public Store Create(Store source) { Store actual = null; SqlConnection connection = ConnectionFactory.GetConnection (); SqlCommand command = new SqlCommand (QUERY_CREATE, connection); command.Parameters.AddWithValue ("@Franchise", source.Franchise); command.Parameters.AddWithValue ("@Name", source.Name); command.Parameters.AddWithValue ("@Address", source.Address); command.Parameters.AddWithValue ("@Longitude", source.Longitude); command.Parameters.AddWithValue ("@Latitude", source.Latitude); try { connection.Open (); int id = (int) command.ExecuteScalar (); actual = GetById (id); } finally { connection.Close (); } return actual; }
private Retail ReadRetail(SqlDataReader reader) { Retail retail = new Retail (); Item item = new Item (); Store store = new Store (); item.Id = (int) reader["ItemId"]; item.Name = reader["ItemName"].ToString (); item.Category = reader["Category"].ToString (); item.Brand = reader["Brand"].ToString (); item.Description = reader["Description"].ToString (); store.Id = (int) reader["StoreId"]; store.Name = reader["StoreName"].ToString (); store.Franchise = reader["Franchise"].ToString (); store.Address = reader["Address"].ToString (); store.Longitude = (double) reader["Longitude"]; store.Latitude = (double) reader["Latitude"]; retail.Id = (int) reader["Id"]; retail.Store = store; retail.Item = item; retail.Price = (decimal) reader["Price"]; retail.Position = (int) reader["Position"]; return retail; }
private ShoppingListItem ReadShoppingList(SqlDataReader reader) { ShoppingListItem listItem = new ShoppingListItem (); Item item = new Item (); Store store = new Store (); item.Id = (int) reader["ItemId"]; item.Name = reader["ItemName"].ToString (); item.Category = reader["Category"].ToString (); item.Brand = reader["Brand"].ToString (); item.Description = reader["Description"].ToString (); store.Id = (int) reader["StoreId"]; store.Name = reader["StoreName"].ToString (); store.Franchise = reader["Franchise"].ToString (); store.Address = reader["Address"].ToString (); listItem.Id = (int) reader["Id"]; listItem.Store = store; listItem.Item = item; listItem.Amount = (int) reader["Amount"]; listItem.Price = (decimal) reader["Price"]; listItem.Position = (int) reader["Position"]; listItem.Note = reader["Note"].ToString (); listItem.Checked = ((int) reader["Checked"]) < 1; return listItem; }
private Store ReadStore(SqlDataReader reader) { Store store = new Store (); store.Id = (int) reader["Id"]; store.Franchise = reader["Franchise"].ToString (); store.Name = reader["Name"].ToString (); store.Address = reader["Address"].ToString (); if ( reader["Longitude"] != DBNull.Value ) { store.Longitude = (Double) reader["Longitude"]; } if ( reader["Latitude"] != DBNull.Value ) { store.Latitude = (Double) reader["Latitude"]; } return store; }