private void Thongtin_FormClosing(object sender, FormClosingEventArgs e) { sodophong = new Sodophong(); Thongtin_Load(sender, e); var list = db.DK_Customers.ToList(); GetData data = new GetData(sodophong.PostData); data(list); }
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(); } } } } }