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));
}
