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); }