public static List <string> ImportReportHeader(int HeaderOrFooter, int BillOrReport) { List <string> aHeaderList = new List <string>(); List <string> aFooterList = new List <string>(); if (BillOrReport == 0) { if (HeaderOrFooter == 0) { DataTable aBillHeader = PrintingSettingsMgmt.SelectBillsHeaders(0, 0); if (aBillHeader != null) { foreach (DataRow aRow in aBillHeader.Rows) { if (aRow["Data"].ToString().Trim() != "") { aHeaderList.Add(aRow["Data"].ToString()); } } return(aHeaderList); } } else if (HeaderOrFooter == 1) { DataTable aBillFooter = PrintingSettingsMgmt.SelectBillsHeaders(1, 0); if (aBillFooter != null) { foreach (DataRow aRow in aBillFooter.Rows) { if (aRow["Data"].ToString().Trim() != "") { aFooterList.Add(aRow["Data"].ToString()); } } return(aFooterList); } } } else if (BillOrReport == 1) { if (HeaderOrFooter == 0) { DataTable aReportHeader = PrintingSettingsMgmt.SelectBillsHeaders(0, 1); if (aReportHeader != null) { foreach (DataRow aRow in aReportHeader.Rows) { if (aRow["Data"].ToString().Trim() != "") { aHeaderList.Add(aRow["Data"].ToString()); } } return(aHeaderList); } } else if (HeaderOrFooter == 1) { DataTable aReportFooter = PrintingSettingsMgmt.SelectBillsHeaders(1, 1); if (aReportFooter != null) { foreach (DataRow aRow in aReportFooter.Rows) { if (aRow["Data"].ToString().Trim() != "") { aFooterList.Add(aRow["Data"].ToString()); } } return(aFooterList); } } } return(null); }
private void UpdateForm() { try { IsLoading = true; DataTable aBillHeader = PrintingSettingsMgmt.SelectBillsHeaders(0, 0); DataTable aBillFooter = PrintingSettingsMgmt.SelectBillsHeaders(1, 0); DataTable aReportHeader = PrintingSettingsMgmt.SelectBillsHeaders(0, 1); DataTable aReportFooter = PrintingSettingsMgmt.SelectBillsHeaders(1, 1); if (aBillHeader != null) { foreach (DataRow aRow in aBillHeader.Rows) { if (aRow["Number"].ToString() == "1") { bh1TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "2") { bh2TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "3") { bh3TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "4") { bh4TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "5") { bh5TxtBox.Text = aRow["Data"].ToString(); } } } if (aBillFooter != null) { foreach (DataRow aRow in aBillFooter.Rows) { if (aRow["Number"].ToString() == "1") { bf1TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "2") { bf2TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "3") { bf3TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "4") { bf4TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "5") { bf5TxtBox.Text = aRow["Data"].ToString(); } } } //-------------- Starting Report Data if (aReportHeader != null) { foreach (DataRow aRow in aReportHeader.Rows) { if (aRow["Number"].ToString() == "1") { rh1TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "2") { rh2TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "3") { rh3TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "4") { rh4TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "5") { rh5TxtBox.Text = aRow["Data"].ToString(); } } } if (aReportFooter != null) { foreach (DataRow aRow in aReportFooter.Rows) { if (aRow["Number"].ToString() == "1") { rf1TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "2") { rf2TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "3") { rf3TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "4") { rf4TxtBox.Text = aRow["Data"].ToString(); } else if (aRow["Number"].ToString() == "5") { rf5TxtBox.Text = aRow["Data"].ToString(); } } } //--------------------- PrintLogoChkBox.Checked = ConfigurationHelper.IsPrintLogoEnabled(); } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [PrintingSettingsForm] \n Exception: \n" + ex.ToString(), MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { IsLoading = false; } }