private static void ReportBuilder(int paymentCropYear, string filePath)
{
const string METHOD_NAME = "ReportBuilder";
const string QUOTE = "\"";
try {
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
List <List1099ExportItem> stateList = WSCPayment.GetBeet1099Export(paymentCropYear);
using (StreamWriter sw = new StreamWriter(filePath, false)) {
foreach (List1099ExportItem state in stateList)
{
//SHID, TaxID, Business Name, Address 1, Address 2, City, State, Zip, Dollars
sw.Write(QUOTE + state.SHID + QUOTE + ",");
sw.Write(QUOTE + state.TaxID + QUOTE + ",");
sw.Write(QUOTE + state.BusName + QUOTE + ",");
sw.Write(QUOTE + state.Address1 + QUOTE + ",");
sw.Write(QUOTE + state.Address2 + QUOTE + ",");
sw.Write(QUOTE + state.TaxCity + QUOTE + ",");
sw.Write(QUOTE + state.TaxState + QUOTE + ",");
sw.Write(QUOTE + state.TaxZip + QUOTE + ",");
sw.Write(QUOTE + state.TaxDollars + QUOTE + Environment.NewLine);
}
sw.Close();
}
}
}
catch (Exception ex) {
WSCIEMP.Common.CException wscex = new WSCIEMP.Common.CException(MOD_NAME + METHOD_NAME, ex);
throw (wscex);
}
}
