public ActionResult EditCustomReport(CustomReportViewModel vm) { if (!vm.Columns.Any(c => c.IsSelected)) ModelState.AddModelError("Columns", "At least one column must be selected."); if (ModelState.IsValid) { vm.ReportName = SecurityElement.Escape(vm.ReportName.Trim()); try { var m = new CustomReportsModel(DbUtil.Db, vm.OrgId); m.SaveReport(vm.OriginalReportName, vm.ReportName, vm.Columns.Where(c => c.IsSelected), vm.RestrictToThisOrg); TempDataSaved = true; } catch (Exception) { ModelState.AddModelError("ReportName", "A report by this name already exists."); } } if (ModelState.IsValid) return Redirect(CustomReportsModel.GetEditUrl(vm.ReportName, vm.QueryId, vm.OrgId)); TempDataModelState = ModelState; TempDataCustomReport = vm; return Redirect(CustomReportsModel.GetEditUrl(vm.OriginalReportName, vm.QueryId, vm.OrgId)); }
public ActionResult EditCustomReport(int? orgId, string reportName, Guid queryId) { CustomReportViewModel originalReportViewModel = null; if (TempData[TempDataModelStateKey] != null) { ModelState.Merge((ModelStateDictionary) TempData[TempDataModelStateKey]); originalReportViewModel = TempData[TempDataCustomReportKey] as CustomReportViewModel; } var m = new CustomReportsModel(DbUtil.Db, orgId); var orgName = (orgId.HasValue) ? DbUtil.Db.Organizations.SingleOrDefault(o => o.OrganizationId == orgId.Value).OrganizationName : null; CustomReportViewModel model; if (string.IsNullOrEmpty(reportName)) { model = new CustomReportViewModel(orgId, queryId, orgName, GetAllStandardColumns(m)); return View(model); } model = new CustomReportViewModel(orgId, queryId, orgName, GetAllStandardColumns(m), reportName); var reportXml = m.GetReportByName(reportName); if (reportXml == null) throw new Exception("Report not found."); var columns = MapXmlToCustomReportColumn(reportXml); var showOnOrgIdValue = reportXml.AttributeOrNull("showOnOrgId"); int showOnOrgId; if (!string.IsNullOrEmpty(showOnOrgIdValue) && int.TryParse(showOnOrgIdValue, out showOnOrgId)) model.RestrictToThisOrg = showOnOrgId == orgId; model.SetSelectedColumns(columns); if (originalReportViewModel != null) model.ReportName = originalReportViewModel.ReportName; var alreadySaved = TempData[TempDataSuccessfulSaved] as bool?; model.CustomReportSuccessfullySaved = alreadySaved.GetValueOrDefault(); return View(model); }
public ActionResult EditCustomReport(CustomReportViewModel viewModel) { if (!viewModel.Columns.Any(c => c.IsSelected)) ModelState.AddModelError("Columns", "At least one column must be selected."); if (ModelState.IsValid) { viewModel.ReportName = SecurityElement.Escape(viewModel.ReportName.Trim()); var m = new CustomReportsModel(DbUtil.Db, viewModel.OrgId); var result = m.SaveReport(viewModel.OriginalReportName, viewModel.ReportName, viewModel.Columns.Where(c => c.IsSelected), viewModel.RestrictToThisOrg); switch (result) { case CustomReportsModel.SaveReportStatus.ReportAlreadyExists: ModelState.AddModelError("ReportName", "A report by this name already exists."); break; default: TempData[TempDataSuccessfulSaved] = true; break; } } if (!ModelState.IsValid) { TempData[TempDataModelStateKey] = ModelState; TempData[TempDataCustomReportKey] = viewModel; return RedirectToAction("EditCustomReport", new { reportName = viewModel.OriginalReportName, orgId = viewModel.OrgId, queryId = viewModel.QueryId }); } return RedirectToAction("EditCustomReport", new { reportName = viewModel.ReportName, orgId = viewModel.OrgId, queryId = viewModel.QueryId }); }
public CustomReportViewModel EditCustomReport(CustomReportViewModel originalReportViewModel, bool? alreadySaved) { var orgName = orgid.HasValue ? DbUtil.Db.Organizations.SingleOrDefault(o => o.OrganizationId == orgid.Value)?.OrganizationName : null; if (!Report.HasValue()) return new CustomReportViewModel(orgid, queryid, orgName, GetAllStandardColumns()); var vm = new CustomReportViewModel(orgid, queryid, orgName, GetAllStandardColumns(), Report); var reportXml = GetReportByName(); if (reportXml == null) throw new Exception("Report not found."); var columns = MapXmlToCustomReportColumn(reportXml); var showOnOrgIdValue = reportXml.AttributeOrNull("showOnOrgId"); int showOnOrgId; if (!string.IsNullOrEmpty(showOnOrgIdValue) && int.TryParse(showOnOrgIdValue, out showOnOrgId)) vm.RestrictToThisOrg = showOnOrgId == orgid; vm.SetSelectedColumns(columns); vm.Columns = vm.Columns.OrderBy(cc => cc.Order).ToList(); if (originalReportViewModel != null) vm.ReportName = originalReportViewModel.ReportName; vm.CustomReportSuccessfullySaved = alreadySaved.GetValueOrDefault(); return vm; }