public ActionResult ImportCategories(HttpPostedFileBase postedExcelFile)
{
if (ModelState.IsValid)
{
if (postedExcelFile == null)
{
ModelState.AddModelError("File", "Please Upload Your file");
TempData["Error"] = "Please Upload Your file.";
return(RedirectToAction("Index"));
}
else if (postedExcelFile.ContentLength > UtilityConstants.MaxContentLength)
{
TempData["Error"] = "SizeExceed";
return(RedirectToAction("Index"));
//return Content("SizeExceed");
}
else if (postedExcelFile.ContentLength > 0)
{
string path = ExcelHelper.SavePathForThePostedFile(postedExcelFile);
if (!(path.Contains("xlsx") || path.Contains("xls")))
{
return(Content("FileFormatError"));
}
try
{
List <CategoryImportExcel> records = ExcelHelper.ReadSheet <CategoryImportExcel>(path, true, 0, null, true).ToList();
records = records.Where(r => !string.IsNullOrEmpty(r.CategoryName) && !string.IsNullOrEmpty(r.CreatedByUser)).ToList();
if (records.Count > 0)
{
objCategoryBO.InsertCategoryInBulk(records);
TempData["Success"] = $"\"NumberOfRecords Uploaded\" : {records.Count()}";
return(RedirectToAction("Index"));
}
TempData["Success"] = $"\"NumberOfRecords Uploaded\" : 0";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
if (ex.Message.Contains("InValidZipCode"))
{
return(Content(ex.Message));
}
}
}
}
return(Content("Error"));
//if (Request.Files["postedExcelFile"].ContentLength > 0)
//{
// string fileExtension = System.IO.Path.GetExtension(Request.Files["postedExcelFile"].FileName);
//}
// return View();
}
