private void LoadComboMain()
{
_dataComboDoctor = "";
_dataComboAssist = "";
_dataComboStage = "";
//LoadDoctor
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadEmployee("Doctor", 0);
_dataComboDoctor = JsonConvert.SerializeObject(dt, Formatting.Indented);
}
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadEmployee("Assistant", 0);
_dataComboAssist = JsonConvert.SerializeObject(dt, Formatting.Indented);
}
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.ExecuteDataTable("YYY_sp_Customer_Treatment_LoadComboService", CommandType.StoredProcedure,
"@Customer_ID", SqlDbType.Int, _CustomerID);
_dataComboService = JsonConvert.SerializeObject(dt, Formatting.Indented);
}
}
public void LoadCombo()
{
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadPara("Schedule Type");
// ds.Tables.Add(dt);
_dataComboScheduleType = JsonConvert.SerializeObject(dt);
}
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadPara("ServiceCare");
// ds.Tables.Add(dt);
_dataComboServicetype = JsonConvert.SerializeObject(dt);
}
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadEmployee("Doctor", 0);
// ds.Tables.Add(dt);
_dataComboDoc = JsonConvert.SerializeObject(dt);
}
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.ExecuteDataTable("YYY_sp_Branch_Load", CommandType.StoredProcedure);
//ds.Tables.Add(dt);
_dataComboBranch = JsonConvert.SerializeObject(dt);
}
}