private List <Loan> getData() { List <Loan> data = new List <Loan>(); using (var ctx = new HLIMSystemEntities()) { data = ctx.tblLoans.Select(s => new Loan() { Id = s.Id, OurginalAmount = s.OriginalAmount, RemainingAmount = s.ReminingAmount, RemainingTenure = s.ReminingTenure, Tenure = s.OriginalTenure, Borrwoer = new Borrower() { Id = s.tblBorrower.Id, FirstName = s.tblBorrower.FirstName, MiddleName = s.tblBorrower.MiddleName, LastName = s.tblBorrower.LastName, Email = s.tblBorrower.Email, Gender = s.tblBorrower.Gender, MailingAddress = s.tblBorrower.MailingAddress, Phone = s.tblBorrower.Phone, StreetAddress = s.tblBorrower.StreetAddress } }).ToList <Loan>(); } return(data); }
private List <Insurence> GetData() { List <Insurence> data = new List <Insurence>(); using (var ctx = new HLIMSystemEntities()) { //data = ctx.tblBanks.ToList<tblBank>(); data = ctx.tblInsurences.Select(s => new Insurence() { Id = s.Id, Name = s.Name }).ToList <Insurence>(); } return(data); }
private List <Borrower> getData() { List <Borrower> data = new List <Borrower>(); using (var ctx = new HLIMSystemEntities()) { data = ctx.tblBorrowers.Select(s => new Borrower() { Id = s.Id, FirstName = s.FirstName, MiddleName = s.MiddleName, LastName = s.LastName, Email = s.Email, Gender = s.Gender, MailingAddress = s.MailingAddress, Phone = s.Phone, StreetAddress = s.StreetAddress }).ToList <Borrower>(); } return(data); }