private void frmgiaodienchinh_Load(object sender, EventArgs e)
{
List <Table> tableList = new List <Table>();
DAOTable a = new DAOTable();
tableList = a.LoadTable();
foreach (Table item in tableList)
{
Button bt = new Button()
{
Width = 120,
Height = 120,
Image = Properties.Resources.icon_table,
FlatStyle = FlatStyle.Flat
};
bt.FlatAppearance.BorderSize = 0;
switch (item.TableStatus1)
{
case "Available":
bt.BackColor = Color.FromArgb(89, 121, 254);
bt.Text = item.Tenban;
break;
default:
bt.BackColor = Color.FromArgb(196, 57, 248);
bt.Text = item.Tenban;
break;
}
bt.Tag = item.Maban;
bt.Click += Bt_Click;
flp.Controls.Add(bt);
}
}
void loadChiTietHoaDon()
{
DAOTable ban = new DAOTable();
DAOHoaDon hd = new DAOHoaDon();
DAOChiTietHoaDon ct = new DAOChiTietHoaDon();
if (ban.KTBanDangSD(Globals.Maban))
{
dtg_chitiet.DataSource = ct.getChiTietHoaDon(Globals.Mahoadon);
dtg_chitiet.AllowUserToAddRows = false;
txt_tongtien.text = hd.getTongbill(Globals.Mahoadon).ToString();
}
}
private void btn_thanhtoan_Click(object sender, EventArgs e)
{
try
{
DAOHoaDon a = new DAOHoaDon();
a.ThanhToan(Globals.Mahoadon);
MessageBox.Show("Thanh toan thanh cong");
//update trang thai ban
DAOTable tb = new DAOTable();
tb.UpdatetableStatus(Globals.Maban, 1);
}
catch
{
}
}
private void btn_xoa_Click(object sender, EventArgs e)
{
DAOTable a = new DAOTable();
int ID = a.deleteTable();
foreach (Button item in flp.Controls)
{
if (Convert.ToInt32(item.Tag) == ID)
{
flp.Controls.Remove(item);
}
}
flp.Controls.Clear();
createButton();
}
//////////////////////////////////////////////////////////
private void btn_them_Click(object sender, EventArgs e)
{
DAOTable a = new DAOTable();
Table b = new Table();
b = a.addTable();
Button bt = new Button()
{
Width = 120,
Height = 120,
Image = Properties.Resources.icon_table,
FlatStyle = FlatStyle.Flat
};
bt.FlatAppearance.BorderSize = 0;
bt.BackColor = Color.FromArgb(89, 121, 254);
bt.Text = b.Tenban;
bt.Tag = b.Maban;
bt.Click += Bt_Click;
flp.Controls.Add(bt);
}
private void btn_dathang_Click(object sender, EventArgs e)
{
try
{
HoaDon hd = new HoaDon();
hd.Maban = Globals.Maban;
hd.Manv = Globals.NV;
hd.Thoigian = Convert.ToDateTime(DateTime.Now.ToShortDateString());
hd.Tongbill = tongtien;
hd.Trangthai = false;
hd.Mavoucher = int.Parse(cbVoucher.Text);
DAOHoaDon a = new DAOHoaDon();
DAOChiTietHoaDon DCT = new DAOChiTietHoaDon();
a.DatHang(hd);
int mahoadon = a.getCurrentMahoadon(Globals.Maban);
for (int i = 0; i < dtg_chitiet.Rows.Count - 1; i++)
{
int soluong = int.Parse(dtg_chitiet.Rows[i].Cells[2].Value.ToString());
ChiTietHoaDon ct = new ChiTietHoaDon();
if (soluong != 0)
{
ct.Mahoadon = mahoadon;
ct.Mamonan = int.Parse(dtg_chitiet.Rows[i].Cells[0].Value.ToString());
ct.Soluong = soluong;
DCT.Themvaochitiethoadon(ct);
}
}
MessageBox.Show("Dat hang thanh cong");
Globals.SetMahoadon(mahoadon);
DAOTable tb = new DAOTable();
tb.UpdatetableStatus(Globals.Maban, 0);
}
catch (SqlException oke)
{
MessageBox.Show(oke.Message);
}
}
private void Bt_Click(object sender, EventArgs e)
{
Button bt = sender as Button;
object a = bt.Tag;
Globals.SetMaban(Convert.ToInt32(a));
frmdatdonhang frm = new frmdatdonhang();
DAOHoaDon hd = new DAOHoaDon();
// kt xem ban co dang su dung hay ko
DAOTable ban = new DAOTable();
DAOChiTietHoaDon ct = new DAOChiTietHoaDon();
if (ban.KTBanDangSD(Globals.Maban))
{
Globals.SetMahoadon(hd.getCurrentMahoadon(Globals.Maban));
Globals.SetChiTietHoaDon(ct.getChiTietHoaDon(Globals.Mahoadon));
}
frm.Show();
frm.FormClosed += Frm_FormClosed;
}
//197, 57, 248 DarkCyan 254, 122, 162
public void createButton()
{
List <Table> tableList = new List <Table>();
DAOTable a = new DAOTable();
tableList = a.LoadTable();
foreach (Table item in tableList)
{
Button bt = new Button()
{
Width = 120,
Height = 120,
Image = Properties.Resources.icon_table,
FlatStyle = FlatStyle.Flat
};
bt.FlatAppearance.BorderSize = 0;
switch (item.TableStatus1)
{
case "Available":
bt.BackColor = Color.FromArgb(89, 121, 254);
bt.Text = item.Tenban;
//bt.Text = item.Tenban + Environment.NewLine + item.TableStatus1;
break;
default:
bt.BackColor = Color.FromArgb(196, 57, 248);
bt.Text = item.Tenban;
//bt.Text = item.Tenban + Environment.NewLine + item.TableStatus1;
break;
}
bt.Tag = item.Maban;
bt.Click += Bt_Click;
flp.Controls.Add(bt);
}
}
