public AvatarUser GetUserById(string Id)
{
var avatarUser = new AvatarUser();
var connectionString = ConfigurationManager.ConnectionStrings["AvatarDBPM"].ConnectionString;
var commandText = "SELECT u.USERID as Id, " +
"u.user_description as Description " +
"FROM SYSTEM.Radplus_users u " +
"WHERE USERID=? ";
using (var connection = new OdbcConnection(connectionString))
{
connection.Open();
using (var dbcommand = new OdbcCommand(commandText, connection))
{
dbcommand.Parameters.Add(new OdbcParameter("USERID", Id));
using (var reader = dbcommand.ExecuteReader())
{
if (reader.Read())
{
avatarUser.Id = reader["Id"].ToString();
avatarUser.Description = reader["Description"].ToString();
}
else
{
avatarUser = null;
}
}
}
connection.Close();
}
return(avatarUser);
}
public IEnumerable <AvatarUser> SearchUser(string Name)
{
var avatarUsers = new List <AvatarUser>();
var connectionString = ConfigurationManager.ConnectionStrings["AvatarDBPM"].ConnectionString;
var commandText = "SELECT TOP(10) u.USERID as Id, " +
"u.user_description as Description " +
"FROM SYSTEM.Radplus_users u " +
"WHERE u.user_description like ? " +
"AND u.active = 'Yes' " +
"ORDER BY u.user_description ";
using (var connection = new OdbcConnection(connectionString))
{
connection.Open();
using (var dbcommand = new OdbcCommand(commandText, connection))
{
dbcommand.Parameters.Add(new OdbcParameter("user_description", "%" + Name.ToUpper() + "%"));
using (var reader = dbcommand.ExecuteReader())
{
while (reader.Read())
{
var avatarUser = new AvatarUser();
avatarUser.Id = reader["Id"].ToString();
avatarUser.Description = reader["Description"].ToString().Replace("\"", "");
avatarUsers.Add(avatarUser);
}
}
}
connection.Close();
}
return(avatarUsers);
}
private void start_program()
{
AvatarUser.Load(lib_api.user_get());
htCollect_Audio = XML_PARSE(lib_api.audio_get());
Playlist = new FormPlaylist(htCollect_Audio);
string url_music = htCollect_Audio[move_music_list]["url"].ToString();
ProgressBar1.Maximum = Convert.ToInt32(htCollect_Audio[move_music_list]["duration"]);
pl.Open(url_music);
}
