public void FetchProductTest()
 {
     DBManager_Accessor target = new DBManager_Accessor(); // TODO: Initialize to an appropriate value
     DataTable expected = null; // TODO: Initialize to an appropriate value
     DataTable actual;
     actual = target.FetchProduct();
     Assert.AreEqual(expected, actual);
     Assert.Inconclusive("Verify the correctness of this test method.");
 }
        public void AddProductTest()
        {
            DBManager_Accessor target = new DBManager_Accessor(); // TODO: Initialize to an appropriate value
            string manufacturerName = "3M"; // TODO: Initialize to an appropriate value
            string productID = "88888888"; // TODO: Initialize to an appropriate value
            string name = "just for test"; // TODO: Initialize to an appropriate value
            string category = "just for test"; // TODO: Initialize to an appropriate value
            bool perishable = false; // TODO: Initialize to an appropriate value
            //target.AddProduct(manufacturerName, productID, name, category, perishable);

            DataTable dtExpected = new DataTable();
            DataTable dtResult = target.FetchProduct();

            try
            {
                dtExpected.Columns.Add("Manufacturer", typeof(string));
                dtExpected.Columns.Add("ProductID", typeof(string));
                dtExpected.Columns.Add("Name", typeof(string));
                dtExpected.Columns.Add("Category", typeof(string));
                dtExpected.Columns.Add("Perishable", typeof(bool));
                dtExpected.Rows.Add(manufacturerName, productID, name, category, perishable);

                //Comparison
                for (int i = 0; i < dtResult.Rows.Count; i++)
                {
                    if (dtResult.Rows[i]["ProductID"].ToString().Equals(dtExpected.Rows[0]["ProductID"].ToString()))
                    {
                        Assert.AreEqual(dtResult.Rows[i]["ManufacturerName"].ToString(), dtExpected.Rows[0]["ManufacturerName"].ToString());
                        Assert.AreEqual(dtResult.Rows[i]["Name"].ToString(), dtExpected.Rows[0]["Name"].ToString());
                        Assert.AreEqual(dtResult.Rows[i]["Category"].ToString(), dtExpected.Rows[0]["Category"].ToString());
                        Assert.AreEqual(dtResult.Rows[i]["Perishable"].ToString(), dtExpected.Rows[0]["Perishable"].ToString());
                    }
                }
            }
            catch
            {
                target.DeleteProduct(productID);
            }
        }