public ActionResult Create([Bind(Include = "ID,TransDate,TransAmount,Source,Memo")] Transaction transaction)
{
if (ModelState.IsValid)
{
db.History.Add(transaction);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(transaction));
}
public IActionResult Create([FromBody] Transaction transaction)
{
if (transaction == null)
{
return(BadRequest());
}
_context.Transactions.Add(transaction);
_context.SaveChanges();
return(CreatedAtRoute("Transaction", new { id = transaction.Id }, transaction));
}
public TransactionController(TransactionDbContext context)
{
_context = context;
if (!_context.Transactions.Any())
{
Random r = new Random();
for (int i = 0; i < 10; i++)
{
Transaction t = new Transaction();
t.Amount = r.NextDouble();
Address a = new Address {
Line1 = String.Format("{0}{0}{0} Home Lame", r.Next(10), r.Next(10), r.Next(10)), City = "Dallas", State = State.TX, ZipCode = "7526" + r.Next(10)
};
t.Payee = new Person {
FirstName = "Payer" + i, LastName = "McPayerson", EmailAddress = "*****@*****.**", PhoneNumber = "(111) 111-1111", HomeAddress = a
};
t.Payer = new Person {
FirstName = "Apayee" + i, LastName = "Payeeson", EmailAddress = "*****@*****.**", PhoneNumber = "(222) 151-1213", HomeAddress = a
};
_context.Addresses.Add(a);
_context.People.Add(t.Payee);
_context.People.Add(t.Payer);
_context.Transactions.Add(t);
}
_context.SaveChanges();
}
}
private void PopulateDatabase()
{
_dbContext.Transaction.Add(new Transaction()
{
TransactionId = "1",
Amount = 10,
Currency = "USD",
TransactionDate = DateTime.UtcNow,
Status = TransactionStatus.A
});
_dbContext.SaveChanges();
}
public IActionResult Index(TransactionModel model)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var NewTransaction = new TransactionModel
{
BankName = model.BankName,
AccountNumber = model.AccountNumber
};
_context.transactions.Add(NewTransaction);
_context.SaveChanges();
throw new Exception();
var Test = new TestModel
{
AccountNumber = model.AccountNumber
};
_context.Test.Add(Test);
_context.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
}
return(View());
}
public void SaveTransaction(Transaction transaction)
{
try
{
using (var transactionCtx = new TransactionDbContext(GetConnectionString()))
{
transactionCtx.Transactions.Add(transaction);
transactionCtx.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public void InsertOrUpdateTransactions(IReadOnlyCollection <Transaction> transactions)
{
lock (_lockObject)
{
var transactionsToInsert = new List <TransactionDb>();
foreach (var transaction in transactions)
{
var existingTransaction = _transactionDbContext.Transactions.Find(transaction.Id);
if (existingTransaction == null)
{
transactionsToInsert.Add(Convert(transaction));
}
else
{
_transactionDbContext.Entry(existingTransaction).CurrentValues.SetValues(transaction);
}
}
_transactionDbContext.Transactions.AddRange(transactionsToInsert);
_transactionDbContext.SaveChanges();
}
}
public void Create(TransactionOrder order)
{
_dbSet.Add(order);
_context.SaveChanges();
}
public int Complete()
{
return(_context.SaveChanges());
}
public IActionResult AddTransaction(Transaction transaction, string drpdowntype)
{
ViewBag.Showlist = false;
string Typevalue = "";
string totalBalance = "";
if (HttpContext.Request.Query["accno"].ToString() != "")
{
string AccountNumber = HttpContext.Request.Query["accno"].ToString();
ViewBag.lblAccountNumber = AccountNumber;
if (transaction.amount != null)
{
if (drpdowntype == "Deposit")
{
Typevalue = "Credit";
}
else if (drpdowntype == "Withdrawal")
{
Typevalue = "Debit";
}
else if (drpdowntype == "InterestPaid")
{
Typevalue = "Debit";
}
else
{
if (transaction.transactionType == "Credit")
{
Typevalue = "Credit";
}
else
{
Typevalue = "Debit";
}
}
if (ModelState.IsValid)
{
Transaction transactionData = new Transaction();
transactionData.accountNumber = AccountNumber;
transactionData.description = transaction.description;
transactionData.modified_date = DateTime.Now;
transactionData.transaction_date = DateTime.Now;
transactionData.amount = transaction.amount;
transactionData.transactionType = Typevalue;
totalBalance = getTotalBalance(AccountNumber).ToString();
if (Typevalue == "Debit")
{
transactionData.balance = (Convert.ToDecimal(totalBalance) - (transaction.amount));
}
else
{
transactionData.balance = (Convert.ToDecimal(totalBalance) + (transaction.amount));
}
context.transactions.Add(transactionData);
context.SaveChanges();
return(RedirectToAction("Viewtransaction", "transaction", new { accno = AccountNumber }));
}
}
}
return(View());
}
private void SaveChanges()
{
_context.SaveChanges();
}
