public string parseProductsStockPrice(string eweCategory, string[] eweSubcategories, int categoryID, int supplierID) { EweDL eweDL = new EweDL(); ProductDL productDL = new ProductDL(); CategoryBL categoryBL = new CategoryBL(); Category category = categoryBL.GetCategory(categoryID); productDL.SetInStock(supplierID, false, categoryID); int status = 0; for (int i = 0; i < eweSubcategories.Length; i++) { XmlDocument xmlDoc = eweDL.GetXml(eweCategory, eweSubcategories[i], false, false); XmlNodeList nodeList = xmlDoc.DocumentElement.SelectNodes("product"); foreach (XmlNode xmlNode in nodeList) { string supplierCode = xmlNode.SelectSingleNode("id").InnerText.Trim(); int productID; if ((productID = productDL.GetProductIDBySupplierCode(supplierCode)) > 0) { if (!productDL.IsLocked(productID)) { double price = calculatePrice(double.Parse(xmlNode.SelectSingleNode("price").InnerText.Replace('.', ',').Trim()), category.PricePercent); double webPrice = calculatePrice(double.Parse(xmlNode.SelectSingleNode("price").InnerText.Replace('.', ',').Trim()), category.WebPricePercent); status += productDL.UpdatePriceAndStock(productID, price, webPrice, true); } } } } return "Uspešno izmenjeno " + status.ToString() + " artikala."; }
public int UpdatePriceAndStock(int productID, double price, double webPrice, bool isInStock) { ProductDL productDL = new ProductDL(); return productDL.UpdatePriceAndStock(productID, price, webPrice, isInStock); }