public static int CreateProductCutting(String ProductCuttingName, ref List <string> errors)
{
List <ProductCuttingInfo> pi = DALProductCutting.ReadProductCuttingList(ref errors);
if (ProductCuttingName == null)
{
errors.Add("Product cutting name cannot be null");
return(-1);
}
for (int i = 0; i < pi.Count; i++)
{
if (ProductCuttingName.ToLower() == pi[i].product_cutting_name.ToLower())
{
errors.Add("ProductCutting name already exists");
}
}
if (errors.Count > 0)
{
return(-1);
}
return(DALProductCutting.CreateProductCutting(ProductCuttingName, ref errors));
}
public static int UpdateProductCutting(int ProductCuttingId, string ProductCuttingName, ref List <string> errors)
{
if (ProductCuttingId <= 0 || ProductCuttingId > DALProductCutting.ReadProductCuttingList(ref errors).Count)
{
errors.Add("Invalid ProductCutting id");
}
if (errors.Count > 0)
{
return(-1);
}
return(DALProductCutting.UpdateProductCutting(ProductCuttingId, ProductCuttingName, ref errors));
}
public static ProductCuttingInfo ReadProductCutting(int ProductCuttingId, ref List <string> errors)
{
if (ProductCuttingId <= 0 || ProductCuttingId > DALProductCutting.ReadProductCuttingList(ref errors).Count)
{
errors.Add("Invalid ProductCutting id");
}
if (errors.Count > 0)
{
return(null);
}
return(DALProductCutting.ReadProductCuttingDetail(ProductCuttingId, ref errors));
}
public void ReadAllProductCuttingTest()
{
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 <ProductCuttingInfo> ProductCuttingList1 = DALProductCutting.ReadProductCuttingList(ref errors);
List <ProductCuttingInfo> ProductCuttingList2 = DALProductCutting.ReadProductCuttingList(ref errors);
Assert.AreEqual(ProductCuttingList1.Count, ProductCuttingList2.Count);
Assert.AreEqual(errors.Count, 0);
for (int i = 0; i < ProductCuttingList1.Count; i++)
{
Assert.AreEqual(ProductCuttingList1[i].product_cutting_id, ProductCuttingList2[i].product_cutting_id);
Assert.AreEqual(ProductCuttingList1[i].product_cutting_name, ProductCuttingList2[i].product_cutting_name);
}
}
public void CreateProductCuttingTest()
{
Random rand = new Random();
string product_cutting_name = "super deep v sweater " + rand.Next(10000);
List <string> errors = new List <string>();
int result = DALProductCutting.CreateProductCutting(product_cutting_name, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreNotEqual(-1, result);
ProductCuttingInfo verifyCutting = DALProductCutting.ReadProductCuttingDetail(result, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(result, verifyCutting.product_cutting_id);
Assert.AreEqual(product_cutting_name, verifyCutting.product_cutting_name);
}
public void UpdateProductCuttingTest()
{
int myId = 1;
Random rand = new Random();
ProductCuttingInfo cutting = new ProductCuttingInfo(myId, "turtle neck " + rand.Next(10000));
List <string> errors = new List <string>();
int result = DALProductCutting.UpdateProductCutting(cutting.product_cutting_id, cutting.product_cutting_name, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreNotEqual(-1, result);
ProductCuttingInfo verifyCutting = DALProductCutting.ReadProductCuttingDetail(myId, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(cutting.product_cutting_id, verifyCutting.product_cutting_id);
Assert.AreEqual(cutting.product_cutting_name, verifyCutting.product_cutting_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 <ProductCuttingInfo> ReadAllProductCutting(ref List <string> errors)
{
return(DALProductCutting.ReadProductCuttingList(ref errors));
}
