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_New_User_Can_Be_Added()
{
_form1 = new Form1();
_mysql = new Mysql_Connect();
_list = new List_Of_Requests(_form1, _mysql);
_newUser = new Add_New_User(_list, _mysql, _form1);
_paramaterKey = new List <string>();
_paramaterValue = new List <string>();
_newUser = new MedicTalk.Add_New_User(_list, _mysql, _form1);
string UserName = "******";
string FirstName = "J";
string LastName = "fdf";
string Password = "******";
/*
* _newUser.User_Name_Text_Box.Text = "dec0004";
* _newUser.First_Name_Text_Box.Text = "J";
* _newUser.Last_Name_Text_Box.Text = "fdf";
* _newUser.Password_Text_Box.Text = "cdsd";
* _newUser.Room_Text_Box.Text = "4";
* _newUser.Section_Text_Box.Text = "D4";
* _newUser.Age_Text_Box.Text = "45";
*/
_paramaterKey.Add("UserName");
_paramaterKey.Add("FirstName");
_paramaterKey.Add("LastName");
_paramaterKey.Add("Password");
_paramaterValue.Add(UserName);
_paramaterValue.Add(FirstName);
_paramaterValue.Add(LastName);
_paramaterValue.Add(Password);
_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 NEWUsers");
_mysql.Insert_Request("INSERT INTO NEWUsers ( UserName, FirstName, LastName, Password) " + "VALUES ('" + UserName + "','" + FirstName + "','" + LastName + "','" + Password + "');");
newRowCount = _mysql.Count("SELECT COUNT(*) FROM NEWUsers");
Assert.AreNotEqual(rowCount, newRowCount);
rowCount = _mysql.Count("SELECT COUNT(*) FROM NEWResidents");
_mysql.Insert_Request("INSERT INTO NEWResidents (UID, FirstName, LastName, Room, Section, Age) " + "VALUES (28, '" + FirstName + "','" + LastName + "','" + "43', 'D3', 43);");
newRowCount = _mysql.Count("SELECT COUNT(*) FROM NEWResidents");
Assert.AreNotEqual(rowCount, newRowCount);
}
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);
}
