public ActionResult AddLinkagesResult()
{
int SSRSReportId = Convert.ToInt32(Request.Form["selectedReportId"]);
string selectedEuName = Request.Form["CreatedEndUser"];
DB.ReportLinkage temp = new DB.ReportLinkage();
temp.SSRSReportId = SSRSReportId;
temp.LinkageType = Request.Form["LinkageType"];
temp.LinkLocation = Request.Form["LinkLocation"];
temp.CreateEnduserId = DB_MSBDW.endusers.FirstOrDefault(eu => eu.full_name == selectedEuName).id;
temp.RowCreateDate = DateTime.Now;
DB_MSBDW.ReportLinkages.Add(temp);
DB_MSBDW.SaveChanges();
List <DB.ReportLinkage> reportLink = DB_MSBDW.ReportLinkages.Where(sp => sp.SSRSReportId == SSRSReportId).OrderByDescending(sp => sp.RowCreateDate).ToList();
LinkagesViewModel storedProcsViewModel = new LinkagesViewModel(reportLink);
ViewData["selectedReportId"] = SSRSReportId;
ViewData["buttonName"] = "LK";
ViewData["selectedReportName"] = Request.Form["selectedReportName"];
return(RedirectToAction("Index", "Linkages", new { id = SSRSReportId, name = Request.Form["selectedReportName"] }));
}
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 ActionResult AddStoredProcsResult()
{
int SSRSReportId = Convert.ToInt32(Request.Form["selectedReportId"]);
string selectedEuName = Request.Form["CreatedEndUser"];
if (Request.Form["UseExisting"] == "Yes")
{
string reportSPName = Request.Form["ReportSPName"];
int reportSPId = DB_MSBDW.ReportSPs.FirstOrDefault(sp => sp.SPName == reportSPName).ID;
if (!DB_MSBDW.Report_ReportSP.Any(sp => sp.ReportSPId == reportSPId && sp.SSRSReportId == SSRSReportId))
{
DB.Report_ReportSP r_sp_temp = new DB.Report_ReportSP();
r_sp_temp.ReportSPId = reportSPId;
r_sp_temp.SSRSReportId = SSRSReportId;
r_sp_temp.RowCreateDate = DateTime.Now;
DB_MSBDW.Report_ReportSP.Add(r_sp_temp);
DB_MSBDW.SaveChanges();
}
}
else
{
DB.ReportSP temp = new DB.ReportSP();
temp.SPName = Request.Form["SPName"];
temp.PermissionsNotes = Request.Form["PermissionNotes"];
temp.CreateEnduserId = DB_MSBDW.endusers.FirstOrDefault(eu => eu.full_name == selectedEuName).id;
temp.RowCreateDate = DateTime.Now;
temp.RowModifyDate = DateTime.Now;
temp.ModifyEnduserId = DB_MSBDW.endusers.FirstOrDefault(eu => eu.full_name == selectedEuName).id;
temp.IsRDLDropdown = false;
DB_MSBDW.ReportSPs.Add(temp);
DB_MSBDW.SaveChanges();
DB.Report_ReportSP r_sp_temp = new DB.Report_ReportSP();
r_sp_temp.ReportSP = temp;
r_sp_temp.SSRSReport = DB_MSBDW.SSRSReport1.FirstOrDefault(r => r.id == SSRSReportId);
r_sp_temp.RowCreateDate = DateTime.Now;
DB_MSBDW.Report_ReportSP.Add(r_sp_temp);
DB_MSBDW.SaveChanges();
}
ViewData["selectedReportId"] = SSRSReportId;
ViewData["buttonName"] = "SP";
ViewData["selectedReportName"] = Request.Form["selectedReportName"];
return(RedirectToAction("Index", "StoredProcs", new { id = SSRSReportId, name = Request.Form["selectedReportName"] }));
}
public ActionResult Index()
{
int selectedReport;
string SelectedReportName;
if (Request.Form["selectedReportName"] != null && Request.Form["selectedReportName"] != "select report" && Request.Form["selectedReportName"] != "")
{
SelectedReportName = Request.Form["selectedReportName"];
selectedReport = DB_MSBDW.SSRSReport1.FirstOrDefault(r => r.rpt_name == SelectedReportName).id;
}
else
{
return(RedirectToAction("Index", "Home"));
}
if (Request.Form["ReportDescription"] != null)
{
DB.SSRSReport1 report = DB_MSBDW.SSRSReport1.FirstOrDefault(re => re.id == selectedReport);
report.rpt_desc = Request.Form["ReportDescription"];
DB_MSBDW.SaveChanges();
}
if (Request.Form["buttonName"] == "SP")
{
return(RedirectToAction("Index", "StoredProcs", new { id = selectedReport, name = SelectedReportName }));
}
else if (Request.Form["buttonName"] == "LK")
{
return(RedirectToAction("Index", "Linkages", new { id = selectedReport, name = SelectedReportName }));
}
else if (Request.Form["buttonName"] == "PA")
{
return(RedirectToAction("Index", "Parameters", new { id = selectedReport, name = SelectedReportName }));
}
else
{
return(RedirectToAction("Index", "ChangeHistory", new { id = selectedReport, name = SelectedReportName }));
}
}
public ActionResult AddChangeHistoryResult()
{
int SSRSReportId = Convert.ToInt32(Request.Form["selectedReportId"]);
string selectedSPName = Request.Form["IsRDLChange"] == "No" ? Request.Form["ReportSPNameValidated"]: Request.Form["ReportSPName"];
List <int> UnSelectedRepIds = new List <int>();
List <DB.Report_ReportSP> relatedRpts = new List <DB.Report_ReportSP>();
int selectedSPId = -1;
if (selectedSPName != "" && selectedSPName != null)
{
selectedSPId = DB_MSBDW.ReportSPs.FirstOrDefault(s => s.SPName == selectedSPName).ID;
relatedRpts = DB_MSBDW.Report_ReportSP.Where(sp => sp.ReportSPId == selectedSPId).Distinct().ToList();
string cbl1 = "checkboxlist[", cbl2 = "].id", cbl3 = "].isselected";
if (Request.Form[cbl1 + "0" + cbl3] != null)
{
for (int i = 0; i < relatedRpts.Count - 1; i++)
{
if (!Request.Form[cbl1 + i.ToString() + cbl3].Contains("true".ToLower()))
{
UnSelectedRepIds.Add(Convert.ToInt32(Request.Form[cbl1 + i.ToString() + cbl2]));
}
}
}
}
string selectedEuName = Request.Form["CreatedEndUser"];
for (int i = 0; i < relatedRpts.Count || (Request.Form["IsRDLChange"] == "Yes" && relatedRpts.Count == 0); i++) // both with SP selected(at least one in relatedreports list, including "Yes" + SP and "No" + SP) and "Yes" + no SP can go through, and prevent "Yes" + SP index out of range exception
{
DB.ReportChangeLog temp = new DB.ReportChangeLog();
temp.ITComment = Request.Unvalidated.Form["ITComment"];
temp.PublicComment = Request.Form["PublicComment"];
temp.RowCreateDate = DateTime.Now;
temp.ChangeEnduserId = DB_MSBDW.endusers.FirstOrDefault(eu => eu.full_name == selectedEuName).id;
temp.ChangeReason = Request["ChangeReason"];
if (selectedSPId == -1 && Request.Form["IsRDLChange"] == "Yes") // For IsRdlChange is yes and no SP selected, break from the loop
{
temp.SSRSReportId = SSRSReportId;
temp.IsRDLChange = true;
DB_MSBDW.ReportChangeLogs.Add(temp);
DB_MSBDW.SaveChanges();
break;
}
temp.ReportSPId = selectedSPId;
temp.SSRSReportId = relatedRpts[i].SSRSReportId;
if (Request.Form["IsRDLChange"] == "Yes" && !UnSelectedRepIds.Contains((int)relatedRpts[i].SSRSReportId)) // Only the selected reports(from checkboxlist) and current report will get flagged isrdgchange true when user selects IsRDlChange Yes
{
temp.IsRDLChange = true;
}
else
{
temp.IsRDLChange = false;
}
DB_MSBDW.ReportChangeLogs.Add(temp);
DB_MSBDW.SaveChanges();
}
List <DB.ReportChangeLog> reportChange = DB_MSBDW.ReportChangeLogs.Where(sp => sp.SSRSReportId == SSRSReportId).OrderByDescending(sp => sp.RowCreateDate).ToList();
ChangeHistoryViewModel changeHistoryViewModel = new ChangeHistoryViewModel(reportChange);
ViewData["selectedReportId"] = SSRSReportId;
ViewData["buttonName"] = "CH";
ViewData["selectedReportName"] = Request.Form["selectedReportName"];
return(RedirectToAction("Index", "ChangeHistory", new { id = SSRSReportId, name = Request.Form["selectedReportName"] }));
}
