public Loan GetById(int id)
{
using (var ctx = new MicrozayimContext())
{
return(ctx.Loans.Include(x => x.LoanTransactions)
.FirstOrDefault(x => x.Id == id));
}
}
public void CreateLoan(Loan model)
{
using (var ctx = new MicrozayimContext())
{
ctx.Loans.Add(model);
ctx.SaveChanges();
}
}
public IReadOnlyCollection <Loan> GetAll()
{
using (var ctx = new MicrozayimContext())
{
return(ctx.Loans
.AsNoTracking()
.ToList());
}
}
public void UpdateLoan(Loan model)
{
using (var ctx = new MicrozayimContext())
{
var upAmount = ctx.Loans.FirstOrDefault(x => x.Id == model.Id);
upAmount.Amount = model.Amount;
upAmount.Status = model.Status;
ctx.SaveChanges();
}
}
