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
