protected static void AddTodoItem( NpgsqlConnection conn, Guid key, string description, bool isComplete, DateTime timeCreated) { TodoStorageCommands.AddNewItem(conn, key, description, isComplete, timeCreated).ExecuteNonQuery(); }
protected static List <TodoItem> GetTodoList(NpgsqlConnection conn) { var retVal = new List <TodoItem>(); using (var reader = TodoStorageCommands.GetAllTodoItems(conn).ExecuteReader()) { while (reader.Read()) { var item = new TodoItem { Key = reader.GetGuid(reader.GetOrdinal(PgEnums.Tables.TodoItems.key_uid.ToString())), Description = reader.GetString(reader.GetOrdinal(PgEnums.Tables.TodoItems.description.ToString())), IsComplete = reader.GetBoolean(reader.GetOrdinal(PgEnums.Tables.TodoItems.is_complete.ToString())), TimeCreated = reader.GetDateTime(reader.GetOrdinal(PgEnums.Tables.TodoItems.time_created.ToString())) }; retVal.Add(item); } } return(retVal); }