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 void DeleteProductVariationInfoTest()
{
List <string> errors = new List <string>(); // TODO: Initialize to an appropriate value
//create a new pv
ProductVariationInfo ProductVariationInfo = new ProductVariationInfo(1, 2, 3, 4, 5, 2, 'M', "XL", 1, (float)10.0, 'a');
int id = DALProductVariationInfo.CreatePV(ProductVariationInfo, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreNotEqual(-1, id);
ProductVariationInfo pv = DALProductVariationInfo.ReadPVDetail(id, ref errors);
Assert.AreEqual(pv.product_id, 5);
Assert.AreEqual(pv.product_brand_id, 3);
Assert.AreEqual(pv.product_cutting_id, 4);
Assert.AreEqual(pv.product_color_id, 5);
Assert.AreEqual(pv.product_type_id, 2);
Assert.AreEqual(pv.sex, 'M');
Assert.AreEqual(pv.size, "XL");
Assert.AreEqual(pv.stock, 1);
Assert.AreEqual(pv.price, 10.0F);
Assert.AreEqual(pv.condition, 'a');
List <string> errorsExpected = new List <string>(); // TODO: Initialize to an appropriate value
int expected = 1; // TODO: Initialize to an appropriate value
int actual;
actual = DALProductVariationInfo.DeleteProductVariationInfo(id, ref errors);
pv = DALProductVariationInfo.ReadPVDetail(id, ref errors);
Assert.AreEqual(expected, actual);
Assert.AreEqual('d', pv.condition);
}
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(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 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 int DeletePV(int productVariationId, ref List <string> errors)
{
if (productVariationId <= 0)
{
errors.Add("Invalid product variation id");
}
if (errors.Count > 0)
{
return(-1);
}
return(DALProductVariationInfo.DeleteProductVariationInfo(productVariationId, ref errors));
}
public static ProductVariationInfo ReadPV(int productVariationId, ref List <string> errors)
{
if (productVariationId <= 0)
{
System.Diagnostics.Debug.WriteLine("REACHED here is the id: " + productVariationId);
errors.Add("Invalid product variation id");
}
if (errors.Count > 0)
{
return(null);
}
return(DALProductVariationInfo.ReadPVDetail(productVariationId, ref errors));
}
public void CreatePVTest()
{
char gender = 'M';
char condition = 'a';
ProductVariationInfo ProductVariationInfo = new ProductVariationInfo(1, 1, 1, 1, 1, 1, gender, "L", 1, (float)1.0, condition); // 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 result = DALProductVariationInfo.CreatePV(ProductVariationInfo, ref errors);
ProductVariationInfo pv = DALProductVariationInfo.ReadPVDetail(result, ref errors);
Assert.AreEqual(pv.product_id, ProductVariationInfo.product_id);
Assert.AreEqual(pv.product_brand_id, ProductVariationInfo.product_brand_id);
Assert.AreEqual(pv.product_cutting_id, ProductVariationInfo.product_cutting_id);
Assert.AreEqual(pv.product_color_id, ProductVariationInfo.product_color_id);
Assert.AreEqual(pv.product_type_id, ProductVariationInfo.product_type_id);
Assert.AreEqual(pv.sex, ProductVariationInfo.sex);
Assert.AreEqual(pv.size, ProductVariationInfo.size);
Assert.AreEqual(pv.stock, ProductVariationInfo.stock);
Assert.AreEqual(pv.price, ProductVariationInfo.price);
Assert.AreEqual(pv.condition, ProductVariationInfo.condition);
}
public void UpdateProductVariationInfoTest()
{
char gender = 'M';
char condition = 'a';
ProductVariationInfo ProductVariationInfo = new ProductVariationInfo(1, 2, 2, 2, 2, 2, gender, "L", 2, (float)1.0, condition); // 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 result = DALProductVariationInfo.UpdateProductVariationInfo(ProductVariationInfo, ref errors);
ProductVariationInfo pv = DALProductVariationInfo.ReadPVDetail(1, ref errors);
Assert.AreEqual(1, result);
Assert.AreEqual(pv.product_variation_id, 1);
Assert.AreEqual(pv.product_id, 2);
Assert.AreEqual(pv.product_brand_id, 2);
Assert.AreEqual(pv.product_cutting_id, 2);
Assert.AreEqual(pv.product_color_id, 2);
Assert.AreEqual(pv.product_type_id, 2);
Assert.AreEqual(pv.sex, gender);
Assert.AreEqual(pv.size, "L");
Assert.AreEqual(pv.stock, 2);
Assert.AreEqual(pv.price, (float)1.0);
Assert.AreEqual(pv.condition, condition);
}
public static List <ProductVariationInfo> ReadAllPV(ref List <string> errors)
{
return(DALProductVariationInfo.ReadPVList(ref errors));
}
