public static DataTable GetData(DTO_TraCuu traCuu)
{
string query = String.Format(@"SELECT TIECCUOI.TenChuRe AS 'Tên chú rể', TIECCUOI.TenCoDau AS 'Tên cô dâu', SANH.TenSanh AS 'Sảnh', TIECCUOI.NgayDaiTiec AS 'Ngày đãi tiệc', CA.TenCa AS 'Ca', PHIEUDATBAN.SoBan AS 'Số bàn'
FROM (((TIECCUOI INNER JOIN SANH ON TIECCUOI.MaSanh = SANH.MaSanh)
INNER JOIN Ca ON TIECCUOI.MaCa = CA.MaCa) INNER JOIN PHIEUDATBAN ON TIECCUOI.MaTiecCuoi = PHIEUDATBAN.MaTiecCuoi)");
return DatabaseHelper.GetData(query);
}
public static DataTable TraCuuTenChuRe(DTO_TraCuu traCuu)
{
string query = String.Format(@"SELECT TIECCUOI.TenChuRe AS 'Tên chú rể', TIECCUOI.TenCoDau AS 'Tên cô dâu', TIECCUOI.DienThoai AS 'Số ĐT', SANH.TenSanh AS 'Sảnh', TIECCUOI.NgayDaiTiec AS 'Ngày đãi tiệc', CA.TenCa AS 'Ca', PHIEUDATBAN.SoBan AS 'Số bàn'
FROM (((TIECCUOI INNER JOIN SANH ON TIECCUOI.MaSanh = SANH.MaSanh)
INNER JOIN Ca ON TIECCUOI.MaCa = CA.MaCa)
INNER JOIN PHIEUDATBAN ON TIECCUOI.MaTiecCuoi = PHIEUDATBAN.MaTiecCuoi)
WHERE dbo.BoDau(TIECCUOI.TenChuRe) LIKE N'%{0}%'", traCuu.key);
return(DatabaseHelper.GetData(query));
}
public GUI_TraCuu()
{
InitializeComponent();
TraCuu_BUS = new BUS_TraCuu();
TraCuu_DTO = new DTO_TraCuu();
cmbTinhTrang.SelectedIndex = 0;
cmbLoaiPhong.SelectedIndex = 3;
rbtnNgayThue.Checked = true;
rbtnNgayTra.Checked = true;
rbtnThangBaoCao.Checked = true;
cmbNamPT.SelectedIndex = 0;
cmbNamHD.SelectedIndex = 0;
cmbNamBC.SelectedIndex = 0;
}
public static DataTable TraCuuDichVu(DTO_TraCuu key)
{
return(DAO_TraCuu.TraCuuDichVu(key));
}
public static DataTable TraCuuMonAn(DTO_TraCuu key)
{
return(DAO_TraCuu.TraCuuMonAn(key));
}
public static DataTable TraCuuNgay(DTO_TraCuu key)
{
return(DAO_TraCuu.TraCuuNgay(key));
}
public static DataTable TraCuuSoDT(DTO_TraCuu key)
{
return(DAO_TraCuu.TraCuuSoDT(key));
}
public static DataTable TraCuuTenCoDau(DTO_TraCuu key)
{
return(DAO_TraCuu.TraCuuTenCoDau(key));
}
public static DataTable GetData(DTO_TraCuu key)
{
return(DAO_TraCuu.GetData(key));
}
public static DataTable TraCuuDichVu(DTO_TraCuu traCuu)
{
string query = String.Format(@"SELECT * FROM DICHVU WHERE dbo.BoDau(TenDichVu) LIKE N'%{0}%'", traCuu.key);
return(DatabaseHelper.GetData(query));
}
public static DataTable TraCuuMonAn(DTO_TraCuu traCuu)
{
string query = String.Format(@"SELECT * FROM MONAN WHERE dbo.BoDau(TenMonAn) LIKE N'%{0}%'", traCuu.key);
return(DatabaseHelper.GetData(query));
}
