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);
}
}
