private void LoadBanAn()
{
tableList = BanAn_DAO.LayBanAn();
for (int i = 0; i < tableList.Count; i++)
{
Button btn = new Button()
{
Width = BanAn_DAO.tableWidth, Height = BanAn_DAO.tableHeight
};
btn.Image = Properties.Resources.icons8_tableware_48px;
btn.ImageAlign = ContentAlignment.BottomCenter;
btn.Text = Environment.NewLine + tableList[i].TenBan;
btn.Font = new Font("Arial", 11, FontStyle.Bold);
btn.TextAlign = ContentAlignment.TopCenter;
btn.Click += btn_Click;
btn.Tag = tableList[i];
switch (tableList[i].TrangThai)
{
case "Trống":
btn.BackColor = Color.White;
break;
case "Bận":
btn.BackColor = Color.Aqua;
break;
}
flpSoDoBan.Controls.Add(btn);
}
}
public void Add(int i)
{
mTBNgay.Clear();
List<BanAn_DTO> tableList = BanAn_DAO.LayBanAn();
txtBan.Text = tableList[i].TenBan;
if (tableList[i].TrangThai == "Có Người")
{
mTBNgay.Text = tableList[i].Ngay;
}
else
{
mTBNgay.Text = "00/00/0000";
}
txtTT.Text = tableList[i].TrangThai;
}
public static List <BanAn_DTO> TimBanAn(string tenBanAn)
{
return(BanAn_DAO.TimBanAn(tenBanAn));
}
public static bool SuaBanAn(BanAn_DTO banAn)
{
return(BanAn_DAO.SuaBanAn(banAn));
}
public static bool XoaBanAn(BanAn_DTO banAn)
{
return(BanAn_DAO.XoaBanAn(banAn));
}
/*public static bool SuaTrangThaiBanAn(int idBan)
* {
* return BanAn_DAO.SuaTrangThaiBanAn(idBan);
* }
*
* public static bool SuaTrangThaiBanAn2(int idBan)
* {
* return BanAn_DAO.SuaTrangThaiBanAn2(idBan);
* }*/
public static bool ThemBanAn(BanAn_DTO banAn)
{
return(BanAn_DAO.ThemBanAn(banAn));
}
public static List <BanAn_DTO> LoadBanAn()
{
return(BanAn_DAO.LayBanAn());
}
public static int layIDBanAn(string tenBanAn)
{
return(BanAn_DAO.layIDBanAn(tenBanAn));
}
public static int CapNhatBanAn(BanAn_DTO BanAn)
{
return(BanAn_DAO.CapNhatBanAn(BanAn));
}
public static int XoaBanAn(string maBan)
{
return(BanAn_DAO.XoaBanAn(maBan));
}
public static int ThemBanAn(BanAn_DTO BanAn, string maNH)
{
return(BanAn_DAO.ThemBanAn(BanAn, maNH));
}
public static DataTable DocBanAn(String maNH)
{
return(BanAn_DAO.DocBanAn(maNH));
}
public static void UpdateTrangThaiBanAn(int maban, int trangthai)
{
BanAn_DAO dao = new BanAn_DAO();
dao.UpdateTrangThaiBanAn(maban, trangthai);
}
public static List <BanAn_DTO> selectBanAnTheoTrangThai(int trangthai, int manh, int mode)
{
BanAn_DAO bananDAO = new BanAn_DAO();
return(bananDAO.SelectBanAnTheoTrangThai(trangthai, manh, mode));
}
public static bool SuaTrangThaiBanAn2(int idBan)
{
return(BanAn_DAO.SuaTrangThaiBanAn2(idBan));
}
