DatetimePicker taking arbitary time

private void checkBox_UpdateDateofPurchase_CheckedChanged ( object sender, EventArgs e )
            {
            if (label6.Text != string.Empty)
                {
                    int lot;
                    if (Int32.TryParse(textBox_lotNo.Text, out lot))
                    {
                        decimal price;
                        if (decimal.TryParse(textBox1.Text, out price))
                        {

                            //string previousNameofItem;
                            //previousNameofItem = label6.Text;
                            //DateTime DateOfPurchase;
                            //DateOfPurchase = dateTimePicker_DateOfPurchase.Value;
                            string NameofItem;
                            NameofItem = textBox_FilmName.Text;
                            Int32 Dealer_ID;
                            Dealer_ID = Convert.ToInt32(textBox_DealerID.Text);
                            string DateOfPurchase;
                            DateOfPurchase = dateTimePicker_DateOfPurchase.Value.ToString();
                            string Typefilm;
                            Typefilm = comboBox_Type.SelectedValue != null ? comboBox_Type.SelectedValue.ToString() : comboBox_Type.Text;

                            //Typefilm = comboBox_Type.SelectedValue.ToString();
                            string Language1;
                            Language1 = comboBox_Language.SelectedItem != null ? comboBox_Language.SelectedValue.ToString() : comboBox_Language.Text;
                            string YearOFRease;
                            YearOFRease = comboBox_YearOfRelease.SelectedValue != null ? comboBox_YearOfRelease.SelectedValue.ToString() : comboBox_YearOfRelease.Text;
                            string FilmCategory;
                            FilmCategory = comboBox_FilmCategory.SelectedValue != null ? comboBox_FilmCategory.SelectedValue.ToString() : comboBox_FilmCategory.Text;
                            string Actors_Name;
                            Actors_Name = textBox_ActorNames.Text;
                            string Actress_Name;
                            Actress_Name = textBox_ActressName.Text;
                            string Producer_Name;
                            Producer_Name = textBox_ProducerName.Text;
                            string Director_Name;
                            Director_Name = textBox_directorName.Text;
                            string StoryWriter_Name;
                            StoryWriter_Name = textBox_StoryWriterName.Text;
                            string ScriptWriter_Name;
                            ScriptWriter_Name = textBox_ScriptwriterName.Text;
                            decimal Price;
                            Price = Convert.ToDecimal(textBox1.Text);
                            Int32 lotNo;
                            lotNo = Convert.ToInt32(textBox_lotNo.Text);

                            Update_DateOfPurchase(NameofItem,DateOfPurchase, Dealer_ID, Typefilm, Language1, YearOFRease, FilmCategory, Actors_Name, Actress_Name, Producer_Name, Director_Name, StoryWriter_Name, ScriptWriter_Name, Price, lotNo);
                            Show_Distinct_Film_Name();
                        }
                        else
                        {
                            MessageBox.Show("Please enter a valid Price of the Item", "Price is requiered", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        }
                    }
                    else
                    {
                        MessageBox.Show("PLease enter a valid Lot no of the Item", "Lot no is required", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    }
                }
            else
                {
                MessageBox.Show ( "Please select a Film/Music Album Name which you want to Edit/Update", "Click on the Film/Music Album Name", MessageBoxButtons.OK, MessageBoxIcon.Error );
                }

            }

        private void Update_DateOfPurchase(string NameofItem,string DateOfPurchase, int Dealer_ID, string Typefilm, string Language1, string YearOFRease, string FilmCategory, string Actors_Name, string Actress_Name, string Producer_Name, string Director_Name, string StoryWriter_Name, string ScriptWriter_Name, decimal Price, int lotNo)
        {
            using (SqlConnection con = new SqlConnection(connectionstring.Connection))
            {//update Table_FilmDetail set Dealer_ID=@parameter1 where NameofItem=@parameter2  and Typefilm=@paramTypefilm and Language1=@paramLanguage1 and YearOFRease=@paramYearOFRease and FilmCategory=@paramFilmCategory and Actors_Name=@paramActors_Name and Producer_Name=@paramProducer_Name and Director_Name=@paramDirector_Name and StoryWriter_Name=@paramStoryWriter_Name and ScriptWriter_Name=@paramScriptWriter_Name and Price=@paramPrice and lotNo=@paramlotNo
                string query = "update Table_FilmDetail set DateOfPurchase=@paramDateOfPurchase  where NameofItem=@parameter2 and Dealer_ID=@parameter1  and Typefilm=@paramTypefilm and Language1=@paramLanguage1 and YearOFRease=@paramYearOFRease and FilmCategory=@paramFilmCategory and Actors_Name=@paramActors_Name and Producer_Name=@paramProducer_Name and Director_Name=@paramDirector_Name and StoryWriter_Name=@paramStoryWriter_Name and ScriptWriter_Name=@paramScriptWriter_Name and Price=@paramPrice and lotNo=@paramlotNo";
                using (SqlCommand cmd = new SqlCommand(query, con))
                {
                    cmd.Parameters.AddWithValue("@parameter1", Dealer_ID);
                    cmd.Parameters.AddWithValue("@parameter2", NameofItem);
                    cmd.Parameters.AddWithValue("@paramDateOfPurchase", DateOfPurchase);
                    cmd.Parameters.AddWithValue("@paramTypefilm", Typefilm);
                    cmd.Parameters.AddWithValue("@paramLanguage1", Language1);
                    cmd.Parameters.AddWithValue("@paramYearOFRease", YearOFRease);
                    cmd.Parameters.AddWithValue("@paramFilmCategory", FilmCategory);
                    cmd.Parameters.AddWithValue("@paramActors_Name", Actors_Name);
                    cmd.Parameters.AddWithValue("@paramProducer_Name", Producer_Name);
                    cmd.Parameters.AddWithValue("@paramDirector_Name", Director_Name);
                    cmd.Parameters.AddWithValue("@paramStoryWriter_Name", StoryWriter_Name);
                    cmd.Parameters.AddWithValue("@paramScriptWriter_Name", ScriptWriter_Name);
                    cmd.Parameters.AddWithValue("@paramPrice", Price);
                    cmd.Parameters.AddWithValue("@paramlotNo", lotNo);
                    con.Open();
                    SqlDataReader reader = cmd.ExecuteReader();
                    MessageBox.Show("Updated");
                }
            }
        }

Select allOpen in new window