public DataRow[] DisplayAllUsersActive()
 {
     DataRow[] allaccount;
     mydb = new sqlClass();
     sSql = "select Email, Active from  User";
     allaccount = mydb.drExecute(sPath, sSql);
     if (allaccount == null)
     {
         mydb = null;
         return null;
     }
     return allaccount;
 }
 public Dictionary<string, int> GetAccountMessages()
 {
     accauntsMessages = new Dictionary<string, int>();
     mydb = new sqlClass();
     sSql = "select Email, LastCountMessage from  User;";
     DataRow[] datarows = mydb.drExecute(sPath, sSql);
     if (datarows == null)
     {
         mydb = null;
         return new Dictionary<string, int>();
     }
     else
     {
         foreach (DataRow dr in datarows)
         {
             accauntsMessages.Add(dr["Email"].ToString(), int.Parse(dr["LastCountMessage"].ToString()));
         }
         return accauntsMessages;
     }
 }
        public List<string> DisplayAllUsers()
        {
            
            users = new List<string>();
            mydb = new sqlClass();
            sSql = "select Email from  User";
            DataRow[] datarows = mydb.drExecute(sPath, sSql);
            if (datarows == null)
            {
                mydb = null;
                return new List<string>();
            }
            else
            {
                foreach (DataRow dr in datarows)
                {
                    users.Add(dr["Email"].ToString());
                }
                return users;
            }

        }
        public Dictionary<string, string> ActiveAccount()
        {
            activeaccount = new Dictionary<string, string>();
            mydb = new sqlClass();
            sSql = "select Email, Password from  User where Active<>0";
            DataRow[] datarows = mydb.drExecute(sPath, sSql);
            if (datarows == null)
            {
                mydb = null;
                return new Dictionary<string,string>();
            }
            else
            {
                foreach (DataRow dr in datarows)
                {
                    activeaccount.Add(dr["Email"].ToString(), dr["Password"].ToString());
                }
                return activeaccount;
            }

        }
 public void UpdateAccountMessages(string email, int i)
 {
     mydb = new sqlClass();
     sSql = @"Update User set LastCountMessage =" + i + " where Email='" + email + "'";
     DataRow[] datarows = mydb.drExecute(sPath, sSql);
     if (datarows == null)
     {
         mydb = null;
         return;
     }
     else
     {
         mydb = null;
     }
 }