private void LoadExistingProducts() { using (var db = new POSApplication.Model.posdbEntities()) { string selectedCategoryName = ExistingCategoryList.GetItemText(ExistingCategoryList.SelectedItem); var query = (from p in db.products join c in db.categories on p.CategoryID equals c.CategoryID //join s in db.suppliers on p.SupplierID equals s.SupplierID where c.CategoryName == selectedCategoryName select new { ProductName = p.ProductName, ProductDescription = p.ProductDescription, Barcode = p.Barcode, ImageFile = p.ImageFileName, SupplierID = p.SupplierID }).ToList(); //ExistingProductList.Items.Clear(); int a = 0; foreach (var item in query) { if (a == 0) { var supp = (from s in db.suppliers where s.SupplierID == item.SupplierID select new { SupplierName = s.SupplierName }).SingleOrDefault(); //ExistingProductList.Text = item.ProductName; //ExistingDescriptionField.Text = item.ProductDescription; //if(supp != null) //{ // ExistingSupplierField.Text = supp.SupplierName; //} //else //{ // ExistingSupplierField.Text = "No Supplier"; //} //ExistingBarcodeField.Text = item.Barcode; //if(item.ImageFile != null) //{ // FileStream fs = new FileStream(item.ImageFile, System.IO.FileMode.Open, System.IO.FileAccess.Read); // ExistingProductImage.Image = Image.FromStream(fs); // fs.Close(); //} } //ExistingProductList.Items.Add(item.ProductName); a += 1; } } }
private void ExistingCategoryList_SelectedIndexChanged_1(object sender, EventArgs e) { var SelectedCategory = ExistingCategoryList.GetItemText(ExistingCategoryList.SelectedItem); using (var db = new POSApplication.Model.posdbEntities()) { var query = (from d in db.products join c in db.categories on d.CategoryID equals c.CategoryID where c.CategoryName == SelectedCategory select new { CategoryName = c.CategoryName, ProductName = d.ProductName }).ToList(); ExistingProductsList.Items.Clear(); foreach (var item in query) { ExistingProductsList.Items.Add(item.ProductName); } } }
private void ExistingProductsList_DoubleClick(object sender, EventArgs e) { clearFields(); using (var db = new POSApplication.Model.posdbEntities()) { var ExistingProduct = ExistingProductsList.GetItemText(ExistingProductsList.SelectedItem); selectedProductName = ExistingProduct; var query = (from d in db.products //join s in db.suppliers on //d.SupplierID equals s.SupplierID where d.ProductName == ExistingProduct select new { ProductName = d.ProductName, ProductDescription = d.ProductDescription, //SupplierName = s == null ? "No Supplier" : s.SupplierName, Barcode = d.Barcode, WarrantyYears = d.WarrantyPeriodYears, GuaranteeYears = d.GuaranteePeriodYears, ProductCode = d.ProductCode, Size = d.ProductSize, Width = d.ProductWidth, Height = d.ProductHeight, Weight = d.ProductWeight, Color = d.ProductColor, Image = d.ImageFileName }).SingleOrDefault(); var supplierQuery = (from d in db.products join s in db.suppliers on d.SupplierID equals s.SupplierID where d.ProductName == ExistingProduct select new { SupplierName = s == null ? "No Supplier" : s.SupplierName }).SingleOrDefault(); CategoryList.Text = ExistingCategoryList.GetItemText(ExistingCategoryList.SelectedItem); ProductNameField.Text = query.ProductName; ProductDescriptionField.Text = query.ProductDescription; ProductCodeField.Text = query.ProductCode; if (supplierQuery != null) { SuppliersList.Text = supplierQuery.SupplierName; } else { SuppliersList.Text = "No Supplier"; } ProductBarcodeField.Text = query.Barcode; WarrantyField.Text = query.WarrantyYears; GuaranteeField.Text = query.GuaranteeYears; SizeField.Text = query.Size; WidthField.Text = query.Width; WeightField.Text = query.Weight; HeightField.Text = query.Height; ColorField.Text = query.Color; if (query.Image != null) { try { string ImagesDirectory = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Images"); //Console.WriteLine(ImagesDirectory + "\\" + query.Image); filename = ImagesDirectory + "\\" + query.Image; FileStream fs = new FileStream(filename, System.IO.FileMode.Open, System.IO.FileAccess.Read); ProductImage.Image = Image.FromStream(fs); fs.Close(); } catch { } } } }
private void ExistingProductsList_DoubleClick(object sender, EventArgs e) { if (ExistingProductsList.SelectedItem != null) { clearFields(); using (var db = new POSApplication.Model.posdbEntities()) { var ExistingProduct = ExistingProductsList.GetItemText(ExistingProductsList.SelectedItem); int productid = getProductID(ExistingProduct); selectedProductName = ExistingProduct; DateTime lowdate = DateTime.Parse("1111/11/11"); var query = (from d in db.inventories join p in db.products on d.ProductID equals p.ProductID join c in db.categories on p.CategoryID equals c.CategoryID where d.ProductID == productid && d.UpdateDt == null orderby d.PurchasePrice descending select new { CategoryName = c.CategoryName, ProductName = p.ProductName, Barcode = p.Barcode, Quantity = d.SumQuantity, //ReorderLevel = d.ReorderValue, LastCostPrice = d.PurchasePrice, SalePrice = d.SalePrice, LastPurchaseDate = d.PurchaseDate, Imagepath = p.ImageFileName }).FirstOrDefault(); CategoryList.Text = ExistingCategoryList.GetItemText(ExistingCategoryList.SelectedItem); ProductNameField.Text = query.ProductName; BarCodeField.Text = query.Barcode; var results = (from item in db.inventories where item.ProductID == productid && item.UpdateDt == null group item by item.ProductID into g select new { totalQuantity = g.Sum(item => item.SumQuantity) }).SingleOrDefault(); //QuantityField.Text = query.Quantity.ToString(); QuantityField.Text = results.totalQuantity.ToString(); //ReOrderLevelField.Text = query.ReorderLevel.ToString(); CostPriceField.Text = query.LastCostPrice.ToString(); SalePriceField.Text = query.SalePrice.ToString(); PurchaseDateField.Text = query.LastPurchaseDate.ToString(); if (query.Imagepath != null) { try { string ImagesDirectory = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Images"); Console.WriteLine(ImagesDirectory + "\\" + query.Imagepath); FileStream fs = new FileStream(ImagesDirectory + "\\" + query.Imagepath, System.IO.FileMode.Open, System.IO.FileAccess.Read); ProductImage.Image = Image.FromStream(fs); fs.Close(); } catch { } } } } }