private void updateCustomerButton_Click(object sender, EventArgs e) { if (customerListDropdown.Items.Count > 0) { using (insuranceEntities ie = new insuranceEntities()) { int selectedCustomerId = Int32.Parse(customerListDropdown.SelectedValue.ToString()); Customer selectedCustomer = ie.Customers.Where(a => a.Id == selectedCustomerId).FirstOrDefault(); if (selectedCustomer != null) { bool somethingUpdated = false; if (selectedCustomer.Status != customerStatusDropdown.SelectedItem.ToString()) { selectedCustomer.Status = customerStatusDropdown.SelectedItem.ToString(); somethingUpdated = true; } if (somethingUpdated == true) { ie.SaveChanges(); MessageBox.Show("Customer information updated successfully!"); } } } } }
private void updateOfficeInfoButton_Click(object sender, EventArgs e) { using (insuranceEntities ie = new insuranceEntities()) { var office = ie.Offices.Where(a => a.Id == this.loggedInId).FirstOrDefault(); if (office != null) { bool somethingUpdated = false; if (office.Name != officeNameInput.Text) { office.Name = officeNameInput.Text; somethingUpdated = true; } if (office.Location != officeLocationInput.Text) { office.Location = officeLocationInput.Text; somethingUpdated = true; } if (office.Director != officeDirectorInput.Text) { office.Director = officeDirectorInput.Text; somethingUpdated = true; } if (somethingUpdated == true) { ie.SaveChanges(); MessageBox.Show("Office information updated successfully!"); } } } }
public void setOfficeDropdownValues() { using (insuranceEntities ie = new insuranceEntities()) { List <Office> offices = ie.Offices.ToList(); officeListDropdown.DataSource = offices; officeListDropdown.ValueMember = "Id"; officeListDropdown.DisplayMember = "DisplayName"; } }
public void setCustomerDropdownValues() { using (insuranceEntities ie = new insuranceEntities()) { List <Customer> customers = ie.Customers.Where(a => a.OfficeId == loggedInId).ToList(); customerListDropdown.DataSource = customers; customerListDropdown.ValueMember = "Id"; customerListDropdown.DisplayMember = "DisplayName"; setCustomerStatus(); } }
private void deleteAppointmentButton_Click(object sender, EventArgs e) { using (insuranceEntities ie = new insuranceEntities()) { Customer customer = ie.Customers.Where(a => a.Id == loggedInId).FirstOrDefault(); if (customer != null) { if (MessageBox.Show("Are you sure you want to delete your appointment?", "Delete Appointment", MessageBoxButtons.YesNo) == DialogResult.Yes) { ie.Customers.Remove(customer); ie.SaveChanges(); MessageBox.Show("Appointment successfully deleted!"); this.Hide(); } } } }
private void employeeLoginButton_Click(object sender, EventArgs e) { using (insuranceEntities ie = new insuranceEntities()) { if (employeeUsernameInput.Text != string.Empty || employeePasswordInput.Text != string.Empty) { if (employeeUsernameInput.Text.Any(Char.IsWhiteSpace) || employeePasswordInput.Text.Any(Char.IsWhiteSpace)) { MessageBox.Show("No spaces allowed in username or password fields!"); } else { var user = ie.Offices.Where(a => a.Username.Equals(employeeUsernameInput.Text)).FirstOrDefault(); if (user != null) { if (user.Password.Equals(employeePasswordInput.Text)) { employeeMainPage1.loggedInId = user.Id; employeeMainPage1.Show(); employeeMainPage1.fixEmptyDatabaseFields(); employeeMainPage1.populateFields(); employeeMainPage1.setCustomerDropdownValues(); employeeMainPage1.BringToFront(); clearFields(); } else { MessageBox.Show("Incorrect password!"); } } else { MessageBox.Show("Incorrect username!"); } } } else { MessageBox.Show("Please input username and password!"); } } }
public void fixEmptyDatabaseFields() { using (insuranceEntities ie = new insuranceEntities()) { var office = ie.Offices.Where(a => a.Id == this.loggedInId).FirstOrDefault(); if (office.Name == null) { office.Name = ""; } if (office.Location == null) { office.Location = ""; } if (office.Director == null) { office.Director = ""; } ie.SaveChanges(); } }
public void populateFields() { using (insuranceEntities ie = new insuranceEntities()) { Customer customer = ie.Customers.Where(a => a.Id == loggedInId).FirstOrDefault(); if (customer != null) { customerLicencePlateValue.Text = customer.LicencePlate; customerNameValue.Text = customer.Name; customerPhoneValue.Text = customer.Phone; List <Office> offices = ie.Offices.ToList(); officeListDropdown.DataSource = offices; officeListDropdown.ValueMember = "Id"; officeListDropdown.DisplayMember = "DisplayName"; officeListDropdown.SelectedValue = customer.OfficeId; customerStatusValue.Text = customer.Status; datePicker.Value = DateTime.Parse(customer.Date); timePicker.Value = DateTime.Parse(customer.Time); } } }
private void deleteCustomerButton_Click(object sender, EventArgs e) { if (customerListDropdown.Items.Count > 0) { using (insuranceEntities ie = new insuranceEntities()) { int selectedCustomerId = Int32.Parse(customerListDropdown.SelectedValue.ToString()); Customer selectedCustomer = ie.Customers.Where(a => a.Id == selectedCustomerId).FirstOrDefault(); if (selectedCustomer != null) { if (MessageBox.Show("Are you sure you want to remove the selected customer?", "Remove Customer", MessageBoxButtons.YesNo) == DialogResult.Yes) { ie.Customers.Remove(selectedCustomer); ie.SaveChanges(); MessageBox.Show("Customer removed successfully!"); setCustomerDropdownValues(); } } } } }
public void setCustomerStatus() { using (insuranceEntities ie = new insuranceEntities()) { int selectedCustomerId; if (customerListDropdown.Items.Count > 0) { Int32.TryParse(customerListDropdown.SelectedValue.ToString(), out selectedCustomerId); if (selectedCustomerId != 0) { Customer selectedCustomer = ie.Customers.Where(a => a.Id == selectedCustomerId).FirstOrDefault(); if (selectedCustomer != null) { customerStatusDropdown.SelectedItem = selectedCustomer.Status; } } } else { customerStatusDropdown.SelectedItem = null; } } }
public void populateFields() { using (insuranceEntities ie = new insuranceEntities()) { var office = ie.Offices.Where(a => a.Id == this.loggedInId).FirstOrDefault(); if (office != null) { if (office.Name != null) { officeNameInput.Text = office.Name; } else { officeNameInput.Text = ""; } if (office.Location != null) { officeLocationInput.Text = office.Location; } else { officeLocationInput.Text = ""; } if (office.Director != null) { officeDirectorInput.Text = office.Director; } else { officeDirectorInput.Text = ""; } } customerStatusDropdown.SelectedItem = null; } }
private void updateCustomerInfoButton_Click(object sender, EventArgs e) { using (insuranceEntities ie = new insuranceEntities()) { Customer customer = ie.Customers.Where(a => a.Id == loggedInId).FirstOrDefault(); if (customer != null) { bool somethingUpdated = false; if (customer.OfficeId != Int32.Parse(officeListDropdown.SelectedValue.ToString())) { customer.OfficeId = Int32.Parse(officeListDropdown.SelectedValue.ToString()); somethingUpdated = true; } if (customer.Date != datePicker.Value.ToString().Substring(0, 10)) { customer.Date = datePicker.Value.ToString().Substring(0, 10); somethingUpdated = true; } string hours = timePicker.Value.ToString().Substring(14, 5).Split(':')[0]; if (hours.Length == 1) { hours = "0" + hours; } string mins = timePicker.Value.ToString().Substring(14, 5).Split(':')[1]; if (mins.Length == 1) { mins = "0" + mins; } string time = hours + ":" + mins; bool canUpdateAppointment = true; int selectedOfficeId = Int32.Parse(officeListDropdown.SelectedValue.ToString()); List <Customer> selectedOfficeCustomers = ie.Customers.Where(a => a.OfficeId == selectedOfficeId).ToList(); foreach (var item in selectedOfficeCustomers) { if (item.Id != loggedInId) { if (item.Date == datePicker.Value.ToString().Substring(0, 10) && item.Time == time) { canUpdateAppointment = false; break; } } } if (customer.Time != time) { customer.Time = time; somethingUpdated = true; } if (canUpdateAppointment == true) { if (somethingUpdated == true) { ie.SaveChanges(); MessageBox.Show("Appointment successfully updated!"); } } else { MessageBox.Show("Selected date and time combination is taken in selected office!"); } } } }
private void setAppointmentButton_Click(object sender, EventArgs e) { if (RemoveWhitespace(licencePlateSetInput.Text) != string.Empty && customerNameInput.Text != string.Empty && customerPhoneSetInput.Text != string.Empty) { using (insuranceEntities ie = new insuranceEntities()) { List <Customer> customers = ie.Customers.ToList(); bool found = false; foreach (var item in customers) { if (item.LicencePlate.Equals(RemoveWhitespace(licencePlateSetInput.Text), StringComparison.InvariantCultureIgnoreCase) && item.OfficeId == Int32.Parse(officeListDropdown.SelectedValue.ToString())) { found = true; break; } } if (found == true) { MessageBox.Show("This licence plate is already registered in an insurance office!"); } else { bool isInputOK = true; if (RemoveWhitespace(licencePlateSetInput.Text).Length != 8) { MessageBox.Show("The licence plate consists of 8 symbols!"); isInputOK = false; } else { string start = RemoveWhitespace(licencePlateSetInput.Text).Substring(0, 2); string middle = RemoveWhitespace(licencePlateSetInput.Text).Substring(2, 4); string end = RemoveWhitespace(licencePlateSetInput.Text).Substring(6, 2); bool startRegex = Regex.IsMatch(start, @"^[a-zA-Z]+$"); bool middleRegex = Regex.IsMatch(middle, @"^[0-9]+$"); bool endRegex = Regex.IsMatch(end, @"^[a-zA-Z]+$"); if (!startRegex) { MessageBox.Show("First 2 licence plate symbols must be latin letters!"); isInputOK = false; } if (!middleRegex) { MessageBox.Show("Middle 4 licence plate symbols must be positive digits!"); isInputOK = false; } if (!endRegex) { MessageBox.Show("Last 2 licence plate symbols must be latin letters!"); isInputOK = false; } } if (RemoveWhitespace(customerPhoneSetInput.Text).Length != 10) { MessageBox.Show("A valid mobile phone number consists of 10 digits!"); isInputOK = false; } if (isInputOK == true) { Customer customer = new Customer(); customer.LicencePlate = RemoveWhitespace(licencePlateSetInput.Text).ToUpper(); customer.Name = customerNameInput.Text; customer.Phone = RemoveWhitespace(customerPhoneSetInput.Text); customer.OfficeId = Int32.Parse(officeListDropdown.SelectedValue.ToString()); customer.Status = "Booked"; string hours = timePicker.Value.ToString().Substring(14, 5).Split(':')[0]; if (hours.Length == 1) { hours = "0" + hours; } string mins = timePicker.Value.ToString().Substring(14, 5).Split(':')[1]; if (mins.Length == 1) { mins = "0" + mins; } string time = hours + ":" + mins; bool canSaveAppointment = true; List <Customer> selectedOfficeCustomers = ie.Customers.Where(a => a.OfficeId == customer.OfficeId).ToList(); foreach (var item in selectedOfficeCustomers) { if (item.Date == datePicker.Value.ToString().Substring(0, 10) && item.Time == time) { canSaveAppointment = false; break; } } customer.Date = datePicker.Value.ToString().Substring(0, 10); customer.Time = time; if (canSaveAppointment == true) { ie.Customers.Add(customer); ie.SaveChanges(); MessageBox.Show("Appointment successfully booked!"); clearFields(); } else { MessageBox.Show("Selected date and time combination is taken in selected office!"); } } } } } else { MessageBox.Show("Please input all fields!"); } }
private void viewAppointmentButton_Click(object sender, EventArgs e) { if (RemoveWhitespace(licencePlateViewInput.Text) != string.Empty && RemoveWhitespace(customerPhoneViewInput.Text) != string.Empty) { bool isInputOK = true; if (RemoveWhitespace(licencePlateViewInput.Text).Length != 8) { MessageBox.Show("The licence plate consists of 8 symbols!"); isInputOK = false; } else { string start = RemoveWhitespace(licencePlateViewInput.Text).Substring(0, 2); string middle = RemoveWhitespace(licencePlateViewInput.Text).Substring(2, 4); string end = RemoveWhitespace(licencePlateViewInput.Text).Substring(6, 2); bool startRegex = Regex.IsMatch(start, @"^[a-zA-Z]+$"); bool middleRegex = Regex.IsMatch(middle, @"^[0-9]+$"); bool endRegex = Regex.IsMatch(end, @"^[a-zA-Z]+$"); if (!startRegex) { MessageBox.Show("First 2 licence plate symbols must be latin letters!"); isInputOK = false; } if (!middleRegex) { MessageBox.Show("Middle 4 licence plate symbols must be positive digits!"); isInputOK = false; } if (!endRegex) { MessageBox.Show("Last 2 licence plate symbols must be latin letters!"); isInputOK = false; } } if (RemoveWhitespace(customerPhoneViewInput.Text).Length != 10) { MessageBox.Show("A valid mobile phone number consists of 10 digits!"); isInputOK = false; } if (isInputOK == true) { string licencePlate = RemoveWhitespace(licencePlateViewInput.Text).ToUpper(); string phoneNumber = RemoveWhitespace(customerPhoneViewInput.Text); using (insuranceEntities ie = new insuranceEntities()) { Customer customer = ie.Customers.Where(a => a.LicencePlate.Equals(licencePlate, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); if (customer != null) { if (customer.Phone.Equals(phoneNumber)) { customerViewPage1.loggedInId = customer.Id; customerViewPage1.Show(); customerViewPage1.populateFields(); customerViewPage1.BringToFront(); clearFields(); } else { MessageBox.Show("Wrong phone number!"); } } else { MessageBox.Show("No appointment found!"); } } } } else { MessageBox.Show("Please input both fields!"); } }