public add() { InitializeComponent(); NORTHWNDEntities1 nw = new NORTHWNDEntities1(); var query = from sp in nw.Suppliers select new { sp.CompanyName }; foreach (var item in query) { SupplierC.Items.Add(item.CompanyName.ToString()); } var result = from ct in nw.Categories select new { ct.CategoryName }; foreach (var item in result) { CategoryC.Items.Add(item.CategoryName.ToString()); } }
public MainWindow() { InitializeComponent(); NORTHWNDEntities1 nw = new NORTHWNDEntities1(); var query = from emp in nw.Employees select new { emp.TitleOfCourtesy, emp.FirstName, emp.LastName }; var result = from ord in nw.Shippers join t in nw.Orders on ord.ShipperID equals t.Shipper.ShipperID select new { ord.ShipperID, ord.CompanyName, t.Customer.ContactName, t.CustomerID, t.Employee.FirstName, t.ShipAddress, t.ShipCity, t.ShipCountry }; this.empDataGrid.ItemsSource = query.ToList(); this.ordDataGrid.ItemsSource = result.ToList(); }
private void Del_Click(object sender, RoutedEventArgs e) { string item = productC.SelectedItem.ToString(); NORTHWNDEntities1 nw = new NORTHWNDEntities1(); var order = from x in nw.Order_Details join v in nw.Products on x.ProductID equals v.ProductID where v.ProductName == item select x; foreach (Order_Detail res in order) { nw.Order_Details.Remove(res); } nw.SaveChanges(); var query = from x in nw.Products where x.ProductName == item select x; Product result = query.SingleOrDefault(); if (result != null) { nw.Products.Remove(result); nw.SaveChanges(); confirmLbl.Content = "Product " + item + " Deleted from Database"; } else { MessageBox.Show("An Error Occured"); } }
private void selc(object sender, SelectionChangedEventArgs e) { NORTHWNDEntities1 nw = new NORTHWNDEntities1(); string cat = ""; var result = from pd in nw.Products join ct in nw.Categories on pd.CategoryID equals ct.CategoryID select new { ct.CategoryName }; foreach (var item in result) { cat = item.CategoryName.ToString(); } CategoryF.Text = cat; var res = from pd in nw.Products join sp in nw.Suppliers on pd.SupplierID equals sp.SupplierID select new { sp.CompanyName }; foreach (var item in res) { cat = item.CompanyName.ToString(); } SupplierF.Text = cat; var query = from pd in nw.Products where pd.ProductName == NameC.SelectedItem select pd; Product p = query.SingleOrDefault(); if (query != null) { //p.Category = new Category() //{ // CategoryName = CategoryF.Text, // CategoryID = 555 //}; //p.Supplier = new Supplier() //{ // SupplierID = 222, // CompanyName = SupplierF.Text //}; //p.UnitPrice = decimal.Parse(PriceF.Text); //p.QuantityPerUnit = QuantityF.Text; } nw.SaveChanges(); }
public delete() { InitializeComponent(); NORTHWNDEntities1 nw = new NORTHWNDEntities1(); var res = from pd in nw.Products select new { pd.ProductName }; foreach (var item in res) { productC.Items.Add(item.ProductName.ToString()); } }
public update() { InitializeComponent(); NORTHWNDEntities1 nw = new NORTHWNDEntities1(); int cat = 0; int sup = 0; var res = from pd in nw.Products select new { pd.ProductName }; foreach (var item in res) { NameC.Items.Add(item.ProductName.ToString()); } }
private void Button_Click(object sender, RoutedEventArgs e) { NORTHWNDEntities1 nw = new NORTHWNDEntities1(); int cat = 0; int sup = 0; var res = from sp in nw.Suppliers where sp.CompanyName == SupplierC.SelectedItem.ToString() select new { sp.SupplierID }; foreach (var item in res) { sup = item.SupplierID; } var result = from ct in nw.Categories where ct.CategoryName == CategoryC.SelectedItem.ToString() select new { ct.CategoryID }; foreach (var item in result) { cat = item.CategoryID; } Console.WriteLine(cat + "" + sup); nw.Products.Add(new Product() { ProductName = NameF.Text, CategoryID = cat, SupplierID = sup, UnitsInStock = short.Parse(QuantityF.Text), UnitPrice = int.Parse(PriceF.Text) }); nw.SaveChanges(); }