public IViewAlbumArtistSongTotalVotesByArtist GetById(int id) { IViewAlbumArtistSongTotalVotesByArtist viewAlbumArtistSongTotalVotesByArtist = new ViewAlbumArtistSongTotalVotesByArtist(); string sqlCommand = "viewAlbumArtistSongTotalVotesByArtistFind"; using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { IDataQuery query = new DataQuery(); query.Where = string.Format(" viewAlbumArtistSongTotalVotesByArtistId={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()) { viewAlbumArtistSongTotalVotesByArtist.ArtistId = Convert.ToInt32(reader["artistId"].ToString()); viewAlbumArtistSongTotalVotesByArtist.Total = Convert.ToInt32(reader["total"].ToString()); viewAlbumArtistSongTotalVotesByArtist.AlbumName = reader["albumName"].ToString(); viewAlbumArtistSongTotalVotesByArtist.ArtistName = reader["artistName"].ToString(); viewAlbumArtistSongTotalVotesByArtist.AlbumCover = reader["albumCover"].ToString(); viewAlbumArtistSongTotalVotesByArtist.Picture = reader["picture"].ToString(); } } } return(viewAlbumArtistSongTotalVotesByArtist); }
public IList <IViewAlbumArtistSongTotalVotesByArtist> GetTop <IViewAlbumArtistSongTotalVotesByArtistQueryParams>(int top, IViewAlbumArtistSongTotalVotesByArtistQueryParams query) { _collection = new List <IViewAlbumArtistSongTotalVotesByArtist>(); string sqlCommand = "viewAlbumArtistSongTotalVotesByArtistGetTop"; 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()) { IViewAlbumArtistSongTotalVotesByArtist viewAlbumArtistSongTotalVotesByArtist = new ViewAlbumArtistSongTotalVotesByArtist(); viewAlbumArtistSongTotalVotesByArtist.ArtistId = Convert.ToInt32(reader["artistId"].ToString()); viewAlbumArtistSongTotalVotesByArtist.Total = Convert.ToInt32(reader["total"].ToString()); viewAlbumArtistSongTotalVotesByArtist.AlbumName = reader["albumName"].ToString(); viewAlbumArtistSongTotalVotesByArtist.ArtistName = reader["artistName"].ToString(); viewAlbumArtistSongTotalVotesByArtist.AlbumCover = reader["albumCover"].ToString(); viewAlbumArtistSongTotalVotesByArtist.Picture = reader["picture"].ToString(); _collection.Add(viewAlbumArtistSongTotalVotesByArtist); } } } return(_collection); }
public IList <IViewAlbumArtistSongTotalVotesByArtist> Find <IViewAlbumArtistSongTotalVotesByArtistQueryParams>(IViewAlbumArtistSongTotalVotesByArtistQueryParams query) { _collection = new List <IViewAlbumArtistSongTotalVotesByArtist>(); string sqlCommand = "viewAlbumArtistSongTotalVotesByArtistFind"; // 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()) { IViewAlbumArtistSongTotalVotesByArtist model = new ViewAlbumArtistSongTotalVotesByArtist(); model.ArtistId = Convert.ToInt32(reader["artistId"].ToString()); model.Total = Convert.ToInt32(reader["total"].ToString()); model.AlbumName = reader["albumName"].ToString(); model.ArtistName = reader["artistName"].ToString(); model.AlbumCover = reader["albumCover"].ToString(); model.Picture = reader["picture"].ToString(); _collection.Add(model); } } } return(_collection); }