// GET: DepartamentValuationFacts
public async Task <IActionResult> Index(int?quarter, int?year, int?nameDepartament, int page = 1)
{
IQueryable <DepartamentValuationFact> companyContext = _context.DepartamentValuationFacts
.Include(d => d.Departament);
if (quarter != null && quarter != 0)
{
companyContext = companyContext.Where(d => d.Quarter == quarter);
}
if (year != null && year != 0)
{
companyContext = companyContext.Where(d => d.Year == year);
}
if (nameDepartament != null && nameDepartament != 0)
{
companyContext = companyContext.Where(d => d.Departament.Id == nameDepartament);
}
//разбиение на страницы
var count = await companyContext.CountAsync();
var departamentValuationFacts = await companyContext.Skip((page - 1) *pageSize).Take(pageSize).ToListAsync();
var departaments = await companyContext.Select(ef => ef.Departament).ToListAsync();
//формирование представления
IndexDepartamentViewModel departament = new IndexDepartamentViewModel
{
DepartamentValuationFacts = departamentValuationFacts,
PageViewModel = new PageViewModel(count, page, pageSize),
FilterDepartamentFactViewModel = new FilterDepartamentFactViewModel(departaments, quarter, year, nameDepartament)
};
return(View(departament));
}
public async Task <IHttpActionResult> Add(IndexDepartamentViewModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
await _service.Add(_mapper.Map <DepartamentBll>(model));
return(Ok());
}
public async Task <ActionResult> Edit(IndexDepartamentViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
await _service.Update(_mapper.Map <DepartamentBll>(model));
return(RedirectToAction("Index"));
}
