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