private void createDetailFooter(InvoiceDataset.ClientInvoiceTableRow invoice)
{
//
Detail detail = global::Argix.Finance.Globals.Detail;
detail.Reference.Value2 = "PLEASE REFERENCE INVOICE# " + invoice.InvoiceNumber + " WHEN REMITING PAYMENT. I.C.C. REGULATIONS REQUIRE THAT THIS BILL BE PAID WITHIN " + invoice.PaymentDays + " DAYS";
}
private void showHeader(InvoiceDataset.ClientInvoiceTableRow invoice)
{
//Set named range summary values
Sheet1 ws = global::Argix.Finance.Globals.Sheet1;
Application.ScreenUpdating = false;
ws.Range[ws.Cells[1, 1], ws.Cells[1, 1]].Value2 = invoice.FileHeader;
Application.ScreenUpdating = true;
}
private void createDetailHeader(InvoiceDataset.ClientInvoiceTableRow invoice)
{
//Set named range summary values
Detail detail = global::Argix.Finance.Globals.Detail;
//Remit To
detail.ClientNumberDiv.Value = (invoice.IsClientNumberNull()?"":invoice.ClientNumber.Trim()) + ' ' + (invoice.IsClientDivisionNull()?"":invoice.ClientDivision.Trim());
detail.RemitToName.Value = invoice.RemitToName.Trim();
detail.RemitToAddressLine1.Value = invoice.RemitToAddressLine1.Trim() + " " + invoice.RemitToCity.Trim() + ", " + invoice.RemitToState.Trim() + " " + invoice.RemitToZip.Trim();
detail.Telephone.Value = (invoice.IsTelephoneNull() ? "" : invoice.Telephone.ToString());
//Bill To
detail.BillToName.Value = invoice.BillToName.Trim();
detail.BillToAddressLine1.Value = invoice.BillToAddressline1.Trim();
detail.BillToAddressLine2.Value = (!invoice.IsBillToAddressline2Null() && invoice.BillToAddressline2.Trim().Length > 0) ? invoice.BillToAddressline2.Trim() : invoice.BillToCity.Trim() + ", " + invoice.BillToState.Trim() + " " + invoice.BillToZip.Trim();
detail.BillToCityStateZip.Value = (!invoice.IsBillToAddressline2Null() && invoice.BillToAddressline2.Trim().Length > 0) ? invoice.BillToCity.Trim() + ", " + invoice.BillToState.Trim() + " " + invoice.BillToZip.Trim() : "";
//Account
detail.InvoiceNumber.Value = invoice.InvoiceNumber.Trim();
detail.InvoiceDate.Value = invoice.InvoiceDate;
}
private void createDetailHeader(InvoiceDataset.ClientInvoiceTableRow invoice)
{
//Create header of detail worksheet
Detail detail = global::Argix.Finance.Globals.Detail;
//Remit To
detail.RemitToName.Value = invoice.RemitToName.Trim();
detail.RemitToAddressLine1.Value = invoice.RemitToAddressLine1.Trim();
//detail.RemitToAddressLine2.Value = invoice.IsRemitToAddressLine2Null() ? "" : invoice.RemitToAddressLine2.Trim();
detail.RemitToCityStateZip.Value = invoice.RemitToCity.Trim() + ", " + invoice.RemitToState.Trim() + " " + invoice.RemitToZip.Trim();
detail.Telephone.Value = "Tel# " + (invoice.IsTelephoneNull() ? "" : invoice.Telephone.ToString());
//Bill To
detail.BillToName.Value = invoice.BillToName.Trim();
detail.BillToAddressLine1.Value = invoice.BillToAddressline1.Trim();
detail.BillToAddressLine2.Value = invoice.IsBillToAddressline2Null() ? "" : invoice.BillToAddressline2.Trim();
detail.BillToCityStateZip.Value = invoice.BillToCity.Trim() + ", " + invoice.BillToState.Trim() + " " + invoice.BillToZip.Trim() + "-" + invoice.BillToZIP4.Trim();
//Account
detail.InvoiceNumber.Value = ""; // invoice.InvoiceNumber.Trim();
detail.InvoiceDate.Value = invoice.InvoiceDate;
detail.ShippedDate.Value = invoice.ReleaseDate;
detail.FuelSurcharge.Value = "Charges Include a Fuel Surcharge of " + invoice.FuelRate.ToString("#0.00");
}
