public static int AddUpdateProduct(product ob) { int _Productid = 0; using (InventoryEntities db = new InventoryEntities()) { if (ob.id > 0) { product temp = db.products.Where(u => u.id == ob.id).FirstOrDefault(); if (temp != null) { temp.id = ob.id; temp.product_name = ob.product_name; temp.category = ob.category; temp.image_url = ob.image_url; temp.brand = ob.brand; temp.sub_category = ob.sub_category; temp.sell_price = ob.sell_price; temp.cost_price = ob.cost_price; temp.weight = ob.weight; temp.status = ob.status; temp.Stock = ob.Stock; } } else { db.products.Add(ob); } int x = db.SaveChanges(); if (x > 0) { _Productid = ob.id; } } return _Productid; }
public static int AddUpdateProduct(product ob) { return ProductProvider.AddUpdateProduct(ob); }
public void SaveProduct(object parameter) { try { path = InventoryHelper.GetSaveFilePath() + "\\" + ProductName + System.IO.Path.GetExtension(SelectedPath); if (SelectedPath != InventoryHelper.ImageNA) { worker.DoWork += worker_DoWork; worker.RunWorkerCompleted += worker_RunWorkerCompleted; worker.RunWorkerAsync(); } product temp = new product(); temp.id = ProductId; temp.product_name = ProductName.Trim(); if (!ProductServices.CheckProductNameAvailable(temp.product_name) && (ProductServices.GetProduct(temp.id).product_name != temp.product_name)) { InventoryHelper.SimpleAlert("Warning", "Product Name is Already taken"); return; } temp.brand = Brand == null ? "" : Brand; temp.sub_category = SelectedSubCategory.id; temp.category = SelectedCategory.id; temp.sell_price = SellingPrice; temp.cost_price = CostPrice; temp.image_url = SelectedPath == InventoryHelper.ImageNA ? "" : path; temp.weight = Weight == null ? "" : Weight; temp.status = true; ProductId = ProductServices.AddUpdateProduct(temp); if (ProductId > 0) { //MessageBox.Show("Product Edited"); InventoryHelper.SuccessAlert("Success", "Product Edited"); } Close = false; } catch (Exception ex) { MessageBox.Show("Product Entry Fails:" + ex.ToString()); //InventoryHelper.SimpleAlert("Warning", "Product Entry Fails:" + ex.ToString()); } }
public void SaveProduct(object parameter) { try { string path = InventoryHelper.GetSaveFilePath() + "\\" + ProductName + System.IO.Path.GetExtension(SelectedPath); if (SelectedPath != InventoryHelper.ImageNA) { System.IO.File.Copy(SelectedPath, path, true); } product temp = new product(); temp.product_name = ProductName.Trim(); if (!ProductServices.CheckProductNameAvailable(temp.product_name)) { InventoryHelper.SimpleAlert("Warning", "Product Name is Already taken"); return; } temp.brand = Brand == null ? "" : Brand; temp.sub_category = SelectedSubCategory.id; temp.category = SelectedCategory.id; temp.sell_price = SellingPrice; temp.cost_price = CostPrice; temp.image_url = SelectedPath == InventoryHelper.ImageNA ? "" : path; temp.weight = Weight == null ? "" : Weight; temp.Stock = 0; temp.status = true; int productId = ProductServices.AddUpdateProduct(temp); if (productId > 0) { // MessageBox.Show("Product Added"); InventoryHelper.SuccessAlert("Success", "Product Added"); Brand = ""; SellingPrice = 0; CostPrice = 0; Weight = ""; SelectedPath = InventoryHelper.ImageNA; ProductName = ""; SelectedSubCategory = null; SelectedCategory = null; } } catch (Exception ex) { MessageBox.Show("Product Entry Fails:" + ex.ToString()); } }
protected ProductSellingEntity CoverttoProductSellingEntity(product ob) { ProductSellingEntity tempproduct = new ProductSellingEntity(); tempproduct.ProductId = ob.id; tempproduct.ProductName = ob.product_name; tempproduct.Quantity = Quantity; tempproduct.SellingPrice = ob.sell_price; tempproduct.Amount = tempproduct.SellingPrice * Quantity; return tempproduct; }