private void miSettings_Click(object sender, RoutedEventArgs e) { Settings settings = new Settings(); CommonTasks.getInstance().Hide(); settings.Show(); }
private void handleLogin() { string[] results = Database.getInstance().datasetToStringArray(Database.getInstance().select("", new string[] { "Employee as T1, EmployeeLogin as T2 " }, new string[] { "T1.EmployeeID", "T1.FirstName" }, "WHERE T1.EmployeeID = T2.EmployeeID and T2.Username", "=", txtUsername.Text + "' and T2.Password = '" + pwbPassword.Password + "", new String[] { "" })); if (results.Length != 0) { DataDelegate.EmployeeID = int.Parse(results[0]); DataDelegate.currentUserName = results[1]; DataDelegate.loginStart = DateTime.Now; MainWindow.getInstance().Show(); MainWindow.getInstance().enableWindow(); CommonTasks.getInstance().Show(); this.Close(); } else { failedAttempts++; if (failedAttempts >= 3) { MessageBox.Show("Too many login attempts. This application will now close. Goodbye.", "Login Failed"); Environment.Exit(0); } else { MessageBox.Show("Incorrect Credentials", "Access Denied"); } } }
private void frmMainWindow_GotFocus(object sender, RoutedEventArgs e) { if (CommonTasks.getInstance().Topmost == false) { CommonTasks.getInstance().Topmost = true; } }
// Method called when a Book Service button is pressed. // Navigates the user to a ServiceDate page private void bookService_click(object sender, RoutedEventArgs e) { String date = ""; String year = ""; String month = ""; String day = ""; int intYear = 0; int intMonth = 0; int intDay = 0; DateTime serviceDate = new DateTime(); if (sender is Button) { Button button = (Button)sender; date = button.Name.Substring(2); // Date is stored in the button name. year = date.Substring(0, 4); month = date.Substring(4, 2); day = date.Substring(6, 2); int.TryParse(year, out intYear); int.TryParse(month, out intMonth); int.TryParse(day, out intDay); serviceDate = new DateTime(intYear, intMonth, intDay); } if (serviceDate.CompareTo(DateTime.Now) > 0) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new ServiceNew(serviceDate, VehicleVIN)); } else { MessageBox.Show("There was a problem parsing the service date.\n" + serviceDate.ToString("yyyy-MM-dd HH:mm:ss") + "\n" + date, "Service Booking Error"); } }
private void btnBookService_Click(object sender, RoutedEventArgs e) { if (ServiceTimeIsInFuture()) { DateTime returnDate = new DateTime(serviceDate.Year, serviceDate.Month, serviceDate.Day, 17, 0, 0); if (serviceDate.Hour > 15) { returnDate = returnDate.AddDays(1); } if (checkDatesForClashes(serviceDate, returnDate, VehicleVIN)) { MessageBox.Show("Your selected dates clash with other bookings. Please reschedule.", "Date Clash Detected"); return; } MessageBoxResult result = MessageBox.Show("Are you happy with these date?\nService Time : " + serviceDate.ToString("yyyy-MM-dd HH:mm") + "\nPickup Time : " + returnDate.ToString("yyyy-MM-dd HH:mm"), "Booking Confirmation", MessageBoxButton.OKCancel, MessageBoxImage.Question); if (result == MessageBoxResult.OK) { int recordsInserted = Database.getInstance().insert("Service", new string[] { "VehicleVIN", "ServiceDate", "ReturnDate" }, new string[] { VehicleVIN, serviceDate.ToString("yyyy-MM-dd HH:mm:ss"), returnDate.ToString("yyyy-MM-dd HH:mm:ss") }); if (recordsInserted > 0) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new ServiceBookingSuccess()); } } } }
void resultButton_Click(object sender, RoutedEventArgs e) { Button button = (Button)sender; int length = button.Name.Length - 3; String strVIN = button.Name.Substring(3, length); CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new FleetEdit(strVIN)); }
// Singleton pattern - return a static instance of the window, only. public static CommonTasks getInstance() { if (instance == null) { instance = new CommonTasks(); } return(instance); }
void resultButton_Click(object sender, RoutedEventArgs e) { Button button = (Button)sender; int length = button.Name.Length - 3; String name = button.Name.Substring(3, length); int CustomerID = int.Parse(name); CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new CustomersEdit(CustomerID)); }
// Method to navigate to BookingsNew page. // If a customerID is selected, use the customerID as a parameter in the call to the page. private void btnBookingNew_Click(object sender, RoutedEventArgs e) { if ((CustomerID != null) && (CustomerID > 0)) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new BookingsNew(CustomerID)); } else { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new BookingsNew()); } }
private void miViewCommonTasks_Click(object sender, RoutedEventArgs e) { CommonTasks.getInstance().Hide(); CommonTasks.getInstance().Show(); this.Topmost = false; if (CommonTasks.getInstance().WindowState != WindowState.Normal) { CommonTasks.getInstance().WindowState = WindowState.Normal; } }
// Method takes the user to a BookingsEdit to see details of the selected booking. private void booking_click(object sender, RoutedEventArgs e) { int bookingID = 0; if (sender is Button) { Button button = (Button)sender; string strBookingID = button.Name.Substring(2); int.TryParse(strBookingID, out bookingID); } CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new BookingsEdit(bookingID)); }
public void print() { PrintDialog print = new PrintDialog(); if (CommonTasks.getInstance().Topmost) { CommonTasks.getInstance().Topmost = false; print.ShowDialog(); CommonTasks.getInstance().Topmost = true; } else { print.ShowDialog(); } }
// Method called when the user clicks one of the results onscreen, displayed as a button. void resultButton_Click(object sender, RoutedEventArgs e) { // Create a button object from the sender. Button button = (Button)sender; // Get the BookingID from the Button Name. // Button names can't start with numbers, so 3 characters have been added by me to get around this. // Create a substring from the button name, of just the characters we want, not the characters I added. String name = button.Name.Substring(3); // and parse that substring to get the ineteger BookingID. int BookingID = int.Parse(name); // Then navigate to the BookingsEdit page, using the BookingID as a parameter. CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new BookingsEdit(BookingID)); }
public bool initialiseScanner() { for (int i = 0; i < deviceManager.DeviceInfos.Count; i++) { try { if (deviceManager.DeviceInfos[i].Type != WiaDeviceType.ScannerDeviceType) { continue; } else { scannerInfo = deviceManager.DeviceInfos[i]; break; } } catch (Exception e) { DataDelegate.errorMessages.Add(e.Message.ToString()); } } if (scannerInfo == null) { if (StephenGlasspell_CarRental.CommonTasks.getInstance().Topmost == true) { System.Windows.MessageBox.Show(CommonTasks.getInstance(), "No Scanner Found", "Error"); } else { System.Windows.MessageBox.Show(new MainWindow(), "No Scanner Found", "Error"); } return(false); } else { return(true); } }
// Method to insert the booking data into the database private void btnConfirmBooking_Click(object sender, RoutedEventArgs e) { string strSHBDT = collectionDateTime.ToString("yyyy-MM-dd HH:mm:ss"); string strSHRDT = returnDateTime.ToString("yyyy-MM-dd HH:mm:ss"); // Databse insert method call. Returns the number of changed records. int success = Database.getInstance().insert("Booking ", new string[] { "VehicleVIN", "CustomerID", "EmployeeID", "ScheduledHireBeginDateTime", "ScheduledHireReturnDateTime", "TotalBill" }, new string[] { VehicleVIN, CustomerID.ToString(), DataDelegate.EmployeeID.ToString(), strSHBDT, strSHRDT, txtTotalCharge.Text }); if (success > 0) // If the numbers of inserted records is more than zero. { // Navigate to BookingCreatedSuccess page. clearForm(); CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new BookingCreatedSuccess()); } else // No records were inserted. { // Show the error message. MessageBox.Show("There were problems entering the data into the database.", "Error"); } }
// Method to delete the selected booking. // Warns the user with a MessageBox and sends a delete statement to the database. private void btnCancelBooking_Click(object sender, RoutedEventArgs e) { // Warning. MessageBoxResult result = MessageBox.Show("Are you sure you want to cancel the booking?\nThe record will be permanently deleted.", "Confirm", MessageBoxButton.YesNo, MessageBoxImage.Exclamation); if (result == MessageBoxResult.Yes) { if (decTotalPaid > 0) { // Refund any payments made. int recordsInserted = Database.getInstance().insert("Payment", new string[] { "BookingID", "Amount", "DateOfPayment" }, new string[] { bookingID.ToString(), (-decTotalPaid).ToString(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }); if (recordsInserted > 0) { MessageBox.Show(decTotalPaid.ToString("C") + " has been refunded to the customer.", "Payment Refunded"); } else { MessageBox.Show("There was a problem refunding the payment throught the database.", "Refund failed."); } } //Send SQL statement to database. int recordsUpdated = Database.getInstance().update("Booking", new string[] { "CancelledDateTime" }, new string[] { DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }, "WHERE BookingID", "=", bookingID.ToString()); // Show confirmation. if (recordsUpdated > 0) { MessageBox.Show("Booking Deleted", "Success"); // Navigate back to the List of Bookings page. CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new BookingsList()); } else { MessageBox.Show("There was a problem cancelling the booking in the database.", "Database Error"); } } }
private void btnNewBooking_Click(object sender, RoutedEventArgs e) { String custName = txtFirstName.Text + " " + txtLastName.Text; CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new BookingsNew(customerID, custName)); }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (isDrivingLicenseNumberAlreadyInDatabase()) { MessageBox.Show("The Driving License you entered is already in the database. No duplicates allowed.", "Driving License Duplicate"); txtDrivingLicenseNumber.Focus(); txtDrivingLicenseNumber.SelectAll(); return; } bool allFieldsAreVaild = true; foreach (FormField field in fields) { if (field.successTextBox.Text != DataDelegate.SUCCESS) { allFieldsAreVaild = false; break; } } if (!allFieldsAreVaild) { MessageBox.Show("Please recheck your entries.", "Your form contains invalid data."); } else { List <String> tables = new List <String>(); foreach (FormField field in fields) { if (!tables.Contains(field.databaseTable)) { tables.Add(field.databaseTable); } } foreach (String table in tables) { List <String> DBfields = new List <String>(); List <String> DBvalues = new List <String>(); for (int index = 0; index < fields.Count; index++) { if (fields[index].databaseTable == table) { DBfields.Add(fields[index].databaseFieldName); DBvalues.Add(fields[index].userEntryText); } if (index == fields.Count - 1) { String[] databaseFields = DBfields.ToArray(); String[] databaseValues = DBvalues.ToArray(); if (Database.getInstance().update(table, databaseFields, databaseValues, " WHERE CustomerID", " = ", txtCustomerID.Text) == 0) { MessageBox.Show("There were some errors updating the database.", "Database Error"); return; } DBfields.Clear(); DBvalues.Clear(); } } } } CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new CustomerUpdateSuccess(customerID)); }
private void btnCustomerEdit_Click(object sender, RoutedEventArgs e) { DataDelegate.previousCursor = Mouse.OverrideCursor; Mouse.OverrideCursor = Cursors.Wait; CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new CustomerList()); }
private void btnCustomerNew_Click(object sender, RoutedEventArgs e) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new CustomersNew()); }
private void btnGoToCustomerEdit_Click(object sender, RoutedEventArgs e) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new CustomersEdit(CustomerID)); }
private void btnSave_Click(object sender, RoutedEventArgs e) { bool allFieldsAreVaild = true; foreach (FormField field in fields) { if (field.successTextBox.Text != SUCCESS) { allFieldsAreVaild = false; break; } } if (!allFieldsAreVaild) { MessageBox.Show("Please recheck your entries.", "Your form contains invalid data."); } else { List <String> tables = new List <String>(); foreach (FormField field in fields) { if (!tables.Contains(field.databaseTable)) { tables.Add(field.databaseTable); } } int CustomerID = Database.getInstance().getNextCustID(); foreach (String table in tables) { List <String> DBfields = new List <String>(); List <String> DBvalues = new List <String>(); int errors = 0; for (int index = 0; index < fields.Count; index++) { if (fields[index].databaseTable == table) { DBfields.Add(fields[index].databaseFieldName); DBvalues.Add(fields[index].userEntryText); } if (index == fields.Count - 1) { String[] databaseFields = DBfields.ToArray(); String[] databaseValues = DBvalues.ToArray(); if (Database.getInstance().insert(table, databaseFields, databaseValues) == 0) { errors++; } DBfields.Clear(); DBvalues.Clear(); } } if (errors > 0) { MessageBox.Show("There were some errors inserting data into the database.", "Database Error"); } else { // MessageBox.Show("Record created successfully.", "Database Updated."); CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new CustomerUpdateSuccess(CustomerID)); } } clearForm(); } }
private void btnNewVehicle_Click(object sender, RoutedEventArgs e) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new FleetNew()); }
// Method to check all the inputs are valid and send them to the database if valid. private void btnSave_Click(object sender, RoutedEventArgs e) { bool allFieldsAreVaild = true; foreach (FormField field in fields) { if (field.successTextBox.Text != DataDelegate.SUCCESS) { // Only display this error message if in debug mode. if (DataDelegate.debugMode) { MessageBox.Show(field.name.ToString(), "Field not valid"); } allFieldsAreVaild = false; break; } } if (!allFieldsAreVaild) { MessageBox.Show("Please recheck your entries.", "Your form contains invalid data."); return; } else { // New list of tables. These relate to the tables in the database. List <String> tables = new List <String>(); // Iterate through every field in the fields list. foreach (FormField field in fields) { //If the table for the selected datafield is not in the list, add it to the list. if (!tables.Contains(field.databaseTable)) { tables.Add(field.databaseTable); } } // Find out what the next customerId in the database should be. // TODO - shouldn't this be auto incremented? FIX THIS. int CustomerID = Database.getInstance().getNextCustID(); // For every table in the list, make lists of fields and values (Properties and values) foreach (String table in tables) { List <String> DBfields = new List <String>(); List <String> DBvalues = new List <String>(); DBfields.Add("CustomerID"); DBvalues.Add(CustomerID.ToString()); // Count any errors. int errors = 0; // This code is to build lists of Database fields and their associated values, per table in the databse. for (int index = 0; index < fields.Count; index++) { if (fields[index].databaseTable == table) { DBfields.Add(fields[index].databaseFieldName); DBvalues.Add(fields[index].userEntryText); } // When you get to the end of the list of fields, if (index == fields.Count - 1) { // Create string arrays from the lists... String[] databaseFields = DBfields.ToArray(); String[] databaseValues = DBvalues.ToArray(); // .. and include them in the SQL statement to the database. // Array of tables // \/ Array of fields // \/ Array of values if (Database.getInstance().insert(table, databaseFields, databaseValues) == 0) { errors++; } DBfields.Clear(); DBvalues.Clear(); } } if (errors > 0) // There were errors. { MessageBox.Show("There were some errors inserting data into the database.", "Database Error"); return; } else // No errors found { // Navigate to the Customer Update Success page. CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new CustomerUpdateSuccess(CustomerID)); } } clearForm(); } }
private void btnNewBooking_Click(object sender, RoutedEventArgs e) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new BookingsNew(CustomerID, CustomerName)); }
private void btnServiceHistory_Click(object sender, RoutedEventArgs e) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new ServiceHistory(VehicleVIN)); }
private void btnBookService_Click(object sender, RoutedEventArgs e) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new CalendarMonth(VehicleVIN)); }
private void btnSave_Click(object sender, RoutedEventArgs e) { int errors = 0; bool allFieldsAreVaild = true; foreach (FormField field in fields) { if (field.successTextBox.Text != DataDelegate.SUCCESS) { allFieldsAreVaild = false; break; } } if (!allFieldsAreVaild) { MessageBox.Show("Please recheck your entries.", "Your form contains invalid data."); return; } else { List <String> tables = new List <String>(); foreach (FormField field in fields) { if (!tables.Contains(field.databaseTable)) { tables.Add(field.databaseTable); } } foreach (String table in tables) { List <String> DBfields = new List <String>(); List <String> DBvalues = new List <String>(); for (int index = 0; index < fields.Count; index++) { if (fields[index].databaseTable == table) { DBfields.Add(fields[index].databaseFieldName); DBvalues.Add(fields[index].userEntryText); } if (index == fields.Count - 1) { String[] databaseFields = DBfields.ToArray(); String[] databaseValues = DBvalues.ToArray(); if (Database.getInstance().update(table, databaseFields, databaseValues, " WHERE VehicleVIN", " = ", "'" + VehicleVIN + "'") == 0) { errors++; } DBfields.Clear(); DBvalues.Clear(); } } } } if (errors > 0) { MessageBox.Show("There were some errors updating the database.", "Database Error"); } else { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new VehicleUpdateSuccess(VehicleVIN)); } }
private void btnShowAllBookings_Click(object sender, RoutedEventArgs e) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new CustomerBookings(customerID)); }
private void btnCollections_Click(object sender, RoutedEventArgs e) { CommonTasks.getInstance().frmCommonTasksMainFrame.Navigate(new BookingsList()); }