public async Task <IActionResult> NewBusinessSummary(int?periodId, string entity = "advisor")
        {
            MLFSReportingPeriod period;

            //get period
            if (periodId == null)
            {
                return(NotFound());
            }
            period = await _periodData.GetPeriodById((int)periodId);

            if (period == null)
            {
                return(NotFound());
            }
            List <MLFSSale> sales = await _salesData.GetSales(period);

            List <NewBusiness> report = NewBusiness.CreateList(sales, period);

            if (entity.ToLower() == "organisation")
            {
                report = report.GroupBy(x => x.Organisation).Select(y => new ViewModels.NewBusiness()
                {
                    Period          = y.FirstOrDefault().Period,
                    PeriodId        = y.FirstOrDefault().PeriodId,
                    Advisor         = y.Key,
                    AdvisorId       = 0,
                    Organisation    = y.Key,
                    NewClients      = y.Sum(z => z.NewClients),
                    ExistingClients = y.Sum(z => z.ExistingClients),
                    Total           = y.Sum(z => z.Total)
                }).ToList();
            }
            return(PartialView("_NewBusiness", report));
        }
        private async Task CreateNewBusinessExecute()
        {
            Debug.WriteLine(NewBusiness.ToString());

            await Task.Run(() =>
            {
                using (var db = new NerContext())
                {
                    db.Businesses.Add(NewBusiness);
                    db.SaveChanges();
                }
            });

            NewBusiness = new Business();
        }
        public BusinessInfo GetBusinessInfo(string businessId)
        {
            RemoveOldAndImpossibleBusinesses();
            var newBusinessInfo = CoreController.BusinessManager.GetBusinessInfo(businessId);

            if (actualBusinessInfo != null)
            {
                NewBusiness.Invoke(actualBusinessInfo.BusinessId, newBusinessInfo.BusinessId);
                if (!actualBusinessInfo.Location.Equals(newBusinessInfo.Location))
                {
                    ConnectingAppManager.EventResultsManager.CoreEventsResult("ChangeBalance",
                                                                              new List <string> {
                        "tranBlubber", (-(float)Math.Round(random.NextDouble() * 4 + 3, 2)).ToString()
                    });
                }
            }
            actualBusinessInfo = newBusinessInfo;
            ShowCoreAndConnectingAppEntities.Instance.ActualBusinessInfo = actualBusinessInfo;

            return(actualBusinessInfo);
        }