public ActionResult Index()
{
var Lastest_Orders = db.oc_order
.OrderByDescending(r => r.date_added)
.Take(5).ToList();
const int COMPLETE = 5;
var model = new Home_IndexViewmodel()
{
Lastest_Orders = new List <Lastest_Orders>(),
Total_Orders = db.oc_order.Count(),
Total_Customers = db.oc_customer.Count(),
Total_Sales = db.oc_order.Count(r => r.order_status_id == COMPLETE),
Total_OnlineUsers = db.oc_customer_online.Count(),
};
foreach (var order in Lastest_Orders)
{
var customer = db.oc_customer.Single(r => r.customer_id == order.customer_id);
var status = db.oc_order_status.Single(r => r.order_status_id == order.order_status_id);
model.Lastest_Orders.Add(new Models.Lastest_Orders()
{
Customer_name = customer.firstname + customer.lastname,
Status = status.name,
Date_Added = order.date_added,
Order_id = order.order_id.ToString(),
Total = (int)order.total
});
}
return(View(model));
}
public ActionResult Index()
{
var enabled = 1;
var top_4_news_products = (from product in db.oc_product
join product_description in db.oc_product_description on product.product_id equals product_description.product_id
join stock_status in db.oc_stock_status on product.stock_status_id equals stock_status.stock_status_id
where product.deleted != 1 && product.status == enabled
orderby product.date_added, product.date_available, product.date_modified
select new Product()
{
seo_url = product_description.seo_url,
product_id = product.product_id,
date_added = product.date_added,
date_available = product.date_available,
date_modified = product.date_modified,
deleted = product.deleted,
model = product.model,
quantity = product.quantity,
status = product.status,
points = product.points,
name = product_description.name,
price = product.price,
image = product.image,
stock_status = stock_status.name,
}).Take(4).ToList();
top_4_news_products.ForEach((product) =>
{
product.alternative_images = db.oc_product_image.Where(r => r.product_id == product.product_id).ToList();
});
var toplevel_categories = from category in db.oc_category
join category_description in db.oc_category_description on category.category_id equals category_description.category_id
where category.parent_id == 0
select new
{
category_description
};
var model = new Home_IndexViewmodel()
{
top_4_maybeyoulike_products = top_4_news_products.Take(4),
top_4_news_products = top_4_news_products.Take(4),
toplevel_categories = toplevel_categories.Select(r => r.category_description).ToList()
};
return(View(model));
}
