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));
}
public void DeletarServidor(Guid id, string tabela)
{
string sqlDelete = GenericQuerys.GerarDeleteQuery(id, tabela);
_conn.ExecuteScalar(sqlDelete, null, _trans);
}
public void InserirServidor(Servidor servidor)
{
string InsertQuery = GenericQuerys.GerarInsertQuery(servidor, "SERVIDOR");
_conn.ExecuteScalar(InsertQuery, servidor, _trans);
}
public void RemoverVideo(Guid id)
{
string sqlDelete = GenericQuerys.GerarDeleteQuery(id, "Video");
_conn.Execute(sqlDelete, null, _trans);
}
public void InserirVideo(Video video)
{
string sqlInsert = GenericQuerys.GerarInsertQuery(video, "Video");
_conn.ExecuteScalar(sqlInsert, video, _trans);
}
