private void ultraBtnRefresh_Click(object sender, EventArgs e) { try { objHospitalDB = new HospitalDB(); Doctor objDoctor = new Doctor(objHospitalDB); DoctorRow objDoctorRow = new DoctorRow(); ultraGridDoc.DataSource = objDoctor.GetAll(); /* dsDoctor = new DataSet(); * SqlCommand cmd = objHospitalDB.CreateCommand("Select * from [Hospital].[dbo].[Doctor]", false); * SqlDataAdapter sda = new SqlDataAdapter(); * sda.SelectCommand = cmd; * sda.Fill(dsDoctor); * ultraGridDoc.DataSource = dsDoctor.Tables[0];*/ } catch (Exception ex) { MessageBox.Show(ex.Message); if (objHospitalDB != null) { objHospitalDB.Dispose(); } } }
private void ultraBtnPRefresh_Click(object sender, EventArgs e) { dsPatient = new DataSet(); try { ultraTextPSearch.Text = ""; ultraDateTimePSearch.Value = ""; objHospitalDB = new HospitalDB(); Patient objPatient = new Patient(objHospitalDB); PatientRow objPatientRow = new PatientRow(); dtPatient = objPatient.GetAllAsDataTable(); ultraGridPatient.DataSource = dtPatient; /*SqlCommand cmd = objHospitalDB.CreateCommand("Select * from [Hospital].[dbo].[Patient]", false); * SqlDataAdapter sda = new SqlDataAdapter(); * sda.SelectCommand = cmd; * sda.Fill(dsPatient); * ultraGridPatient.DataSource = dsPatient.Tables[0];*/ } catch (Exception ex) { MessageBox.Show(ex.Message); if (objHospitalDB != null) { objHospitalDB.Dispose(); } } }
private void ultraBtnBDelete_Click(object sender, EventArgs e) { try { objHospitalDB = new HospitalDB(); Bed objBed = new Bed(objHospitalDB); BedRow objBedRow = new BedRow(); objBedRow.Bed_ID = Convert.ToInt32(this.bed_id); objBed.Delete(objBedRow); ultraGridBed.DataSource = objBed.GetAll(); /*ultraGridBed.Rows[this.ultraGridBed.ActiveRow.Index].Delete(true); * SqlCommand query = objHospitalDB.CreateCommand("delete from Bed where Bed_ID='" + this.bed_id + "';", false); * int p = query.ExecuteNonQuery(); * MessageBox.Show(p + "Deleted");*/ } catch (Exception ex) { MessageBox.Show(ex.Message); if (objHospitalDB != null) { objHospitalDB.Dispose(); } } }
private void ultraButtonRefreshBed_Click(object sender, EventArgs e) { dsBedList = new DataSet(); try { objHospitalDB = new HospitalDB(); SqlCommand cmd = objHospitalDB.CreateCommand("select * from BedInfo ", false); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(dsBedList); ultraGridBedList.DataSource = dsBedList.Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.Message); if (objHospitalDB != null) { objHospitalDB.Dispose(); } } //conn.Open(); //ultraGridBedList.Rows.Refresh(Infragistics.Win.UltraWinGrid.RefreshRow.RefreshDisplay); //conn.Close(); }
protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
private void ultraBtnBRefresh_Click(object sender, EventArgs e) { try { objHospitalDB = new HospitalDB(); dsBed = new DataSet(); SqlCommand cmd = objHospitalDB.CreateCommand("Select * from [Hospital].[dbo].[Bed]", false); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(dsBed); ultraGridBed.DataSource = dsBed.Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.Message); if (objHospitalDB != null) { objHospitalDB.Dispose(); } } }
private void ultraBtnVRefresh_Click(object sender, EventArgs e) { ultraTextSearch.Text = ""; ultraDateTimeSearch.Value = ""; try { objHospitalDB = new HospitalDB(); Visit objVisit = new Visit(objHospitalDB); DataTable dtVisit = new DataTable(); dtVisit = objVisit.GetAllAsDataTable(); ultraGridVisit.DataSource = dtVisit; } catch (Exception ex) { MessageBox.Show(ex.Message); if (objHospitalDB != null) { objHospitalDB.Dispose(); } } }
private void ultraButtonRefresh_Click(object sender, EventArgs e) { dsPatientVisit = new DataSet(); try { objHospDB = new HospitalDB(); PatientVisitInfo objPatientVisitInfo = new PatientVisitInfo(objHospDB); dtPatientVisit = objPatientVisitInfo.GetAllAsDataTable(); ultraGridPatientVisit.DataSource = dtPatientVisit; } catch (Exception ex) { MessageBox.Show(ex.Message); if (objHospDB != null) { objHospDB.Dispose(); } } }
private void ultraButtonRefreshPatientVisit_Click(object sender, EventArgs e) { dsPatientVisit = new DataSet(); try { objHospitalDB = new HospitalDB(); SqlCommand cmd = objHospitalDB.CreateCommand("select * from PatientVisitInfo ", false); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(dsPatientList); ultraGridBedList.DataSource = dsPatientList.Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.Message); if (objHospitalDB != null) { objHospitalDB.Dispose(); } } }
private void ultraBtnSave_Click(object sender, EventArgs e) { objHospitalDB = new HospitalDB(); Visit objVisit = new Visit(objHospitalDB); VisitRow objVisitRow = new VisitRow(); objVisitRow.DateOfDischarge = Convert.ToDateTime(ultraCalendarComboDOD.Text); objVisitRow.DateOfVisit = Convert.ToDateTime(ultraCalendarComboDOV.Text); objVisitRow.Disease = ultraTextDisease.Text; objVisitRow.Symptoms = ultraTextSymtoms.Text; objVisitRow.Treatment = ultraTextTreatment.Text; objVisitRow.DoctorID = Convert.ToInt32(ultraComboEditorDoctorID.Text); objVisitRow.BedID = Convert.ToInt32(ultraComboBedID.Text); objVisitRow.PatientID = Convert.ToInt32(ultraComboEditorPatientID.Text); if (strFormMode == "NEW") { try { if (radioBtnInPatient.Checked == true) { objVisitRow.PatientType = radioBtnInPatient.Text; objVisit.Insert(objVisitRow); } else if (radioBtnOutPatient.Checked == true) { objVisitRow.PatientType = radioBtnOutPatient.Text; objVisit.Insert(objVisitRow); //query = objHospitalDB.CreateCommand("insert into Visit(PatientType,PatientName,PatientID,BedID,DoctorID,DateOfVisit,DateOfDischarge,Symptoms,Disease,Treatment) Values('" + c + "','" + ultraComboEditorPName.Text + "','" + ultraComboEditorPatientID.Text + "','" + ultraComboBedID.Text + "','" + ultraComboEditorDoctorID.Text + "','" + ultraCalendarComboDOV.Text + "','" + ultraCalendarComboDOV.Text + "','" + ultraTextSymtoms.Text + "','" + ultraTextDisease.Text + "','" + ultraTextTreatment.Text + "')", false); } else { objVisit.Insert(objVisitRow); // query = objHospitalDB.CreateCommand("insert into Visit(PatientName,PatientID,DoctorID,BedID,DateOfVisit,DateOfDischarge,Symptoms,Disease,Treatment) Values('" + ultraComboEditorPName.Text + "','" + ultraComboEditorPatientID.Text + "','" + ultraComboEditorDoctorID.Text + "','" + ultraComboBedID.Text + "','" + ultraCalendarComboDOV.Text + "','" + ultraCalendarComboDOD.Text + "','" + ultraTextSymtoms.Text + "','" + ultraTextDisease.Text + "','" + ultraTextTreatment.Text + "')", false); } this.Hide(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { try { if (radioBtnInPatient.Checked == true) { objVisitRow.PatientType = radioBtnInPatient.Text; objVisitRow.VisitorID = Convert.ToInt32(this.id); objVisit.Update(objVisitRow); } else if (radioBtnOutPatient.Checked == true) { objVisitRow.PatientType = radioBtnOutPatient.Text; objVisitRow.VisitorID = Convert.ToInt32(this.id); objVisit.Update(objVisitRow); } else { objVisitRow.VisitorID = Convert.ToInt32(this.id); objVisit.Update(objVisitRow); } this.Hide(); } catch (Exception ex) { MessageBox.Show(ex.Message); if (objHospitalDB != null) { objHospitalDB.Dispose(); } } } }