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; } }
public static void SetConnectionString() { __ConnectionString = ConfigurationHelper.GetConnString(); }