public HttpResponseMessage FundTransfer(int amount, long destinationAccountNo, long SourceAccountNo) { try { accountDetail account = dbContext.accountDetails.Where(val => val.accountNumber == destinationAccountNo).Single <accountDetail>(); account.accountBalance += amount; accountTypeDetail accountType = dbContext.accountTypeDetails.Where(x => x.lowerBound <= account.accountBalance && x.upperBound >= account.accountBalance).Single <accountTypeDetail>(); account.accountType = accountType.accountType; accountDetail account1 = dbContext.accountDetails.Where(val => val.accountNumber == SourceAccountNo).Single <accountDetail>(); account1.accountBalance -= amount; accountType = dbContext.accountTypeDetails.Where(x => x.lowerBound <= account1.accountBalance && x.upperBound >= account1.accountBalance).Single <accountTypeDetail>(); account1.accountType = accountType.accountType; dbContext.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception exe) { return(Request.CreateResponse(HttpStatusCode.NotAcceptable)); } }
public HttpResponseMessage getAccountTypeOfGivenAmount(long amount) { accountTypeDetail accountType = dbContext.accountTypeDetails.Where(x => x.lowerBound <= amount && x.upperBound >= amount).Single <accountTypeDetail>(); return(Request.CreateResponse(HttpStatusCode.OK, accountType)); }