public BillingStatement(int _BillingContactID, DateTime _StartDate, DateTime _EndDate)
{
billingStatementRows = new List <BillingStatementRow>();
BillingStatementDataContext dc = new BillingStatementDataContext();
var result = dc.S1_BillingStatement_GetCurrentStatement(_BillingContactID, _StartDate, _EndDate);
foreach (var item in result)
{
BillingStatementRow billingStatementRow = new BillingStatementRow(item.Date, item.InvoiceNumber,
item.Type, item.Amount.Value, item.LinkID);
billingStatementRows.Add(billingStatementRow);
}
ClientContactsDataContext ccdc = new ClientContactsDataContext();
billingContact = ClientContacts.GetClientContactFromBillingContactID(_BillingContactID);
}
public AccountActivity(int _BillingContactID, int _UserID, int _InvoiceID, int _PaymentID)
{
accountActivityRows = new List <BillingStatementRow>();
BillingStatementDataContext dc = new BillingStatementDataContext();
var result = dc.S1_BillingStatement_GetBillingActivityForAnInvoiceIDAndPaymentID(_BillingContactID, _UserID, _InvoiceID, _PaymentID);
foreach (var item in result)
{
decimal Balance = (Math.Abs(item.Amount.GetValueOrDefault()) - item.TotalAmountSpent.GetValueOrDefault() - item.TotalAmountReceived.GetValueOrDefault()) - (item.CreditSpent.GetValueOrDefault() + item.CreditReceived.GetValueOrDefault());
BillingStatementRow accountActivityRow = new BillingStatementRow(item.Date, item.InvoiceNumber, item.Type, item.Amount.Value, item.LinkID, item.InvoiceList,
item.InvoiceDateList, item.PaymentSpentAmountList, item.IQBTransactionIDList, item.PtiQBTransactionIDList,
item.PaymentList, item.PaymentDateList, item.AmountReceivedList, item.PQBTransactionIDList, item.ItpQBTransactionIDList,
(item.InvoiceID.HasValue ? item.InvoiceID.Value.ToString() : ""), (item.PaymentID.HasValue ? item.PaymentID.Value.ToString() : ""),
item.InvoiceNumberList, (item.TotalAmountSpent.HasValue ? item.TotalAmountSpent.Value.ToString("f2") : ""),
(item.TotalAmountReceived.HasValue ? item.TotalAmountReceived.Value.ToString("f2") : ""), Balance, item.CreditReceived.GetValueOrDefault(), item.CreditSpent.GetValueOrDefault());
accountActivityRows.Add(accountActivityRow);
}
}
