public string GetLoanByCustomer(string customerName)
{
using (LoansDatabaseEntities entities = new LoansDatabaseEntities())
{
var loansList = entities.Loans.Where(x => x.CustName.Contains(customerName)).ToList();
if (loansList.Count > 0)
{
return(JsonConvert.SerializeObject(loansList, Formatting.Indented,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
}));
}
else
{
return("Table empty");
}
}
}
public string GetAllLoans()
{
using (LoansDatabaseEntities entities = new LoansDatabaseEntities())
{
var loansList = (from f in entities.Loans
select f).ToList <Loan>();
if (loansList.Count > 0)
{
return(JsonConvert.SerializeObject(loansList, Formatting.Indented,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
}));
}
else
{
return("Table empty");
}
}
}