private ArrayList GetRentals() { DatabaseAccessController dbc = new DatabaseAccessController(); ArrayList rentals = dbc.GetRentals(this.rentalID); return(rentals); }
private void ReceiptBody() { DatabaseAccessController dbc = new DatabaseAccessController(); ArrayList receiptDetails = dbc.GetReceiptDetails(this.rentalID); this.PlaceSearchResultsInList(receiptDetails, this.receiptListView); }
private void rentAddItemButton_Click(object sender, EventArgs e) { if (this.rentQuantityComboBox.SelectedItem == null) { this.errorProvider.SetError(this.rentQuantityComboBox, "Must make selection."); return; } this.errorProvider.SetError(this.rentQuantityComboBox, ""); int furnitureNumber = (int)this.rentFurnitureNumberCombBox.SelectedItem; DatabaseAccessController dba = new DatabaseAccessController(); string[] data = dba.GetFurnitureDescription(furnitureNumber); string description = data[0]; string dailyRate = data[1]; string dailyFee = data[2]; DataRow newRow = this.rentalInfoTable.NewRow(); newRow["FurnitureID"] = this.rentFurnitureNumberCombBox.SelectedItem; newRow["Description"] = description; newRow["Quantity"] = this.rentQuantityComboBox.SelectedItem; newRow["DailyRate"] = Convert.ToDecimal(dailyRate); newRow["DailyFee"] = Convert.ToDecimal(dailyFee); this.rentalInfoTable.Rows.Add(newRow); //dataGridView1.Rows.Add(new object[] { this.rentFurnitureNumberCombBox.SelectedItem, description, this.rentQuantityComboBox.SelectedItem }); this.rentFurnitureNumberCombBox.SelectedIndex = -1; this.rentFurnitureNumberCombBox.Items.Remove(furnitureNumber); this.rentQuantityComboBox.Items.Clear(); this.rentButton.Enabled = true; this.rentalInfoDataGridView.Enabled = true; }
private void PerformNonQuery() { DatabaseAccessController dbc = new DatabaseAccessController(); string result = dbc.AdminNonQuery(this.sqlStatementTextBox.Text); MessageBox.Show(result); }
private void returnRentalIDComboBox_SelectionChangeCommitted(object sender, EventArgs e) { int rentalID = (int)this.returnRentalIDComboBox.SelectedItem; DatabaseAccessController dba = new DatabaseAccessController(); returnInfoTable.Rows.Clear(); dba.GetRentalInfo(rentalID, returnInfoTable); }
private void PopulateStateComboBox() { DatabaseAccessController dbc = new DatabaseAccessController(); stateAbbrevs = dbc.GetStateAbbrevs(); foreach (String abbrev in stateAbbrevs) { this.stateAbbrevComboBox.Items.Add(abbrev); } }
private void SetUpFurnitureNumberComboBox() { DatabaseAccessController dba = new DatabaseAccessController(); ArrayList furnitureNums = dba.GetFurnitureItemNumbers(); this.rentFurnitureNumberCombBox.Items.Clear(); foreach (int number in furnitureNums) { this.rentFurnitureNumberCombBox.Items.Add(number); } }
private void SetColumnHeaders() { DatabaseAccessController dbc = new DatabaseAccessController(); ArrayList columnHeaders = dbc.AdminQueryColumns(this.sqlStatementTextBox.Text); queryResultsListView.Columns.Clear(); foreach (string column in columnHeaders) { this.queryResultsListView.Columns.Add(column); } }
private void SetUpReturnRentalIDComboBox() { DatabaseAccessController dba = new DatabaseAccessController(); ArrayList rentalIDs = dba.GetRentalIDsNumbers(this.returnCustomerIdTextBox.Text.ToString()); this.returnRentalIDComboBox.Items.Clear(); foreach (int id in rentalIDs) { this.returnRentalIDComboBox.Items.Add(id); } }
//************************Click event handlers************************* private void registerCustomerButton_Click(object sender, EventArgs e) { Customer customer = new Customer(); customer.FName = this.firstNameRegisterCustomerTextBox.Text; customer.MName = this.middleNameRegisterCustomerTextBox.Text; customer.LName = this.lastNameRegisterCustomerTextBox.Text; customer.StreetAddress = this.streetAddressRegisterCustomerTextBox.Text; customer.City = this.cityRegisterCustomerTextBox.Text; customer.State = this.stateAbbrevComboBox.SelectedItem.ToString(); customer.ZIPCode = this.zipCodeRegisterCustomerMaskedTextBox.Text; customer.SSN = this.ssnRegisterCustomerMaskedTextBox.Text; customer.Phone = this.phoneRegisterCustomerMaskedTextBox.Text; /** * String firstName = this.firstNameRegisterCustomerTextBox.Text; * String middleName = this.middleNameRegisterCustomerTextBox.Text; * String lastName = this.lastNameRegisterCustomerTextBox.Text; * String streetAddress = this.streetAddressRegisterCustomerTextBox.Text; * String city = this.cityRegisterCustomerTextBox.Text; * String state = this.stateAbbrevComboBox.SelectedItem.ToString(); * String zipCode = this.zipCodeRegisterCustomerMaskedTextBox.Text; * String ssn = this.ssnRegisterCustomerMaskedTextBox.Text; * String phone = this.phoneRegisterCustomerMaskedTextBox.Text; **/ //String message = "Customer registered:\n" + // " First Name: " + firstName + // "\n Middle Name: " + middleName + // "\n Last Name: " + lastName + // "\n Street Address: " + streetAddress + // "\n City: " + city + // "\n State: " + state + // "\n ZIP Code: " + zipCode + // "\n SSN: " + ssn + // "\n phone: " + phone; //MessageBox.Show(message, "Entered Info", MessageBoxButtons.OK, MessageBoxIcon.None); //this.customerID++; DatabaseAccessController dbc = new DatabaseAccessController(); String customerID = dbc.AddCustomer(customer); MessageBox.Show(customer.FName + " " + customer.LName + "\n\nCustomer ID: " + customerID, "Registered Customer", MessageBoxButtons.OK, MessageBoxIcon.None); this.ResetAllControls(); }
private void rentButton_Click(object sender, EventArgs e) { string custID = this.rentCustomerIDTextBox.Text; int customerID = Convert.ToInt32(custID); int empID = this.loginInformation.getEmployeeID(); DatabaseAccessController dba = new DatabaseAccessController(); string rentalID = dba.AddRental(customerID, empID, rentalInfoTable); ReceiptForm receipt = new ReceiptForm(rentalID); receipt.ShowDialog(); this.setUpRentForm(); }
private void PerformFurnitureSearch() { DatabaseAccessController dbAccess = new DatabaseAccessController(); string searchCriteria = this.searchFurnitureCriteriaTextBox.Text; ArrayList results = dbAccess.SearchFurniture(searchCriteria); if (results.Count != 0) { this.PlaceSearchResultsInList(results, this.searchResultsSearchFurnitureListView); } else { this.NoResultsFound(this.searchResultsSearchFurnitureListView); } this.ResizeListViewColumns(this.searchResultsSearchFurnitureListView); }
//******************************* Login Methods ********************************* private void ValidateLogin(string username, string password) { DatabaseAccessController dbc = new DatabaseAccessController(); ArrayList userData = dbc.GetLogin(username, password); if (userData.Count != NO_RESULTS) { this.loginInformation.setEmployeeID(Convert.ToInt32(userData[0])); this.loginInformation.setUsername(username); this.loginInformation.setName(userData[1] + " " + userData[2]); this.loginInformation.setIsAdmin(Convert.ToInt32(userData[3])); this.DialogResult = DialogResult.OK; } else { this.errorLoginFormLabel.Visible = true; } }
private void PerformGetRentals() { string fromDate = this.fromDateTimePicker.Text; string toDate = this.toDateTimePicker.Text; DatabaseAccessController dbc = new DatabaseAccessController(); ArrayList rentals = dbc.GetRentals(fromDate, toDate); if (rentals.Count != 0) { this.PlaceSearchResultsInList(rentals, this.ordersListView); } else { this.NoResultsFound(this.ordersListView); } this.ResizeListViewColumns(this.ordersListView); }
private void PerformGetRentalDetails() { ListView.SelectedListViewItemCollection rental = this.ordersListView.SelectedItems; string rentalID = rental[0].SubItems[0].Text; DatabaseAccessController dbc = new DatabaseAccessController(); ArrayList rentalItems = dbc.GetRentalItems(rentalID); if (rentalItems.Count != 0) { this.PlaceSearchResultsInList(rentalItems, this.contentsListView); } else { this.NoResultsFound(this.contentsListView); } this.ResizeListViewColumns(this.contentsListView); }
private void HandleReturnCustomerIDValidation() { DatabaseAccessController dba = new DatabaseAccessController(); ArrayList customerInfo = dba.CustomerValidation(this.returnCustomerIdTextBox.Text); if (customerInfo.Count == 2) { this.errorProvider.SetError(this.returnCustomerIdTextBox, ""); this.returnRentalIDComboBox.Enabled = true; this.SetUpReturnRentalIDComboBox(); this.returnRentalIDComboBox.Focus(); } else { this.errorProvider.SetError(this.returnCustomerIdTextBox, "Invalid Customer ID"); } }
private void PerformCustomerSearch() { DatabaseAccessController dbc = new DatabaseAccessController(); String fname = this.firstNameSearchCustomerTextBox.Text; String lname = this.lastNameSearchCustomerTextBox.Text; String phone = this.phoneNumberSearchCustomerMaskedTextBox.Text; ArrayList customers = dbc.GetCustomers(fname, lname, phone); if (customers.Count != 0) { this.PlaceSearchResultsInList(customers, this.searchResultsSearchCustomerListView); } else { this.NoResultsFound(this.searchResultsSearchCustomerListView); } this.ResizeListViewColumns(this.searchResultsSearchCustomerListView); }
private void returnReturnButton_Click(object sender, EventArgs e) { int employeeID = loginInformation.getEmployeeID(); int rentalID = Convert.ToInt32(this.returnRentalIDComboBox.SelectedItem); DataTable data = new DataTable(); data.Columns.Add("rentalItemID", typeof(int)); data.Columns.Add("quantityReturned", typeof(int)); foreach (DataRow row in this.returnInfoTable.Rows) { int rentalItemID = Convert.ToInt32(row[2]); Debug.WriteLine("rentalItemId: " + rentalItemID); int quantity = Convert.ToInt32(row[8]); Debug.WriteLine("quantity: " + quantity); if (quantity > 0) { DataRow newRow = data.NewRow(); newRow["rentalItemID"] = rentalItemID; Debug.WriteLine("newRow rentalItemId: " + newRow["rentalItemID"]); newRow["quantityReturned"] = quantity; Debug.WriteLine("newRow quantityReturned: " + newRow["quantityReturned"]); data.Rows.Add(newRow); } } DatabaseAccessController dba = new DatabaseAccessController(); bool isReturnSuccessful = dba.InsertReturns(data, employeeID); string successReturn = "Your items were returned."; if (!isReturnSuccessful) { successReturn = "Your return was not successful. Contact Administrator."; } MessageBox.Show(successReturn, "Return", MessageBoxButtons.OK, MessageBoxIcon.None); this.returnInfoTable.Rows.Clear(); dba.GetRentalInfo(rentalID, returnInfoTable); }
private void PerformQuery() { DatabaseAccessController dbc = new DatabaseAccessController(); ArrayList results = dbc.AdminQueryResults(this.sqlStatementTextBox.Text); if (results == null) { MessageBox.Show("SQL is incorrect"); } else if (results.Count != 0) { this.SetColumnHeaders(); this.PlaceSearchResultsInList(results, this.queryResultsListView); } else { this.NoResultsFound(this.queryResultsListView); } this.ResizeListViewColumns(this.queryResultsListView); }
private void ValidateFurnitureNumberSelection() { DatabaseAccessController dba = new DatabaseAccessController(); int furnNum = (int)this.rentFurnitureNumberCombBox.SelectedItem; int quantity = dba.GetQuantityForFurnitureNumber(furnNum); if (quantity < 1) { this.errorProvider.SetError(this.rentFurnitureNumberCombBox, "Out of stock"); //this.rentQuantityComboBox.Enabled = false; this.rentAddItemButton.Enabled = false; } else { this.errorProvider.SetError(this.rentFurnitureNumberCombBox, ""); this.SetUpQuantityComboBox(quantity); this.rentQuantityComboBox.Enabled = true; this.rentQuantityLabel.Enabled = true; } }
private void HandleCustomerIDValidation() { DatabaseAccessController dba = new DatabaseAccessController(); ArrayList customerInfo = dba.CustomerValidation(this.rentCustomerIDTextBox.Text); if (customerInfo.Count == 2) { this.errorProvider.SetError(this.rentCustomerIDTextBox, ""); this.rentCustomerNameTextBox.Visible = true; this.rentFurnitureNumLabel.Enabled = true; this.rentFurnitureNumberCombBox.Enabled = true; this.rentCustomerNameTextBox.Text = customerInfo[0] + " " + customerInfo[1]; this.SetUpFurnitureNumberComboBox(); this.rentFurnitureNumberCombBox.Focus(); } else { this.errorProvider.SetError(this.rentCustomerIDTextBox, "Invalid Customer ID"); } }