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