Ejemplo n.º 1
0
        //Create User Profile and Scope ProfileID
        public int CreateProfile(ViewProfileDO create)
        {
            int profileID = 0;

            //Try(catch) to open a connection and access the server database
            try
            {
                using (SqlConnection sqlConnect = new SqlConnection(connectionString))
                    using (SqlCommand sqlCommand = new SqlCommand("CREATE_PROFILE", sqlConnect))
                    {
                        sqlCommand.CommandType = CommandType.StoredProcedure;
                        sqlConnect.Open();

                        sqlCommand.Parameters.AddWithValue("@Bio", create.Bio);
                        sqlCommand.Parameters.AddWithValue("@JobTitle", create.JobTitle);
                        sqlCommand.Parameters.AddWithValue("@Achievements", create.Achievements);
                        sqlCommand.Parameters.AddWithValue("@Posts", create.Posts);
                        profileID = (int)sqlCommand.ExecuteScalar();
                        sqlCommand.ExecuteNonQuery();
                    }
            }
            catch (Exception error)
            {
                Logger Error = new Logger();
                Error.logErrors(error);
            }
            finally { }

            return(profileID);
        }
Ejemplo n.º 2
0
        // User Profiles Database Procdures ------------------------------------------------------------------------------------------------------------------------

        //Reading all the Profile Information in the database table "UserProfiles" into a List.
        public ViewProfileDO ViewProfiles(int profileID)
        {
            ViewProfileDO userProfile = new ViewProfileDO();

            //Try(catch) to open a connection and access the server database
            try
            {
                using (SqlConnection sqlConnect = new SqlConnection(connectionString))
                    using (SqlCommand sqlCommand = new SqlCommand("VIEW_PROFILE", sqlConnect))
                    {
                        sqlCommand.CommandType = CommandType.StoredProcedure;
                        sqlConnect.Open();

                        sqlCommand.Parameters.AddWithValue("@ProfileID", profileID);

                        using (SqlDataReader dataReader = sqlCommand.ExecuteReader())
                        {
                            //Reads all the data in the UserProfile table by ProfileID.
                            while (dataReader.Read())
                            {
                                userProfile.ProfileID     = (int)dataReader["ProfileID"];
                                userProfile.UserFirstName = (string)dataReader["UserFirstName"];
                                userProfile.UserLastName  = (string)dataReader["UserLastName"];
                                userProfile.Email         = (string)dataReader["Email"];
                                userProfile.UserName      = (string)dataReader["UserName"];
                                userProfile.Bio           = (string)dataReader["Bio"];
                                userProfile.JobTitle      = (string)dataReader["JobTitle"];
                                userProfile.Achievements  = (string)dataReader["Achievements"];
                                userProfile.Posts         = (string)dataReader["Posts"];
                            }
                        }
                    }
            }
            catch (Exception error)
            {
                Logger Error = new Logger();
                Error.logErrors(error);
            }
            finally { }

            return(userProfile);
        }