public void ReportSetting() { var header = sPService.GetDataWithoutParameter("USP_GET_REPORT_HEADER").Tables[0].AsEnumerable().Select(x => new ReportHeader() { Id = x.Field <int>(0), CompanyNameLeft = x.Field <int>(1), CompanyNameHeight = x.Field <int>(2), CompanyNameTop = x.Field <int>(3), CompanyNameWidth = x.Field <int>(4), CompanyNameFontSize = x.Field <int>(5), CompanyNameBold = x.Field <bool>(6), CompanyNameAlign = x.Field <string>(7), CompanyAddressLeft = x.Field <int>(8), CompanyAddressHeight = x.Field <int>(9), CompanyAddressTop = x.Field <int>(10), CompanyAddressWidth = x.Field <int>(11), CompanyAddressFontSize = x.Field <int>(12), CompanyAddressBold = x.Field <bool>(13), CompanyAddressAlign = x.Field <string>(14), ReportNameLeft = x.Field <int>(15), ReportNameHeight = x.Field <int>(16), ReportNameTop = x.Field <int>(17), ReportNameWidth = x.Field <int>(18), ReportNameFontSize = x.Field <int>(19), ReportNameBold = x.Field <bool>(20), ReportNameAlign = x.Field <string>(21), CompanyLogoLeft = x.Field <int>(22), CompanyLogoHeight = x.Field <int>(23), CompanyLogoTop = x.Field <int>(24), CompanyLogoWidth = x.Field <int>(25), FirstLineLeft = x.Field <int>(26), FirstLineTop = x.Field <int>(27), SecondLineLeft = x.Field <int>(28), SecondLineTop = x.Field <int>(29), FirstLineSuppress = x.Field <bool>(30), SecondLineSuppress = x.Field <bool>(31), ReportType = x.Field <string>(32), FirstLineWidth = x.Field <int>(33), SecondLineWidth = x.Field <int>(34), PaperType = x.Field <string>(35) }).ToList(); SessionHelper.ReportHeader = header; }
public void GetBankWiseAllBranch(int reportNo, string exportType) { var data = sPService.GetDataWithoutParameter( "RPT_GetBankWiseAllBranch").Tables[0]; var reportParam = new Dictionary <string, object> { { "param_orgName", "Ucas" } }; ReportHelper.ShowReport(data, exportType, "rpt_Bank_BranchList.rpt", "rpt_BrokerInfo", reportParam); }
public ActionResult ReportAccess() { var users = spService.GetDataWithoutParameter("USP_GET_ALL_USER").Tables[0].AsEnumerable() .Select(x => new AspNetUser() { UserId = x.Field <int>(0), UserName = x.Field <string>(1) }) .ToList(); var reportsModule = spService.GetDataWithoutParameter("USP_GET_ALL_Report_Module").Tables[0].AsEnumerable() .Select(x => new AspNetSecurityModule() { AspNetSecurityModuleId = x.Field <int>(0), LinkText = x.Field <string>(1) }) .ToList(); ViewBag.Users = users; ViewBag.ReportModules = reportsModule; ViewBag.Reports = reportInformationService.GetAll().ToList(); ViewBag.Projects = securityService.GetAllProject(SessionHelper.LoggedIn_RoleId, "0"); return(View()); }