public PartialViewResult DeleteReportParameterReturnPartialView(int reportId, int paramId) { try { REPORTS _report = database.REPORTS.Find(reportId); PARAMETERS _filter = database.PARAMETERS.Find(paramId); if (_report.PARAMETERS.Contains(_filter)) { _report.PARAMETERS.Remove(_filter); database.Entry(_report).State = EntityState.Modified; database.PARAMETERS.Remove(_filter); database.SaveChanges(); } } catch (Exception) { } return(PartialView("_ListParamsTable4Report", database.REPORTS.Where(p => p.Report_Id == reportId).FirstOrDefault())); }
public PartialViewResult AddReportParameterReturnPartialView(int reportId, string paramName, string paramType, string paramLabel, bool paramRequired) { try { REPORTS _report = database.REPORTS.Find(reportId); //Create new parameter object and assign values... PARAMETERS _reportParameter = new PARAMETERS(); _reportParameter.ParameterName = paramName; _reportParameter.ParameterType = paramType; _reportParameter.DisplayLabel = paramLabel; _reportParameter.Required = paramRequired; _report.PARAMETERS.Add(_reportParameter); database.Entry(_report).State = EntityState.Modified; database.SaveChanges(); } catch (Exception) { } return(PartialView("_ListParamsTable4Report", database.REPORTS.Where(p => p.Report_Id == reportId).FirstOrDefault())); }