public IList <IViewAlbumArtistSongTotalVotes> GetTop <IViewAlbumArtistSongTotalVotesQueryParams>(int top, IViewAlbumArtistSongTotalVotesQueryParams query)
{
_collection = new List <IViewAlbumArtistSongTotalVotes>();
string sqlCommand = "viewAlbumArtistSongTotalVotesGetTop";
using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand))
{
_dataBase.AddInParameter(dbCmd, "@topParam", DbType.Int32, top);
_dataBase.AddInParameter(dbCmd, "@fromParam", DbType.String, ((IDataQuery)query).From);
_dataBase.AddInParameter(dbCmd, "@whereParam", DbType.String, ((IDataQuery)query).Where);
_dataBase.AddInParameter(dbCmd, "@orderByParam", DbType.String, ((IDataQuery)query).OrderBy);
using (IDataReader reader = _dataBase.ExecuteReader(dbCmd))
{
while (reader.Read())
{
IViewAlbumArtistSongTotalVotes viewAlbumArtistSongTotalVotes = new ViewAlbumArtistSongTotalVotes();
viewAlbumArtistSongTotalVotes.SongId = Convert.ToInt32(reader["songId"].ToString());
viewAlbumArtistSongTotalVotes.Total = Convert.ToInt32(reader["total"].ToString());
viewAlbumArtistSongTotalVotes.SongName = reader["songName"].ToString();
viewAlbumArtistSongTotalVotes.AlbumName = reader["albumName"].ToString();
viewAlbumArtistSongTotalVotes.ArtistName = reader["artistName"].ToString();
viewAlbumArtistSongTotalVotes.ArtistId = Convert.ToInt32(reader["artistId"].ToString());
viewAlbumArtistSongTotalVotes.AlbumCover = reader["albumCover"].ToString();
viewAlbumArtistSongTotalVotes.BattlDate = (DateTime)reader["battlDate"];
_collection.Add(viewAlbumArtistSongTotalVotes);
}
}
}
return(_collection);
}
public IList <IViewAlbumArtistSongTotalVotes> Find <IViewAlbumArtistSongTotalVotesQueryParams>(IViewAlbumArtistSongTotalVotesQueryParams query)
{
_collection = new List <IViewAlbumArtistSongTotalVotes>();
string sqlCommand = "viewAlbumArtistSongTotalVotesGroupedBySong";
// Create a suitable command type and add the required parameter.
using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand))
{
_dataBase.AddInParameter(dbCmd, "@fromParam", DbType.String, ((IDataQuery)query).From);
_dataBase.AddInParameter(dbCmd, "@whereParam", DbType.String, ((IDataQuery)query).Where);
_dataBase.AddInParameter(dbCmd, "@orderByParam", DbType.String, ((IDataQuery)query).OrderBy);
_dataBase.AddInParameter(dbCmd, "@pageNumber", DbType.String, ((IDataQuery)query).Page);
_dataBase.AddInParameter(dbCmd, "@rowCount", DbType.String, ((IDataQuery)query).RowCount);
// Call the ExecuteReader method with the command.
using (IDataReader reader = _dataBase.ExecuteReader(dbCmd))
{
while (reader.Read())
{
IViewAlbumArtistSongTotalVotes viewAlbumArtistSongTotalVotes = new ViewAlbumArtistSongTotalVotes();
viewAlbumArtistSongTotalVotes.SongId = Convert.ToInt32(reader["songId"].ToString());
viewAlbumArtistSongTotalVotes.SongName = reader["songName"].ToString();
viewAlbumArtistSongTotalVotes.Total = Convert.ToInt32(reader["total"].ToString());
viewAlbumArtistSongTotalVotes.AlbumName = reader["albumName"].ToString();
viewAlbumArtistSongTotalVotes.ArtistName = reader["artistName"].ToString();
viewAlbumArtistSongTotalVotes.ArtistId = Convert.ToInt32(reader["total"].ToString());
viewAlbumArtistSongTotalVotes.AlbumCover = reader["albumCover"].ToString();
_collection.Add(viewAlbumArtistSongTotalVotes);
}
}
}
return(_collection);
}
public IViewAlbumArtistSongTotalVotes GetById(int id)
{
IViewAlbumArtistSongTotalVotes viewAlbumArtistSongTotalVotes = new ViewAlbumArtistSongTotalVotes();
string sqlCommand = "viewAlbumArtistSongTotalVotesFind";
using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand))
{
IDataQuery query = new DataQuery();
query.Where = string.Format(" songId={0} ", id);
_dataBase.AddInParameter(dbCmd, "@fromParam", DbType.String, query.From);
_dataBase.AddInParameter(dbCmd, "@whereParam", DbType.String, query.Where);
_dataBase.AddInParameter(dbCmd, "@orderByParam", DbType.String, query.OrderBy);
// Call the ExecuteReader method with the command.
using (IDataReader reader = _dataBase.ExecuteReader(dbCmd))
{
while (reader.Read())
{
viewAlbumArtistSongTotalVotes.SongId = Convert.ToInt32(reader["songId"].ToString());
viewAlbumArtistSongTotalVotes.Total = Convert.ToInt32(reader["total"].ToString());
viewAlbumArtistSongTotalVotes.SongName = reader["songName"].ToString();
viewAlbumArtistSongTotalVotes.AlbumName = reader["albumName"].ToString();
viewAlbumArtistSongTotalVotes.ArtistName = reader["artistName"].ToString();
viewAlbumArtistSongTotalVotes.ArtistId = Convert.ToInt32(reader["artistId"].ToString());
viewAlbumArtistSongTotalVotes.AlbumCover = reader["albumCover"].ToString();
viewAlbumArtistSongTotalVotes.BattlDate = (DateTime)reader["battlDate"];
}
}
}
return(viewAlbumArtistSongTotalVotes);
}
public IList <IViewAlbumArtistSongTotalVotes> ExecuteProcedure <IViewTopAlbumsQueryParams>(string procedureName, IViewTopAlbumsQueryParams query, int top = 0)
{
_collection = new List <IViewAlbumArtistSongTotalVotes>();
using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(procedureName))
{
if (top > 0)
{
_dataBase.AddInParameter(dbCmd, "@topParam", DbType.Int32, top);
}
_dataBase.AddInParameter(dbCmd, "@whereParam", DbType.String, ((IDataQuery)query).Where);
using (IDataReader reader = _dataBase.ExecuteReader(dbCmd))
{
while (reader.Read())
{
IViewAlbumArtistSongTotalVotes viewAlbumArtistSongTotalVotes = new ViewAlbumArtistSongTotalVotes();
viewAlbumArtistSongTotalVotes.ArtistId = Convert.ToInt32(reader["artistId"].ToString());
viewAlbumArtistSongTotalVotes.Total = Convert.ToInt32(reader["totalVotes"].ToString());
viewAlbumArtistSongTotalVotes.AlbumName = reader["albumName"].ToString();
viewAlbumArtistSongTotalVotes.ArtistName = reader["artistName"].ToString();
viewAlbumArtistSongTotalVotes.AlbumCover = reader["albumCover"].ToString();
viewAlbumArtistSongTotalVotes.Picture = reader["picture"].ToString();
_collection.Add(viewAlbumArtistSongTotalVotes);
}
}
}
return(_collection);
}