public dynamic UpdateBalance(TransactionDetail transactionDetail) { var sendacc = db.AccountDetails.Where(accnum => accnum.AccountNumber == transactionDetail.SenderAccount).FirstOrDefault(); var receacc = db.AccountDetails.Where(accnum => accnum.AccountNumber == transactionDetail.RecieverAccount).FirstOrDefault(); if (sendacc.AccountBalance >= transactionDetail.TransactionAmount) { sendacc.AccountBalance -= transactionDetail.TransactionAmount; receacc.AccountBalance += transactionDetail.TransactionAmount; db.SaveChanges(); } else { return(err); } var transid = (from t in db.TransactionDetails orderby t.TransactionID descending select t.TransactionID).FirstOrDefault(); return(transid); }
public void Add(TransactionDetail transactionDetail) { db.TransactionDetails.Add(transactionDetail); db.SaveChanges(); }