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);
}
