public void SaveData(Loan_Account loan)
{
using (BankDbEntities Db = new BankDbEntities())
{
var s = Db.Saving_Account.Where(l => l.CustomerId == loan.CustomerId).FirstOrDefault();
if (s != null)
{
loan.CustomerId = s.CustomerId;
Db.Loan_Account.Add(loan);
Db.SaveChanges();
}
}
}
public async Task <IHttpActionResult> Put([FromUri] int customerId, [FromBody] Loan_Account loan)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid Model"));
}
using (BankDbEntities Db = new BankDbEntities())
{
var existingloan = Db.Loan_Account.FirstOrDefault <Loan_Account>(l => l.CustomerId == customerId);
if (existingloan != null)
{
existingloan.LoanAmount = loan.LoanAmount;
existingloan.Loan_AccountNo = loan.Loan_AccountNo;
await Db.SaveChangesAsync();
}
else
{
NotFound();
}
}
return(Ok());
}
public async Task <IHttpActionResult> PostLoanData(Loan_Account loan)
{
using (BankDbEntities Db = new BankDbEntities())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var task = Task.Run(() => Db.Saving_Account.Where(s => s.CustomerId == loan.CustomerId).FirstOrDefault());
var id = await task;
if (id != null)
{
Db.Loan_Account.Add(loan);
Db.SaveChanges();
return(Ok("Data Added"));
}
else
{
return(BadRequest("CustomerId Not Exist Loan cannot be initiated"));
}
}
}
