public static SalaryListViewModel GetSalaryByUser(string username) { Entities entities = new Entities(); var salaries = entities.Incomes.Where(x => x.Username.Equals(username) && x.IncomeType == (int)Constants.Constants.INCOME_TYPE.SALARY_INCOME && !x.DisabledDate.HasValue).OrderBy(x => x.Name).ToList(); SalaryListViewModel result = new SalaryListViewModel(); foreach (var salary in salaries) { SalaryViewModel viewModel = new SalaryViewModel { Id = salary.Id, Source = salary.Name, IncomeDay = salary.IncomeDay, Income = salary.Value, AnnualIncome = salary.Value * 12, Note = salary.Note }; result.Salaries.Add(viewModel); } result.TotalIncome = result.Salaries.Sum(x => x.Income.Value); result.TotalAnnualIncome = result.TotalIncome * 12; result.IsInitialized = UserQueries.IsCompleteInitialized(username); return(result); }
public ActionResult _SalaryTable() { SalaryListViewModel model = SalaryQueries.GetSalaryByUser(UserQueries.GetCurrentUsername()); return(PartialView(model)); }