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;
}
