private bool checkStaffTodaySchedule(Staff staff) { string date = DateTimeManager.convertDate(DpScheduleDate.Date.ToString()); MySqlConnectionStringBuilder builder = DBConnection.Connect(); MySqlConnection conn = new MySqlConnection(builder.ToString()); String qry = $"SELECT * FROM staff_schedule WHERE StaffID='{staff.staffID}' " + $"AND Date='{date}';"; MySqlCommand cmd = new MySqlCommand(qry, conn); conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); int counter = 0; while (reader.Read()) { counter++; } conn.Close(); if (counter > 0) { PanelError2.Visibility = Visibility.Visible; TxtErrorMessage2.Text = "This staff member already has a shift on the selected date."; return(false); } else { return(true); } }
private void getSelectedDateAppointments() { //clear list appointmentList.Clear(); //Get date selection string selectedDate; if (CalUpcomingAppt.SelectedDates.Count == 1) { selectedDate = CalUpcomingAppt.SelectedDates[0].ToString(); } else { selectedDate = DateTime.Now.ToString(); } selectedDate = selectedDate.Substring(0, 10); retrieveAppointmentsFromDB(DateTimeManager.convertDate(selectedDate)); NextApptPanel.Visibility = Visibility.Collapsed; GridNoApptSelection.Visibility = Visibility.Visible; refreshPanelsForAppointments(); }
private void BtnModify_Click(object sender, RoutedEventArgs e) { Appointment appointment = (Appointment)ListViewAppointment.SelectedItem; if (fieldsAreValid()) { appointment.name = TxtName.Text; appointment.surname = TxtName.Text; appointment.date = DateTimeManager.convertDate(DatePickerAddAppt.Date.ToString()); appointment.time = TimePickerAddAppt.Time.ToString(); appointment.contact = TxtName.Text; appointment.type = TxtName.Text; appointment.notes = TxtNotes.Text; if ((bool)RadioBurn.IsChecked) { appointment.type = "Burn"; } if ((bool)RadioUlcer.IsChecked) { appointment.type = "Chronic Ulcer"; } if ((bool)RadioDiabeticFoot.IsChecked) { appointment.type = "Diabetic Foot"; } modifyAppointment(appointment); } }
private void BtnModifyThisSchedule_Click(object sender, RoutedEventArgs e) { if (validateSchedule()) { ScheduleItem item = (ScheduleItem)ListViewSchedule.SelectedItem; Staff staff = (Staff)CmbChooseStaff.SelectedItem; item.staffID = staff.staffID; item.date = DateTimeManager.convertDate(DpScheduleDate.Date.ToString()); item.startTime = TPStart.Time.ToString(); item.endTime = TPEnd.Time.ToString(); modifySchedule(item); PanelAddModifySchedule.Visibility = Visibility.Collapsed; RightOverlay.Visibility = Visibility.Collapsed; getSchedule(item.date); if (ListViewSchedule.SelectedItem == null) { BtnModifySchedule.IsEnabled = false; BtnRemoveSchedule.IsEnabled = false; } } }
//Add this Appointment private void BtnAdd_Click(object sender, RoutedEventArgs e) { if (fieldsAreValid()) { string appointmentID = IDManager.getNextAppointmentID(); string name = TxtName.Text; string surname = TxtSurname.Text; string date = DateTimeManager.convertDate(DatePickerAddAppt.Date.ToString()); string time = TimePickerAddAppt.Time.ToString(); string contact = TxtContact.Text; string notes = TxtNotes.Text; string type = ""; string patientId = TxtID.Text; if (patientId.Equals("Select patient from list")) { patientId = ""; } time = time.Substring(0, 5); if ((bool)RadioBurn.IsChecked) { type = "Burn"; } if ((bool)RadioUlcer.IsChecked) { type = "Chronic Ulcer"; } if ((bool)RadioDiabeticFoot.IsChecked) { type = "Diabetic Foot"; } Appointment newAppointment = new Appointment(appointmentID, name, surname, contact, date, time, type, notes, patientId); addAppointment(newAppointment); if (!patientId.Equals("")) { addPatientAppt(patientId, appointmentID); } clearFormValues(); // Dialog PanelDialog.Visibility = Visibility.Visible; TxtDialogMessage.Text = "Appointment has been added"; Overlay.Visibility = Visibility.Visible; getSelectedDateAppointments(); PanelAddAppointment.Visibility = Visibility.Collapsed; MainPanel.Visibility = Visibility.Visible; refreshPanelsForAppointments(); } }
private void CalSchedule_SelectedDatesChanged(CalendarView sender, CalendarViewSelectedDatesChangedEventArgs args) { if (sender.SelectedDates.Count == 1) { string selectedDate = CalSchedule.SelectedDates[0].ToString(); selectedDate = selectedDate.Substring(0, 10); getSchedule(DateTimeManager.convertDate(selectedDate)); } }
protected override void OnNavigatedTo(NavigationEventArgs e) { base.OnNavigatedTo(e); if (e.Parameter is Appointment) { thisAppointment = (Appointment)e.Parameter; LblName.Text = thisAppointment.name + " " + thisAppointment.surname; LblDateTime.Text = DateTimeManager.DateToShort(thisAppointment.date) + " | " + thisAppointment.time; } }
private void BtnModify_Click(object sender, RoutedEventArgs e) { LblTitle.Text = "Modify Staff"; string password = ""; PanelDetails.Visibility = Visibility.Collapsed; PanelAddModify.Visibility = Visibility.Visible; BtnCancel.Visibility = Visibility.Collapsed; NoSelectionPanel.Visibility = Visibility.Collapsed; BtnAddThisStaff.Visibility = Visibility.Collapsed; BtnModifyThisStaff.Visibility = Visibility.Visible; Staff staff = (Staff)ListViewStaff.SelectedItem; CmbStatus.SelectedValue = staff.status; CmbTitle.SelectedValue = staff.title; TxtName.Text = staff.name; TxtSurname.Text = staff.surname; DpStaffDOB.Date = DateTimeManager.convertToDate(staff.dob); if (staff.sex.Equals("Male")) { RadioSexM.IsChecked = true; } else { RadioSexF.IsChecked = true; } if (staff.password.Equals("") || staff.password.Equals("none")) { password = ""; } else { TxtPassword.Password = staff.password; } TxtAddress.Text = staff.address; TxtContact.Text = staff.contact; TxtEmail.Text = staff.email; TxtRate.Text = staff.rate; CmbOccurrence.SelectedValue = staff.occurence; TxtPassword.Password = password; CmbRights.SelectedValue = staff.rights; ListViewStaff.IsEnabled = false; BtnAdd.IsEnabled = false; TxtSearch.IsEnabled = false; }
private void BtnModifyPatient_Click(object sender, RoutedEventArgs e) { ListViewPatient.IsEnabled = false; BtnAddPatient.IsEnabled = false; TxtSearch.IsEnabled = false; Patient pat = (Patient)ListViewPatient.SelectedItem; if (validatePatient()) { pat.title = CmbTitle.SelectedValue.ToString(); pat.name = TxtPatientName.Text; pat.surname = TxtPatientSurname.Text; pat.dateOfBirth = DateTimeManager.convertDate(DpPatientDOB.Date.ToString()); if ((bool)RadioSexM.IsChecked) { pat.sex = "Male"; } if ((bool)RadioSexF.IsChecked) { pat.sex = "Female"; } pat.address = TxtPatientAddress.Text; pat.contact = TxtPatientContact.Text; pat.email = TxtPatientEmail.Text; pat.occupation = TxtPatientOccupation.Text; modifyPatient(pat); clearFormValues(); // Dialog PanelDialog.Visibility = Visibility.Visible; TxtDialogMessage.Text = "Patient has been modified"; Overlay.Visibility = Visibility.Visible; DetailsPanel.Visibility = Visibility.Collapsed; AddPanel.Visibility = Visibility.Collapsed; NoSelectionPanel.Visibility = Visibility.Visible; BtnCancelPatientDetails.Visibility = Visibility.Visible; BtnViewArchived.IsEnabled = true; ListViewPatient.IsEnabled = true; BtnAddPatient.IsEnabled = true; TxtSearch.IsEnabled = true; LblMainTitle.Text = "Patients"; } }
private void BtnModifyAppointment_Click(object sender, RoutedEventArgs e) { LblAddModifyTitle.Text = "Modify Appointment"; Appointment appointment = (Appointment)ListViewAppointment.SelectedItem; MainPanel.Visibility = Visibility.Collapsed; PanelAddAppointment.Visibility = Visibility.Visible; BtnAdd.Visibility = Visibility.Collapsed; BtnModify.Visibility = Visibility.Visible; BtnChoosePatient.Visibility = Visibility.Collapsed; BtnCancelSelect.Visibility = Visibility.Collapsed; TxtName.Text = appointment.name; TxtSurname.Text = appointment.surname; DatePickerAddAppt.Date = DateTimeManager.convertToDate(appointment.date); TimePickerAddAppt.Time = TimeSpan.Parse(appointment.time); TxtContact.Text = appointment.contact; TxtNotes.Text = appointment.notes; if (appointment.patientId == "0") { TxtID.Text = ""; } else { TxtID.Text = appointment.patientId; } string type = appointment.type; if (type.Equals("Burn")) { RadioBurn.IsChecked = true; } else if (type.Equals("Chronic Ulcer")) { RadioUlcer.IsChecked = true; } else if (type.Equals("Diabetic Foot")) { RadioDiabeticFoot.IsChecked = true; } }
private void showAppointment(Appointment appt) { BtnDeleteAppt.Tag = appt; GridNoApptSelection.Visibility = Visibility.Collapsed; NextApptPanel.Visibility = Visibility.Visible; LblName.Text = appt.name + " " + appt.surname; LblDate.Text = DateTimeManager.DateToShort(appt.date); LblTime.Text = appt.time; LblContactText.Text = appt.contact; LblNoteText.Text = appt.notes; string patientId = appt.patientId; if (apptIsExisitingPatient(patientId)) { if (visitExists(patientId, appt.date, appt.time)) { BtnNewVisit.Visibility = Visibility.Collapsed; BtnViewVisit.Visibility = Visibility.Visible; BtnDeleteAppt.Visibility = Visibility.Collapsed; BtnModifyAppointment.Visibility = Visibility.Collapsed; } else { BtnDeleteAppt.Visibility = Visibility.Visible; BtnModifyAppointment.Visibility = Visibility.Visible; BtnNewVisit.Visibility = Visibility.Visible; BtnViewVisit.Visibility = Visibility.Collapsed; } patientId = " - " + patientId; } else { patientId = ""; BtnViewVisit.Visibility = Visibility.Collapsed; BtnDeleteAppt.Visibility = Visibility.Visible; BtnModifyAppointment.Visibility = Visibility.Visible; } LblPatientID.Text = patientId; BtnNewVisit.Tag = appt; }
// BUTTONS private void ListView_ItemClick(object sender, ItemClickEventArgs e) { PanelDetails.Visibility = Visibility.Visible; NoSelectionPanel.Visibility = Visibility.Collapsed; Staff staff = (Staff)e.ClickedItem; LblID.Text = staff.staffID; LblName.Text = staff.title + ". " + staff.name + " " + staff.surname; LblDob.Text = DateTimeManager.DateToShortYear(staff.dob); LblAddress.Text = staff.address; LblEmail.Text = staff.email; LblRate.Text = "Rs" + staff.rate + " " + staff.occurence; LblSex.Text = staff.sex; LblStatus.Text = staff.status; LblContact.Text = staff.contact; LblRights.Text = staff.rights; }
private Staff createStaff() { string sex = ""; string password = ""; string rights = ""; string date = DateTimeManager.convertDate(DpStaffDOB.Date.ToString()); if ((bool)RadioSexM.IsChecked) { sex = "Male"; } if ((bool)RadioSexF.IsChecked) { sex = "Female"; } if (TxtPassword.Password.Equals("")) { password = "******"; } else { password = TxtPassword.Password; } if (CmbRights.SelectedIndex == -1) { rights = "none"; } else { rights = CmbRights.SelectedValue.ToString(); } Staff staff = new Staff(IDManager.getNextStaffID(), CmbStatus.SelectedValue.ToString(), CmbTitle.SelectedValue.ToString(), TxtName.Text, TxtSurname.Text, date, sex, TxtAddress.Text, TxtContact.Text, TxtRate.Text, TxtEmail.Text, CmbOccurrence.SelectedValue.ToString(), password, rights); return(staff); }
// CREATE PATIENT private Patient createPatient() { string sex = ""; string date = DateTimeManager.convertDate(DpPatientDOB.Date.ToString()); if ((bool)RadioSexM.IsChecked) { sex = "Male"; } if ((bool)RadioSexF.IsChecked) { sex = "Female"; } Patient pat = new Patient(IDManager.getNextPatientID(), CmbTitle.SelectedValue.ToString(), TxtPatientName.Text, TxtPatientSurname.Text, date, sex, TxtPatientAddress.Text, TxtPatientContact.Text, TxtPatientEmail.Text, TxtPatientOccupation.Text); return(pat); }
private void BtnAddThisSchedule_Click(object sender, RoutedEventArgs e) { if (validateSchedule()) { Staff staff = (Staff)CmbChooseStaff.SelectedItem; string date = DateTimeManager.convertDate(DpScheduleDate.Date.ToString()); string startTime = TPStart.Time.ToString(); string endTime = TPEnd.Time.ToString(); if (startTime.Length > 5) { startTime = startTime.Substring(0, 5); } if (endTime.Length > 5) { endTime = endTime.Substring(0, 5); } if (checkStaffTodaySchedule(staff)) { ScheduleItem item = new ScheduleItem(IDManager.getNextScheduleID(), date, startTime, endTime, staff.staffID, staff.name, staff.surname, staff.contact); addSchedule(item); scheduleList.Add(item); PanelAddModifySchedule.Visibility = Visibility.Collapsed; RightOverlay.Visibility = Visibility.Collapsed; clearScheduleValues(); PanelDialog.Visibility = Visibility.Visible; TxtDialogMessage.Text = "Staff has been added to the schedule."; NoScheduleSelection.Visibility = Visibility.Collapsed; ListViewSchedule.Visibility = Visibility.Visible; } } }
// PATIENT LIST SELECT private void ListViewPatient_ItemClick(object sender, ItemClickEventArgs e) { DetailsPanel.Visibility = Visibility.Visible; AddPanel.Visibility = Visibility.Collapsed; NoSelectionPanel.Visibility = Visibility.Collapsed; Patient patient = (Patient)e.ClickedItem; getVisitList(patient); LblPatientName.Text = patient.name + " " + patient.surname; LblPatientID.Text = patient.patientId; LblPatientTitle.Text = patient.title; LblDOB.Text = DateTimeManager.DateToShortYear(patient.dateOfBirth); LblSex.Text = patient.sex; LblPatientAddress.Text = patient.address; LblPatientContact.Text = patient.contact; LblPatientEmail.Text = patient.email; LblPatientOccupation.Text = patient.occupation; }
// GET MAIN VISIT INFO private void getVisitDetails(PatientVisit visit) { MySqlConnectionStringBuilder builder = DBConnection.Connect(); MySqlConnection conn = new MySqlConnection(builder.ToString()); String qry = "SELECT patient_visits.*, patients.Name, patients.Surname FROM patient_visits " + "JOIN patients ON patient_visits.PatientID = patients.PatientID " + "WHERE patient_visits.PatientVisitID = '" + visit.id + "'; "; MySqlCommand cmd = new MySqlCommand(qry, conn); conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string id = reader["PatientVisitID"].ToString(); string pId = reader["PatientID"].ToString(); string notes = reader["Notes"].ToString(); string date = reader["Date"].ToString(); string time = reader["Time"].ToString(); string incomeId = reader["IncomeID"].ToString(); string afterOpening = reader["AfterOpening"].ToString(); string actions = reader["ActionsPerformed"].ToString(); string beforeClosing = reader["BeforeClosing"].ToString(); string name = reader["Name"].ToString(); string surname = reader["Surname"].ToString(); string type = reader["Type"].ToString(); LblName.Text = name + " " + surname; LblDateTime.Text = date + " " + time; LblDateTime.Text = DateTimeManager.DateToShort(date) + " | " + time; LblAfterOpeningText.Text = afterOpening; LblActionsTakenText.Text = actions; LblBeforeClosingText.Text = beforeClosing; LblNotesText.Text = notes; } }
private void BtnModify_Click(object sender, RoutedEventArgs e) { LblMainTitle.Text = "Modify Patient"; DetailsPanel.Visibility = Visibility.Collapsed; AddPanel.Visibility = Visibility.Visible; BtnModifyPatient.Visibility = Visibility.Visible; BtnAdd.Visibility = Visibility.Collapsed; BtnCancelPatientDetails.Visibility = Visibility.Collapsed; ListViewPatient.IsEnabled = false; BtnAddPatient.IsEnabled = false; TxtSearch.IsEnabled = false; BtnViewArchived.IsEnabled = false; Patient pat = (Patient)ListViewPatient.SelectedItem; CmbTitle.SelectedValue = pat.title; TxtPatientSurname.Text = pat.surname; TxtPatientName.Text = pat.name; DpPatientDOB.Date = DateTimeManager.convertToDate(pat.dateOfBirth); if (pat.sex.Equals("Male")) { RadioSexM.IsChecked = true; } else { RadioSexF.IsChecked = true; } TxtPatientAddress.Text = pat.address; TxtPatientContact.Text = pat.contact; TxtPatientEmail.Text = pat.email; TxtPatientOccupation.Text = pat.occupation; }
// MODIFY SCHEDULE private void BtnModifySchedule_Click(object sender, RoutedEventArgs e) { PanelAddModifySchedule.Visibility = Visibility.Visible; BtnAddThisSchedule.Visibility = Visibility.Collapsed; BtnModifyThisSchedule.Visibility = Visibility.Visible; RightOverlay.Visibility = Visibility.Visible; ScheduleItem item = (ScheduleItem)ListViewSchedule.SelectedItem; DpScheduleDate.Date = DateTimeManager.convertToDate(item.date); TPStart.Time = TimeSpan.Parse(item.startTime); TPEnd.Time = TimeSpan.Parse(item.endTime); Staff selectedStaff = null; foreach (var staff in staffList) { if (staff.staffID.Equals(item.staffID)) { selectedStaff = staff; } } CmbChooseStaff.SelectedItem = selectedStaff; }
private void BtnModifyThisStaff_Click(object sender, RoutedEventArgs e) { Staff staff = (Staff)ListViewStaff.SelectedItem; if (validateFields()) { staff.status = CmbStatus.SelectedValue.ToString(); staff.title = CmbTitle.SelectedValue.ToString(); staff.name = TxtName.Text; staff.surname = TxtSurname.Text; staff.dob = DateTimeManager.convertDate(DpStaffDOB.Date.ToString()); if ((bool)RadioSexM.IsChecked) { staff.sex = "Male"; } if ((bool)RadioSexF.IsChecked) { staff.sex = "Female"; } if (TxtPassword.Password.Equals("")) { staff.password = "******"; } else { staff.password = TxtPassword.Password; } if (CmbRights.SelectedIndex == -1) { staff.rights = "none"; } else { staff.rights = CmbRights.SelectedValue.ToString(); } staff.address = TxtAddress.Text; staff.contact = TxtContact.Text; staff.email = TxtEmail.Text; staff.rate = TxtRate.Text; staff.occurence = CmbOccurrence.SelectedValue.ToString(); staff.password = TxtPassword.Password; modifyStaff(staff); clearFormValues(); PanelDialog.Visibility = Visibility.Visible; TxtDialogMessage.Text = "Staff has been modified."; Overlay.Visibility = Visibility.Visible; PanelDetails.Visibility = Visibility.Collapsed; PanelAddModify.Visibility = Visibility.Collapsed; NoSelectionPanel.Visibility = Visibility.Visible; BtnCancel.Visibility = Visibility.Visible; ListViewStaff.IsEnabled = true; BtnAdd.IsEnabled = true; TxtSearch.IsEnabled = true; LblTitle.Text = "Staff"; } }