public static bool CheckTiecCuoiExist(string maTiecCuoi, string ngayDaiTiecSqlFormat, string maCa, string maSanh)
{
if (DAO_QuanLyTiecCuoi.CountTiecCuoi(maTiecCuoi, ngayDaiTiecSqlFormat, maCa, maSanh) > 0)
{
return(true);
}
return(false);
}
public static void GetDataPhieuBanAn(string maTiecCuoi, out string soLuongBan, out string soLuongBanDuTru, out DataTable danhSachMonAn)
{
using (DataTable dt = DAO_QuanLyTiecCuoi.GetRowPhieuDatBan(maTiecCuoi))
{
soLuongBan = dt.Rows[0].ItemArray[0].ToString();
soLuongBanDuTru = dt.Rows[0].ItemArray[1].ToString();
}
danhSachMonAn = DAO_QuanLyTiecCuoi.GetTableMonAnDonGiaDGTT(maTiecCuoi);
}
public static List <string> GetListMonAn(string maHD)
{
DataTable dt = DAO_QuanLyTiecCuoi.GetColumnMonAn(maHD);
List <string> list = new List <string>();
foreach (DataRow dr in dt.Rows)
{
list.Add(dr["TenMonAn"].ToString());
}
return(list);
}
static public void Init()
{
_ListMaCa = new List <string>();
_ListTenCa = new List <string>();
_ListMaSanh = new List <string>();
_ListTenSanh = new List <string>();
_ListSoLuongBanToiDa = new List <int>();
DataTable dtCa = DAO_QuanLyTiecCuoi.GetTableCa();
foreach (DataRow row in dtCa.Rows)
{
_ListMaCa.Add(row["MaCa"].ToString());
_ListTenCa.Add(row["TenCa"].ToString());
}
DataTable dtSanh = DAO_QuanLyTiecCuoi.GetTableSanh();
foreach (DataRow row in dtSanh.Rows)
{
_ListMaSanh.Add(row["MaSanh"].ToString());
_ListSoLuongBanToiDa.Add(int.Parse(row["SoLuongBanToiDa"].ToString()));
_ListTenSanh.Add(row["TenSanh"].ToString());
}
_ListMaMonAn = new List <string>(); _ListTenMonAn = new List <string>();
_ListDonGiaMonAn = new List <string>(); _ListHinhAnhMonAn = new List <string>();
using (DataTable dt = DAO_QuanLyTiecCuoi.GetTableMonAn())
{
foreach (DataRow row in dt.Rows)
{
_ListMaMonAn.Add(row["MaMonAn"].ToString());
_ListTenMonAn.Add(row["TenMonAn"].ToString());
_ListDonGiaMonAn.Add(row["DonGia"].ToString());
_ListHinhAnhMonAn.Add(row["HinhAnh"].ToString());
}
}
_ListMaDichVu = new List <string>(); _ListTenDichVu = new List <string>();
_ListDonGiaDichVu = new List <string>(); _ListHinhAnhDichVu = new List <string>();
using (DataTable dt = DAO_QuanLyTiecCuoi.GetTableDichVu())
{
foreach (DataRow row in dt.Rows)
{
_ListMaDichVu.Add(row["MaDichVu"].ToString());
_ListTenDichVu.Add(row["TenDichVu"].ToString());
_ListDonGiaDichVu.Add(row["DonGia"].ToString());
_ListHinhAnhDichVu.Add(row["HinhAnh"].ToString());
}
}
}
static BUS_QuanLyTiecCuoi()
{
DataTable dt = DAO_QuanLyTiecCuoi.GetTableMonAn();
foreach (DataRow dr in dt.Rows)
{
_listMaMonAn.Add(dr["MaMonAn"].ToString());
_listTenMonAn.Add(dr["TenMonAn"].ToString());
}
dt = DAO_QuanLyTiecCuoi.GetTableDichVu();
foreach (DataRow dr in dt.Rows)
{
_listMaDichVu.Add(dr["MaDichVu"].ToString());
_listTenDichVu.Add(dr["TenDichVu"].ToString());
}
}
public static void DeleteTiecCuoi(string MaHD)
{
DAO_QuanLyTiecCuoi.DeleteTiecCuoi(MaHD);
}
public static DataTable GetTableDanhSachTiecCuoi()
{
return(DAO_QuanLyTiecCuoi.GetTableDanhSachTiecCuoi());
}
//public static int GetIndexListMaCa(string maCa)
//{
// return _ListMaCa.IndexOf(maCa);
//}
//public static int GetIndexListMaSanh(string maSanh)
//{
// return _ListMaSanh.IndexOf(maSanh);
//}
// Tra ve false neu khong tim thay MaTiecCuoi trong TIECCUOI
public static bool DeleteTiecCuoi(string maTiecCuoi)
{
return(DAO_QuanLyTiecCuoi.DeleteTiecCuoi(maTiecCuoi));
}
public static void InsertDichVu(int maTiecCuoi, string maDichVu, string donGiaTT, string soLuong)
{
DAO_QuanLyTiecCuoi.InsertDichVu(maTiecCuoi, maDichVu, donGiaTT, soLuong);
}
public static void DeleteDichVu(int maTiecCuoi)
{
DAO_QuanLyTiecCuoi.DeleteDichVu(maTiecCuoi);
}
public static void InsertMonAn(int maPhieuDatBan, string maMonAn, string donGiaThucTe)
{
DAO_QuanLyTiecCuoi.InsertMonAn(maPhieuDatBan, maMonAn, donGiaThucTe);
}
public static int GetMaPhieuDatBan(int maTiecCuoi)
{
DataTable dt = DAO_QuanLyTiecCuoi.GetMaPhieuDatBan(maTiecCuoi);
return(int.Parse(dt.Rows[0].ItemArray[0].ToString()));
}
public static void UpdatePhieuDatBan(int maTiecCuoi, string soLuongBan, string soLuongBanDT, decimal donGiaBan)
{
DAO_QuanLyTiecCuoi.UpdatePhieuDatBan(maTiecCuoi, soLuongBan, soLuongBanDT, donGiaBan);
}
public static void DeleteMonAn(int maTiecCuoi)
{
DAO_QuanLyTiecCuoi.DeleteMonAn(maTiecCuoi);
}
public static void UpdateTiecCuoi(DTO_TiecCuoi tiecCuoi)
{
DAO_QuanLyTiecCuoi.UpdateTiecCuoi(tiecCuoi);
}
public static object GetDataPhieuDichVu(string maTiecCuoi)
{
return(DAO_QuanLyTiecCuoi.GetTablePhieuDichVu(maTiecCuoi));
}
