public IEnumerable <Video> RetornarTodosVideosServidor(Guid serverId)
{
var video = new Video()
{
IdServidor = serverId
};
string sql = GenericQuerys.GerarSelectQuery(video, "Video", "ORDER BY DATACADASTRO DESC");
return(_conn.Query <Video>(sql, video, _trans));
}
public IEnumerable <ServidorCustomDTO> RetornarDadosServidor(Guid id)
{
var servidor = new Servidor()
{
Id = id
};
string sql = GenericQuerys.GerarSelectQuery(servidor, "SERVIDOR", "ORDER BY NOME");
return(_conn.Query <ServidorCustomDTO>(sql, servidor, _trans));
}
public IEnumerable <Video> RetornarDadosVideo(Guid id, Guid serverId)
{
var video = new Video()
{
Id = id, IdServidor = serverId
};
string sql = GenericQuerys.GerarSelectQuery(video, "Video", "");
return(_conn.Query <Video>(sql, video, _trans));
}
public IEnumerable <ServidorDTO> RetornarListaServidores()
{
string sql = GenericQuerys.GerarSelectQuery(new Servidor(), "SERVIDOR", "ORDER BY NOME");
return(_conn.Query <ServidorDTO>(sql, null, _trans));
}