public JsonResult ImportScore([DataSourceRequest] DataSourceRequest request, CatImportModel model)
{
var services = new Tra_TraineeScoreServices();
List<Tra_TraineeScoreImport> lstTraineeScore = new List<Tra_TraineeScoreImport>();
List<Tra_TraineeScoreImport> lstTraineeScoreTranslate = new List<Tra_TraineeScoreImport>();
List<Tra_TraineeScoreImport> DataError = new List<Tra_TraineeScoreImport>();
var _fileName = Common.GetPath(Common.TemplateURL) + model.TemplateFile;
_fileName = _fileName.Replace("/", "\\");
ImportService = new ImportService
{
//FileName = Common.GetPath(model.TemplateFile),
FileName = _fileName,
DateTimeFormat = model.FormatDate,
ImportTemplateID = model.ID,
};
try
{
var table = ImportService.ImportNew(_fileName, model.TemplateFile, model.ID);
lstTraineeScore = table.Translate<Tra_TraineeScoreImport>();
foreach (var item in lstTraineeScore)
{
var entity = new Tra_TraineeScoreImport
{
ClassCode = item.Column2,
CodeEmp = item.Column3,
TopicCode = item.Column4,
TypeScore = item.Column5,
Score = item.Column6,
TypeError = item.Column7,
};
lstTraineeScoreTranslate.Add(entity);
}
var lstEntity = services.GetListTraineeScore(lstTraineeScoreTranslate, out DataError);
if (DataError.Count > 0)
{
return Json(DataError.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
model.Description = ex.Message;
}
return Json(DataError.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
