public List <Customer> FindAllCustomers()
{
string query = "SELECT ID,ALIAS,FIRSTNAME, LASTNAME FROM CUSTOMER";
List <Customer> customers = new List <Customer>();
using (SQLiteConnection dataConnection = SqliteDBHelper.GetConnection(this.databasePath))
{
using (SQLiteCommand dataCommand = dataConnection.CreateCommand())
{
var result = SqliteDBHelper.GetResult(dataCommand, query);
foreach (DataRow dataRow in result.Tables[0].Rows)
{
customers.Add(new Customer()
{
Id = Convert.ToInt32(dataRow["Id"]),
Alias = dataRow.GetString("Alias"),
FirstName = dataRow.GetString("FirstName")
}
);
}
}
dataConnection.Close();
}
return(customers);
}
private int GetNextId(SQLiteCommand sqliteDBCommand, string tableName, string keyColumn = "Id")
{
string query = $"SELECT MAX({keyColumn}) FROM {tableName}";
var result = SqliteDBHelper.GetResult(sqliteDBCommand, query);
int lastId = 0;
if (result.Tables[0].Rows.Count != 0)
{
var value = result.Tables[0].Rows[0][0];
lastId = value == DBNull.Value ? 0 : Convert.ToInt32(value);
}
return(++lastId);
}