public async Task <IActionResult> GetProducts()
{
using (var ctx = new AdventureWorksLT2017Context())
{
var categories = ctx.Product.ToList();
return(Ok(categories));
}
}
public async Task <IActionResult> GetAveragePricePerCategory()
{
using (var ctx = new AdventureWorksLT2017Context())
{
var res = ctx.AveragePriceCategories.FromSqlRaw("select pc.Name, avg(p.ListPrice) as avg from SalesLT.Product p join SalesLT.ProductCategory pc on p.ProductCategoryID = pc.ProductCategoryID group by pc.ProductCategoryID, pc.Name order by avg")
.ToList();
return(Ok(res));
}
}
public async Task <IActionResult> GetProductsInCategory(int CategoryId)
{
using (var ctx = new AdventureWorksLT2017Context())
{
return(Ok(
ctx.Product.Where(p => p.ProductCategory.ProductCategoryId == CategoryId).ToList()
));
}
}
public async Task<IActionResult> GetCustomerById(int CustomerId)
{
using (var ctx = new AdventureWorksLT2017Context())
{
var res = from c in ctx.Customer
where c.CustomerId == CustomerId
select c;
return Ok(res);
}
}
public async Task<IActionResult> GetCustomers()
{
using (var ctx = new AdventureWorksLT2017Context())
{
var result = from c in ctx.Customer
select c;
return Ok(result.ToList());
}
}
public async Task<IActionResult> SearchCustomerByName(string Name)
{
using (var ctx = new AdventureWorksLT2017Context())
{
var res = from c in ctx.Customer
where c.FirstName.Contains(Name)
select c;
return Ok(res.ToList());
}
}
public async Task <IActionResult> GetCategories()
{
using (var ctx = new AdventureWorksLT2017Context())
{
var categories = ctx.ProductCategory
.Where(p => p.ParentProductCategoryId != null)
.Select(p => new { p.ProductCategoryId, p.Name, Count = p.Product.Count })
.ToList();
return(Ok(categories));
}
}
public async Task <IActionResult> GetProductById(int ProductId)
{
using (var ctx = new AdventureWorksLT2017Context())
{
var p = ctx.Product.Find(ProductId);
if (p == null)
{
return(NotFound(ProductId));
}
else
{
return(Ok(p));
}
}
}
public BikesController(AdventureWorksLT2017Context context)
{
db = context;
}
public MoviesController(AdventureWorksLT2017Context context)
{
_context = context;
}
