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)); }