public IEnumerable <ProdDetails> getInfo()
{
GetOrders_Result oj = new GetOrders_Result();
var result = db.Database.SqlQuery <ProdDetails>("SELECT ProdId,ProdName,ProdDesc,ProdPrice,Image FROM dbo.Product b, dbo.ProdGallery g WHERE b.ProdId = g.GalleryId");
return(result);
}
public IEnumerable <OrderDetails> getInfo()
{
GetOrders_Result oj = new GetOrders_Result();
var result = db.Database.SqlQuery <OrderDetails>("SELECT z.OrderId ,ProdName ,ProdDesc ,totalPrice ,AddressOrder ,OrderStatus, DeliveryStatus FROM dbo.[Order] z, dbo.Product b, dbo.OrderCopy o, dbo.Customer g WHERE z.OrderId = o.orderid AND b.ProdId = o.product_id AND g.Id = z.Id");
return(result);
}
