public static bool UpdateDichVuPhong(DichVuPhongDTO dichVuPhongDTO)
{
try
{
DataProvider.ExecuseNonQuery("UPDATE quanlykaraoke.dichvuphong SET quanlykaraoke.dichvuphong.SoLuong = '" + dichVuPhongDTO.SoLuong + "', quanlykaraoke.dichvuphong.Gia ='" + dichVuPhongDTO.DonGia + "' WHERE quanlykaraoke.dichvuphong.MaDVP = '" + dichVuPhongDTO.MaDVP + "';");
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static bool LuuThongTinDichVuPhong(DichVuPhongDTO dichVuPhongDTO)
{
try
{
StringBuilder strSQL = new StringBuilder("INSERT INTO quanlykaraoke.dichvuphong (MaDVP, MaThuePhong, MaDV , ThoiGian, SoLuong, Gia) VALUES('$0','$1','$2','$3','$4','$5')");
strSQL.Replace("$0", dichVuPhongDTO.MaDVP.ToString());
strSQL.Replace("$1", dichVuPhongDTO.MaThuePhong.ToString());
strSQL.Replace("$2", dichVuPhongDTO.MaDV.ToString());
strSQL.Replace("$3", dichVuPhongDTO.ThoiGian.ToString("yyyy-MM-dd HH:mm:ss.fff"));
strSQL.Replace("$4", dichVuPhongDTO.SoLuong.ToString());
strSQL.Replace("$5", dichVuPhongDTO.DonGia.ToString());
DAL.DataProvider.ExecuseNonQuery(strSQL.ToString());
return(true);
}
catch (Exception e)
{
return(false);
}
}
public void RefreshDataBinding(ThuePhongDTO thuePhongDTO, KhachHangDTO khachHangDTO)
{
txtTienGio.ReadOnly = false;
gridView1.OptionsBehavior.ReadOnly = false;
this.thuePhong = thuePhongDTO;
txtGioVao.Time = thuePhong.GioThuePhong;
txtGioRa.Time = (thuePhong.GioTraPhong == DateTime.MinValue) ?DateTime.Now : thuePhong.GioTraPhong;
thuePhong.GioTraPhong = txtGioRa.Time;
listKhuyenMai = new Dictionary <int, DichVuPhongDTO>();
RefreshDataBindingTienGio();
loaiKhachHang = LoaiKhachHangBUS.LayLoaiKhachHang(khachHangDTO);
DichVuPhongDTO dichVuPhongDTO;
//Kiểm tra các ngày đặt biệt
foreach (DTO.ThongTinThanhToanTheoNgay ngay in ThanhToanBUS.TinhTienThuePhong(thuePhong, DateTime.Now).listThongTin)
{
//Sinh nhật
if (ngay.ngay.date.Day == khachHangDTO.NgaySinh.Day && ngay.ngay.date.Month == khachHangDTO.NgaySinh.Month && khachHangDTO.MaKH != 0)
{
if (TongTienGio * loaiKhachHang.PhanTramGiamGiaSinhNhat > loaiKhachHang.SoTienGiamGiaSinhNhat_Max)
{
dichVuPhongDTO = new DichVuPhongDTO(-1, thuePhong.MaThuePhong, 1, DateTime.Now, 1.0, -loaiKhachHang.SoTienGiamGiaSinhNhat_Max);
}
else if ((TongTienGio * loaiKhachHang.PhanTramGiamGiaSinhNhat < loaiKhachHang.SoTienGiamGiaSinhNhat_Min))
{
dichVuPhongDTO = new DichVuPhongDTO(-1, thuePhong.MaThuePhong, 1, DateTime.Now, 1.0, -loaiKhachHang.SoTienGiamGiaSinhNhat_Min);
}
else
{
dichVuPhongDTO = new DichVuPhongDTO(-1, thuePhong.MaThuePhong, 1, DateTime.Now, 1.0, -(TongTienGio * loaiKhachHang.PhanTramGiamGiaSinhNhat));
}
if (dichVuPhongDTO.DonGia != 0)
{
listKhuyenMai.Add(dichVuPhongDTO.MaDVP, dichVuPhongDTO);
}
}
}
//KM Loại KH
if (TongTienGio * loaiKhachHang.PhanTramGiamGia > loaiKhachHang.SoTienGiamGia_Max)
{
dichVuPhongDTO = new DichVuPhongDTO(-(listKhuyenMai.Count + 1), thuePhong.MaThuePhong, 2, DateTime.Now, 1.0, -loaiKhachHang.SoTienGiamGia_Max);
}
else if ((TongTienGio * loaiKhachHang.PhanTramGiamGia < loaiKhachHang.SoTienGiamGia_Min))
{
dichVuPhongDTO = new DichVuPhongDTO(-(listKhuyenMai.Count + 1), thuePhong.MaThuePhong, 2, DateTime.Now, 1.0, -loaiKhachHang.SoTienGiamGia_Min);
}
else
{
dichVuPhongDTO = new DichVuPhongDTO(-(listKhuyenMai.Count + 1), thuePhong.MaThuePhong, 2, DateTime.Now, 1.0, -(TongTienGio * loaiKhachHang.PhanTramGiamGia));
}
if (dichVuPhongDTO.DonGia != 0 && khachHangDTO.MaKH != 0)
{
listKhuyenMai.Add(dichVuPhongDTO.MaDVP, dichVuPhongDTO);
}
RefreshDataBindingDichVuPhong();
}
public static void UpdateDichVuPhong(DichVuPhongDTO dichVuPhongDTO)
{
DichVuPhongDAL.UpdateDichVuPhong(dichVuPhongDTO);
}
public static bool LuuThongTinDichVuPhong(DichVuPhongDTO dichVuPhongDTO)
{
return(DichVuPhongDAL.LuuThongTinDichVuPhong(dichVuPhongDTO));
}
