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