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