private void ultraButtonRegister_Click(object sender, EventArgs e)
{
objhospdb = new HospitalDB();
PatientVisitInfo objpatientVisitInfo = new PatientVisitInfo(objhospdb);
PatientVisitInfoRow objPatientVisitInfoRow = new PatientVisitInfoRow();
objPatientVisitInfoRow.PatientType = Convert.ToInt32(ultraComboPatientType.Text);
objPatientVisitInfoRow.DoctorId = Convert.ToInt32(ultraComboEditorDoctorId.Text);
objPatientVisitInfoRow.BedId = Convert.ToInt32(ultraComboEditorBedId.Text);
objPatientVisitInfoRow.DateofVisit = ultraDateTimeEditorDOV.DateTime;
objPatientVisitInfoRow.DateofDischarge = ultraDateTimeEditorDOD.DateTime;
objPatientVisitInfoRow.Symptoms = ultraTextEditorSymptoms.Text;
objPatientVisitInfoRow.Disease = ultraTextEditorDisease.Text;
objPatientVisitInfoRow.Treatment = ultraTextEditorTreatment.Text;
objpatientVisitInfo.Insert(objPatientVisitInfoRow);
/*
* SqlCommand cmd = objhospdb.CreateCommand("insert into PatientVisitInfo values('" + ultraComboPatientType .Text+ "', '"+ultraComboEditorDoctorId.Text+ "','" + ultraComboEditorBedId.Text + "','" + ultraDateTimeEditorDOV .Text+ "','"+ ultraDateTimeEditorDOD .Text+ "','"+ ultraTextEditorSymptoms .Text+ "','"+ ultraTextEditorDisease .Text+ "','"+ ultraTextEditorTreatment .Text+ "')");
* int o = cmd.ExecuteNonQuery();
* conn.Close();*/
MessageBox.Show(":Registered");
openfrmMain();
}
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();
}
}
}