Пример #1
0
 private void removeRequestsPopup(DBconnect db)
 {
     try
     {
         db.executionQuery("UPDATE studentrequests SET STATUSOFREQUEST = 'Allowed' WHERE STATUSOFREQUEST='R_Allowed' and STUDENTUSERNAME='******'");
         db.executionQuery("UPDATE studentrequests SET STATUSOFREQUEST = 'Denied' WHERE STATUSOFREQUEST='R_Denied' and STUDENTUSERNAME='******'");
     }
     catch (Exception) { }
 }
Пример #2
0
        // checks if there at least one students request that have status R_Allowed or R_denied, if there are new
        // responces found, rename them to Allowed or Denied
        private void studentRequestResponsed()
        {
            DBconnect db    = new DBconnect();
            string    query = "select COUNT(*) from StudentRequests  WHERE StudentUsername = '******' AND StatusOFRequest IN ('R_Allowed','R_Denied')";

            using (SqlCommand sqlCommand = new SqlCommand(query, db.getConnection()))
            {
                db.OpenConn();

                int userCount = (int)sqlCommand.ExecuteScalar();
                if (userCount > 0)
                {
                    MessageBox.Show("You received responce to one or more of your student request\nCheck them in \" Student requests -> My requests\"");
                    removeRequestsPopup(db);
                }
            }
        }
Пример #3
0
 public Form_studentMenu()
 {
     InitializeComponent();
     dbcon = new DBconnect();
     updateGlobalMessage();
 }