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 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 int SaveSP(SPToUpdate SP) { DB.ReportSP sp = DB_MSBDW.ReportSPs.FirstOrDefault(s => s.ID == SP.ID); switch (SP.ColumnToUpdate) { case "PermissionNotes": sp.PermissionsNotes = SP.FieldValue; break; default: break; } DB_MSBDW.SaveChanges(); return(1); }