public ActionResult Index()
{
ViewBag.adminName = Session["AdminName"];
var customermodel = new CustomerListViewModel
{
Customers = _customerManager.GetAllActives()
};
ViewBag.customers = customermodel.Customers.Count().ToString();
ViewBag.customerCount = customermodel.Customers.Where(x => x.IsActive == true).OrderByDescending(x => x.DateOfRegister).Take(10).Count();
var productModel = new ProductListViewModel
{
Products = _productManager.GetAll()
};
ViewBag.products = productModel.Products.Count().ToString();
var salesModel = new SalesDetailListViewModel
{
SalesDetails = _salesDetailManager.GetAll()
};
ViewBag.sales = salesModel.SalesDetails.Sum(x => x.SalesDetailTotal).ToString();
var expenseModel = new ExpenseListViewModel
{
Expenses = _expenseManager.GetAll()
};
ViewBag.expenseTotal = expenseModel.Expenses.Sum(x => x.ExpenseTotal).ToString();
var customerLisst = _customerManager.GetAll().Take(10).ToList();
var salesList = _salesDetailManager.GetAll().OrderByDescending(x => x.SalesDetailDate).Take(10).ToList();
var productList = _productManager.GetAll().Where(x => x.IsActive == true).OrderByDescending(x => x.ProductId).Take(5).ToList();
return(View(Tuple.Create <List <Customer>, List <SalesDetail>, List <Product> >(customerLisst, salesList, productList)));
}
public IActionResult Index([FromForm] ExpenseListViewModel form)
{
IEnumerable <Expense> selections = _expenseDatabase.GetExpenses();
if (form.SelectedMonth != 0)
{
selections = selections.Where(s => s.Datum.Month == form.SelectedMonth);
}
if (form.SelectedYear != 0)
{
selections = selections.Where(s => s.Datum.Year == form.SelectedYear);
}
var expenseList = selections.Select(expense => new ExpenseListItemViewModel
{
Id = expense.Id,
Omschrijving = expense.Omschrijving,
Bedrag = expense.Bedrag,
Datum = expense.Datum,
Categorie = expense.Categorie
}).ToList();
return(View(new ExpenseListViewModel
{
List = expenseList,
Years = GetYears(),
Highest = expenseList.Where(s => s.Bedrag == HoogsteBedrag(expenseList)).ToList(),
Lowest = expenseList.Where(s => s.Bedrag == laagsteBedrag(expenseList)).ToList(),
MostExpensiveDays = ExpensesPerDay(expenseList).Where(s => s.Value == ExpensesPerDay(expenseList).OrderBy(s => s.Value).Last().Value).ToDictionary(s => s.Key, s => s.Value),
MostExpensiveCategories = CostsOfCategories(expenseList).Where(s => s.Value == CostsOfCategories(expenseList).OrderBy(s => s.Value).Last().Value).ToDictionary(s => s.Key, s => s.Value),
CheapestCategories = CostsOfCategories(expenseList).Where(s => s.Value == CostsOfCategories(expenseList).OrderBy(s => s.Value).First().Value).ToDictionary(s => s.Key, s => s.Value),
SelectedMonth = form.SelectedMonth,
SelectedYear = form.SelectedYear
}));
}
public ViewResult Index(ExpenseListViewModel model)
{
if (string.IsNullOrEmpty(User.Identity.Name))
{
userName = "******";
}
else
{
userName = User.Identity.Name;
}
model.expenseList = _expenseRepository.GetExpensesAll(userName).OrderBy(e => e.ExpenseDate);
ViewBag.YearList = new SelectList(YearList);
if (model.searchCategory != null)
{
model.expenseList = model.expenseList.Where(e => e.ExpenseCategory == model.searchCategory);
}
if (model.searchType != null)
{
model.expenseList = model.expenseList.Where(e => e.ExpenseType == model.searchType);
}
if (model.searchYear != null)
{
model.expenseList = model.expenseList.Where(e => e.ExpenseDate.Year == model.searchYear);
}
if (model.searchMonth != null)
{
model.expenseList = model.expenseList.Where(e => e.ExpenseDate.Month == (int)model.searchMonth);
}
return(View(model));
}
public async Task <ExpenseListViewModel> Upload(IFormFile fileForm, string fileName, int expenseId)
{
var viewModel = new ExpenseListViewModel();
try
{
var expense = await _expenseRepository.Get(expenseId);
if (fileForm != null && fileForm.Length > 0)
{
using (var ms = new MemoryStream())
{
fileForm.CopyTo(ms);
var fileRawData = ms.ToArray();
var salesDocument = new SalesDocumentForm()
{
ExpenseId = expenseId,
Name = fileName,
FileRawData = fileRawData
};
await _salesDocumentRepository.Create(salesDocument);
}
}
viewModel.VirtualAccountId = expense.VirtualAccountId;
viewModel.Expenses = await _expenseRepository.GetAll(expense.VirtualAccountId);
}
catch (Exception e)
{
viewModel.Error = new GackoError(e);
}
return(viewModel);
}
public ActionResult Index()
{
var model = new ExpenseListViewModel
{
Expenses = _expenseManager.GetAll()
};
return(View(model));
}
public async Task <IActionResult> Update(ExpenseForm expense)
{
await _expenseService.Update(expense);
var viewModel = new ExpenseListViewModel()
{
VirtualAccountId = expense.VirtualAccountId,
Expenses = await _expenseService.GetAll(expense.VirtualAccountId)
};
return(PartialView("_ExpenseList", viewModel));
}
public async Task <IActionResult> Delete(int id)
{
var expense = await _expenseService.Get(id);
await _expenseService.Delete(id);
var viewModel = new ExpenseListViewModel()
{
VirtualAccountId = expense.VirtualAccountId,
Expenses = await _expenseService.GetAll(expense.VirtualAccountId)
};
return(PartialView("_ExpenseList", viewModel));
}
/// <summary>
/// Get all active expenses of an account by expense type
/// </summary>
/// <param name="username">Username of account</param>
/// <param name="type">Income type to filter</param>
/// <returns>List of active expenses</returns>
public static ExpenseListViewModel GetExpenseByUser(string username, int type)
{
Entities entities = new Entities();
DateTime current = DateTime.Now;
List <Expenses> queryResult = entities.Expenses.Where(x => x.Username.Equals(username) &&
x.ExpenseType == type &&
!x.DisabledDate.HasValue).ToList();
ExpenseListViewModel result = new ExpenseListViewModel
{
List = queryResult,
Type = type,
TotalMonthlyExpense = queryResult.Where(x => x.StartDate <= current && (x.EndDate.HasValue ? x.EndDate.Value >= current : true)).Select(x => x.Value).DefaultIfEmpty(0).Sum()
};
return(result);
}
protected override async void OnAppearing()
{
var expList = new ExpenseListViewModel();
vm.setBalance();
SetupView();
await expList.MakeExpenseList();
var list = expList.ExtendedExpenseList.OrderByDescending(i => i.Expense.Date).Take(5);
listView.ItemsSource = null;
listView.ItemsSource = list;
vm.Height = list.Count() * 78;
base.OnAppearing();
BindingContext = vm;
}
// GET: Expense
public ActionResult Index() //Home Page
{
if (Session["ID"] != null)
{
var viewModel = new ExpenseListViewModel();
//var request = new Expense.Engine.Request.GetExpensesRequest(); //Angular will do the post
//request.UserID = Convert.ToInt32(Session["ID"]);
//request.RoleID = Convert.ToInt32(Session["RoleID"]);
//viewModel.ExpenseList = Expense.Engine.Handlers.ExpenseHandler.GetAllExpenses(request).ExpenseList;
return(View(viewModel));
}
return(RedirectToAction("Index", "Login")); //If Session is empty, throw back to login
}
public IActionResult Admin(string filter, int pageNumber = 1)
{
TempData["filter"] = filter;
ViewBag.Updated = TempData["updated"];
Func <Expense, bool> filterFunction = e => String.IsNullOrEmpty(filter) || e.SpanishDescription.CaseInsensitiveContains(filter) || e.EnglishDescription.CaseInsensitiveContains(filter);
ExpenseListViewModel vm = new ExpenseListViewModel
{
CurrentFilter = filter,
Expenses = _expensesRepo.Expenses.Where(filterFunction)
.OrderBy(e => e.Id)
.Skip((pageNumber - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = pageNumber,
ItemsPerPage = this.PageSize,
TotalItems = _expensesRepo.Expenses.Count(filterFunction)
}
};
return(View(vm));
}
public async Task <IActionResult> Index()
{
List <ExpenseListViewModel> XpList = new List <ExpenseListViewModel>();
IEnumerable <Expense> expenses = await _dbContext.Expenses
.Include(x => x.Category).Where(expense => expense.ExpenseUserId == User.FindFirstValue(ClaimTypes.NameIdentifier)).ToListAsync();
IEnumerable <Expense> sortedExpenses = expenses.OrderBy(x => x.Date);
var expense = new ExpenseEditViewModel();
foreach (var thing in sortedExpenses)
{
ExpenseListViewModel Xp = new ExpenseListViewModel()
{
Id = thing.Id,
Category = thing.Category.Name,
Description = (string)thing.Description,
Date = (DateTime)thing.Date,
Amount = (decimal)thing.Amount,
PhotoUrl = thing.PhotoUrl
};
XpList.Add(Xp);
}
return(View(XpList));
}
public ExpenseListView()
{
BindingContext = new ExpenseListViewModel();
InitializeComponent();
}
public PartialViewResult _ExpenseTable(int type)
{
ExpenseListViewModel model = ExpenseQueries.GetExpenseByUser(UserQueries.GetCurrentUsername(), type);
return(PartialView(model));
}
public ActionResult _Report(int type)
{
ExpenseListViewModel model = ExpenseQueries.GetExpenseByUser(UserQueries.GetCurrentUsername(), type);
return(PartialView(model));
}
