public static int CreateProductColor(String ProductColorName, ref List <string> errors) { List <ProductColorInfo> pi = DALProductColor.ReadProductColorList(ref errors); if (ProductColorName == null) { errors.Add("Product color name cannot be null"); return(-1); } for (int i = 0; i < pi.Count; i++) { if (ProductColorName.ToLower() == pi[i].product_color_name.ToLower()) { errors.Add("ProductColor name already exists"); } } if (errors.Count > 0) { return(-1); } return(DALProductColor.CreateProductColor(ProductColorName, ref errors)); }
public static int UpdateProductColor(int ProductColorId, string ProductColorName, ref List <string> errors) { if (ProductColorId <= 0 || ProductColorId > DALProductColor.ReadProductColorList(ref errors).Count) { errors.Add("Invalid ProductColor id"); } if (errors.Count > 0) { return(-1); } return(DALProductColor.UpdateProductColor(ProductColorId, ProductColorName, ref errors)); }
public static ProductColorInfo ReadProductColor(int ProductColorId, ref List <string> errors) { if (ProductColorId <= 0 || ProductColorId > DALProductColor.ReadProductColorList(ref errors).Count) { errors.Add("Invalid ProductColor id"); } if (errors.Count > 0) { return(null); } return(DALProductColor.ReadProductColorDetail(ProductColorId, ref errors)); }
public void CreateProductColorTest() { Random rand = new Random(); string ProductColor_name = "Diarrhea Green " + rand.Next(10000); // TODO: Initialize to an appropriate value List <string> errors = new List <string>(); // TODO: Initialize to an appropriate value List <string> errorsExpected = new List <string>(); // TODO: Initialize to an appropriate value int actual; actual = DALProductColor.CreateProductColor(ProductColor_name, ref errors); ProductColorInfo pi = DALProductColor.ReadProductColorDetail(actual, ref errors); Assert.AreEqual(pi.product_color_name, ProductColor_name); Assert.AreEqual(pi.product_color_id, actual); }
public void ReadAllProductColorTest() { List <string> errors = new List <string>(); // TODO: Initialize to an appropriate value List <string> errorsExpected = new List <string>(); // TODO: Initialize to an appropriate value List <ProductColorInfo> ProductColorList1 = DALProductColor.ReadProductColorList(ref errors); List <ProductColorInfo> ProductColorList2 = DALProductColor.ReadProductColorList(ref errors); Assert.AreEqual(ProductColorList1.Count, ProductColorList2.Count); Assert.AreEqual(errors.Count, 0); for (int i = 0; i < ProductColorList1.Count; i++) { Assert.AreEqual(ProductColorList1[i].product_color_id, ProductColorList2[i].product_color_id); Assert.AreEqual(ProductColorList1[i].product_color_name, ProductColorList2[i].product_color_name); } }
public void UpdateProductColorTest() { int myId = 1; Random rand = new Random(); ProductColorInfo Color = new ProductColorInfo(myId, "Sanrio Pink " + rand.Next(10000)); List <string> errors = new List <string>(); int result = DALProductColor.UpdateProductColor(Color.product_color_id, Color.product_color_name, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreNotEqual(-1, result); ProductColorInfo verifyColor = DALProductColor.ReadProductColorDetail(myId, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(Color.product_color_id, verifyColor.product_color_id); Assert.AreEqual(Color.product_color_name, verifyColor.product_color_name); }
public static int UpdatePV(ProductVariationInfo productVariation, ref List <string> errors) { if (productVariation == null) { errors.Add("Product Variation cannot be null"); } else if (productVariation.product_variation_id <= 0 || productVariation.product_variation_id > DALProductVariationInfo.ReadPVList(ref errors).Count) { errors.Add("Invalid product variation id"); } else if (productVariation.product_id <= 0 || productVariation.product_id > DALProduct.ReadProductList(ref errors).Count) { errors.Add("Invalid product_id"); } else if (productVariation.product_brand_id <= 0 || productVariation.product_brand_id > DALBrand.ReadBrandList(ref errors).Count) { errors.Add("Invalid product_brand_d"); } else if (productVariation.product_cutting_id <= 0 || productVariation.product_cutting_id > DALProductCutting.ReadProductCuttingList(ref errors).Count) { errors.Add("Invalid product_cutting_id"); } else if (productVariation.product_color_id <= 0 || productVariation.product_color_id > DALProductColor.ReadProductColorList(ref errors).Count) { errors.Add("Invalid product_color_id"); } else if (productVariation.sex != 'F' && productVariation.sex != 'M' && productVariation.sex != 'U') { errors.Add("Invalid sex"); } else if (productVariation.size != "XS" && productVariation.size != "S" && productVariation.size != "M" && productVariation.size != "L" && productVariation.size != "XL" && productVariation.size != "XXL") { errors.Add("Invalid size"); } else if (productVariation.stock < 0) { errors.Add("Invalid stock"); } else if (productVariation.price < 0) { errors.Add("Invalid price"); } else if (productVariation.condition != 'a' && productVariation.condition != 's' && productVariation.condition != 'd') { errors.Add("Invalid condition"); } if (errors.Count > 0) { return(-1); } return(DALProductVariationInfo.UpdateProductVariationInfo(productVariation, ref errors)); }
public static int CreatePV(ProductVariationInfo productVariation, ref List <string> errors) { if (productVariation == null) { errors.Add("Product Variation cannot be null"); return(-1); } System.Diagnostics.Debug.WriteLine("THIS IS THE PID:" + productVariation.product_id); if (productVariation.product_id <= 0 || productVariation.product_id > DALProduct.ReadProductList(ref errors).Count) { errors.Add("Invalid product_id"); } if (productVariation.product_brand_id <= 0 || productVariation.product_brand_id > DALBrand.ReadBrandList(ref errors).Count) { errors.Add("Invalid product_brand_id"); } if (productVariation.product_cutting_id <= 0 || productVariation.product_cutting_id > DALProductCutting.ReadProductCuttingList(ref errors).Count) { errors.Add("Invalid product_cutting_id"); } if (productVariation.product_color_id <= 0 || productVariation.product_color_id > DALProductColor.ReadProductColorList(ref errors).Count) { errors.Add("Invalid product_color_id"); } if (productVariation.sex != 'F' && productVariation.sex != 'M' && productVariation.sex != 'U') { errors.Add("Invalid sex"); } if (productVariation.size != "XS" && productVariation.size != "S" && productVariation.size != "M" && productVariation.size != "L" && productVariation.size != "XL" && productVariation.size != "XXL") { errors.Add("Invalid size"); } if (productVariation.stock < 0) { errors.Add("Invalid stock"); } if (productVariation.price < 0) { errors.Add("Invalid price"); } if (productVariation.condition != 'a' && productVariation.condition != 's' && productVariation.condition != 'd') { errors.Add("Invalid condition"); } if (errors.Count > 0) { return(-1); } return(DALProductVariationInfo.CreatePV(productVariation, ref errors)); }
public static List <ProductColorInfo> ReadAllProductColor(ref List <string> errors) { return(DALProductColor.ReadProductColorList(ref errors)); }