public IList <IViewUserTotalVotes> GetTop <IViewUserTotalVotesQueryParams>(int top, IViewUserTotalVotesQueryParams query) { _collection = new List <IViewUserTotalVotes>(); string sqlCommand = "viewUserTotalVotesGetTop"; 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()) { IViewUserTotalVotes viewUserTotalVotes = new ViewUserTotalVotes(); viewUserTotalVotes.BattlId = Convert.ToInt32(reader["battlId"].ToString()); viewUserTotalVotes.SongId = Convert.ToInt32(reader["songId"].ToString()); viewUserTotalVotes.ProfileId = Convert.ToInt32(reader["profileId"].ToString()); viewUserTotalVotes.Total = Convert.ToInt32(reader["total"].ToString()); viewUserTotalVotes.Name = reader["name"].ToString(); viewUserTotalVotes.UsuarioId = Convert.ToInt32(reader["usuarioId"].ToString()); viewUserTotalVotes.Picture = reader["picture"].ToString(); viewUserTotalVotes.SongName = reader["songName"].ToString(); viewUserTotalVotes.Gender = reader["gender"].ToString(); _collection.Add(viewUserTotalVotes); } } } return(_collection); }
public IViewUserTotalVotes GetById(int id) { IViewUserTotalVotes viewUserTotalVotes = new ViewUserTotalVotes(); string sqlCommand = "viewUserTotalVotesFind"; using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { IDataQuery query = new DataQuery(); query.Where = string.Format(" profielId={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()) { viewUserTotalVotes.BattlId = Convert.ToInt32(reader["battlId"].ToString()); viewUserTotalVotes.SongId = Convert.ToInt32(reader["songId"].ToString()); viewUserTotalVotes.ProfileId = Convert.ToInt32(reader["profileId"].ToString()); viewUserTotalVotes.Total = Convert.ToInt32(reader["total"].ToString()); viewUserTotalVotes.Name = reader["name"].ToString(); viewUserTotalVotes.UsuarioId = Convert.ToInt32(reader["usuarioId"].ToString()); viewUserTotalVotes.Picture = reader["picture"].ToString(); viewUserTotalVotes.SongName = reader["songName"].ToString(); viewUserTotalVotes.Gender = reader["gender"].ToString(); } } } return(viewUserTotalVotes); }
public IViewUserTotalVotes Add(IViewUserTotalVotes viewUserTotalVotes) { IViewUserTotalVotes retorno = new ViewUserTotalVotes(); int id = 0; string sqlCommand = "viewUserTotalVotesAdd"; using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { _dataBase.AddInParameter(dbCmd, "@battlId", DbType.Int32, viewUserTotalVotes.BattlId); _dataBase.AddInParameter(dbCmd, "@songId", DbType.Int32, viewUserTotalVotes.SongId); _dataBase.AddInParameter(dbCmd, "@profileId", DbType.Int32, viewUserTotalVotes.ProfileId); _dataBase.AddInParameter(dbCmd, "@total", DbType.Int32, viewUserTotalVotes.Total); _dataBase.AddInParameter(dbCmd, "@name", DbType.String, viewUserTotalVotes.Name); _dataBase.AddInParameter(dbCmd, "@usuarioId", DbType.Int32, viewUserTotalVotes.UsuarioId); _dataBase.AddInParameter(dbCmd, "@picture", DbType.String, viewUserTotalVotes.Picture); _dataBase.AddInParameter(dbCmd, "@songName", DbType.String, viewUserTotalVotes.SongName); _dataBase.AddInParameter(dbCmd, "@gender", DbType.String, viewUserTotalVotes.Gender); id = Convert.ToInt32(_dataBase.ExecuteScalar(dbCmd)); retorno = this.GetById(id); } return(retorno); }
public IList <IViewUserTotalVotes> Find <IViewUserTotalVotesQueryParams>(IViewUserTotalVotesQueryParams query) { _collection = new List <IViewUserTotalVotes>(); string sqlCommand = "viewUserTotalVotesFind"; // 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()) { IViewUserTotalVotes viewUserTotalVotes = new ViewUserTotalVotes(); viewUserTotalVotes.ProfileId = Convert.ToInt32(reader["profileId"].ToString()); viewUserTotalVotes.Total = Convert.ToInt32(reader["total"].ToString()); viewUserTotalVotes.Name = reader["name"].ToString(); viewUserTotalVotes.Picture = reader["picture"].ToString(); _collection.Add(viewUserTotalVotes); } } } return(_collection); }
public IViewUserTotalVotes Update(IViewUserTotalVotes viewUserTotalVotes) { IViewUserTotalVotes viewUserTotalVotesUpdated = new ViewUserTotalVotes(); string sqlCommand = "viewUserTotalVotesUpdate"; using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { _dataBase.AddInParameter(dbCmd, "@battlId", DbType.Int32, viewUserTotalVotes.BattlId); _dataBase.AddInParameter(dbCmd, "@songId", DbType.Int32, viewUserTotalVotes.SongId); _dataBase.AddInParameter(dbCmd, "@profileId", DbType.Int32, viewUserTotalVotes.ProfileId); _dataBase.AddInParameter(dbCmd, "@total", DbType.Int32, viewUserTotalVotes.Total); _dataBase.AddInParameter(dbCmd, "@name", DbType.String, viewUserTotalVotes.Name); _dataBase.AddInParameter(dbCmd, "@usuarioId", DbType.Int32, viewUserTotalVotes.UsuarioId); _dataBase.AddInParameter(dbCmd, "@picture", DbType.String, viewUserTotalVotes.Picture); _dataBase.AddInParameter(dbCmd, "@songName", DbType.String, viewUserTotalVotes.SongName); _dataBase.AddInParameter(dbCmd, "@gender", DbType.String, viewUserTotalVotes.Gender); _dataBase.ExecuteScalar(dbCmd); viewUserTotalVotesUpdated = this.GetById(viewUserTotalVotes.ProfileId); } return(viewUserTotalVotesUpdated); }