/// <summary> /// </summary> /// <param name="id"></param> /// <returns></returns> public Tra_TraineeModel GetById(Guid id) { string status = string.Empty; var model = new Tra_TraineeModel(); ActionService service = new ActionService(UserLogin); var entity = service.GetByIdUseStore<Tra_TraineeEntity>(id,ConstantSql.hrm_tra_sp_get_TraineeById ,ref status); if (entity!=null) { model = entity.CopyData<Tra_TraineeModel>(); } model.ActionStatus = status; return model; }
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 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)); }