public ActionResult UnpayedDebtorFilter()
{
DebtorComplaint list = new DebtorComplaint();
list.listComplaints = db.Complaints.ToList();
list.listDebtors = (from debtor in db.OrganisationDeptors
where debtor.IsPayed == false
select debtor).ToList();
return View("Debtors", list);
}
//Запрос на должника
public ActionResult QueryForCrucialDebtors()
{
DebtorComplaint list = new DebtorComplaint();
list.listDebtors = db.Database.SqlQuery<OrganisationDeptor>("GetCrucialDebtor @day_count", new SqlParameter("day_count", 3)).ToList();
list.listComplaints = db.Complaints.ToList();
return View("Debtors", list);
}
public ActionResult Debtors()
{
if (Session["Role"] != null && Session["Role"].ToString() == "Secretary")
{
//возвращаем в View нужные данные для формирования двух таблиц
DebtorComplaint list = new DebtorComplaint();
list.listComplaints = db.Complaints.ToList();
list.listDebtors = db.OrganisationDeptors.ToList();
return View(list);
}
else
{
return RedirectToAction("Http403", "Error");
}
}
