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);
}
