//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));
}
