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();
}
}
}
}
