public IActionResult Index([FromServices] ISimpleDatabase database) { Account acc = new Account { Name = "Melinda", Balance = 100 }; db.Accounts.Add(acc); var count = db.SaveChanges(); Console.WriteLine($"{count} records saved to database"); ViewBag.Accounts = db.Accounts; ViewData["data"] = database.GetAll(); ViewData["account"] = acc.GetAccount(); string choice = (string)TempData["choice"]; decimal amount = Convert.ToInt32(TempData["amount"]); decimal balance = acc.Balance; if (choice == "withdrawn") { if (balance >= amount) { acc.Withdraw(amount); } } else if (choice == "deposited") { acc.Deposit(amount); } return(View()); }
public IActionResult Index([FromServices] ISimpleDatabase database) { ViewData["Data"] = database.GetAll(); return(View()); }
public TransactionStorage(ISimpleDatabase simpleDatabase) { _simpleDatabase = simpleDatabase; ResetCounters(); }
static async Task Test(ISimpleDatabase Database, ITestSchema TestSchema) { List <IResultRow> RowList; IInsertResult InsertResult; //IDeleteResult DeleteResult; IJoinQueryResult JoinQueryResult; //IUpdateResult UpdateResult; //ISingleQueryResult SelectResult; int isAsync = 1; if (isAsync == 0) { InsertResult = Database.Run(new InsertContext(TestSchema.Test0, new List <IColumnValuePair>() { new ColumnValuePair <Guid>(TestSchema.Test0_Guid, guidKey0) })); } else { InsertResult = await Database.RunAsync(new InsertContext(TestSchema.Test0, new List <IColumnValuePair>() { new ColumnValuePair <Guid>(TestSchema.Test0_Guid, guidKey0) })); } Thread.Sleep(5000); if (isAsync == 0) { InsertResult = Database.Run(new InsertContext(TestSchema.Test0, new List <IColumnValuePair>() { new ColumnValuePair <int>(TestSchema.Test0_Int, 1) })); } else { InsertResult = await Database.RunAsync(new InsertContext(TestSchema.Test0, new List <IColumnValuePair>() { new ColumnValuePair <int>(TestSchema.Test0_Int, 1) })); } Thread.Sleep(5000); ((SimpleDatabase)Database).IgnoreErrorCode = 1062; if (isAsync == 0) { InsertResult = Database.Run(new InsertContext(TestSchema.Test0, new List <IColumnValuePair>() { new ColumnValuePair <Guid>(TestSchema.Test0_Guid, guidKey0) })); } else { InsertResult = await Database.RunAsync(new InsertContext(TestSchema.Test0, new List <IColumnValuePair>() { new ColumnValuePair <Guid>(TestSchema.Test0_Guid, guidKey0) })); } Thread.Sleep(5000); if (isAsync == 0) { InsertResult = Database.Run(new InsertContext(TestSchema.Test0, new List <IColumnValuePair>() { new ColumnValuePair <Guid>(TestSchema.Test0_Guid, guidKey1), new ColumnValuePair <int>(TestSchema.Test0_Int, 1) })); } else { InsertResult = await Database.RunAsync(new InsertContext(TestSchema.Test0, new List <IColumnValuePair>() { new ColumnValuePair <Guid>(TestSchema.Test0_Guid, guidKey1), new ColumnValuePair <int>(TestSchema.Test0_Int, 1) })); } Thread.Sleep(5000); if (isAsync == 0) { JoinQueryResult = Database.Run(new JoinQueryContext(TestSchema.Test0.All)); } else { JoinQueryResult = await Database.RunAsync(new JoinQueryContext(TestSchema.Test0.All)); } RowList = new List <IResultRow>(JoinQueryResult.RowList); if (isAsync == 0) { InsertResult = Database.Run(new InsertContext(TestSchema.Test1, new List <IColumnValuePair>() { new ColumnValuePair <string>(TestSchema.Test1_String, "row 0") })); } else { InsertResult = await Database.RunAsync(new InsertContext(TestSchema.Test1, new List <IColumnValuePair>() { new ColumnValuePair <string>(TestSchema.Test1_String, "row 0") })); } Thread.Sleep(5000); if (isAsync == 0) { InsertResult = Database.Run(new InsertContext(TestSchema.Test1, new List <IColumnValuePair>() { new ColumnValuePair <string>(TestSchema.Test1_String, "row 1") })); } else { InsertResult = await Database.RunAsync(new InsertContext(TestSchema.Test1, new List <IColumnValuePair>() { new ColumnValuePair <string>(TestSchema.Test1_String, "row 1") })); } Thread.Sleep(5000); ((SimpleDatabase)Database).IgnoreErrorCode = 1062; if (isAsync == 0) { InsertResult = Database.Run(new InsertContext(TestSchema.Test1, new List <IColumnValuePair>() { new ColumnValuePair <int>(TestSchema.Test1_Int, 1), new ColumnValuePair <string>(TestSchema.Test1_String, "row 2") })); } else { InsertResult = await Database.RunAsync(new InsertContext(TestSchema.Test1, new List <IColumnValuePair>() { new ColumnValuePair <int>(TestSchema.Test1_Int, 1), new ColumnValuePair <string>(TestSchema.Test1_String, "row 2") })); } Thread.Sleep(5000); if (isAsync == 0) { JoinQueryResult = Database.Run(new JoinQueryContext(TestSchema.Test1.All)); } else { JoinQueryResult = await Database.RunAsync(new JoinQueryContext(TestSchema.Test1.All)); } RowList = new List <IResultRow>(JoinQueryResult.RowList); }