public DataTable getAllDrSchedule(DODrSchedule objDODrSchedule)
{
DataTable dt = objDALDrSchedule.DrScheduleList(objDODrSchedule);
return(dt);
}
public DataTable getSelectedDrSchedule(DODrSchedule objDODrSchedule)
{
DataTable dt = objDALDrSchedule.SelectedDrSchedule(objDODrSchedule);
return(dt);
}
private void cmboConsultant_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (cmboConsultant.SelectedIndex > 0)
{
DODrSchedule objdodrschedule = new DODrSchedule();
objdodrschedule.ConsultantID = Convert.ToInt32(cmboConsultant.SelectedValue);
objdodrschedule.Flag = 2;
DataTable dt = objDrScheduleServices.getSelectedDrSchedule(objdodrschedule);
dgDrSchedule.DataSource = dt;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void defaultloadallControlValues()
{
try
{
//Default gridview load with all dr schedule
DODrSchedule objdodrschedule = new DODrSchedule();
//objdodrschedule.Flag = 1;
dgDrSchedule.DataSource = objDrScheduleServices.getAllDrSchedule(objdodrschedule);
//Consultant Combobox load
MasterConsultantDO objMasterConsultantDO = new MasterConsultantDO();
objMasterConsultantDO.Flag = 4; //To load combobox with consultant full name as display member and Consultant Id as value member
DataTable dt = objMasterConsultantSerices.getConsultantList(objMasterConsultantDO);
cmboConsultant.DataSource = dt;
cmboConsultant.ValueMember = "ConsultantID";
cmboConsultant.DisplayMember = "Name";
DataRow drr;
drr = dt.NewRow();
drr["ConsultantID"] = "0";
drr["Name"] = "$---Select---$";
dt.Rows.Add(drr);
dt.DefaultView.Sort = "Name asc";
//-------------------------
cmboConsultant.DataSource = dt;
cmboConsultant.DisplayMember = "Name";
cmboConsultant.ValueMember = "ConsultantID";
cmboConsultant.Text = "$---Select---$";
// //All Appointment Load
refreshAppointmentList();
//Searchcombo box initialized
cmbSearch.Text = "Search Appointment By";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public DataTable SelectedDrSchedule(DODrSchedule obj)
{
DataTable dt = ExecuteDatable(SP_Procedure, true, obj.SQLParameters);
return(dt);
}