public void AddApprovedRequestTest()
        {
            DBManager_Accessor target = new DBManager_Accessor(); // TODO: Initialize to an appropriate value
            DataTable dtExpected = new DataTable();
            DataTable dtResult;
            dtExpected.Columns.Add("ProductName", typeof(string));
            dtExpected.Columns.Add("ManufacturerName", typeof(string));
            dtExpected.Columns.Add("ProductID", typeof(string));
            dtExpected.Columns.Add("ShopID", typeof(string));
            dtExpected.Columns.Add("ShopCountry", typeof(string));
            dtExpected.Columns.Add("ShopLocation", typeof(string));
            dtExpected.Columns.Add("RequestDate", typeof(DateTime));
            dtExpected.Columns.Add("ApprovedDate", typeof(DateTime));
            dtExpected.Columns.Add("StaffID", typeof(string));
            dtExpected.Columns.Add("Quantity", typeof(int));
            dtExpected.Columns.Add("Urgency", typeof(bool));

            string productName = "Money Clip"; // TODO: Initialize to an appropriate value
            string manufacturerName = "Zooper Dooper"; // TODO: Initialize to an appropriate value
            string productID = "11521340"; // TODO: Initialize to an appropriate value
            string shopID = "0001"; // TODO: Initialize to an appropriate value
            string shopCountry = "Singapore"; // TODO: Initialize to an appropriate value
            string shopLocaton = "Ang Mo Kio"; // TODO: Initialize to an appropriate value
            DateTime requestDate = new DateTime(2013,8,29); // TODO: Initialize to an appropriate value
            DateTime approvedDate = DateTime.Now; // TODO: Initialize to an appropriate value
            string staffID = "*****@*****.**"; // TODO: Initialize to an appropriate value
            string quantity = "50"; // TODO: Initialize to an appropriate value
            bool urgency = true; // TODO: Initialize to an appropriate value
            //target.AddApprovedRequest(productName, manufacturerName, productID, shopID, shopCountry, shopLocaton, requestDate, approvedDate, staffID, quantity, urgency);

            dtResult = target.FetchApprovedRequest();
            dtExpected.Rows.Add(productName, manufacturerName, productID, shopID, shopCountry, shopLocaton, requestDate, approvedDate, staffID, quantity, urgency);

            //Comparison
            Assert.AreEqual(dtExpected.Rows[0]["ProductName"].ToString(), dtResult.Rows[dtResult.Rows.Count-1]["ProductName"].ToString());
            Assert.AreEqual(dtExpected.Rows[0]["ManufacturerName"].ToString(), dtResult.Rows[dtResult.Rows.Count - 1]["ManufacturerName"].ToString());
            Assert.AreEqual(dtExpected.Rows[0]["ProductID"].ToString(), dtResult.Rows[dtResult.Rows.Count - 1]["ProductID"].ToString());
            Assert.AreEqual(dtExpected.Rows[0]["ShopID"].ToString(), dtResult.Rows[dtResult.Rows.Count - 1]["ShopID"].ToString());
            Assert.AreEqual(dtExpected.Rows[0]["ShopCountry"].ToString(), dtResult.Rows[dtResult.Rows.Count - 1]["ShopCountry"].ToString());
            Assert.AreEqual(dtExpected.Rows[0]["ShopLocation"].ToString(), dtResult.Rows[dtResult.Rows.Count - 1]["ShopLocation"].ToString());
            Assert.AreEqual(dtExpected.Rows[0]["RequestDate"], dtResult.Rows[dtResult.Rows.Count - 1]["RequestDate"]);
            Assert.AreEqual(dtExpected.Rows[0]["ApprovedDate"], dtResult.Rows[dtResult.Rows.Count - 1]["ApprovedDate"]);
            Assert.AreEqual(dtExpected.Rows[0]["StaffID"].ToString(), dtResult.Rows[dtResult.Rows.Count - 1]["StaffID"].ToString());
            Assert.AreEqual(dtExpected.Rows[0]["Quantity"], dtResult.Rows[dtResult.Rows.Count - 1]["Quantity"]);
            Assert.AreEqual(dtExpected.Rows[0]["Urgency"], dtResult.Rows[dtResult.Rows.Count - 1]["Urgency"]);
        }
 public void FetchApprovedRequestTest()
 {
     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.FetchApprovedRequest();
     Assert.AreEqual(expected, actual);
     Assert.Inconclusive("Verify the correctness of this test method.");
 }