public DataTable FilteredOrders(string category)
{
ProductDataHandler productdate = new ProductDataHandler();
FilteredData = productdate.FilterOrders("Products", category);
return(FilteredData);
}
//Method of reading products accessed from the data access layer
public DataTable GetProducts()
{
ProductDataHandler productdata = new ProductDataHandler();
dataT = productdata.GetProducts("Products");
return(dataT);
}
public List <Product> ReadingProducts()
{
List <Product> ReadProducts = new List <Product>();
DataSet GetClients = new ProductDataHandler().ReadProducts("Products");
foreach (DataRow item in GetClients.Tables["Products"].Rows)
{
ReadProducts.Add(new Product(item["ProductID"].ToString(), item["CategoryID"].ToString(), item["ProductName"].ToString(), int.Parse(item["AvailableQuantity"].ToString()), Double.Parse(item["Price"].ToString()), item["Description"].ToString(), item["Manufacturer"].ToString(), item["Model"].ToString(), item["SerialNumber"].ToString()));
}
return(ReadProducts);
}
public Product Post([FromBody] Product pProduct)
{
Product p = pProduct;
try {
p = new ProductDataHandler().SaveProduct(pProduct);
}
catch (Exception ex)
{
return(null);
}
return(p);
}
public Product Get(int id)
{
Product p = new ProductDataHandler().GetProducts().Where(x => x.ProductId == id).FirstOrDefault();
return(p == null? new Product(): p);
}