private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Please insert Vendor Name"); } else if (numericUpDown1.Value == 0) { MessageBox.Show("Please insert quantity"); } else { DataSet ds = new DataSet(); ds = _sqlSetup.GetData("select Name from Vendor where Name = '" + textBox1.Text + "'", false, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { string cmd; if (textBox2.Text == "") { cmd = "insert into MedicineReceived(idMedicine, RecvdDate, ExpiryDate, QtyRcvd, idVendor) values" + "(" + InventoryView.SetID + ", '" + dateTimePicker2.Value.ToShortDateString() + "', '" + dateTimePicker1.Value.ToShortDateString() + "', " + numericUpDown1.Value + ",(Select idVendor from Vendor where Name like '" + textBox1.Text + "'))"; } else { cmd = "insert into MedicineReceived(idMedicine, RecvdDate, ExpiryDate, Comments, QtyRcvd, idVendor) values" + "(" + InventoryView.SetID + ",'" + dateTimePicker2.Value.ToShortDateString() + "', '" + dateTimePicker1.Value.ToShortDateString() + "', '" + textBox2.Text + "', " + numericUpDown1.Value + ",(Select idVendor from Vendor where Name like '" + textBox1.Text + "'))"; } int insert = _sqlSetup.SetData(cmd, false, null); int update = _sqlSetup.SetData("Update Medicine Set Quantity = Quantity + ((Select PcsPerPack from Medicine where idMedicine = " + InventoryView.SetID + ") * " + numericUpDown1.Value + " ) where idMedicine = " + InventoryView.SetID + " ", false, null); MessageBox.Show("Stock Updated."); this.RefreshDgv(); this.Close(); } else { MessageBox.Show("The vendor does not exist."); } } } }
private void button1_Click_1(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Please insert vendor's name."); } else { DataSet ds = new DataSet(); ds = _sqlSetup.GetData("select Name from Vendor where Name = '" + textBox1.Text + "'", false, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show("This vendor already exists."); } else { int insert = _sqlSetup.SetData("Insert into Vendor(idVendor, Name) values " + "((Select Top 1 idVendor from Vendor order by idVendor desc) +1,'" + textBox1.Text + "')", false, null); MessageBox.Show("Vendor Added."); this.Close(); AddMedicineStock fm = new AddMedicineStock(); fm.Show(); } } } }
private void button1_Click_1(object sender, EventArgs e) { DataSet ds = new DataSet(); ds = _sqlSetup.GetData("select Name from Medicine where Name like '" + textBox4.Text + "'", false, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { if (numericUpDown1.Value == 0) { MessageBox.Show("The Quantity must be greater than 0"); } else { DataSet ds1 = new DataSet(); ds1 = _sqlSetup.GetData("Select * from Appointment_has_Medicine", false, null); if (ds1 != null) { if (ds1.Tables[0].Rows.Count > 0) { int insert = _sqlSetup.SetData("Insert into Appointment_has_Medicine(idAppMed, idMedicine,idAppointment, QtyIssued, Date) values " + "((Select Top 1 idAppMed from Appointment_has_Medicine order by idAppMed desc) +1,(select idMedicine from Medicine where Name like '" + textBox4.Text + "' and Type = (Select idType from Type where Name like '" + comboBox1.Text + "')), (Select idAppointment from Appointment where idAppointment = " + ConsultationForm.appt.ToString() + " and Date = '" + ConsultationForm.date + "'), " + numericUpDown1.Value + ", (Select Date from Appointment where idAppointment = " + ConsultationForm.appt.ToString() + " and Date = '" + ConsultationForm.date + "'))", false, null); } else { int insert = _sqlSetup.SetData("Insert into Appointment_has_Medicine(idAppMed, idMedicine, idAppointment, QtyIssued, Date) values(1, (select idMedicine from Medicine where Name like '" + textBox4.Text + "' and Type = (Select idType from Type where Name like '" + comboBox1.Text + "')), (Select idAppointment from Appointment where idAppointment = " + ConsultationForm.appt.ToString() + " and Date = '" + ConsultationForm.date + "'), " + numericUpDown1.Value + ", (Select Date from Appointment where idAppointment = " + ConsultationForm.appt.ToString() + " and Date = '" + ConsultationForm.date + "'))", false, null); MessageBox.Show("Dosage Added"); } } } } else { MessageBox.Show("Please enter a valid medicine from the options available"); } } DisplayData(); }
private void button1_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dataGridView1.Rows) { AppMed = Convert.ToInt32(row.Cells[1].Value.ToString()); bool isSelected = Convert.ToBoolean(row.Cells[0].Value); DataSet ds = new DataSet(); ds = _sqlSetup.GetData("Select * from Appointment_has_Medicine where idAppMed = " + AppMed + " and issued = 1", false, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show(row.Cells[2].Value.ToString() + " has already been issued."); } else if (isSelected && ds.Tables[0].Rows.Count == 0) { DataSet ds2 = new DataSet(); ds2 = _sqlSetup.GetData("Select * from Medicine where Name like '" + row.Cells[2].Value.ToString() + "'and Quantity -" + Convert.ToInt32(row.Cells[3].Value.ToString()) + "> 0", false, null); if (ds2 != null) { if (ds2.Tables[0].Rows.Count > 0) { int update = _sqlSetup.SetData("Update Medicine Set Quantity = Quantity -" + Convert.ToInt32(row.Cells[3].Value.ToString()) + " where idMedicine = (Select idMedicine from Medicine where Name like '" + row.Cells[2].Value.ToString() + "')", false, null); int update2 = _sqlSetup.SetData("Update Appointment_has_Medicine Set issued = 1 where idAppMed = " + AppMed + "", false, null); MessageBox.Show("Medicine has been issued."); this.Close(); } else { MessageBox.Show("Not enough quantity in stock for " + dataGridView1.CurrentRow.Cells[2].Value.ToString()); } } } } } }
private void button1_Click(object sender, EventArgs e) { double pv; if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "" || textBox7.Text == "" || textBox8.Text == "") { MessageBox.Show("Invalid! Please enter all the information to proceed."); } else { if (!(Double.TryParse(textBox4.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv)) || !(Double.TryParse(textBox6.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv)) || !(Double.TryParse(textBox5.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv))) { MessageBox.Show("Phone Number , CNIC, and age must only be integer values."); } else { if (!(textBox5.TextLength == 11)) { MessageBox.Show("Phone No. must be 11 digits."); } else { if (!(textBox4.TextLength == 13)) { MessageBox.Show("CNIC must be 13 digits."); } else if (textBox4.TextLength == 13) { DataSet ds = new DataSet(); ds = _sqlSetup.GetData("select Name from City where Name = '" + textBox7.Text + "'", false, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { int update = _sqlSetup.SetData("Update Patient set idCity = (select idCity from City where Name like '" + textBox7.Text + "'), FatherOrHusband = '" + textBox3.Text + "', Age = " + Convert.ToInt32(textBox6.Text) + ", CNIC = '" + textBox4.Text + "', Address = '" + textBox8.Text + "', Cell_No = '" + textBox5.Text + "' where Patient.Name = '" + textBox2.Text + "' and Patient.MR_No = " + Convert.ToInt32(textBox1.Text), false, null); MessageBox.Show("Patient details updated! Please click the Close button to exit."); } else { MessageBox.Show("Please enter a valid city from the options available"); } } } } } } }
private void button1_Click(object sender, EventArgs e) { double pv; //when no details are mentioned and save is pressed if (comboBox1.Text == "" && comboBox2.Text == "" && textBox9.Text == "" && textBox8.Text == "" && textBox7.Text == "" && textBox6.Text == "" && textBox5.Text == "" && textBox1.Text == "" && textBox4.Text == "") { MessageBox.Show("Please enter details to proceed."); } //when only vitals are being filled out else if (textBox1.Text == "" && textBox4.Text == "") { if (Double.TryParse(comboBox1.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv) && Double.TryParse(textBox9.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv) && Double.TryParse(textBox8.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv)) { int update = _sqlSetup.SetData("Update Appointment set Heightf = " + Convert.ToDouble(comboBox1.Text) + ", Heighti = " + Convert.ToDouble(comboBox2.Text) + ", Weight = " + Convert.ToDouble(textBox9.Text) + ", Temp = " + Convert.ToDouble(textBox8.Text) + ", BP = '" + textBox7.Text + "', Pulse = '" + textBox6.Text + "', RespRate = '" + textBox5.Text + "' where idDoctors in (select idDoctors from Doctors where Name like '" + ConsultationForm.doc + "') and MR_No = " + DoctorView.MR.ToString() + " and Date = '" + ConsultationForm.date + "' and idAppointment = " + ConsultationForm.appt.ToString(), false, null); MessageBox.Show("Changes saved!"); } else { MessageBox.Show("Height, Weight and Temp must be numbers"); } } //when consulting doctors enters all data else { if (Double.TryParse(comboBox1.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv) && Double.TryParse(textBox9.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv) && Double.TryParse(textBox8.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv)) { int update2 = _sqlSetup.SetData("Update Appointment set Investigation = '" + textBox4.Text + "', PresentComplaints = '" + textBox1.Text + "', Heightf = " + Convert.ToDouble(comboBox1.Text) + ", Heighti = " + Convert.ToDouble(comboBox2.Text) + ", Weight = " + Convert.ToDouble(textBox9.Text) + ", Temp = " + Convert.ToDouble(textBox8.Text) + ", BP = '" + textBox7.Text + "', Pulse = '" + textBox6.Text + "', RespRate = '" + textBox5.Text + "' where idDoctors in (select idDoctors from Doctors where Name like '" + ConsultationForm.doc + "') and MR_No = " + DoctorView.MR.ToString() + " and Date = '" + ConsultationForm.date + "' and idAppointment = " + ConsultationForm.appt.ToString(), false, null); MessageBox.Show("Changes saved!"); } else { MessageBox.Show("Height, Weight and Temp must be numbers"); } } }
private void button4_Click(object sender, EventArgs e) { SetID = dataGridView1.CurrentRow.Cells[0].Value.ToString(); int insert = _sqlSetup.SetData("Begin Transaction Delete from MedicineReceived where idMedicine = " + SetID + " Delete from Appointment_has_Medicine where idMedicine = " + SetID + " Delete from Medicine where idMedicine = " + SetID + " Commit", false, null); MessageBox.Show("Medicine Deleted"); DataSet ds = new DataSet(); ds = _sqlSetup.GetData("Select idMedicine, Medicine.Name as 'Medicine', Quantity, Type.Name AS 'Type' from Medicine join Type on Medicine.Type = Type.idType Where Medicine.Name like '" + textBox1.Text + "%'", false, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { dataGridView1.DataSource = ds.Tables[0]; } } }
private void button1_Click(object sender, EventArgs e) { double pv; if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "" || textBox7.Text == "" || (radioButton1.Checked == false && radioButton2.Checked == false)) { MessageBox.Show("Invalid! Please enter all the information to proceed."); } else { if (Double.TryParse(textBox3.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv) && Double.TryParse(textBox4.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv) && Double.TryParse(textBox6.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv) && textBox4.TextLength == 11 && textBox3.TextLength == 13) { DataSet ds = new DataSet(); ds = _sqlSetup.GetData("select Name from City where Name = '" + textBox7.Text + "'", false, null); if (ds != null) { if (!(ds.Tables[0].Rows.Count > 0)) { MessageBox.Show("Please enter a valid city from the options available"); } else { DataSet ds2 = new DataSet(); ds2 = _sqlSetup.GetData("Select top 1 MR_No from Patient", false, null); if (ds2 != null) { if (!(ds2.Tables[0].Rows.Count > 0)) { int insert = _sqlSetup.SetData("Set Identity_insert Patient ON insert into Patient (MR_No, idCity, Name, FatherOrHusband, Age, CNIC, Address, Cell_No) values (" + "1, (select idCity from City where Name like '" + textBox7.Text + "'), '" + textBox1.Text + "', '" + textBox2.Text + "', " + Convert.ToInt32(textBox6.Text) + ", '" + textBox3.Text + "', '" + textBox5.Text + "', '" + textBox4.Text + "')", false, null); } else { int insert = _sqlSetup.SetData("Set Identity_insert Patient ON insert into Patient (MR_No, idCity, Name, FatherOrHusband, Age, CNIC, Address, Cell_No) values (" + "(Select top 1 MR_No from Patient order by MR_No desc) + 1, (select idCity from City where Name like '" + textBox7.Text + "'), '" + textBox1.Text + "', '" + textBox2.Text + "', " + Convert.ToInt32(textBox6.Text) + ", '" + textBox3.Text + "', '" + textBox5.Text + "', '" + textBox4.Text + "')", false, null); } } DataSet ds4 = new DataSet(); ds4 = _sqlSetup.GetData("Select top 1 idAppointment from Appointment where Date = '" + dateTimePicker2.Value.Date + "' order by idAppointment desc", false, null); if (ds4 != null) { if (ds4.Tables[0].Rows.Count > 0) //if an appointment exists for that date { DataSet ds6 = new DataSet(); ds6 = _sqlSetup.GetData("select Name from Doctors where Name = '" + textBox8.Text + "'", false, null); if (ds6 != null) { if (ds6.Tables[0].Rows.Count > 0) //if the doctor is correct { if (radioButton1.Checked == true) //if it is a consultation { int insert4 = _sqlSetup.SetData("insert into Appointment (idAppointment, idDoctors, MR_No, Date, Time, isSurgery) values " + "((Select top 1 idAppointment from Appointment where Date = '" + dateTimePicker2.Value.Date + "'order by idAppointment desc) +1," + " (select idDoctors from Doctors where Name like '" + textBox8.Text + "'), (select TOP 1 MR_No from Patient order by MR_No desc), '" + dateTimePicker2.Value.Date + "', '" + dateTimePicker3.Value.ToLongTimeString() + "', 0)", false, null); MessageBox.Show("Patient added and Appointment Scheduled!"); this.Close(); } else if (radioButton2.Checked == true) { int insert4 = _sqlSetup.SetData("insert into Appointment (idAppointment, idDoctors, MR_No, Date, Time, isSurgery) values " + "((Select top 1 idAppointment from Appointment where Date = '" + dateTimePicker2.Value.Date + "'order by idAppointment desc) +1," + " (select idDoctors from Doctors where Name like '" + textBox8.Text + "'), (select TOP 1 MR_No from Patient order by MR_No desc), '" + dateTimePicker2.Value.Date + "', '" + dateTimePicker3.Value.ToLongTimeString() + "', 1)", false, null); MessageBox.Show("Patient added and Appointment Scheduled!"); this.Close(); } } else { MessageBox.Show("Please enter a valid doctor from the options available"); } } } else { DataSet ds5 = new DataSet(); ds5 = _sqlSetup.GetData("select Name from Doctors where Name = '" + textBox8.Text + "'", false, null); if (ds5 != null) { if (ds5.Tables[0].Rows.Count > 0) { if (radioButton1.Checked == true) { int insert3 = _sqlSetup.SetData("insert into Appointment (idAppointment, idDoctors, MR_No, Date, Time, isSurgery) values (1, (select idDoctors from Doctors where Name like '" + textBox8.Text + "'), (select TOP 1 MR_No from Patient order by MR_No desc), '" + dateTimePicker2.Value.Date + "', '" + dateTimePicker3.Value.ToLongTimeString() + "', 0)", false, null); MessageBox.Show("Patient added and Appointment Scheduled!"); this.Close(); } else if (radioButton2.Checked == true) { int insert3 = _sqlSetup.SetData("insert into Appointment (idAppointment, idDoctors, MR_No, Date, Time, isSurgery) values (1, (select idDoctors from Doctors where Name like '" + textBox8.Text + "'), (select TOP 1 MR_No from Patient order by MR_No desc), '" + dateTimePicker2.Value.Date + "', '" + dateTimePicker3.Value.ToLongTimeString() + "', 1)", false, null); MessageBox.Show("Patient added and Appointment Scheduled!"); this.Close(); } } else { MessageBox.Show("Please enter a valid doctor from the options available"); } } } } } } } else { MessageBox.Show("CNIC must have 13 digits, Phone Number must have 11 digits. Age, CNIC and Phone Number must only be numeric."); } } }
private void Reg_Click_1(object sender, EventArgs e) { if (uname.Text == "" || pass.Text == "" || cpass.Text == "") { MessageBox.Show("Incomplete Information!"); } else if (pass.Text.Length < 8) { MessageBox.Show("Password needs more characters"); } else if (pass.Text != cpass.Text) { MessageBox.Show("Passwords don't match"); } else { DataSet ds = new DataSet(); ds = _sqlSetup.GetData("select username from Users where username ='******'", false, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show("A user already exists with these credentials. Please enter a different username and password."); } else { string command; if (radioButton1.Checked == true) { command = "Insert into dbo.Users(username,pw,isDoctor,isReceptionist,isPharmacist,isAdmin) " + "values( '" + uname.Text + "', '" + pass.Text + "', 0,0,1,0)"; int update = _sqlSetup.SetData(command, false, null); MessageBox.Show("User Details Added!"); this.Close(); } else if (radioButton2.Checked == true) { command = "Insert into dbo.Users(username,pw,isDoctor,isReceptionist,isPharmacist,isAdmin) " + "values( '" + uname.Text + "', '" + pass.Text + "', 0,1,0,0)"; int update = _sqlSetup.SetData(command, false, null); MessageBox.Show("User Details Added!"); this.Close(); } else if (radioButton3.Checked == true) { command = "Insert into dbo.Users(username,pw,isDoctor,isReceptionist,isPharmacist,isAdmin) " + "values( '" + uname.Text + "', '" + pass.Text + "', 0,0,0,1)"; int update = _sqlSetup.SetData(command, false, null); MessageBox.Show("User Details Added!"); this.Close(); } else if (radioButton4.Checked == true) { command = "Insert into dbo.Users(username,pw,isDoctor,isReceptionist,isPharmacist,isAdmin) " + "values( '" + uname.Text + "', '" + pass.Text + "', 1,0,0,0)"; int add = _sqlSetup.SetData("Insert into dbo.Doctors(Name) values('" + uname.Text + "')", false, null); int update = _sqlSetup.SetData(command, false, null); MessageBox.Show("User Details Added!"); this.Close(); } else { MessageBox.Show("Please select your position!"); } } } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("Invalid! Please enter all the information to proceed."); } else { if (textBox3.Enabled == true && textBox3.Text == "") { MessageBox.Show("Invalid! Please enter all the information to proceed."); } else { double pv; if (textBox3.Enabled == true && !(Double.TryParse(textBox3.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.CurrentCulture, out pv))) { MessageBox.Show("Quantity has to be an integer only."); } else { DataSet ds = new DataSet(); ds = _sqlSetup.GetData("Select * from Medicine where Name like '" + textBox1.Text + "' and Type = (Select idType from Type " + "where Name like '" + comboBox1.Text + "')", false, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show("This medicine already exists."); } } else { if (textBox3.Text == "") { int insert = _sqlSetup.SetData("Set Identity_insert Medicine ON Insert into Medicine(idMedicine, Name, GenericChemName, Quantity, PcsPerPack, Type) values (((Select Top 1 idMedicine from Medicine order by idMedicine desc)+1), '" + textBox1.Text + "', '" + textBox2.Text + "' , 0 , 0 , (Select idType from Type where Name like '" + comboBox1.Text + "')) ", false, null); MessageBox.Show("Medicine Added."); this.Close(); InventoryView newfrm = new InventoryView(); newfrm.Show(); } else { int insert = _sqlSetup.SetData("Set Identity_insert Medicine ON Insert into Medicine(idMedicine, Name, GenericChemName, Quantity, PcsPerPack, Type) values (((Select Top 1 idMedicine from Medicine order by idMedicine desc)+1), '" + textBox1.Text + "', '" + textBox2.Text + "' , 0 , '" + textBox3.Text + "' , (Select idType from Type where Name like '" + comboBox1.Text + "')) ", false, null); MessageBox.Show("Medicine Added."); this.Close(); InventoryView newfrm = new InventoryView(); newfrm.Show(); } } } } } }
private void button1_Click(object sender, EventArgs e) { if (textBox3.Text == "" || (radioButton1.Checked == false && radioButton2.Checked == false)) { MessageBox.Show("Invalid! Please enter all the information to proceed."); } else { DataSet ds = new DataSet(); ds = _sqlSetup.GetData("Select top 1 idAppointment from Appointment where Date = '" + dateTimePicker1.Value.Date + "' order by idAppointment desc", false, null); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataSet ds1 = new DataSet(); ds1 = _sqlSetup.GetData("select Name from Doctors where Name = '" + textBox3.Text + "'", false, null); if (ds1 != null) { if (ds1.Tables[0].Rows.Count > 0) { if (radioButton1.Checked == true) { int insert = _sqlSetup.SetData("insert into Appointment (idAppointment, idDoctors, MR_No, Date, Time, " + "isSurgery) values ((Select top 1 idAppointment from Appointment where Date = '" + dateTimePicker1.Value.Date + "' order by idAppointment desc) +1 , " + "(select idDoctors from Doctors where Name like '" + textBox3.Text + "'), " + "(select MR_No from Patient where MR_No = " + Convert.ToInt32(textBox2.Text) + "),'" + dateTimePicker1.Value.Date + "','" + dateTimePicker2.Value.ToLongTimeString() + "', 0)", false, null); MessageBox.Show("Appointment Scheduled!"); this.Close(); } else if (radioButton2.Checked == true) { int insert = _sqlSetup.SetData("insert into Appointment (idAppointment, idDoctors, MR_No, Date, Time, " + "isSurgery) values ((Select top 1 idAppointment from Appointment where Date = '" + dateTimePicker1.Value.Date + "' order by idAppointment desc) +1 , " + "(select idDoctors from Doctors where Name like '" + textBox3.Text + "'), " + "(select MR_No from Patient where MR_No = " + Convert.ToInt32(textBox2.Text) + "),'" + dateTimePicker1.Value.Date + "','" + dateTimePicker2.Value.ToLongTimeString() + "', 1)", false, null); MessageBox.Show("Appointment Scheduled!"); this.Close(); } } else { MessageBox.Show("Please enter a valid doctor from the options available"); } } } else { DataSet ds2 = new DataSet(); ds2 = _sqlSetup.GetData("select Name from Doctors where Name = '" + textBox3.Text + "' ", false, null); if (ds2 != null) { if (ds2.Tables[0].Rows.Count > 0) { if (radioButton1.Checked == true) { int insert = _sqlSetup.SetData("insert into Appointment (idAppointment, idDoctors, MR_No, Date, Time, " + "isSurgery) values (1, (select idDoctors from Doctors where Name like '" + textBox3.Text + "'), " + "(select MR_No from Patient where MR_No = " + Convert.ToInt32(textBox2.Text) + "),'" + dateTimePicker1.Value.Date + "','" + dateTimePicker2.Value.ToLongTimeString() + "', 0)", false, null); MessageBox.Show("Appointment Scheduled!"); this.Close(); } else if (radioButton2.Checked == true) { int insert = _sqlSetup.SetData("insert into Appointment (idAppointment, idDoctors, MR_No, Date, Time, " + "isSurgery) values (1, (select idDoctors from Doctors where Name like '" + textBox3.Text + "'), " + "(select MR_No from Patient where MR_No = " + Convert.ToInt32(textBox2.Text) + "), '" + dateTimePicker1.Value.Date + "','" + dateTimePicker2.Value.ToLongTimeString() + "', 1)", false, null); MessageBox.Show("Appointment Scheduled!"); this.Close(); } } else { MessageBox.Show("Please enter a valid doctor from the options available"); } } } } } }