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