public static void ReportBuilder(SqlDataReader drHdr, int cropYear, int contractNumber, string deliveryDates, FileStream fs)
{
const string METHOD_NAME = "ReportBuilder";
Document document = null;
PdfWriter writer = null;
DailyGrowerTareDetailEvent pgEvent = null;
int resetFlag = 0;
string dates = null;
int contractID = 0;
string factoryNo = "";
string firstDeliveryDate = null;
string nextDeliveryDate = null;
string lastDeliveryDate = null;
string busName = "";
string address1 = "";
string address2 = "";
string CSZ = "";
string rptTitle = "Western Sugar Cooperative\nDaily Grower Tare Detail Report";
try {
if (drHdr.Read())
{
contractID = drHdr.GetInt32(drHdr.GetOrdinal("ContractID"));
factoryNo = drHdr.GetString(drHdr.GetOrdinal("Delivery_Factory_No"));
firstDeliveryDate = drHdr.GetString(drHdr.GetOrdinal("Delivery_Date"));
nextDeliveryDate = firstDeliveryDate;
}
else
{
// Warn that we have no data.
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("No records matched your report criteria.");
throw (warn);
}
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
// Header Address Info
if (contractID > 0)
{
using (SqlDataReader drAddr = WSCReportsExec.GrowerDetailReportAddr(conn, contractID)) {
if (drAddr.Read())
{
busName = drAddr.GetString(drAddr.GetOrdinal("Business_Name"));
address1 = drAddr.GetString(drAddr.GetOrdinal("Address_1"));
address2 = drAddr.GetString(drAddr.GetOrdinal("Address_2"));
CSZ = drAddr.GetString(drAddr.GetOrdinal("City")) + ", " +
drAddr.GetString(drAddr.GetOrdinal("State")) + " " +
drAddr.GetString(drAddr.GetOrdinal("Zip"));
}
}
}
// Sample / Tare information
// I use nextDeliveryDate as a trick to allow reading drHdr. Initially,
// nextDeliveryDate is loaded and we skip reading drHdr. Subsequently,
// the bottom of each iteration will null nextDeliveryDate and force reading drHdr.
int loadCount = 0;
while (nextDeliveryDate != null || drHdr.Read())
{
if (document == null)
{
// IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!!
// *** US LETTER: 612 X 792 ***
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin, PortraitPageSize.PgBottomMargin);
// we create a writer that listens to the document
// and directs a PDF-stream to a file
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.FillEvent(contractNumber, busName, factoryNo, address1, address2, CSZ, resetFlag, rptTitle);
writer.PageEvent = pgEvent;
// Open the document
document.Open();
}
// load the delivery date.
nextDeliveryDate = drHdr.GetString(drHdr.GetOrdinal("Delivery_Date"));
// Acquire the sample details for the first station on a given day
if (lastDeliveryDate != nextDeliveryDate)
{
AddSampleHdr(ref document, drHdr, cropYear, pgEvent);
lastDeliveryDate = nextDeliveryDate;
using (SqlDataReader drSamples = WSCReportsExec.GrowerDetailReportTares(conn, contractID, nextDeliveryDate)) {
AddSampleDetail(ref document, drSamples, pgEvent);
}
}
loadCount = 0;
// Display Truck information for each station
// on the first delivery day.
if (nextDeliveryDate == firstDeliveryDate)
{
// Get the truck data.
SqlParameter[] spParams = null;
using (SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn, contractID,
drHdr.GetInt32(drHdr.GetOrdinal("Delivery_Station_ID")),
firstDeliveryDate, ref spParams)) {
AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0)
{
AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"),
Convert.ToInt32(spParams[5].Value).ToString("#,##0"), pgEvent);
}
}
}
// clear date to force read in top of loop
nextDeliveryDate = null;
}
}
// ======================================================
// Close document
// ======================================================
if (document != null)
{
pgEvent.IsDocumentClosing = true;
document.Close();
document = null;
}
if (writer == null)
{
// Warn that we have no data.
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("No records matched your report criteria.");
throw (warn);
}
}
catch (Exception ex) {
string errMsg = "document is null: " + (document == null).ToString() + "; " +
"writer is null: " + (writer == null).ToString();
WSCIEMP.Common.CException wscex = new WSCIEMP.Common.CException(METHOD_NAME + errMsg, ex);
throw (wscex);
}
finally {
if (document != null)
{
pgEvent.IsDocumentClosing = true;
document.Close();
}
if (writer != null)
{
writer.Close();
}
}
}
public static void AddTruckTotals(ref Document document, string loadCount, string dirtWeight, string netWeight, DailyGrowerTareDetailEvent pgEvent)
{
const string METHOD_NAME = "AddTruckTotals";
try {
PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
// Let the PDF Page event handler take care of adding column labels on page breaks.
pgEvent.HeaderNameList = _truckDetailHdrNames;
pgEvent.HeaderTableLayout = _primaryTableLayout;
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Load Count:", _labelFont);
PdfReports.AddText2Table(table, loadCount, _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, dirtWeight, _normalFont, "right");
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, netWeight, _normalFont, "right");
PdfReports.AddText2Table(table, " ", _normalFont, _primaryTableLayout.Length);
PdfReports.AddTableNoSplit(document, pgEvent, table);
pgEvent.HeaderNameList = null;
pgEvent.HeaderTableLayout = null;
}
catch (Exception ex) {
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(MOD_NAME + "." + METHOD_NAME, ex);
throw (wscEx);
}
}
public static void AddTruckDetail(ref Document document, SqlDataReader drTrucks, DailyGrowerTareDetailEvent pgEvent)
{
const string METHOD_NAME = "AddTruckDetail";
string yardCard = null;
try {
pgEvent.HeaderNameList = _truckDetailHdrNames;
//PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
int iYardCard = drTrucks.GetOrdinal("Yard_Card_Sequence_Number");
int iDeliveryDate = drTrucks.GetOrdinal("Delivery_Date");
int iTruckNumber = drTrucks.GetOrdinal("Truck_Number");
int iWeightIn = drTrucks.GetOrdinal("Weight_In");
int iWeightOut = drTrucks.GetOrdinal("Weight_Out");
int iDirtWt = drTrucks.GetOrdinal("Dirt_Weight");
int iDirtTaken = drTrucks.GetOrdinal("Dirt_Taken");
int iNetWt = drTrucks.GetOrdinal("Net_Weight");
while (drTrucks.Read())
{
PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
// On first pass, add the header labels here.
if (yardCard == null)
{
PdfReports.FillHeaderLabels(ref table, _truckDetailHdrNames, _labelFont);
}
else
{
// Now let the PDF Page event handler take care of adding column labels on page breaks.
pgEvent.HeaderTableLayout = _primaryTableLayout;
}
yardCard = drTrucks.GetString(iYardCard);
PdfReports.AddText2Table(table, yardCard, _normalFont, "center");
PdfReports.AddText2Table(table, drTrucks.GetString(iDeliveryDate), _normalFont, "center");
PdfReports.AddText2Table(table, drTrucks.GetString(iTruckNumber), _normalFont, "center");
PdfReports.AddText2Table(table, drTrucks.GetInt32(iWeightIn).ToString("#,##0"), _normalFont, "right");
PdfReports.AddText2Table(table, drTrucks.GetInt32(iWeightOut).ToString("#,##0"), _normalFont, "right");
PdfReports.AddText2Table(table, drTrucks.GetInt32(iDirtWt).ToString("#,##0"), _normalFont, "right");
PdfReports.AddText2Table(table, drTrucks.GetString(iDirtTaken), _normalFont, "center");
PdfReports.AddText2Table(table, drTrucks.GetInt32(iNetWt).ToString("#,##0"), _normalFont, "right");
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
//PdfReports.AddTableNoSplit(document, pgEvent, table);
pgEvent.HeaderNameList = null;
pgEvent.HeaderTableLayout = null;
}
catch (Exception ex) {
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(MOD_NAME + "." + METHOD_NAME, ex);
throw (wscEx);
}
}
private static void AddSampleHdr(ref Document document, SqlDataReader drHdr, int cropYear, DailyGrowerTareDetailEvent pgEvent)
{
PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
PdfReports.AddText2Table(table, "Delivery Date", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetString(drHdr.GetOrdinal("Delivery_Date")), _normalFont);
PdfReports.AddText2Table(table, "1st Net Lbs", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("First_Net_Pounds")).ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "% Sugar", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetDecimal(drHdr.GetOrdinal("Sugar_Content")).ToString("0.00"), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Station No", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("Delivery_Station_No")).ToString(), _normalFont);
PdfReports.AddText2Table(table, "Tare Lbs", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("Tare_Pounds")).ToString(), _normalFont);
PdfReports.AddText2Table(table, drHdr.GetDecimal(drHdr.GetOrdinal("Tare")).ToString("0.00"), _normalFont);
PdfReports.AddText2Table(table, "SLM", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetDecimal(drHdr.GetOrdinal("SLM_Pct")).ToString("0.0000"), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Station Name", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetString(drHdr.GetOrdinal("Delivery_Station_Name")), _normalFont);
PdfReports.AddText2Table(table, "Final Net Lbs", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("Final_Net_Pounds")).ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Lbs Extractable Sugar/Ton", _normalFont, 2);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("ExSugarPerTon")).ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _labelFont, _primaryTableLayout.Length);
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
public static void AddSampleDetail(ref Document document, SqlDataReader drSamples, DailyGrowerTareDetailEvent pgEvent)
{
const string METHOD_NAME = "AddSampleDetail";
string yardCard = null;
PdfPTable table = null;
try {
pgEvent.HeaderNameList = _sampleDetailHdrNames;
while (drSamples.Read())
{
table = PdfReports.CreateTable(_tareTableLayout, 1);
// On first pass, add the header labels here.
if (yardCard == null)
{
PdfReports.FillHeaderLabels(ref table, _sampleDetailHdrNames, _labelFont);
}
else
{
// Now let the PDF Page event handler take care of adding column labels on page breaks.
pgEvent.HeaderTableLayout = _tareTableLayout;
}
yardCard = drSamples.GetString(drSamples.GetOrdinal("Yard_Card_No"));
PdfReports.AddText2Table(table, yardCard, _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetInt32(drSamples.GetOrdinal("SampleNo")).ToString("#"), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("Sugar_Content")).ToString("0.00"), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("Gross_Weight")).ToString("#,##0.0"), _normalFont, "right");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("Clean_Weight")).ToString("#,##0.0"), _normalFont, "right");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("Tare")).ToString("0.00"), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetString(drSamples.GetOrdinal("High_Tare")), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetInt32(drSamples.GetOrdinal("Sample_Quality")).ToString(), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("SLM_Pct")).ToString("0.0000"), _normalFont, "center");
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
pgEvent.HeaderNameList = null;
pgEvent.HeaderTableLayout = null;
// Follow the table with a blank line
table = PdfReports.CreateTable(_tareTableLayout, 1);
PdfReports.AddText2Table(table, " ", _normalFont, _tareTableLayout.Length);
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
catch (Exception ex) {
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(MOD_NAME + "." + METHOD_NAME, ex);
throw (wscEx);
}
}
public static void ReportBuilder(SqlDataReader drHdr, int cropYear, int contractNumber, string deliveryDates, FileStream fs)
{
const string METHOD_NAME = "ReportBuilder";
Document document = null;
PdfWriter writer = null;
DailyGrowerTareDetailEvent pgEvent = null;
int resetFlag = 0;
string dates = null;
int contractID = 0;
string factoryNo = "";
string firstDeliveryDate = null;
string nextDeliveryDate = null;
string lastDeliveryDate = null;
string busName = "";
string address1 = "";
string address2 = "";
string CSZ = "";
string rptTitle = "Western Sugar Cooperative\nDaily Grower Tare Detail Report";
try {
if (drHdr.Read()) {
contractID = drHdr.GetInt32(drHdr.GetOrdinal("ContractID"));
factoryNo = drHdr.GetString(drHdr.GetOrdinal("Delivery_Factory_No"));
firstDeliveryDate = drHdr.GetString(drHdr.GetOrdinal("Delivery_Date"));
nextDeliveryDate = firstDeliveryDate;
} else {
// Warn that we have no data.
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("No records matched your report criteria.");
throw (warn);
}
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
// Header Address Info
if (contractID > 0) {
using (SqlDataReader drAddr = WSCReportsExec.GrowerDetailReportAddr(conn, contractID)) {
if (drAddr.Read()) {
busName = drAddr.GetString(drAddr.GetOrdinal("Business_Name"));
address1 = drAddr.GetString(drAddr.GetOrdinal("Address_1"));
address2 = drAddr.GetString(drAddr.GetOrdinal("Address_2"));
CSZ = drAddr.GetString(drAddr.GetOrdinal("City")) + ", " +
drAddr.GetString(drAddr.GetOrdinal("State")) + " " +
drAddr.GetString(drAddr.GetOrdinal("Zip"));
}
}
}
// Sample / Tare information
// I use nextDeliveryDate as a trick to allow reading drHdr. Initially,
// nextDeliveryDate is loaded and we skip reading drHdr. Subsequently,
// the bottom of each iteration will null nextDeliveryDate and force reading drHdr.
int loadCount = 0;
while (nextDeliveryDate != null || drHdr.Read()) {
if (document == null) {
// IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!!
// *** US LETTER: 612 X 792 ***
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin, PortraitPageSize.PgBottomMargin);
// we create a writer that listens to the document
// and directs a PDF-stream to a file
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.FillEvent(contractNumber, busName, factoryNo, address1, address2, CSZ, resetFlag, rptTitle);
writer.PageEvent = pgEvent;
// Open the document
document.Open();
}
// load the delivery date.
nextDeliveryDate = drHdr.GetString(drHdr.GetOrdinal("Delivery_Date"));
// Acquire the sample details for the first station on a given day
if (lastDeliveryDate != nextDeliveryDate) {
AddSampleHdr(ref document, drHdr, cropYear, pgEvent);
lastDeliveryDate = nextDeliveryDate;
using (SqlDataReader drSamples = WSCReportsExec.GrowerDetailReportTares(conn, contractID, nextDeliveryDate)) {
AddSampleDetail(ref document, drSamples, pgEvent);
}
}
loadCount = 0;
// Display Truck information for each station
// on the first delivery day.
if (nextDeliveryDate == firstDeliveryDate) {
// Get the truck data.
SqlParameter[] spParams = null;
using (SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn, contractID,
drHdr.GetInt32(drHdr.GetOrdinal("Delivery_Station_ID")),
firstDeliveryDate, ref spParams)) {
AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0) {
AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"),
Convert.ToInt32(spParams[5].Value).ToString("#,##0"), pgEvent);
}
}
}
// clear date to force read in top of loop
nextDeliveryDate = null;
}
}
// ======================================================
// Close document
// ======================================================
if (document != null) {
pgEvent.IsDocumentClosing = true;
document.Close();
document = null;
}
if (writer == null) {
// Warn that we have no data.
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("No records matched your report criteria.");
throw (warn);
}
}
catch (Exception ex) {
string errMsg = "document is null: " + (document == null).ToString() + "; " +
"writer is null: " + (writer == null).ToString();
WSCIEMP.Common.CException wscex = new WSCIEMP.Common.CException(METHOD_NAME + errMsg, ex);
throw (wscex);
}
finally {
if (document != null) {
pgEvent.IsDocumentClosing = true;
document.Close();
}
if (writer != null) {
writer.Close();
}
}
}
private static void AddSampleHdr(ref Document document, SqlDataReader drHdr, int cropYear, DailyGrowerTareDetailEvent pgEvent)
{
PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
PdfReports.AddText2Table(table, "Delivery Date", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetString(drHdr.GetOrdinal("Delivery_Date")), _normalFont);
PdfReports.AddText2Table(table, "1st Net Lbs", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("First_Net_Pounds")).ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "% Sugar", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetDecimal(drHdr.GetOrdinal("Sugar_Content")).ToString("0.00"), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Station No", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("Delivery_Station_No")).ToString(), _normalFont);
PdfReports.AddText2Table(table, "Tare Lbs", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("Tare_Pounds")).ToString(), _normalFont);
PdfReports.AddText2Table(table, drHdr.GetDecimal(drHdr.GetOrdinal("Tare")).ToString("0.00"), _normalFont);
PdfReports.AddText2Table(table, "SLM", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetDecimal(drHdr.GetOrdinal("SLM_Pct")).ToString("0.0000"), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Station Name", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetString(drHdr.GetOrdinal("Delivery_Station_Name")), _normalFont);
PdfReports.AddText2Table(table, "Final Net Lbs", _normalFont);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("Final_Net_Pounds")).ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Lbs Extractable Sugar/Ton", _normalFont, 2);
PdfReports.AddText2Table(table, drHdr.GetInt32(drHdr.GetOrdinal("ExSugarPerTon")).ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _labelFont, _primaryTableLayout.Length);
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
public static void AddTruckDetail(ref Document document, SqlDataReader drTrucks, DailyGrowerTareDetailEvent pgEvent)
{
const string METHOD_NAME = "AddTruckDetail";
string yardCard = null;
try {
pgEvent.HeaderNameList = _truckDetailHdrNames;
//PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
int iYardCard = drTrucks.GetOrdinal("Yard_Card_Sequence_Number");
int iDeliveryDate = drTrucks.GetOrdinal("Delivery_Date");
int iTruckNumber = drTrucks.GetOrdinal("Truck_Number");
int iWeightIn = drTrucks.GetOrdinal("Weight_In");
int iWeightOut = drTrucks.GetOrdinal("Weight_Out");
int iDirtWt = drTrucks.GetOrdinal("Dirt_Weight");
int iDirtTaken = drTrucks.GetOrdinal("Dirt_Taken");
int iNetWt = drTrucks.GetOrdinal("Net_Weight");
while (drTrucks.Read()) {
PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
// On first pass, add the header labels here.
if (yardCard == null) {
PdfReports.FillHeaderLabels(ref table, _truckDetailHdrNames, _labelFont);
} else {
// Now let the PDF Page event handler take care of adding column labels on page breaks.
pgEvent.HeaderTableLayout = _primaryTableLayout;
}
yardCard = drTrucks.GetString(iYardCard);
PdfReports.AddText2Table(table, yardCard, _normalFont, "center");
PdfReports.AddText2Table(table, drTrucks.GetString(iDeliveryDate), _normalFont, "center");
PdfReports.AddText2Table(table, drTrucks.GetString(iTruckNumber), _normalFont, "center");
PdfReports.AddText2Table(table, drTrucks.GetInt32(iWeightIn).ToString("#,##0"), _normalFont, "right");
PdfReports.AddText2Table(table, drTrucks.GetInt32(iWeightOut).ToString("#,##0"), _normalFont, "right");
PdfReports.AddText2Table(table, drTrucks.GetInt32(iDirtWt).ToString("#,##0"), _normalFont, "right");
PdfReports.AddText2Table(table, drTrucks.GetString(iDirtTaken), _normalFont, "center");
PdfReports.AddText2Table(table, drTrucks.GetInt32(iNetWt).ToString("#,##0"), _normalFont, "right");
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
//PdfReports.AddTableNoSplit(document, pgEvent, table);
pgEvent.HeaderNameList = null;
pgEvent.HeaderTableLayout = null;
}
catch (Exception ex) {
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(MOD_NAME + "." + METHOD_NAME, ex);
throw (wscEx);
}
}
public static void AddTruckTotals(ref Document document, string loadCount, string dirtWeight, string netWeight, DailyGrowerTareDetailEvent pgEvent)
{
const string METHOD_NAME = "AddTruckTotals";
try {
PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
// Let the PDF Page event handler take care of adding column labels on page breaks.
pgEvent.HeaderNameList = _truckDetailHdrNames;
pgEvent.HeaderTableLayout = _primaryTableLayout;
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Load Count:", _labelFont);
PdfReports.AddText2Table(table, loadCount, _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, dirtWeight, _normalFont, "right");
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, netWeight, _normalFont, "right");
PdfReports.AddText2Table(table, " ", _normalFont, _primaryTableLayout.Length);
PdfReports.AddTableNoSplit(document, pgEvent, table);
pgEvent.HeaderNameList = null;
pgEvent.HeaderTableLayout = null;
}
catch (Exception ex) {
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(MOD_NAME + "." + METHOD_NAME, ex);
throw (wscEx);
}
}
public static void ReportBuilder(List<ListGrowerTareItem> hdrList, int cropYear, bool isPosted, bool isPreview, bool isHardCopy, bool isEmail,
bool isFax, FileStream fs, string filePath)
{
const string METHOD_NAME = "ReportBuilder";
const int RESET_FLAG = 0;
Document document = null;
PdfWriter writer = null;
DailyGrowerTareDetailEvent pgEvent = null;
List<ListGrowerTareItem> emailFaxList = null;
List<ListGrowerTareItem> hardCopyList = null;
int lastContractID = 0, lastStationID = 0;
int index = 0;
string firstDeliveryDate = "", busName = "", address1 = "", address2 = "", CSZ = "", emailAddress = "", faxNumber = "";
string rptTitle = "Western Sugar Cooperative\nDaily Grower Tare Detail Report";
try {
if (!isPreview) {
emailFaxList = hdrList.FindAll(item => item.RptType == "E" || item.RptType == "F");
hardCopyList = hdrList.FindAll(item => item.RptType == "M");
}
else {
// In preview mode we're going to lump these all together and print them.
hardCopyList = hdrList;
}
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
if (emailFaxList != null && emailFaxList.Count > 0) {
GrowerTareReportEmailFax(conn, filePath, ref emailFaxList, rptTitle, cropYear);
}
for (index = 0; index < hardCopyList.Count; index++) {
ListGrowerTareItem hdrItem = hardCopyList[index];
//----------------------------------------------------------------
// Changed contract or station, start a new print out.
//----------------------------------------------------------------
if (hdrItem.ContractID != lastContractID || hdrItem.Delivery_Station_ID != lastStationID) {
if (document == null) {
GetAddressInfo(conn, hdrItem.ContractID, out busName, out address1, out address2, out CSZ,
out emailAddress, out faxNumber);
// IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!!
// *** US LETTER: 612 X 792 ***
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin,
PortraitPageSize.PgBottomMargin);
// we create a writer that listens to the document
// and directs a PDF-stream to a file
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.FillEvent(hdrItem.Contract_No, busName, hdrItem.Delivery_Factory_No, address1, address2, CSZ,
RESET_FLAG, rptTitle + (!isPreview ? "" : " - " + hdrItem.RptType));
writer.PageEvent = pgEvent;
// Open the document
document.Open();
}
if (lastContractID != 0) {
//--------------------------------------------------------------------------
// Display Truck information for the first delivery day.
//--------------------------------------------------------------------------
int loadCount = 0;
//if (nextDeliveryDate == firstDeliveryDate) {
try {
// Get the truck data.
SqlParameter[] spParams = null;
using (
SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn,
lastContractID, lastStationID, firstDeliveryDate, ref spParams)) {
rptDailyGrowerTareDetail.AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0) {
rptDailyGrowerTareDetail.AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"),
Convert.ToInt32(spParams[5].Value).ToString("#,##0"), pgEvent);
}
}
}
catch {
hardCopyList[index-1].Success += "Fail: Truck Detail ";
}
GetAddressInfo(conn, hdrItem.ContractID, out busName, out address1, out address2, out CSZ,
out emailAddress, out faxNumber);
// New Page !: in Preview mode, append the report type to the title of the report.
pgEvent.FillEvent(hdrItem.Contract_No, busName, hdrItem.Delivery_Factory_No, address1, address2, CSZ,
RESET_FLAG, rptTitle + (!isPreview ? "" : " - " + hdrItem.RptType));
document.NewPage();
}
firstDeliveryDate = hdrItem.Delivery_Date;
lastStationID = hdrItem.Delivery_Station_ID;
lastContractID = hdrItem.ContractID;
}
try {
AddSampleHdr(ref document, hdrItem, cropYear, pgEvent);
using (
SqlDataReader drSamples = WSCReportsExec.GrowerDetailReportTares(conn, hdrItem.ContractID, hdrItem.Delivery_Date)) {
rptDailyGrowerTareDetail.AddSampleDetail(ref document, drSamples, pgEvent);
}
}
catch {
hardCopyList[index].Success += "Fail: Sample Detail ";
}
}
if (lastContractID != 0) {
//--------------------------------------------------------------------------
// Display Truck information for the first delivery day.
//--------------------------------------------------------------------------
int loadCount = 0;
try {
// Get the truck data.
SqlParameter[] spParams = null;
using (SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn,
lastContractID, lastStationID, firstDeliveryDate, ref spParams)) {
rptDailyGrowerTareDetail.AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0) {
rptDailyGrowerTareDetail.AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"), Convert.ToInt32(spParams[5].Value).ToString("#,##0"),
pgEvent);
}
}
}
catch {
hardCopyList[index-1].Success += "Fail: Truck Detail ";
}
}
}
//------------------------------------
// Print a Process Summary
//------------------------------------
if (document != null && writer != null) {
pgEvent.IsSummary = true;
document.NewPage();
PdfPTable procSumTab = null;
PrintSummary(document, ref procSumTab, hdrList, isPreview);
PdfReports.AddTableNoSplit(document, pgEvent, procSumTab);
} else {
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin,
PortraitPageSize.PgBottomMargin);
// we create a writer that listens to the document
// and directs a PDF-stream to a file
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.IsSummary = true;
writer.PageEvent = pgEvent;
// Open the document
document.Open();
PdfPTable procSumTab = null;
PrintSummary(document, ref procSumTab, hdrList, isPreview);
PdfReports.AddTableNoSplit(document, pgEvent, procSumTab);
}
// ======================================================
// Close document
// ======================================================
if (document != null) {
pgEvent.IsDocumentClosing = true;
document.Close();
document = null;
}
}
catch (Exception ex) {
string errMsg = "document is null: " + (document == null).ToString() + "; " +
"writer is null: " + (writer == null).ToString();
CException wscex = new CException(METHOD_NAME + errMsg, ex);
throw (wscex);
}
finally {
if (document != null) {
pgEvent.IsDocumentClosing = true;
document.Close();
}
if (writer != null) {
writer.Close();
}
}
}
public static void AddSampleDetail(ref Document document, SqlDataReader drSamples, DailyGrowerTareDetailEvent pgEvent)
{
const string METHOD_NAME = "AddSampleDetail";
string yardCard = null;
PdfPTable table = null;
try {
pgEvent.HeaderNameList = _sampleDetailHdrNames;
while (drSamples.Read()) {
table = PdfReports.CreateTable(_tareTableLayout, 1);
// On first pass, add the header labels here.
if (yardCard == null) {
PdfReports.FillHeaderLabels(ref table, _sampleDetailHdrNames, _labelFont);
} else {
// Now let the PDF Page event handler take care of adding column labels on page breaks.
pgEvent.HeaderTableLayout = _tareTableLayout;
}
yardCard = drSamples.GetString(drSamples.GetOrdinal("Yard_Card_No"));
PdfReports.AddText2Table(table, yardCard, _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetInt32(drSamples.GetOrdinal("SampleNo")).ToString("#"), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("Sugar_Content")).ToString("0.00"), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("Gross_Weight")).ToString("#,##0.0"), _normalFont, "right");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("Clean_Weight")).ToString("#,##0.0"), _normalFont, "right");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("Tare")).ToString("0.00"), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetString(drSamples.GetOrdinal("High_Tare")), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetInt32(drSamples.GetOrdinal("Sample_Quality")).ToString(), _normalFont, "center");
PdfReports.AddText2Table(table, drSamples.GetDecimal(drSamples.GetOrdinal("SLM_Pct")).ToString("0.0000"), _normalFont, "center");
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
pgEvent.HeaderNameList = null;
pgEvent.HeaderTableLayout = null;
// Follow the table with a blank line
table = PdfReports.CreateTable(_tareTableLayout, 1);
PdfReports.AddText2Table(table, " ", _normalFont, _tareTableLayout.Length);
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
catch (Exception ex) {
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(MOD_NAME + "." + METHOD_NAME, ex);
throw (wscEx);
}
}
private static void GrowerTareReportEmailFax(SqlConnection conn, string filePath, ref List<ListGrowerTareItem> emailList, string rptTitle, int cropYear )
{
const string METHOD_NAME = "GrowerTareReportEmailFax";
const string SEND_RPT_SUBJECT = "WESTERN SUGAR COOPERATIVE - Daily Grower Tare Detail Report";
const int RESET_FLAG = 0;
FileStream fs = null;
Document document = null;
PdfWriter writer = null;
DailyGrowerTareDetailEvent pgEvent = null;
int lastContractID = 0, lastStationID = 0;
int index = 0;
string destinationFile = "", lastRptType = "";
string firstDeliveryDate = "", busName = "", address1 = "", address2 = "", CSZ = "", emailAddress = "", faxNumber = "";
try {
for (index = 0; index < emailList.Count; index++) {
ListGrowerTareItem hdrItem = emailList[index];
//----------------------------------------------------------------
// Changed contract or station, start a new print out.
//----------------------------------------------------------------
if (hdrItem.ContractID != lastContractID || hdrItem.Delivery_Station_ID != lastStationID) {
if (document == null) {
GetAddressInfo(conn, hdrItem.ContractID, out busName, out address1, out address2, out CSZ,
out emailAddress, out faxNumber);
// IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!!
// *** US LETTER: 612 X 792 ***
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin,
PortraitPageSize.PgBottomMargin);
destinationFile = filePath.Substring(0, filePath.Length - 4) + "_" + hdrItem.Delivery_Station_No + "_" + hdrItem.Contract_No.ToString() + ".pdf";
// we create a writer that listens to the document
// and directs a PDF-stream to a file
if (File.Exists(destinationFile)) {
File.Delete(destinationFile);
}
fs = new FileStream(destinationFile, FileMode.Create, FileAccess.Write, FileShare.Read);
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.FillEvent(hdrItem.Contract_No, busName, hdrItem.Delivery_Factory_No, address1, address2, CSZ,
RESET_FLAG, rptTitle);
writer.PageEvent = pgEvent;
// Open the document
document.Open();
}
if (lastContractID != 0) {
//--------------------------------------------------------------------------
// Display Truck information for the first delivery day.
//--------------------------------------------------------------------------
int loadCount = 0;
try {
// Get the truck data.
SqlParameter[] spParams = null;
using (
SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn,
lastContractID, lastStationID, firstDeliveryDate, ref spParams)) {
rptDailyGrowerTareDetail.AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0) {
rptDailyGrowerTareDetail.AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"),
Convert.ToInt32(spParams[5].Value).ToString("#,##0"), pgEvent);
}
}
}
catch {
emailList[index - 1].Success += "Fail: Truck Detail ";
}
// Save File & Send File
// ======================================================
// Close document and write effectively saves the file
// ======================================================
if (document != null) {
if (pgEvent != null) {
pgEvent.IsDocumentClosing = true;
}
document.Close();
document = null;
}
if (writer != null) {
writer.Close();
writer = null;
}
fs.Close();
fs = null;
// Send Report File
if (lastRptType == "E") {
if (!SendEmailReport(SEND_RPT_SUBJECT,
ConfigurationManager.AppSettings["email.target.employeeServiceFrom"].ToString(), emailAddress, destinationFile)) {
emailList[index - 1].Success += "Fail: Email ";
}
} else {
// Send FAX
if (!SendFaxReport(SEND_RPT_SUBJECT,
ConfigurationManager.AppSettings["email.target.employeeServiceFrom"].ToString(),
"", faxNumber, busName, "", busName, destinationFile)) {
emailList[index - 1].Success += "Fail: Fax ";
}
}
GetAddressInfo(conn, hdrItem.ContractID, out busName, out address1, out address2, out CSZ,
out emailAddress, out faxNumber);
// New document needed.
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin,
PortraitPageSize.PgBottomMargin);
destinationFile = filePath.Substring(0, filePath.Length - 4) + "_" + hdrItem.Delivery_Station_No + "_" + hdrItem.Contract_No.ToString() + ".pdf";
// we create a writer that listens to the document
// and directs a PDF-stream to a file
if (File.Exists(destinationFile)) {
File.Delete(destinationFile);
}
fs = new FileStream(destinationFile, FileMode.Create, FileAccess.Write, FileShare.Read);
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.FillEvent(hdrItem.Contract_No, busName, hdrItem.Delivery_Factory_No, address1, address2, CSZ,
RESET_FLAG, rptTitle);
writer.PageEvent = pgEvent;
// Open the document
document.Open();
}
firstDeliveryDate = hdrItem.Delivery_Date;
lastStationID = hdrItem.Delivery_Station_ID;
lastContractID = hdrItem.ContractID;
lastRptType = hdrItem.RptType;
}
try {
AddSampleHdr(ref document, hdrItem, cropYear, pgEvent);
using (
SqlDataReader drSamples = WSCReportsExec.GrowerDetailReportTares(conn, hdrItem.ContractID, hdrItem.Delivery_Date)) {
rptDailyGrowerTareDetail.AddSampleDetail(ref document, drSamples, pgEvent);
}
}
catch {
emailList[index].Success += "Fail: Sample Detail ";
}
}
if (lastContractID != 0) {
//--------------------------------------------------------------------------
// Display Truck information for the first delivery day.
//--------------------------------------------------------------------------
int loadCount = 0;
try {
// Get the truck data.
SqlParameter[] spParams = null;
using (SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn,
lastContractID, lastStationID, firstDeliveryDate, ref spParams)) {
rptDailyGrowerTareDetail.AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0) {
rptDailyGrowerTareDetail.AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"), Convert.ToInt32(spParams[5].Value).ToString("#,##0"),
pgEvent);
}
}
}
catch {
emailList[index - 1].Success += "Fail: Truck Detail ";
}
}
// Save File & Send File
// ======================================================
// Close document and write effectively saves the file
// ======================================================
if (document != null) {
if (pgEvent != null) {
pgEvent.IsDocumentClosing = true;
}
document.Close();
document = null;
}
if (writer != null) {
writer.Close();
writer = null;
}
fs.Close();
fs = null;
// Send Report File
if (lastRptType == "E") {
if (!SendEmailReport(SEND_RPT_SUBJECT,
ConfigurationManager.AppSettings["email.target.employeeServiceFrom"].ToString(), emailAddress, destinationFile)) {
emailList[index - 1].Success += "Fail: Email ";
}
} else {
// Send FAX
if (!SendFaxReport(SEND_RPT_SUBJECT,
ConfigurationManager.AppSettings["email.target.employeeServiceFrom"].ToString(),
"", faxNumber, busName, "", busName, destinationFile)) {
emailList[index - 1].Success += "Fail: FAx ";
}
}
}
catch (Exception ex) {
string errMsg = "document is null: " + (document == null).ToString() + "; " +
"writer is null: " + (writer == null).ToString();
CException wscex = new CException(METHOD_NAME + errMsg, ex);
throw (wscex);
}
finally {
if (document != null) {
pgEvent.IsDocumentClosing = true;
document.Close();
}
if (writer != null) {
writer.Close();
}
}
}
private static void AddSampleHdr(ref Document document, ListGrowerTareItem hdrItem, int cropYear, DailyGrowerTareDetailEvent pgEvent)
{
PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
PdfReports.AddText2Table(table, "Delivery Date", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Delivery_Date, _normalFont);
PdfReports.AddText2Table(table, "1st Net Lbs", _normalFont);
PdfReports.AddText2Table(table, hdrItem.First_Net_Pounds.ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "% Sugar", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Sugar_Content.ToString("0.00"), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Station No", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Delivery_Station_No, _normalFont);
PdfReports.AddText2Table(table, "Tare Lbs", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Tare_Pounds.ToString(), _normalFont);
PdfReports.AddText2Table(table, hdrItem.Tare.ToString("0.00"), _normalFont);
PdfReports.AddText2Table(table, "SLM", _normalFont);
PdfReports.AddText2Table(table, hdrItem.SLM_Pct.ToString("0.0000"), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Station Name", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Delivery_Station_Name, _normalFont);
PdfReports.AddText2Table(table, "Final Net Lbs", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Final_Net_Pounds.ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Lbs Extractable Sugar/Ton", _normalFont, 2);
PdfReports.AddText2Table(table, hdrItem.ExSugarPerTon.ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _labelFont, _primaryTableLayout.Length);
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
public static void ReportBuilder(List <ListGrowerTareItem> hdrList, int cropYear, bool isPosted, bool isPreview, bool isHardCopy, bool isEmail,
bool isFax, FileStream fs, string filePath)
{
const string METHOD_NAME = "ReportBuilder";
const int RESET_FLAG = 0;
Document document = null;
PdfWriter writer = null;
DailyGrowerTareDetailEvent pgEvent = null;
List <ListGrowerTareItem> emailFaxList = null;
List <ListGrowerTareItem> hardCopyList = null;
int lastContractID = 0, lastStationID = 0;
int index = 0;
string firstDeliveryDate = "", busName = "", address1 = "", address2 = "", CSZ = "", emailAddress = "", faxNumber = "";
string rptTitle = "Western Sugar Cooperative\nDaily Grower Tare Detail Report";
try {
if (!isPreview)
{
emailFaxList = hdrList.FindAll(item => item.RptType == "E" || item.RptType == "F");
hardCopyList = hdrList.FindAll(item => item.RptType == "M");
}
else
{
// In preview mode we're going to lump these all together and print them.
hardCopyList = hdrList;
}
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
if (emailFaxList != null && emailFaxList.Count > 0)
{
GrowerTareReportEmailFax(conn, filePath, ref emailFaxList, rptTitle, cropYear);
}
for (index = 0; index < hardCopyList.Count; index++)
{
ListGrowerTareItem hdrItem = hardCopyList[index];
//----------------------------------------------------------------
// Changed contract or station, start a new print out.
//----------------------------------------------------------------
if (hdrItem.ContractID != lastContractID || hdrItem.Delivery_Station_ID != lastStationID)
{
if (document == null)
{
GetAddressInfo(conn, hdrItem.ContractID, out busName, out address1, out address2, out CSZ,
out emailAddress, out faxNumber);
// IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!!
// *** US LETTER: 612 X 792 ***
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin,
PortraitPageSize.PgBottomMargin);
// we create a writer that listens to the document
// and directs a PDF-stream to a file
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.FillEvent(hdrItem.Contract_No, busName, hdrItem.Delivery_Factory_No, address1, address2, CSZ,
RESET_FLAG, rptTitle + (!isPreview ? "" : " - " + hdrItem.RptType));
writer.PageEvent = pgEvent;
// Open the document
document.Open();
}
if (lastContractID != 0)
{
//--------------------------------------------------------------------------
// Display Truck information for the first delivery day.
//--------------------------------------------------------------------------
int loadCount = 0;
//if (nextDeliveryDate == firstDeliveryDate) {
try {
// Get the truck data.
SqlParameter[] spParams = null;
using (
SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn,
lastContractID, lastStationID, firstDeliveryDate, ref spParams)) {
rptDailyGrowerTareDetail.AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0)
{
rptDailyGrowerTareDetail.AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"),
Convert.ToInt32(spParams[5].Value).ToString("#,##0"), pgEvent);
}
}
}
catch {
hardCopyList[index - 1].Success += "Fail: Truck Detail ";
}
GetAddressInfo(conn, hdrItem.ContractID, out busName, out address1, out address2, out CSZ,
out emailAddress, out faxNumber);
// New Page !: in Preview mode, append the report type to the title of the report.
pgEvent.FillEvent(hdrItem.Contract_No, busName, hdrItem.Delivery_Factory_No, address1, address2, CSZ,
RESET_FLAG, rptTitle + (!isPreview ? "" : " - " + hdrItem.RptType));
document.NewPage();
}
firstDeliveryDate = hdrItem.Delivery_Date;
lastStationID = hdrItem.Delivery_Station_ID;
lastContractID = hdrItem.ContractID;
}
try {
AddSampleHdr(ref document, hdrItem, cropYear, pgEvent);
using (
SqlDataReader drSamples = WSCReportsExec.GrowerDetailReportTares(conn, hdrItem.ContractID, hdrItem.Delivery_Date)) {
rptDailyGrowerTareDetail.AddSampleDetail(ref document, drSamples, pgEvent);
}
}
catch {
hardCopyList[index].Success += "Fail: Sample Detail ";
}
}
if (lastContractID != 0)
{
//--------------------------------------------------------------------------
// Display Truck information for the first delivery day.
//--------------------------------------------------------------------------
int loadCount = 0;
try {
// Get the truck data.
SqlParameter[] spParams = null;
using (SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn,
lastContractID, lastStationID, firstDeliveryDate, ref spParams)) {
rptDailyGrowerTareDetail.AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0)
{
rptDailyGrowerTareDetail.AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"), Convert.ToInt32(spParams[5].Value).ToString("#,##0"),
pgEvent);
}
}
}
catch {
hardCopyList[index - 1].Success += "Fail: Truck Detail ";
}
}
}
//------------------------------------
// Print a Process Summary
//------------------------------------
if (document != null && writer != null)
{
pgEvent.IsSummary = true;
document.NewPage();
PdfPTable procSumTab = null;
PrintSummary(document, ref procSumTab, hdrList, isPreview);
PdfReports.AddTableNoSplit(document, pgEvent, procSumTab);
}
else
{
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin,
PortraitPageSize.PgBottomMargin);
// we create a writer that listens to the document
// and directs a PDF-stream to a file
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.IsSummary = true;
writer.PageEvent = pgEvent;
// Open the document
document.Open();
PdfPTable procSumTab = null;
PrintSummary(document, ref procSumTab, hdrList, isPreview);
PdfReports.AddTableNoSplit(document, pgEvent, procSumTab);
}
// ======================================================
// Close document
// ======================================================
if (document != null)
{
pgEvent.IsDocumentClosing = true;
document.Close();
document = null;
}
}
catch (Exception ex) {
string errMsg = "document is null: " + (document == null).ToString() + "; " +
"writer is null: " + (writer == null).ToString();
CException wscex = new CException(METHOD_NAME + errMsg, ex);
throw (wscex);
}
finally {
if (document != null)
{
pgEvent.IsDocumentClosing = true;
document.Close();
}
if (writer != null)
{
writer.Close();
}
}
}
private static void AddSampleHdr(ref Document document, ListGrowerTareItem hdrItem, int cropYear, DailyGrowerTareDetailEvent pgEvent)
{
PdfPTable table = PdfReports.CreateTable(_primaryTableLayout, 1);
PdfReports.AddText2Table(table, "Delivery Date", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Delivery_Date, _normalFont);
PdfReports.AddText2Table(table, "1st Net Lbs", _normalFont);
PdfReports.AddText2Table(table, hdrItem.First_Net_Pounds.ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "% Sugar", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Sugar_Content.ToString("0.00"), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Station No", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Delivery_Station_No, _normalFont);
PdfReports.AddText2Table(table, "Tare Lbs", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Tare_Pounds.ToString(), _normalFont);
PdfReports.AddText2Table(table, hdrItem.Tare.ToString("0.00"), _normalFont);
PdfReports.AddText2Table(table, "SLM", _normalFont);
PdfReports.AddText2Table(table, hdrItem.SLM_Pct.ToString("0.0000"), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Station Name", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Delivery_Station_Name, _normalFont);
PdfReports.AddText2Table(table, "Final Net Lbs", _normalFont);
PdfReports.AddText2Table(table, hdrItem.Final_Net_Pounds.ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _normalFont);
PdfReports.AddText2Table(table, "Lbs Extractable Sugar/Ton", _normalFont, 2);
PdfReports.AddText2Table(table, hdrItem.ExSugarPerTon.ToString(), _normalFont);
PdfReports.AddText2Table(table, " ", _labelFont, _primaryTableLayout.Length);
PdfReports.AddTableNoSplit(document, pgEvent, table);
}
private static void GrowerTareReportEmailFax(SqlConnection conn, string filePath, ref List <ListGrowerTareItem> emailList, string rptTitle, int cropYear)
{
const string METHOD_NAME = "GrowerTareReportEmailFax";
const string SEND_RPT_SUBJECT = "WESTERN SUGAR COOPERATIVE - Daily Grower Tare Detail Report";
const int RESET_FLAG = 0;
FileStream fs = null;
Document document = null;
PdfWriter writer = null;
DailyGrowerTareDetailEvent pgEvent = null;
int lastContractID = 0, lastStationID = 0;
int index = 0;
string destinationFile = "", lastRptType = "";
string firstDeliveryDate = "", busName = "", address1 = "", address2 = "", CSZ = "", emailAddress = "", faxNumber = "";
try {
for (index = 0; index < emailList.Count; index++)
{
ListGrowerTareItem hdrItem = emailList[index];
//----------------------------------------------------------------
// Changed contract or station, start a new print out.
//----------------------------------------------------------------
if (hdrItem.ContractID != lastContractID || hdrItem.Delivery_Station_ID != lastStationID)
{
if (document == null)
{
GetAddressInfo(conn, hdrItem.ContractID, out busName, out address1, out address2, out CSZ,
out emailAddress, out faxNumber);
// IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!!
// *** US LETTER: 612 X 792 ***
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin,
PortraitPageSize.PgBottomMargin);
destinationFile = filePath.Substring(0, filePath.Length - 4) + "_" + hdrItem.Delivery_Station_No + "_" + hdrItem.Contract_No.ToString() + ".pdf";
// we create a writer that listens to the document
// and directs a PDF-stream to a file
if (File.Exists(destinationFile))
{
File.Delete(destinationFile);
}
fs = new FileStream(destinationFile, FileMode.Create, FileAccess.Write, FileShare.Read);
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.FillEvent(hdrItem.Contract_No, busName, hdrItem.Delivery_Factory_No, address1, address2, CSZ,
RESET_FLAG, rptTitle);
writer.PageEvent = pgEvent;
// Open the document
document.Open();
}
if (lastContractID != 0)
{
//--------------------------------------------------------------------------
// Display Truck information for the first delivery day.
//--------------------------------------------------------------------------
int loadCount = 0;
try {
// Get the truck data.
SqlParameter[] spParams = null;
using (
SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn,
lastContractID, lastStationID, firstDeliveryDate, ref spParams)) {
rptDailyGrowerTareDetail.AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0)
{
rptDailyGrowerTareDetail.AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"),
Convert.ToInt32(spParams[5].Value).ToString("#,##0"), pgEvent);
}
}
}
catch {
emailList[index - 1].Success += "Fail: Truck Detail ";
}
// Save File & Send File
// ======================================================
// Close document and write effectively saves the file
// ======================================================
if (document != null)
{
if (pgEvent != null)
{
pgEvent.IsDocumentClosing = true;
}
document.Close();
document = null;
}
if (writer != null)
{
writer.Close();
writer = null;
}
fs.Close();
fs = null;
// Send Report File
if (lastRptType == "E")
{
if (!SendEmailReport(SEND_RPT_SUBJECT,
ConfigurationManager.AppSettings["email.target.employeeServiceFrom"].ToString(), emailAddress, destinationFile))
{
emailList[index - 1].Success += "Fail: Email ";
}
}
else
{
// Send FAX
if (!SendFaxReport(SEND_RPT_SUBJECT,
ConfigurationManager.AppSettings["email.target.employeeServiceFrom"].ToString(),
"", faxNumber, busName, "", busName, destinationFile))
{
emailList[index - 1].Success += "Fail: Fax ";
}
}
GetAddressInfo(conn, hdrItem.ContractID, out busName, out address1, out address2, out CSZ,
out emailAddress, out faxNumber);
// New document needed.
document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin,
PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin,
PortraitPageSize.PgBottomMargin);
destinationFile = filePath.Substring(0, filePath.Length - 4) + "_" + hdrItem.Delivery_Station_No + "_" + hdrItem.Contract_No.ToString() + ".pdf";
// we create a writer that listens to the document
// and directs a PDF-stream to a file
if (File.Exists(destinationFile))
{
File.Delete(destinationFile);
}
fs = new FileStream(destinationFile, FileMode.Create, FileAccess.Write, FileShare.Read);
writer = PdfWriter.GetInstance(document, fs);
// Attach my override event handler(s)
pgEvent = new DailyGrowerTareDetailEvent();
pgEvent.FillEvent(hdrItem.Contract_No, busName, hdrItem.Delivery_Factory_No, address1, address2, CSZ,
RESET_FLAG, rptTitle);
writer.PageEvent = pgEvent;
// Open the document
document.Open();
}
firstDeliveryDate = hdrItem.Delivery_Date;
lastStationID = hdrItem.Delivery_Station_ID;
lastContractID = hdrItem.ContractID;
lastRptType = hdrItem.RptType;
}
try {
AddSampleHdr(ref document, hdrItem, cropYear, pgEvent);
using (
SqlDataReader drSamples = WSCReportsExec.GrowerDetailReportTares(conn, hdrItem.ContractID, hdrItem.Delivery_Date)) {
rptDailyGrowerTareDetail.AddSampleDetail(ref document, drSamples, pgEvent);
}
}
catch {
emailList[index].Success += "Fail: Sample Detail ";
}
}
if (lastContractID != 0)
{
//--------------------------------------------------------------------------
// Display Truck information for the first delivery day.
//--------------------------------------------------------------------------
int loadCount = 0;
try {
// Get the truck data.
SqlParameter[] spParams = null;
using (SqlDataReader drTrucks = WSCReportsExec.GrowerDetailReportASH(conn,
lastContractID, lastStationID, firstDeliveryDate, ref spParams)) {
rptDailyGrowerTareDetail.AddTruckDetail(ref document, drTrucks, pgEvent);
drTrucks.Close();
loadCount = Convert.ToInt32(spParams[3].Value);
if (loadCount > 0)
{
rptDailyGrowerTareDetail.AddTruckTotals(ref document, loadCount.ToString(),
Convert.ToInt32(spParams[4].Value).ToString("#,##0"), Convert.ToInt32(spParams[5].Value).ToString("#,##0"),
pgEvent);
}
}
}
catch {
emailList[index - 1].Success += "Fail: Truck Detail ";
}
}
// Save File & Send File
// ======================================================
// Close document and write effectively saves the file
// ======================================================
if (document != null)
{
if (pgEvent != null)
{
pgEvent.IsDocumentClosing = true;
}
document.Close();
document = null;
}
if (writer != null)
{
writer.Close();
writer = null;
}
fs.Close();
fs = null;
// Send Report File
if (lastRptType == "E")
{
if (!SendEmailReport(SEND_RPT_SUBJECT,
ConfigurationManager.AppSettings["email.target.employeeServiceFrom"].ToString(), emailAddress, destinationFile))
{
emailList[index - 1].Success += "Fail: Email ";
}
}
else
{
// Send FAX
if (!SendFaxReport(SEND_RPT_SUBJECT,
ConfigurationManager.AppSettings["email.target.employeeServiceFrom"].ToString(),
"", faxNumber, busName, "", busName, destinationFile))
{
emailList[index - 1].Success += "Fail: FAx ";
}
}
}
catch (Exception ex) {
string errMsg = "document is null: " + (document == null).ToString() + "; " +
"writer is null: " + (writer == null).ToString();
CException wscex = new CException(METHOD_NAME + errMsg, ex);
throw (wscex);
}
finally {
if (document != null)
{
pgEvent.IsDocumentClosing = true;
document.Close();
}
if (writer != null)
{
writer.Close();
}
}
}