public static RepaymentsDTO getRepaymentById(int id)
{
db DB = new db();
Repayments repyment = DB.Repayments.FirstOrDefault(r => r.RepaymentId == id);
User user = DB.Users.FirstOrDefault(u => u.UserId == repyment.UserId);
RepaymentsDTO repaymentDTO = RepaymentConvert.DALtoDTO(repyment);
repaymentDTO.UserName = user.firstName + " " + user.lastname;
return(repaymentDTO);
}
public static LoanDTO GetByID(int LoanId)
{
db Sgmach = new db();
Loan loan = Sgmach.Loans.FirstOrDefault(l => l.LoanId == LoanId);
LoanDTO loanDTO = LoanConvert.DALtoDTO(loan);
List <Repayments> Repayments = Sgmach.Repayments.Where(r => r.LoanId == LoanId).ToList();
foreach (var Repayment in Repayments)
{
loanDTO.Repayments.Add(RepaymentConvert.DALtoDTO(Repayment));
}
return(loanDTO);
}
public static List <RepaymentsDTO> GetAll()
{
List <RepaymentsDTO> repyments = new List <RepaymentsDTO>();
db DB = new db();
foreach (var repyment in DB.Repayments)
{
var r = RepaymentConvert.DALtoDTO(repyment);
User user = DB.Users.FirstOrDefault(u => u.UserId == r.UserId);
r.UserName = user.firstName + " " + user.lastname;
repyments.Add(r);
}
return(repyments);
}
