public List <CargoDTO> Consultar(string nome)
{
string script = @"SELECT * FROM tb_depto WHERE nm_depto LIKE @nm_depto";
List <MySqlParameter> parms = new List <MySqlParameter>();
parms.Add(new MySqlParameter("nm_depto", nome + "%"));
Database db = new Database();
MySqlDataReader reader = db.ExecuteSelectScript(script, parms);
List <CargoDTO> lista = new List <CargoDTO>();
while (reader.Read())
{
CargoDTO dto = new CargoDTO();
dto.Id = reader.GetInt32("id_depto");
dto.Nome = reader.GetString("nm_depto");
dto.Descricao = reader.GetString("ds_depto");
lista.Add(dto);
}
reader.Close();
return(lista);
}
public int Salvar(CargoDTO dto)
{
string script = @"INSERT INTO tb_depto(nm_depto, ds_depto) VALUES(@nm_depto, @ds_depto)";
List <MySqlParameter> parms = new List <MySqlParameter>();
parms.Add(new MySqlParameter("nm_depto", dto.Nome));
parms.Add(new MySqlParameter("ds_depto", dto.Descricao));
Database db = new Database();
return(db.ExecuteInsertScriptWithPk(script, parms));
}
public int Salvar(CargoDTO dto)
{
CargoDataBase db = new CargoDataBase();
return(db.Salvar(dto));
}