public void Test_New_Visitor_Can_Be_Added() { _form1 = new Form1(); _mysql = new Mysql_Connect(); _list = new List_Of_Requests(_form1, _mysql); _visitor = new Visitor_Signin(_list, _mysql, _form1); string FirstName = "dec0004"; string LastName = "J"; string PersonVisiting = "fdf"; _form1.Username_Textbox.Text = "resident"; _form1.Password_Textbox.Text = "resident"; _form1.UserNameProperty = "resident"; _form1.PasswordProperty = "resident"; _form1.Login_Click(new object(), EventArgs.Empty); rowCount = _mysql.Count("SELECT COUNT(*) FROM NEWVisitorIn"); _mysql.Insert_Request("INSERT INTO NEWVisitorIn (First_Name, Last_Name, Person_Visiting, Time_In) " + "VALUES ('" + FirstName + "','" + LastName + "','" + PersonVisiting + "','" + DateTime.Now.TimeOfDay + "');"); newRowCount = _mysql.Count("SELECT COUNT(*) FROM NEWVisitorIn"); Assert.AreNotEqual(rowCount, newRowCount); }
public void Test_Visitors_Show() { _form1 = new Form1(); _mysql = new Mysql_Connect(); _list = new List_Of_Requests(_form1, _mysql); _visitor = new Visitor_Signin(_list, _mysql, _form1); bool exists = _mysql.DataExists("NEWVisitorIn", "First_Name = 'dec0004'"); Assert.IsTrue(exists); }
public void Test_Visitors_List_Clears() { _form1 = new Form1(); _mysql = new Mysql_Connect(); _list = new List_Of_Requests(_form1, _mysql); _visitor = new Visitor_Signin(_list, _mysql, _form1); _form1.Username_Textbox.Text = "resident"; _form1.Password_Textbox.Text = "resident"; _form1.UserNameProperty = "resident"; _form1.PasswordProperty = "resident"; _form1.Login_Click(new object(), EventArgs.Empty); _mysql.Insert_Request("INSERT INTO NEWVisitorIn (First_Name, Last_Name, Person_Visiting, Time_In) VALUES ('Jordan', 'de carheil', 'amandasswdc', '12:00:21');"); _mysql.Insert_Request("INSERT INTO NEWVisitorIn (First_Name, Last_Name, Person_Visiting, Time_In) VALUES ('Jordan', 'de carheil', 'amandasswdc', '12:00:23');"); rowCount = _mysql.Count("SELECT COUNT(*) FROM NEWVisitorIn"); Console.WriteLine(rowCount); _mysql.Delete_Request("DELETE FROM NEWVisitorIn", null); newRowCount = _mysql.Count("SELECT COUNT(*) FROM NEWVisitorIn"); Console.WriteLine(newRowCount); Assert.AreNotEqual(rowCount, newRowCount); }