public PartialViewResult UploadFileAjax(HttpPostedFileBase itemExcelFile)
{
var qtyPacked = string.Empty;
var qty = string.Empty;
var data = (new ExcelReader()).ReadExcel(itemExcelFile);
var model = new List <TraCafItemDetails>();
if (data != null)
{
foreach (var dataRow in data.DataRows)
{
if (dataRow[0] == "")
{
continue;
}
var item = new TraCafItemDetails();
item.SirsNumber = dataRow[0].ToString();
item.CreatedDate = DateTime.Now;
item.CreatedBy = CurrentUser.USER_ID;
item.PoliceNumber = dataRow[3].ToString();
item.Supervisor = dataRow[4].ToString();
item.IncidentLocation = dataRow[6].ToString();
item.IncidentDescription = dataRow[7].ToString();
item.EmployeeName = dataRow[8].ToString();
item.EmployeeId = dataRow[9].ToString();
item.Area = dataRow[10].ToString();
item.VehicleModel = dataRow[11].ToString();
item.VendorName = dataRow[12].ToString();
double d = double.Parse(dataRow[5].ToString());
try
{
DateTime conv = DateTime.FromOADate(d);
item.IncidentDate = conv;
}
catch (Exception)
{
item.Message = "Failed to parse Incident Date from excel";
model.Add(item);
continue;
}
var dataTovalidate = AutoMapper.Mapper.Map <TraCafDto>(item);
string message = "";
_cafBLL.ValidateCaf(dataTovalidate, out message);
item.Message = message;
model.Add(item);
}
}
var modelData = new TraCafUploadViewModel();
modelData.Details = model;
return(PartialView("_UploadFileDocumentsList", modelData));
}
public ActionResult Upload()
{
var model = new TraCafUploadViewModel();
model.MainMenu = _mainMenu;
model.CurrentLogin = CurrentUser;
return(View("UploadDashboard", model));
}
public ActionResult Upload(TraCafUploadViewModel model)
{
try
{
var data = AutoMapper.Mapper.Map <List <TraCafDto> >(model.Details);
_cafBLL.SaveList(data, CurrentUser);
}
catch (Exception ex)
{
AddMessageInfo(ex.Message, Enums.MessageInfoType.Error);
}
return(RedirectToAction("Index"));
}
