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