private void UpdateBillsBtn_Click(object sender, EventArgs e)
{
try
{
PrintingSettings aPrintingSettings = new PrintingSettings();
aPrintingSettings.BillOrReport = 0;
int aCnt = 0;
//Headers
aPrintingSettings.HeaderOrFooter = 0;
//
aPrintingSettings.Data = bh1TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
aPrintingSettings.Data = bh2TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
aPrintingSettings.Data = bh3TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
aPrintingSettings.Data = bh4TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
aPrintingSettings.Data = bh5TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
aCnt = 0;
//Footers
aPrintingSettings.HeaderOrFooter = 1;
//
aPrintingSettings.Data = bf1TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
aPrintingSettings.Data = bf2TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
aPrintingSettings.Data = bf3TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
aPrintingSettings.Data = bf4TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
aPrintingSettings.Data = bf5TxtBox.Text;
aPrintingSettings.Number = ++aCnt;
PrintingSettingsMgmt.InsertLine(aPrintingSettings);
MessageBox.Show(MsgTxt.UpdateSuccessfully, MsgTxt.InformationCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [PritingSettingFrm: UpdateBillsBtn_Click] \n Exception: \n" + ex.ToString(), MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
UpdateForm();
}
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; }
}
