public bool UpdatePickedProduct(List <UpdateProductModel> model) { bool result = false; try { if (model.Count > 0) { using (DropshipDataEntities datacontext = new DropshipDataEntities()) { foreach (UpdateProductModel item in model) { Product dbProduct = datacontext.Products.Where(m => m.OriginalProductID == item.SKU).FirstOrDefault(); if (dbProduct != null) { PickedProduct dbPickedProduct = datacontext.PickedProducts.Where(p => p.SKU == item.SKU).FirstOrDefault(); if (dbPickedProduct != null) { long existingInventory = dbPickedProduct.UpdatedInventory.Value > 0 ? dbPickedProduct.UpdatedInventory.Value : 0; dbPickedProduct.UpdatedInventory = Convert.ToInt32(item.PickedInventory); dbPickedProduct.UpdatedPrice = Convert.ToInt32(item.UpdatedPrice); dbPickedProduct.UpdatedBy = 1; dbPickedProduct.UpdatedDate = DateTime.Now; datacontext.SaveChanges(); dbProduct.Inventory = Convert.ToString(Convert.ToInt32(dbProduct.Inventory) - (dbPickedProduct.UpdatedInventory - existingInventory)); datacontext.SaveChanges(); result = true; } else { PickedProduct dbPickProduct = new PickedProduct(); dbPickedProduct.ProductId = dbProduct.ProductID; dbPickedProduct.SKU = dbProduct.OriginalProductID; dbPickedProduct.UpdatedPrice = Convert.ToInt16(item.UpdatedPrice); dbPickedProduct.UpdatedInventory = Convert.ToInt16(item.PickedInventory); dbPickedProduct.CreatedBy = 1; dbPickedProduct.CreatedDate = DateTime.Now; datacontext.PickedProducts.Add(dbPickedProduct); datacontext.SaveChanges(); long remainInventory = Convert.ToInt32(dbProduct.Inventory) - dbPickedProduct.UpdatedInventory.Value; if (remainInventory > 0) { dbProduct.Inventory = Convert.ToString(remainInventory); } datacontext.SaveChanges(); } result = true; //string productSKU = SyncWithAliExpress(dbProduct); } } } } } catch (Exception) { result = false; } return(result); }
public void Init(int ID, string WPT, IRole uvo, SummonVO svo) { PickedProduct = ProductFactory.Create(ID, WPT); textBox1.Text = PickedProduct.GetName(); this.UVO = uvo; this.SVO = svo; }
private void button1_Click(object sender, EventArgs e) { WPName wp = new WPName(true, UVO, WPTYPE.WPNAMELIST, false); wp.ShowDialog(); if (wp.PickedID == 0) { return; } PickedProduct = ProductFactory.Create(wp.PickedID, wp.PickedType); textBox1.Text = PickedProduct.GetName(); }
public ProductViewModel AddUpdatedValues(ProductViewModel productModel) { if (productModel != null) { using (DropshipDataEntities datacontext = new DropshipDataEntities()) { PickedProduct dbPickedProduct = datacontext.PickedProducts.Where(m => m.SKU == productModel.OriginalProductID).FirstOrDefault(); if (dbPickedProduct != null) { productModel.UpdatedInvetory = dbPickedProduct.UpdatedInventory.Value; productModel.UpdatedPrice = dbPickedProduct.UpdatedPrice.Value; } else { productModel.UpdatedInvetory = 0; productModel.UpdatedPrice = 0; } } } return(productModel); }