public List <Operation> SelectOpList(TestSQLiteDB databaseObject)
{
List <Operation> opList = new List <Operation>();
string query = "SELECT * FROM Operations";
SQLiteCommand myCommand = new SQLiteCommand(query, databaseObject.myConnection);
databaseObject.OpenConnection();
using (SQLiteDataReader queryResult = myCommand.ExecuteReader())
{
if (queryResult.HasRows)
{
while (queryResult.Read())
{
Operation opNew = new Operation
{
Id = int.Parse(queryResult["ID"].ToString()),
Firstnumber = int.Parse(queryResult["FIRSTNUMBER"].ToString()),
Op = queryResult["OP"].ToString(),
Secondnumber = Convert.ToInt32(queryResult["SECONDNUMBER"]),
Result = Convert.ToInt32(queryResult["RESULT"]),
Timestamp = queryResult["TIMESTAMP"].ToString()
};
opList.Add(opNew);
}
}
}
databaseObject.CloseConnection();
return(opList);
}
public void DeleteAllOp(TestSQLiteDB databaseObject)
{
string query = "DELETE FROM Operations";
SQLiteCommand myCommand = new SQLiteCommand(query, databaseObject.myConnection);
databaseObject.OpenConnection();
myCommand.ExecuteNonQuery();
databaseObject.CloseConnection();
}
public void InsertNewOp(TestSQLiteDB databaseObject, Operation operation)
{
string query = "INSERT INTO Operations('ID', 'FIRSTNUMBER', 'OP', 'SECONDNUMBER', 'RESULT', 'TIMESTAMP') VALUES(@ID, @FIRSTNUMBER, @OP, @SECONDNUMBER, @RESULT, @TIMESTAMP)";
SQLiteCommand myCommand = new SQLiteCommand(query, databaseObject.myConnection);
databaseObject.OpenConnection();
myCommand.Parameters.AddWithValue("ID", operation.Id);
myCommand.Parameters.AddWithValue("FIRSTNUMBER", operation.Firstnumber);
myCommand.Parameters.AddWithValue("OP", operation.Op);
myCommand.Parameters.AddWithValue("SECONDNUMBER", operation.Secondnumber);
myCommand.Parameters.AddWithValue("RESULT", operation.Result);
myCommand.Parameters.AddWithValue("TIMESTAMP", operation.Timestamp);
myCommand.ExecuteNonQuery();
databaseObject.CloseConnection();
}