private void btnTeminate_Click(object sender, EventArgs e)
{
btnPay.Enabled = false;
btnPrint.Enabled = false;
btnTeminate.Enabled = false;
btnMove.Enabled = false;
btnAddInfo.Enabled = false;
btnReduce.Enabled = false;
Bill_BUS.DeleteAllOfBill(currentIdBill);
billInfo.Rows.Clear();
//xu ly table of bill
for (int i = 0; i < tableofbill.Rows.Count; i++)
{
int idTable = Int32.Parse(tableofbill.Rows[i]["IdTable"].ToString());
DataRow[] foundRows = tablelist.Select("IdTable = " + idTable);
foundRows[0]["Status"] = 0;
Table_BUS.EditStatusOfTable(idTable, 0);
((Button)flowLayoutPanel1.Controls[tableofbill.Rows[i]["IdTable"].ToString()]).Image = (Image)(Properties.Resources.available);
flowLayoutPanel1.Controls[tableofbill.Rows[i]["IdTable"].ToString()].BackColor = Color.FromArgb(15, 216, 52);
}
if (tableofbill.Rows.Count < 1)
{
gcBillTakeAway.DataSource = Bill_BUS.LoadBillTakeAway();
}
}
private void LoadTable()
{
txtSoLuong.Text = Table_BUS.CountTable().ToString();
txtBan.ReadOnly = true;
txtViTri.ReadOnly = true;
cbxTinhTrang.Enabled = false;
}
private void btnPay_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn muốn in hóa đơn?", "Xác Nhận", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
btnPrint_Click(sender, e);
}
billInfo.Rows.Clear();
Bill_BUS.EditStatusOfBill(currentIdBill, 1);
if (tableofbill.Rows.Count < 1)
{
gcBillTakeAway.DataSource = Bill_BUS.LoadBillTakeAway();
}
else
{
for (int j = 0; j < tableofbill.Rows.Count; j++)
{
int idTable = Int32.Parse(tableofbill.Rows[j]["IdTable"].ToString());
Table_BUS.EditStatusOfTable(idTable, 0);
((Button)flowLayoutPanel1.Controls[idTable.ToString()]).Image = (Image)(Properties.Resources.available);
flowLayoutPanel1.Controls[idTable.ToString()].BackColor = Color.FromArgb(15, 216, 52);
}
//flowLayoutPanel1.Controls.Clear();
//LoadTable();
tableofbill.Rows.Clear();
}
//tbTotal.Text = "";
btnAddInfo.Enabled = false;
btnReduce.Enabled = false;
btnPay.Enabled = false;
btnPrint.Enabled = false;
btnTeminate.Enabled = false;
btnMove.Enabled = false;
}
private void LoadTable()
{
tablelist = Table_BUS.LoadTable();
for (int i = 0; i < Table_BUS.CountTable(); i++)
{
Button btn = new Button()
{
Width = 80, Height = 80
};
Object id = tablelist.Rows[i]["IdTable"];
Object name = tablelist.Rows[i]["Name"];
Object status = tablelist.Rows[i]["Status"];
btn.Click += new EventHandler(this.buttonTable_Click);
btn.Name = id.ToString();
btn.Text = Environment.NewLine + Environment.NewLine + Environment.NewLine + Environment.NewLine + "" + name.ToString();
btn.ForeColor = Color.White;
btn.Font = new Font(btn.Font.Name, btn.Font.Size, FontStyle.Bold);
if (status.ToString() == "0")
{
btn.Image = (Image)(Properties.Resources.available);
btn.BackColor = Color.FromArgb(15, 216, 52);
}
else
{
btn.Image = (Image)(Properties.Resources.occupy);
btn.BackColor = Color.FromArgb(249, 64, 64);
}
flowLayoutPanel1.Controls.Add(btn);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (txtBan.Text.Trim() != "" && txtViTri.Text.Trim() != "")
{
if (flag == 1) //thêm
{
if (Table_BUS.CheckValidTable(txtBan.Text) == 1)
{
string status;
if (cbxTinhTrang.Text == "Trống")
{
status = "0";
}
else
{
status = "1";
}
Table_DTO table = new Table_DTO(txtBan.Text, txtViTri.Text, status);
Table_BUS.AddTable(table);
MessageBox.Show("Lưu thành công");
}
else
{
MessageBox.Show("Đã Tồn tại bàn " + txtBan.Text);
}
}
else //sửa
{
string status;
if (cbxTinhTrang.Text == "Trống")
{
status = "0";
}
else
{
status = "1";
}
DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle);
Table_DTO table = new Table_DTO(txtBan.Text, txtViTri.Text, status);
Table_BUS.EditTable(table, row[0].ToString());
MessageBox.Show("Sửa thành công");
}
dgvBan.DataSource = Table_BUS.LoadTable();
bindingData();
txtBan.ReadOnly = true;
txtViTri.ReadOnly = true;
cbxTinhTrang.Enabled = false;
txtSoLuong.Text = Table_BUS.CountTable().ToString();
btnLuu.Enabled = false;
btnThem.Enabled = true;
btnSua.Enabled = true;
btnXoa.Enabled = true;
}
else
{
MessageBox.Show("Vui lòng điền đầy đủ thông tin");
}
}
private void btnHuy_Click(object sender, EventArgs e)
{
LoadTable();
dgvBan.DataSource = Table_BUS.LoadTable();
bindingData();
btnThem.Enabled = true;
btnSua.Enabled = true;
btnXoa.Enabled = true;
btnLuu.Enabled = false;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (billInfo.Rows.Count > 0)
{
Bill_DTO newBill = new Bill_DTO(Int32.Parse(gridColumn6.SummaryItem.SummaryValue.ToString()), 0, DateTime.Now);
//Bill_DTO newBill = new Bill_DTO(Int32.Parse(tbTotal.Text), 0, DateTime.Now);
Bill_BUS.InsertBill(newBill);
currentIdBill = Bill_BUS.GetLastIdBill();
//xu ly bill info
for (int i = 0; i < billInfo.Rows.Count; i++)
{
int idFood = Int32.Parse(billInfo.Rows[i]["IdFood"].ToString());
int number = Int32.Parse(billInfo.Rows[i]["Number"].ToString());
BillDetails_BUS.InsertBillDetail(new BillDetails_DTO(currentIdBill, idFood, number));
}
//billInfo.Rows.Clear();
//xu ly table of bill
nameBill.Text = "Hóa Đơn - Bàn ";
for (int i = 0; i < tableofbill.Rows.Count; i++)
{
//int status = Int32.Parse(foundRows[0]["Status"].ToString());
int idTable = Int32.Parse(tableofbill.Rows[i]["IdTable"].ToString());
DataRow[] foundRows = tablelist.Select("IdTable = " + idTable);
foundRows[0]["Status"] = 1;
Table_BUS.EditStatusOfTable(idTable, 1);
BillTable_BUS.AddTableIntoBill(new BillTable_DTO(currentIdBill, idTable));
((Button)flowLayoutPanel1.Controls[tableofbill.Rows[i]["IdTable"].ToString()]).Image = (Image)(Properties.Resources.occupy);
flowLayoutPanel1.Controls[tableofbill.Rows[i]["IdTable"].ToString()].BackColor = Color.FromArgb(249, 64, 64);
nameBill.Text += " " + flowLayoutPanel1.Controls[tableofbill.Rows[i]["IdTable"].ToString()].Text.Trim();
}
if (tableofbill.Rows.Count < 1)
{
gcBillTakeAway.DataSource = Bill_BUS.LoadBillTakeAway();
nameBill.Text = "Hóa Đơn - " + currentIdBill + " (Mang về)";
}
//tableofbill.Rows.Clear();
btnCreateBill.Visible = true;
//btnAddInfo.Enabled = false;
btnCancel.Visible = false;
//btnReduce.Enabled = false;
btnSave.Visible = false;
btnPay.Enabled = true;
btnPrint.Enabled = true;
btnTeminate.Enabled = true;
btnMove.Enabled = true;
creatingBill = false;
refreshTable.Enabled = true;
//tbTotal.Text = "0";
}
else
{
MessageBox.Show("Không thể lập hóa đơn trống");
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn chắc chắn muốn xóa " + txtBan.Text + " ?", "Xác Nhận", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle);
Table_BUS.DeleteTable(row[0].ToString());
MessageBox.Show("Xóa hoàn tất");
}
dgvBan.DataSource = Table_BUS.LoadTable();
bindingData();
txtSoLuong.Text = Table_BUS.CountTable().ToString();
}
private void btnConfirmMove_Click(object sender, EventArgs e)
{
if (movingtable.Rows.Count > 0)
{
moving = false;
btnConfirmMove.Visible = false;
btnCancelMove.Visible = false;
btnMove.Visible = true;
btnPay.Enabled = true;
btnAddInfo.Enabled = true;
btnReduce.Enabled = true;
btnPrint.Enabled = true;
btnTeminate.Enabled = true;
btnCreateBill.Enabled = true;
refreshTable.Enabled = true;
BillTable_BUS.DeleteAllTablesOfBill(currentIdBill);
for (int i = 0; i < tableofbill.Rows.Count; i++)
{
int idTable = Int32.Parse(tableofbill.Rows[i]["IdTable"].ToString());
Table_BUS.EditStatusOfTable(idTable, 0);
DataRow[] foundRows = tablelist.Select("IdTable = " + idTable);
foundRows[0]["Status"] = 0;
}
for (int i = 0; i < movingtable.Rows.Count; i++)
{
int idTable = Int32.Parse(movingtable.Rows[i]["IdTable"].ToString());
BillTable_BUS.AddTableIntoBill(new BillTable_DTO(currentIdBill, idTable));
Table_BUS.EditStatusOfTable(idTable, 1);
DataRow[] foundRows = tablelist.Select("IdTable = " + idTable);
foundRows[0]["Status"] = 1;
((Button)flowLayoutPanel1.Controls[idTable.ToString()]).Image = (Image)(Properties.Resources.occupy);
flowLayoutPanel1.Controls[idTable.ToString()].BackColor = Color.FromArgb(249, 64, 64);
}
movingtable.Rows.Clear();
}
else
{
MessageBox.Show("Vui lòng chọn ít nhất 1 bàn.");
}
}
private void frmTable_Load(object sender, EventArgs e)
{
dgvBan.DataSource = Table_BUS.LoadTable();
bindingData();
btnLuu.Enabled = false;
}
