public Preference GetPreference(string userID)
{
Preference preference = new Preference();
using (_connection)
{
SqlCommand cmd = new SqlCommand("spGetPreference", _connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", userID);
_connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
preference.UserID = reader.GetString(0);
preference.Performer = reader.IsDBNull(1) ? -1 : reader.GetInt32(1);
preference.Title = reader.IsDBNull(2)? -1 : reader.GetInt32(2);
}
}
return(preference);
}
public List <Preference> GetUsers()
{
List <Preference> users = new List <Preference>();
using (_connection)
{
SqlCommand cmd = new SqlCommand("spGetUsers", _connection);
cmd.CommandType = CommandType.StoredProcedure;
_connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Preference user = new Preference();
user.UserID = reader.GetString(0);
user.Performer = reader.GetInt32(1);
user.Title = reader.GetInt32(2);
users.Add(user);
}
}
return(users);
}
