private void _createGlaInvoiceLineItemTeamSplitRecordsInCrm(CRM.Model.Invoice crmInvoice, CRM.Model.InvoiceLineItem crmInvoiceLineItem, Model.InvoiceLineItem invoiceLineItem)
{
var engagement = this.Engagements.Find(x => x.Id == crmInvoice.EngagementId);
if (engagement.IsOngoingEngagement() && invoiceLineItem.LineItemType == Model.LineItemType.Fee)
{
var split = new CRM.Model.GlaInvoiceTeamSplit();
split.InvoiceLineItemId = crmInvoiceLineItem.Id;
split.StartDate = (DateTime)crmInvoiceLineItem.StartDate;
split.EndDate = (DateTime)crmInvoiceLineItem.EndDate;
split.TotalSplit = 100.00m;
split.ProductType = engagement.ProductType;
if (invoiceLineItem.IsWorkplace && invoiceLineItem.TeamId == new Guid("9FB7C526-7EAF-E311-B765-D8D385C29900")) // Workplace && RetireAdvisers
{
if (invoiceLineItem.ApprovedOn == null || ((DateTime)invoiceLineItem.ApprovedOn).Date.AddMonths(12) > invoiceLineItem.StartDate.Date) // IsNew
{
split.GeneralLedgerAccountId = this.GeneralLedgerAccounts.Find(x => x.QuickBooksAccountNumber.Equals("4042")).Id;
}
else // IsLegacy
{
split.GeneralLedgerAccountId = this.GeneralLedgerAccounts.Find(x => x.QuickBooksAccountNumber.Equals("4046")).Id;
}
}
else
{
switch (invoiceLineItem.TeamId.ToString().ToUpper())
{
case "7671B7ED-E4BA-DB11-9697-001143F10531": //ERISA
split.GeneralLedgerAccountId = this.GeneralLedgerAccounts.Find(x => x.QuickBooksAccountNumber.Equals("4020")).Id;
break;
case "7287DE04-E5BA-DB11-9697-001143F10531": //Investment
split.GeneralLedgerAccountId = this.GeneralLedgerAccounts.Find(x => x.QuickBooksAccountNumber.Equals("4030")).Id;
break;
case "9FB7C526-7EAF-E311-B765-D8D385C29900": //RetireAdvisers
split.GeneralLedgerAccountId = this.GeneralLedgerAccounts.Find(x => x.QuickBooksAccountNumber.Equals("4040")).Id;
break;
case "F8ECF41B-E5BA-DB11-9697-001143F10531": //Vendor
split.GeneralLedgerAccountId = this.GeneralLedgerAccounts.Find(x => x.QuickBooksAccountNumber.Equals("4050")).Id;
break;
}
}
var splitsInvoice = (CRM.Model.GlaInvoiceTeamSplit) this.GlaInvoiceTeamSplitsInvoiceLineItems
.FindAll(x => x.InvoiceLineItemId == crmInvoiceLineItem.Id)
.FindAll(x => x.GeneralLedgerAccountId == split.GeneralLedgerAccountId || (x.GeneralLedgerAccountId == Guid.Empty && split.GeneralLedgerAccountId == Guid.Empty))
.Find(x => x.StartDate.Date == split.StartDate.Date || x.StartDate.Date == ((DateTime)crmInvoice.StartDate).Date);
var isNew = true;
if (splitsInvoice != null)
{
split.Id = splitsInvoice.Id;
isNew = false;
}
CRM.Data.GlaInvoiceTeamSplit.Save(split, isNew);
}
else
{
var splitsAccounts = this.GlaInvoiceTeamSplitsAccounts
.FindAll(x => x.AccountId == engagement.ClientId)
.FindAll(x => x.ProductType == engagement.ProductType)
.FindAll(x => x.StartDate.Date <= ((DateTime)crmInvoice.EndDate).Date)
.FindAll(x => x.EndDate.Date > ((DateTime)crmInvoice.StartDate).Date);
foreach (var split in splitsAccounts)
{
var splitsInvoice = (CRM.Model.GlaInvoiceTeamSplit) this.GlaInvoiceTeamSplitsInvoiceLineItems
.FindAll(x => x.InvoiceLineItemId == crmInvoiceLineItem.Id)
.FindAll(x => x.GeneralLedgerAccountId == split.GeneralLedgerAccountId || (x.GeneralLedgerAccountId == Guid.Empty && split.GeneralLedgerAccountId == Guid.Empty))
.Find(x => x.StartDate.Date == split.StartDate.Date || x.StartDate.Date == ((DateTime)crmInvoice.StartDate).Date);
var isNew = true;
if (splitsInvoice != null)
{
split.Id = splitsInvoice.Id;
isNew = false;
}
var startDate = split.StartDate;
if (split.StartDate.Date <= ((DateTime)crmInvoice.StartDate).Date)
{
split.StartDate = (DateTime)crmInvoice.StartDate;
}
else
{
var coveredDays = (decimal)(((DateTime)crmInvoice.EndDate).Date - split.StartDate.Date).TotalDays;
var totalDays = (decimal)(((DateTime)crmInvoice.EndDate).Date - ((DateTime)crmInvoice.StartDate).Date).TotalDays;
split.TotalSplit = (coveredDays / totalDays) * 100.00m;
}
var endDate = split.EndDate;
if (split.EndDate.Date >= ((DateTime)crmInvoice.EndDate).Date)
{
split.EndDate = (DateTime)crmInvoice.EndDate;
}
else
{
var coveredDays = (decimal)(split.EndDate.Date - ((DateTime)crmInvoice.StartDate).Date).TotalDays;
var totalDays = (decimal)(((DateTime)crmInvoice.EndDate).Date - ((DateTime)crmInvoice.StartDate).Date).TotalDays;
split.TotalSplit = (coveredDays / totalDays) * 100.00m;
}
var accountId = split.AccountId;
var invoiceId = split.InvoiceId;
split.InvoiceId = Guid.Empty;
split.AccountId = Guid.Empty;
split.InvoiceLineItemId = crmInvoiceLineItem.Id;
CRM.Data.GlaInvoiceTeamSplit.Save(split, isNew);
split.AccountId = accountId;
split.InvoiceId = invoiceId;
split.StartDate = startDate;
split.EndDate = endDate;
}
}
}
private void _calculateLineItems()
{
var beginningOfYear = new DateTime(this.BillingDate.Year, 01, 01);
var invoiceMaster = new Data.InvoiceMaster();
var main = invoiceMaster.RunMain(beginningOfYear);
foreach (DataRow row in main.Rows)
{
var clientName = row["ClientName"].ToString();
var taskName = row["TaskName"].ToString();
DateTime?overageApprovedOn = null;
if (String.IsNullOrWhiteSpace(row["OverageApprovedOn"].ToString()) == false)
{
overageApprovedOn = DateTime.Parse(row["OverageApprovedOn"].ToString());
}
var engagement = this.Engagements.Find(x => x.Name == clientName);
if (engagement == null)
{
continue;
}
var invoices = this._generatedInvoices
.FindAll(x => x.EngagementId == engagement.Id)
.FindAll(x => x.IsMainInvoice == true);
var single = invoiceMaster.RunSingle(clientName, taskName, beginningOfYear);
foreach (var invoice in invoices)
{
var workplaceLineItem = new Model.InvoiceLineItem();
workplaceLineItem.ApprovedOn = overageApprovedOn;
var otherLineItem = new Model.InvoiceLineItem();
otherLineItem.ApprovedOn = overageApprovedOn;
foreach (DataRow row2 in single.Rows)
{
var teamId = Guid.Parse(row2["TeamId"].ToString());
var overageWorkplaceHours = decimal.Parse(row2["OverageWorkplaceHours"].ToString());
var overageWorkplaceAmount = decimal.Parse(row2["OverageWorkplaceAmount"].ToString());
var overageOtherHours = decimal.Parse(row2["OverageOtherHours"].ToString());
var overageOtherAmount = decimal.Parse(row2["OverageOtherAmount"].ToString());
var startTime = DateTime.Parse(row2["StartTime"].ToString());
workplaceLineItem.Name = taskName;
workplaceLineItem.TeamId = teamId;
workplaceLineItem.IsWorkplace = true;
workplaceLineItem.LineItemType = Model.LineItemType.Fee;
otherLineItem.Name = taskName;
otherLineItem.TeamId = teamId;
otherLineItem.IsWorkplace = false;
otherLineItem.LineItemType = Model.LineItemType.Fee;
if (invoice.BillingType == Model.BillingType.InAdvanced)
{
var range = (invoice.EndDate - invoice.StartDate).TotalDays - 3;
var billingStartDate = invoice.StartDate.AddDays(range * -1);
billingStartDate = new DateTime(billingStartDate.Year, billingStartDate.Month, 1);
var billingEndDate = invoice.StartDate.Date.AddSeconds(-1);
if (startTime.Date >= billingStartDate.Date && startTime.Date < billingEndDate.Date)
{
workplaceLineItem.Amount = workplaceLineItem.Amount + overageWorkplaceAmount;
if (String.IsNullOrWhiteSpace(workplaceLineItem.Description))
{
workplaceLineItem.Description = overageWorkplaceHours.ToString("0.00") + " Hours";
}
else
{
var hours = decimal.Parse(workplaceLineItem.Description.Replace(" Hours", ""));
workplaceLineItem.Description = (hours + overageWorkplaceHours).ToString("0.00") + " Hours";
}
otherLineItem.Amount = otherLineItem.Amount + overageOtherAmount;
if (String.IsNullOrWhiteSpace(otherLineItem.Description))
{
otherLineItem.Description = overageOtherHours.ToString("0.00") + " Hours";
}
else
{
var hours = decimal.Parse(otherLineItem.Description.Replace(" Hours", ""));
otherLineItem.Description = (hours + overageOtherHours).ToString("0.00") + " Hours";
}
}
workplaceLineItem.StartDate = DateTime.SpecifyKind(billingStartDate, DateTimeKind.Utc).AddHours(12);
workplaceLineItem.EndDate = DateTime.SpecifyKind(billingEndDate, DateTimeKind.Utc).AddSeconds(1).AddHours(-12);
otherLineItem.StartDate = DateTime.SpecifyKind(billingStartDate, DateTimeKind.Utc).AddHours(12);
otherLineItem.EndDate = DateTime.SpecifyKind(billingEndDate, DateTimeKind.Utc).AddSeconds(1).AddHours(-12);
}
else
{
if (startTime.Date >= invoice.StartDate.Date && startTime.Date <= invoice.EndDate.Date)
{
workplaceLineItem.Amount = workplaceLineItem.Amount + overageWorkplaceAmount;
otherLineItem.Amount = otherLineItem.Amount + overageOtherAmount;
}
workplaceLineItem.StartDate = invoice.StartDate;
workplaceLineItem.EndDate = invoice.EndDate;
otherLineItem.StartDate = invoice.StartDate;
otherLineItem.EndDate = invoice.EndDate;
}
}
if (workplaceLineItem.Amount > 0)
{
invoice.LineItems.Add(workplaceLineItem);
}
if (otherLineItem.Amount > 0)
{
invoice.LineItems.Add(otherLineItem);
}
}
}
foreach (var invoice in this._generatedInvoices.FindAll(x => x.InvoiceCredit > 0))
{
var engagement = this.Engagements.Find(x => x.Id == invoice.EngagementId);
var lineItem = new Model.InvoiceLineItem();
lineItem.Name = "Automatically Generated Invoice Credit";
lineItem.LineItemType = Model.LineItemType.Credit;
lineItem.Amount = invoice.InvoiceCredit;
lineItem.StartDate = invoice.StartDate;
lineItem.EndDate = invoice.EndDate;
//invoice.LineItems.Add(lineItem); // removed on 11/21/2016 - will be calculated manually for the time being
}
}