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