public IList <IViewUserFavoritesSongs> GetTop <IViewUserFavoritesSongsQueryParams>(int top, IViewUserFavoritesSongsQueryParams query) { _collection = new List <IViewUserFavoritesSongs>(); string sqlCommand = "viewUserFavoritesSongsGetTop"; 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()) { IViewUserFavoritesSongs viewUserFavoritesSongs = new ViewUserFavoritesSongs(); viewUserFavoritesSongs.SongId = Convert.ToInt32(reader["songId"].ToString()); viewUserFavoritesSongs.UsuarioId = Convert.ToInt32(reader["usuarioId"].ToString()); viewUserFavoritesSongs.ProfileId = Convert.ToInt32(reader["profileId"].ToString()); viewUserFavoritesSongs.TotalSong = Convert.ToInt32(reader["totalSong"].ToString()); viewUserFavoritesSongs.AlbumId = Convert.ToInt32(reader["albumId"].ToString()); viewUserFavoritesSongs.ArtistId = Convert.ToInt32(reader["artistId"].ToString()); viewUserFavoritesSongs.AlbumCover = reader["albumCover"].ToString(); viewUserFavoritesSongs.AlbumName = reader["albumName"].ToString(); viewUserFavoritesSongs.ArtistName = reader["artistName"].ToString(); viewUserFavoritesSongs.SongName = reader["songName"].ToString(); _collection.Add(viewUserFavoritesSongs); } } } return(_collection); }
public IViewUserFavoritesSongs Add(IViewUserFavoritesSongs viewUserFavoritesSongs) { IViewUserFavoritesSongs viewUserFavoritesSongsAdded = new ViewUserFavoritesSongs(); int id = 0; string sqlCommand = "viewUserFavoritesSongsAdd"; using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { _dataBase.AddInParameter(dbCmd, "@songId", DbType.Int32, viewUserFavoritesSongs.SongId); _dataBase.AddInParameter(dbCmd, "@usuarioId", DbType.Int32, viewUserFavoritesSongs.UsuarioId); _dataBase.AddInParameter(dbCmd, "@profileId", DbType.Int32, viewUserFavoritesSongs.ProfileId); _dataBase.AddInParameter(dbCmd, "@totalSong", DbType.Int32, viewUserFavoritesSongs.TotalSong); _dataBase.AddInParameter(dbCmd, "@albumId", DbType.Int32, viewUserFavoritesSongs.AlbumId); _dataBase.AddInParameter(dbCmd, "@artistId", DbType.Int32, viewUserFavoritesSongs.ArtistId); _dataBase.AddInParameter(dbCmd, "@albumCover", DbType.String, viewUserFavoritesSongs.AlbumCover); _dataBase.AddInParameter(dbCmd, "@albumName", DbType.String, viewUserFavoritesSongs.AlbumName); _dataBase.AddInParameter(dbCmd, "@artistName", DbType.String, viewUserFavoritesSongs.ArtistName); _dataBase.AddInParameter(dbCmd, "@songName", DbType.String, viewUserFavoritesSongs.SongName); id = Convert.ToInt32(_dataBase.ExecuteScalar(dbCmd)); viewUserFavoritesSongsAdded = this.GetById(id); } return(viewUserFavoritesSongsAdded); }
public IViewUserFavoritesSongs GetById(int id) { IViewUserFavoritesSongs viewUserFavoritesSongs = new ViewUserFavoritesSongs(); string sqlCommand = "viewUserFavoritesSongsFind"; using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { IDataQuery query = new DataQuery(); query.Where = string.Format(" viewUserFavoritesSongsId = {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()) { viewUserFavoritesSongs.SongId = Convert.ToInt32(reader["songId"].ToString()); viewUserFavoritesSongs.UsuarioId = Convert.ToInt32(reader["usuarioId"].ToString()); viewUserFavoritesSongs.ProfileId = Convert.ToInt32(reader["profileId"].ToString()); viewUserFavoritesSongs.TotalSong = Convert.ToInt32(reader["totalSong"].ToString()); viewUserFavoritesSongs.AlbumId = Convert.ToInt32(reader["albumId"].ToString()); viewUserFavoritesSongs.ArtistId = Convert.ToInt32(reader["artistId"].ToString()); viewUserFavoritesSongs.AlbumCover = reader["albumCover"].ToString(); viewUserFavoritesSongs.AlbumName = reader["albumName"].ToString(); viewUserFavoritesSongs.ArtistName = reader["artistName"].ToString(); viewUserFavoritesSongs.SongName = reader["songName"].ToString(); } } } return(viewUserFavoritesSongs); }
public IList <IViewUserFavoritesSongs> Find <IViewUserFavoritesSongsQueryParams>(IViewUserFavoritesSongsQueryParams query) { _collection = new List <IViewUserFavoritesSongs>(); string sqlCommand = "viewUserFavoritesSongsFind"; // 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()) { IViewUserFavoritesSongs viewUserFavoritesSongs = new ViewUserFavoritesSongs(); viewUserFavoritesSongs.SongId = Convert.ToInt32(reader["songId"].ToString()); viewUserFavoritesSongs.ProfileId = Convert.ToInt32(reader["profileId"].ToString()); viewUserFavoritesSongs.TotalSong = Convert.ToInt32(reader["totalSong"].ToString()); viewUserFavoritesSongs.AlbumId = Convert.ToInt32(reader["albumId"].ToString()); viewUserFavoritesSongs.ArtistId = Convert.ToInt32(reader["artistId"].ToString()); viewUserFavoritesSongs.AlbumCover = reader["albumCover"].ToString(); viewUserFavoritesSongs.AlbumName = reader["albumName"].ToString(); viewUserFavoritesSongs.ArtistName = reader["artistName"].ToString(); viewUserFavoritesSongs.SongName = reader["songName"].ToString(); _collection.Add(viewUserFavoritesSongs); } } } return(_collection); }