public bool ThemThongTinVaoCT_HD(int maHoaDon, Bang_DS_DatPhong phieuDat)
{
try
{
var thongTinCT_DP = db.CT_DatPhong.Find(phieuDat.MaDatPhong);
ChiTietHoaDon bienTam = new ChiTietHoaDon();
bienTam.MaPhong = thongTinCT_DP.MaPhong;
bienTam.MaHoaDon = maHoaDon;
bienTam.SoNguoi = Convert.ToInt32(phieuDat.SoNguoi);
bienTam.NgayBatDau = phieuDat.NgayBD;
bienTam.NgayKetThuc = phieuDat.NgayKT;
bienTam.Gia = thongTinCT_DP.TongGia;
bienTam.NgayLap = DateTime.Now;
db.ChiTietHoaDons.Add(bienTam);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public int ThemThongTinKhach(Bang_DS_DatPhong thongTin)
{
List <KhachHang> TimKiemKhachTheoSDT = db.KhachHangs.Where(x => x.SDT == thongTin.SDT).ToList();
if (TimKiemKhachTheoSDT.Count != 0)
{
var TimPhieuDatPhong = db.Bang_DS_DatPhongs.Find(thongTin.MaDatPhong);
TimPhieuDatPhong.TinhTrang = "Success";
db.SaveChanges();
return(TimKiemKhachTheoSDT[0].MaKhachHang);
}
else
{
KhachHang bienTam = new KhachHang();
bienTam.TenKhachHang = thongTin.HoTen;
bienTam.SDT = thongTin.SDT;
bienTam.GioiTinh = thongTin.GioiTinh;
bienTam.DiaChi = thongTin.DiaChi;
bienTam.Email = thongTin.Email;
db.KhachHangs.Add(bienTam);
db.SaveChanges();
var TimPhieuDatPhong = db.Bang_DS_DatPhongs.Find(thongTin.MaDatPhong);
TimPhieuDatPhong.TinhTrang = "Success";
db.SaveChanges();
return(bienTam.MaKhachHang);
}
}
public int DatPhongMoi(Bang_DS_DatPhong ma)
{
ma.NgayDat = DateTime.Now;
ma.TinhTrang = "Dang Cho";
db.Bang_DS_DatPhongs.Add(ma);
db.SaveChanges();
return(ma.MaDatPhong);
}
public int ThemThongTinVaoHoaDon(Bang_DS_DatPhong phieuDat, int MaKhach)
{
try
{
HoaDon BienTam = new HoaDon();
BienTam.MaKhachHang = MaKhach;
BienTam.NgayLap = DateTime.Now;
BienTam.TongTien = phieuDat.CT_DatPhong.TongGia;
BienTam.TinhTrang = "Run";
db.HoaDons.Add(BienTam);
db.SaveChanges();
return(BienTam.MaHoaDon);
}
catch (Exception ex)
{
return(-1);
}
}
public ActionResult DatPhongMoi(Bang_DS_DatPhong lh, int maPhong)
{
if (lh.NgayBD >= DateTime.Now.Date && lh.NgayBD <= lh.NgayKT)
{
var dao = new DatPhongDao();
int id = dao.DatPhongMoi(lh);
var result = dao.ThemGiaTriVaoCT_Phong(id, maPhong);
if (result)
{
SetAlert("Thêm thành công", "success");
return(RedirectToAction("DanhSachDatPhong", "DatPhong"));
}
else
{
SetAlert("Dữ liệu không hợp lý mời xem lại", "error");
return(RedirectToAction("DatPhongMoi", "DatPhong"));
}
}
SetAlert("Dữ liệu không hợp lý mời xem lại", "error");
return(RedirectToAction("DatPhongMoi", "DatPhong"));
}
public ActionResult Bang_DS_DatPhong(Bang_DS_DatPhong dp)
{
Session[CommonConstants.BangDPSesstion] = dp.MaDatPhong;
return(RedirectToAction("ChonPhong", "Phong"));
}
