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() { Random rand = new Random(); String updateString = "Tall " + rand.Next(1000); 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 = BLProductCutting.UpdateProductCutting(1, updateString, ref errors); AsynchLog.LogNow(errors); ProductCuttingInfo ProductCutting = BLProductCutting.ReadProductCutting(1, ref errors); AsynchLog.LogNow(errors); Assert.AreEqual(1, result); Assert.AreEqual(ProductCutting.product_cutting_id, 1); Assert.AreEqual(ProductCutting.product_cutting_name, updateString); }
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 void CreateProductCuttingTest() { Random rand = new Random(); String createString = "Midget " + rand.Next(1000); 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 = BLProductCutting.CreateProductCutting(createString, ref errors); AsynchLog.LogNow(errors); Assert.AreNotEqual(result, -1); ProductCuttingInfo ProductCutting = BLProductCutting.ReadProductCutting(result, ref errors); AsynchLog.LogNow(errors); Assert.AreEqual(ProductCutting.product_cutting_id, result); Assert.AreEqual(ProductCutting.product_cutting_name, createString); }
public static List <ProductCuttingInfo> ReadProductCuttingList(ref List <string> errors) { SqlConnection conn = new SqlConnection(connection_string); ProductCuttingInfo Product = null; List <ProductCuttingInfo> ProductCuttingList = new List <ProductCuttingInfo>(); try { string strSQL = "read_all_product_cutting"; SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn); mySA.SelectCommand.CommandType = CommandType.StoredProcedure; 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++) { Product = new ProductCuttingInfo(int.Parse(myDS.Tables[0].Rows[i]["product_cutting_id"].ToString()), myDS.Tables[0].Rows[i]["product_cutting_name"].ToString()); ProductCuttingList.Add(Product); } } catch (Exception e) { errors.Add("Error: " + e.ToString()); } finally { conn.Dispose(); conn = null; } return(ProductCuttingList); }
public static ProductCuttingInfo ReadProductCuttingDetail(int product_cutting_id, ref List <string> errors) { SqlConnection conn = new SqlConnection(connection_string); ProductCuttingInfo ProductCutting = null; try { string strSQL = "read_product_cutting"; SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn); mySA.SelectCommand.CommandType = CommandType.StoredProcedure; mySA.SelectCommand.Parameters.Add(new SqlParameter("@product_cutting_id", SqlDbType.Int)); mySA.SelectCommand.Parameters["@product_cutting_id"].Value = product_cutting_id; DataSet myDS = new DataSet(); mySA.Fill(myDS); if (myDS.Tables[0].Rows.Count == 0) { return(null); } ProductCutting = new ProductCuttingInfo(int.Parse(myDS.Tables[0].Rows[0]["product_cutting_id"].ToString()), myDS.Tables[0].Rows[0]["product_cutting_name"].ToString()); return(ProductCutting); } catch (Exception e) { errors.Add("Error: " + e.ToString()); } finally { conn.Dispose(); conn = null; } return(null); }