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