public void CreateProductVariationErrorTest() { List <string> errors = new List <string>(); // TODO: Initialize to an appropriate value List <string> errorsExpected = new List <string>(); // TODO: Initialize to an appropriate value BLProductVariation.CreatePV(null, ref errors); AsynchLog.LogNow(errors); Assert.AreEqual(1, errors.Count); errors = new List <string>(); // TODO: Initialize to an appropriate value int invalid_pv_id = BLProductVariation.ReadAllPV(ref errors).Count + 1; int invalid_product_id = BLProduct.ReadAllProduct(ref errors).Count + 1; int invalid_brand_id = BLBrand.ReadAllBrand(ref errors).Count + 1; int invalid_product_color_id = BLProductColor.ReadAllProductColor(ref errors).Count + 1; int invalid_product_cutting_id = BLProductCutting.ReadAllProductCutting(ref errors).Count + 1; char invalid_sex = 'Q'; string invalid_size = "huge"; int invalid_stock = -1; int invalid_price = -1; char invalid_condition = 'f'; int invalid_product_type_id = BLProductType.ReadAllProductType(ref errors).Count + 1; ProductVariationInfo ipv = new ProductVariationInfo(invalid_pv_id, invalid_product_id, invalid_brand_id, invalid_product_cutting_id, invalid_product_color_id, invalid_product_type_id, invalid_sex, invalid_size, invalid_stock, invalid_price, invalid_condition); BLProductVariation.CreatePV(ipv, ref errors); Assert.AreEqual(8, errors.Count); AsynchLog.LogNow(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 = BLProductVariation.CreatePV(ProductVariationInfo, ref errors); Assert.AreNotEqual(result, -1); AsynchLog.LogNow(errors); ProductVariationInfo pv = BLProductVariation.ReadPV(result, ref errors); AsynchLog.LogNow(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); Assert.AreEqual(0, errors.Count); }
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 = BLProductVariation.UpdatePV(ProductVariationInfo, ref errors); AsynchLog.LogNow(errors); ProductVariationInfo pv = BLProductVariation.ReadPV(result, ref errors); AsynchLog.LogNow(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 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> ReadPVList(char condition, ref List <string> errors) { SqlConnection conn = new SqlConnection(connection_string); ProductVariationInfo pv = null; List <ProductVariationInfo> pvList = new List <ProductVariationInfo>(); try { string strSQL = "read_all_pv_condition"; SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn); mySA.SelectCommand.CommandType = CommandType.StoredProcedure; mySA.SelectCommand.Parameters.Add(new SqlParameter("@condition", SqlDbType.Char)); mySA.SelectCommand.Parameters["@condition"].Value = condition; DataSet myDS = new DataSet(); mySA.Fill(myDS); if (myDS.Tables[0].Rows.Count == 0) { return(null); } for (int i = 0; i < myDS.Tables[0].Rows.Count; i++) { pv = new ProductVariationInfo(int.Parse(myDS.Tables[0].Rows[i]["product_variation_id"].ToString()), int.Parse(myDS.Tables[0].Rows[i]["product_id"].ToString()), int.Parse(myDS.Tables[0].Rows[i]["product_brand_id"].ToString()), int.Parse(myDS.Tables[0].Rows[i]["product_cutting_id"].ToString()), int.Parse(myDS.Tables[0].Rows[i]["product_color_id"].ToString()), int.Parse(myDS.Tables[0].Rows[i]["product_type_id"].ToString()), char.Parse(myDS.Tables[0].Rows[i]["sex"].ToString()), myDS.Tables[0].Rows[i]["size"].ToString(), int.Parse(myDS.Tables[0].Rows[i]["stock"].ToString()), float.Parse(myDS.Tables[0].Rows[i]["price"].ToString()), char.Parse(myDS.Tables[0].Rows[i]["condition"].ToString())); pvList.Add(pv); } } catch (Exception e) { System.Diagnostics.Debug.Write("THIS IS THE ERROR: " + e.ToString()); errors.Add("Error: " + e.ToString()); } finally { conn.Dispose(); conn = null; } return(pvList); }
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 CreatePV(ProductVariationInfo ProductVariationInfo, ref List <string> errors) { SqlConnection conn = new SqlConnection(connection_string); try { string strSQL = "create_pv"; SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn); mySA.SelectCommand.CommandType = CommandType.StoredProcedure; mySA.SelectCommand.Parameters.Add(new SqlParameter("@product_id", SqlDbType.Int)); mySA.SelectCommand.Parameters.Add(new SqlParameter("@product_brand_id", SqlDbType.Int)); mySA.SelectCommand.Parameters.Add(new SqlParameter("@product_cutting_id", SqlDbType.Int)); mySA.SelectCommand.Parameters.Add(new SqlParameter("@product_color_id", SqlDbType.Int)); mySA.SelectCommand.Parameters.Add(new SqlParameter("@product_type_id", SqlDbType.Int)); mySA.SelectCommand.Parameters.Add(new SqlParameter("@sex", SqlDbType.Char)); mySA.SelectCommand.Parameters.Add(new SqlParameter("@size", SqlDbType.Char)); mySA.SelectCommand.Parameters.Add(new SqlParameter("@stock", SqlDbType.Int)); mySA.SelectCommand.Parameters.Add(new SqlParameter("@price", SqlDbType.Float)); mySA.SelectCommand.Parameters.Add(new SqlParameter("@condition", SqlDbType.Char)); SqlParameter pvIdParmOut = new SqlParameter("@product_variation_id_output", SqlDbType.Int); pvIdParmOut.Direction = ParameterDirection.Output; mySA.SelectCommand.Parameters.Add(pvIdParmOut); mySA.SelectCommand.Parameters["@product_id"].Value = ProductVariationInfo.product_id; mySA.SelectCommand.Parameters["@product_brand_id"].Value = ProductVariationInfo.product_brand_id; mySA.SelectCommand.Parameters["@product_cutting_id"].Value = ProductVariationInfo.product_cutting_id; mySA.SelectCommand.Parameters["@product_color_id"].Value = ProductVariationInfo.product_color_id; mySA.SelectCommand.Parameters["@product_type_id"].Value = ProductVariationInfo.product_type_id; mySA.SelectCommand.Parameters["@sex"].Value = ProductVariationInfo.sex; mySA.SelectCommand.Parameters["@size"].Value = ProductVariationInfo.size; mySA.SelectCommand.Parameters["@stock"].Value = ProductVariationInfo.stock; mySA.SelectCommand.Parameters["@price"].Value = ProductVariationInfo.price; mySA.SelectCommand.Parameters["@condition"].Value = ProductVariationInfo.condition; DataSet myDS = new DataSet(); mySA.Fill(myDS); return((int)pvIdParmOut.Value); } catch (Exception e) { System.Diagnostics.Debug.Write("THIS IS THE ERROR: " + e.ToString()); errors.Add("Error: " + e.ToString()); return(-1); } finally { conn.Dispose(); conn = null; } }
public static ProductVariationInfo ReadPVDetail(int product_variation_id, ref List <string> errors) { SqlConnection conn = new SqlConnection(connection_string); ProductVariationInfo pv = null; try { string strSQL = "read_pv"; SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn); mySA.SelectCommand.CommandType = CommandType.StoredProcedure; mySA.SelectCommand.Parameters.Add(new SqlParameter("@product_variation_id", SqlDbType.Int)); mySA.SelectCommand.Parameters["@product_variation_id"].Value = product_variation_id; DataSet myDS = new DataSet(); mySA.Fill(myDS); if (myDS.Tables[0].Rows.Count == 0) { System.Diagnostics.Debug.WriteLine("REACHED"); return(null); } pv = new ProductVariationInfo(int.Parse(myDS.Tables[0].Rows[0]["product_variation_id"].ToString()), int.Parse(myDS.Tables[0].Rows[0]["product_id"].ToString()), int.Parse(myDS.Tables[0].Rows[0]["product_brand_id"].ToString()), int.Parse(myDS.Tables[0].Rows[0]["product_cutting_id"].ToString()), int.Parse(myDS.Tables[0].Rows[0]["product_color_id"].ToString()), int.Parse(myDS.Tables[0].Rows[0]["product_type_id"].ToString()), char.Parse(myDS.Tables[0].Rows[0]["sex"].ToString()), myDS.Tables[0].Rows[0]["size"].ToString().Replace(" ", ""), int.Parse(myDS.Tables[0].Rows[0]["stock"].ToString()), float.Parse(myDS.Tables[0].Rows[0]["price"].ToString()), char.Parse(myDS.Tables[0].Rows[0]["condition"].ToString())); } catch (Exception e) { errors.Add("Error: " + e.ToString()); System.Diagnostics.Debug.WriteLine("THIS IS THE ERROR:" + e); } finally { conn.Dispose(); conn = null; } return(pv); }
public void ProductVariationUpdateErrorTest() { List <string> errors = new List <string>(); // TODO: Initialize to an appropriate value int invalid_pv_id = BLProductVariation.ReadAllPV(ref errors).Count + 1; char gender = 'M'; char condition = 'a'; ProductVariationInfo ProductVariationInfo1 = new ProductVariationInfo(invalid_pv_id, 2, 2, 2, 2, 2, gender, "L", 2, (float)1.0, condition); // TODO: Initialize to an appropriate value ProductVariationInfo ProductVariationInfo2 = new ProductVariationInfo(-1, 2, 2, 2, 2, 2, gender, "L", 2, (float)1.0, condition); // TODO: Initialize to an appropriate value BLProductVariation.UpdatePV(ProductVariationInfo1, ref errors); Assert.AreEqual(1, errors.Count); BLProductVariation.UpdatePV(ProductVariationInfo2, ref errors); Assert.AreEqual(2, errors.Count); AsynchLog.LogNow(errors); }
public void DeleteProductVariationInfoTest() { char gender = 'M'; char condition = 'a'; List <string> errors = new List <string>(); // TODO: Initialize to an appropriate value List <string> errorsExpected = new List <string>(); // TODO: Initialize to an appropriate value ProductVariationInfo ProductVariationInfo = new ProductVariationInfo(1, 1, 1, 1, 1, 1, gender, "L", 1, (float)1.0, condition); // TODO: Initialize to an appropriate value int result = BLProductVariation.CreatePV(ProductVariationInfo, ref errors); AsynchLog.LogNow(errors); int t = BLProductVariation.DeletePV(result, ref errors); AsynchLog.LogNow(errors); ProductVariationInfo pv = BLProductVariation.ReadPV(result, ref errors); AsynchLog.LogNow(errors); Assert.AreEqual('d', pv.condition); }
public void ProductVariationDeleteErrorTest() { List <string> errors = new List <string>(); // TODO: Initialize to an appropriate value //int invalid_pv_id = BLProductVariation.ReadAllPV(ref errors).Count + 1; //create PV, should have no errors char gender = 'M'; char condition = 'a'; ProductVariationInfo ProductVariationInfo = new ProductVariationInfo(1, 1, 1, 1, 1, 1, gender, "L", 1, (float)1.0, condition); int id_created = BLProductVariation.CreatePV(ProductVariationInfo, ref errors); Assert.AreEqual(0, errors.Count); Console.WriteLine("id: " + id_created); //should delete without error BLProductVariation.DeletePV(id_created, ref errors); Assert.AreEqual(0, errors.Count); //BLProductVariation.DeletePV(invalid_pv_id, ref errors); Assert.AreEqual(0, errors.Count); BLProductVariation.DeletePV(-1, ref errors); Assert.AreEqual(1, errors.Count); AsynchLog.LogNow(errors); }
public int UpdatePV(ProductVariationInfo ProductVariation, ref List <string> errors) { return(BLProductVariation.UpdatePV(ProductVariation, ref errors)); }