public SaledProductDetailForm(SaledProductForm quantityForm, Salemodel2 smodel)
{
InitializeComponent();
QuantityForm = quantityForm;
SModel = smodel;
}
public List <Salemodel2> GetSaleModels()
{
{
using (var context = DbContextCreator.Create())
{
var productNames = context.Items.ToDictionary(x => x.ItemId, x => x.Name);
var query = from p in context.Orders
where p.IsSale == true
select new
{
Order = p,
Quantity = p.Quantity,
ProductName = p.Item.Name,
ItemId = p.ItemId
};
var query2 = from x in query
group x by x.ItemId into g
select g;
var models = new List <Salemodel2>();
foreach (var @group in query2)
{
Salemodel2 model = new Salemodel2();
model.ItemId = group.Key;
model.Quantity = group.Sum(g => g.Quantity);
model.ProductName = productNames[group.Key];
models.Add(model);
}
return(models);
}
}
}
private void chartControl1_SelectedItemsChanged(object sender, DevExpress.XtraCharts.SelectedItemsChangedEventArgs e)
{
Salemodel2 selectedItem = chartControl1.SelectedItems[0] as Salemodel2;
if (selectedItem == null)
{
return;
}
SaledProductDetailForm newSaleProduct = new SaledProductDetailForm(this, selectedItem);
newSaleProduct.Show();
}
