/// <summary> /// handles the edit button click, enabling the add items interface. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void editInvoiceButton_Click(object sender, RoutedEventArgs e) { try { if (datePicker.SelectedDate == null) { selectDateErrorLabel.Visibility = (Visibility)0; } else if (invoiceComboBox.SelectedItem == null) { Selecet_Invoice_Error_Label.Visibility = (Visibility)0; } else { clsInvoices selectedInvoice = (clsInvoices)invoiceComboBox.SelectedItem; invoiceDataGrid.ItemsSource = dataGridList; selectDateErrorLabel.Visibility = (Visibility)1; Selecet_Invoice_Error_Label.Visibility = (Visibility)1; addItemsCanvas.IsEnabled = true; invoiceNumberTextBox.Text = selectedInvoice.InvoiceNum; invoiceLookUpCanvas.IsEnabled = false; Total_TextBox.Text = selectedInvoice.TotalCost; ItemInventory.IsEnabled = false; } } catch (Exception ex) { //this is reflection HandleError(MethodInfo.GetCurrentMethod().DeclaringType.Name, MethodInfo.GetCurrentMethod().Name, ex.Message); } }
/// <summary> /// handles the delete invoice button click by deleteing the currently selected invoice. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void deleteInvoiceButton_Click(object sender, RoutedEventArgs e) { try { if (datePicker.SelectedDate == null) { selectDateErrorLabel.Visibility = (Visibility)0; } else if (invoiceComboBox.SelectedItem == null) { Selecet_Invoice_Error_Label.Visibility = (Visibility)0; } else { clsInvoices selectedInvoice = (clsInvoices)invoiceComboBox.SelectedItem; invoiceDataGrid.ItemsSource = dataGridList; selectDateErrorLabel.Visibility = (Visibility)1; Selecet_Invoice_Error_Label.Visibility = (Visibility)1; invoiceNumberTextBox.Text = selectedInvoice.InvoiceNum; mainLogic.DeleteInvoice(selectedInvoice.InvoiceNum); dataGridList.Clear(); invoiceDataGrid.ItemsSource = dataGridList; itemsComboBox.Text = ""; invoiceComboBox.Text = ""; datePicker.Text = "Please select a date"; invoice_Deleted_Label.Visibility = (Visibility)0; } } catch (Exception ex) { //this is reflection HandleError(MethodInfo.GetCurrentMethod().DeclaringType.Name, MethodInfo.GetCurrentMethod().Name, ex.Message); } }
/// <summary> /// Handles the Search Invoices menu item click. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SearchInvoices_Click(object sender, RoutedEventArgs e) { try { wndSearch wndSearch = new wndSearch(); wndSearch.ShowDialog(); if (MainWndwInvoice.InvoiceNum != null) { var DateTime = Convert.ToDateTime(MainWndwInvoice.InvoiceDate); clsInvoices[] list = new clsInvoices[1]; list[0] = MainWndwInvoice; datePicker.SelectedDate = DateTime; invoiceComboBox.SelectedItem = MainWndwInvoice.InvoiceNum; invoiceComboBox.ItemsSource = list; dataGridList = mainLogic.PopulateLineItemsOnInvoiceNum(MainWndwInvoice.InvoiceNum); invoiceDataGrid.ItemsSource = dataGridList; } } catch (Exception ex) { //this is reflection HandleError(MethodInfo.GetCurrentMethod().DeclaringType.Name, MethodInfo.GetCurrentMethod().Name, ex.Message); } }
/// <summary> /// Inserts data into the LineItems table /// </summary> /// <param name="InvoicedItems"></param> private void AddLineItems(ObservableCollection <Item> InvoicedItems) { //string invoiceNum, int lineItemNum, string itemCode try { clsInvoices invoice = GetMaxInvoice(); foreach (Item item in InvoicedItems) // add LineItem to DB { int LineItemNum = 1; int row = db.ExecuteNonQuery(SQL.InsertLineItems(invoice.InvoiceNum, LineItemNum.ToString(), item.itemCode)); LineItemNum++; } } catch (Exception ex) { //this is reflection for exception handling throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message); } }
/// <summary> /// Returns the invoice with the highest invoice number /// </summary> /// <returns></returns> private clsInvoices GetMaxInvoice() { try { clsInvoices invoice = new clsInvoices(); int iRet = 0; //Number of return values DataSet ds = new DataSet(); //Holds the return values ds = db.ExecuteSQLStatement(SQL.SelectMaxInvoice(), ref iRet); invoice.InvoiceNum = ds.Tables[0].Rows[0][0].ToString(); invoice.InvoiceDate = ds.Tables[0].Rows[0][1].ToString(); invoice.TotalCost = ds.Tables[0].Rows[0]["TotalCost"].ToString(); return(invoice); } catch (Exception ex) { //this is reflection for exception handling throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message); } }
/// <summary> /// Constructor for main window and application entry point. /// </summary> public MainWindow() { try { InitializeComponent(); mainLogic = new clsMainLogic(); Application.Current.ShutdownMode = ShutdownMode.OnMainWindowClose;//close the application when the main window is closed //Maybe delete this line. MainWndwInvoice = new clsInvoices(); dataGridList = new ObservableCollection <Item>(); itemsWindow = new wndItems(); SearchWindow = new wndSearch(); //this.Hide(); //temporary for austin's development //itemsWindow.Show(); //temporary for austin's development } catch (Exception ex) { //this is reflection HandleError(MethodInfo.GetCurrentMethod().DeclaringType.Name, MethodInfo.GetCurrentMethod().Name, ex.Message); } }