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; }