public ActionResult ExportTraineePassListByTemplate([DataSourceRequest] DataSourceRequest request, Tra_TraineeSearchModel model)
{
string status = string.Empty;
var isDataTable = false;
object obj = new Tra_TraineeModel();
var result = GetListData<Tra_TraineeModel, Tra_TraineeEntity, Tra_TraineeSearchModel>(request, model, ConstantSql.hrm_tra_sp_get_TraineePass, ref status);
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Tra_TraineeModel(),
FileName = "Tra_Trainee",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportId != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetTraineeWithOutProcess([DataSourceRequest] DataSourceRequest request, Tra_TraineeSearchModel model)
{
return GetListDataAndReturn<Tra_TraineeModel, Tra_TraineeEntity, Tra_TraineeSearchModel>(request, model, ConstantSql.hrm_tra_sp_get_TraineeWithOutProcess);
}
public ActionResult GetTraineePassList([DataSourceRequest] DataSourceRequest request, Tra_TraineeSearchModel model)
{
//return GetListDataAndReturn<Tra_TraineeModel, Tra_TraineeEntity, Tra_TraineeSearchModel>(request, model, ConstantSql.hrm_tra_sp_get_TraineePass);
var status = string.Empty;
var traineeServices = new ActionService(UserLogin);
var objTrainee = new List<object>();
objTrainee.AddRange(new object[12]);
objTrainee[0] = model.ProfileName;
objTrainee[1] = model.CodeEmp;
objTrainee[2] = model.OrgStructureID;
objTrainee[4] = model.DateFrom;
objTrainee[5] = model.DateTo;
objTrainee[10] = 1;
objTrainee[11] = int.MaxValue - 1;
var result = traineeServices.GetData<Tra_TraineeEntity>(objTrainee, ConstantSql.hrm_tra_sp_get_TraineePass, ref status).ToList().Translate<Tra_TraineeModel>();
Guid[] classID = null;
if (!string.IsNullOrEmpty(model.ClassID))
{
classID = model.ClassID.Split(',').Select(s => Guid.Parse(s)).ToArray();
if (classID != null)
{
result = result.Where(s => classID.Contains(s.ClassID)).ToList();
}
}
Guid[] courseID = null;
if (!string.IsNullOrEmpty(model.CourseID))
{
courseID = model.CourseID.Split(',').Select(s => Guid.Parse(s)).ToArray();
if (courseID != null)
{
result = result.Where(s => courseID.Contains(s.CourseID)).ToList();
}
}
return Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
public ActionResult ExportTraineeFailList([DataSourceRequest] DataSourceRequest request, Tra_TraineeSearchModel model)
{
return ExportAllAndReturn<Tra_TraineeEntity,Tra_TraineeModel,Tra_TraineeSearchModel>(request,model,ConstantSql.hrm_tra_sp_get_TraineeFail);
}
public ActionResult GetTraineeFinishInsideList([DataSourceRequest] DataSourceRequest request, Tra_TraineeSearchModel model)
{
return GetListDataAndReturn<Tra_TraineeModel, Tra_TraineeEntity, Tra_TraineeSearchModel>(request, model, ConstantSql.hrm_tra_sp_get_TraineeFinishInside);
}
