MvcWrench.Models.UserRepository.SaveUser C# (CSharp) Method

SaveUser() public static method

public static SaveUser ( User user ) : void
user User
return void
        public static void SaveUser(User user)
        {
            NpgsqlConnection conn = new NpgsqlConnection (conn_string);
            NpgsqlCommand comm = conn.CreateCommand ();

            // Add data to the User table
            string sql = "UPDATE users SET email = @email, gravatar = @gravatar, svn = @svn WHERE id = @id";
            comm.CommandText = sql;

            comm.Parameters.Add ("@id", user.ID);
            comm.Parameters.Add ("@svn", user.SvnAccount);
            comm.Parameters.Add ("@email", user.Email);
            comm.Parameters.Add ("@gravatar", user.Gravatar);

            conn.Open ();
            comm.ExecuteNonQuery ();
            comm.Dispose ();
        }