public IEnumerable <ClienteDomain> GetAll(ClienteArgs args)
{
List <ClienteDomain> retorno = new List <ClienteDomain>();
using (SqlConnection conn = new SqlConnection(SqlConnectionString))
{
try
{
conn.Open();
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandType = CommandType.Text;
comm.CommandText = " SELECT * FROM CLIENTE WHERE ID > 0 ";
if (args.Id > 0)
{
comm.CommandText += " AND ID = @ID ";
comm.Parameters.Add(new SqlParameter("@ID", args.Id));
}
if (!string.IsNullOrEmpty(args.Nome))
{
comm.CommandText += " AND NOME = @NOME ";
comm.Parameters.Add(new SqlParameter("@NOME", args.Nome));
}
using (SqlDataReader reader = comm.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var cliente = new ClienteDomain();
cliente.Id = int.Parse(reader["ID"].ToString());
cliente.Nome = reader["NOME"].ToString();
cliente.Idade = short.Parse(reader["IDADE"].ToString());
cliente.Email = reader["EMAIL"].ToString();
cliente.DataNascimento = DateTime.Parse(reader["DATANASCIMENTO"].ToString());
retorno.Add(cliente);
}
}
}
}
return(retorno);
}
catch (Exception ex)
{
throw new Exception($"{ex.Message} - {ex.StackTrace}");
}
finally
{
conn.Close();
}
}
}
public IEnumerable <ClienteDomain> GetAll(ClienteArgs args)
{
return(repository.GetAll(args));
}
