public void ReadAllPVTestWithCond()
{
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 <ProductVariationInfo> pvList1 = DALProductVariationInfo.ReadPVList('a', ref errors);
List <ProductVariationInfo> pvList2 = DALProductVariationInfo.ReadPVList('a', ref errors);
Assert.AreEqual(pvList1.Count, pvList2.Count);
Assert.AreEqual(errors.Count, 0);
for (int i = 0; i < pvList1.Count; i++)
{
Assert.AreEqual(pvList1[i].product_variation_id, pvList2[i].product_variation_id);
Assert.AreEqual(pvList1[i].product_id, pvList2[i].product_id);
Assert.AreEqual(pvList1[i].product_brand_id, pvList2[i].product_brand_id);
Assert.AreEqual(pvList1[i].product_cutting_id, pvList2[i].product_cutting_id);
Assert.AreEqual(pvList1[i].product_color_id, pvList2[i].product_color_id);
Assert.AreEqual(pvList1[i].product_type_id, pvList2[i].product_type_id);
Assert.AreEqual(pvList1[i].sex, pvList2[i].sex);
Assert.AreEqual(pvList1[i].size, pvList2[i].size);
Assert.AreEqual(pvList1[i].stock, pvList2[i].stock);
Assert.AreEqual(pvList1[i].price, pvList2[i].price);
Assert.AreEqual(pvList1[i].condition, pvList2[i].condition);
}
for (int i = 0; i < pvList1.Count; i++)
{
Assert.AreEqual(pvList1[i].condition, 'a');
Assert.AreEqual(pvList2[i].condition, 'a');
}
}
public static List <ProductVariationInfo> ReadAllPV(char condition, ref List <string> errors)
{
if (condition != 'a' && condition != 's' && condition != 'd')
{
errors.Add("Invalid condition");
return(null);
}
return(DALProductVariationInfo.ReadPVList(condition, ref errors));
}
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 List <ProductVariationInfo> ReadAllPV(ref List <string> errors)
{
return(DALProductVariationInfo.ReadPVList(ref errors));
}