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