private void AddDocumentRowButton_Click(object sender, EventArgs e)
{
double quantity = double.Parse(quantityET.Text);
var productID = productTreeListLookUpEdit.EditValue.ToString();
var lotID = lotTreeListLookUpEdit.EditValue.ToString();
using (var db = new WereDesktopEntities())
{
var lots = db.Lot.Where(l => l.ID == lotID).ToList();
foreach (Lot lot in lots)
{
var products = db.Product.Where(p => p.ID == productID).ToList();
foreach (Product product in products)
{
if (lot.ID.Equals(lotID))
{
quantity = Convert.ToDouble(quantityET.Text);
}
DocumentRowCart dr = new DocumentRowCart();
Guid id = Guid.NewGuid();
dr.ID = id.ToString();
dr.ProductID = productID;
dr.ProductName = product.Name;
dr.LotID = lotID;
dr.LotNumber = lot.LotNumber;
dr.Quantity = quantity;
dr.Sum = Convert.ToDecimal(quantity) * lot.Product.Price;
var lot1 = lotTreeListLookUpEdit.GetSelectedDataRow() as Lot;
db.SaveChanges();
lot.Quantity = lot.Quantity - quantity;
db.Lot.AddOrUpdate(lot);
db.SaveChanges();
documentRowsList.Add(dr);
this.Close();
}
}
}
}
private void reportButton_Click(object sender, EventArgs e)
{
var selected = SelectedDocument;
List <DocumentRowCart> list = new List <DocumentRowCart>();
using (var db = new WereDesktopEntities())
{
foreach (DocumentRow dr in db.DocumentRow.Where(dr => dr.DocumentID == selected.ID).ToList())
{
DocumentRowCart cardRow = new DocumentRowCart();
cardRow.ID = dr.ID;
cardRow.ProductID = dr.ProductID;
cardRow.ProductName = dr.Product.Name;
cardRow.LotID = dr.LotID;
cardRow.LotNumber = dr.Lot.LotNumber;
cardRow.Quantity = dr.Quantity;
cardRow.Sum = dr.Sum;
list.Add(cardRow);
}
}
XtraReportDocument.ShowPreview(selected, list);
}
