public int getCustomerId(long accountNo) { accountDetail account = dbContext.accountDetails.Where(val => val.accountNumber == accountNo).Single <accountDetail>(); int userId = int.Parse(account.userId.ToString()); return(userId); }
public ActionResult SaveAccountDetails(accountDetail accountDetail) { int dest = int.Parse(accountDetail.destination), origin = int.Parse(accountDetail.originate); var acc = _db.accounts.Where(a => a.aid == dest).FirstOrDefault(); var accO = _db.accounts.Where(a => a.aid == origin).FirstOrDefault(); acc.balance = acc.balance + accountDetail.import; _db.Entry(acc).State = System.Data.Entity.EntityState.Modified; _db.SaveChanges(); accountDetail.balance = acc.balance; accountDetail.destination = acc.ano; accountDetail.originate = accO.ano; accountDetail.aid = acc.aid; accountDetail.transType = true; _db.accountDetails.Add(accountDetail); _db.SaveChanges(); accO.balance = accO.balance - accountDetail.import; _db.Entry(accO).State = System.Data.Entity.EntityState.Modified; _db.SaveChanges(); accountDetail.balance = accO.balance; accountDetail.destination = acc.ano; accountDetail.originate = accO.ano; accountDetail.aid = accO.aid; accountDetail.transType = false; _db.accountDetails.Add(accountDetail); _db.SaveChanges(); return(Json("")); }
public HttpResponseMessage checkDestinationAccount(long accountNo) { try { accountDetail acc = dbContext.accountDetails.Where(val => val.accountNumber == accountNo).Single <accountDetail>(); } catch (Exception exe) { return(Request.CreateResponse(HttpStatusCode.NotFound, false)); } return(Request.CreateResponse(HttpStatusCode.OK, true)); }
public HttpResponseMessage BalanceEnquiry(long accountNo) { try { accountDetail account = (dbContext.accountDetails.Single(x => x.accountNumber == accountNo)); return(Request.CreateResponse(HttpStatusCode.OK, account)); } catch (Exception exe) { return(Request.CreateResponse(HttpStatusCode.NotFound, "Account not found")); } }
public HttpResponseMessage getAmount(long accountNo) { try { accountDetail account = dbContext.accountDetails.Where(val => val.accountNumber == accountNo).Single <accountDetail>(); int amt = (int)(account.accountBalance); return(Request.CreateResponse(HttpStatusCode.OK, amt)); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, -100)); } }
public HttpResponseMessage getSpecificAccountOfUser(long accountNo) { accountDetail account = dbContext.accountDetails.Where(x => x.accountNumber == accountNo).Single <accountDetail>(); accountDetailViewModel acc2 = new accountDetailViewModel(); //acc2.accountBalance = account.accountBalance; //acc2.accountNumber = xyz.accountNumber; //acc2.accountStatus = xyz.accountStatus; //acc2.accountType = xyz.accountType; //acc2.closingDate = xyz.closingDate; //acc2.createdBy = xyz.createdBy; //acc2.createdDate = xyz.createdDate; //acc2.editedDate = xyz.editedDate; //acc2.type = xyz.type; //acc2.updatedBy = xyz.updatedBy; //acc2.userId = xyz.userId; return(Request.CreateResponse(HttpStatusCode.OK, account)); }
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 getSpecificAccountOfUser(long accountNo) { accountDetail account = dbContext.accountDetails.Where(x => x.accountNumber == accountNo).Single <accountDetail>(); return(Request.CreateResponse(HttpStatusCode.OK, account)); }