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