// [HttpPost] public ActionResult ExportTraineeList([DataSourceRequest] DataSourceRequest request, Tra_TraineeSearchModel1 model) { return ExportAllAndReturn<Tra_TraineeEntity, Tra_TraineeModel, Tra_TraineeSearchModel1>(request, model, ConstantSql.hrm_tra_sp_get_Trainee); }
public ActionResult ExportTraineeListByTemplate([DataSourceRequest] DataSourceRequest request, Tra_TraineeSearchModel1 model) { string status = string.Empty; var isDataTable = false; object obj = new Tra_TraineeModel(); request.Page = 1; request.PageSize = int.MaxValue - 1; var result = GetListData<Tra_TraineeModel, Tra_TraineeEntity, Tra_TraineeSearchModel1>(request, model, ConstantSql.hrm_tra_sp_get_Trainee, ref status); //Guid[] classID = null; //if (!string.IsNullOrEmpty(model.ClassID.Value)) //{ // 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.Value)) //{ // courseID = model.CourseID.Split(',').Select(s => Guid.Parse(s)).ToArray(); // if (courseID != null) // { // result = result.Where(s => courseID.Contains(s.CourseID)).ToList(); // } //} //Guid[] RequirementTrainIDs = null; //if (!string.IsNullOrEmpty(model.RequirementTrainID)) //{ // RequirementTrainIDs = model.RequirementTrainID.Split(',').Select(s => Guid.Parse(s)).ToArray(); // result = result.Where(s => s.RequirementTrainID != null && RequirementTrainIDs.Contains((Guid)s.RequirementTrainID)).ToList(); //} var listModel = new List<Tra_TraineeModel>(); var hreServiceProfile = new Hre_ProfileServices(); var lstProfile = hreServiceProfile.GetProfileNameAll(); foreach (var item in result) { if (item.TrainerOtherList != null) { string _strTrainerOtherList = item.TrainerOtherList.Replace(" ", ""); string[] lstitem = _strTrainerOtherList.Split(',').ToArray(); if (lstProfile != null && lstitem != null) { List<Hre_ProfileEntity> lstitemprofile = lstProfile.Where(s => lstitem.Contains(s.CodeEmp)).ToList(); string Stringresult = string.Empty; foreach (var itemstring in lstitemprofile) { Stringresult += itemstring.ProfileName + ", "; } if (!string.IsNullOrEmpty(Stringresult)) { Stringresult = Stringresult.Substring(0, Stringresult.Length - 2); } item.TeacherName = Stringresult; } } var newModle = (Tra_TraineeModel)typeof(Tra_TraineeModel).CreateInstance(); foreach (var property in item.GetType().GetProperties()) { newModle.SetPropertyValue(property.Name, item.GetPropertyValue(property.Name)); } listModel.Add(newModle); } 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, listModel, null, model.ExportType); return Json(fullPath); } return Json(listModel.ToDataSourceResult(request)); }
public ActionResult GetTraineeList([DataSourceRequest] DataSourceRequest request, Tra_TraineeSearchModel1 model) { var services = new ActionService(UserLogin); var traineeServices = new Tra_TraineeServices(); string status = string.Empty; var objTrainee = new List<object>(); objTrainee.AddRange(new object[15]); objTrainee[0] = model.ClassID; objTrainee[1] = model.CodeEmp; objTrainee[2] = model.CourseID; objTrainee[3] = model.DateFrom; objTrainee[4] = model.DateTo; objTrainee[8] = model.OrgStructureID; objTrainee[9] = model.ProfileName; objTrainee[10] = model.Status; objTrainee[11] = model.RequirementTrainName; objTrainee[12] = null; objTrainee[13] = 1; objTrainee[14] = int.MaxValue - 1; var result = services.GetData<Tra_TraineeEntity>(objTrainee, ConstantSql.hrm_tra_sp_get_Trainee, ref status); if (model.RequirementTrainID != null) { List<Guid> _RequirementTrainIDs = model.RequirementTrainID.Split(',').Select(s => Guid.Parse(s)).ToList(); result = traineeServices.GetListTrainees(result, _RequirementTrainIDs); } return Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); }