public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { cr_staff_bank_schedule rpt = new cr_staff_bank_schedule(); rpt.Site = this.Site; return(rpt); }
protected void LoadReports(string ReportType) { switch (ReportType) { case "Payroll Report": try { base.WindowState = FormWindowState.Maximized; cr_staff_payroll report = new cr_staff_payroll(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetDataSource(StaffPayrollReports.select_staff_payroll("select_staff_payroll", StaffPayrollReports._payment_period_id, StaffPayrollReports._branch_id, StaffPayrollReports._payment_month)); report.SetParameterValue("QueryName", "select_staff_payroll"); report.SetParameterValue("branch_id", StaffPayrollReports._branch_id); report.SetParameterValue("branch_name", StaffPayrollReports._branch_id); report.SetParameterValue("payment_month", StaffPayrollReports._payment_month); report.SetParameterValue("payment_period_id", StaffPayrollReports._payment_period_id); report.SetParameterValue("client_name", SystemConst.ClientName); this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields; this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } break; case "Bank Payment Schedule": try { base.WindowState = FormWindowState.Maximized; cr_staff_bank_schedule report = new cr_staff_bank_schedule(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetDataSource(StaffPayrollReports.select_staff_payroll("select_staff_bank_schedule", StaffPayrollReports._payment_period_id, StaffPayrollReports._branch_id, StaffPayrollReports._payment_month)); report.SetParameterValue("QueryName", "select_staff_bank_schedule"); report.SetParameterValue("branch_id", StaffPayrollReports._branch_id); report.SetParameterValue("payment_month", StaffPayrollReports._payment_month); report.SetParameterValue("payment_period_id", StaffPayrollReports._payment_period_id); report.SetParameterValue("bank_name", StaffPayrollReports.bank_name); report.SetParameterValue("client_name", SystemConst.ClientName); this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields; this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } break; case "NSSF": try { base.WindowState = FormWindowState.Maximized; cr_staff_nssf_report report = new cr_staff_nssf_report(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetDataSource(StaffPayrollReports.select_staff_payroll("select_staff_nssf_report", StaffPayrollReports._payment_period_id, StaffPayrollReports._branch_id, StaffPayrollReports._payment_month)); report.SetParameterValue("QueryName", "select_staff_nssf_report"); report.SetParameterValue("branch_id", StaffPayrollReports._branch_id); report.SetParameterValue("branch_name", StaffPayrollReports._branch_id); report.SetParameterValue("payment_month", StaffPayrollReports._payment_month); report.SetParameterValue("payment_period_id", StaffPayrollReports._payment_period_id); report.SetParameterValue("client_name", SystemConst.ClientName); this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields; this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } break; case "PAYE": try { base.WindowState = FormWindowState.Maximized; cr_staff_paye_report report = new cr_staff_paye_report(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetDataSource(StaffPayrollReports.select_staff_payroll("select_staff_paye_report", StaffPayrollReports._payment_period_id, StaffPayrollReports._branch_id, StaffPayrollReports._payment_month)); report.SetParameterValue("QueryName", "select_staff_paye_report"); report.SetParameterValue("branch_id", StaffPayrollReports._branch_id); report.SetParameterValue("payment_month", StaffPayrollReports._payment_month); report.SetParameterValue("payment_period_id", StaffPayrollReports._payment_period_id); report.SetParameterValue("client_name", SystemConst.ClientName); this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields; this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } break; case "LST": try { base.WindowState = FormWindowState.Maximized; cr_staff_local_service_tax_report report = new cr_staff_local_service_tax_report(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetDataSource(StaffPayrollReports.select_staff_payroll("select_staff_local_service_tax_report", StaffPayrollReports._payment_period_id, StaffPayrollReports._branch_id, StaffPayrollReports._payment_month)); report.SetParameterValue("QueryName", "select_staff_local_service_tax_report"); report.SetParameterValue("branch_id", StaffPayrollReports._branch_id); report.SetParameterValue("payment_month", StaffPayrollReports._payment_month); report.SetParameterValue("payment_period_id", StaffPayrollReports._payment_period_id); report.SetParameterValue("client_name", SystemConst.ClientName); this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields; this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } break; #region LegacyReports case "Legacy_DebtorsList": try { base.WindowState = FormWindowState.Maximized; crDebtorsReport report = new crDebtorsReport(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetDataSource(AccountsBackEnd.LegacyReports.LoadDebtorsListing("select_debtors_list", LegacyReports.station_code, LegacyReports.begin_date, LegacyReports.end_date)); report.SetParameterValue("queryname", "select_debtors_list"); report.SetParameterValue("station_code", LegacyReports.station_code); report.SetParameterValue("begin_date", LegacyReports.begin_date); report.SetParameterValue("end_date", LegacyReports.end_date); this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields; this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } break; case "Legacy_Client_statement": try { base.WindowState = FormWindowState.Maximized; crClientstatementReport report = new crClientstatementReport(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetDataSource(AccountsBackEnd.LegacyReports.LoadClientStatement("select_client_account_statement", LegacyReports.client_code, LegacyReports.begin_date, LegacyReports.end_date)); report.SetParameterValue("queryname", "select_client_account_statement"); report.SetParameterValue("client_code", LegacyReports.client_code); report.SetParameterValue("begin_date", LegacyReports.begin_date); report.SetParameterValue("end_date", LegacyReports.end_date); this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields; this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } break; case "Legacy_income_and_expenditure_statement": try { base.WindowState = FormWindowState.Maximized; crIncomeExpenditureReport report = new crIncomeExpenditureReport(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetDataSource(AccountsBackEnd.LegacyReports.LoadIncomeandExpenditureReport("income_and_expenditure", LegacyReports.station_code, LegacyReports.begin_date, LegacyReports.end_date)); report.SetParameterValue("queryname", "income_and_expenditure"); report.SetParameterValue("subpcode", LegacyReports.station_code); report.SetParameterValue("begin_date", LegacyReports.begin_date); report.SetParameterValue("end_date", LegacyReports.end_date); this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields; this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } break; case "Legacy_trial_balance": try { base.WindowState = FormWindowState.Maximized; crTrialbalance report = new crTrialbalance(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetDataSource(AccountsBackEnd.LegacyReports.LoadIncomeandExpenditureReport("trial_balance", LegacyReports.station_code, LegacyReports.begin_date, LegacyReports.end_date)); report.SetParameterValue("queryname", "trial_balance"); report.SetParameterValue("subpcode", LegacyReports.station_code); report.SetParameterValue("begin_date", LegacyReports.begin_date); report.SetParameterValue("end_date", LegacyReports.end_date); this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields; this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } break; #endregion } }