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