private void Loadata(int CustomerID)
{
defaultAvatar = Comon.Global.sys_DefaultAvatar;
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Customer_LoadInfo]", CommandType.StoredProcedure,
"@CurrentID", SqlDbType.Int, Convert.ToInt32(CustomerID == 0 ? 0 : CustomerID));
}
if (ds != null)
{
CustName = ds.Tables["Table"].Rows[0]["Name"].ToString();
CustCode = ds.Tables["Table"].Rows[0]["Cust_Code"].ToString();
Phone = ds.Tables["Table"].Rows[0]["Phone1"].ToString();
Avatar = ds.Tables["Table"].Rows[0]["Avatar"].ToString();
facebookurl = ds.Tables["Table"].Rows[0]["facebookurl"].ToString();
instgramurl = ds.Tables["Table"].Rows[0]["instgramurl"].ToString();
totalmoneyRaise = ds.Tables["Table"].Rows[0]["TOTALPRICE"].ToString();
totalmoneyPaid = ds.Tables["Table"].Rows[0]["TOTALPAID"].ToString();
totalmoneyLeft = ds.Tables["Table"].Rows[0]["Rest"].ToString();
}
else
{
CustName = "";
CustCode = "";
Phone = ""; Avatar = ""; instgramurl = ""; facebookurl = "";
totalmoneyRaise = ""; totalmoneyPaid = ""; totalmoneyLeft = "";
}
}
public static string LoadData(string dateFrom, string dateTo, string branchID)
{
//Ke toan STT,ReceiptName,Amount,Date,CreatedName
//import STT,Date,CreatedName,Amount
//payment STT,CustomerName,Date,Amount,CreatedName,SourceName
// Total ketoan, toal import, toal payment, totalmain
DataSet ds = new DataSet();
//DataTable dt = new DataTable();
//dt.Columns.Add("Month"); dt.Columns.Add("Amount"); dt.Columns.Add("Target"); dt.Columns.Add("UpDown");
//DataRow dr = dt.NewRow();
//dr[0] = "06-2019"; dr[1] = "4000000"; dr[2] = "06-2019"; dr[3] = "<a class='ui blue mini basic label'>Up</a>";
//DataRow dr1 = dt.NewRow();
//dr1[0] = "07-2019"; dr1[1] = "7000000"; dr1[2] = "07-2019"; dr1[3] = "<a class='ui red mini basic label'>Down</a>";
//dt.Rows.Add(dr); dt.Rows.Add(dr1);
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Report_Overview]", CommandType.StoredProcedure,
"@dateFrom", SqlDbType.DateTime, Convert.ToDateTime(dateFrom)
, "@dateTo", SqlDbType.DateTime, Convert.ToDateTime(dateTo)
, "@branchID", SqlDbType.Int, Convert.ToInt32(branchID));
}
if (ds != null)
{
return(JsonConvert.SerializeObject(ds, Formatting.Indented));
}
else
{
return("");
}
}
private void InitializeService()
{
_Service = new List <DiscountTable>();
_ServiceType = new List <DiscountTable>();
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Discount_LoadListService]", CommandType.StoredProcedure);
}
if (ds != null)
{
DataTable dtService = ds.Tables[0];
DataTable dtServiceType = ds.Tables[1];
foreach (DataRow dr in dtService.Rows)
{
_Service.Add(new DiscountTable(dr[0].ToString(), dr[1].ToString()));
}
foreach (DataRow dr in dtServiceType.Rows)
{
_ServiceType.Add(new DiscountTable(dr[0].ToString(), dr[1].ToString()));
}
}
else
{
_Service = null;
_ServiceType = null;
}
}
private void Loadata(int id)
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Product_Reciept_LoadDetail]", CommandType.StoredProcedure,
"@ID", SqlDbType.Int, Convert.ToInt32(id == 0 ? 0 : id));
}
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
_DataProductChoosen = JsonConvert.SerializeObject(ds.Tables[1]);
}
else
{
_DataProductChoosen = null;
}
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
_DataInputMain = JsonConvert.SerializeObject(ds.Tables[0]);
}
else
{
_DataInputMain = "";
}
}
public static string LoadataCustomer(string dateFrom, string dateTo)
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Customer_LoadList]", CommandType.StoredProcedure,
"@dateFrom", SqlDbType.DateTime, Convert.ToDateTime(dateFrom)
, "@dateTo", SqlDbType.DateTime, Convert.ToDateTime(dateTo));
}
return(JsonConvert.SerializeObject(ds));
}
public static string LoadataReceipt(string dateFrom, string dateTo)
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Accountant_ReceiptPaymentLoad]", CommandType.StoredProcedure,
"@dateFrom", SqlDbType.DateTime, Convert.ToDateTime(dateFrom)
, "@dateTo", SqlDbType.DateTime, Convert.ToDateTime(dateTo));
}
return(JsonConvert.SerializeObject(ds));
}
public string LoadDataMovie()
{
try
{
string Page = HttpContext.Request.Query["Page"].ToString();
DataSet dt = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
dt = confunc.ExecuteDataSet("[YYY_sp_Client_Movie_LoadList_Catalog]", CommandType.StoredProcedure,
"@PageNumber", SqlDbType.Int, Page);
}
return(dt != null?JsonConvert.SerializeObject(dt) : "[]");
}
catch (Exception ex)
{
return("[]");
}
}
private void Initialize()
{
_DataBranch = "";
_DataCompany = "";
_DataOption = "";
DataSet ds = new DataSet();
using (Models.ExecuteDataBase connFunc = new Models.ExecuteDataBase())
{
ds = connFunc.ExecuteDataSet("[YYY_sp_LoadAll_Setting]", CommandType.StoredProcedure);
}
_Branch_ID = ds.Tables[1].Rows[0]["ID"].ToString();
_CompanyID = ds.Tables[0].Rows[0]["ID"].ToString();
_DataBranch = JsonConvert.SerializeObject(ds.Tables[1]);
_DataCompany = JsonConvert.SerializeObject(ds.Tables[0]);
_DataOption = JsonConvert.SerializeObject(ds.Tables[2]);
}
public string Loadata(int CustomerID)
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_CustomerCare_GetInfo]", CommandType.StoredProcedure,
"@Customer_ID", SqlDbType.Int, Convert.ToInt32(CustomerID == 0 ? 0 : CustomerID));
}
if (ds != null)
{
return(JsonConvert.SerializeObject(ds, Formatting.Indented));
}
else
{
return("");
}
}
private void Loadata(int CustomerID)
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Customer_LoadInfo]", CommandType.StoredProcedure,
"@CurrentID", SqlDbType.Int, Convert.ToInt32(CustomerID == 0 ? 0 : CustomerID));
}
if (ds != null)
{
dataMainCustomer = JsonConvert.SerializeObject(ds.Tables["Table"], Formatting.Indented);
dataSchedule = JsonConvert.SerializeObject(ds.Tables["Table3"], Formatting.Indented);
dataHistory = JsonConvert.SerializeObject(ds.Tables["Table1"], Formatting.Indented);
}
else
{
dataMainCustomer = "";
dataSchedule = "";
dataHistory = "";
}
}
DataSet LoadDataProduct()
{
try
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Client_Product_LoadList]", CommandType.StoredProcedure);
}
if (ds != null)
{
return(ds);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public string LoadDataMain()
{
try
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Client_Movie_LoadList_Main]", CommandType.StoredProcedure);
}
if (ds != null)
{
return(JsonConvert.SerializeObject(ds));
}
else
{
return("[]");
}
}
catch (Exception ex)
{
return("[]");
}
}
DataSet DataRoomChair(int RoomID)
{
try
{
DataSet dt = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
dt = confunc.ExecuteDataSet("[YYY_sp_Cinema_Chair_LoadDetail]", CommandType.StoredProcedure,
"@RoomID", SqlDbType.Int, RoomID);
}
if (dt != null)
{
return(dt);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public string GetMovieDetail(int MovieDetailID)
{
try
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Client_Movie_LoadDetail]", CommandType.StoredProcedure,
"@CurrentID", SqlDbType.Int, MovieDetailID);
}
if (ds != null)
{
return(JsonConvert.SerializeObject(ds));
}
else
{
return("");
}
}
catch (Exception ex)
{
return("[]");
}
}
public string LoadUser()
{
try
{
DataSet dt = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
dt = confunc.ExecuteDataSet("[YYY_sp_Employee_LoadList]", CommandType.StoredProcedure);
}
if (dt != null)
{
return(JsonConvert.SerializeObject(dt));
}
else
{
return("[]");
}
}
catch (Exception ex)
{
return("[]");
}
}
DataSet LoadDetail(int ScheduleID)
{
try
{
DataSet ds = new DataSet();
using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase())
{
ds = confunc.ExecuteDataSet("[YYY_sp_Client_Schedule_LoadMovie]", CommandType.StoredProcedure,
"@ScheduleID", SqlDbType.Int, ScheduleID);
}
if (ds != null)
{
return(ds);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}