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