public static CargoModel RecuperarPeloId(int id)
{
CargoModel ret = null;
using (var conexao = new NpgsqlConnection())
{
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
conexao.Open();
using (var comando = new NpgsqlCommand())
{
comando.Connection = conexao;
comando.CommandText = "select * from cargo_funcao where (id =@id)";
comando.Parameters.Add("@id", NpgsqlDbType.Integer).Value = id;
var reader = comando.ExecuteReader();
if (reader.Read())
{
ret = new CargoModel
{
Id = (int)reader["id"],
Cargo = (string)reader["cargo"],
};
}
}
}
return(ret);
}
private bool IncluirRegistro(CargoModel model, NpgsqlConnection conexao)
{
var queryResult = $@"insert into cargo_funcao (cargo) values (@Cargo)";
using (var comando = new NpgsqlCommand(queryResult, conexao))
{
if (model == null)
{
comando.Parameters.AddWithValue("Cargo", NpgsqlDbType.Varchar, this.Cargo);
comando.Prepare();
comando.ExecuteNonQuery();
return(true);
}
}
return(false);
}
private bool Update(CargoModel model, NpgsqlConnection conexao)
{
var queryResult = $@"update cargo_funcao
set cargo = @Cargo
where
id = @Id";
using (var comando = new NpgsqlCommand(queryResult, conexao))
{
comando.Parameters.AddWithValue("Cargo", NpgsqlDbType.Varchar, model.Cargo);
comando.Parameters.AddWithValue("Id", NpgsqlDbType.Integer, model.Id);
comando.Prepare();
if (comando.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
}