private void InitializeCombo()
{
_DataComboStatus = "";
_DataComboSource = "";
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
DataRow dr = dt.NewRow(); dr[0] = 0; dr[1] = "All";
DataRow dr1 = dt.NewRow(); dr1[0] = 1; dr1[1] = "Chưa Xử Lý";
DataRow dr2 = dt.NewRow(); dr2[0] = 2; dr2[1] = "Đã Xử Lý";
dt.Rows.Add(dr); dt.Rows.Add(dr1); dt.Rows.Add(dr2);
DataTable dt1 = new DataTable();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
dt1 = confunc.LoadPara("SourceCustomer");
DataRow dr3 = dt1.NewRow();
dr3[0] = 0; dr3[1] = "All";
dt1.Rows.InsertAt(dr3, 0);
}
_DataComboStatus = JsonConvert.SerializeObject(dt);
_DataComboSource = JsonConvert.SerializeObject(dt1);
}
private void InitializeCombo()
{
_DataComboSource = "";
DataTable dt1 = new DataTable();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
dt1 = confunc.LoadPara("SourceCustomer");
}
_DataComboSource = JsonConvert.SerializeObject(dt1);
}
private void InitializeCombo()
{
_DataComboTypeinput = "";
DataTable dt1 = new DataTable();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
dt1 = confunc.LoadPara("TypeIntput");
}
_DataComboTypeinput = JsonConvert.SerializeObject(dt1);
}
private void InitializeCombo()
{
_DataComboSource = "";
DataTable dt1 = new DataTable();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
dt1 = confunc.LoadPara("SourceCustomer");
DataRow dr3 = dt1.NewRow();
dr3[0] = 0; dr3[1] = "All";
dt1.Rows.InsertAt(dr3, 0);
}
_DataComboSource = JsonConvert.SerializeObject(dt1);
}
public static string LoadCombo()
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadPara("Schedule Type");
ds.Tables.Add(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);
}
return(JsonConvert.SerializeObject(ds, Formatting.Indented));
}
private void InitializeComboType()
{
_DataComboGender = "";
_DataTicketSource = "";
DataTable dt = new DataTable();
using (Models.ExecuteDataBase connFunc = new Models.ExecuteDataBase())
{
dt = connFunc.LoadPara("SourceCustomer");
}
DataTable dt1 = new DataTable();
using (Models.ExecuteDataBase connFunc = new Models.ExecuteDataBase())
{
dt1 = connFunc.LoadPara("Gender");
}
_DataTicketSource = JsonConvert.SerializeObject(dt);
_DataComboGender = JsonConvert.SerializeObject(dt1);
}
private void InitializeComboType()
{
_DataComboReceiptype = "";
_DataComboMethod = "";
DataTable dt = new DataTable();
using (Models.ExecuteDataBase connFunc = new Models.ExecuteDataBase())
{
dt = connFunc.LoadPara("ReceiptType");
}
DataTable dt1 = new DataTable();
using (Models.ExecuteDataBase connFunc = new Models.ExecuteDataBase())
{
dt1 = connFunc.LoadPara("Method");
}
_DataComboReceiptype = JsonConvert.SerializeObject(dt);
_DataComboMethod = JsonConvert.SerializeObject(dt1);
}
public static string LoadComboMain()
{
DataSet ds = new DataSet();
//LoadTypeHistory
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadPara("TypeHistory");
ds.Tables.Add(dt);
}
//LoadTypeCompalint
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadPara("TypeComplaint");
ds.Tables.Add(dt);
}
//
return(JsonConvert.SerializeObject(ds, 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);
}
}
public static string LoadComboMain()
{
DataSet ds = new DataSet();
//LoadGroup
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.ExecuteDataTable("YYY_sp_Employee_LoadCombo_Group", CommandType.StoredProcedure);
ds.Tables.Add(dt);
}
//LoadSourceCustomer
//LoadGender
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadPara("Gender");
ds.Tables.Add(dt);
}
return(JsonConvert.SerializeObject(ds, Formatting.Indented));
}
public void LoadComboMain()
{
//LoadLanguage
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadPara("Language");
_dataLangue = JsonConvert.SerializeObject(dt, Formatting.Indented);
}
//LoadSourceCustomer
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadPara("SourceCustomer");
_dataSource = JsonConvert.SerializeObject(dt, Formatting.Indented);
}
//LoadGender
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.LoadPara("Gender");
_dataGender = JsonConvert.SerializeObject(dt, Formatting.Indented);
}
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.ExecuteDataTable("[YYY_sp_LoadCombo_LocationCity]", CommandType.StoredProcedure);
_dataCity = JsonConvert.SerializeObject(dt, Formatting.Indented);
}
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
DataTable dt = new DataTable();
dt = confunc.ExecuteDataTable("[YYY_sp_LoadCombo_LocationDistrict]", CommandType.StoredProcedure);
_dataDistrict = JsonConvert.SerializeObject(dt, Formatting.Indented);
}
}