private void NakliyeleriGetir()
{
NorthwindSabahEntities db = new NorthwindSabahEntities();
var nakliyeler = db.Shippers
.OrderBy(x => x.CompanyName)
.ToList();
cmbNakliye.DataSource = nakliyeler;
cmbNakliye.DisplayMember = "CompanyName";
}
private void MusterileriGetir()
{
NorthwindSabahEntities db = new NorthwindSabahEntities();
var musteriler = db.Customers
.OrderBy(x => x.CompanyName)
.ToList();
cmbMusteri.DataSource = musteriler;
cmbMusteri.DisplayMember = "CompanyName";
}
private void UrunleriGetir()
{
NorthwindSabahEntities db = new NorthwindSabahEntities();
var urunler = db.Products
.OrderBy(x => x.ProductName)
.Select(x => new ProductViewModel()
{
ProductId = x.ProductID,
ProductName = x.ProductName,
UnitPrice = x.UnitPrice
})
.ToList();
lstUrunler.DataSource = urunler;
}
private void CalisanlariGetir()
{
NorthwindSabahEntities db = new NorthwindSabahEntities();
var calisanlar = db.Employees
.OrderBy(x => x.FirstName)
.Select(x => new EmployeeViewModel
{
EmployeeID = x.EmployeeID,
FirstName = x.FirstName,
LastName = x.LastName
})
.ToList();
cmbCalisan.DataSource = calisanlar;
}
private void txtAra_KeyUp(object sender, KeyEventArgs e)
{
string ara = txtAra.Text.ToLower();
NorthwindSabahEntities db = new NorthwindSabahEntities();
List <ProductViewModel> bulunanlar = new List <ProductViewModel>();
db.Products
.Where(x => x.ProductName.ToLower().Contains(ara) || x.Category.CategoryName.ToLower().Contains(ara))
.ToList()
.ForEach(x => bulunanlar.Add(new ProductViewModel()
{
ProductId = x.ProductID,
ProductName = x.ProductName,
UnitPrice = x.UnitPrice
}));
lstUrunler.DataSource = bulunanlar;
}
