public ActionResult Business(int?p, string search)
{
using (UnitOfWorkManager.NewUnitOfWork())
{
var pageIndex = p ?? 1;
var allBusinesses = string.IsNullOrEmpty(search) ? _businessService.GetAll(pageIndex, SiteConstants.Instance.AdminListPageSize) :
_businessService.SearchBusiness(search, pageIndex, SiteConstants.Instance.AdminListPageSize);
var listViewModel = new BusinessListViewModel
{
Businesses = allBusinesses,
PageIndex = pageIndex,
TotalCount = allBusinesses.TotalCount,
Search = search,
TotalPages = allBusinesses.TotalPages
};
StatesViewModel statesViewModel = new StatesViewModel()
{
allStates = SettingsService.ListOfStates().ToList()
};
var viewModel = new BusinessViewModel
{
_listViewModel = listViewModel,
_stateViewModel = statesViewModel
};
return(View(viewModel));
}
}
public ActionResult BusinessList()
{
var model = new BusinessListViewModel
{
Businesses = _contex.Businesses.Where(b => b.Public == true).ToList()
};
return(View(model));
}
public static BusinessListViewModel GetBusinessByUser(string username)
{
Entities entities = new Entities();
BusinessListViewModel result = new BusinessListViewModel();
DateTime current = DateTime.Now;
var businesss = entities.Assets.Include("Incomes").Include("Liabilities").Where(x => x.Username.Equals(username) &&
x.AssetType == (int)Constants.Constants.ASSET_TYPE.BUSINESS &&
!x.DisabledDate.HasValue);
foreach (var business in businesss)
{
BusinessViewModel businessViewModel = new BusinessViewModel();
businessViewModel.Id = business.Id;
businessViewModel.Name = business.AssetName;
businessViewModel.Value = business.Value;
if (business.Incomes1.Where(x => !x.DisabledDate.HasValue).Any())
{
businessViewModel.Income = business.Incomes1.FirstOrDefault().Value;
}
else
{
businessViewModel.Income = 0;
}
businessViewModel.AnnualIncome = businessViewModel.Income * 12;
businessViewModel.RentYield = businessViewModel.Value > 0 ? businessViewModel.AnnualIncome / businessViewModel.Value : 0;
foreach (var liability in business.Liabilities.Where(x => !x.DisabledDate.HasValue))
{
BusinessLiabilityViewModel liabilityViewModel = BusinessLiabilityQueries.CreateViewModel(liability);
businessViewModel.Liabilities.Add(liabilityViewModel);
}
var liabilities = businessViewModel.Liabilities.Where(x => x.StartDate <= current && x.EndDate >= current);
businessViewModel.TotalLiabilityValue = liabilities.Select(x => x.Value.Value).DefaultIfEmpty(0).Sum();
businessViewModel.TotalOriginalPayment = liabilities.Select(x => x.MonthlyOriginalPayment).DefaultIfEmpty(0).Sum();
businessViewModel.TotalInterestPayment = liabilities.Select(x => x.MonthlyInterestPayment).DefaultIfEmpty(0).Sum();
businessViewModel.TotalMonthlyPayment = liabilities.Select(x => x.TotalMonthlyPayment).DefaultIfEmpty(0).Sum();
businessViewModel.TotalPayment = liabilities.Select(x => x.TotalPayment).DefaultIfEmpty(0).Sum();
businessViewModel.TotalRemainedValue = liabilities.Select(x => x.RemainedValue).DefaultIfEmpty(0).Sum();
businessViewModel.TotalInterestRate = businessViewModel.TotalLiabilityValue > 0 ? liabilities.Select(x => x.OriginalInterestPayment).DefaultIfEmpty(0).Sum() / businessViewModel.TotalLiabilityValue * 12 : 0;
businessViewModel.RowSpan = businessViewModel.Liabilities.Any() ? businessViewModel.Liabilities.Count() + 3 : 2;
result.Businesses.Add(businessViewModel);
}
result.TotalValue = result.Businesses.Select(x => x.Value).DefaultIfEmpty(0).Sum();
result.TotalMonthlyIncome = result.Businesses.Select(x => x.Income).DefaultIfEmpty(0).Sum();
result.TotalAnnualIncome = result.TotalMonthlyIncome * 12;
result.TotalRentYield = result.TotalValue > 0 ? result.TotalAnnualIncome / result.TotalValue : 0;
result.IsInitialized = UserQueries.IsCompleteInitialized(username);
return(result);
}
public async Task <IActionResult> Pick()
{
var userId = this.User.FindFirst(ClaimTypes.NameIdentifier)?.Value;
var businesses = await this.businessService.GetAllForUserAsync <BusinessAllViewModel>(userId);
var businessesList = new BusinessListViewModel()
{
Businesses = businesses,
};
return(this.View(businessesList));
}
// GET: Dates
public async Task <ActionResult> Index()
{
var viewModel = new BusinessListViewModel();
var user = await GetUserAsync();
var date = await _context.Dates.FirstOrDefaultAsync(d => d.IsScheduled == false && d.UserId == user.Id);
var businesses = await _context.Businesses.Where(b => b.DateId == date.Id).ToListAsync();
viewModel.Date = date;
viewModel.Businesses = businesses;
return(View(viewModel));
}
public async Task <ActionResult> ViewPreviousBusinessesForScheduledDates(int id)
{
var viewModel = new BusinessListViewModel();
var user = await GetUserAsync();
var date = await _context.Dates.FirstOrDefaultAsync(d => d.IsScheduled == true && d.UserId == user.Id && d.Id == id);
var businesses = await _context.Businesses
.Include(b => b.LocationType)
.Where(b => b.DateId == date.Id).ToListAsync();
viewModel.Date = date;
viewModel.Businesses = businesses;
return(View(viewModel));
}
public async Task <ActionResult> Edit(int id, BusinessListViewModel businessListViewModel)
{
try
{
var date = await _context.Dates.FirstOrDefaultAsync(d => d.Id == id);
date.DateTime = businessListViewModel.DateTime;
_context.Dates.Update(date);
await _context.SaveChangesAsync();
return(RedirectToAction("ScheduledDates", "Dates"));
}
catch
{
return(View());
}
}
// GET: Dates/Edit/5
public async Task <ActionResult> Edit(int id)
{
var date = await _context.Dates.FirstOrDefaultAsync(d => d.Id == id);
var user = await GetUserAsync();
var viewModel = new BusinessListViewModel()
{
DateTime = date.DateTime
};
if (date.UserId != user.Id)
{
return(NotFound());
}
;
return(View(viewModel));
}
public async Task <ActionResult> CompleteDate(int DateId, BusinessListViewModel viewModel)
{
var user = await GetUserAsync();
var date = await _context.Dates.FirstOrDefaultAsync(d => d.Id == DateId);
date.DateTime = viewModel.DateTime;
date.IsScheduled = true;
_context.Dates.Update(date);
var newDate = new Date()
{
UserId = user.Id
};
_context.Dates.Add(newDate);
await _context.SaveChangesAsync();
return(RedirectToAction("ScheduledDates", "Dates"));
}
public ActionResult Directory(int?p, string search)
{
using (UnitOfWorkManager.NewUnitOfWork())
{
var pageIndex = p ?? 1;
var allBusinesses = string.IsNullOrEmpty(search) ? _businessService.GetAll(pageIndex, SiteConstants.Instance.AdminListPageSize) :
_businessService.SearchBusiness(search, pageIndex, SiteConstants.Instance.AdminListPageSize);
var businessList = _businessService.GetAllBusiness();
var viewModel = new BusinessListViewModel
{
Businesses = allBusinesses,
PageIndex = pageIndex,
TotalCount = allBusinesses.TotalCount,
Search = search,
TotalPages = allBusinesses.TotalPages,
NonPagedBusinesses = businessList.ToList()
};
return(View(viewModel));
}
}
public ActionResult _BusinessTable()
{
BusinessListViewModel model = BusinessQueries.GetBusinessByUser(UserQueries.GetCurrentUsername());
return(PartialView(model));
}
