private void createDetailHeader(InvoiceDS.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();
//detail.RemitToAddressLine2.Value = invoice.IsRemitToAddressLine2Null() ? "" : invoice.RemitToAddressLine2.Trim();
detail.RemitToCityStateZip.Value = 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();
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;
}
private void createDetailHeader(InvoiceDS.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");
}
