public DataTable getConsultantList(MasterConsultantDO obj)
{
//DataTable dt = objMasterConsultantDAO.LoadConsultantCombo(obj);
DataTable dt = objMasterConsultantDAO.LoadConsultantDT(obj);
return(dt);
}
public void Save(MasterConsultantDO Obj1, bool IsNew)
{
if (IsNew)
{
CallInsert(Obj1);
}
else
{
CallUpdate(Obj1);
}
Obj1 = null;
}
public MasterConsultantDO Loaddr(MasterConsultantDO Obj1)
{
SqlDataReader dr;
dr = ExecuteDataReader(OpenConnection(), CommandType.StoredProcedure, SP_Procedure, Obj1.SQLParameters);
MasterConsultantDO objDOMaster_Consultant = new MasterConsultantDO(dr);
return(objDOMaster_Consultant);
dr.Close();
dr.Dispose();
objDOMaster_Consultant = null;
}
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 DataSet Load(MasterConsultantDO Obj1)
{
DataSet DS = new DataSet();
return(DS = objMasterConsultantDAO.ExecuteDataset(objMasterConsultantDAO.OpenConnection(), SP_Procedure, true, Obj1.SQLParameters));
}
public void Delete(MasterConsultantDO Obj1)
{
ExecuteNonQuery(OpenConnection(), SP_Procedure, true, Obj1.SQLParameters);
}
private void CallUpdate(MasterConsultantDO Obj1)
{
ExecuteNonQuery(OpenConnection(), SP_Procedure, true, Obj1.SQLParameters);
}
public DataTable LoadConsultantDT(MasterConsultantDO Obj1)
{
DataTable DS = new DataTable();
return(DS = ExecuteDatable(SP_Procedure, true, Obj1.SQLParameters));
}
