public void setupAdminPnl() { //fill the data tables with info if (isFirstSetup) { try { admin1Data.DataSource = EmployeesTable.getAll(); admin1Data.Columns["password"].Visible = false; admin1Data.Columns["deleted"].Visible = false; admin2Data.DataSource = CustomersTable.getAll(); admin2Data.Columns["deleted"].Visible = false; admin3Data.DataSource = MoviesTable.getAll(); admin3Data.Columns["deleted"].Visible = false; sortBy(admin3Data, 1, true); admin4Data.DataSource = CopiesTable.getAll(); admin4Data.Columns["deleted"].Visible = false; sortBy(admin4Data, 0, true); }catch { EmployeesTable.adapter.Dispose(); CustomersTable.adapter.Dispose(); MoviesTable.adapter.Dispose(); CopiesTable.adapter.Dispose(); Prompt.dbError(); } } Reposition.setControl(adminTitleLbl, .4, .7, 0, .1); Reposition.setControl(adminTab, .1, .9, .1, .9); Reposition.setNestedControlPosition(admin1Data, .05, .95, 0, .8); Reposition.setNestedControlPosition(admin2Data, .05, .95, 0, .8); Reposition.setNestedControlPosition(admin3Data, .05, .95, 0, .8); Reposition.setNestedControlPosition(admin4Data, .05, .95, 0, .8); //user Buttons Reposition.setNestedControlLocation(admin1Btn, .1, .85); Reposition.setNestedControlLocation(adminPasswordBtn, .4, .85); Reposition.setNestedControlLocation(admin2Btn, .7, .85); //customer buttons Reposition.setNestedControlLocation(admin3Btn, .3, .85); Reposition.setNestedControlLocation(admin4Btn, .6, .85); //movie buttons Reposition.setNestedControlLocation(admin5Btn, .3, .85); Reposition.setNestedControlLocation(admin6Btn, .6, .85); //upc buttons Reposition.setNestedControlLocation(admin7Btn, .3, .85); Reposition.setNestedControlLocation(admin8Btn, .6, .85); }
public void setupReportsPnl() { if (isFirstSetup) { try { reports1Data.DataSource = MoviesTable.getAll(); reports1Data.Columns["deleted"].Visible = false; sortBy(reports1Data, 5, false); reports2Data.DataSource = CustomersTable.getAll(); reports2Data.Columns["deleted"].Visible = false; sortBy(reports2Data, 7, false); reports3Data.DataSource = MoviesTable.getAll(); reports3Data.Columns["deleted"].Visible = false; sortBy(reports3Data, 1, true); reports4Data.DataSource = RentalsTable.getNotReturned(); reports4Data.Columns["returned"].Visible = false; sortBy(reports4Data, 4, true); reports5Data.DataSource = RentalsTable.getLateMovies(); reports5Data.Columns["returned"].Visible = false; sortBy(reports5Data, 4, true); reports6Data.DataSource = CopiesTable.getAll(); reports6Data.Columns["deleted"].Visible = false; sortBy(reports6Data, 0, true); }catch { CustomersTable.adapter.Dispose(); MoviesTable.adapter.Dispose(); RentalsTable.adapter.Dispose(); CopiesTable.adapter.Dispose(); Prompt.dbError(); } } Reposition.setControl(reportsTitleLbl, .4, .7, 0, .1); Reposition.setControl(reportsTab, .1, .9, .1, .9); Reposition.setNestedControlPosition(reports1Data, .05, .95, 0, 1); Reposition.setNestedControlPosition(reports2Data, .05, .95, 0, 1); Reposition.setNestedControlPosition(reports3Data, .05, .95, 0, 1); Reposition.setNestedControlPosition(reports4Data, .05, .95, 0, 1); Reposition.setNestedControlPosition(reports5Data, .05, .95, 0, 1); Reposition.setNestedControlPosition(reports6Data, .05, .95, 0, 1); }
private void newCustomer1Btn_Click(object sender, EventArgs e) { string firstName = newCustomer1Txt.Text.Trim(' '); string lastName = newCustomer2Txt.Text.Trim(' '); string phone = newCustomer3Txt.Text.Trim(' '); string email = newCustomer4Txt.Text.Trim(' '); string address = newCustomer5Txt.Text.Trim(' '); if (!Check.areValidInputs(firstName, lastName, phone, email, address)) { Prompt.enterValidInput(); return; } if (!Check.isPhone(phone)) { Prompt.enterPhone(); return; } if (!Check.isEmail(email)) { Prompt.enterEmail(); return; } try { if (CustomersTable.hasCustomer(firstName, lastName, phone)) { Prompt.alreadyInDB("customer"); return; } CustomersTable.add(lastName, firstName, email, address, phone); clearRadioButtons(newCustomerPnl); clearTextBoxes(newCustomerPnl); if (currentUser.isAdmin()) { setCurrentMainPanel(adminPnl); } }catch { CustomersTable.adapter.Dispose(); Prompt.dbError(); } }
private void rent2Btn_Click(object sender, EventArgs e) { string firstName = rent2Txt.Text.Trim(' '); string lastName = rent3Txt.Text.Trim(' '); string phone = rent4Txt.Text.Trim(' '); int customerId; if (!Check.areValidInputs(firstName, lastName, phone)) { Prompt.enterValidInput(); return; } if (!Check.isPhone(phone)) { Prompt.enterPhone(); return; } try { if (!CustomersTable.hasCustomer(firstName, lastName, phone)) { Prompt.notACustomer(); return; } customerId = CustomersTable.getCustomerId(firstName, lastName, phone); currentCustomer = new Customer(customerId, firstName, lastName); CopiesTable.makeUnavailable(currentDVD.getUpc()); RentalsTable.add(currentDVD.getUpc(), currentCustomer.getCustomerId(), currentUser.getUserName(), Date.dateAfter(7)); CustomersTable.incrementTimesRented(currentCustomer.getCustomerId()); MoviesTable.incrementTimesRented(currentDVD.getUpc()); clearTextBoxes(rent2Pnl); setCurrentMainPanel(rentPnl); }catch { CustomersTable.adapter.Dispose(); RentalsTable.adapter.Dispose(); MoviesTable.adapter.Dispose(); CopiesTable.adapter.Dispose(); Prompt.dbError(); } }
private void removeCustomer1Btn_Click(object sender, EventArgs e) { string customerId = removeCustomer1Txt.Text.Trim(' '); if (!Check.areValidInputs(customerId)) { Prompt.enterValidInput(); return; } if (!Check.isNumeric(customerId)) { Prompt.enterNumeric("Customer Id"); return; } try { if (!CustomersTable.hasCustomer(Int32.Parse(customerId))) { Prompt.notInDB("customer", customerId); return; } if (RentalsTable.customerIsRenting(Int32.Parse(customerId))) { Prompt.removalDependency("customer", "rental"); return; } CustomersTable.setDeleted(true, Int32.Parse(customerId)); clearTextBoxes(removeCustomerPnl); //exit to admin panel setCurrentMainPanel(adminPnl); }catch { CustomersTable.adapter.Dispose(); RentalsTable.adapter.Dispose(); Prompt.dbError(); } }