public ActionResult <Seg_Perfil_Acesso> GetPerfilById([FromHeader] string ibge, [FromRoute] int?id)
{
try
{
ibge = _configuration.GetConnectionString(Connection.GetConnection(ibge));
Seg_Perfil_Acesso item = _Repository.GetPerfilById(ibge, (int)id);
return(Ok(item));
}
catch (Exception ex)
{
var response = TrataErro.GetResponse(ex.Message, true);
return(StatusCode((int)HttpStatusCode.InternalServerError, response));
}
}
public ActionResult Editar([FromHeader] string ibge, [FromBody] Seg_Perfil_Acesso model, [FromRoute] int?id)
{
try
{
ibge = _configuration.GetConnectionString(Connection.GetConnection(ibge));
model.id = id;
_Repository.UpdateSegPerfilAcesso(ibge, model);
return(Ok());
}
catch (Exception ex)
{
var response = TrataErro.GetResponse(ex.Message, true);
return(StatusCode((int)HttpStatusCode.InternalServerError, response));
}
}
public void UpdateSegPerfilAcesso(string ibge, Seg_Perfil_Acesso model)
{
try
{
Helpers.HelperConnection.ExecuteCommand(ibge, conn =>
conn.Execute(_command.UpdateSegPerfilAcesso, new
{
@descricao = model.descricao,
@id = model.id
}));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Inserir([FromHeader] string ibge, [FromBody] Seg_Perfil_Acesso model)
{
try
{
ibge = _configuration.GetConnectionString(Connection.GetConnection(ibge));
var pordescricao = _Repository.GetPerfilByDescricao(ibge, model.descricao);
if (pordescricao != null)
{
return(BadRequest(TrataErro.GetResponse("Já existe um outro perfil cadastrado com a mesma descrição. ", true)));
}
model.id = _Repository.GetPerfilNewId(ibge);
_Repository.InsertSegPerfilAcesso(ibge, model);
return(Ok(model));
}
catch (Exception ex)
{
var response = TrataErro.GetResponse(ex.Message, true);
return(StatusCode((int)HttpStatusCode.InternalServerError, response));
}
}
