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