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