protected void Load_Report()
{
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
guard_employment_record_report report = new guard_employment_record_report();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
//set report connection details
//ConnectionInfo myconnectioninfo = new ConnectionInfo();
//myconnectioninfo.ServerName = "Thadeous";
//myconnectioninfo.DatabaseName = "guard_profiles_db";
//myconnectioninfo.UserID = "sg_admin";
//myconnectioninfo.Password = "******";
//SET_CONNECTION_INFO(myconnectioninfo);
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
//report.SetDataSource(sg_Reports.RETURN_OFFICER_DETAILS("", SystemConst.guard_number));
report.SetParameterValue("QueryName", "SELECT_GUARD_EMPLOYMENT_RECORD_REPORT");
report.SetParameterValue("guard_number", SystemConst.guard_number);
employment_report_reportviewer.ParameterFieldInfo = paramFields;
this.employment_report_reportviewer.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
private void frm_active_guards_report_Load(object sender, EventArgs e)
{
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
cr_active_guards_by_station report = new cr_active_guards_by_station();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(sg_Reports.SELECT_ACTIVE_GUARDS_BY_STATION("", SystemConst._branch));
report.SetParameterValue("QueryName", "SELECT_ACTIVE_GUARDS_BY_STATION");
report.SetParameterValue("branch", SystemConst._branch);
report.SetParameterValue("update_month", SystemConst._Report_update_month);
cr_active_guards.ParameterFieldInfo = paramFields;
this.cr_active_guards.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
private void frm_archieved_guard_list_report_Load(object sender, EventArgs e)
{
string _guard_status = SystemConst._guard_status;
if (_guard_status != String.Empty)
{
try {
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
cr_archived_guard_lists report = new cr_archived_guard_lists();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Archieve_Lists.SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS("SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS", _guard_status));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS");
report.SetParameterValue("guard_status", SystemConst._guard_status);
cr_viewer_archieved_guards_report.ParameterFieldInfo = paramFields;
this.cr_viewer_archieved_guards_report.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
catch (Exception ex) {
throw ex;
}
}
else
{
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
cr_archived_guard_lists report = new cr_archived_guard_lists();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
report.SetDatabaseLogon("sg_admin", "sg_admin123"); //hide the password from the code..get it from configuration file...
report.SetDataSource(Archieve_Lists.SELECT_ARCHIEVED_GUARD_LIST_ALL("SELECT_ARCHIEVED_GUARD_LIST_ALL"));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_LIST_ALL");
// report.SetParameterValue("guard_status", SystemConst._guard_status);
cr_viewer_archieved_guards_report.ParameterFieldInfo = paramFields;
this.cr_viewer_archieved_guards_report.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
}
private void frmcrystal_report_single_Load(object sender, EventArgs e)
{
if (SystemConst._Single_report_type == "Active")
{
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
guard_single_report report = new guard_single_report();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(sg_Reports.RETURN_OFFICER_DETAILS("", SystemConst.guard_number));
report.SetParameterValue("QueryName", "SELECT_GUARD_REPORT_SINGLE");
report.SetParameterValue("guard_number", SystemConst.guard_number);
report.SetParameterValue("guard_status", String.Empty);
report.SetParameterValue("client_name", SystemConst.ClientName);
crystalReportViewer1.ParameterFieldInfo = paramFields;
this.crystalReportViewer1.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
else if (SystemConst._Single_report_type == "Archieve")
{
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
guard_single_report report = new guard_single_report();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(sg_Reports.RETURN_OFFICER_DETAILS("", SystemConst.guard_number));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_REPORT_SINGLE");
report.SetParameterValue("guard_number", SystemConst.guard_number);
report.SetParameterValue("guard_status", String.Empty);
report.SetParameterValue("client_name", SystemConst.ClientName);
crystalReportViewer1.ParameterFieldInfo = paramFields;
this.crystalReportViewer1.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
}
private void frm_archieved_guard_list_report_Load(object sender, EventArgs e)
{
string _guard_status = SystemConst._guard_status;
if (_guard_status == string.Empty)
{
base.WindowState = FormWindowState.Maximized;
cr_archived_guard_lists report = new cr_archived_guard_lists();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField1 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Archieve_Lists.SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS("SELECT_ARCHIEVED_GUARD_LIST_ALL", _guard_status));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_LIST_ALL");
report.SetParameterValue("guard_status", SystemConst._guard_status);
report.SetParameterValue("client_name", SystemConst.ClientName);
this.cr_viewer_archieved_guards_report.ParameterFieldInfo = paramFields;
this.cr_viewer_archieved_guards_report.ReportSource = report;
}
else
{
try
{
base.WindowState = FormWindowState.Maximized;
cr_archived_guard_lists report = new cr_archived_guard_lists();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField1 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Archieve_Lists.SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS("SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS", _guard_status));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS");
report.SetParameterValue("guard_status", SystemConst._guard_status);
this.cr_viewer_archieved_guards_report.ParameterFieldInfo = paramFields;
this.cr_viewer_archieved_guards_report.ReportSource = report;
}
catch (Exception exception)
{
throw exception;
}
}
}
protected void Load_Report()
{
base.WindowState = FormWindowState.Maximized;
guard_employment_record_report report = new guard_employment_record_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.SetParameterValue("QueryName", "SELECT_GUARD_EMPLOYMENT_RECORD_REPORT");
report.SetParameterValue("guard_number", SystemConst.guard_number);
this.employment_report_reportviewer.ParameterFieldInfo = paramFields;
this.employment_report_reportviewer.ReportSource = report;
}
protected void LoadReport(string tracker_id)
{
ReportDocument crystalReport = new ReportDocument();
crystalReport.Load(Server.MapPath("~/cr_DataEntryTracker.rpt"));
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in crystalReport.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
DataSet ds = DataEntryTracker._ReturnDataEntryReport("weekly_tracker_report", tracker_id);
crystalReport.SetDataSource(ds);
crystalReport.SetParameterValue("@QueryType", "weekly_tracker_report");
CrystalReportViewer1.ToolPanelView = ToolPanelViewType.None;
CrystalReportViewer1.ReportSource = crystalReport;
}
private void frm_sg_list_report_Load(object sender, EventArgs e)
{
base.WindowState = FormWindowState.Maximized;
cr_all_guards_list report = new cr_all_guards_list();
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(sg_Reports.SELECT_GUARD_LIST("SELECT_GUARD_LIST"));
report.SetParameterValue("QueryName", "SELECT_GUARD_LIST");
report.SetParameterValue("client_name", SystemConst.ClientName);
this.report_sg_lists.ParameterFieldInfo = paramFields;
this.report_sg_lists.ReportSource = report;
}
private void frm_officer_large_img_report_Load(object sender, EventArgs e)
{
base.WindowState = FormWindowState.Maximized;
cr_guard_large_img report = new cr_guard_large_img();
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(sg_Reports.SELECT_GUARD_LARGE_IMAGE_RPT("", SystemConst.guard_number));
report.SetParameterValue("QueryName", "SELECT_GUARD_LARGE_IMAGE_RPT");
report.SetParameterValue("guard_number", SystemConst.guard_number);
this.cr_large_image_report.ParameterFieldInfo = paramFields;
this.cr_large_image_report.ReportSource = report;
}
private void frm_kampala_active_guards_report_Load(object sender, EventArgs e)
{
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
cr_kampala_report report = new cr_kampala_report();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(sg_Reports.SELECT_ACTIVE_GUARDS_KAMPALA("", SystemConst._branch));
//check if user selected kampala
if (SystemConst._branch == "KAMPALA")
{
report.SetParameterValue("QueryName", "SELECT_ACTIVE_GUARDS_KAMPALA_COMBINED");
report.SetParameterValue("branch", SystemConst._branch);
report.SetParameterValue("update_month", SystemConst._Report_update_month);
report.SetParameterValue("client_name", SystemConst.ClientName);
cr_active_kampala_guards_report.ParameterFieldInfo = paramFields;
this.cr_active_kampala_guards_report.ReportSource = report;
}
else
{
report.SetParameterValue("QueryName", "SELECT_ACTIVE_GUARDS_KAMPALA");
report.SetParameterValue("branch", SystemConst._branch);
report.SetParameterValue("update_month", SystemConst._Report_update_month);
report.SetParameterValue("client_name", SystemConst.ClientName);
cr_active_kampala_guards_report.ParameterFieldInfo = paramFields;
this.cr_active_kampala_guards_report.ReportSource = report;
}
}
protected void LoadBushenyiTrackerReport(string tracker_id)
{
cr_DataEntryTracker objRptMain = new cr_DataEntryTracker();
ReportDocument objSubRpt = new ReportDocument();
objSubRpt.Load(Server.MapPath("~/Bushenyi_sub_report.rpt"));
//foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in objSubRpt.Database.Tables)
//{
// Set_Report_logons.SetTableLogin(tbCurrent);
//}
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in objRptMain.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
foreach (ReportDocument subreport in objRptMain.Subreports)
{
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in subreport.Database.Tables)
{
Set_Report_logons.SetTableLogin(CrTable);
}
}
DataSet ds = DataEntryTracker._ReturnDataEntryReport("Data_entry_weekly_tracker_report", tracker_id);
objSubRpt = objRptMain.OpenSubreport("Bushenyi_sub_report.rpt");
objSubRpt.SetDataSource(ds);
//objRptMain.SetParameterValue("@QueryType", "weekly_tracker_report");
objRptMain.SetParameterValue("@QueryType", "Data_entry_weekly_tracker_report", objRptMain.Subreports[0].Name.ToString());
objRptMain.SetParameterValue("@Tracker_id", tracker_id, objRptMain.Subreports[0].Name.ToString());
CrystalReportViewer1.ToolPanelView = ToolPanelViewType.None;
objRptMain.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "Tracker");
CrystalReportViewer1.ReportSource = objRptMain;
}
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
}
}
private void frm_finance_detailed_guard_pay_roll_report_Load(object sender, EventArgs e)
{
if (SystemConst._finance_crystal_report_type == "DEPLOY" || SystemConst._finance_crystal_report_type == "CLIENT" || SystemConst._finance_crystal_report_type == "GUARD")
{
this.Text = SystemConst.ClientName + "-Deployment Reporting";
}
else
{
this.Text = SystemConst.ClientName + "-Finance Reporting";
}
if (SystemConst._finance_crystal_report_type == "Detailed")
{
try
{
base.WindowState = FormWindowState.Maximized;
finance_detailed_guard_pay_roll_report report = new finance_detailed_guard_pay_roll_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(Finance_Reports.select_guard_payroll_summary_details_by_station("select_guard_payroll_summary_details_by_station", Convert.ToInt32(SystemConst._active_deployment_id), SystemConst._station_code, SystemConst._station_name, SystemConst._guard_rank));
report.SetParameterValue("QueryName", "select_guard_payroll_summary_details_by_station");
report.SetParameterValue("guard_number", string.Empty);
report.SetParameterValue("station_code", SystemConst._station_code);
report.SetParameterValue("station_name", SystemConst._station_name);
report.SetParameterValue("guard_rank", SystemConst._guard_rank);
report.SetParameterValue("rank_name", SystemConst._rank_name);
report.SetParameterValue("deploy_period_id", Convert.ToInt32(SystemConst._active_deployment_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;
Set_current_deployment_periods();
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "bank_payment")
{
try
{
base.WindowState = FormWindowState.Maximized;
finance_bank_salary_payment_report report = new finance_bank_salary_payment_report();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField1 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Finance_Reports.select_bank_payment_report("select_bank_payment_report", SystemConst._station_name, Convert.ToInt32(SystemConst._payment_deployment_id)));
report.SetParameterValue("QueryName", "select_bank_payment_report");
report.SetParameterValue("station_name", SystemConst._station_name);
report.SetParameterValue("deploy_period_id", Convert.ToInt32(SystemConst._payment_deployment_id));
report.SetParameterValue("bank_branch", "STANBIC BANK-" + SystemConst._bank_branch);
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;
Set_current_deployment_periods();
}
catch (Exception exception1)
{
MessageBox.Show(exception1.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "Payroll_Archive")
{
try
{
base.WindowState = FormWindowState.Maximized;
finance_detailed_guard_pay_roll_report_archive report = new finance_detailed_guard_pay_roll_report_archive();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField1 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Nss_archive.select_payroll_report());
report.SetParameterValue("QueryName", "select_payroll_report");
report.SetParameterValue("branch_name", Nss_archive.Rbranch_name);
report.SetParameterValue("payment_year", Nss_archive.Rpayment_year);
report.SetParameterValue("payment_month", Nss_archive.Rpayment_month);
this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields;
this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report;
//Set_current_deployment_periods();
}
catch (Exception exception1)
{
MessageBox.Show(exception1.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "NSSF_Archive")
{
try
{
base.WindowState = FormWindowState.Maximized;
finance_employee_nssf_report_archive report = new finance_employee_nssf_report_archive();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField1 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Nss_archive.select_nssf_report());
report.SetParameterValue("QueryName", "select_nssf_report");
report.SetParameterValue("branch_name", Nss_archive.Rbranch_name);
report.SetParameterValue("payment_year", Nss_archive.Rpayment_year);
report.SetParameterValue("payment_month", Nss_archive.Rpayment_month);
this.cr_finance_detailed_guard_pay_roll_report.ParameterFieldInfo = paramFields;
this.cr_finance_detailed_guard_pay_roll_report.ReportSource = report;
//Set_current_deployment_periods();
}
catch (Exception exception1)
{
MessageBox.Show(exception1.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "LST")
{
try
{
base.WindowState = FormWindowState.Maximized;
finance_local_service_tax_report report = new finance_local_service_tax_report();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField2 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue2 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Finance_Reports.select_local_service_tax_nssf_andpaye_report("select_local_service_tax_report", SystemConst._station_name, SystemConst._station_code, Convert.ToInt32(SystemConst._active_deployment_id)));
report.SetParameterValue("QueryName", "select_local_service_tax_report");
report.SetParameterValue("station_name", SystemConst._station_name);
report.SetParameterValue("deploy_period_id", Convert.ToInt32(SystemConst._active_deployment_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;
Set_current_deployment_periods();
}
catch (Exception exception2)
{
MessageBox.Show(exception2.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "NSSF")
{
try
{
base.WindowState = FormWindowState.Maximized;
finance_employee_nssf_report report = new finance_employee_nssf_report();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField3 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue3 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Finance_Reports.select_local_service_tax_nssf_andpaye_report("select_nssf_report", SystemConst._station_name, SystemConst._station_code, Convert.ToInt32(SystemConst._active_deployment_id)));
report.SetParameterValue("QueryName", "select_nssf_report");
report.SetParameterValue("station_name", SystemConst._station_name);
report.SetParameterValue("branch_name", SystemConst._station_name);
report.SetParameterValue("deploy_period_id", Convert.ToInt32(SystemConst._active_deployment_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;
Set_current_deployment_periods();
}
catch (Exception exception3)
{
MessageBox.Show(exception3.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "PAYE")
{
try
{
base.WindowState = FormWindowState.Maximized;
finance_employee_paye_report report = new finance_employee_paye_report();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField4 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue4 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Finance_Reports.select_local_service_tax_nssf_andpaye_report("select_paye_tax_report", SystemConst._station_name, SystemConst._station_code, Convert.ToInt32(SystemConst._active_deployment_id)));
report.SetParameterValue("QueryName", "select_paye_tax_report");
report.SetParameterValue("station_name", SystemConst._station_name);
report.SetParameterValue("deploy_period_id", Convert.ToInt32(SystemConst._active_deployment_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;
Set_current_deployment_periods();
}
catch (Exception exception4)
{
MessageBox.Show(exception4.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "DEPLOY")
{
try
{
base.WindowState = FormWindowState.Maximized;
cr_deployment_summary_report report = new cr_deployment_summary_report();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField5 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue5 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Finance_Reports.select_local_service_tax_nssf_andpaye_report("select_deployment_summary_report", SystemConst._station_name, SystemConst._station_code, Convert.ToInt32(SystemConst._active_deployment_id)));
report.SetParameterValue("QueryName", "select_paye_tax_report");
report.SetParameterValue("station_name", SystemConst._station_name);
report.SetParameterValue("deploy_period_id", Convert.ToInt32(SystemConst._active_deployment_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;
Set_current_deployment_periods();
}
catch (Exception exception5)
{
MessageBox.Show(exception5.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "CLIENT")
{
try
{
base.WindowState = FormWindowState.Maximized;
cr_deployment_client_guard_mapping_report report = new cr_deployment_client_guard_mapping_report();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField6 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue6 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Finance_Reports.select_client_guard_mapping_report("select_client_guard_mapping_report", SystemConst._client_code, SystemConst._deployment_start_date, SystemConst._deployment_end_date));
report.SetParameterValue("QueryName", "select_client_guard_mapping_report");
report.SetParameterValue("client_code", SystemConst._client_code);
report.SetParameterValue("deploy_date_from", SystemConst._deployment_start_date);
report.SetParameterValue("deploy_date_to", SystemConst._deployment_end_date);
report.SetParameterValue("date_from", SystemConst._deployment_start_date);
report.SetParameterValue("date_to", SystemConst._deployment_end_date);
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;
Set_current_deployment_periods();
}
catch (Exception exception6)
{
MessageBox.Show(exception6.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "GUARD")
{
try
{
base.WindowState = FormWindowState.Maximized;
cr_deployment_guard_client_mapping_report report = new cr_deployment_guard_client_mapping_report();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField7 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue7 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Finance_Reports.select_guard_client_mapping_report("select_guard_client_mapping_report", SystemConst.guard_number, SystemConst._deployment_start_date, SystemConst._deployment_end_date));
report.SetParameterValue("QueryName", "select_guard_client_mapping_report");
report.SetParameterValue("guard_number", SystemConst.guard_number);
report.SetParameterValue("deploy_date_from", SystemConst._deployment_start_date);
report.SetParameterValue("deploy_date_to", SystemConst._deployment_end_date);
report.SetParameterValue("date_from", SystemConst._deployment_start_date);
report.SetParameterValue("date_to", SystemConst._deployment_end_date);
report.SetParameterValue("client_name", SystemConst.ClientName);
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;
Set_current_deployment_periods();
}
catch (Exception exception7)
{
MessageBox.Show(exception7.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "DEPLOYMENT_SCHEDULE")
{
try
{
base.WindowState = FormWindowState.Maximized;
cr_guard_deployment_schedule_report report = new cr_guard_deployment_schedule_report();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField7 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue7 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Finance_Reports.select_guard_deployment_schedule_report("select_deployment_schedule_report_by_branch", SystemConst._station_name, Convert.ToInt32(SystemConst._active_deployment_id)));
report.SetParameterValue("QueryName", "select_deployment_schedule_report_by_branch");
report.SetParameterValue("branch_name", SystemConst._station_name);
report.SetParameterValue("deploy_id", Convert.ToInt32(SystemConst._active_deployment_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;
Set_current_deployment_periods();
}
catch (Exception exception7)
{
MessageBox.Show(exception7.ToString());
}
}
else if (SystemConst._finance_crystal_report_type == "customer_bill")
{
try
{
base.WindowState = FormWindowState.Maximized;
cr_client_billing report = new cr_client_billing();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField7 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue7 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Finance_Reports.select_client_billing_report("select_client_billing_report", SystemConst._station_name, Convert.ToInt32(SystemConst._active_deployment_id)));
report.SetParameterValue("QueryName", "select_client_billing_report");
report.SetParameterValue("station_name", SystemConst._station_name);
report.SetParameterValue("deploy_period_id", Convert.ToInt32(SystemConst._active_deployment_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;
Set_current_deployment_periods();
}
catch (Exception exception7)
{
MessageBox.Show(exception7.ToString());
}
}
}
