public ActionResult UserBasic_DeleteConfirmed(int id)
{
User_Basic user_Basic = db.User_Basic.Find(id);
user_Basic.Status = "Disable";
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult User_Basic_EditConfirm([Bind(Include = "User_ID,User_Code,Password,User_First_Name,User_Last_Name,User_Alternative_Name,User_DoB_Day,User_DoB_Month,User_DoB_Year,Gender,Address_Detail,Address_District,Email,Phone,Role,Client_Code,Education_Type_Code,Job_Type_Code,Job_Detail,Status,Note")] User_Basic user_Basic)
{
if (ModelState.IsValid)
{
db.Entry(user_Basic).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user_Basic));
}
public ActionResult Information()
{
var mykey = Int32.Parse(Request.Cookies["key"].Value);
User_Basic userbasic = db.User_Basic.Find(mykey);
if (userbasic == null)
{
return(HttpNotFound());
}
return(PartialView(userbasic));
}
//xóa userbasic
public ActionResult User_Basic_Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
User_Basic user_Basic = db.User_Basic.Find(id);
if (user_Basic == null)
{
return(HttpNotFound());
}
return(PartialView(user_Basic));
}
public ActionResult User_Basic_MultiUpload(HttpPostedFileBase file)
{
try
{
if (file.ContentLength > 0)
{
ViewBag.ErrorFileName = "";
ViewBag.CurrentFunctionExcelUpload = "UserBasic";
string ErrorFileName = "";
string _FileName = Path.GetFileName(file.FileName);
string _path = Path.Combine(Server.MapPath("~/App_Data/uploads"), _FileName);
string _TemplatePath = Path.Combine(Server.MapPath("~/App_Data/uploads"), "UserBasic_Template.xlsx");
string _FileExtension = Path.GetExtension(_FileName);
if (_FileExtension == ".xlsx")
{
// lưu file excel lại với tên Usercode_filename.xlsxS
string FileNameToSave = Path.Combine(Server.MapPath("~/App_Data/uploads"), Request.Cookies["UserName"].Value.ToString() + "_" + _FileName);
file.SaveAs(FileNameToSave);
//read file index excel
FileStream fsIndex = new FileStream(FileNameToSave, FileMode.Open);
XSSFWorkbook wbIndex = new XSSFWorkbook(fsIndex);
ISheet sheetIndex = wbIndex.GetSheetAt(0);
var rowIndex = sheetIndex.GetRow(0);
//read file template excel
FileStream fsTemplate = new FileStream(_TemplatePath, FileMode.Open);
XSSFWorkbook wbTemplate = new XSSFWorkbook(fsTemplate);
ISheet sheetTemplate = wbTemplate.GetSheetAt(0);
var rowTemplate = sheetTemplate.GetRow(0);
//vòng lặp kiểm tra file upload != file template
for (int i = 0; i <= 17; i++)
{
if (rowTemplate.GetCell(0).StringCellValue != rowIndex.GetCell(0).StringCellValue)
{
ViewBag.Message = "Sai định dạng template";
return(PartialView());
}
}
if (sheetIndex.LastRowNum == 0)
{
ViewBag.Message = "File rỗng!";
return(PartialView());
}
bool checkError = true;
for (int i = 1; i <= sheetIndex.LastRowNum; i++)
{
string error = "";
var rowNow = sheetIndex.GetRow(i);
// cộng lỗi vào chuổi error
//CHECK_IS_NULL kiểm tra khác rổng
//CHECK_NUMBER_TYPE kiểm tra dạng sổ
//CHECK_ISNULL_AND_NUMBER kiểm khác rống và dạng sô
error += Check_Format_Excel(sheetIndex, CHECK_IS_NULL, i, 0);
error += Check_Format_Excel(sheetIndex, CHECK_IS_NULL, i, 1);
error += Check_Format_Excel(sheetIndex, CHECK_NUMBER_TYPE, i, 3);
error += Check_Format_Excel(sheetIndex, CHECK_NUMBER_TYPE, i, 4);
error += Check_Format_Excel(sheetIndex, CHECK_ISNULL_AND_NUMBER, i, 5);
error += Check_Format_Excel(sheetIndex, CHECK_IS_NULL, i, 6);
error += Check_Format_Excel(sheetIndex, CHECK_IS_NULL, i, 7);
error += Check_Format_Excel(sheetIndex, CHECK_ISNULL_AND_NUMBER, i, 8);
if ((rowNow.GetCell(9) == null) && (rowNow.GetCell(10) == null))
{
error += "Missing Email or Phone | ";
}
error += Check_Format_Excel(sheetIndex, CHECK_IS_NULL, i, 11);
error += Check_Format_Excel(sheetIndex, CHECK_IS_NULL, i, 12);
error += Check_Format_Excel(sheetIndex, CHECK_IS_NULL, i, 13);
if (error == "")
{
//lưu lại nếu không có lỗi trong rownow
User_Basic userbasic = new User_Basic();
userbasic.User_First_Name = rowNow.GetCell(0).ToString();
userbasic.User_Last_Name = rowNow.GetCell(1).ToString();
if (rowNow.GetCell(2) != null)
{
userbasic.User_Alternative_Name = rowNow.GetCell(2).StringCellValue;
}
userbasic.User_DoB_Day = Int32.Parse(rowNow.GetCell(3).ToString());
userbasic.User_DoB_Month = Int32.Parse(rowNow.GetCell(4).ToString());
userbasic.User_DoB_Year = Int32.Parse(rowNow.GetCell(5).ToString());
userbasic.Gender = rowNow.GetCell(6).ToString();
userbasic.Address_Detail = rowNow.GetCell(7).ToString();
userbasic.Address_District = Int32.Parse(rowNow.GetCell(8).ToString());
if (rowNow.GetCell(9) != null)
{
userbasic.Email = rowNow.GetCell(9).ToString();
}
if (rowNow.GetCell(10) != null)
{
userbasic.Phone = rowNow.GetCell(10).ToString();
}
userbasic.Role = rowNow.GetCell(11).StringCellValue;
userbasic.Client_Code = rowNow.GetCell(12).ToString();
userbasic.Education_Type_Code = rowNow.GetCell(13).ToString();
if (rowNow.GetCell(14) != null)
{
userbasic.Job_Type_Code = rowNow.GetCell(14).ToString();
}
if (rowNow.GetCell(15) != null)
{
userbasic.Job_Detail = rowNow.GetCell(15).ToString();
}
userbasic.CreateBy = Request.Cookies["UserName"].Value;
userbasic.CreateDate = DateTime.Today;
//userbasic.User_Code = userbasic.Role +
db.User_Basic.Add(userbasic);
db.SaveChanges();
}
else
{
checkError = false;
string tempxx = rowNow.GetCell(6).StringCellValue;
var RowErrorIndex = sheetTemplate.CreateRow(i);
for (int j = 0; j <= 17; j++)
{
if (rowNow.GetCell(j) != null)
{
RowErrorIndex.CreateCell(j).SetCellValue(rowNow.GetCell(j).ToString());
}
}
RowErrorIndex.CreateCell(17).SetCellValue(error);
string tempxxx = sheetTemplate.GetRow(1).GetCell(6).StringCellValue;
}
}
if (!checkError)
{
ErrorFileName = Request.Cookies["UserName"].Value.ToString() + "_Error.xlsx";
string ErrorPath = Path.Combine(Server.MapPath("~/App_Data/uploads"), ErrorFileName);
FileStream fsError = new FileStream(ErrorPath, FileMode.Create);
wbTemplate.Write(fsError);
fsError.Close();
fsTemplate.Close();
fsIndex.Close();
ViewBag.Message = "Lỗi trong file upload.";
ViewBag.ErrorFileName = ErrorFileName;
return(PartialView());
}
}
else
{
ViewBag.Message = "Sai định dạng file .xlsx";
return(PartialView());
}
}
ViewBag.Message = "Cập nhật thành công!";
return(PartialView());
}
catch
{
ViewBag.Message = "Cập nhật thất bại!";
return(PartialView());
}
}