private void btnPayment_Click(object sender, EventArgs e)
{
cDining_Table table = lsvBill.Tag as cDining_Table;
int idBill = cBill.GetUncheckBillIDByTableID(table.ID);
if (idBill != -1)
{
if (MessageBox.Show("Bạn có chắc thanh toán hóa đơn cho " + table.DiningTableName, "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
DataProvider.ExecuteQuery("UPDATE dbo.Bill SET BillStatus = N'Đã thanh toán', PaymentDate = CURRENT_TIMESTAMP WHERE id = " + idBill);
rBill report = new rBill(idBill);
ReportPrintTool print = new ReportPrintTool(report);
report.ShowPreview();
ShowBill(table.ID);
loadFpnl(cDining_Table.LoadAllTableList());
btnPayment.Enabled = false;
}
}
else
{
MessageBox.Show("Có lỗi xảy ra !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static List <cDining_Table> LoadEmptyTableList()
{
List <cDining_Table> tableList = new List <cDining_Table>();
DataTable data = DataProvider.ExecuteQuery("SELECT * FROM dbo.Dining_Table WHERE TableStatus = N'Trống'");
foreach (DataRow item in data.Rows)
{
cDining_Table table = new cDining_Table(item);
tableList.Add(table);
}
return(tableList);
}
private void tsmMenuAdd_Click(object sender, EventArgs e)
{
cDining_Table table = lsvBill.Tag as cDining_Table;
if (table == null)
{
MessageBox.Show("Hãy chọn bàn !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
fInput f = new fInput();
f.ShowDialog();
if (f.amount == 0)
{
return;
}
string id = string.Empty;
if (DataProvider.ExecuteQuery("SELECT dbo.Products.id FROM dbo.Products WHERE dbo.Products.ProductName = N'" + lsvMenu.SelectedItems[0].Text + "'") != null)
{
foreach (DataRow dr in DataProvider.ExecuteQuery("SELECT dbo.Products.id FROM dbo.Products WHERE dbo.Products.ProductName = N'" + lsvMenu.SelectedItems[0].Text + "'").Rows)
{
id = dr["id"].ToString();
}
}
int idBill = cBill.GetUncheckBillIDByTableID(table.ID);
int productID = int.Parse(id);
int amount = f.amount;
if (idBill == -1)
{
cBill.InsertBill(table.ID);
cBillInfo.InsertBillInfo(cBill.GetMaxIDBill(), productID, amount);
}
else
{
cBillInfo.InsertBillInfo(idBill, productID, amount);
}
ShowBill(table.ID);
loadFpnl(cDining_Table.LoadAllTableList());
btnPayment.Enabled = true;
}