private void btnSelect_Click(object sender, RoutedEventArgs e)
{
var fabr = new Negocio.Fabricante().Select();
dataGrid.ItemsSource = null;
dataGrid.ItemsSource = fabr.OrderBy(f => f.Descricao);
}
static void Main(string[] args)
{
List <Modelo.Fabricante> fabricantes = new Negocio.Fabricante().Select();
List <Modelo.Veiculo> veiculos = new Negocio.Veiculo().Select();
foreach (Modelo.Fabricante f in fabricantes)
{
var propfab = GetProperties(f);
foreach (var p in propfab)
{
Console.Write(p.GetValue(f) + " - ");
}
Console.WriteLine();
}
foreach (Modelo.Veiculo v in veiculos)
{
var propvec = GetProperties(v);
foreach (var p in propvec)
{
Console.Write(p.GetValue(v) + " - ");
}
Console.WriteLine();
}
}
private void SetFabricantes()
{
var fabr = new Negocio.Fabricante().Select();
cmbFabricantes.ItemsSource = null;
cmbFabricantes.ItemsSource = fabr.OrderBy(f => f.Descricao);
cmbFabricantes.DisplayMemberPath = "Descricao";
cmbFabricantes.SelectedValuePath = "Id";
}
private void btnListar_Click(object sender, RoutedEventArgs e)
{
var veiculos = new Negocio.Veiculo().SelectDisponiveis();
var fabricantes = new Negocio.Fabricante().Select();
var vplusf = from v in veiculos
join fab in fabricantes on v.IdFabricante equals fab.Id
select new
{
id = v.Id,
modelo = v.Modelo,
ano = v.Ano,
dtCompra = v.DataCompra,
vCompra = v.ValorCompra,
desc = fab.Descricao,
idFab = fab.Id
};
dataGrid.ItemsSource = null;
dataGrid.ItemsSource = vplusf.OrderBy(desc => desc.desc).ThenBy(mode => mode.modelo);
}
