public void FetchDoctorList() { DataSet dsDoctor; System.Data.SqlClient.SqlCommand cmdSelect = new System.Data.SqlClient.SqlCommand(); gClass.MakeStoreProcedureName(ref cmdSelect, "sp_Doctors_LoadData", false); cmdSelect.Parameters.Add("@OrganizationCode", System.Data.SqlDbType.Int).Value = Convert.ToInt32(gClass.OrganizationCode); if (this.blnIsSurgeon.HasValue) { cmdSelect.Parameters.Add("@vblnIsSurgeon", System.Data.SqlDbType.Bit).Value = this.blnIsSurgeon.Value; } if (this.blnIsHide.HasValue) { cmdSelect.Parameters.Add("@vblnIsHide", System.Data.SqlDbType.Bit).Value = this.blnIsHide.Value; } dsDoctor = gClass.FetchData(cmdSelect, "tblSurgon"); for (int Xh = 0; Xh < dsDoctor.Tables["tblSurgon"].Rows.Count; Xh++) { dsDoctor.Tables["tblSurgon"].Rows[Xh]["Doctor_Name"] = dsDoctor.Tables["tblSurgon"].Rows[Xh]["Doctor_Name"].ToString().Replace("`", "'"); } dsDoctor.AcceptChanges(); DoctorsList.DataSource = dsDoctor; DoctorsList.DataMember = "tblSurgon"; DoctorsList.DataValueField = "DoctorID"; DoctorsList.DataTextField = "Doctor_Name"; try { DoctorsList.DataBind(); }catch { } DoctorsList.Items.Insert(0, new ListItem("Select ...", "0")); return; }
public void AddDoctor(string name, string surname) { if (!ContainsDoctor(name)) { var doctor = new Doctor(name, surname); DoctorsList.Add(doctor); } }
/// <summary> /// Accepts Doctors object, batch delete row(s) from Doctors table /// /// return docID of deleted row(s) /// </summary> /// <param name="Doctors">Doctors object</param> /// <param name="sqlCmd">SqlCommand object</param> /// <returns>docID of deleted row(s)</returns> public static int Delete(DoctorsList objDoctorsList, SqlCommand sqlCmd) { try { foreach (Doctors item in objDoctorsList) { Delete(item, sqlCmd); } return(objDoctorsList.Count); } catch (Exception ex) { throw ex; } }
public void RemoveDr() { String text = "Do You Want To Remove " + ListSelectedDoctor.Value + " ?"; DialogResult answer = System.Windows.Forms.MessageBox.Show(text, "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (answer == DialogResult.Yes) { DoctorsComboBox.Add(new ComboBoxPairs(ListSelectedDoctor.Key, ListSelectedDoctor.Value)); Hospital.Patients[PatientID].removeDoctor(ListSelectedDoctor.Key); ((Doctor)Hospital.Employees[ListSelectedDoctor.Key]).Patients.Remove(PatientID); HospitalDB.DeleteDoctorPatient(ListSelectedDoctor.Key, PatientID); DoctorsList.Remove(ListSelectedDoctor); DoctorsNumber = "Doctors: " + Hospital.Patients[PatientID].Doctors.Count().ToString(); } }
public void AssignDoctor() { DoctorsList.Add(new ComboBoxPairs(DoctorComboBox.Key, DoctorComboBox.Value)); foreach (Doctor doctor in Hospital.Employees.Values) { if (doctor.ID == DoctorComboBox.Key) { Hospital.Patients[PatientID].Doctors.Add(doctor.ID, doctor); HospitalDB.InsertDoctorPatient(doctor.ID, PatientID); DoctorsNumber = "Doctors: " + Hospital.Patients[PatientID].Doctors.Count().ToString(); break; } } ((Doctor)Hospital.Employees[DoctorComboBox.Key]).Patients.Add(PatientID, Hospital.Patients[PatientID]); DoctorsComboBox.Remove(DoctorComboBox); Home.ViewModel.CloseRootDialog(); }
/// <summary> /// Accepts Doctors object, batch delete row(s) from Doctors table /// /// return docID of deleted row(s) /// </summary> /// <param name="Doctors">Doctors object</param> /// <returns>docID of deleted row(s)</returns> public static int Delete(DoctorsList objDoctorsList) { SqlCommand sqlCmd = new SqlCommand(Doctors_Delete, SqlHelper.DefaultSqlConnection); try { sqlCmd.Connection.Open(); sqlCmd.Transaction = sqlCmd.Connection.BeginTransaction(); Delete(objDoctorsList, sqlCmd); sqlCmd.Transaction.Commit(); return(objDoctorsList.Count); } catch (Exception ex) { sqlCmd.Transaction.Rollback(); throw ex; } finally { sqlCmd.Connection.Close(); } }
//Submit Add Form protected void AddDoctorButton_Click(object sender, EventArgs e) { Button btn = (Button)sender; String btnId = btn.ID; if (btnId.Equals("AddDoctorButton")) { if (IsValid) { System.Threading.Thread.Sleep(3000); var name = NameTextBox.Text; var gender = GenderRadioButtonList1.SelectedItem.Value; var genderId = long.Parse(gender); var dob = Convert.ToDateTime(DOBTextBox.Text); var address = AddressTextBox.Text; var license = LicenseTextBox.Text; var doctor = new Doctor() { doctorName = name, genderId = genderId, dob = dob, address = address, license = license }; _dataContext.Doctors.InsertOnSubmit(doctor); _dataContext.SubmitChanges(); DoctorsList.DataBind(); ResetInputField(); //Use For checking Data //Debug.WriteLine("name: " + name); //Debug.WriteLine("gender: " + gender); //Debug.WriteLine("dob: " + dob); //Debug.WriteLine("address: " + address); //Debug.WriteLine("license: " + license); } else if (btnId.Equals("ResetDoctorButton")) { ResetInputField(); } } }
/// <summary> /// Accepts DoctorsList object, batch updated row(s) into Doctors table /// /// return docID of updated row(s) /// </summary> /// <param name="Doctors">Doctors object</param> /// <param name="sqlCmd">SqlCommand object</param> /// <returns>docID of updated row(s)</returns> public static int Update(DoctorsList objDoctorsList, SqlCommand sqlCmd) { try { foreach (Doctors item in objDoctorsList) { if (item.docID == 0) { item.docID = Insert(item, sqlCmd); } else if (item.docID > 0) { Update(item, sqlCmd); } else { throw new InvalidOperationException("Doctors object was not in specified format"); } } return(objDoctorsList.Count); } catch (Exception ex) { throw ex; } }
public Doctor GetDoctorInList(string doctorName) { return(DoctorsList.FirstOrDefault(x => x.Fullname == doctorName)); }
public bool ContainsDoctor(string doctorName) { return(DoctorsList.Any(x => x.Name == doctorName)); }