private void buttonCliSearch_Click(object sender, EventArgs e) { int choice = comboBoxCliSearch.SelectedIndex; switch (choice) { case -1: MessageBox.Show("Please select the search option"); break; case 0: //Search by Client Name Clients Cli = ClientsDA.Search(textBoxCliSearch.Text); if (Cli != null) { textBoxCliName.Text = Cli.clientName; maskedTextBoxCliPhone.Text = Cli.phoneNumber; textBoxCliCity.Text = Cli.city; textBoxCliPostalCode.Text = Cli.postalCode; textBoxCliStreet.Text = Cli.street; textBoxCliCredit.Text = Cli.creditLimit.ToString(); buttonCliDelete.Enabled = true; buttonCliUpdate.Enabled = true; } else { MessageBox.Show("Client not Found!"); textBoxCliSearch.Clear(); textBoxCliSearch.Focus(); } break; case 1: //Search by Client City Clients CliCity = ClientsDA.SearchByCity(textBoxCliSearch.Text); if (CliCity != null) { textBoxCliName.Text = CliCity.clientName; maskedTextBoxCliPhone.Text = CliCity.phoneNumber; textBoxCliCity.Text = CliCity.city; textBoxCliPostalCode.Text = CliCity.postalCode; textBoxCliStreet.Text = CliCity.street; textBoxCliCredit.Text = CliCity.creditLimit.ToString(); buttonCliDelete.Enabled = true; buttonCliUpdate.Enabled = true; } else { MessageBox.Show("Client not Found!"); textBoxCliSearch.Clear(); textBoxCliSearch.Focus(); } break; default: break; } }
private void buttonOrdUpdate_Click(object sender, EventArgs e) { if (!Validator.IsEmpty(textBoxOrdQuantity)) { MessageBox.Show("Orders must have a valid quantity.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error); textBoxAutID.Clear(); textBoxAutID.Focus(); return; } Order aorder = createOrder(); Order xorder = OrderDA.SearchByNumber(Convert.ToInt32(textBoxOrdNumber.Text)); Books abook = BooksDA.SearchByTitle(comboBoxOrdProduct.Text); Clients aclient = ClientsDA.Search(comboBoxOrdClient.Text); abook.QOH = (abook.QOH + xorder.OrdQuantity) - aorder.OrdQuantity; BooksDA.Update(abook); aclient.creditLimit = (aclient.creditLimit + aorder.OrdTotal) - aorder.OrdTotal; ClientsDA.Update(aclient); OrderDA.Update(aorder); OrderDA.ListOrder(listViewOrd); buttonOrdList.PerformClick(); UpdateComboBoxes(); }
private void listViewOrd_MouseClick(object sender, MouseEventArgs e) { string OrdNumber = listViewOrd.SelectedItems[0].SubItems[0].Text; string OrdEmployee = listViewOrd.SelectedItems[0].SubItems[1].Text; string OrdClient = ClientsDA.Search(listViewOrd.SelectedItems[0].SubItems[2].Text).clientName; string OrdProduct = BooksDA.SearchByTitle(listViewOrd.SelectedItems[0].SubItems[3].Text).title; string OrdQuantity = listViewOrd.SelectedItems[0].SubItems[4].Text; string OrdTotal = listViewOrd.SelectedItems[0].SubItems[5].Text; string OrdDate = listViewOrd.SelectedItems[0].SubItems[6].Text; string OrdPhoneNumber = ClientsDA.Search(listViewOrd.SelectedItems[0].SubItems[2].Text).phoneNumber; string OrdCreditLimit = ClientsDA.Search(listViewOrd.SelectedItems[0].SubItems[2].Text).creditLimit.ToString(); string OrdAddress = (ClientsDA.Search(listViewOrd.SelectedItems[0].SubItems[2].Text).postalCode) + ", " + (ClientsDA.Search(listViewOrd.SelectedItems[0].SubItems[2].Text).street); string OrdUnitPrice = BooksDA.SearchByTitle(listViewOrd.SelectedItems[0].SubItems[3].Text).unitPrice.ToString(); textBoxOrdNumber.Text = OrdNumber; textBoxOrdClient.Text = OrdClient; comboBoxOrdProduct.Text = OrdProduct; textBoxOrdQuantity.Text = OrdQuantity; textBoxOrdTotal.Text = OrdTotal; dateTimePicker1.Text = OrdDate; textBoxOrdPhoneNumber.Text = OrdPhoneNumber; textBoxOrdCreditLimit.Text = OrdCreditLimit; textBoxOrdAdress.Text = OrdAddress; textBoxOrdUnitPrice.Text = OrdUnitPrice; buttonOrdDelete.Enabled = true; buttonOrdUpdate.Enabled = true; }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { Clients result = ClientsDA.Search(comboBoxOrdClient.Text); if (result != null) { textBoxOrdClient.Text = result.clientName.ToString(); textBoxOrdPhoneNumber.Text = result.phoneNumber.ToString(); textBoxOrdCreditLimit.Text = ("$ " + result.creditLimit.ToString()); textBoxOrdAdress.Text = (result.postalCode + ", " + result.city + " - " + result.street); } }
private void buttonOrdPlaceOrder_Click(object sender, EventArgs e) { //Order Validators if (!Validator.IsEmptyComboBox(comboBoxOrdClient)) { MessageBox.Show("Order must have a valid Client.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error); textBoxAutID.Clear(); textBoxAutID.Focus(); return; } if (!Validator.IsEmptyComboBox(comboBoxOrdProduct)) { MessageBox.Show("Order must have a valid Product.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error); textBoxAutID.Clear(); textBoxAutID.Focus(); return; } if (!Validator.IsEmpty(textBoxOrdQuantity)) { MessageBox.Show("Orders must have a valid quantity.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error); textBoxAutID.Clear(); textBoxAutID.Focus(); return; } int temp = 0; if ((!int.TryParse((textBoxOrdQuantity.Text), out temp))) { MessageBox.Show("Quantity of Products must be a integer number.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error); textBoxOrdQuantity.Clear(); textBoxOrdQuantity.Focus(); return; } Order aOrder = createOrder(); Books aBook = BooksDA.SearchByTitle(comboBoxOrdProduct.Text); Clients aClient = ClientsDA.Search(comboBoxOrdClient.Text); aBook.QOH = aBook.QOH - aOrder.OrdQuantity; BooksDA.Update(aBook); aClient.creditLimit = aClient.creditLimit - aOrder.OrdTotal; ClientsDA.Update(aClient); OrderDA.SaveOrder(aOrder); buttonOrdList.PerformClick(); UpdateComboBoxes(); }
//________________ORDER TAB_______________________________________________________________________ private Order createOrder() { Order aOrder = new Order(); Clients aClients = new Clients(); Books aBook = new Books(); Employee aEmployee = new Employee(); aBook = BooksDA.SearchByTitle(comboBoxOrdProduct.Text); aClients = ClientsDA.Search(comboBoxOrdClient.Text); aEmployee = EmployeeDA.Search(Convert.ToInt32(textBoxOrdEmployee.Text)); aOrder.OrdNumber = OrderDA.OrderID() + 1; aOrder.OrdEmployee = null; aOrder.OrdEmployee = aEmployee; aOrder.OrdClient = aClients; aOrder.OrdProduct = aBook; aOrder.OrdQuantity = Convert.ToInt32(textBoxOrdQuantity.Text); aOrder.OrdTotal = aOrder.OrdQuantity * BooksDA.SearchByTitle(comboBoxOrdProduct.Text).unitPrice; aOrder.OrdDate = Convert.ToDateTime(dateTimePicker1.Value); return(aOrder); }