public void Doctor_Update_UpdateDoctorInfo()
{
Doctor doctor = new Doctor("John", "john567", "567", "Physician");
doctor.Save();
doctor.Update("Tom", "tom567", "123", "Cardiology");
Doctor controlDoctor = new Doctor("Tom", "tom567", "123", "Cardiology", doctor.Id);
Assert.Equal(controlDoctor, doctor);
}
private void ultraBtnSave_Click(object sender, EventArgs e)
{
objHospitalDB = new MyCompany.MyProject.Db.HospitalDB();
Doctor objDoctor = new Doctor(objHospitalDB);
DoctorRow objDoctorRow = new MyCompany.MyProject.Db.DoctorRow();
objDoctorRow.FullName = ultraTextFullName.Text;
objDoctorRow.Phone = ultraTextPhoneNumber.Text;
objDoctorRow.Doc_Address = ultraTextAddress.Text;
if (strFormMode == "NEW")
{
objDoctor.Insert(objDoctorRow);
}
else if (strFormMode == "EDIT")
{
objDoctorRow.Doctor_ID = Convert.ToInt32(ultraTextEditorID.Text);
}
objDoctor.Update(objDoctorRow);
//string query = "insert into Doctor Values('" + ultraTextFullName.Text + "','" + ultraTextAddress.Text + "','" + ultraTextPhoneNumber.Text + "')";
//SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-89LF16D;Initial Catalog=Hospital;Integrated Security=True");
/* if (strFormMode == "NEW")
* {
* try
* {
*
* objHospitalDB = new HospitalDB();
* string query1 = "insert into Doctor Values('" + ultraTextFullName.Text + "','" + ultraTextAddress.Text + "','" + ultraTextPhoneNumber.Text + "')";
* SqlCommand cmd = objHospitalDB.CreateCommand(query1, false);
* // cmd.Parameters.Add(new SqlParameter("@images", images));
* int p = cmd.ExecuteNonQuery();
*
* MessageBox.Show(p.ToString() + "registerd");
* this.Close();
* }
* catch (Exception ex)
* {
* MessageBox.Show(ex.Message);
* if (objHospitalDB != null)
* {
* objHospitalDB.Dispose();
* }
* }
* }
* else
* {
* try
* {
*
* objHospitalDB = new HospitalDB();
* SqlCommand cmd = objHospitalDB.CreateCommand("update Doctor set FullName='" + ultraTextFullName.Text + "',Doc_Address='" + ultraTextAddress.Text + "',Phone='" + ultraTextPhoneNumber.Text + "' where Doctor_ID= '" + ultraTextEditorID.Text + "'",false);
* int o = cmd.ExecuteNonQuery();
*
* MessageBox.Show(o + ":updated");
* this.Close();
* }
* catch (Exception ex)
* {
* MessageBox.Show(ex.Message);
* if (objHospitalDB != null)
* {
* objHospitalDB.Dispose();
* }
* }
* }*/
}
