public ActionResult Create(CatImportModel model) { var service = new RestServiceClient<CatImportModel>(UserLogin); service.SetCookies(this.Request.Cookies, _hrm_Hr_Service); var result = service.Post(_hrm_Hr_Service, "api/CatImport/", model); return Json(result, JsonRequestBehavior.AllowGet); }
/// <summary> /// [Tin.Nguyen] - Lấy dữ liệu Nhập Dữ Liệu(Cat_ImportItem) theo Id /// </summary> /// <param name="id"></param> /// <returns></returns> public CatImportModel GetById(Guid id) { string status = string.Empty; var model = new CatImportModel(); ActionService service = new ActionService(UserLogin); var entity = service.GetByIdUseStore<Cat_ImportEntity>(id,ConstantSql.hrm_cat_sp_get_ImportById ,ref status); if (entity != null) { model = entity.CopyData<CatImportModel>(); } model.ActionStatus = status; return model; }
public ActionResult SaveResultInterviewImport([DataSourceRequest] DataSourceRequest request, CatImportModel model) { try { Rec_ImportInterviewResultService importService = new Rec_ImportInterviewResultService { UserID = model.UserID, }; if (importService.SaveInterviewResult()) { return Json(NotificationType.Success.ToString()); } else { return Json(NotificationType.Error.ToString()); } } catch (Exception ex) { return Json(NotificationType.Error + "," + ex.GetBaseException()); } }
public ContentResult ImportResultInterview([DataSourceRequest] DataSourceRequest request, CatImportModel model) { var _fileName = Common.GetPath(Common.TemplateURL) + model.TemplateFile; _fileName = _fileName.Replace("/", "\\"); Rec_ImportInterviewResultService importService = new Rec_ImportInterviewResultService { FileName = _fileName, UserID = model.UserID, }; DataTable dataTableInvalid = new DataTable("InvalidData"); DataTable dataTable = new DataTable("ImportData"); try { importService.ImportInterviewResult(); dataTable = importService.GetImportObject(); dataTableInvalid = importService.GetInvalidObject(); } catch (Exception ex) { model.Description = ex.Message; } var importConfigs = new Dictionary<string, Dictionary<string, object>>(); foreach (DataColumn item in dataTable.Columns) { var displayField = importService.FieldMappings.Where(d => d.Value == item.ColumnName).Select(d => d.Key).FirstOrDefault(); if (string.IsNullOrWhiteSpace(displayField) || importService.ListInvisibleField.Contains(item.ColumnName)) { var config = new Dictionary<string, object>(); config.Add("hidden", true); importConfigs.Add(item.ColumnName, config); } else { var config = new Dictionary<string, object>(); config.Add("title", displayField); importConfigs.Add(item.ColumnName, config); } } model.ListImportData = dataTable.ConfigTable(importConfigs).ToDataSourceResult(request); model.ListInvalidData = dataTableInvalid.ConfigTable().ToDataSourceResult(request); var serializer = new JavaScriptSerializer(); serializer.MaxJsonLength = Int32.MaxValue - 1; var result = new ContentResult(); result.Content = serializer.Serialize(model); result.ContentType = "text/json"; return result; }
public ActionResult SaveImport([DataSourceRequest] DataSourceRequest request, CatImportModel model) { try { if (model.UserID != Guid.Empty && ListImportDataTemp != null && ListImportDataTemp.ContainsKey(model.UserID)) { ImportService importService = new ImportService { UserID = model.UserID, ImportTemplateID = model.ID, DateTimeFormat = model.FormatDate, ImportMode = model.ProcessDuplicateData == HRM.Infrastructure.Utilities.EnumDropDown.DuplicateData.E_INSERT.ToString() ? ImportDataMode.Insert : model.ProcessDuplicateData == HRM.Infrastructure.Utilities.EnumDropDown.DuplicateData.E_UPDATE.ToString() ? ImportDataMode.Update : ImportDataMode.Skip }; importService.ProgressChanged += importService_ProgressChanged; if (importService.Save(model.UserID, ListImportDataTemp[model.UserID], UserLogin)) { ListImportDataTemp[model.UserID] = null; ListImportDataTemp.Remove(model.UserID); return Json(NotificationType.Success.ToString()); } else { return Json(NotificationType.Error.ToString()); } } else { return Json(NotificationType.Error.ToString()); } } catch (Exception ex) { return Json(NotificationType.Error + "," + ex.GetExceptionMessage()); } }
public ContentResult ProgessChanged([DataSourceRequest] DataSourceRequest request, CatImportModel model) { if (ListComputePercent != null && ListComputePercent.ContainsKey(model.UserID)) { var arg = ListComputePercent[model.UserID]; model.Percent = arg.Percent.ToString(); model.ProcessName = arg.Name; model.ProcessNameView = arg.Value; } var serializer = new JavaScriptSerializer(); serializer.MaxJsonLength = Int32.MaxValue - 1; var result = new ContentResult(); result.Content = serializer.Serialize(model); result.ContentType = "text/json"; return result; }
public ContentResult Import([DataSourceRequest] DataSourceRequest request, CatImportModel model) { var _fileName = Common.GetPath(Common.TemplateURL) + model.TemplateFile; _fileName = _fileName.Replace("/", "\\"); ImportService importService = new ImportService { FileName = _fileName, UserID = model.UserID, ImportTemplateID = model.ID, DateTimeFormat = model.FormatDate, ImportMode = model.ProcessDuplicateData == HRM.Infrastructure.Utilities.EnumDropDown.DuplicateData.E_INSERT.ToString() ? ImportDataMode.Insert : model.ProcessDuplicateData == HRM.Infrastructure.Utilities.EnumDropDown.DuplicateData.E_UPDATE.ToString() ? ImportDataMode.Update : ImportDataMode.Skip }; importService.ProgressChanged += importService_ProgressChanged; DataTable dataTableInvalid = new DataTable("InvalidData"); DataTable dataTable = new DataTable("ImportData"); string[] lstFieldInvalid = new string[] { "DataField", "InvalidValue", "ExcelField", "ExcelValue", "ValueType", "Desciption" }; try { importService.Import(); dataTable = importService.ListImportData.Translate(importService.ListValueField.ToArray()); dataTableInvalid = importService.ListInvalidData.Translate(lstFieldInvalid); if (model.UserID != Guid.Empty) { if (ListImportDataTemp == null) { ListImportDataTemp = new Dictionary<Guid, IList>(); } if (ListImportDataTemp.ContainsKey(model.UserID)) { ListImportDataTemp[model.UserID] = importService.ListImportData; } else { ListImportDataTemp.Add(model.UserID, importService.ListImportData); } if (ListInvalidDataTemp == null) { ListInvalidDataTemp = new Dictionary<Guid, IList>(); } if (ListInvalidDataTemp.ContainsKey(model.UserID)) { ListInvalidDataTemp[model.UserID] = importService.ListInvalidData.Select(d => d.ImportData).Distinct().ToList(); } else { ListInvalidDataTemp.Add(model.UserID, importService.ListInvalidData.Select(d => d.ImportData).Distinct().ToList()); } } else { model.Description = "Người dùng ảo"; } if (model.IsImportAndSave) { if (importService.Save(model.UserID, importService.ListImportData, UserLogin)) { model.Description = NotificationType.Success.ToString(); } else { model.Description = NotificationType.Error.ToString(); } } } catch (Exception ex) { model.Description = ex.Message; } model.ListImportData = dataTable.ConfigTable().ToDataSourceResult(request); model.ListInvalidData = dataTableInvalid.ConfigTable().ToDataSourceResult(request); model.UrlInvalidFileName = ExportInvalidData(model.UserID, model.ID, importService); model.ListValueField = importService.ListValueField; model.ListDisplayField = lstFieldInvalid.ToList(); var serializer = new JavaScriptSerializer(); serializer.MaxJsonLength = Int32.MaxValue - 1; var result = new ContentResult(); result.Content = serializer.Serialize(model); result.ContentType = "text/json"; return result; }
public ActionResult ImportResultInterviewValidate(CatImportModel Model) { //if (ListComputePercent != null && ListComputePercent.ContainsKey(Model.UserID)) //{ // ListComputePercent.Remove(Model.UserID); //} //#region Validate string message = string.Empty; //var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<CatImportModel>(Model, "Cat_Import_List", ref message); //if (!checkValidate) //{ // var ls = new object[] { "error", message }; // return Json(ls); //} //#endregion return Json(message); }
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 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 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); }
public ActionResult ImportValidate(CatImportModel Model) { #region Validate string message = string.Empty; var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<CatImportModel>(Model, "Tra_Import_List", ref message); if (!checkValidate) { var ls = new object[] { "error", message }; return Json(ls); } #endregion return Json(message); }