/// <summary>
/// Get a Shop
/// </summary>
/// <param name="id"></param>
/// <returns>
/// Return Shop if found, else null
/// </returns>
public Shop GetShop(int id)
{
Shop shop = null;
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ConnectionString))
{
conn.Open();
var cmd = new SqlCommand("SELECT * FROM Shop WHERE shopId = @ShopId", conn);
cmd.Parameters.AddWithValue("ShopId", id);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
// Build the Shop object
shop = ObjectBuilder.CreateShop(reader);
}
}
return(shop);
}
/// <summary>
/// Get all Shops by a Chain id
/// </summary>
/// <returns>
/// List of Shop
/// </returns>
public List <Shop> GetAllShopsByChainId(int chainId)
{
var shops = new List <Shop>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ConnectionString))
{
conn.Open();
var cmd = new SqlCommand("SELECT * FROM Shop WHERE shopChainId=@ChainId", conn);
cmd.Parameters.AddWithValue("ChainId", chainId);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
// build the Shop object
var shop = ObjectBuilder.CreateShop(reader);
// Add it to the list
shops.Add(shop);
}
}
return(shops);
}
