public void InvoiceSearch(SearchWindow window) { string name = window.TxtSearchInvoiceName.Text; string statusId = window.CbSearchInvoiceStatus.Text; List <Objects.Invoice> invoices = new InvoiceCRUD().GetInvoices(); if (!String.IsNullOrEmpty(name)) { invoices.RemoveAll(x => x.InvoiceName != name); } if (!String.IsNullOrEmpty(statusId)) { invoices.RemoveAll(x => x.InvoiceTypeId != Convert.ToInt32(statusId)); } if (invoices.Count > 0) { BindDataGrid(invoices); window.Close(); } else { MessageBox.Show("There are no results", "Information"); } }
private void BtnSubmit_Click(object sender, RoutedEventArgs e) { int result = 0; result = new InvoiceCRUD().Update((Objects.Invoice) this.DataContext); if (result > 0) { this.Close(); MessageBox.Show("Invoice was updated", "Success"); } else { MessageBox.Show("Unable to update invoice", "Failure"); } }
public void BindDataGrid(List <Objects.Invoice> invoices) { if (invoices == null) { invoices = new InvoiceCRUD().GetInvoices(); } List <Objects.InvoiceType> invoiceTypes = new InvoiceCRUD().GetInvoiceTypes(); List <Job> allJobs = new JobCRUD().GetJobs(); if (invoices.Count > 0) { foreach (var inv in invoices) { if (inv.InvoiceTypeId > 0) { inv.InvoiceTypeName = invoiceTypes.Where(x => x.InvoiceTypeId == inv.InvoiceTypeId).First().InvoiceTypeName; } else { inv.InvoiceTypeName = "None"; } try { if (inv.JobId > 0) { inv.JobName = allJobs.Where(x => x.JobId == inv.JobId).First().Name; } else { inv.JobName = "None"; } } catch (Exception ex) { inv.JobName = ""; continue; } } } this.dgData.ItemsSource = invoices; }