private void studentRequestsButton_Click(object sender, EventArgs e)
{
using (Form_secretaryStudentRequests studentRequests = new Form_secretaryStudentRequests())
{
this.Hide();
studentRequests.ShowDialog(this);
}
}
public void SecretaryDeniesRequest()
{
Form_secretaryStudentRequests secretaryForm = new Form_secretaryStudentRequests();
PrivateObject secretaryPrivateObject = new PrivateObject(secretaryForm);
DBconnect db = new DBconnect();
db.OpenConn();
//create new request
db.executionQuery("insert into studentrequests values('alex', 'unittest','R_Denied','isabele')");
DataSet ds = new DataSet();
ds = db.LoadTableByFreeQuerry("select * from studentrequests where MESSAGEBODY='unittest'");
Assert.IsNotNull(ds);
string requestID = ds.Tables[0].Rows[0][0].ToString();
string requestFromStrudent = ds.Tables[0].Rows[0][1].ToString();
string expectedRequestFromStrudent = "alex";
Assert.AreEqual(requestFromStrudent, expectedRequestFromStrudent);
string messagebody = ds.Tables[0].Rows[0][2].ToString();
string expectedMessageBody = "unittest";
Assert.AreEqual(messagebody, expectedMessageBody);
string requestStatus = ds.Tables[0].Rows[0][3].ToString();
string expectedRequestStatus = "R_Denied";
Assert.AreEqual(requestStatus, expectedRequestStatus);
String[] args = new String[2];
string expectedNewStatus = "R_Denied";
args[0] = "R_Denied";
args[1] = requestID;
secretaryPrivateObject.Invoke("updateRequest", args);
ds = db.LoadTableByFreeQuerry("select * from studentRequests where MESSAGEBODY='unittest' and ID=" + requestID);
Assert.IsNotNull(ds);
string newStatus = ds.Tables[0].Rows[0][3].ToString();
try { Assert.AreEqual(expectedNewStatus, newStatus); }
finally
{
db.executionQuery("delete from StudentRequests where MESSAGEBODY='unittest'"); //remove created request
db.CloseConn(db.ConnStatus());
}
}
