private void Save_Click(object sender, EventArgs e) { //var Medicine = db.MedicineInfos.SingleOrDefault(u => u.Medicine_Name == textBox1.Text); if (textBox6.Text != "") { //int mid = Convert.ToInt32(textBox6.Text); //var Medicine_Id = db.MedicineInfos.Select(u => u.Medicine_Id); //if (Medicine_Id == null) //{ // MessageBox.Show("This Id Already Added!'Medicine Id Must be Unique'"); //} try { string Medicine_Name, Medicine_Catagory, Dosage, Manufacturer; int Medicine_Available; DateTime Entry_Date; DateTime Production_Date; DateTime Expire_Date; int Buying_Price; int Selling_Price; int Medicine_Id; Medicine_Name = textBox1.Text; Medicine_Catagory = textBox2.Text; Dosage = textBox7.Text; Manufacturer = comboBox1.Text; Medicine_Available = Convert.ToInt32(textBox8.Text); Entry_Date = Convert.ToDateTime(dateTimePicker1.Text); Production_Date = Convert.ToDateTime(dateTimePicker2.Text); Expire_Date = Convert.ToDateTime(dateTimePicker3.Text); Buying_Price = Convert.ToInt32(textBox4.Text); Selling_Price = Convert.ToInt32(textBox5.Text); Medicine_Id = Convert.ToInt32(textBox6.Text); MedicineData.InsertPermacyData(Medicine_Name, Medicine_Catagory, Dosage, Manufacturer, Medicine_Available, Entry_Date, Production_Date, Expire_Date, Buying_Price, Selling_Price, Medicine_Id); MessageBox.Show("Medicine Added Successfully"); this.Hide(); } catch (Exception) { MessageBox.Show("please fill all information"); } } else { MessageBox.Show("Medicine Id Must Needed"); } }