public List <HistoricoDTO> Consultar(string animal) { string script = @"SELECT * FROM tb_historico WHERE id_animal LIKE @id_animal"; List <MySqlParameter> parms = new List <MySqlParameter>(); parms.Add(new MySqlParameter("id_animal", animal + "%")); Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, null); List <HistoricoDTO> lista = new List <HistoricoDTO>(); while (reader.Read()) { HistoricoDTO dto = new HistoricoDTO(); dto.IdAnimal = reader.GetInt32("id_animal"); lista.Add(dto); } reader.Close(); return(lista); }
public void Alterar(HistoricoDTO histo) { string script = @"UPDATE tb_historicoAnimal SET id_animal = @id_animal, id_vacina = @id_vacina, id_funcionario = @id_funcionario, ds_dose = @ds_dose WHERE id_historico = @id_historico"; List <MySqlParameter> parms = new List <MySqlParameter>(); parms.Add(new MySqlParameter("id_animal", histo.IdAnimal)); parms.Add(new MySqlParameter("id_vacina", histo.IdVacina)); parms.Add(new MySqlParameter("id_funcionario", histo.IdFuncionario)); parms.Add(new MySqlParameter("ds_dose", histo.Dose)); Database db = new Database(); db.ExecuteInsertScriptWithPk(script, parms); }
public List <HistoricoDTO> Listar() { string script = @"SELECT * FROM tb_historico"; Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, null); List <HistoricoDTO> lista = new List <HistoricoDTO>(); while (reader.Read()) { HistoricoDTO add = new HistoricoDTO(); add.IdAnimal = reader.GetInt32("id_animal"); add.IdVacina = reader.GetInt32("id_vacina"); add.IdFuncionario = reader.GetInt32("id_funcionario"); add.Dose = reader.GetString("ds_dose"); lista.Add(add); } reader.Close(); return(lista); }
public int Salvar(HistoricoDTO histo) { string script = @"INSERT INTO (id_animal, id_vacina, id_funcionario, ds_dose) VALUES ( @id_animal, @id_vacina, @id_funcionario, @ds_dose)"; List <MySqlParameter> parms = new List <MySqlParameter>(); parms.Add(new MySqlParameter("id_animal", histo.IdAnimal)); parms.Add(new MySqlParameter("id_vacina", histo.IdVacina)); parms.Add(new MySqlParameter("id_funcionario", histo.IdFuncionario)); parms.Add(new MySqlParameter("ds_dose", histo.Dose)); Database db = new Database(); int pk = db.ExecuteInsertScriptWithPk(script, parms); return(pk); }