public bool UpdateBookingTable(int order_id)
{
string query = $"update ires.booking_table set status='ĐÃ THANH TOÁN' where order_id={order_id}";
WorkerToDB paymentToBD = new WorkerToDB();
return(paymentToBD.updateCommand(query));
}
public bool UpdateOrder(int order_id, int user_id)
{
string query = $"update ires.orders set order_status='ĐÃ THANH TOÁN' where order_id={order_id}";
WorkerToDB paymentToBD = new WorkerToDB();
return(paymentToBD.updateCommand(query));
}
public Order getOrderInfo(int order_id)
{
string query = $"select * from ires.orders where order_id={order_id}";
WorkerToDB billToDB = new WorkerToDB();
DataTable dt = billToDB.getRecordsCommand(query);
var orderInfo = new Order();
for (int i = 0; i < dt.Rows.Count; i++)
{
var orderTotalPrice = (Convert.ToInt32(dt.Rows[i]["order_total_price"].ToString() != "" ? dt.Rows[i]["order_total_price"] : 280000));
var code = dt.Rows[i]["order_code"].ToString() != "" ? dt.Rows[i]["order_code"].ToString() : "o_111111";
var persons = dt.Rows[i]["person_quantity"].ToString() != "" ? Convert.ToInt32(dt.Rows[i]["person_quantity"]) : 4;
orderInfo = new Order()
{
OrderTotalPrice = orderTotalPrice,
Code = code,
Id = order_id,
PersonQuantity = persons
};
}
return(orderInfo);
}
public bool UpdateTableList(int orderId) // này là 1 list nè
{
//string query = $"update ires.table_info set table_status='CÒN TRỐNG' where table_id={table_id}";
string query = $"UPDATE ires.table_info SET table_status ='CÒN TRỐNG', request_payment=false,payment_type=NULL, tip=NULL, promotion=NULL, table_mes=NULL WHERE table_id " +
$"IN(SELECT table_id FROM ires.booking_table WHERE order_id={orderId})";
WorkerToDB paymentToBD = new WorkerToDB();
return(paymentToBD.updateCommand(query));
}
public bool WriteToBill(Order orderInfo, int user_id, MoneyPayModel moneyPay, CustomerModel cus, string type, string billId)
{
string query = $"INSERT INTO ires.BILL (BILL_CODE, ORDER_ID, ORDER_TOTAL_PRICE, CUSTOMER_ID, EMPLOYEE_ID, PAYMENT, TIP, PROMOTION_ID, PROMOTION_COST, CREATED_DATETIME, " +
$"UPDATED_BY, CUSTOMER_NAME, PERSON_QUANTITY) values('{billId}' , {orderInfo.Id}, {moneyPay.TotalPay}, {cus.ID}, " +
$"{user_id}, {moneyPay.MoneyCustomer}, {moneyPay.MoneyCustomerTip + moneyPay.MoneyCustomerGive}, null, 0, '{DateTime.Now}', {user_id}, '{cus.Name}'," +
$" {orderInfo.PersonQuantity})";
WorkerToDB billToDB = new WorkerToDB();
return(billToDB.insertCommand(query));
}
public UserModel getUser(UserModel account)
{
string query = $"SELECT * FROM ires.employee WHERE user_name='{account.Username}' and password='******'";
WorkerToDB worker = new WorkerToDB();
DataTable dt = worker.getRecordsCommand(query);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// account.Role = dt.Rows[i]["role_id"].ToString();
//}
return(account);
}
public int getOrderId(int idTable)
{
string query = $"SELECT bt.order_id FROM ires.booking_table bt" +
$" WHERE bt.table_id={idTable} AND bt.status = 'CHƯA THANH TOÁN'";
WorkerToDB billToDB = new WorkerToDB();
DataTable dt = billToDB.getRecordsCommand(query);
int id = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
id = Convert.ToInt32(dt.Rows[i]["order_id"]);
}
return(id);
}
public FloorModel GetListTables(string tablePosition)
{
string query = $"SELECT * FROM ires.table_info where table_position='{tablePosition}' AND active=true";
FloorModel result = new FloorModel();
result.Name = tablePosition;
WorkerToDB tableToDB = new WorkerToDB();
DataTable dtFloor = tableToDB.getRecordsCommand(query);
try
{
for (int i = 0; i < dtFloor.Rows.Count; i++)
{
var table = new TableModel()
{
Code = dtFloor.Rows[i]["table_code"].ToString(),
Id = Convert.ToInt32(dtFloor.Rows[i]["table_id"]),
StatusShow = dtFloor.Rows[i]["table_status"].ToString() == "CÒN TRỐNG" ? false : true,
TableName = "Bàn " + dtFloor.Rows[i]["table_number"].ToString(),
TipMoney = Convert.ToInt32(dtFloor.Rows[i]["tip"].ToString() != "" ? dtFloor.Rows[i]["tip"] : 0),
Promotion = dtFloor.Rows[i]["promotion"].ToString() != "" ? dtFloor.Rows[i]["promotion"].ToString() : null
};
if (table.StatusShow == true)
{
++result.CountBusyTables;
}
else
{
++result.CountEmptyTables;
}
result.ListTables.Add(table);
}
result.ListTables = result.ListTables.OrderBy(x => x.Code).ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(result);
}
public List <OrderDetail> getDishesInfo(int order_id)
{
string query = $"Select * from ires.order_detail where order_id={order_id}";
WorkerToDB billToDB = new WorkerToDB();
DataTable dtOrderDetailInfo = billToDB.getRecordsCommand(query);
var result = new List <OrderDetail>();
try
{
for (int i = 0; i < dtOrderDetailInfo.Rows.Count; i++)
{
int dishId = Convert.ToInt32(dtOrderDetailInfo.Rows[i]["dish_id"]);
var checkDishId = result.FirstOrDefault(x => x.DishId == dishId);
var queryGetDish = $"Select * from ires.dish where dish_id={dishId}";
var resultDish = new Dish();
// get cost of dish
DataTable dtDishInfo = billToDB.getRecordsCommand(queryGetDish); // get cost
if (checkDishId == null)
{
result.Add(new OrderDetail()
{
DishQuantity = Convert.ToInt32(dtOrderDetailInfo.Rows[i]["dish_quantity"]),
Id = Convert.ToInt32(dtOrderDetailInfo.Rows[i]["order_detail_id"]),
DishId = dishId,
DishCost = Convert.ToInt32(dtDishInfo.Rows[0]["dish_cost"]),
DishName = dtDishInfo.Rows[0]["dish_name"].ToString(),
DishTotalCost = Convert.ToInt32(dtOrderDetailInfo.Rows[i]["dish_quantity"]) * Convert.ToInt32(dtDishInfo.Rows[0]["dish_cost"])
});
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(result);
}
public CustomerModel getCustomerInfo(int order_id)
{
string query = $"SELECT * from ires.customer" +
$" where customer_id IN (" +
$" select customer_id from ires.orders where order_id={order_id})";
WorkerToDB billToDB = new WorkerToDB();
DataTable dt = billToDB.getRecordsCommand(query);
var result = new CustomerModel();
for (int i = 0; i < dt.Rows.Count; i++)
{
var cusIdTemp = dt.Rows[i]["customer_id"].ToString() != "" ? Convert.ToInt32(dt.Rows[i]["customer_id"]) : 1;
var cusNameTemp = dt.Rows[i]["user_name"].ToString() != "" ? dt.Rows[i]["user_name"].ToString() : "Kim Hạnh";
var cusCodeTemp = dt.Rows[i]["customer_code"].ToString() != "" ? dt.Rows[i]["customer_code"].ToString() : "C_01";
var cusLevelTemp = dt.Rows[i]["customer_level"].ToString() != "" ? dt.Rows[i]["customer_level"].ToString() : "Vàng";
result = new CustomerModel()
{
ID = cusIdTemp,
Name = cusNameTemp,
Code = cusCodeTemp,
Level = cusLevelTemp
};
}
if (dt.Rows.Count == 0)
{
result = new CustomerModel
{
ID = 1,
Name = "Kim Hạnh",
Code = "C_01",
Level = "Vàng"
};
}
return(result);
}
public List <InfoRequestPaymentModel> GetListInfoNotify()
{
string query = "select * from ires.table_info where request_payment=true and table_status='ĐANG DÙNG'";
List <InfoRequestPaymentModel> result = new List <InfoRequestPaymentModel>();
WorkerToDB tableToDB = new WorkerToDB();
DataTable listTablesNotifies = tableToDB.getRecordsCommand(query);
try
{
for (int i = 0; i < listTablesNotifies.Rows.Count; i++)
{
var info = new InfoRequestPaymentModel()
{
Id = Convert.ToInt32(listTablesNotifies.Rows[i]["table_id"]),
Type = listTablesNotifies.Rows[i]["payment_type"].ToString(),
Description = listTablesNotifies.Rows[i]["table_mes"].ToString()
};
if (info.Type == "thẻ")
{
info.Description = "Momo -" + info.Description;
}
else if (info.Type == "tiền mặt")
{
info.Description = "Tiền mặt -" + info.Description;
}
result.Add(info);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lay danh sach notify loi");
}
return(result);
}
