public IHttpActionResult PutKH_POLICY(int id, KH_POLICY policy)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != policy.ID)
{
return(BadRequest());
}
var query = db.KH_POLICY.Where(x => x.ID == id).FirstOrDefault();
if (query != null)
{
query.CK_HISTORY_3 = query.CK_HISTORY_2;
query.GIA_HISTORY_3 = query.GIA_HISTORY_2;
query.CK_HISTORY_2 = query.CK_HISTORY_1;
query.GIA_HISTORY_2 = query.GIA_HISTORY_1;
query.CK_HISTORY_1 = query.CK;
query.GIA_HISTORY_1 = query.GIA_BAN;
query.CK = policy.CK;
query.GIA_BAN = policy.GIA_BAN;
query.NGUOI_CAP_NHAT = policy.NGUOI_CAP_NHAT;
query.NGAY_CAP_NHAT = DateTime.Now;
}
// db.Entry(kH_POLICY).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KH_POLICYExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostKH_POLICY(khachhang_policy kH_POLICY)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var query = db.HH_NHOM_VTHH.Where(x => x.MA_NHOM_HANG_CHI_TIET == kH_POLICY.MA_NHOM_HANG).FirstOrDefault();
if (query != null)
{
KH_POLICY newpolicy = new KH_POLICY();
newpolicy.MA_NHOM_HANG = kH_POLICY.MA_NHOM_HANG;
newpolicy.MA_KHACH_HANG = kH_POLICY.MA_KHACH_HANG;
newpolicy.NGAY_CAP_NHAT = DateTime.Today.Date;
newpolicy.GIA_BAN = kH_POLICY.GIA_BAN;
newpolicy.CK = kH_POLICY.CK;
newpolicy.NGUOI_CAP_NHAT = kH_POLICY.NGUOI_CAP_NHAT;
db.KH_POLICY.Add(newpolicy);
db.SaveChanges();
}
else
{
HH_NHOM_VTHH newvthh = new HH_NHOM_VTHH();
newvthh.MA_NHOM_HANG_CHI_TIET = kH_POLICY.MA_NHOM_HANG;
newvthh.MA_NHOM_HANG_CHA = kH_POLICY.MA_NHOM_HANG_CHA;
newvthh.PURC_PHU_TRACH = kH_POLICY.PURC_PHU_TRACH;
newvthh.MARK_PHU_TRACH = kH_POLICY.MARK_PHU_TRACH;
db.HH_NHOM_VTHH.Add(newvthh);
db.SaveChanges();
KH_POLICY newpolicy = new KH_POLICY();
newpolicy.MA_NHOM_HANG = newvthh.MA_NHOM_HANG_CHI_TIET;
newpolicy.MA_KHACH_HANG = kH_POLICY.MA_KHACH_HANG;
newpolicy.GIA_BAN = kH_POLICY.GIA_BAN;
newpolicy.CK = kH_POLICY.CK;
newpolicy.NGUOI_CAP_NHAT = kH_POLICY.NGUOI_CAP_NHAT;
newpolicy.NGAY_CAP_NHAT = DateTime.Now;
db.KH_POLICY.Add(newpolicy);
db.SaveChanges();
}
return(Ok(kH_POLICY));
}
public IHttpActionResult CopyNewKH(string mkh, KhachHanghl thongtinmoi)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var thongtinchung = db.KHs.Where(x => x.MA_KHACH_HANG == mkh).FirstOrDefault();
var diachixuathang = db.KH_DC_XUAT_HANG.Where(x => x.MA_KHACH_HANG == mkh).ToList();
var lienhe = db.KH_LIEN_HE.Where(x => x.MA_KHACH_HANG == mkh).ToList();
var phanloai = db.KH_PHAN_LOAI_KHACH.Where(x => x.MA_KHACH_HANG == mkh).FirstOrDefault();
var taikhoan = db.KH_TK_NGAN_HANG.Where(x => x.MA_KHACH_HANG == mkh).ToList();
var policy = db.KH_POLICY.Where(x => x.MA_KHACH_HANG == mkh).ToList();
var phanhoi = db.KH_PHAN_HOI_KHACH_HANG.Where(x => x.MA_KHACH_HANG == mkh).ToList();
var thongke = db.KH_THONG_KE_MUA_HANG.Where(x => x.MA_KHACH_HANG == mkh).ToList();
KH newkhachhang = new KH();
newkhachhang.MA_KHACH_HANG = GenerateMAKH();
newkhachhang.TEN_CONG_TY = thongtinchung.TEN_CONG_TY;
newkhachhang.VAN_PHONG_GIAO_DICH = thongtinchung.VAN_PHONG_GIAO_DICH;
newkhachhang.DIA_CHI_XUAT_HOA_DON = thongtinchung.DIA_CHI_XUAT_HOA_DON;
newkhachhang.TINH = thongtinchung.TINH;
newkhachhang.QUOC_GIA = thongtinchung.QUOC_GIA;
newkhachhang.MST = thongtinchung.MST;
newkhachhang.HOTLINE = thongtinchung.HOTLINE;
newkhachhang.EMAIL = thongtinchung.EMAIL;
newkhachhang.FAX = thongtinchung.FAX;
newkhachhang.LOGO = thongtinchung.LOGO;
newkhachhang.WEBSITE = thongtinchung.WEBSITE;
newkhachhang.DIEU_KHOAN_THANH_TOAN = thongtinchung.DIEU_KHOAN_THANH_TOAN;
newkhachhang.TINH_TRANG_HOAT_DONG = thongtinchung.TINH_TRANG_HOAT_DONG;
newkhachhang.SO_NGAY_DUOC_NO = thongtinchung.SO_NGAY_DUOC_NO;
newkhachhang.SO_NO_TOI_DA = thongtinchung.SO_NO_TOI_DA;
newkhachhang.GHI_CHU = thongtinchung.GHI_CHU;
newkhachhang.TRUC_THUOC = thongtinmoi.TRUC_THUOC;
newkhachhang.SALES_TAO = thongtinmoi.SALES_PHU_TRACH;
newkhachhang.KHACH_DO_MARKETING_TIM_KIEM = thongtinchung.KHACH_DO_MARKETING_TIM_KIEM;
newkhachhang.KHACH_MUA_DOANH_SO_CAO = thongtinchung.KHACH_MUA_DOANH_SO_CAO;
newkhachhang.KHACH_MUA_SO_LUONG_NHIEU = thongtinchung.KHACH_MUA_SO_LUONG_NHIEU;
newkhachhang.KHACH_DAC_BIET = thongtinchung.KHACH_DAC_BIET;
newkhachhang.THONG_TIN_DA_DAY_DU = thongtinchung.THONG_TIN_DA_DAY_DU;
newkhachhang.HO_SO_THANH_TOAN = thongtinchung.HO_SO_THANH_TOAN;
db.KHs.Add(newkhachhang);
db.SaveChanges();
KH_CHUYEN_SALES newchuyensale = new KH_CHUYEN_SALES();
newchuyensale.MA_KHACH_HANG = newkhachhang.MA_KHACH_HANG;
newchuyensale.SALE_HIEN_THOI = thongtinmoi.SALES_PHU_TRACH;
db.KH_CHUYEN_SALES.Add(newchuyensale);
db.SaveChanges();
foreach (var item in diachixuathang)
{
KH_DC_XUAT_HANG newdiachi = new KH_DC_XUAT_HANG();
newdiachi.MA_KHACH_HANG = newkhachhang.MA_KHACH_HANG;
newdiachi.DIA_CHI_XUAT_HANG = item.DIA_CHI_XUAT_HANG;
newdiachi.GHI_CHU = item.GHI_CHU;
db.KH_DC_XUAT_HANG.Add(newdiachi);
db.SaveChanges();
}
foreach (var item in diachixuathang)
{
KH_DC_XUAT_HANG newdiachi = new KH_DC_XUAT_HANG();
newdiachi.MA_KHACH_HANG = newkhachhang.MA_KHACH_HANG;
newdiachi.DIA_CHI_XUAT_HANG = item.DIA_CHI_XUAT_HANG;
newdiachi.GHI_CHU = item.GHI_CHU;
db.KH_DC_XUAT_HANG.Add(newdiachi);
db.SaveChanges();
}
foreach (var item in lienhe)
{
KH_LIEN_HE newlienhe = new KH_LIEN_HE();
newlienhe.MA_KHACH_HANG = newkhachhang.MA_KHACH_HANG;
newlienhe.NGUOI_LIEN_HE = item.NGUOI_LIEN_HE;
newlienhe.CHUC_VU = item.CHUC_VU;
newlienhe.PHONG_BAN = item.PHONG_BAN;
newlienhe.NGAY_SINH = item.NGAY_SINH;
newlienhe.GIOI_TINH = item.GIOI_TINH;
newlienhe.EMAIL_CA_NHAN = item.EMAIL_CA_NHAN;
newlienhe.EMAIL_CONG_TY = item.EMAIL_CONG_TY;
newlienhe.SKYPE = item.SKYPE;
newlienhe.FACEBOOK = item.FACEBOOK;
newlienhe.GHI_CHU = item.GHI_CHU;
newlienhe.SDT1 = item.SDT1;
newlienhe.SDT2 = item.SDT2;
newlienhe.TINH_TRANG_LAM_VIEC = item.TINH_TRANG_LAM_VIEC;
db.KH_LIEN_HE.Add(newlienhe);
db.SaveChanges();
}
KH_PHAN_LOAI_KHACH newphanloai = new KH_PHAN_LOAI_KHACH();
newphanloai.MA_KHACH_HANG = newkhachhang.MA_KHACH_HANG;
newphanloai.MA_LOAI_KHACH = phanloai.MA_LOAI_KHACH;
newphanloai.NHOM_NGANH = phanloai.NHOM_NGANH;
db.KH_PHAN_LOAI_KHACH.Add(newphanloai);
db.SaveChanges();
foreach (var item in taikhoan)
{
KH_TK_NGAN_HANG newtaikhoan = new KH_TK_NGAN_HANG();
newtaikhoan.MA_KHACH_HANG = newkhachhang.MA_KHACH_HANG;
newtaikhoan.SO_TAI_KHOAN = item.SO_TAI_KHOAN;
newtaikhoan.TEN_TAI_KHOAN = item.TEN_TAI_KHOAN;
newtaikhoan.TEN_NGAN_HANG = item.TEN_NGAN_HANG;
newtaikhoan.CHI_NHANH = item.CHI_NHANH;
newtaikhoan.TINH_TP = item.TINH_TP;
newtaikhoan.LOAI_TAI_KHOAN = item.LOAI_TAI_KHOAN;
newtaikhoan.GHI_CHU = item.GHI_CHU;
db.KH_TK_NGAN_HANG.Add(newtaikhoan);
db.SaveChanges();
}
foreach (var item in policy)
{
KH_POLICY newpolicy = new KH_POLICY();
newpolicy.MA_KHACH_HANG = newkhachhang.MA_KHACH_HANG;
newpolicy.MA_NHOM_HANG = item.MA_NHOM_HANG;
newpolicy.GIA_BAN = item.GIA_BAN;
newpolicy.CK = item.CK;
newpolicy.CK_HISTORY_1 = item.CK_HISTORY_1;
newpolicy.GIA_HISTORY_1 = item.GIA_HISTORY_1;
newpolicy.CK_HISTORY_2 = item.CK_HISTORY_2;
newpolicy.GIA_HISTORY_2 = item.GIA_HISTORY_2;
newpolicy.CK_HISTORY_3 = item.CK_HISTORY_3;
newpolicy.GIA_HISTORY_3 = item.GIA_HISTORY_3;
db.KH_POLICY.Add(newpolicy);
db.SaveChanges();
}
foreach (var item in phanhoi)
{
KH_PHAN_HOI_KHACH_HANG newphanhoi = new KH_PHAN_HOI_KHACH_HANG();
newphanhoi.MA_KHACH_HANG = newkhachhang.MA_KHACH_HANG;
newphanhoi.NGUOI_PHAN_HOI = item.NGUOI_PHAN_HOI;
newphanhoi.NGAY_PHAN_HOI = item.NGAY_PHAN_HOI;
newphanhoi.THONG_TIN_PHAN_HOI = item.THONG_TIN_PHAN_HOI;
db.KH_PHAN_HOI_KHACH_HANG.Add(newphanhoi);
db.SaveChanges();
}
foreach (var item in thongke)
{
KH_THONG_KE_MUA_HANG newthongke = new KH_THONG_KE_MUA_HANG();
newthongke.MA_KHACH_HANG = newkhachhang.MA_KHACH_HANG;
newthongke.MA_HANG = item.MA_HANG;
newthongke.SL_MUA = item.SL_MUA;
newthongke.DON_GIA_MUA = item.DON_GIA_MUA;
newthongke.NHAN_VIEN_BAN_HANG = item.NHAN_VIEN_BAN_HANG;
db.KH_THONG_KE_MUA_HANG.Add(newthongke);
db.SaveChanges();
}
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
throw;
}
return(Ok(newkhachhang.MA_KHACH_HANG));
}
