Пример #1
0
        public List<Users> GetAllUsers()
        {
            SqlCommand cmd;
            List<Users> tempUserList = new List<Users>();

            try
            {

                Connect();

                cmd = new SqlCommand("SELECT Uname FROM Users", conn);

                SqlDataReader sqlReader;

                sqlReader = cmd.ExecuteReader();
                if (sqlReader.HasRows)
                {
                    while (sqlReader.Read())
                    {
                        Users tempUser = new Users();

                        tempUser.UserName = sqlReader.GetString(0);
                        tempUserList.Add(tempUser);
                    }
                }

                // Cleanup command and connection objects.
                cmd.Dispose();
                conn.Dispose();
            }
            catch (Exception ex)
            {
                // Add error handling here for debugging.
                // This error message should not be sent back to the caller.
                System.Diagnostics.Trace.WriteLine("[ValidateUser] Exception " + ex.Message);
            }
            return tempUserList;
        }
Пример #2
0
        public List<Users> GetInfoAboutSpecificUser(int userID)
        {
            SqlCommand cmd;
            List<Users> tempUserInfo = new List<Users>();

            try
            {

                Connect();

                cmd = new SqlCommand("SELECT Uname, Pwd, userRole, UserID, PersonalInfo, LastName, FirstName, Email, Tele FROM Users WHERE UserID=@userID", conn);

                cmd.Parameters.AddWithValue("@userID", 25);
                cmd.Parameters["@userID"].Value = userID;

                SqlDataReader sqlReader;

                sqlReader = cmd.ExecuteReader();

                if (sqlReader.HasRows)
                {
                    while (sqlReader.Read())
                    {
                        Users tempUser = new Users();

                        tempUser.UserName = sqlReader.GetString(0);
                        tempUser.Password = sqlReader.GetString(1);
                        tempUser.UserRole = sqlReader.GetString(2);
                        tempUser.UserId = sqlReader.GetInt32(3);
                        tempUser.PersonalInfo = sqlReader.GetString(4);
                        tempUser.LastName = sqlReader.GetString(5);
                        tempUser.FirstName = sqlReader.GetString(6);
                        tempUser.Email = sqlReader.GetString(7);
                        tempUser.Tele = sqlReader.GetString(8);

                        tempUserInfo.Add(tempUser);
                    }
                }

                // Cleanup command and connection objects.
                cmd.Dispose();
                conn.Dispose();
            }
            catch (Exception ex)
            {
                // Add error handling here for debugging.
                // This error message should not be sent back to the caller.
                System.Diagnostics.Trace.WriteLine("[ValidateUser] Exception " + ex.Message);
            }

            return tempUserInfo;
        }