//Thêm khách hàng. public static KHACHHANG_DTO ThemKhachHang(BANG_KHACHHANG kh) { QuanLyShop = new QUANLYCUAHANGEntities(); kh = QuanLyShop.BANG_KHACHHANG.Add(kh); QuanLyShop.SaveChanges(); KHACHHANG_DTO khDTO = ConvertDTO(kh); return(khDTO); }
public static KHACHHANG_DTO ConvertDTO(BANG_KHACHHANG kh) { KHACHHANG_DTO khDTO = new KHACHHANG_DTO(); khDTO.idkhachhang = kh.idkhachhang; khDTO.name = kh.name; khDTO.phonenumber = kh.phonenumber; khDTO.address = kh.address; khDTO.idkhuyenmai = kh.idkhuyenmai; khDTO.gender = kh.gender; khDTO.Old = kh.Old; khDTO.Chitiet = kh.Chitiet; khDTO.createdate = kh.createdate; return(khDTO); }
//Xóa khách hàng public static bool XoaKhachHang(string idKh) { BANG_KHACHHANG dKh = QuanLyShop.BANG_KHACHHANG.SingleOrDefault(k => k.idkhachhang == idKh); if (dKh != null) { QuanLyShop.BANG_KHACHHANG.Remove(dKh); try { QuanLyShop.SaveChanges(); return(true); } catch (Exception ex) { return(false); } } return(false); }
//Sửa thông tin khách hàng. public static KHACHHANG_DTO SuaKhachHang(BANG_KHACHHANG Kh) { BANG_KHACHHANG khUpdate = QuanLyShop.BANG_KHACHHANG.SingleOrDefault(k => k.idkhachhang == Kh.idkhachhang); if (khUpdate != null) { khUpdate.idkhachhang = Kh.idkhachhang; khUpdate.name = Kh.name; khUpdate.phonenumber = Kh.phonenumber; khUpdate.address = Kh.address; khUpdate.idkhuyenmai = Kh.idkhuyenmai; khUpdate.gender = Kh.gender; khUpdate.Old = Kh.Old; khUpdate.createdate = Kh.createdate; khUpdate.Chitiet = khUpdate.Chitiet + "\n" + Kh.Chitiet; QuanLyShop.SaveChanges(); KHACHHANG_DTO khDTO = ConvertDTO(khUpdate); return(khDTO); } return(null); }
//Sửa thông tin khách hàng public static KHACHHANG_DTO SuaKhachHang(BANG_KHACHHANG kh) { return(KHACHHANG_DAL.SuaKhachHang(kh)); }
//Thêm khách hàng. public static KHACHHANG_DTO ThemKhachHang(BANG_KHACHHANG kh) { return(KHACHHANG_DAL.ThemKhachHang(kh)); }