Files

program.cs

using sqlapp.Services;
 
  
 
var builder = WebApplication.CreateBuilder(args);
 
  
 
builder.Services.AddTransient<IProductService, ProductService>();
 
  
 
builder.Services.AddRazorPages();
 
  
 
var app = builder.Build();
 
  
 
// Configure the HTTP request pipeline.
 
if (!app.Environment.IsDevelopment())
 
{
 
    app.UseExceptionHandler("/Error");
 
    // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
 
    app.UseHsts();
 
}
 
  
 
app.UseHttpsRedirection();
 
app.UseStaticFiles();
 
  
 
app.UseRouting();
 
  
 
app.UseAuthorization();
 
  
 
app.MapRazorPages();
 
  
 
app.Run();
 

product.service.cs

using sqlapp.Models;
 
using System.Data.SqlClient;
 
using System.Text.Json;
 
  
 
namespace sqlapp.Services
 
{
 
  
 
    // This service will interact with our Product data in the SQL database
 
    public class ProductService : IProductService
 
    {
 
  
 
        public async Task <List<Product>> GetProducts()
 
        {
 
            String FunctionURL = "https://newapp200030.azurewebsites.net/api/GetProducts?code=RVVlGJpJ4paRmO6z6GStMbNZPPMeUDaHg6UzfFi/xrOMSEDMRKzNLg==";
 
  
 
            using (HttpClient _client = new HttpClient())
 
            {
 
                HttpResponseMessage _response = await _client.GetAsync(FunctionURL);
 
                string _content = await _response.Content.ReadAsStringAsync();
 
                return JsonSerializer.Deserialize<List<Product>>(_content);
 
            }
 
  
 
            }
 
    }
 
}