private void ShowPayeeInformation(PdfPTable table, int contractNumber, int cropYear, bool splitRetain, bool splitChemical)
{
const string METHOD_NAME = "rptContractPayeeSummary.ShowPayeeInformation";
try {
Paragraph p = new Paragraph("", _normalFont);
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
using (SqlDataReader dr = WSCPayment.RptContractPayeeSummary2(conn, contractNumber, cropYear)) {
while (dr.Read())
{
if (dr.GetInt16(dr.GetOrdinal("PayeeNumber")) == 1)
{
Phrase phrase = new Phrase("1st Payee: ", _labelFont);
p.Add(phrase);
phrase = new Phrase(dr.GetString(dr.GetOrdinal("PayeeName")) + "\n", _normalFont);
p.Add(phrase);
phrase = new Phrase(dr.GetFloat(dr.GetOrdinal("SplitPercent")).ToString("##.0000") + "%" + "\n", _normalFont);
p.Add(phrase);
phrase = new Phrase("Mailed To: ", _labelFont);
p.Add(phrase);
phrase = new Phrase(dr.GetString(dr.GetOrdinal("AddressNumber")) + " " + dr.GetString(dr.GetOrdinal("BusinessName")), _normalFont);
p.Add(phrase);
phrase = new Phrase(" Split Retains: ", _labelFont);
p.Add(phrase);
phrase = new Phrase((splitRetain ? "Y" : "N"), _normalFont);
p.Add(phrase);
phrase = new Phrase(" Split Chemicals: ", _labelFont);
p.Add(phrase);
phrase = new Phrase((splitChemical ? "Y" : "N") + "\n", _normalFont);
p.Add(phrase);
}
else
{
Phrase phrase = new Phrase("2nd Payee: ", _labelFont);
p.Add(phrase);
phrase = new Phrase(dr.GetString(dr.GetOrdinal("PayeeName")) + "\n", _normalFont);
p.Add(phrase);
phrase = new Phrase(dr.GetFloat(dr.GetOrdinal("SplitPercent")).ToString("##.0000") + "%" + "\n", _normalFont);
p.Add(phrase);
phrase = new Phrase("Mailed To: ", _labelFont);
p.Add(phrase);
phrase = new Phrase(dr.GetString(dr.GetOrdinal("AddressNumber")) + " " + dr.GetString(dr.GetOrdinal("BusinessName")) + "\n", _normalFont);
p.Add(phrase);
}
}
PdfReports.AddText2Table(table, p, _primaryTableLayout.Length);
}
}
}
catch (Exception ex) {
WSCIEMP.Common.CException wscex = new WSCIEMP.Common.CException(METHOD_NAME, ex);
throw (wscex);
}
}
