public JsonResult ImportTrainee([DataSourceRequest] DataSourceRequest request, CatImportModel model)
{
var services = new Tra_TraineeServices();
List<Tra_TraineeScoreImport> lstTraineeScore = new List<Tra_TraineeScoreImport>();
List<Tra_TraineeScoreImport> DataError = new List<Tra_TraineeScoreImport>();
List<ImportTraineeEntity> lstTrainee = new List<ImportTraineeEntity>();
List<ImportTraineeEntity> lstTraineeTranslate = new List<ImportTraineeEntity>();
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);
lstTrainee = table.Translate<ImportTraineeEntity>();
foreach (var item in lstTrainee)
{
var entity = new ImportTraineeEntity
{
CodeEmp = item.Column2,
ClassCode = item.Column3,
RequirementCode = item.Column4,
Status = item.Column5
};
lstTraineeTranslate.Add(entity);
}
var lstEntity = services.GetListTrainee(lstTraineeTranslate,UserLogin);
if (lstEntity.Count > 0)
{
return Json(lstEntity.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
model.Description = ex.Message;
}
return Json(DataError.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
public JsonResult SaveChangeClass([DataSourceRequest] DataSourceRequest request, CatImportModel model)
{
var services = new Tra_TraineeServices();
List<ImportTraineeEntity> lstTrainee = new List<ImportTraineeEntity>();
List<Tra_TraineeChangeClassEntity> lstTraineeTranslate = new List<Tra_TraineeChangeClassEntity>();
List<Tra_TraineeScoreImport> DataError = new List<Tra_TraineeScoreImport>();
var _fileName = Common.GetPath(Common.TemplateURL) + model.TemplateFile;
_fileName = _fileName.Replace("/", "\\");
ImportService = new ImportService
{
FileName = _fileName,
DateTimeFormat = model.FormatDate,
ImportTemplateID = model.ID,
};
try
{
var table = ImportService.ImportNew(_fileName, model.TemplateFile, model.ID);
lstTrainee = table.Translate<ImportTraineeEntity>();
foreach (var item in lstTrainee)
{
var entity = new Tra_TraineeChangeClassEntity
{
CodeEmp = item.Column2,
ClassOldCode = item.Column3,
ClassNewCode = item.Column4
};
lstTraineeTranslate.Add(entity);
}
var message = services.ImportChangeClass(lstTraineeTranslate,UserLogin);
if (message == NotificationType.Success.ToString())
{
return Json(message, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
model.Description = ex.Message;
}
return Json(DataError.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
public JsonResult SaveImortScore([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 message = services.SaveListTraineeScore(lstTraineeScoreTranslate, out DataError);
if (message == NotificationType.Success.ToString())
{
return Json(message, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
model.Description = ex.Message;
}
return Json(DataError.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
