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