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