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);
}
