private void CreateAgWFP3PaymentBMPFundingOverviewGrid(int i) { StringBuilder sb = new StringBuilder(); try { using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var x = wDataContext.form_wfp3_payment_get_funding_PK(i); if (x.Count() > 0) { sb.Append("<div class='taC NestedDivReadOnly'>"); sb.Append("<div class='fsS B'>Funding History</div>"); sb.Append("<center><table cellpadding='5' rules='cols'>"); sb.Append("<tr valign='top'>"); sb.Append("<td class='B U'>Date</td>"); sb.Append("<td class='B U'>BMP</td>"); sb.Append("<td class='B U'>Funding Source</td>"); sb.Append("<td class='B U'>Funding Agency</td>"); sb.Append("<td class='B U'>Version</td>"); sb.Append("<td class='B U taR'>Amount</td>"); sb.Append("</tr>"); foreach (var y in x) { sb.Append("<tr valign='top'>"); sb.Append("<td class='taL'>" + WACGlobal_Methods.Format_Global_Date(y.date) + "</td>"); sb.Append("<td class='taL'>" + y.CompositBmpNum + "</td>"); sb.Append("<td class='taL'>" + y.Funding_Source + "</td>"); sb.Append("<td class='taL'>" + y.Funding_Agency + "</td>"); sb.Append("<td class='taL'>" + y.Version + "</td>"); sb.Append("<td class='taR'>" + WACGlobal_Methods.Format_Global_Currency(y.funding) + "</td>"); sb.Append("</tr>"); } sb.Append("</table></center>"); sb.Append("</div>"); } else { sb.Append("<div class='NestedDivLevel00'>No Existing Funding History</div>"); } } } catch (Exception ex) { sb.Append("Error Creating Funding History Grid: " + ex.Message); } Literal litAg_WFP3_Payments_BMPs_Funding_Overview_Grid = pnlSubPanels.FindControl("litAg_WFP3_Payments_BMPs_Funding_Overview_Grid") as Literal; if (litAg_WFP3_Payments_BMPs_Funding_Overview_Grid != null) { litAg_WFP3_Payments_BMPs_Funding_Overview_Grid.Text = sb.ToString(); } }
private void Create_Agriculture_WFP3_PaymentBMP_PaymentStatus_Grid(int iPK_Form_WFP3) { StringBuilder sb = new StringBuilder(); try { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { var x = wac.vw_form_wfp3_paymentBMP_paymentStatus.Where(w => w.fk_form_wfp3 == iPK_Form_WFP3).Select(s => s); if (x.Count() > 0) { sb.Append("<div class='taC NestedDivReadOnly'>"); sb.Append("<div class='B fsS'>BMP Payments</div>"); sb.Append("<table cellpadding='5' rules='cols' align='center'>"); sb.Append("<tr valign='top'><td class='B U'>Payment Date</td><td class='B U'>BMP #</td><td class='B U'>Amount</td><td class='B U'>Amount, Other Agency</td><td class='B U'>Other Agency</td><td class='B U'>Payment Status</td></tr>"); foreach (var y in x) { sb.Append("<tr valign='top'>"); sb.Append("<td>" + WACGlobal_Methods.Format_Global_Date(y.date) + "</td>"); sb.Append("<td>" + y.CompositBmpNum + "</td>"); sb.Append("<td>" + WACGlobal_Methods.Format_Global_Currency(y.amt) + "</td>"); sb.Append("<td>" + WACGlobal_Methods.Format_Global_Currency(y.amt_agencyFunding) + "</td>"); sb.Append("<td>" + y.otherAgencyFunding + "</td>"); sb.Append("<td>" + y.status + "</td>"); sb.Append("</tr>"); } sb.Append("</table>"); sb.Append("</div>"); } else { sb.Append("<div class='NestedDivLevel00'>No Existing BMP Payments</div>"); } } } catch (Exception ex) { sb.Append("Error Creating BMP Payments Grid: " + ex.Message); } Literal litAg_WFP3_Payments_BMPs_Payments_Overview_Grid = pnlSubPanels.FindControl("litAg_WFP3_Payments_BMPs_Payments_Overview_Grid") as Literal; if (litAg_WFP3_Payments_BMPs_Payments_Overview_Grid != null) { litAg_WFP3_Payments_BMPs_Payments_Overview_Grid.Text = sb.ToString(); } }