public bool ThemPhieuCheckIn(PhieuCheckIn_Ent phieucheckin_ent)
{
Phong phongID = db.Phongs.Where(n => n.id_Phong == phieucheckin_ent.Id_Phong && n.tinh_trang == 1).SingleOrDefault();
if (phongID != null)
{
return(false);
}
try
{
PhieuCheck_In p = new PhieuCheck_In();
p.id_phieu_checkin = phieucheckin_ent.Id_phieu_checkin;
//p.id_DichVu = phieucheckin_ent.Id_DichVu;
p.id_khach = phieucheckin_ent.Id_khach;
p.id_Phong = phieucheckin_ent.Id_Phong;
p.id_NhanVien = phieucheckin_ent.Id_NhanVien;
p.giam_gia = phieucheckin_ent.Giam_gia;
p.ngay_check_in = phieucheckin_ent.Ngay_check_in;
p.ngay_check_out = phieucheckin_ent.Ngay_check_out;
p.gio_check_in = phieucheckin_ent.Gio_check_in;
p.gio_check_out = phieucheckin_ent.Gio_check_out;
p.soLuongDichVu = phieucheckin_ent.SoLuongDichVu;
p.soLuongKhach = phieucheckin_ent.SoLuongKhach;
p.TrangThaiPhieuCK = 0;
db.PhieuCheck_Ins.InsertOnSubmit(p);
db.SubmitChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
public bool CapNhatKhachHang(KhachHang_Ent kh_ent)
{
KhachHang kh = db.KhachHangs.Where(n => n.id_khach.Equals(kh_ent.Id_khach)).SingleOrDefault();
if (kh == null)
{
return(false);
}
try
{
kh.ho = kh_ent.Ho;
kh.ten = kh_ent.Ten;
kh.date_of_birth = kh_ent.Date_of_birth;
kh.so_cmnd = kh_ent.So_cmnd;
kh.so_dien_thoai = kh_ent.Sodienthoai;
if (kh_ent.Gioi_tinh == "nam")
{
kh.gioi_tinh = 1;
}
if (kh_ent.Gioi_tinh == "nu")
{
kh.gioi_tinh = 0;
}
kh.quoc_tich = kh_ent.Quoc_tich;
db.SubmitChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
public bool CapNhatDichVu(DichVu_Ent dv_ent)
{
DichVu dv = db.DichVus.Where(n => n.id_DichVu.Equals(dv_ent.Id_DichVu)).SingleOrDefault();
LoaiDichVu loaiDV = db.LoaiDichVus.Where(n => n.ten_loai_dich_vu.Equals(dv_ent.TenLoaiDichVu)).SingleOrDefault();
if (dv == null)
{
return(false);
}
if (loaiDV == null)
{
try
{
LoaiDichVu ldv = new LoaiDichVu();
ldv.ten_loai_dich_vu = dv_ent.TenLoaiDichVu;
db.LoaiDichVus.InsertOnSubmit(ldv);
db.SubmitChanges();
}
catch
{
return(false);
}
}
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.LoaiDichVus);
try
{
dv.ten_dich_vu = dv_ent.TenDichVu;
dv.gia_dich_vu = dv_ent.DonGia;
dv.id_loai_dich_vu = db.LoaiDichVus.Where(n => n.ten_loai_dich_vu.Equals(dv_ent.TenLoaiDichVu)).SingleOrDefault().id_LoaiDichVu;
db.SubmitChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
public bool CapNhatPhong(Phong_Ent phong_ent)
{
Phong p = db.Phongs.Where(n => n.id_Phong.Equals(phong_ent.Id_Phong)).SingleOrDefault();
if (p == null)
{
return(false);
}
try
{
p.id_loai_phong = Convert.ToInt32(phong_ent.Id_loai_phong);
p.ghi_chu = phong_ent.Ghi_chu;
p.so_luong_nguoi = phong_ent.So_luong_nguoi;
p.so_Phong = phong_ent.So_Phong;
p.tang = phong_ent.Tang;
db.SubmitChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
public bool ThemNhanVien(NhanVien_Ent nv_ent, string matKhau)
{
NhanVien nv;
NhanVien NVTestEmail = db.NhanViens.Where(n => n.email.Equals(nv_ent.Email)).SingleOrDefault();
if (NVTestEmail != null)
{
return(false);
}
try
{
nv = new NhanVien();
nv.ho = nv_ent.Ho;
nv.ten = nv_ent.Ten;
if (nv_ent.GioiTinh == "nam")
{
nv.gioi_tinh = 1;
}
if (nv_ent.GioiTinh == "nu")
{
nv.gioi_tinh = 0;
}
nv.ngay_sinh = nv_ent.NgaySinh;
if (nv_ent.ChucVu == "nhanvien")
{
nv.chuc_vu = 2;
}
if (nv_ent.ChucVu == "quanly")
{
nv.chuc_vu = 1;
}
if (nv_ent.CaLamViec == "sang")
{
nv.ca_lam_viec = 1;
}
if (nv_ent.CaLamViec == "chieu")
{
nv.ca_lam_viec = 2;
}
if (nv_ent.CaLamViec == "toi")
{
nv.ca_lam_viec = 3;
}
nv.email = nv_ent.Email;
nv.mat_khau = matKhau;
db.NhanViens.InsertOnSubmit(nv);
db.SubmitChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
