public IViewPastBattls GetById(int id) { IViewPastBattls retorno = new ViewPastBattls(); string sqlCommand = "viewPastBattlsFind"; using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { IDataQuery query = new DataQuery(); query.Where = string.Format(" BattlId={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()) { IViewPastBattls viewPastBattls = new ViewPastBattls(); viewPastBattls.BattlId = Convert.ToInt32(reader["battlId"].ToString()); viewPastBattls.FirstArtistId = Convert.ToInt32(reader["firstArtistId"].ToString()); viewPastBattls.FirstSongId = Convert.ToInt32(reader["firstSongId"].ToString()); viewPastBattls.FirstSongName = reader["firstSongName"].ToString(); viewPastBattls.FirstAlbumName = reader["firstAlbumName"].ToString(); viewPastBattls.FirstArtistName = reader["firstArtistName"].ToString(); viewPastBattls.SecondSongId = Convert.ToInt32(reader["secondSongId"].ToString()); viewPastBattls.SecondSongName = reader["secondSongName"].ToString(); viewPastBattls.SecondAlbumName = reader["secondAlbumName"].ToString(); viewPastBattls.SecondArtistName = reader["secondArtistName"].ToString(); viewPastBattls.FirstAlbumCover = reader["firstAlbumCover"].ToString(); viewPastBattls.SecondAlbumCover = reader["secondAlbumCover"].ToString(); viewPastBattls.TotalSecond = Convert.ToInt32(reader["totalSecond"].ToString()); viewPastBattls.TotalFirst = Convert.ToInt32(reader["totalFirst"].ToString()); viewPastBattls.FirstSoundCloudUrl = reader["firstSoundCloudUrl"].ToString(); viewPastBattls.SecondSoundCloudUrl = reader["secondSoundCloudUrl"].ToString(); viewPastBattls.Active = Convert.ToBoolean(reader["active"].ToString()); _collection.Add(viewPastBattls); retorno = viewPastBattls; } } } return(retorno); }
public IList <IViewPastBattls> GetTop <IViewPastBattlsQueryParams>(int top, IViewPastBattlsQueryParams query) { _collection = new List <IViewPastBattls>(); string sqlCommand = "viewPastBattlsGetTop"; 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()) { IViewPastBattls viewPastBattls = new ViewPastBattls(); viewPastBattls.BattlId = Convert.ToInt32(reader["battlId"].ToString()); viewPastBattls.FirstSongId = Convert.ToInt32(reader["firstSongId"].ToString()); viewPastBattls.FirstAlbumId = Convert.ToInt32(reader["firstAlbumId"].ToString()); viewPastBattls.FirstArtistId = Convert.ToInt32(reader["firstArtistId"].ToString()); viewPastBattls.FirstSongName = reader["firstSongName"].ToString(); viewPastBattls.FirstAlbumName = reader["firstAlbumName"].ToString(); viewPastBattls.FirstArtistName = reader["firstArtistName"].ToString(); viewPastBattls.SecondSongId = Convert.ToInt32(reader["secondSongId"].ToString()); viewPastBattls.SecondAlbumId = Convert.ToInt32(reader["secondAlbumId"].ToString()); viewPastBattls.SecondArtistId = Convert.ToInt32(reader["secondArtistId"].ToString()); viewPastBattls.SecondSongName = reader["secondSongName"].ToString(); viewPastBattls.SecondAlbumName = reader["secondAlbumName"].ToString(); viewPastBattls.SecondArtistName = reader["secondArtistName"].ToString(); viewPastBattls.FirstAlbumCover = reader["firstAlbumCover"].ToString(); viewPastBattls.SecondAlbumCover = reader["secondAlbumCover"].ToString(); viewPastBattls.FirstSoundCloudUrl = reader["firstSoundCloudUrl"].ToString(); viewPastBattls.SecondSoundCloudUrl = reader["secondSoundCloudUrl"].ToString(); viewPastBattls.Active = Convert.ToBoolean(reader["active"].ToString()); _collection.Add(viewPastBattls); } } } return(_collection); }
public IList <IViewPastBattls> Find <IViewPastBattlsQueryParams>(IViewPastBattlsQueryParams query) { _collection = new List <IViewPastBattls>(); string sqlCommand = "viewPastBattlsFind"; // 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()) { IViewPastBattls viewPastBattls = new ViewPastBattls(); viewPastBattls.BattlId = Convert.ToInt32(reader["battlId"].ToString()); viewPastBattls.FirstArtistId = Convert.ToInt32(reader["firstArtistId"].ToString()); viewPastBattls.FirstSongName = reader["firstSongName"].ToString(); viewPastBattls.FirstAlbumName = reader["firstAlbumName"].ToString(); viewPastBattls.FirstArtistName = reader["firstArtistName"].ToString(); viewPastBattls.SecondSongId = Convert.ToInt32(reader["secondSongId"].ToString()); viewPastBattls.SecondSongName = reader["secondSongName"].ToString(); viewPastBattls.SecondAlbumName = reader["secondAlbumName"].ToString(); viewPastBattls.SecondArtistName = reader["secondArtistName"].ToString(); viewPastBattls.FirstAlbumCover = reader["firstAlbumCover"].ToString(); viewPastBattls.SecondAlbumCover = reader["secondAlbumCover"].ToString(); viewPastBattls.TotalSecond = Convert.ToInt32(reader["totalSecond"].ToString()); viewPastBattls.TotalFirst = Convert.ToInt32(reader["totalFirst"].ToString()); viewPastBattls.FirstSoundCloudUrl = reader["firstSoundCloudUrl"].ToString(); viewPastBattls.SecondSoundCloudUrl = reader["secondSoundCloudUrl"].ToString(); viewPastBattls.Active = Convert.ToBoolean(reader["active"].ToString()); _collection.Add(viewPastBattls); } } } return(_collection); }