//Allows associate dean to approve a project
protected void Accepted(object sender, EventArgs e)
{
string projectID = projID.Text;
string userID = (string)Session["StaffNo"];
string role = getRole();
MySql.Data.MySqlClient.MySqlDataReader reader;
Button button = (Button)sender;
DB db = new DB();
string updateSigned = "UPDATE 17agileteam6db.projects SET " + role + "_accepted = 1 WHERE project_ID = " + projectID;
string updateIDSigned = "UPDATE 17agileteam6db.projects SET " + role + "_ID =" + userID + " WHERE project_ID = " + projectID;
db.Insert(updateSigned);
db.Insert(updateIDSigned);
db.History(Int32.Parse(projectID), role, "Signed", "Project Has been Signed");
string getEmail = "USE 17agileteam6db; " +
"SELECT email FROM users INNER JOIN projects ON projects.researcher_ID = staff_no WHERE projects.project_ID = 21 ";
reader = db.Select(getEmail);
while (reader.HasRows && reader.Read())
{
getEmail = reader.GetString(reader.GetOrdinal("Email"));
}
db.Email(getEmail, "Project " + projectID + " has been approved");
}
protected void Accepted(object sender, EventArgs e)
{
string projectID = projID.Text;
string userID = (string)Session["StaffNo"];
string role = getRole();
Button button = (Button)sender;
DB db = new DB();
string updateSigned = "UPDATE 17agileteam6db.projects SET " + role + "_accepted = 1 WHERE project_ID = " + projectID;
string updateIDSigned = "UPDATE 17agileteam6db.projects SET " + role + "_ID =" + userID + " WHERE project_ID = " + projectID;
db.Insert(updateSigned);
db.Insert(updateIDSigned);
db.History(Int32.Parse(projectID), role, "Signed", "Project Has been Signed");
db.Email("*****@*****.**", "Project " + projectID + "awaiting signing");
}