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());
}