public List <Dictionary <string, string> > getAll(int pageSize) { List <Product> products = QuerySyntax.GetAllProducts(pageSize); List <Dictionary <string, string> > outputData = new List <Dictionary <string, string> >(); foreach (Product p in products) { Dictionary <String, String> currentProductData = new Dictionary <string, string>(); currentProductData.Add("ProductID", p.ProductID.ToString()); currentProductData.Add("Name", p.Name); currentProductData.Add("ProductNumber", p.ProductNumber); if (p.Color == null) { currentProductData.Add("Color", "Unknown"); } else { currentProductData.Add("Color", p.Color); } currentProductData.Add("StandardCost", p.StandardCost.ToString()); currentProductData.Add("SafetyStockLevel", p.SafetyStockLevel.ToString()); outputData.Add(currentProductData); } return(outputData); }
public string updateProduct(int productID, string name, string productNumber, string color, double standardCost, short safetyStockLevel) { Product p = new Product(); p.ProductID = productID; p.Name = name; p.ProductNumber = productNumber; p.Color = color; p.StandardCost = (decimal)standardCost; p.SafetyStockLevel = safetyStockLevel; return(QuerySyntax.UpdateProduct(p)); }
public string addProduct(string name, string productNumber, string color, double standardCost, short safetyStockLevel) { Product p = new Product(); p.ProductID = 0; p.Name = name; p.ProductNumber = productNumber; p.Color = color; p.StandardCost = (decimal)standardCost; p.SafetyStockLevel = (short)safetyStockLevel; p.SellStartDate = DateTime.Now; p.ModifiedDate = DateTime.Now; p.ReorderPoint = 600; return(QuerySyntax.AddProduct(p)); }
public string removeProduct(string name) { return(QuerySyntax.RemoveProductByName(name)); }