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