public DataTable AllAppointmentList(AppointmentDO objAppointmentDO)
{
DataTable dt;
dt = ExecuteDatable(SP_Procedure, true, objAppointmentDO.SQLParameters);
return(dt);
}
public void refreshAppointmentList()
{
AppointmentDO objAppointmentDO = new AppointmentDO();
objAppointmentDO.Flag = 4;
dgAppointmentReport.DataSource = objAppointmentservices.getAllAppointmentList(objAppointmentDO);
}
private void updateAppointmentToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
AppointmentDO objAppointmentDO = new AppointmentDO();
objAppointmentDO.PatientName = txtPName.Text;
objAppointmentDO.ContactNo = txtPName.Text;
objAppointmentDO.AppointmentID = Convert.ToInt32(txtAptID.Text);
objAppointmentDO.ConsultantID = (int)cmboConsultant.SelectedValue;
objAppointmentDO.ConsultantName = cmboConsultant.Text;
//System.Console.WriteLine("********************* Consultant Name" + cmboConsultant.Text + "88888888888" + objdoappointment.ConsultantName);
objAppointmentDO.FromTime = dtpfromtime.Value.ToShortTimeString();
objAppointmentDO.ToTime = dtptotime.Value.ToShortTimeString();
objAppointmentDO.AppointmentDate = dtpdate.Value.Date;
objAppointmentDO.Flag = 2;
objAppointmentservices.getBookChangeAppointment(objAppointmentDO, false);
MessageBox.Show("Appointment Changed Successfully");
refreshAppointmentList();
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
AppointmentDO objAppointmentDO = new AppointmentDO();
if (cmbSearch.SelectedText == "Date")
{
objAppointmentDO.Flag = 5;
objAppointmentDO.AppointmentDate = dtpSearchAppointment.Value;
dgAppointmentReport.DataSource = objAppointmentservices.getAllAppointmentList(objAppointmentDO);
}
if (cmbSearch.Text == "Patient Name")
{
objAppointmentDO.Flag = 6;
objAppointmentDO.PatientName = txtSearch.Text;
dgAppointmentReport.DataSource = objAppointmentservices.getAllAppointmentList(objAppointmentDO);
}
if (cmbSearch.Text == "Consultant Name")
{
objAppointmentDO.Flag = 7;
objAppointmentDO.ConsultantName = txtSearch.Text;
dgAppointmentReport.DataSource = objAppointmentservices.getAllAppointmentList(objAppointmentDO);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void cancelAppointmentToolStripMenuItem_Click(object sender, EventArgs e)
{
AppointmentDO objAppointmentDO = new AppointmentDO();
objAppointmentDO.Flag = 3;
objAppointmentDO.AppointmentID = Convert.ToInt32(txtAptID.Text);
objAppointmentservices.getCancelAppointment(objAppointmentDO);
MessageBox.Show("Appointment Cancelled Successfully");
refreshAppointmentList();
}
private void dtpSearchAppointment_ValueChanged(object sender, EventArgs e)
{
AppointmentDO objAppointmentDO = new AppointmentDO();
objAppointmentDO.Flag = 5;
objAppointmentDO.AppointmentDate = dtpSearchAppointment.Value.Date;
label11.Text = dtpSearchAppointment.Value.Date.ToShortDateString();
dgAppointmentReport.DataSource = objAppointmentservices.getAllAppointmentList(objAppointmentDO);
refreshAppointmentList();
}
public void Save(AppointmentDO Obj1, bool IsNew)
{
if (IsNew)
{
CallInsert(Obj1);
}
else
{
CallUpdate(Obj1);
}
Obj1 = null;
}
public AppointmentDO Loaddr(AppointmentDO Obj1)
{
SqlDataReader dr;
dr = ExecuteDataReader(OpenConnection(), CommandType.StoredProcedure, SP_Procedure, Obj1.SQLParameters);
AppointmentDO objDOPatientIntro = new AppointmentDO(dr);
return(objDOPatientIntro);
dr.Close();
dr.Dispose();
objDOPatientIntro = null;
}
public void Delete(AppointmentDO Obj1)
{
ExecuteNonQuery(OpenConnection(), SP_Procedure, true, Obj1.SQLParameters);
}
private void CallUpdate(AppointmentDO Obj1)
{
ExecuteNonQuery(OpenConnection(), SP_Procedure, true, Obj1.SQLParameters);
}
public DataSet Load(AppointmentDO ObjAppointmentDO)
{
DataSet DS = new DataSet();
return(DS = ExecuteDataset(OpenConnection(), SP_Procedure, true, ObjAppointmentDO.SQLParameters));
}
public void getCancelAppointment(AppointmentDO objAppointmentDO)
{
objAppointmentDAO.Delete(objAppointmentDO);
}
public void getBookChangeAppointment(AppointmentDO objAppointmentDO, bool isbookchange)
{
objAppointmentDAO.Save(objAppointmentDO, isbookchange);
}
public DataTable getAllAppointmentList(AppointmentDO objAppointmentDO)
{
DataTable dt = objAppointmentDAO.AllAppointmentList(objAppointmentDO);
return(dt);
}