private void MigrateProductInventory(string bvin)
{
wl(" - Migrating Inventory...");
data.bvc2004Entities db = new data.bvc2004Entities(EFConnString(settings.SourceConnectionString()));
Api proxy = GetBV6Proxy();
var itemMain = db.bvc_Product.Where(y => y.ID == bvin).FirstOrDefault();
if (itemMain == null) return;
var old = itemMain.bvc_ProductInventory.FirstOrDefault();
if (old == null) return;
ProductInventoryDTO inv = new ProductInventoryDTO();
inv.LowStockPoint = 0;
inv.ProductBvin = bvin;
inv.QuantityOnHand = old.Qty;
inv.QuantityReserved = 0;
var res = proxy.ProductInventoryCreate(inv);
if (res != null)
{
if (res.Errors.Count > 0)
{
DumpErrors(res.Errors);
wl("FAILED");
}
}
else
{
wl("FAILED! EXCEPTION!");
}
}
private void MigrateProductInventory(string bvin)
{
wl(" - Migrating Inventory...");
data.BV53Entities db = new data.BV53Entities(EFConnString(settings.SourceConnectionString()));
Api proxy = GetBV6Proxy();
var old = db.bvc_ProductInventory.Where(y => y.ProductBvin == bvin).FirstOrDefault();
if (old == null) return;
ProductInventoryDTO inv = new ProductInventoryDTO();
inv.LowStockPoint = (int)(old.ReorderLevel ?? 0);
inv.ProductBvin = bvin;
inv.QuantityOnHand = (int)((old.QuantityAvailableForSale ?? 0) + old.QuantityReserved);
inv.QuantityReserved = (int)old.QuantityReserved;
var res = proxy.ProductInventoryCreate(inv);
if (res != null)
{
if (res.Errors.Count > 0)
{
DumpErrors(res.Errors);
wl("FAILED");
}
}
else
{
wl("FAILED! EXCEPTION!");
}
}
//DTO
public ProductInventoryDTO ToDto()
{
ProductInventoryDTO dto = new ProductInventoryDTO();
dto.Bvin = this.Bvin;
dto.LastUpdated = this.LastUpdated;
dto.LowStockPoint = this.LowStockPoint;
dto.ProductBvin = this.ProductBvin;
dto.QuantityOnHand = this.QuantityOnHand;
dto.QuantityReserved = this.QuantityReserved;
dto.VariantId = this.VariantId;
return dto;
}
public void FromDto(ProductInventoryDTO dto)
{
if (dto == null) return;
this.Bvin = dto.Bvin;
this.LastUpdated = dto.LastUpdated;
this.LowStockPoint = dto.LowStockPoint;
this.ProductBvin = dto.ProductBvin;
this.QuantityOnHand = dto.QuantityOnHand;
this.QuantityReserved = dto.QuantityReserved;
this.VariantId = dto.VariantId;
}
public ApiResponse<ProductInventoryDTO> ProductInventoryUpdate(ProductInventoryDTO item)
{
ApiResponse<ProductInventoryDTO> result = new ApiResponse<ProductInventoryDTO>();
result = RestHelper.PostRequest<ApiResponse<ProductInventoryDTO>>(this.fullApiUri + "productinventory/" + Enc(item.Bvin) + "?key=" + Enc(key), MerchantTribe.Web.Json.ObjectToJson(item));
return result;
}
