public static DataTable Get()
{
string query = "SELECT * FROM " + TableName;
return(DatabaseAccesser.GetResult(query));
}
public static int GetMaxTripId()
{
string query = $"SELECT MAX({ColumnTripId}) AS max_id FROM {TableName}";
return(DatabaseAccesser.GetResult(query).Rows[0].Field <int?>("max_id") ?? 0);
}
public static void Insert(DataTable dataTable)
{
DatabaseAccesser.Insert(TableName, dataTable);
}