public ShoppingList Create(ShoppingList source) { User me = CurrentUser.retrieve (); ShoppingList actual = null; SqlConnection connection = ConnectionFactory.GetConnection (); SqlCommand command = new SqlCommand (QUERY_CREATE, connection); command.Parameters.AddWithValue ("@UserId", me.Id); command.Parameters.AddWithValue ("@Date", DateTime.Now); command.Parameters.AddWithValue ("@Name", source.Name); command.Parameters.AddWithValue ("@Notes", source.Notes == null ? "": source.Notes); command.Parameters.AddWithValue ("@Done", false); try { connection.Open (); int id = (int) command.ExecuteScalar (); actual = GetById (id); } finally { connection.Close (); } return actual; }
public List<ShoppingListItem> GetByShoppingList(ShoppingList list) { return GetByShoppingList (list.Id); }
private ShoppingList ReadShoppingList(SqlDataReader reader) { ShoppingList list = new ShoppingList (); list.Id = (int) reader["Id"]; list.Name = reader["Name"].ToString (); list.Date = (DateTime) reader["Date"]; list.Notes = reader["Notes"].ToString (); list.Done = false; return list; }
public ShoppingList Update(int id, ShoppingList source) { User me = CurrentUser.retrieve (); ShoppingList original = GetById (id); SqlConnection connection = ConnectionFactory.GetConnection (); SqlCommand command = new SqlCommand (QUERY_UPDATE, connection); command.Parameters.AddWithValue ("@UserId", me.Id); command.Parameters.AddWithValue ("@Date", source.Date == null ? original.Date : source.Date); command.Parameters.AddWithValue ("@Name", source.Name == null ? original.Name : source.Name); command.Parameters.AddWithValue ("@Notes", source.Notes == null ? original.Notes : source.Notes); try { connection.Open (); command.ExecuteScalar (); } finally { connection.Close (); } return GetById (original.Id); }