public ProfileClass getUserDetails(string username) { conn.Open(); ProfileClass profile = null; cmd = new SqlCommand("SELECT * FROM Profile WHERE Username=@username", conn); cmd.Parameters.AddWithValue("username", username); SqlDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { profile = new ProfileClass { username = reader.GetString(0).ToString(), password = reader.GetString(1).ToString(), name = reader.GetString(2).ToString(), phone = reader.GetString(3).ToString(), email = reader.GetString(4).ToString(), country = reader.GetString(5).ToString(), profession = reader.GetString(6).ToString() }; } } catch (Exception e) { } return(profile); }
public bool updateUser(string username, ProfileClass newProfile) { conn.Open(); try { cmd = new SqlCommand("UPDATE Profile set Password=@password,Name=@name,Phone=@phone,Email=@email,Country=@country,Profession=@profession WHERE Username=@username", conn); cmd.Parameters.AddWithValue("username", newProfile.username); cmd.Parameters.AddWithValue("password", newProfile.password); cmd.Parameters.AddWithValue("name", newProfile.name); cmd.Parameters.AddWithValue("email", newProfile.email); cmd.Parameters.AddWithValue("phone", newProfile.phone); cmd.Parameters.AddWithValue("country", newProfile.country); cmd.Parameters.AddWithValue("profession", newProfile.profession); cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { conn.Close(); return(false); } }