protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dtfInfo = DateTimeFormatInfo.InvariantInfo;
MODEL.Criteria.reqDashboard req = new MODEL.Criteria.reqDashboard();
hdMemberID.Value = getMemberID();
hdRestaurantID.Value = getRestaurantID();
//req.RestaurantID = HttpContext.Current.Application["app_memberID"].ToString().Trim();
//req.RestaurantID = Session["session_restaurantID"].ToString().Trim();
req.RestaurantID = hdRestaurantID.Value;
req.DashboardDate = DateTime.Today.ToString("MM/dd/yyyy", dtfInfo);
initDashBoard();
DAL.Dashboard sv = new DAL.Dashboard();
MODEL.DashboardCashier model = new MODEL.DashboardCashier();
model = sv.getDashboardCashier(req);
if (model.ResultOk == "true")
{
// lblFoodsOrder.InnerText = model.FoodsOrder;
// lblCountTable.InnerText = model.CountTable;
// lblSalesOrder.InnerText = model.CountSalesOrderPerDay;
// lblNoticeBill.InnerText = model.CountNoticeBill;
repMain.DataSource = model.list;
repMain.DataBind();
}
else
{
}
}
}
private void initDashBoard()
{
MODEL.Criteria.reqDashboard req = new MODEL.Criteria.reqDashboard();
BLL.DashBoard _BLL = new BLL.DashBoard();
String SumPrice;
String CountTable;
String CountUser;
String FoodPending;
String CountFood;
String CountDrink;
hdMemberID.Value = getMemberID();
hdRestaurantID.Value = getRestaurantID();
req.RestaurantID = hdRestaurantID.Value;
req.DashboardDate = DateTime.Today.ToString("MM/dd/yyyy", dtfInfo);
SumPrice = _BLL.getSumPrice(req);
lblSumPrice.InnerText = SumPrice;
CountTable = _BLL.getCountTable(req);
lblCountTable.InnerText = CountTable;
CountUser = _BLL.getUserBuy(req);
lblCountUser.InnerText = CountUser;
FoodPending = _BLL.getFoodPending(req);
lblFoodPending.InnerText = FoodPending;
CountDrink = _BLL.getCountDrink(req);
lblCountDrink.InnerText = CountDrink;
CountFood = _BLL.getCountFood(req);
lblCountFood.InnerText = CountFood;
}
public MODEL.DashboardCashier getDashboardCashier([FromBody] MODEL.Criteria.reqDashboard req)
{
MODEL.DashboardCashier result = new MODEL.DashboardCashier();
result.ResultOk = "false";
try
{
if (req != null)
{
result.ResultOk = "true";
result.ErrorMessage = "";
result.FoodsOrder = "15";
result.CountTable = "2";
result.CountSalesOrderPerDay = "45,000";
List <Bill> listBill = new List <Bill>();
Bill mBill;
mBill = new Bill();
mBill.billID = "20191020002";
mBill.billNo = "20191020002";
mBill.billCreateDate = "20-10-2019 08:30:00";
mBill.billCreateName = "sombut";
mBill.billTableName = "10";
mBill.billMenuCount = "6";
mBill.billTotalPrice = "4000";
mBill.billStatusText = "Complete";
listBill.Add(mBill);
mBill = new Bill();
mBill.billID = "20191020003";
mBill.billNo = "20191020003";
mBill.billCreateDate = "20-10-2019 10:30:00";
mBill.billCreateName = "nathan";
mBill.billTableName = "15";
mBill.billMenuCount = "4";
mBill.billTotalPrice = "7500";
mBill.billStatusText = "Complete";
listBill.Add(mBill);
result.list = listBill;
}
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.ResultOk = "false";
}
finally
{
}
return(result);
}
public string getCountDrink(MODEL.Criteria.reqDashboard req)
{
SqlConnection conn = new SqlConnection(DataHelper.GetConnectionString());
DataSet ds = new DataSet();
String ret = "0";
DataTable tb;
try
{
conn.Open();
string Sql;
SqlDataAdapter adp = new SqlDataAdapter("sp_GetCountDrink", conn);
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
adp.SelectCommand.Parameters.Add(new SqlParameter("@restaurantID", req.RestaurantID));
adp.SelectCommand.Parameters.Add(new SqlParameter("@StartDate", req.DashboardDate + " 00:00"));
adp.SelectCommand.Parameters.Add(new SqlParameter("@EndDate", req.DashboardDate + " 23:59"));
//adp.Fill(ds);
adp.Fill(ds);
tb = ds.Tables[0];
if (tb.Rows.Count > 0)
{
ret = tb.Rows[0][0].ToString();
}
else
{
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(ret);
}
public string getCountDrink(MODEL.Criteria.reqDashboard req)
{
return(DashboardDAL.getCountDrink(req));
}
public string getFoodPending(MODEL.Criteria.reqDashboard req)
{
return(DashboardDAL.getFoodPending(req));
}
public string getUserBuy(MODEL.Criteria.reqDashboard req)
{
return(DashboardDAL.getUserBuy(req));
}
public string getSumPrice(MODEL.Criteria.reqDashboard req)
{
return(DashboardDAL.getSumPrice(req));
}
public MODEL.DashboardCashier getDashboardCashier(MODEL.Criteria.reqDashboard req)
{
return(DashboardDAL.getDashboardCashier(req));
}
public MODEL.DashboardCashier getDashboardCashier(MODEL.Criteria.reqDashboard req)
{
SqlConnection conn = new SqlConnection(DataHelper.GetConnectionString());
DataSet ds = new DataSet();
MODEL.DashboardCashier result = new MODEL.DashboardCashier();
List <Bill> bill = new List <Bill>();
try
{
conn.Open();
string Sql;
SqlDataAdapter adp = new SqlDataAdapter("sp_getDashboard_Cashier", conn);
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
adp.SelectCommand.Parameters.Add(new SqlParameter("@restaurantID", req.RestaurantID));
adp.SelectCommand.Parameters.Add(new SqlParameter("@StartDate", req.DashboardDate + " 00:00"));
adp.SelectCommand.Parameters.Add(new SqlParameter("@EndDate", req.DashboardDate + " 23:59"));
//adp.Fill(ds);
adp.Fill(ds);
if (ds.Tables.Count > 0)
{
result.ResultOk = "true";
result.FoodsOrder = ds.Tables[0].Rows[0][0].ToString().Trim();
result.CountTable = ds.Tables[1].Rows[0][0].ToString().Trim();
result.CountSalesOrderPerDay = ds.Tables[2].Rows[0][0].ToString().Trim();
result.CountNoticeBill = ds.Tables[3].Rows[0][0].ToString().Trim();
if (ds.Tables[4].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = ds.Tables[4];
Bill f;
for (int i = 0; i < dt.Rows.Count; i++)
{
f = new Bill();
f.queue_no = dt.Rows[i]["queue_no"].ToString().Trim();
f.billNo = dt.Rows[i]["order_no"].ToString().Trim();
f.billTableName = dt.Rows[i]["table_name"].ToString().Trim();
f.billMenuCount = dt.Rows[i]["CountFoods2"].ToString().Trim();
f.billTotalPrice = dt.Rows[i]["SumPrice2"].ToString().Trim();
f.billStatusText = dt.Rows[i]["status_order"].ToString().Trim();
bill.Add(f);
}
}
result.list = bill;
}
else
{
result.ResultOk = "false";
}
}
catch (Exception ex)
{
result.ResultOk = "false";
result.ErrorMessage = ex.Message;
}
finally
{
conn.Close();
}
return(result);
}
public DashboardKitchen getDashboardKitchen([FromBody] MODEL.Criteria.reqDashboard req)
{
DashboardKitchen result = new DashboardKitchen();
result.resultOk = "false";
try
{
if (req != null)
{
result.resultOk = "true";
result.errorMessage = "";
result.CountFoodsPending = "15";
result.CountFoodPerDay = "2";
result.MenuUrgent = "10";
List <Food> listFood = new List <Food>();
Food mFood;
mFood = new Food();
mFood.menuFoodsName = "Meet Steak";
mFood.tableName = "Table 1";
mFood.menuStatus = "Wait";
listFood.Add(mFood);
mFood = new Food();
mFood.menuFoodsName = "Pork Steak";
mFood.tableName = "Table 1";
mFood.menuStatus = "Wait";
listFood.Add(mFood);
//List<Bill> listBill = new List<Bill>();
//Bill mBill;
//mBill = new Bill();
//mBill.billID = "20191020002";
//mBill.billNo = "03";
//mBill.billCreateDate = "20-10-2019 08:30:00";
//mBill.billCreateName = "sombut";
//mBill.billTableName = "10";
//mBill.billMenuCount = "6";
//mBill.billTotalPrice = "750";
//mBill.billStatusText = "Complete";
//listBill.Add(mBill);
result.list = listFood;
//"billID": "20191020002",
//"billNo": "03",
//"billCreateDate": "20-10-2019 08:30:00",
//"billCreateName": "sombut",
//"billTableName": "10",
//"billMenuCount": "6",
//"billTotalPrice": "750",
//"billStatusText": "Complete"
}
}
catch (Exception e)
{
result.errorMessage = e.Message;
result.resultOk = "false";
}
finally
{
}
return(result);
}
