public IActionResult Edit(int?id)
{
var depositcontext = db.Deposits.Include(c => c.Currency).Include(d => d.Depositor).Include(t => t.Typedeposit).Include(e => e.Employee);
var items = depositcontext.Where(d => d.DespositID == id).ToList();
var currencies = new SelectList(db.Currencies, "CurrencyID", "NameCurrency", items.First().CurrencyID);
var depositors = new SelectList(db.Depositors, "DepositorID", "NameDep", items.First().DepositorID);
var typedeposits = new SelectList(db.Typesdeposits, "TypedepositID", "NameType", items.First().TypedepositID);
var emloyees = new SelectList(db.Employees, "EmployeeID", "NameEmpl", items.First().EmployeeID);
DepositsViewModel deposits = new DepositsViewModel
{
Deposits = items,
DepositViewModel = _deposit,
CurrenciesList = currencies,
DepositorsList = depositors,
TypedepositsList = typedeposits,
EmployeesList = emloyees
};
return(View(deposits));
}
public IActionResult Details(int?id)
{
var depositcontext = db.Deposits.Include(c => c.Currency).Include(d => d.Depositor).Include(t => t.Typedeposit).Include(e => e.Employee);
var items = depositcontext.Where(d => d.DespositID == id).ToList();
var currencies = new SelectList(db.Currencies, "CurrencyID", "NameCurrency");
var depositors = new SelectList(db.Depositors, "DepositorID", "NameDep");
var typedeposits = new SelectList(db.Typesdeposits, "TypedepositID", "NameType");
var emloyees = new SelectList(db.Employees, "EmployeeID", "NameEmpl");
DepositViewModel depositView = new DepositViewModel
{
DespositID = items.First().DespositID,
NameCurrency = items.First().Currency.NameCurrency,
NameDep = items.First().Depositor.NameDep,
NameType = items.First().Typedeposit.NameType,
NameEmpl = items.First().Employee.NameEmpl,
Depositsum = items.First().Depositsum,
Datedeposit = items.First().Datedeposit,
Refundamount = items.First().Refundamount,
Datereturn = items.First().Datereturn
};
DepositsViewModel deposit = new DepositsViewModel
{
Deposits = items,
DepositViewModel = _deposit,
CurrenciesList = currencies,
DepositorsList = depositors,
TypedepositsList = typedeposits,
EmployeesList = emloyees
};
if (items == null)
{
return(View("NotFound"));
}
else
{
return(View(deposit));
}
}
public IActionResult Index(int?currency, int?typedeposit, int page = 1, SortState sortOrder = SortState.DespositIDAsc)
{
int pageSize = 10;
IQueryable <Deposit> source = db.Deposits.Include(d => d.Currency)
.Include(d => d.Depositor)
.Include(d => d.Typedeposit)
.Include(d => d.Employee);
if (currency != null && currency != 0)
{
source = source.Where(p => p.CurrencyID == currency);
}
if (typedeposit != null && typedeposit != 0)
{
source = source.Where(p => p.TypedepositID == typedeposit);
}
switch (sortOrder)
{
case SortState.DespositIDDesc:
source = source.OrderByDescending(s => s.DespositID);
break;
case SortState.TypeOfCurrencyAsc:
source = source.OrderBy(s => s.Currency.NameCurrency);
break;
case SortState.TypeOfCurrencyDesc:
source = source.OrderByDescending(s => s.Currency.NameCurrency);
break;
case SortState.TypeOfDepositorAsc:
source = source.OrderBy(s => s.Depositor.NameDep);
break;
case SortState.TypeOfDepositorDesc:
source = source.OrderByDescending(s => s.Depositor.NameDep);
break;
case SortState.TypeOfTypedepositAsc:
source = source.OrderBy(s => s.Typedeposit.NameType);
break;
case SortState.TypeOfTypedepositDesc:
source = source.OrderByDescending(s => s.Typedeposit.NameType);
break;
case SortState.TypeOfEmployeeAsc:
source = source.OrderBy(s => s.Employee.NameEmpl);
break;
case SortState.TypeOfEmployeeDesc:
source = source.OrderByDescending(s => s.Employee.NameEmpl);
break;
case SortState.DepositsumAsc:
source = source.OrderBy(s => s.Depositsum);
break;
case SortState.DepositsumDesc:
source = source.OrderByDescending(s => s.Depositsum);
break;
case SortState.DatedepositAsc:
source = source.OrderBy(s => s.Datedeposit);
break;
case SortState.DatedepositDesc:
source = source.OrderByDescending(s => s.Datedeposit);
break;
case SortState.RefundamountAsc:
source = source.OrderBy(s => s.Refundamount);
break;
case SortState.RefundamountDesc:
source = source.OrderByDescending(s => s.Refundamount);
break;
case SortState.DatereturnAsc:
source = source.OrderBy(s => s.Datereturn);
break;
case SortState.DatereturnDesc:
source = source.OrderByDescending(s => s.Datereturn);
break;
default:
source = source.OrderBy(s => s.DespositID);
break;
}
var count = source.Count();
var items = source.Skip((page - 1) * pageSize).Take(pageSize).ToList();
PageViewModel pageViewModel = new PageViewModel(count, page, pageSize);
DepositsFilterViewModel depositsFilterViewModel = new DepositsFilterViewModel(db.Currencies.ToList(), db.Typesdeposits.ToList(), currency, typedeposit);
DepositsViewModel deposits = new DepositsViewModel
{
Deposits = items,
DepositViewModel = _deposit,
PageViewModel = pageViewModel,
SortViewModel = new DepositsSortViewModel(sortOrder),
FilterViewModel = depositsFilterViewModel
};
return(View(deposits));
}