public bool AddKH(Entities.KhachHang.KhachHang kh) { try { Tbl_KhachHang newKHRecord = DB.Tbl_KhachHangs.Where(x => x.maKH == kh.Makh).FirstOrDefault(); if (newKHRecord != null) { return(0);///trường hợp trùng } newKHRecord = new Tbl_KhachHang(); newKHRecord.maKH = kh.Makh; newKHRecord.tenKH = kh.Tenkh; newKHRecord.diachi = kh.Diachi; newKHRecord.soCMND = kh.Socmnd; newKHRecord.sodienthoai = kh.Sodienthoai; newKHRecord.gioitinh = kh.Gioitinh; newKHRecord.ngaycapCMND = kh.Ngaycapcmnd; newKHRecord.nghenghiep = kh.Nghenghiep; newKHRecord.ngaysinh = kh.Ngaysinh; newKHRecord.trangthai = kh.Trangthai; newKHRecord.email = kh.Email; DB.SubmitChanges(); return(true); } catch { return(false); } }
public bool quydoidiem(Entities.KhachHang.KhachHang kh, string maThe) { try { Tbl_TheThanhVien ttv = DB.Tbl_TheThanhViens.Single(record => record.maThe == maThe); ///trường hợp chưa có thẻ thành viên if (ttv == null) { Tbl_TheThanhVien newTheTV = new Tbl_TheThanhVien(); newTheTV.maThe = maThe; newTheTV.maKH = kh.Makh; newTheTV.tongTien = tinhTongTien(); newTheTV.diemTichLuy = (int)newTheTV.tongTien / 1000; DB.Tbl_TheThanhViens.InsertOnSubmit(newTheTV); DB.SubmitChanges(); } else { ttv.diemTichLuy += (int)tinhTongTien() / 1000; DB.SubmitChanges(); } return(true); } catch (Exception) { return(false); } }
/*public bool Delete(string deleteID) * { * try * { * Tbl_KhachHang deleteRecord = DB.Tbl_KhachHangs.Single(record => record.maKH == deleteID); * * DB.Tbl_KhachHangs.DeleteOnSubmit(deleteRecord); * DB.SubmitChanges(); * * return true; * } * catch { return false; } * }*/ public bool Update(Entities.KhachHang.KhachHang updateKH) { try { Tbl_KhachHang updateRecord = DB.Tbl_KhachHangs.Single(record => record.maKH == updateKH.Makh); updateRecord.maKH = updateKH.Makh; updateRecord.tenKH = updateKH.Tenkh; updateRecord.diachi = updateKH.Diachi; updateRecord.email = updateKH.Email; updateRecord.gioitinh = updateKH.Gioitinh; updateRecord.ngaycapCMND = updateKH.Ngaycapcmnd; updateRecord.ngaysinh = updateKH.Ngaysinh; updateRecord.nghenghiep = updateKH.Nghenghiep; updateRecord.soCMND = updateKH.Socmnd; updateRecord.sodienthoai = updateKH.Sodienthoai; updateRecord.trangthai = updateKH.Trangthai; DB.SubmitChanges(); return(true); } catch { return(false); } }
public List <Entities.KhachHang.KhachHang> GetAllKhachHang() { var dsKH = DB.Tbl_KhachHangs.ToList(); List <Entities.KhachHang.KhachHang> listKh = new List <Entities.KhachHang.KhachHang>(); foreach (Tbl_KhachHang kh_DAL in dsKH) { Entities.KhachHang.KhachHang ekh = new Entities.KhachHang.KhachHang(); ekh.Makh = kh_DAL.maKH; ekh.Tenkh = kh_DAL.tenKH; ekh.Diachi = kh_DAL.diachi; ekh.Sodienthoai = kh_DAL.sodienthoai; ekh.Email = kh_DAL.email; ekh.Ngaycapcmnd = Convert.ToDateTime(kh_DAL.ngaycapCMND); ekh.Ngaysinh = Convert.ToDateTime(kh_DAL.ngaysinh); ekh.Trangthai = kh_DAL.trangthai; ekh.Gioitinh = kh_DAL.gioitinh; ekh.Nghenghiep = kh_DAL.nghenghiep; ekh.Socmnd = kh_DAL.soCMND; listKh.Add(ekh); } return(listKh); }
public override bool Equals(Object newKH) { KhachHang nv = (KhachHang)newKH; return(this.makh.ToLower().Equals(nv.makh.ToLower())); }