public IHttpActionResult PutKH_PHAN_LOAI_KHACH(int id, KH_PHAN_LOAI_KHACH kH_PHAN_LOAI_KHACH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var query = db.KH_PHAN_LOAI_KHACH.Where(x => x.ID == id).FirstOrDefault();
if (query != null)
{
query.MA_LOAI_KHACH = kH_PHAN_LOAI_KHACH.MA_LOAI_KHACH;
query.NHOM_NGANH = kH_PHAN_LOAI_KHACH.NHOM_NGANH;
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KH_PHAN_LOAI_KHACHExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutKH_PHAN_LOAI_KHACH(int id, KH_PHAN_LOAI_KHACH kH_PHAN_LOAI_KHACH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != kH_PHAN_LOAI_KHACH.ID)
{
return(BadRequest());
}
db.Entry(kH_PHAN_LOAI_KHACH).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KH_PHAN_LOAI_KHACHExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetKH_PHAN_LOAI_KHACH(int id)
{
KH_PHAN_LOAI_KHACH kH_PHAN_LOAI_KHACH = db.KH_PHAN_LOAI_KHACH.Find(id);
if (kH_PHAN_LOAI_KHACH == null)
{
return(NotFound());
}
return(Ok(kH_PHAN_LOAI_KHACH));
}
public IHttpActionResult PostKH_PHAN_LOAI_KHACH(KH_PHAN_LOAI_KHACH kH_PHAN_LOAI_KHACH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.KH_PHAN_LOAI_KHACH.Add(kH_PHAN_LOAI_KHACH);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = kH_PHAN_LOAI_KHACH.ID }, kH_PHAN_LOAI_KHACH));
}
public IHttpActionResult DeleteKH_PHAN_LOAI_KHACH(int id)
{
KH_PHAN_LOAI_KHACH kH_PHAN_LOAI_KHACH = db.KH_PHAN_LOAI_KHACH.Find(id);
if (kH_PHAN_LOAI_KHACH == null)
{
return(NotFound());
}
db.KH_PHAN_LOAI_KHACH.Remove(kH_PHAN_LOAI_KHACH);
db.SaveChanges();
return(Ok(kH_PHAN_LOAI_KHACH));
}
public IHttpActionResult PostKH_PHAN_LOAI_KHACH(KH_PHAN_LOAI_KHACH kH_PHAN_LOAI_KHACH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
KH_PHAN_LOAI_KHACH newphanloaikh = new KH_PHAN_LOAI_KHACH();
newphanloaikh.MA_KHACH_HANG = kH_PHAN_LOAI_KHACH.MA_KHACH_HANG;
newphanloaikh.MA_LOAI_KHACH = kH_PHAN_LOAI_KHACH.MA_LOAI_KHACH;
newphanloaikh.NHOM_NGANH = kH_PHAN_LOAI_KHACH.NHOM_NGANH;
db.KH_PHAN_LOAI_KHACH.Add(newphanloaikh);
db.SaveChanges();
return(Ok(newphanloaikh));
}
public ActionResult Import_KhachHang(HttpPostedFileBase file)
{
try
{
if (Request != null)
{
HttpPostedFileBase filetonkho = Request.Files["UploadedFile"];
if ((filetonkho != null) && (filetonkho.ContentLength > 0) && !string.IsNullOrEmpty(filetonkho.FileName))
{
string fileName = filetonkho.FileName;
string fileContentType = filetonkho.ContentType;
byte[] fileBytes = new byte[filetonkho.ContentLength];
var data = filetonkho.InputStream.Read(fileBytes, 0, Convert.ToInt32(filetonkho.ContentLength));
//var usersList = new List<Users>();
using (var package = new ExcelPackage(filetonkho.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
string makhach = workSheet.Cells[rowIterator, 1].Value.ToString();
var query = db.KHs.Where(x => x.MA_KHACH_HANG == makhach).FirstOrDefault();
if (query == null)
{
KH khachhang = new KH();
khachhang.MA_KHACH_HANG = makhach;
khachhang.TEN_CONG_TY = workSheet.Cells[rowIterator, 2].Value.ToString();
if (workSheet.Cells[rowIterator, 5].Value != null)
{
khachhang.VAN_PHONG_GIAO_DICH = workSheet.Cells[rowIterator, 5].Value.ToString();
}
if (workSheet.Cells[rowIterator, 6].Value != null)
{
khachhang.DIA_CHI_XUAT_HOA_DON = workSheet.Cells[rowIterator, 6].Value.ToString();
}
if (workSheet.Cells[rowIterator, 7].Value != null)
{
khachhang.MST = workSheet.Cells[rowIterator, 7].Value.ToString();
}
if (workSheet.Cells[rowIterator, 8].Value != null)
{
khachhang.HOTLINE = workSheet.Cells[rowIterator, 8].Value.ToString();
}
if (workSheet.Cells[rowIterator, 9].Value != null)
{
khachhang.FAX = workSheet.Cells[rowIterator, 9].Value.ToString();
}
if (workSheet.Cells[rowIterator, 10].Value != null)
{
khachhang.EMAIL = workSheet.Cells[rowIterator, 10].Value.ToString();
}
if (workSheet.Cells[rowIterator, 11].Value != null)
{
khachhang.LOGO = workSheet.Cells[rowIterator, 11].Value.ToString();
}
if (workSheet.Cells[rowIterator, 12].Value != null)
{
khachhang.WEBSITE = workSheet.Cells[rowIterator, 12].Value.ToString();
}
if (workSheet.Cells[rowIterator, 13].Value != null)
{
khachhang.TINH = workSheet.Cells[rowIterator, 13].Value.ToString();
}
if (workSheet.Cells[rowIterator, 14].Value != null)
{
khachhang.QUOC_GIA = workSheet.Cells[rowIterator, 14].Value.ToString();
}
if (workSheet.Cells[rowIterator, 15].Value != null)
{
khachhang.DIEU_KHOAN_THANH_TOAN = workSheet.Cells[rowIterator, 15].Value.ToString();
}
if (workSheet.Cells[rowIterator, 16].Value != null)
{
khachhang.SO_NGAY_DUOC_NO = Convert.ToInt32(workSheet.Cells[rowIterator, 16].Value);
}
if (workSheet.Cells[rowIterator, 17].Value != null)
{
khachhang.SO_NO_TOI_DA = Convert.ToInt32(workSheet.Cells[rowIterator, 17].Value);
}
khachhang.TRUC_THUOC = "HOPLONG";
if (workSheet.Cells[rowIterator, 19].Value != null)
{
khachhang.GHI_CHU = workSheet.Cells[rowIterator, 19].Value.ToString();
}
db.KHs.Add(khachhang);
db.SaveChanges();
var DATA = db.KHs.Where(x => x.MA_KHACH_HANG == makhach).FirstOrDefault();
if (DATA != null)
{
KH_PHAN_LOAI_KHACH plkhach = new KH_PHAN_LOAI_KHACH();
plkhach.MA_KHACH_HANG = makhach;
plkhach.MA_LOAI_KHACH = workSheet.Cells[rowIterator, 3].Value.ToString();
if (workSheet.Cells[rowIterator, 4].Value != null)
{
plkhach.NHOM_NGANH = workSheet.Cells[rowIterator, 4].Value.ToString();
}
db.KH_PHAN_LOAI_KHACH.Add(plkhach);
db.SaveChanges();
}
if (workSheet.Cells[rowIterator, 20].Value != null)
{
KH_LIEN_HE lhkhach = new KH_LIEN_HE();
lhkhach.MA_KHACH_HANG = makhach;
lhkhach.NGUOI_LIEN_HE = workSheet.Cells[rowIterator, 20].Value.ToString();
if (workSheet.Cells[rowIterator, 21].Value != null)
{
lhkhach.CHUC_VU = workSheet.Cells[rowIterator, 21].Value.ToString();
}
if (workSheet.Cells[rowIterator, 22].Value != null)
{
lhkhach.PHONG_BAN = workSheet.Cells[rowIterator, 22].Value.ToString();
}
if (workSheet.Cells[rowIterator, 23].Value != null)
{
lhkhach.NGAY_SINH = xulydate.Xulydatetime(workSheet.Cells[rowIterator, 23].Value.ToString());
}
if (workSheet.Cells[rowIterator, 24].Value != null)
{
lhkhach.GIOI_TINH = workSheet.Cells[rowIterator, 24].Value.ToString();
}
lhkhach.SDT1 = workSheet.Cells[rowIterator, 25].Value.ToString();
if (workSheet.Cells[rowIterator, 26].Value != null)
{
lhkhach.SDT2 = workSheet.Cells[rowIterator, 26].Value.ToString();
}
if (workSheet.Cells[rowIterator, 27].Value != null)
{
lhkhach.EMAIL_CA_NHAN = workSheet.Cells[rowIterator, 27].Value.ToString();
}
if (workSheet.Cells[rowIterator, 28].Value != null)
{
lhkhach.EMAIL_CONG_TY = workSheet.Cells[rowIterator, 28].Value.ToString();
}
if (workSheet.Cells[rowIterator, 29].Value != null)
{
lhkhach.SKYPE = workSheet.Cells[rowIterator, 29].Value.ToString();
}
if (workSheet.Cells[rowIterator, 30].Value != null)
{
lhkhach.FACEBOOK = workSheet.Cells[rowIterator, 30].Value.ToString();
}
if (workSheet.Cells[rowIterator, 31].Value != null)
{
lhkhach.GHI_CHU = workSheet.Cells[rowIterator, 31].Value.ToString();
}
db.KH_LIEN_HE.Add(lhkhach);
db.SaveChanges();
string idlh = workSheet.Cells[rowIterator, 25].Value.ToString();
var datalienhe = db.KH_LIEN_HE.Where(x => x.SDT1 == idlh).FirstOrDefault();
if (datalienhe != null)
{
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = datalienhe.ID_LIEN_HE;
salept.SALES_PHU_TRACH = workSheet.Cells[rowIterator, 32].Value.ToString();
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
}
if (workSheet.Cells[rowIterator, 33].Value != null)
{
KH_TK_NGAN_HANG tkkhach = new KH_TK_NGAN_HANG();
tkkhach.MA_KHACH_HANG = makhach;
tkkhach.SO_TAI_KHOAN = workSheet.Cells[rowIterator, 33].Value.ToString();
if (workSheet.Cells[rowIterator, 34].Value != null)
{
tkkhach.TEN_TAI_KHOAN = workSheet.Cells[rowIterator, 34].Value.ToString();
}
if (workSheet.Cells[rowIterator, 35].Value != null)
{
tkkhach.TEN_NGAN_HANG = workSheet.Cells[rowIterator, 35].Value.ToString();
}
if (workSheet.Cells[rowIterator, 36].Value != null)
{
tkkhach.CHI_NHANH = workSheet.Cells[rowIterator, 36].Value.ToString();
}
if (workSheet.Cells[rowIterator, 37].Value != null)
{
tkkhach.TINH_TP = workSheet.Cells[rowIterator, 37].Value.ToString();
}
if (workSheet.Cells[rowIterator, 38].Value != null)
{
tkkhach.LOAI_TAI_KHOAN = workSheet.Cells[rowIterator, 38].Value.ToString();
}
if (workSheet.Cells[rowIterator, 39].Value != null)
{
tkkhach.GHI_CHU = workSheet.Cells[rowIterator, 39].Value.ToString();
}
db.KH_TK_NGAN_HANG.Add(tkkhach);
db.SaveChanges();
}
}
}
else
if (query != null)
{
if (workSheet.Cells[rowIterator, 20].Value != null)
{
KH_LIEN_HE lhkhach = new KH_LIEN_HE();
lhkhach.MA_KHACH_HANG = makhach;
lhkhach.NGUOI_LIEN_HE = workSheet.Cells[rowIterator, 20].Value.ToString();
if (workSheet.Cells[rowIterator, 21].Value != null)
{
lhkhach.CHUC_VU = workSheet.Cells[rowIterator, 21].Value.ToString();
}
if (workSheet.Cells[rowIterator, 22].Value != null)
{
lhkhach.PHONG_BAN = workSheet.Cells[rowIterator, 22].Value.ToString();
}
if (workSheet.Cells[rowIterator, 23].Value != null)
{
lhkhach.NGAY_SINH = xulydate.Xulydatetime(workSheet.Cells[rowIterator, 23].Value.ToString());
}
if (workSheet.Cells[rowIterator, 24].Value != null)
{
lhkhach.GIOI_TINH = workSheet.Cells[rowIterator, 24].Value.ToString();
}
lhkhach.SDT1 = workSheet.Cells[rowIterator, 25].Value.ToString();
if (workSheet.Cells[rowIterator, 26].Value != null)
{
lhkhach.SDT2 = workSheet.Cells[rowIterator, 26].Value.ToString();
}
if (workSheet.Cells[rowIterator, 27].Value != null)
{
lhkhach.EMAIL_CA_NHAN = workSheet.Cells[rowIterator, 27].Value.ToString();
}
if (workSheet.Cells[rowIterator, 28].Value != null)
{
lhkhach.EMAIL_CONG_TY = workSheet.Cells[rowIterator, 28].Value.ToString();
}
if (workSheet.Cells[rowIterator, 29].Value != null)
{
lhkhach.SKYPE = workSheet.Cells[rowIterator, 29].Value.ToString();
}
if (workSheet.Cells[rowIterator, 30].Value != null)
{
lhkhach.FACEBOOK = workSheet.Cells[rowIterator, 30].Value.ToString();
}
if (workSheet.Cells[rowIterator, 31].Value != null)
{
lhkhach.GHI_CHU = workSheet.Cells[rowIterator, 31].Value.ToString();
}
db.KH_LIEN_HE.Add(lhkhach);
db.SaveChanges();
string idlh = workSheet.Cells[rowIterator, 25].Value.ToString();
var datalienhe = db.KH_LIEN_HE.Where(x => x.SDT1 == idlh).FirstOrDefault();
if (datalienhe != null)
{
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = datalienhe.ID_LIEN_HE;
salept.SALES_PHU_TRACH = workSheet.Cells[rowIterator, 32].Value.ToString();
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
}
if (workSheet.Cells[rowIterator, 33].Value != null)
{
KH_TK_NGAN_HANG tkkhach = new KH_TK_NGAN_HANG();
tkkhach.MA_KHACH_HANG = makhach;
tkkhach.SO_TAI_KHOAN = workSheet.Cells[rowIterator, 33].Value.ToString();
if (workSheet.Cells[rowIterator, 34].Value != null)
{
tkkhach.TEN_TAI_KHOAN = workSheet.Cells[rowIterator, 34].Value.ToString();
}
if (workSheet.Cells[rowIterator, 35].Value != null)
{
tkkhach.TEN_NGAN_HANG = workSheet.Cells[rowIterator, 35].Value.ToString();
}
if (workSheet.Cells[rowIterator, 36].Value != null)
{
tkkhach.CHI_NHANH = workSheet.Cells[rowIterator, 36].Value.ToString();
}
if (workSheet.Cells[rowIterator, 37].Value != null)
{
tkkhach.TINH_TP = workSheet.Cells[rowIterator, 37].Value.ToString();
}
if (workSheet.Cells[rowIterator, 38].Value != null)
{
tkkhach.LOAI_TAI_KHOAN = workSheet.Cells[rowIterator, 38].Value.ToString();
}
if (workSheet.Cells[rowIterator, 39].Value != null)
{
tkkhach.GHI_CHU = workSheet.Cells[rowIterator, 39].Value.ToString();
}
db.KH_TK_NGAN_HANG.Add(tkkhach);
db.SaveChanges();
}
}
}
so_dong_thanh_cong++;
dong = rowIterator;
}
}
}
}
}
catch (Exception Ex)
{
ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex;
ViewBag.Information = "Lỗi tại dòng thứ: " + dong;
}
finally
{
ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng";
}
return(View());
}
public ActionResult Import_KhachHang(HttpPostedFileBase file)
{
try
{
if (Request != null)
{
HttpPostedFileBase filetonkho = Request.Files["UploadedFile"];
if ((filetonkho != null) && (filetonkho.ContentLength > 0) && !string.IsNullOrEmpty(filetonkho.FileName))
{
string fileName = filetonkho.FileName;
string fileContentType = filetonkho.ContentType;
byte[] fileBytes = new byte[filetonkho.ContentLength];
var data = filetonkho.InputStream.Read(fileBytes, 0, Convert.ToInt32(filetonkho.ContentLength));
//var usersList = new List<Users>();
using (var package = new ExcelPackage(filetonkho.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
makhach = workSheet.Cells[rowIterator, 1].Value.ToString();
tencongty = workSheet.Cells[rowIterator, 2].Value.ToString();
if (workSheet.Cells[rowIterator, 3].Value != null)
{
phanloaikhach = workSheet.Cells[rowIterator, 3].Value.ToString();
}
else
{
phanloaikhach = "";
}
if (workSheet.Cells[rowIterator, 4].Value != null)
{
nhomnganh = workSheet.Cells[rowIterator, 4].Value.ToString();
}
else
{
nhomnganh = "";
}
if (workSheet.Cells[rowIterator, 4].Value != null)
{
nhomnganh = workSheet.Cells[rowIterator, 4].Value.ToString();
}
else
{
nhomnganh = "";
}
if (workSheet.Cells[rowIterator, 5].Value != null)
{
diachivpgiaodich = workSheet.Cells[rowIterator, 5].Value.ToString();
}
else
{
diachivpgiaodich = "";
}
if (workSheet.Cells[rowIterator, 6].Value != null)
{
diachixuathoadon = workSheet.Cells[rowIterator, 6].Value.ToString();
}
else
{
diachixuathoadon = "";
}
if (workSheet.Cells[rowIterator, 7].Value != null)
{
MST = workSheet.Cells[rowIterator, 7].Value.ToString();
}
else
{
MST = "";
}
if (workSheet.Cells[rowIterator, 8].Value != null)
{
somayban = workSheet.Cells[rowIterator, 8].Value.ToString();
}
else
{
somayban = "";
}
if (workSheet.Cells[rowIterator, 9].Value != null)
{
fax = workSheet.Cells[rowIterator, 9].Value.ToString();
}
else
{
fax = "";
}
if (workSheet.Cells[rowIterator, 10].Value != null)
{
email = workSheet.Cells[rowIterator, 10].Value.ToString();
}
else
{
email = "";
}
if (workSheet.Cells[rowIterator, 11].Value != null)
{
logo = workSheet.Cells[rowIterator, 11].Value.ToString();
}
else
{
logo = "";
}
if (workSheet.Cells[rowIterator, 12].Value != null)
{
website = workSheet.Cells[rowIterator, 12].Value.ToString();
}
else
{
website = "";
}
if (workSheet.Cells[rowIterator, 13].Value != null)
{
tinh = workSheet.Cells[rowIterator, 13].Value.ToString();
}
else
{
tinh = "";
}
if (workSheet.Cells[rowIterator, 14].Value != null)
{
quocgia = workSheet.Cells[rowIterator, 14].Value.ToString();
}
else
{
quocgia = "";
}
if (workSheet.Cells[rowIterator, 15].Value != null)
{
dieukhoanthanhtoan = workSheet.Cells[rowIterator, 15].Value.ToString();
}
else
{
dieukhoanthanhtoan = "";
}
if (workSheet.Cells[rowIterator, 16].Value != null)
{
songayduocno = workSheet.Cells[rowIterator, 16].Value.ToString();
}
else
{
songayduocno = "";
}
if (workSheet.Cells[rowIterator, 17].Value != null)
{
sonotoida = workSheet.Cells[rowIterator, 17].Value.ToString();
}
else
{
sonotoida = "";
}
if (workSheet.Cells[rowIterator, 18].Value != null)
{
tinhtranghoatdong = workSheet.Cells[rowIterator, 18].Value.ToString();
}
else
{
tinhtranghoatdong = "";
}
if (workSheet.Cells[rowIterator, 19].Value != null)
{
tructhuoc = workSheet.Cells[rowIterator, 19].Value.ToString();
}
else
{
tructhuoc = "";
}
if (workSheet.Cells[rowIterator, 20].Value != null)
{
ghichu = workSheet.Cells[rowIterator, 20].Value.ToString();
}
else
{
ghichu = "";
}
if (workSheet.Cells[rowIterator, 21].Value != null)
{
phutrachhienthoi = workSheet.Cells[rowIterator, 21].Value.ToString();
}
else
{
phutrachhienthoi = "";
}
if (workSheet.Cells[rowIterator, 22].Value != null)
{
nguoilienhe = workSheet.Cells[rowIterator, 22].Value.ToString();
}
else
{
nguoilienhe = "";
}
if (workSheet.Cells[rowIterator, 23].Value != null)
{
chucvu = workSheet.Cells[rowIterator, 23].Value.ToString();
}
else
{
chucvu = "";
}
if (workSheet.Cells[rowIterator, 24].Value != null)
{
phongban = workSheet.Cells[rowIterator, 24].Value.ToString();
}
else
{
phongban = "";
}
if (workSheet.Cells[rowIterator, 25].Value != null)
{
ngaysinh = workSheet.Cells[rowIterator, 25].Value.ToString();
}
else
{
ngaysinh = "";
}
if (workSheet.Cells[rowIterator, 26].Value != null)
{
gioitinh = workSheet.Cells[rowIterator, 26].Value.ToString();
}
else
{
gioitinh = "";
}
if (workSheet.Cells[rowIterator, 27].Value != null)
{
sdt1 = workSheet.Cells[rowIterator, 27].Value.ToString();
}
else
{
sdt1 = "";
}
if (workSheet.Cells[rowIterator, 28].Value != null)
{
sdt2 = workSheet.Cells[rowIterator, 28].Value.ToString();
}
else
{
sdt2 = "";
}
if (workSheet.Cells[rowIterator, 29].Value != null)
{
emailcanhan = workSheet.Cells[rowIterator, 29].Value.ToString();
}
else
{
emailcanhan = "";
}
if (workSheet.Cells[rowIterator, 30].Value != null)
{
emailcongty = workSheet.Cells[rowIterator, 30].Value.ToString();
}
else
{
emailcongty = "";
}
if (workSheet.Cells[rowIterator, 31].Value != null)
{
skype = workSheet.Cells[rowIterator, 31].Value.ToString();
}
else
{
skype = "";
}
if (workSheet.Cells[rowIterator, 32].Value != null)
{
facebook = workSheet.Cells[rowIterator, 32].Value.ToString();
}
else
{
facebook = "";
}
if (workSheet.Cells[rowIterator, 33].Value != null)
{
ghichulienhe = workSheet.Cells[rowIterator, 33].Value.ToString();
}
else
{
ghichulienhe = "";
}
if (workSheet.Cells[rowIterator, 34].Value != null)
{
salephutrach = workSheet.Cells[rowIterator, 34].Value.ToString();
}
else
{
salephutrach = "";
}
if (workSheet.Cells[rowIterator, 35].Value != null)
{
sotknganhang = workSheet.Cells[rowIterator, 36].Value.ToString();
}
else
{
sotknganhang = "";
}
if (workSheet.Cells[rowIterator, 36].Value != null)
{
tentaikhoan = workSheet.Cells[rowIterator, 36].Value.ToString();
}
else
{
tentaikhoan = "";
}
if (workSheet.Cells[rowIterator, 37].Value != null)
{
tennganhang = workSheet.Cells[rowIterator, 37].Value.ToString();
}
else
{
tennganhang = "";
}
if (workSheet.Cells[rowIterator, 38].Value != null)
{
chinhanhnganhang = workSheet.Cells[rowIterator, 38].Value.ToString();
}
else
{
chinhanhnganhang = "";
}
if (workSheet.Cells[rowIterator, 39].Value != null)
{
tinhnganhang = workSheet.Cells[rowIterator, 39].Value.ToString();
}
else
{
tinhnganhang = "";
}
if (workSheet.Cells[rowIterator, 40].Value != null)
{
loaitaikhoan = workSheet.Cells[rowIterator, 40].Value.ToString();
}
else
{
loaitaikhoan = "";
}
if (workSheet.Cells[rowIterator, 41].Value != null)
{
ghichu = workSheet.Cells[rowIterator, 41].Value.ToString();
}
else
{
ghichu = "";
}
//Thêm khách hàng
var query = db.KHs.Where(x => x.MA_KHACH_HANG == makhach).FirstOrDefault();
if (query == null)
{
KH khachhang = new KH();
khachhang.MA_KHACH_HANG = makhach;
khachhang.TEN_CONG_TY = tencongty;
if (diachivpgiaodich != "")
{
khachhang.VAN_PHONG_GIAO_DICH = diachivpgiaodich;
}
if (diachixuathoadon != "")
{
khachhang.DIA_CHI_XUAT_HOA_DON = diachixuathoadon;
}
if (MST != "")
{
khachhang.MST = MST;
}
if (somayban != "")
{
khachhang.HOTLINE = somayban;
}
if (fax != "")
{
khachhang.FAX = fax;
}
if (email != "")
{
khachhang.EMAIL = email;
}
if (logo != "")
{
khachhang.LOGO = logo;
}
if (website != "")
{
khachhang.WEBSITE = website;
}
if (tinh != "")
{
khachhang.TINH = tinh;
}
if (quocgia != "")
{
khachhang.QUOC_GIA = quocgia;
}
if (dieukhoanthanhtoan != "")
{
khachhang.DIEU_KHOAN_THANH_TOAN = dieukhoanthanhtoan;
}
if (songayduocno != "")
{
khachhang.SO_NGAY_DUOC_NO = Convert.ToInt32(songayduocno);
}
if (sonotoida != "")
{
khachhang.SO_NO_TOI_DA = Convert.ToInt32(sonotoida);
}
if (tinhtranghoatdong != "")
{
khachhang.TINH_TRANG_HOAT_DONG = tinhtranghoatdong;
}
if (tructhuoc != "")
{
khachhang.TRUC_THUOC = tructhuoc;
}
if (ghichu != "")
{
khachhang.GHI_CHU = ghichu;
}
db.KHs.Add(khachhang);
db.SaveChanges();
//thêm phụ trách hiện thời
if (phutrachhienthoi != "")
{
KH_CHUYEN_SALES chuyensale = new KH_CHUYEN_SALES();
chuyensale.MA_KHACH_HANG = makhach;
chuyensale.SALE_HIEN_THOI = phutrachhienthoi;
db.KH_CHUYEN_SALES.Add(chuyensale);
}
//Thêm phân loại khách
var DATA = db.KH_PHAN_LOAI_KHACH.Where(x => x.MA_KHACH_HANG == makhach).FirstOrDefault();
if (DATA != null && phanloaikhach != "")
{
KH_PHAN_LOAI_KHACH plkhach = new KH_PHAN_LOAI_KHACH();
plkhach.MA_KHACH_HANG = makhach;
plkhach.MA_LOAI_KHACH = phanloaikhach;
if (nhomnganh != "")
{
plkhach.NHOM_NGANH = nhomnganh;
}
db.KH_PHAN_LOAI_KHACH.Add(plkhach);
db.SaveChanges();
}
//thêm người liên hệ
if (nguoilienhe != "")
{
KH_LIEN_HE lhkhach = new KH_LIEN_HE();
lhkhach.MA_KHACH_HANG = makhach;
lhkhach.NGUOI_LIEN_HE = nguoilienhe;
if (chucvu != "")
{
lhkhach.CHUC_VU = chucvu;
}
if (phongban != "")
{
lhkhach.PHONG_BAN = phongban;
}
if (ngaysinh != "")
{
lhkhach.NGAY_SINH = xulydate.Xulydatetime(ngaysinh);
}
if (gioitinh != "")
{
lhkhach.GIOI_TINH = gioitinh;
}
lhkhach.SDT1 = sdt1;
if (sdt2 != "")
{
lhkhach.SDT2 = sdt2;
}
if (emailcanhan != "")
{
lhkhach.EMAIL_CA_NHAN = emailcanhan;
}
if (emailcongty != "")
{
lhkhach.EMAIL_CONG_TY = emailcongty;
}
if (skype != "")
{
lhkhach.SKYPE = skype;
}
if (facebook != "")
{
lhkhach.FACEBOOK = facebook;
}
if (ghichulienhe != "")
{
lhkhach.GHI_CHU = ghichu;
}
db.KH_LIEN_HE.Add(lhkhach);
db.SaveChanges();
//thêm sale phụ trách
var datalienhe = db.KH_LIEN_HE.Where(x => x.SDT1 == sdt1).FirstOrDefault();
if (datalienhe != null)
{
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = datalienhe.ID_LIEN_HE;
salept.SALES_PHU_TRACH = salephutrach;
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
}
//thêm tài khoản ngân hàng
if (sotknganhang != "")
{
KH_TK_NGAN_HANG tkkhach = new KH_TK_NGAN_HANG();
tkkhach.MA_KHACH_HANG = makhach;
tkkhach.SO_TAI_KHOAN = sotknganhang;
if (tentaikhoan != "")
{
tkkhach.TEN_TAI_KHOAN = tentaikhoan;
}
if (tennganhang != "")
{
tkkhach.TEN_NGAN_HANG = tennganhang;
}
if (chinhanhnganhang != "")
{
tkkhach.CHI_NHANH = chinhanhnganhang;
}
if (tinhnganhang != "")
{
tkkhach.TINH_TP = tinhnganhang;
}
if (loaitaikhoan != "")
{
tkkhach.LOAI_TAI_KHOAN = loaitaikhoan;
}
if (ghichutaikhoan != "")
{
tkkhach.GHI_CHU = ghichutaikhoan;
}
db.KH_TK_NGAN_HANG.Add(tkkhach);
db.SaveChanges();
}
}
}
//trường hợp đã có khách hàng, chỉ thêm liên hệ, ...
else
if (query != null)
{
//thêm liên hệ
if (nguoilienhe != "")
{
KH_LIEN_HE lhkhach = new KH_LIEN_HE();
lhkhach.MA_KHACH_HANG = makhach;
lhkhach.NGUOI_LIEN_HE = nguoilienhe;
if (chucvu != "")
{
lhkhach.CHUC_VU = chucvu;
}
if (phongban != "")
{
lhkhach.PHONG_BAN = phongban;
}
if (ngaysinh != "")
{
lhkhach.NGAY_SINH = xulydate.Xulydatetime(ngaysinh);
}
if (gioitinh != "")
{
lhkhach.GIOI_TINH = gioitinh;
}
lhkhach.SDT1 = sdt1;
if (sdt2 != "")
{
lhkhach.SDT2 = sdt2;
}
if (emailcanhan != "")
{
lhkhach.EMAIL_CA_NHAN = emailcanhan;
}
if (emailcongty != "")
{
lhkhach.EMAIL_CONG_TY = emailcongty;
}
if (skype != "")
{
lhkhach.SKYPE = skype;
}
if (facebook != "")
{
lhkhach.FACEBOOK = facebook;
}
if (ghichu != "")
{
lhkhach.GHI_CHU = ghichu;
}
db.KH_LIEN_HE.Add(lhkhach);
db.SaveChanges();
//thêm sale phụ trách
var datalienhe = db.KH_LIEN_HE.Where(x => x.SDT1 == sdt1).FirstOrDefault();
if (datalienhe != null)
{
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = datalienhe.ID_LIEN_HE;
salept.SALES_PHU_TRACH = salephutrach;
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
}
//thêm tài khoản ngân hàng
if (sotknganhang != "")
{
KH_TK_NGAN_HANG tkkhach = new KH_TK_NGAN_HANG();
tkkhach.MA_KHACH_HANG = makhach;
tkkhach.SO_TAI_KHOAN = sotknganhang;
if (tentaikhoan != "")
{
tkkhach.TEN_TAI_KHOAN = tentaikhoan;
}
if (tennganhang != "")
{
tkkhach.TEN_NGAN_HANG = tennganhang;
}
if (chinhanhnganhang != "")
{
tkkhach.CHI_NHANH = chinhanhnganhang;
}
if (tinhnganhang != "")
{
tkkhach.TINH_TP = tinhnganhang;
}
if (loaitaikhoan != "")
{
tkkhach.LOAI_TAI_KHOAN = loaitaikhoan;
}
if (ghichutaikhoan != "")
{
tkkhach.GHI_CHU = ghichutaikhoan;
}
db.KH_TK_NGAN_HANG.Add(tkkhach);
db.SaveChanges();
}
}
}
so_dong_thanh_cong++;
dong = rowIterator;
}
}
}
}
}
catch (Exception Ex)
{
ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex;
ViewBag.Information = "Lỗi tại các dòng: " + dong;
}
finally
{
ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng";
}
return(View());
}
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));
}
