public ActionResult AddReport()
{
DB.SSRSReport1 temp = new DB.SSRSReport1();
temp.rpt_name = Request.Form["ReportName"];
temp.rpt_desc = Request.Form["ReportDescription"];
string endUserName = Request.Form["CreatedEndUser"];
temp.OwnerEnduserId = DB_MSBDW.endusers.FirstOrDefault(eu => eu.full_name == endUserName).id;
temp.RdlName = Request.Form["RDLName"];
temp.create_date = DateTime.Now;
temp.reportcat_id = 0;
temp.ReportLogId = Convert.ToInt32(Request.Form["ReportLogId"]);
DB.Report_ReportSP r_sp_temp = new DB.Report_ReportSP();
if (Request.Form["UseExisting"] == "Yes")
{
temp.sp_name = Request.Form["ReportSPName"];
DB_MSBDW.SSRSReport1.Add(temp);
DB_MSBDW.SaveChanges();
int SpId = DB_MSBDW.ReportSPs.FirstOrDefault(sp => sp.SPName == temp.sp_name).ID;
r_sp_temp.ReportSPId = SpId;
}
else
{
DB.ReportSP SP = new DB.ReportSP();
SP.SPName = Request.Form["SPName"];
SP.PermissionsNotes = Request.Form["PermissionNotes"];
SP.CreateEnduserId = DB_MSBDW.endusers.FirstOrDefault(eu => eu.full_name == endUserName).id;
SP.RowCreateDate = DateTime.Now;
SP.RowModifyDate = DateTime.Now;
SP.ModifyEnduserId = DB_MSBDW.endusers.FirstOrDefault(eu => eu.full_name == endUserName).id;
SP.IsRDLDropdown = false;
DB_MSBDW.ReportSPs.Add(SP);
DB_MSBDW.SaveChanges();
temp.sp_name = SP.SPName;
DB_MSBDW.SSRSReport1.Add(temp);
DB_MSBDW.SaveChanges();
r_sp_temp.ReportSP = SP;
}
r_sp_temp.SSRSReport = temp;
r_sp_temp.RowCreateDate = DateTime.Now;
DB_MSBDW.Report_ReportSP.Add(r_sp_temp);
DB_MSBDW.SaveChanges();
return(RedirectToAction("Index", "ChangeHistory", new { id = r_sp_temp.SSRSReportId, name = temp.rpt_name }));
}
public ActionResult SaveReportDesc()
{
string test = Request.Form["selectedReportName"];
int reportId = Convert.ToInt32(Request.Form["selectedReportId"]);
DB.SSRSReport1 report = DB_MSBDW.SSRSReport1.FirstOrDefault(re => re.id == reportId);
report.rpt_desc = Request.Form["ReportDescription"];
DB_MSBDW.SaveChanges();
ViewData["ReportDescription"] = Request.Form["ReportDescription"];
ViewData["selectedReportName"] = Request.Form["selectedReportName"];
return(PartialView("_ReportDescription"));
}
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 }));
}
}
