protected void Page_Load(object sender, EventArgs e) { RLt_MDMusicStyleRecordList rLt_MDMusicStyleRecordList = new RLt_MDMusicStyleRecordList(); CssMusicDBExternalData cssMusicDBExternal = new CssMusicDBExternalData(); RCt_SMArtistDataPointRecord sMArtistDataPointRecord; //cssMusicDBExternal.MssGetMusicStyleByArtist(1, out rLt_MDMusicStyleRecordList); cssMusicDBExternal.MssGetSocialMediaDataPointByArtist(1, 1, 2, -1, out sMArtistDataPointRecord); }
} // MssGetSocialMediaDataPointByArtist /// <summary> /// /// </summary> /// <param name="ssArtistId"></param> /// <param name="ssArtistMusicStyle"></param> public void MssGetMusicStyleByArtist(int ssArtistId, out RLt_MDMusicStyleRecordList ssArtistMusicStyle) { // define SQL Server Command to retrieve data string strSQLCommand = String.Format("SELECT t_MDMusicStyle.* " + "FROM t_MUArtistMusicStyle " + "INNER JOIN t_MDMusicStyle ON t_MDMusicStyle.MusicStyleId = t_MUArtistMusicStyle.MusicStyleId " + "WHERE ArtistId = {0}", ssArtistId); // initializes list instance ssArtistMusicStyle = new RLt_MDMusicStyleRecordList(); // gets the data from database GetRecordList <RCt_MDMusicStyleRecord>(strSQLCommand, ssArtistMusicStyle); log.Write(System.DateTime.Now, AppInfo.GetAppInfo().OsContext.Session.SessionID, AppInfo.GetAppInfo().eSpaceId, AppInfo.GetAppInfo().Tenant.Id, AppInfo.GetAppInfo().OsContext.Session.UserId, string.Format("Retrieved {0} of {1} from MusicDB External database", ssArtistMusicStyle.Count, ssArtistMusicStyle.GetType()), "Info", "MusicDBExternalData", "0"); } // MssGetMusicStyleByArtist