public ActionResult Create([Bind(Include = "localID,stb,tendaydu,socmt,noicap,diachi,nguoidk,diachidl,matinh,khuvuc,anhcmt,flag")] Models.eloadPttb eloadPttb, FormCollection collection)
{
try
{
if (ModelState.IsValid)
{
eloadPttb.id = Guid.NewGuid();
eloadPttb.ngaysinh = collection["ngaysinh"].StringToShortDatetime();
eloadPttb.ngaycap = collection["ngaycap"].StringToShortDatetime();
eloadPttb.ngaydk = collection["ngaydk"].DateTimeParseExactVNToEN();
eloadPttb.ngaysua = collection["ngaysua"].DateTimeParseExactVNToEN();
eloadPttb.createdBy = Authentication.Auth.AuthUser.id.ToString();
eloadPttb.createdAt = DateTime.Now;
eloadPttb.updatedBy = Authentication.Auth.AuthUser.id.ToString();
eloadPttb.updatedAt = eloadPttb.createdAt;
db.eloadPttbs.Add(eloadPttb);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
this.danger(TM.Common.Language.msgCreateError);
}
}
catch (Exception ex)
{
this.danger(ex.Message);
}
ViewBag.local = db.locals.Where(d => d.flag > 0).ToList();
return(View(eloadPttb));
}
public ActionResult Edit([Bind(Include = "id,localID,stb,tendaydu,socmt,noicap,diachi,nguoidk,diachidl,matinh,khuvuc,anhcmt,flag")] Models.eloadPttb eloadPttb_tmp, FormCollection collection)
{
try
{
if (ModelState.IsValid)
{
var eloadPttb = db.eloadPttbs.Find(eloadPttb_tmp.id);
eloadPttb.localID = eloadPttb_tmp.localID;
eloadPttb.stb = eloadPttb_tmp.stb;
eloadPttb.tentb = eloadPttb_tmp.tentb;
eloadPttb.ngaysinh = collection["ngaysinh"].StringToShortDatetime();
eloadPttb.socmt = eloadPttb_tmp.socmt;
eloadPttb.ngaycap = collection["ngaycap"].StringToShortDatetime();
eloadPttb.noicap = eloadPttb_tmp.noicap;
eloadPttb.diachi = eloadPttb_tmp.diachi;
eloadPttb.nguoidk = eloadPttb_tmp.nguoidk;
eloadPttb.ngaydk = collection["ngaydk"].DateTimeParseExactVNToEN();
eloadPttb.ngaysua = collection["ngaysua"].DateTimeParseExactVNToEN();
eloadPttb.diachidl = eloadPttb_tmp.diachidl;
eloadPttb.matinh = eloadPttb_tmp.matinh;
eloadPttb.khuvuc = eloadPttb_tmp.khuvuc;
eloadPttb.anhcmt = eloadPttb_tmp.anhcmt;
eloadPttb.flag = eloadPttb_tmp.flag;
eloadPttb.updatedBy = Authentication.Auth.AuthUser.id.ToString();
eloadPttb.updatedAt = DateTime.Now;
db.Entry(eloadPttb).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
this.danger(TM.Common.Language.msgUpdateError);
}
}
catch (Exception ex)
{
this.danger(ex.Message);
}
ViewBag.local = db.locals.Where(d => d.flag > 0).ToList();
return(View(eloadPttb_tmp));
}
public ActionResult Upload()
{
try
{
if (Request.Files.Count < 1)
{
this.warning("Vui lòng Chọn tệp!");
return(RedirectToAction("Create"));
}
var file = TM.IO.FileDirectory.Upload(Request.Files, TM.Common.Directories.ccbs, false, new[] { ".xls", ".xlsx" }, 5);
foreach (var item in file.UploadFile())
{
var excel = new TM.Interop.Excel(TM.IO.FileDirectory.MapPath(TM.Common.Directories.ccbs + item));
var list = excel.ToList();
for (var i = 6; i < list.Count; i++)
{
var eloadPttb = new Models.eloadPttb();
eloadPttb.id = Guid.NewGuid();
eloadPttb.stb = long.Parse(list[i][2].ToString());
//
//if (CheckExist(eloadPttb.stb.Value)) continue;
var eloadPttbExist = CheckExistPttb(eloadPttb.stb.Value);
if (eloadPttbExist != null)
{
eloadPttbExist.tentb = list[i][3].ToString();
eloadPttbExist.ngaysinh = list[i][5].ToString().StringToShortDatetime();
eloadPttbExist.socmt = long.Parse(list[i][7].ToString());
eloadPttbExist.ngaycap = list[i][8].ToString().StringToShortDatetime();
eloadPttbExist.noicap = list[i][10].ToString();
eloadPttbExist.diachi = list[i][11].ToString();
eloadPttbExist.nguoidk = list[i][20].ToString();
eloadPttbExist.ngaydk = list[i][16].ToString().DateTimeParseExactVNToEN();
eloadPttbExist.ngaysua = list[i][18].ToString().DateTimeParseExactVNToEN();
eloadPttbExist.diachidl = list[i][21].ToString();
eloadPttbExist.matinh = list[i][23].ToString();
eloadPttbExist.khuvuc = Int32.Parse(list[i][24].ToString());
eloadPttbExist.anhcmt = list[i][25].ToString() == "Co" ? 1 : 0;
eloadPttbExist.localID = getLocal(eloadPttbExist.nguoidk);
eloadPttbExist.updatedBy = Authentication.Auth.AuthUser.id.ToString();
eloadPttbExist.updatedAt = DateTime.Now;;
db.Entry(eloadPttbExist).State = EntityState.Modified;
db.SaveChanges();
continue;
}
//
eloadPttb.tentb = list[i][3].ToString();
eloadPttb.ngaysinh = list[i][5].ToString().StringToShortDatetime();
eloadPttb.socmt = long.Parse(list[i][7].ToString());
eloadPttb.ngaycap = list[i][8].ToString().StringToShortDatetime();
eloadPttb.noicap = list[i][10].ToString();
eloadPttb.diachi = list[i][11].ToString();
eloadPttb.nguoidk = list[i][20].ToString();
eloadPttb.ngaydk = list[i][16].ToString().DateTimeParseExactVNToEN();
eloadPttb.ngaysua = list[i][18].ToString().DateTimeParseExactVNToEN();
eloadPttb.diachidl = list[i][21].ToString();
eloadPttb.matinh = list[i][23].ToString();
eloadPttb.khuvuc = Int32.Parse(list[i][24].ToString());
eloadPttb.anhcmt = list[i][25].ToString() == "Co" ? 1 : 0;
eloadPttb.flag = 1;
eloadPttb.localID = getLocal(eloadPttb.nguoidk);
eloadPttb.createdBy = Authentication.Auth.AuthUser.id.ToString();
eloadPttb.createdAt = DateTime.Now;
eloadPttb.updatedBy = Authentication.Auth.AuthUser.id.ToString();
eloadPttb.updatedAt = eloadPttb.createdAt;
db.eloadPttbs.Add(eloadPttb);
if (i % 100 == 0)
{
db.SaveChanges();
}
}
}
db.SaveChanges();
this.success("Cập nhật thành công!");
}
catch (Exception ex)
{
this.danger(ex.Message);
}
return(RedirectToAction("Create"));
}
