public async Task <IHttpActionResult> Remove([FromBody] QuadroModel model)
{
object result = await repository.Remove(rhNetContext, model);
if (result.GetType() == typeof(QuadroModel))
{
return(Ok(result));
}
else
{
return(BadRequest(result.ToString()));
}
}
public async Task <IHttpActionResult> Update([FromBody] QuadroModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
object result = await repository.Update(rhNetContext, model);
if (result.GetType() == typeof(QuadroModel))
{
return(Ok(result));
}
else
{
return(BadRequest(result.ToString()));
}
}
public async Task <QuadroModel> Get(RhNetContext rhNetContext, int id)
{
QuadroModel quadroModel = await(from x in rhNetContext.Quadros
where x.Id == id
orderby x.Descricao
select new QuadroModel()
{
Descricao = x.Descricao,
Id = x.Id
}).FirstOrDefaultAsync();
if (quadroModel == null)
{
return(null);
}
quadroModel.Subquadros = await(from x in rhNetContext.Subquadros
where x.Quadro_Id == quadroModel.Id
select new SubquadroModel()
{
Id = x.Id,
Descricao = x.Descricao,
Sigla = x.Sigla
}).ToListAsync();
quadroModel.Atos_Normativos = await(from x in rhNetContext.Quadros_Atos_Normativos
from y in rhNetContext.Atos_Normativos.Where(e => e.Id == x.Ato_Normativo_Id)
from z in rhNetContext.Tipos_de_Ato_Normativo.Where(e => e.Id == y.Tipo_de_Ato_Normativo_Id)
where x.Quadro_Id == quadroModel.Id
select new Ato_NormativoModel()
{
Id = y.Id,
Descricao = y.Descricao,
Ano = y.Ano,
Numero = y.Numero,
Publicacao_Data = y.Publicacao_Data,
Vigencia_Data = y.Vigencia_Data,
Tipo_de_Ato_Normativo_Id = z.Id,
Tipo_de_Ato_Normativo_Descricao = z.Descricao
}).ToListAsync();
return(quadroModel);
}
public async Task <Object> Remove(RhNetContext rhNetContext, QuadroModel quadroModel)
{
Quadro quadro = await rhNetContext.Quadros.FindAsync(quadroModel.Id);
if (quadro == null)
{
return("Quadro não encontrado.");
}
try
{
rhNetContext.Entry(quadro).State = EntityState.Deleted;
await rhNetContext.SaveChangesAsync();
return(quadroModel);
}
catch (DbUpdateException ex)
{
return(ex.InnerException.ToString());
}
}
public async Task <object> Add(RhNetContext rhNetContext, QuadroModel quadroModel)
{
Quadro quadro = new Quadro()
{
Descricao = quadroModel.Descricao
};
try
{
rhNetContext.Entry(quadro).State = EntityState.Added;
await rhNetContext.SaveChangesAsync();
await rhNetContext.Entry(quadro).ReloadAsync();
quadroModel.Id = quadro.Id;
return(quadroModel);
}
catch (DbUpdateException ex)
{
return(ex.InnerException.ToString());
}
}
public async Task <ActionResult> Remove([FromServices] RhNetContext rhNetContext, [FromBody] QuadroModel quadroModel)
{
QuadroRepository repository = new QuadroRepository();
object result = await repository.Remove(rhNetContext, quadroModel);
if (result.GetType() == typeof(QuadroModel))
{
return(Ok(result));
}
else
{
return(BadRequest(result.ToString()));
}
}
