public void Xoa(int id)
{
DK_Customer kh = this.DK_Customers.FirstOrDefault(c => c.Id == id);
this.DK_Customers.Remove(kh);
this.SaveChanges();
}
public void Edit(DK_Customer cus)
{
DK_Customer kh = this.DK_Customers.FirstOrDefault(c => c.Id == cus.Id);
var list = this.DK_Customers;
if (cus.Daidien == true)
{
foreach (var item in list.ToList())
{
if (item.Daidien == true && item.Sophong == cus.Sophong)
{
item.Daidien = false;
}
}
}
kh.Daidien = cus.Daidien;
kh.CMND = cus.CMND;
kh.Hoten = cus.Hoten;
kh.Gioitinh = cus.Gioitinh;
kh.Quoctich = cus.Quoctich;
kh.DateCheckin = cus.DateCheckin;
kh.GioCheckin = cus.GioCheckin;
kh.DateCheckout = cus.DateCheckout;
kh.GioCheckout = cus.GioCheckout;
kh.Ghichu = cus.Ghichu;
this.SaveChanges();
}
public void NewCustomer(DK_Customer cus)
{
var list = this.DK_Customers.ToList();
this.DK_Customers.Add(cus);
if (cus.Daidien == true)
{
foreach (var item in list)
{
if (item.Daidien == true && cus.Daidien == true && item.Sophong == cus.Sophong)
{
item.Daidien = false;
}
}
}
this.SaveChanges();
}
public void EditCustomer(DK_Customer cus)
{
DK_CustomerDAO.Instance.Edit(cus);
}
public void NewCustomer(DK_Customer cus)
{
DK_CustomerDAO.Instance.NewCustomer(cus);
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (t == 0)
{
if (txtCmnd.Text == "")
{
MessageBox.Show("CMND không được để trống!");
return;
}
var list = db.DK_Customers.ToList();
DK_Customer khachhang = new DK_Customer();
Khach khach = new Khach();
//khachhang.Id = k;
khachhang.Id = Convert.ToInt32(gvDataCheckin.GetRowCellValue(gvDataCheckin.FocusedRowHandle, "Id"));
khachhang.CMND = txtCmnd.Text.ToString().Trim();
khachhang.Hoten = txtHoten.Text.ToString().Trim();
khachhang.Quoctich = Convert.ToInt32(lookUpEditQuoctich.EditValue);
if (cbGioitinh.Checked == true)
{
khachhang.Gioitinh = true;
}
else
{
khachhang.Gioitinh = false;
}
if (cbDaidien.Checked == true)
{
khachhang.Daidien = true;
}
else
{
khachhang.Daidien = false;
}
khachhang.DateCheckin = Convert.ToDateTime(dateEditCheckin.EditValue);
khachhang.GioCheckin = txtGioCheckin.Text.ToString().Trim();
khachhang.DateCheckout = Convert.ToDateTime(dateEditCheckout.EditValue);
khachhang.GioCheckout = txtGioCheckout.Text.ToString().Trim();
khachhang.Ghichu = memoEditGhichu.Text.ToString().Trim();
khachhang.Sophong = Convert.ToInt32(labPhong.Text);
khach.DonVi = "Khách hàng";
khach.SoCMND = khachhang.CMND;
khach.HoTen = khachhang.Hoten;
khach.MaQT = khachhang.Quoctich;
khach.GioiTnh = khachhang.Gioitinh;
khach.MaBank = "";
khach.NgaySinh = Convert.ToDateTime("01-01-1900");
khach.Phone = "";
khach.SoATM = 0;
khach.GhiChu = "";
db.DK_Customers.Add(khachhang);
if (otp == 1)
{
KhachHangBUS.Instance.NewKhachHang(khach);
var idkh = db.Khach.OrderByDescending(m => m.Id).First();
khachhang.IdKH = idkh.Id;
DK_CustomerBUS.Instance.NewCustomer(khachhang);
DK_CustomerBUS.Instance.Xem(gcDataCheckin, Convert.ToInt32(labPhong.Text));
MessageBox.Show("Thêm thành công!");
gcDataCheckin.Enabled = true;
btnThemnguoi.Enabled = true;
sodophong = new Sodophong();
Thongtin_Load(sender, e);
GetData data = new GetData(sodophong.PostData);
data(list);
otp = 0;
btnDelete.Enabled = true;
}
else
{
khach.Id = idkh;
DK_CustomerBUS.Instance.EditCustomer(khachhang);
KhachHangBUS.Instance.EditKhachHang(khach);
DK_CustomerBUS.Instance.Xem(gcDataCheckin, Convert.ToInt32(labPhong.Text));
MessageBox.Show("Sửa thành công!");
gcDataCheckin.Enabled = true;
btnThemnguoi.Enabled = true;
}
}
else if (t == 1)
{
if (gvListDichvu.DataSource != null)
{
for (int i = 0; i < gvListDichvu.RowCount; i++)
{
int id = Convert.ToInt32(gvListDichvu.GetRowCellValue(i, gvListDichvu.Columns[0]));
var pdv = db.PhongDVs.FirstOrDefault(c => c.Id == id);
if (pdv.Soluong > Convert.ToInt32(gvListDichvu.GetRowCellValue(i, gvListDichvu.Columns[6])))
{
pdv.Soluong = pdv.Soluong - Convert.ToInt32(gvListDichvu.GetRowCellValue(i, gvListDichvu.Columns[6]));
if (pdv.Loaitien == "VNĐ")
{
pdv.Thanhtien = pdv.Soluong * pdv.DonGia;
}
else
{
pdv.Thanhtien = pdv.Soluong * pdv.DonGia * pdv.Tygia;
}
var dv = db.DichVu.FirstOrDefault(c => c.MaDV == pdv.MaDV);
dv.SoLuong += Convert.ToInt32(gvListDichvu.GetRowCellValue(i, gvListDichvu.Columns[6]));
db.SaveChanges();
}
else if (pdv.Soluong < Convert.ToInt32(gvListDichvu.GetRowCellValue(i, gvListDichvu.Columns[6])))
{
pdv.Soluong = pdv.Soluong + Convert.ToInt32(gvListDichvu.GetRowCellValue(i, gvListDichvu.Columns[6]));
if (pdv.Loaitien == "VNĐ")
{
pdv.Thanhtien = pdv.Soluong * pdv.DonGia;
}
else
{
pdv.Thanhtien = pdv.Soluong * pdv.DonGia * pdv.Tygia;
}
var dv = db.DichVu.FirstOrDefault(c => c.MaDV == pdv.MaDV);
dv.SoLuong -= Convert.ToInt32(gvListDichvu.GetRowCellValue(i, gvListDichvu.Columns[6]));
db.SaveChanges();
}
}
}
if (gcBaothuc.DataSource != null)
{
for (int i = 0; i < gvBaothuc.RowCount - 1; i++)
{
var id = Convert.ToInt32(gvBaothuc.GetRowCellValue(i, gvBaothuc.Columns[4]));
var bt = db.BaoThuc.Where(m => m.Id == id).Count();
if (bt != 0)
{
var editbt = db.BaoThuc.FirstOrDefault(m => m.Id == id);
editbt.Ngay = Convert.ToDateTime(gvBaothuc.GetRowCellValue(i, gvBaothuc.Columns[0]));
editbt.Gio = gvBaothuc.GetRowCellValue(i, gvBaothuc.Columns[1]).ToString();
editbt.NoiDung = gvBaothuc.GetRowCellValue(i, gvBaothuc.Columns[2]).ToString();
editbt.Lap = gvBaothuc.GetRowCellValue(i, gvBaothuc.Columns[3]).ToString();
db.SaveChanges();
}
else
{
BaoThuc addbt = new BaoThuc();
addbt.IdPhong = Convert.ToInt32(labPhong.Text);
addbt.Ngay = Convert.ToDateTime(gvBaothuc.GetRowCellValue(i, gvBaothuc.Columns[0]));
addbt.Gio = Convert.ToString(gvBaothuc.GetRowCellValue(i, gvBaothuc.Columns[1]));
addbt.NoiDung = Convert.ToString(gvBaothuc.GetRowCellValue(i, gvBaothuc.Columns[2]));
addbt.Lap = Convert.ToString(gvBaothuc.GetRowCellValue(i, gvBaothuc.Columns[3]));
db.BaoThuc.Add(addbt);
db.SaveChanges();
}
}
}
}
else if (t == 4)
{
if (gcSuachua.DataSource != null)
{
for (int i = 0; i < gvSuachua.RowCount - 1; i++)
{
var id = Convert.ToInt32(gvSuachua.GetRowCellValue(i, gvSuachua.Columns[0]));
var sc = db.PhongS.Where(m => m.Id == id).Count();
if (sc != 0)
{
var editsc = db.PhongS.FirstOrDefault(m => m.Id == id);
editsc.MaStatus = ma;
editsc.Tungay = tungay;
editsc.Denngay = denngay;
db.SaveChanges();
}
else
{
PhongS addsc = new PhongS();
addsc.Sophong = Convert.ToInt32(labPhong.Text);
addsc.MaStatus = ma;
addsc.Tungay = tungay;
addsc.Denngay = denngay;
db.PhongS.Add(addsc);
db.SaveChanges();
}
}
}
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
string phong = "";
if (glueDoitac.Text == "")
{
MessageBox.Show("Vui lòng chọn khách hàng hoặc đối tác!");
glueDoitac.Focus();
return;
}
else
{
var idkhach = Convert.ToInt32(glueDoitac.EditValue);
if (t == 1)
{
if (txtSo.Text == "")
{
if (gcDangky.DataSource == null)
{
MessageBox.Show("Vui lòng chọn phòng để đăng ký");
return;
}
Dangky dk = new Dangky();
dk.NgayDK = Convert.ToDateTime(dateNgay.EditValue.ToString());
dk.NgayCheckin = Convert.ToDateTime(dateCheckin.EditValue.ToString());
dk.NgayCheckout = Convert.ToDateTime(dateCheckout.EditValue.ToString());
dk.SotienUT = Convert.ToDouble(tbDattruoc.Text.ToString());
dk.Sokhach = Convert.ToInt32(gvDangky.Columns[2].SummaryItem.SummaryValue);
dk.Sophong = Convert.ToInt32(gvDangky.Columns[3].SummaryItem.SummaryValue);
dk.DaCheckin = false;
dk.Ghichu = tbNoidung.Text.ToString();
dk.HinhthucTT = cbHinhthuc.EditValue.ToString();
dk.Loaitien = cbxLoai.EditValue.ToString();
if (dk.HinhthucTT == "Tiền mặt")
{
dk.SoATM = "";
}
else
{
dk.SoATM = tbSoTK.EditValue.ToString();
}
dk.Tygia = Convert.ToInt32(tbTygia.Text.ToString());
dk.MaBank = glueNganhang.EditValue.ToString();
dk.NgayUT = Convert.ToDateTime(dtDattruoc.EditValue.ToString());
db.Dangky.Add(dk);
db.SaveChanges();
var id = db.Dangky.Where(m => m.DaCheckin == false).OrderByDescending(m => m.Id).First();
for (int j = 0; j < gvDangky.RowCount; j++)
{
GridView dView = gvDangky.GetDetailView(j, 0) as GridView;
if (dView == null)
{
MessageBox.Show("Vui lòng nhập thông tin khách hàng đăng ký!");
return;
}
phong.Trim();
phong += gvDangky.GetRowCellValue(j, gvDangky.Columns[0]).ToString();
if (j < gvDangky.RowCount - 1)
{
phong += ",";
}
DK_Customer dk_khach = new DK_Customer();
Khach khach = new Khach();
DangKyPhong dk_phong = new DangKyPhong();
for (int i = 0; i < dView.RowCount; i++)
{
if (dView.GetRowCellValue(i, dView.Columns[0]) != null && dView.GetRowCellValue(i, dView.Columns[1]) != null)
{
khach.HoTen = dView.GetRowCellValue(i, dView.Columns[1]).ToString();
khach.SoCMND = dView.GetRowCellValue(i, dView.Columns[0]).ToString();
khach.GioiTnh = Convert.ToBoolean(dView.GetRowCellValue(i, dView.Columns[2]));
khach.MaQT = Convert.ToInt32(dView.GetRowCellValue(i, dView.Columns[3]));
khach.NgaySinh = DateTime.Now;
khach.DonVi = "Khách hàng";
if (edtDienThoai.Text == "Nhập số điện thoại")
{
khach.Phone = "";
}
else
{
khach.Phone = edtDienThoai.Text.ToString();
}
db.Khach.Add(khach);
db.SaveChanges();
var idkh = db.Khach.OrderByDescending(m => m.Id).First();
dk_khach.IdDK = id.Id;
dk_khach.IdKH = idkhach;
dk_khach.Hoten = dView.GetRowCellValue(i, dView.Columns[1]).ToString();
dk_khach.CMND = dView.GetRowCellValue(i, dView.Columns[0]).ToString();
dk_khach.Gioitinh = Convert.ToBoolean(dView.GetRowCellValue(i, dView.Columns[2]));
dk_khach.Quoctich = Convert.ToInt32(dView.GetRowCellValue(i, dView.Columns[3]));
dk_khach.Sophong = Convert.ToInt32(gvDangky.GetRowCellValue(j, gvDangky.Columns[0]));
dk_khach.DateCheckin = Convert.ToDateTime(dateCheckin.EditValue.ToString());
dk_khach.DateCheckout = Convert.ToDateTime(dateCheckout.EditValue.ToString());
dk_khach.GioCheckin = DateTime.Now.ToShortTimeString();
dk_khach.GioCheckout = "12:00";
db.DK_Customers.Add(dk_khach);
db.SaveChanges();
dk_phong.IDDK = id.Id;
dk_phong.SoPhong = Convert.ToInt32(gvDangky.GetRowCellValue(j, gvDangky.Columns[0]));
dk_phong.NgayCheckIn = Convert.ToDateTime(dateCheckin.EditValue.ToString());
dk_phong.NgayCheckOut = Convert.ToDateTime(dateCheckout.EditValue.ToString());
dk_phong.LoaiTien = id.Loaitien;
dk_phong.TyGia = id.Tygia;
dk_phong.GhiChu = id.Ghichu;
dk_phong.DaCheckIn = id.DaCheckin;
dk_phong.DonGia = Convert.ToInt32(gvDangky.GetRowCellValue(j, gvDangky.Columns[1]));
db.DangKyPhong.Add(dk_phong);
}
}
}
txtSo.Text = id.ToString();
var update = db.Dangky.FirstOrDefault(m => m.Id == id.Id);
update.Phong = phong.ToString();
db.SaveChanges();
t = 0;
}
else
{
var id = Convert.ToInt32(txtSo.Text);
var dk = db.Dangky.FirstOrDefault(m => m.Id == id);
dk.NgayDK = Convert.ToDateTime(dateNgay.EditValue.ToString());
dk.NgayCheckin = Convert.ToDateTime(dateCheckin.EditValue.ToString());
dk.NgayCheckout = Convert.ToDateTime(dateCheckout.EditValue.ToString());
dk.SotienUT = Convert.ToDouble(tbDattruoc.Text.ToString());
dk.Sokhach = Convert.ToInt32(gvDangky.Columns[2].SummaryItem.SummaryValue);
dk.Sophong = Convert.ToInt32(gvDangky.Columns[3].SummaryItem.SummaryValue);
dk.DaCheckin = false;
dk.Ghichu = tbNoidung.Text.ToString();
dk.HinhthucTT = cbHinhthuc.EditValue.ToString();
dk.Loaitien = cbxLoai.EditValue.ToString();
if (dk.HinhthucTT == "Tiền mặt")
{
dk.SoATM = "";
}
else
{
dk.SoATM = tbSoTK.EditValue.ToString();
}
dk.Tygia = Convert.ToInt32(tbTygia.Text.ToString());
dk.MaBank = glueNganhang.EditValue.ToString();
dk.NgayUT = Convert.ToDateTime(dtDattruoc.EditValue.ToString());
phong = dk.Phong.ToString();
db.SaveChanges();
var dkphong = db.DangKyPhong.Where(m => m.IDDK == id).Count();
if (gvDangky.RowCount > dkphong)
{
for (int j = dkphong; j < gvDangky.RowCount; j++)
{
GridView dView = gvDangky.GetDetailView(j, 0) as GridView;
phong.Trim();
phong += gvDangky.GetRowCellValue(j, gvDangky.Columns[0]).ToString();
if (j < gvDangky.RowCount - 1)
{
phong += ",";
}
DK_Customer dk_khach = new DK_Customer();
Khach khach = new Khach();
DangKyPhong dk_phong = new DangKyPhong();
for (int i = 0; i < dView.RowCount; i++)
{
if (dView.GetRowCellValue(i, dView.Columns[0]) != null && dView.GetRowCellValue(i, dView.Columns[1]) != null)
{
khach.HoTen = dView.GetRowCellValue(i, dView.Columns[1]).ToString();
khach.SoCMND = dView.GetRowCellValue(i, dView.Columns[0]).ToString();
khach.GioiTnh = Convert.ToBoolean(dView.GetRowCellValue(i, dView.Columns[2]));
khach.MaQT = Convert.ToInt32(dView.GetRowCellValue(i, dView.Columns[3]));
khach.NgaySinh = DateTime.Now;
khach.DonVi = "Khách hàng";
if (edtDienThoai.Text == "Nhập số điện thoại")
{
khach.Phone = "";
}
else
{
khach.Phone = edtDienThoai.Text.ToString();
}
db.Khach.Add(khach);
db.SaveChanges();
dk_khach.IdDK = id;
dk_khach.IdKH = idkhach;
dk_khach.Hoten = dView.GetRowCellValue(i, dView.Columns[1]).ToString();
dk_khach.CMND = dView.GetRowCellValue(i, dView.Columns[0]).ToString();
dk_khach.Gioitinh = Convert.ToBoolean(dView.GetRowCellValue(i, dView.Columns[2]));
dk_khach.Quoctich = Convert.ToInt32(dView.GetRowCellValue(i, dView.Columns[3]));
dk_khach.Sophong = Convert.ToInt32(gvDangky.GetRowCellValue(j, gvDangky.Columns[0]));
dk_khach.DateCheckin = Convert.ToDateTime(dateCheckin.EditValue.ToString());
dk_khach.DateCheckout = Convert.ToDateTime(dateCheckout.EditValue.ToString());
dk_khach.GioCheckin = DateTime.Now.ToShortTimeString();
dk_khach.GioCheckout = "12:00";
db.DK_Customers.Add(dk_khach);
db.SaveChanges();
dk_phong.IDDK = id;
dk_phong.SoPhong = Convert.ToInt32(gvDangky.GetRowCellValue(j, gvDangky.Columns[0]));
dk_phong.NgayCheckIn = Convert.ToDateTime(dateCheckin.EditValue.ToString());
dk_phong.NgayCheckOut = Convert.ToDateTime(dateCheckout.EditValue.ToString());
dk_phong.LoaiTien = cbxLoai.EditValue.ToString();
dk_phong.TyGia = Convert.ToInt32(tbTygia.Text.ToString());
dk_phong.GhiChu = tbNoidung.Text.ToString();
dk_phong.DaCheckIn = false;
dk_phong.DonGia = Convert.ToInt32(gvDangky.GetRowCellValue(j, gvDangky.Columns[1]));
db.DangKyPhong.Add(dk_phong);
}
}
}
}
else
{
for (int j = 0; j < gvDangky.RowCount; j++)
{
var sophong = Convert.ToInt32(gvDangky.GetRowCellValue(j, gvDangky.Columns[0]));
var dkkhach = db.DK_Customers.Where(m => m.IdDK == id && m.Sophong == sophong).Count();
GridView dView = gvDangky.GetDetailView(j, 0) as GridView;
DK_Customer dk_khach = new DK_Customer();
Khach khach = new Khach();
DangKyPhong dk_phong = new DangKyPhong();
int dem = 0;
for (int i = 0; i < dView.RowCount; i++)
{
if (dView.GetRowCellValue(i, dView.Columns[0]) != null && dView.GetRowCellValue(i, dView.Columns[1]) != null)
{
dem++;
}
}
if (dem > dkkhach)
{
for (int i = dkkhach; i < dView.RowCount; i++)
{
if (dView.GetRowCellValue(i, dView.Columns[0]) != null && dView.GetRowCellValue(i, dView.Columns[1]) != null)
{
khach.HoTen = dView.GetRowCellValue(i, dView.Columns[1]).ToString();
khach.SoCMND = dView.GetRowCellValue(i, dView.Columns[0]).ToString();
khach.GioiTnh = Convert.ToBoolean(dView.GetRowCellValue(i, dView.Columns[2]));
khach.MaQT = Convert.ToInt32(dView.GetRowCellValue(i, dView.Columns[3]));
khach.NgaySinh = DateTime.Now;
khach.DonVi = "Khách hàng";
if (edtDienThoai.Text == "Nhập số điện thoại")
{
khach.Phone = "";
}
else
{
khach.Phone = edtDienThoai.Text.ToString();
}
db.Khach.Add(khach);
db.SaveChanges();
var idkh = db.Khach.OrderByDescending(m => m.Id == idkhach).First();
dk_khach.IdDK = id;
dk_khach.IdKH = idkhach;
dk_khach.Hoten = dView.GetRowCellValue(i, dView.Columns[1]).ToString();
dk_khach.CMND = dView.GetRowCellValue(i, dView.Columns[0]).ToString();
dk_khach.Gioitinh = Convert.ToBoolean(dView.GetRowCellValue(i, dView.Columns[2]));
dk_khach.Quoctich = Convert.ToInt32(dView.GetRowCellValue(i, dView.Columns[3]));
dk_khach.Sophong = Convert.ToInt32(gvDangky.GetRowCellValue(i, gvDangky.Columns[0]));
dk_khach.DateCheckin = Convert.ToDateTime(dateCheckin.EditValue.ToString());
dk_khach.DateCheckout = Convert.ToDateTime(dateCheckout.EditValue.ToString());
dk_khach.GioCheckin = DateTime.Now.ToShortTimeString();
dk_khach.Sophong = Convert.ToInt32(dView.GetRowCellValue(i, dView.Columns[4]));
dk_khach.GioCheckout = "12:00";
db.DK_Customers.Add(dk_khach);
db.SaveChanges();
}
}
}
else if (dem <= dkkhach)
{
for (int i = 0; i < dkkhach; i++)
{
if (dView.GetRowCellValue(i, dView.Columns[0]) != null && dView.GetRowCellValue(i, dView.Columns[1]) != null)
{
var iddk = Convert.ToInt32(dView.GetRowCellValue(i, dView.Columns[5]).ToString());
var editkhach = db.Khach.FirstOrDefault(m => m.Id == idkhach);
if (edtDienThoai.Text == "Nhập số điện thoại")
{
editkhach.Phone = "";
}
else
{
editkhach.Phone = edtDienThoai.Text.ToString();
}
db.SaveChanges();
DK_Customer edit_dkkhach = (from dkcus in db.DK_Customers
where dkcus.Id == iddk
select dkcus).DefaultIfEmpty().Single();
DK_Customer dkcustomer = new DK_Customer();
dkcustomer.IdKH = idkhach;
dkcustomer.Hoten = dView.GetRowCellValue(i, dView.Columns[1]).ToString();
dkcustomer.CMND = dView.GetRowCellValue(i, dView.Columns[0]).ToString();
dkcustomer.Gioitinh = Convert.ToBoolean(dView.GetRowCellValue(i, dView.Columns[2]));
dkcustomer.Quoctich = Convert.ToInt32(dView.GetRowCellValue(i, dView.Columns[3]).ToString());
dkcustomer.Sophong = Convert.ToInt32(gvDangky.GetRowCellValue(i, gvDangky.Columns[0]));
dkcustomer.DateCheckin = Convert.ToDateTime(dateCheckin.EditValue.ToString());
dkcustomer.DateCheckout = Convert.ToDateTime(dateCheckout.EditValue.ToString());
dkcustomer.GioCheckin = DateTime.Now.ToShortTimeString();
dkcustomer.GioCheckout = "12:00";
edit_dkkhach.CMND = dkcustomer.CMND;
edit_dkkhach.Hoten = dkcustomer.Hoten;
edit_dkkhach.Gioitinh = dkcustomer.Gioitinh;
edit_dkkhach.Quoctich = dkcustomer.Quoctich;
edit_dkkhach.DateCheckin = dkcustomer.DateCheckin;
edit_dkkhach.DateCheckout = dkcustomer.DateCheckout;
edit_dkkhach.IdKH = dkcustomer.IdKH;
db.SaveChanges();
}
}
}
}
}
var update = db.Dangky.FirstOrDefault(m => m.Id == id);
update.Phong = phong.ToString();
db.SaveChanges();
t = 0;
}
}
if (tam == 2)
{
if (txtSo.Text != null)
{
var id = Convert.ToInt32(txtSo.Text);
if (gcDangky.DataSource == null)
{
var delid = db.Dangky.FirstOrDefault(m => m.Id == id);
db.Dangky.Remove(delid);
db.SaveChanges();
var deldk = db.DK_Customers.FirstOrDefault(m => m.IdDK == id);
db.DK_Customers.Remove(deldk);
var deldkp = db.DangKyPhong.Where(m => m.IDDK == id).ToList();
foreach (var item in deldkp)
{
db.DangKyPhong.Remove(item);
}
var listdkp = db.DangKyPhong.Where(m => m.IDDK == id).ToList();
foreach (var item in listdkp)
{
var room = db.Rooms.Where(m => m.Sophong == item.SoPhong).First();
room.Status = 1;
}
db.SaveChanges();
}
else
{
var dkp = db.DangKyPhong.Where(m => m.IDDK == id).OrderBy(m => m.SoPhong).ToList();
if (lstdkp.Count != 0)
{
foreach (var item in lstdkp)
{
db.DangKyPhong.Remove(item);
var deldkk = db.DK_Customers.Where(m => m.Sophong == item.SoPhong).First();
db.DK_Customers.Remove(deldkk);
var room = db.Rooms.Where(m => m.Sophong == item.SoPhong).First();
room.Status = 1;
}
for (int i = 0; i < gvDangky.RowCount; i++)
{
phong.Trim();
phong += gvDangky.GetRowCellValue(i, gvDangky.Columns[0]).ToString();
if (i < gvDangky.RowCount - 1)
{
phong += ",";
}
}
var update = db.Dangky.FirstOrDefault(m => m.Id == id);
update.Phong = phong.ToString();
db.SaveChanges();
}
else
{
foreach (var item in lstdkk)
{
db.DK_Customers.Remove(item);
}
db.SaveChanges();
}
}
}
}
MessageBox.Show("Lưu thành công!");
}
}
