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);
}
