protected void Page_Load(object sender, EventArgs e)
{
using (CommerceEntities db = new CommerceEntities())
{
try
{
var query = (from ProductOrders in db.OrderDetails
join SelectedProducts in db.Products on ProductOrders.ProductID equals SelectedProducts.ProductID
group ProductOrders by new
{
ProductId = SelectedProducts.ProductID,
ModelName = SelectedProducts.ModelName
} into grp
select new
{
ModelName = grp.Key.ModelName,
ProductId = grp.Key.ProductId,
Quantity = grp.Sum(o => o.Quantity)
} into orderdgrp where orderdgrp.Quantity > 0 orderby orderdgrp.Quantity descending select orderdgrp).Take(5);
RepeaterItemsList.DataSource = query;
RepeaterItemsList.DataBind();
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Load Popular Items - " + exp.Message.ToString(), exp);
}
}
}
//------------------------------------------------------------------------------------------------------------------------------------------+
private void WriteAlsoPurchased(int currentProduct)
{
using (CommerceEntities db = new CommerceEntities())
{
try
{
var v = db.SelectPurchasedWithProducts(currentProduct);
RepeaterItemsList.DataSource = v;
RepeaterItemsList.DataBind();
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Write Also Purchased - " + exp.Message.ToString(), exp);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (DataContext db = new DataContext())
{
try
{
var query = db.Urun.Where(x => x.CokSatan == true).Take(5);
RepeaterItemsList.DataSource = query.ToList();
RepeaterItemsList.DataBind();
}
catch (Exception exp)
{
throw new Exception("ERROR: Popüler ürünler yüklenemedi - " + exp.Message.ToString(), exp);
}
}
}
