private void SelectClicked(object sender, RoutedEventArgs e) { using (GCCL_Part_DatabaseEntities context = new GCCL_Part_DatabaseEntities()) { //Build dynamic query IQueryable <GCCL> query = context.Set <GCCL>(); if (GCCLNumber.Text != string.Empty) { int GCCLPartNumber = Int32.Parse(GCCLNumber.Text); query = query.Where(s => s.GCCL1 == GCCLPartNumber); } if (PartNumberTextField.Text != string.Empty) { query = query.Where(s => s.Part_Number == PartNumberTextField.Text); } if (ManufacutrerTextField.Text != string.Empty) { query = query.Where(s => s.Manufacturer == ManufacutrerTextField.Text); } if (DesciptionTextFiled.Text != string.Empty) { query = query.Where(s => s.Description.Contains(DesciptionTextFiled.Text)); } var queryResult = query.ToList <GCCL>(); ReportWindow secWindow = new ReportWindow(queryResult); secWindow.Show(); } }
private void ApplyMessage_Click(object sender, RoutedEventArgs e) { if (GCCLNumber.Text.Length < 1) { MessageBox.Show("GCCL number missing"); } else { using (GCCL_Part_DatabaseEntities context = new GCCL_Part_DatabaseEntities()) { try { int GCCLPartNumber = Int32.Parse(GCCLNumber.Text); GCCL gccl = new GCCL { GCCL1 = GCCLPartNumber, Part_Number = PartNumberTextField.Text, Manufacturer = ManufacutrerTextField.Text, Description = DesciptionTextFiled.Text }; context.GCCLs.Add(gccl); context.SaveChanges(); //Messagebox has no overload that formats ouput string MessageBox.Show(String.Format("GCCL item {0} Added", GCCLPartNumber)); GCCLNumber.Clear(); PartNumberTextField.Clear(); ManufacutrerTextField.Clear(); DesciptionTextFiled.Clear(); } catch (FormatException) { MessageBox.Show("GCCL not a number"); GCCLNumber.Clear(); } } } }