public IViewBattlResults GetById(int id) { IViewBattlResults viewBattlResults = new ViewBattlResults(); string sqlCommand = "viewBattlResultsFind"; using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { IDataQuery query = new DataQuery(); query.Where = string.Format(" viewBattlResultsId = {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()) { viewBattlResults.BattlId = Convert.ToInt32(reader["battlId"].ToString()); viewBattlResults.FirstSongId = Convert.ToInt32(reader["firstSongId"].ToString()); viewBattlResults.SecondSongId = Convert.ToInt32(reader["secondSongId"].ToString()); viewBattlResults.ArtistNameSecond = reader["artistNameSecond"].ToString(); viewBattlResults.ArtistNameFirst = reader["artistNameFirst"].ToString(); viewBattlResults.TotalSecond = Convert.ToInt32(reader["totalSecond"].ToString()); viewBattlResults.TotalFirst = Convert.ToInt32(reader["totalFirst"].ToString()); viewBattlResults.ProfileId = Convert.ToInt32(reader["profileId"].ToString()); viewBattlResults.Active = Convert.ToBoolean(reader["active"].ToString()); } } } return(viewBattlResults); }
public IList <IViewBattlResults> GetTop <IViewBattlResultsQueryParams>(int top, IViewBattlResultsQueryParams query) { _collection = new List <IViewBattlResults>(); string sqlCommand = "viewBattlResultsGetTop"; 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()) { IViewBattlResults viewBattlResults = new ViewBattlResults(); viewBattlResults.BattlId = Convert.ToInt32(reader["battlId"].ToString()); viewBattlResults.FirstSongId = Convert.ToInt32(reader["firstSongId"].ToString()); viewBattlResults.SecondSongId = Convert.ToInt32(reader["secondSongId"].ToString()); viewBattlResults.ArtistNameSecond = reader["artistNameSecond"].ToString(); viewBattlResults.ArtistNameFirst = reader["artistNameFirst"].ToString(); viewBattlResults.TotalSecond = Convert.ToInt32(reader["totalSecond"].ToString()); viewBattlResults.TotalFirst = Convert.ToInt32(reader["totalFirst"].ToString()); viewBattlResults.ProfileId = Convert.ToInt32(reader["profileId"].ToString()); viewBattlResults.Active = Convert.ToBoolean(reader["active"].ToString()); _collection.Add(viewBattlResults); } } } return(_collection); }
public IList <IViewBattlResults> Find <IViewBattlResultsQueryParams>(IViewBattlResultsQueryParams query) { _collection = new List <IViewBattlResults>(); string sqlCommand = "viewBattlResultsFind"; // 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); // Call the ExecuteReader method with the command. using (IDataReader reader = _dataBase.ExecuteReader(dbCmd)) { while (reader.Read()) { IViewBattlResults viewBattlResults = new ViewBattlResults(); viewBattlResults.BattlId = Convert.ToInt32(reader["battlId"].ToString()); viewBattlResults.FirstSongId = Convert.ToInt32(reader["firstSongId"].ToString()); viewBattlResults.SecondSongId = Convert.ToInt32(reader["secondSongId"].ToString()); viewBattlResults.ArtistNameSecond = reader["artistNameSecond"].ToString(); viewBattlResults.ArtistNameFirst = reader["artistNameFirst"].ToString(); viewBattlResults.TotalSecond = Convert.ToInt32(reader["totalSecond"].ToString()); viewBattlResults.TotalFirst = Convert.ToInt32(reader["totalFirst"].ToString()); viewBattlResults.ProfileId = Convert.ToInt32(reader["profileId"].ToString()); viewBattlResults.Active = Convert.ToBoolean(reader["active"].ToString()); _collection.Add(viewBattlResults); } } } return(_collection); }