public List <ServicoView> Consultar(string nome, string data) { string script = @"SELECT * FROM vw_servico WHERE nm_animal LIKE @nm_animal AND dt_duracao LIKE @ dt_duracao"; List <MySqlParameter> parms = new List <MySqlParameter>(); parms.Add(new MySqlParameter("nm_animal", nome + "%")); parms.Add(new MySqlParameter("dt_duracao", data + "%")); Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, null); List <ServicoView> lista = new List <ServicoView>(); while (reader.Read()) { ServicoView add = new ServicoView(); add.Id = reader.GetInt32("id_servico"); add.Animal = reader.GetString("nm_animal"); add.Cliente = reader.GetString("nm_nome"); add.Data = reader.GetString("dt_duracao"); add.Servico = reader.GetString("ds_servico"); add.Valor = reader.GetDecimal("ds_valor"); lista.Add(add); } reader.Close(); return(lista); }
public List <ServicoView> Listar() { string script = @"SELECT * FROM vw_servico"; Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, null); List <ServicoView> lista = new List <ServicoView>(); while (reader.Read()) { ServicoView add = new ServicoView(); add.Id = reader.GetInt32("id_servico"); add.Animal = reader.GetString("nm_animal"); add.Cliente = reader.GetString("nm_nome"); add.Data = reader.GetString("dt_duracao"); add.Servico = reader.GetString("ds_servico"); add.Valor = reader.GetDecimal("ds_valor"); lista.Add(add); } reader.Close(); return(lista); }