public IHttpActionResult PostKH(KH kH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.KHs.Add(kH);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KHExists(kH.MA_KHACH_HANG))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = kH.MA_KHACH_HANG }, kH));
}
public IHttpActionResult PutKH(string id, KH kH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != kH.MA_KHACH_HANG)
{
return(BadRequest());
}
db.Entry(kH).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KHExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
KH kH = db.Khachhang.Find(id);
db.Khachhang.Remove(kH);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult PutKH(string id, KH kH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != kH.MA_KHACH_HANG)
{
return(BadRequest());
}
var khach = db.KHs.Where(x => x.MA_KHACH_HANG == id).FirstOrDefault();
if (khach != null)
{
if (kH.LOGO != "")
{
khach.LOGO = kH.LOGO;
}
khach.TEN_CONG_TY = kH.TEN_CONG_TY;
khach.VAN_PHONG_GIAO_DICH = kH.VAN_PHONG_GIAO_DICH;
khach.DIA_CHI_XUAT_HOA_DON = kH.DIA_CHI_XUAT_HOA_DON;
khach.TINH = kH.TINH;
khach.QUOC_GIA = kH.QUOC_GIA;
khach.MST = kH.MST;
khach.HOTLINE = kH.HOTLINE;
khach.EMAIL = kH.EMAIL;
khach.FAX = kH.FAX;
khach.WEBSITE = kH.WEBSITE;
khach.DIEU_KHOAN_THANH_TOAN = kH.DIEU_KHOAN_THANH_TOAN;
khach.SO_NGAY_DUOC_NO = kH.SO_NGAY_DUOC_NO;
khach.SO_NO_TOI_DA = kH.SO_NO_TOI_DA;
khach.TINH_TRANG_HOAT_DONG = kH.TINH_TRANG_HOAT_DONG;
khach.GHI_CHU = kH.GHI_CHU;
khach.TRUC_THUOC = kH.TRUC_THUOC;
khach.SALES_TAO = kH.SALES_TAO;
}
//db.Entry(kH).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KHExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult ThemMoiKH(KH kH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
KH khach = new KH();
khach.MA_KHACH_HANG = GenerateMAKH();
khach.TEN_CONG_TY = kH.TEN_CONG_TY;
khach.VAN_PHONG_GIAO_DICH = kH.VAN_PHONG_GIAO_DICH;
khach.DIA_CHI_XUAT_HOA_DON = kH.DIA_CHI_XUAT_HOA_DON;
khach.TINH = kH.TINH;
khach.QUOC_GIA = kH.QUOC_GIA;
khach.MST = kH.MST;
khach.HOTLINE = kH.HOTLINE;
khach.EMAIL = kH.EMAIL;
khach.FAX = kH.FAX;
khach.LOGO = kH.LOGO;
khach.WEBSITE = kH.WEBSITE;
khach.DIEU_KHOAN_THANH_TOAN = kH.DIEU_KHOAN_THANH_TOAN;
khach.SO_NGAY_DUOC_NO = kH.SO_NGAY_DUOC_NO;
khach.SO_NO_TOI_DA = kH.SO_NO_TOI_DA;
khach.TINH_TRANG_HOAT_DONG = kH.TINH_TRANG_HOAT_DONG;
khach.GHI_CHU = kH.GHI_CHU;
khach.HO_SO_THANH_TOAN = kH.HO_SO_THANH_TOAN;
khach.TRUC_THUOC = kH.TRUC_THUOC;
khach.SALES_TAO = kH.SALES_TAO;
khach.KHACH_DO_MARKETING_TIM_KIEM = kH.KHACH_DO_MARKETING_TIM_KIEM;
khach.THONG_TIN_DA_DAY_DU = kH.THONG_TIN_DA_DAY_DU;
khach.KHACH_MUA_SO_LUONG_NHIEU = kH.KHACH_MUA_SO_LUONG_NHIEU;
khach.KHACH_MUA_DOANH_SO_CAO = kH.KHACH_MUA_DOANH_SO_CAO;
khach.KHACH_DAC_BIET = kH.KHACH_DAC_BIET;
db.KHs.Add(khach);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KHExists(kH.MA_KHACH_HANG))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(khach));
}
public ActionResult Edit([Bind(Include = "IDkhachhang,Name,Address,PhoneNumber")] KH kH)
{
if (ModelState.IsValid)
{
db.Entry(kH).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(kH));
}
public ActionResult Create([Bind(Include = "IDkhachhang,Name,Address,PhoneNumber")] KH kH)
{
if (ModelState.IsValid)
{
db.Khachhang.Add(kH);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(kH));
}
public IHttpActionResult GetKH(string id)
{
KH kH = db.KHs.Find(id);
if (kH == null)
{
return(NotFound());
}
return(Ok(kH));
}
static data()
{
KH.GetFullInfo("ListNhanVien");
NV.GetFullInfo("ListNhanVien");
NV2.GetFullInfo("ListKhachHang");
KH3.GetFullInfo("ListKhachHang");
donhang.GetFullInfo("listTTbanle");
sp.GetFullInfo("ListSP");
listNV.GetFullInfo("NhanVien");
KH2.GetFullInfo("ListKhachHang");
DL.GetFullInfo("DaiLy_NhanVien");
donhang2.GetFullInfo("ListDHBB");
}
// GET: KHs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
KH kH = db.Khachhang.Find(id);
if (kH == null)
{
return(HttpNotFound());
}
return(View(kH));
}
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
KH kH = db.KHs.Find(id);
if (kH == null)
{
return(HttpNotFound());
}
return(View(kH));
}
public IHttpActionResult DeleteKH(string id)
{
KH kH = db.KHs.Find(id);
if (kH == null)
{
return(NotFound());
}
db.KHs.Remove(kH);
db.SaveChanges();
return(Ok(kH));
}
private static Numeric getNewTemperatureValue(int amplitude, double counter, int CurrentValueVal, int InvalidVal, int mCounterVal, string code)
{
code = @"
{
int amplitude = " + amplitude + @";
double counter = " + counter + @";
CalcLong vMyCalcExMonth.CurrentValue = " + CurrentValueVal + @";
bool calc_month.Invalid = " + InvalidVal + @";
int mCounter = " + mCounterVal + @";" + code;
Parser parser = new Parser(code);
Program program = parser.GetProgram();
program.Translate();
var watch = Stopwatch.StartNew();
var programEnc = program.EncProgram();
List <Party> parties = new List <Party>();
Client client = new Client(program);
parties.Add(client);
EVH evh = new EVH(programEnc[0]);
parties.Add(evh);
KH kh = new KH(programEnc[1]);
parties.Add(kh);
Helper helper = new Helper();
parties.Add(helper);
Network.NetworkInitialize(parties);
Thread thread = new Thread(() => evh.RunParty());
thread.Name = "EVH";
thread.Start();
thread = new Thread(() => kh.RunParty());
thread.Name = "KH";
thread.Start();
client.RunParty();
watch.Stop();
long currDur = (watch.ElapsedTicks * (1000L * 1000L * 1000L)) / Stopwatch.Frequency;
// Console.WriteLine(" durWITH:" + currDur);
totalTimeEncData += currDur;
return((Numeric)program.vTable["temperature"]);
}
private void NapDuLieuChoNhaCungCap()
{
BindingList <KH> ds = new BindingList <KH>();
dt = UC_BanHang_TheoChungTuBUS.LayThongTinKhachHang();
if (dt.Rows.Count > 0)
{
KH ncc1 = new KH();
ncc1.Ten = "Tất cả";
ncc1.Ma = "All";
ds.Add(ncc1);
for (int i = 0; i < dt.Rows.Count; i++)
{
KH ncc = new KH();
ncc.Ten = dt.Rows[i]["Tên Khách Hàng"].ToString();
ncc.Ma = dt.Rows[i]["Ma"].ToString();
ds.Add(ncc);
}
cbxemtatca.Properties.DataSource = ds;
cbxemtatca.Properties.DisplayMember = "Ten";
cbxemtatca.Properties.ValueMember = "Ma";
cbxemtatca.EditValue = cbxemtatca.Properties.GetKeyValue(0);
}
}
public IHttpActionResult PostKH(KH kH)
{
string makhachhang;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
String nam = DateTime.Today.Year.ToString();
String nam2so = nam.Substring(2);
var query = db.Database.SqlQuery <string>("XL_LayMaKhachMoiNhat");
if (query.Count() > 0)
{
string prefixID = "KH" + nam2so;
var data = query.FirstOrDefault();
string LastID = data;
int nextID = int.Parse(LastID.Remove(0, prefixID.Length)) + 1;
int lengthNumerID = LastID.Length - prefixID.Length;
string zeroNumber = "";
for (int i = 1; i <= lengthNumerID; i++)
{
if (nextID < Math.Pow(10, i))
{
for (int j = 1; j <= lengthNumerID - i; i++)
{
zeroNumber += "0";
}
}
}
// int ma = Convert.ToInt32(makhach.Substring(4));
makhachhang = prefixID + zeroNumber + nextID.ToString();
}
else
{
makhachhang = "KH" + nam2so + "0001";
}
KH khach = new KH();
khach.MA_KHACH_HANG = makhachhang;
khach.TEN_CONG_TY = kH.TEN_CONG_TY;
khach.VAN_PHONG_GIAO_DICH = kH.VAN_PHONG_GIAO_DICH;
khach.DIA_CHI_XUAT_HOA_DON = kH.DIA_CHI_XUAT_HOA_DON;
khach.TINH = kH.TINH;
khach.QUOC_GIA = kH.QUOC_GIA;
khach.MST = kH.MST;
khach.HOTLINE = kH.HOTLINE;
khach.EMAIL = kH.EMAIL;
khach.FAX = kH.FAX;
khach.LOGO = kH.LOGO;
khach.WEBSITE = kH.WEBSITE;
khach.DIEU_KHOAN_THANH_TOAN = kH.DIEU_KHOAN_THANH_TOAN;
khach.SO_NGAY_DUOC_NO = kH.SO_NGAY_DUOC_NO;
khach.SO_NO_TOI_DA = kH.SO_NO_TOI_DA;
khach.TINH_TRANG_HOAT_DONG = kH.TINH_TRANG_HOAT_DONG;
khach.GHI_CHU = kH.GHI_CHU;
khach.TRUC_THUOC = kH.TRUC_THUOC;
khach.SALES_TAO = kH.SALES_TAO;
db.KHs.Add(khach);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KHExists(kH.MA_KHACH_HANG))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = kH.MA_KHACH_HANG }, kH));
}
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));
}
public IHttpActionResult DeleteKH(string id)
{
KH khachhang = db.KHs.Find(id);
if (khachhang == null)
{
return(NotFound());
}
List <KH_TK_NGAN_HANG> tknganhang = new List <KH_TK_NGAN_HANG>();
tknganhang = db.KH_TK_NGAN_HANG.Where(x => x.MA_KHACH_HANG == id).ToList();
foreach (var item in tknganhang)
{
db.KH_TK_NGAN_HANG.Remove(item);
}
List <KH_THONG_KE_MUA_HANG> thongke = new List <KH_THONG_KE_MUA_HANG>();
thongke = db.KH_THONG_KE_MUA_HANG.Where(x => x.MA_KHACH_HANG == id).ToList();
foreach (var item in thongke)
{
db.KH_THONG_KE_MUA_HANG.Remove(item);
}
List <KH_LIEN_HE> lienhe = new List <KH_LIEN_HE>();
lienhe = db.KH_LIEN_HE.Where(x => x.MA_KHACH_HANG == id).ToList();
foreach (var item in lienhe)
{
var query = db.KH_SALES_PHU_TRACH.Where(x => x.ID_LIEN_HE == item.ID_LIEN_HE).FirstOrDefault();
if (query != null)
{
db.KH_SALES_PHU_TRACH.Remove(query);
}
db.KH_LIEN_HE.Remove(item);
}
List <KH_POLICY> policy = new List <KH_POLICY>();
policy = db.KH_POLICY.Where(x => x.MA_KHACH_HANG == id).ToList();
foreach (var item in policy)
{
db.KH_POLICY.Remove(item);
}
List <KH_PHAN_LOAI_KHACH> phanloai = new List <KH_PHAN_LOAI_KHACH>();
phanloai = db.KH_PHAN_LOAI_KHACH.Where(x => x.MA_KHACH_HANG == id).ToList();
foreach (var item in phanloai)
{
db.KH_PHAN_LOAI_KHACH.Remove(item);
}
List <KH_CHUYEN_SALES> chuyensale = new List <KH_CHUYEN_SALES>();
chuyensale = db.KH_CHUYEN_SALES.Where(x => x.MA_KHACH_HANG == id).ToList();
foreach (var item in chuyensale)
{
db.KH_CHUYEN_SALES.Remove(item);
}
List <KH_PHAN_HOI_KHACH_HANG> phanhoi = new List <KH_PHAN_HOI_KHACH_HANG>();
phanhoi = db.KH_PHAN_HOI_KHACH_HANG.Where(x => x.MA_KHACH_HANG == id).ToList();
foreach (var item in phanhoi)
{
db.KH_PHAN_HOI_KHACH_HANG.Remove(item);
}
List <KH_DC_XUAT_HANG> diachi = new List <KH_DC_XUAT_HANG>();
diachi = db.KH_DC_XUAT_HANG.Where(x => x.MA_KHACH_HANG == id).ToList();
foreach (var item in diachi)
{
db.KH_DC_XUAT_HANG.Remove(item);
}
db.KHs.Remove(khachhang);
db.SaveChanges();
return(Ok(khachhang));
}
private void KH_SelectedIndexChanged(object sender, EventArgs e)
{
KH.SelectAll();
}
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());
}
private void KH_DoubleClick(object sender, EventArgs e)
{
KH.SelectAll();
}
