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