public ActionResult AddParametersResult()
{
int SSRSReportId = Convert.ToInt32(Request.Form["selectedReportId"]);
string selectedEuName = Request.Form["CreatedEndUser"];
string selectedSPName = Request.Form["ReportSPNameValidated"];
DB.ReportSPParameter temp = new DB.ReportSPParameter();
temp.ReportSPId = DB_MSBDW.ReportSPs.FirstOrDefault(sp => sp.SPName == selectedSPName).ID;
temp.SSRSReportId = SSRSReportId;
temp.RDLParameterName = Request.Form["RDLParameterName"];
temp.ParamDescription = Request.Form["ParamDescription"];
temp.IsUserControlled = Request.Form["IsUserControlled"] == "Yes" ? true : false;
temp.UserControlType = Request.Form["UserControlType"];
temp.IsSetValue = Request.Form["IsSetValue"] == "Yes" ? true : false;
temp.DefaultValue = Request.Form["DefaultValue"];
temp.AdditionalInfo = Request.Form["AdditionalInfo"];
temp.RowCreateDate = DateTime.Now;
temp.CreateEnduserId = DB_MSBDW.endusers.FirstOrDefault(eu => eu.full_name == selectedEuName).id;
DB_MSBDW.ReportSPParameters.Add(temp);
DB_MSBDW.SaveChanges();
ViewData["selectedReportId"] = SSRSReportId;
ViewData["buttonName"] = "PA";
ViewData["selectedReportName"] = Request.Form["selectedReportName"];
return(RedirectToAction("Index", "Parameters", new { id = SSRSReportId, name = Request.Form["selectedReportName"] }));
}
public int SavePara(ParameterToUpdate para)
{
DB.ReportSPParameter pa = DB_MSBDW.ReportSPParameters.FirstOrDefault(l => l.ID == para.ID);
switch (para.ColumnToUpdate)
{
case "RDLParamName":
pa.RDLParameterName = para.FieldValue;
break;
case "ParameterDesc":
pa.ParamDescription = para.FieldValue;
break;
case "IsUserControlled":
if (para.FieldValue == "True")
{
pa.IsUserControlled = true; pa.IsSetValue = false;
}
else
{
pa.IsUserControlled = false; pa.IsSetValue = true;
}
break;
case "UserControlType":
pa.UserControlType = para.FieldValue;
break;
case "DefaultValue":
pa.DefaultValue = para.FieldValue;
break;
case "AdditionalInfo":
pa.AdditionalInfo = para.FieldValue;
break;
default:
break;
}
DB_MSBDW.SaveChanges();
return(1);
}
