public ActionResult initiateTransaction(TRANSACTION_DETAILS model) { ViewBag.Message = ""; int success = 0; var query = _db.USER_DETAILS.Where(r => r.ACCOUNT_NUMBER == model.account_number); USER_DETAILS[] userdetail = query.ToArray(); PerformTransactionService service = new PerformTransactionService(); success = service.updateTransactionDetails(model, userdetail); var query3 = _db1.USER_DETAILS.Where(r => r.ACCOUNT_NUMBER == model.account_number); USER_DETAILS[] updateduserdetail = query3.ToArray(); string k = updateduserdetail[0].ACCOUNT_BALANCE.ToString(); if (success == 1) { string l = "Transaction Successfully Completed. The balance available in your Account is " + k + "."; ViewBag.Message = l; } else { if (userdetail[0].ACCOUNT_TYPE == "Salary") { ViewBag.Message = "You do not have sufficient fund in your account. Your account balance is " + k + "."; } else { ViewBag.Message = "You should maintain minimum 5000 Rupee in your account. Your account balance is " + k + "."; } } return(View("~/Views/Home/BankManagementSystem.cshtml")); }
public void DeleteDetail(int id) { TRANSACTION_DETAILS detail = db.TRANSACTION_DETAILSs.Find(id); db.TRANSACTION_DETAILSs.Remove(detail); db.SaveChanges(); }
public void VerifyProductInDetail_NotProductInDetail_ReturnFalse() { TRANSACTION_DETAILS detail1 = new TRANSACTION_DETAILS(); TRANSACTION_DETAILS detail2 = new TRANSACTION_DETAILS(); TRANSACTION_DETAILS detail3 = new TRANSACTION_DETAILS(); TRANSACTION_DETAILS detail4 = new TRANSACTION_DETAILS(); detail1.productId = 1; detail2.productId = 2; detail3.productId = 3; detail4.productId = 4; int idProd = 7; IList <TRANSACTION_DETAILS> detailsList = new List <TRANSACTION_DETAILS> { detail1, detail2, detail3, detail4 }; bool result = TransactionBL.VerifyProductInDetail(idProd, detailsList); Assert.AreEqual(false, result); }
internal static IList <TRANSACTION_DETAILS> InitializeTransactionDetails() { IList <TRANSACTION_DETAILS> result = new List <TRANSACTION_DETAILS>(); TRANSACTION_DETAILS detail = new TRANSACTION_DETAILS(); result.Add(detail); return(result); }
public int updateTransactionDetailsCredit(TRANSACTION_DETAILS model, USER_DETAILS[] query) { _db.TRANSACTION_DETAILS.Add(model); _db.SaveChanges(); Int64 ACC_NUM = Convert.ToInt64(model.account_number); var query1 = _db.USER_DETAILS.Where(r => r.ACCOUNT_NUMBER == ACC_NUM); foreach (USER_DETAILS userdetail in query1) { userdetail.ACCOUNT_BALANCE = query[0].ACCOUNT_BALANCE + model.ACCOUNT_BALANCE; } _db.SaveChanges(); return(0); }
public int updateTransactionDetails(TRANSACTION_DETAILS model, USER_DETAILS[] query) { if (model.TRANSACTION_TYPE == "Withdrawal") { if (query[0].ACCOUNT_TYPE.ToString().ToLower() == "saving") { if (query[0].ACCOUNT_BALANCE - model.ACCOUNT_BALANCE < 5000) { return(0); } else { if (query[0].ACCOUNT_BALANCE - model.ACCOUNT_BALANCE < 0) { return(0); } else { PerformTransaction refer = new PerformTransaction(); int result = refer.updateTransactionDetailsDebit(model, query); return(1); } } } else { if (query[0].ACCOUNT_BALANCE - model.ACCOUNT_BALANCE < 0) { return(0); } else { PerformTransaction refer = new PerformTransaction(); int result = refer.updateTransactionDetailsDebit(model, query); return(1); } } } else { PerformTransaction refer = new PerformTransaction(); int result = refer.updateTransactionDetailsCredit(model, query); return(1); } }