public ShopifyLineItem(ShopifyProduct thisProduct, ShopifyVariant thisVariant) { Id = 0; FulfillmentService = thisVariant.FulfillmentService; FulfillmentStatus = null; Grams = thisVariant.Grams; Price = thisVariant.Price; ProductId = thisProduct.Id == null ? 0 : (int)thisProduct.Id; Quantity = thisVariant.InventoryQuantity == null ? 0 : (int) thisVariant.InventoryQuantity; RequiresShipping = thisVariant.RequiresShipping; Sku = thisVariant.Sku; Title = thisProduct.Title; VariantId = thisVariant.Id == null ? 0 : (int)thisVariant.Id; VariantTitle = thisVariant.Title; Vendor = thisProduct.Vendor; Name = thisVariant.Title; }
internal bool UpdateShopifyProductTimeStamp(ShopifyProduct item, DateTime timestamp) { if (item == null) { throw new ArgumentException("Neither arguments can be null"); } var query = String.Format( @" UPDATE ShopifyProduct SET versiondate = '{0:yyyy-MM-dd HH:mm:ss}' where id = {1} LIMIT 1;", timestamp, item.Id); var sqlCommand = new MySqlCommand(query, _dbConn); try { if (sqlCommand.ExecuteNonQuery() == 1) { return true; } Logger.ErrorFormat( "UpdateShopifyProductTimeStamp(): Couldnt update timestamp on ShopifyItem({0}).", item.Id); return false; } catch (Exception dbEx) { Logger.ErrorFormat( "UpdateShopsterProductTimeStamp(): Database exception while attempting to update shopsterProduct({0}) with timestamp ({1}). " + dbEx.Message, item.Id, timestamp); return false; } }
public bool InsertProductForUser(ConnectsterUser user, InventoryItemType shopsterProduct, ShopifyProduct shopifyProduct) { //TODO: have this take a bool to decide if shopster is master, for now true //Todo: have actual dates from Shopster API, when available. return InsertProductForUser(user, Convert.ToInt32(shopsterProduct.ItemId), (DateTime.Now.ToUniversalTime()), (int) shopifyProduct.Id, ((DateTime) shopifyProduct.Variants[0].UpdatedAt).ToUniversalTime()); }
public ShopifyResponse<ShopifyProduct> UpdateProduct(ShopifyStoreAuth storeAuth, ShopifyProduct shopifyProduct) { if (shopifyProduct == null || shopifyProduct.Id == null) { throw new ArgumentNullException( "shopifyProduct"); } var xS = new XmlSerializer(typeof (ShopifyProduct)); var memStream = new MemoryStream(); var xDoc = new XmlDocument(); xS.Serialize(memStream, shopifyProduct); memStream.Seek(0, SeekOrigin.Begin); xDoc.Load(memStream); memStream.Close(); XmlDocument productResponse = ShopifyPutPost( (_protocol + storeAuth.StoreSubDomain + _domain + "/admin/products/" + shopifyProduct.Id + ".xml"), HashString(_appAuth.Secret + storeAuth.StoreAuthToken), xDoc, "PUT"); return new ShopifyResponse<ShopifyProduct>(productResponse); }