public Bill_Infor(BillInfor bill)
{
this.bill = bill;
InitializeComponent();
this.FormBorderStyle = FormBorderStyle.None;
Region = System.Drawing.Region.FromHrgn(CreateRoundRectRgn(0, 0, Width, Height, 18, 18));
}
public void updateItem(BillInfor billInfor)
{
int oldItems = int.Parse(DataProvider.Instance.ExcuteQuery("select * from dbo.ITEM where id = '" + billInfor.IdItem + @"'").Rows[0]["countItem"].ToString());
string query = "update dbo.ITEM set countItem = " + (oldItems - billInfor.CountItems).ToString() + @"where id = '" + billInfor.IdItem + @"'";
DataProvider.Instance.ExcuteQuery(query);
}
public List <BillInfor> getListBillInfor(string idBill)
{
List <BillInfor> billInfors = new List <BillInfor>();
DataTable table = DataProvider.Instance.ExcuteQuery("select * from dbo.BILLINFOR where idBill = '" + idBill + @"'");
foreach (DataRow item in table.Rows)
{
BillInfor bi = new BillInfor(item);
billInfors.Add(bi);
}
return(billInfors);
}
public List <BillInfor> GetListBillInfo(int id)
{
List <BillInfor> listBillInfo = new List <BillInfor>();
DataTable data = DBHelper.ExecuteQuery("select * from billinfo where idbill= " + id);
foreach (BillInfor item in listBillInfo)
{
BillInfor billinfo = new BillInfor();
listBillInfo.Add(billinfo);
}
return(listBillInfo);
}
public List <BillInfor> getListBillInfor(int id)
{
List <BillInfor> listBillInfor = new List <BillInfor>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from BillInfo where idBill = " + id);
foreach (DataRow item in data.Rows)
{
BillInfor infor = new BillInfor(item);
listBillInfor.Add(infor);
}
return(listBillInfor);
}
public ActionResult Detail(BillInfor billInfor)
{
if (ModelState.IsValid)
{
var id = Session["idUser"];
if (id != null)
{
int i = product.Purchase(billInfor, Convert.ToInt32(id));
TempData["shortMessage"] = i;
}
return(RedirectToAction("Detail", "Purchase"));
}
else
{
return(RedirectToAction("Detail", "Purchase"));
}
}
public void AddData(BillInfor billInfor)
{
string query = @"insert into dbo.BILLINFOR
(
id,
idItem,
idBill,
countItems
)
values
(
'" + billInfor.Id + @"',
'" + billInfor.IdItem + @"',
'" + billInfor.IdBill + @"',
" + billInfor.CountItems.ToString() + @"
)";
DataProvider.Instance.ExcuteQuery(query);
}
private void btnSave_Click(object sender, EventArgs e)
{
btnPay.Enabled = true;
btnChangeTable.Enabled = true;
bool status = false;
double totalPrice = Convert.ToDouble(txtToTal.Text);
int sale = Convert.ToInt32(cbxSale.SelectedItem);
List <Bill> bills = Bill.GetAllBill(tableid);
if (!btnAddFood.Enabled)
{
ArrayList arrayList = new ArrayList()
{
DateTime.Now, tableid, status, totalPrice, lblStaff.Text, sale
};
Bill.AddBill(arrayList);
}
int billId = Bill.GetAllBill(tableid)[0].Id;
if (Bill.GetAllBill(tableid).Count > 0)
{
BillInfor.DeleteBillInfor(billId);
}
for (int i = 0; i < dgvOrder.Rows.Count; i++)
{
ArrayList billInfor = new ArrayList()
{
billId, foodId[i], dgvOrder.Rows[i].Cells["Số Lượng"].Value, dgvOrder.Rows[i].Cells["Thành Tiền"].Value
};
BillInfor.AddBill(billInfor);
}
ArrayList tableList = new ArrayList()
{
"Có Người", tableid
};
Table.UpdateTableStatus(tableList);
LoadTable();
dgvOrder.DataSource = MenuDAL.GetMenuByTableId(tableid);
refreshDgvOrder();
}
private void BtPay_Click(object sender, EventArgs e)
{
string s = AddHistoryLoginDAO.Instance.idLoginNow();
Bill bill = new Bill(AddHistoryLoginDAO.Instance.idLoginNow(), DateTime.Now, float.Parse(lbTotal.Text));
billDAO.Instance.addData(bill);
for (int i = lvBillInfor.Items.Count - 1; i >= 0; i--)
{
BillInfor billInfor = new BillInfor(lvBillInfor.Items[i].SubItems[1].Text, lvBillInfor.Items[i].SubItems[2].Text, bill.Id);
BillInforDAO.Instance.AddData(billInfor);
ItemDAO.Instance.updateItem(billInfor);
}
MoneyDAO.Instance.updateMoneyAdd(Total, "đơn hàng");
MessageBox.Show("Số tiền: " + lbTotal.Text);
lvBillInfor.Clear();
lbTotal.Text = "0.0";
Total = 0;
}
public ActionResult Detail()
{
if (TempData["shortMessage"] != null)
{
ViewBag.Update = TempData["shortMessage"].ToString();
}
var id = Session["idUser"];
int totalPrice = 0;
if (id != null)
{
totalPrice = product.TotalPrice(Convert.ToInt32(id));
}
Customer cus = product.GetCustomerDetail(Convert.ToInt32(id));
BillInfor billInfor = new BillInfor()
{
Name = cus.LastName,
Phone = cus.Phone,
Cus_Note = cus.Address,
totalPrice = totalPrice
};
return(View(billInfor));
}
