public Object List()
{
List <OrderWithUserName> orders = new List <OrderWithUserName>();
try
{
using (var db = new PCPartsDB())
{
var aux = db.Orders.ToList();
foreach (var item in aux)
{
string user = db.Users.Where(u => u.UserID == item.UserFK).Select(n => n.Name).FirstOrDefault();
OrderWithUserName order = new OrderWithUserName
{
Order = item,
UserName = user
};
orders.Add(order);
}
}
}
catch (Exception) { return(null); }
if (orders == null)
{
return(new { result = false, info = "Erro ao retornar todas as orders." });
}
return(new { result = true, data = orders });
}
public Object Type(int productType)
{
Object products;
try
{
using (var db = new PCPartsDB())
{ products = db.Products.Where(x => x.ProductTypeFK == productType).ToList(); }
}
catch (Exception) { return(null); }
if (products == null)
{
return(new { result = false, info = "Erro ao retornar os produtos desse tipo." });
}
return(new { result = true, data = products });
}
public Object Details(int productid)
{
Object product;
try
{
using (var db = new PCPartsDB())
{ product = db.Products.Find(productid); }
}
catch (Exception) { return(null); }
if (product == null)
{
return(new { result = false, info = "Erro ao retornar os detalhes do produto." });
}
return(new { result = true, data = product });
}
public Object List()
{
Object products;
try
{
using (var db = new PCPartsDB())
{ products = db.Products.ToList(); }
}
catch (Exception) { return(null); }
if (products == null)
{
return(new { result = false, info = "Erro ao retornar a lista de produtos." });
}
return(new { result = true, data = products });
}
public Object Details(int userid)
{
Object user;
try
{
using (var db = new PCPartsDB())
{ user = db.Users.Find(userid); }
}
catch (Exception) { return(null); }
if (user == null)
{
return(new { result = false, info = "Utilizador não encontrado." });
}
return(new { result = true, data = user });
}
public Object Recent()
{
Object products;
try
{
using (var db = new PCPartsDB())
{
products = db.Products.OrderByDescending(x => x.ProductID).Take(3).ToList();
}
}
catch (Exception) { return(null); }
if (products == null)
{
return(new { result = false, info = "Erro ao retornar os produtos mais recentes." });
}
return(new { result = true, data = products });
}
public Object Type()
{
Object types;
try
{
using (var db = new PCPartsDB())
{
types = db.ProductType.ToList();
}
}
catch (Exception) { return(null); }
if (types == null)
{
return(new { result = false, info = "Erro ao retornar os tipos de produtos." });
}
return(new { result = true, data = types });
}
public Object Details(int orderid)
{
List <ProductsInOrder> products = new List <ProductsInOrder>();
OrderWithAllDetails order = null;
{
try
{
using (var db = new PCPartsDB())
{
//Information about Order
var auxOrder = db.Orders.Find(orderid);
//Info ab
var productOrder = db.Product_Order.Where(po => po.OrderFK == auxOrder.OrderID).ToList();
foreach (var item in productOrder)
{
var product = db.Products.Where(p => p.ProductID == item.ProductFK).FirstOrDefault();
string supplier = db.Suppliers.Where(s => s.SupplierID == product.SupplierFK).Select(s => s.Name).FirstOrDefault();
ProductsInOrder prd = new ProductsInOrder
{
Product = product,
Quantity = item.Quantity,
SupplierName = supplier
};
products.Add(prd);
}
order = new OrderWithAllDetails(products, auxOrder);
}
}
catch (Exception) { return(null); }
if (order == null)
{
return(new { result = false, info = "Erro ao retornar os detalhes da order." });
}
return(new { result = true, data = order });
}
}
