public AppointmentsList(Model.Patient patient, Model.Hospital hospitalIn) { InitializeComponent(); using (SqlConnection connection = new SqlConnection()) { connection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = connection; command.CommandText = "SELECT apptTime, apptDate, importance, reason FROM Hospital.dbo.Appointments" + "\n WHERE patientID = @patientID AND hospitalID = @hospitalID;"; SqlDataReader cursor = command.ExecuteReader(); if (cursor.Read()) { object[] tuple = new object[cursor.FieldCount]; cursor.GetValues(tuple); DateTime date = (DateTime)tuple[0]; DateTime time = (DateTime)tuple[1]; DateTime schedule = new DateTime(date.Year, date.Month, date.Day, time.Hour, time.Minute, time.Second, DateTimeKind.Local); Model.Triage importance = (Model.Triage)Enum.Parse(typeof(Model.Triage), (string)tuple[2]); Model.Specialty specialty = (Model.Specialty)Enum.Parse(typeof(Model.Specialty), (string)tuple[3]); } } } }
private void confirmButton_Click(object sender, EventArgs e) { if (((String)triage.SelectedItem) == "" || ((String)reasonList.SelectedItem) == "") { errorMessage.Visible = true; errorMessage.Text = "Please fill all fields"; return; } Model.Triage urgency = (Model.Triage)Enum.Parse(typeof(Model.Triage), (string)triage.SelectedItem); Model.Specialty reason = (Model.Specialty)Enum.Parse(typeof(Model.Specialty), (string)reasonList.SelectedItem); try { appointmentIn.AddAppointment(schedulePicker.Value, reason, triage.SelectedItem.ToString(), detailedReason.Text, patient); //If successfull, hide error message. errorMessage.Visible = false; } catch (Exception err) { errorMessage.Text = err.Message; errorMessage.Visible = true; } this.Close(); }
private void UpdateCommandHandler(object sender, ExecutedRoutedEventArgs e) { if (newSpecialtyGrid.IsVisible) { newSpecialty = new Model.Specialty(); Model.Specialty nSpecialty = mySpecialtiesViewSource.View.CurrentItem as Model.Specialty; if (nSpecialty != null) { newSpecialty.SpecialtyName = nSpecialty?.SpecialtyName; if (!string.IsNullOrWhiteSpace(newSpecialty?.SpecialtyName)) { mySpecialtiesViewSource.View.Refresh(); mySpecialtiesViewSource.View.MoveCurrentTo(newSpecialty); context.SaveChanges(); Messenger.Default.Send <string>(Utils.LanguageAddedMessage); } else { MessageBox.Show("Specialty Is Empty."); } } newSpecialtyGrid.Visibility = Visibility.Collapsed; existingSpecialtyGrid.Visibility = Visibility.Visible; } }
public SpecialtyEntity(IDataService dataService, IMessenger messanger, Model.Specialty entity, long position) { DataService = dataService; Messenger = messanger; this.entity = entity; this.position = position; hasChanges = false; UpdateHasChanges(); }
private void CreateEntity() { try { if (DataService?.DBContext?.Specializations != null && DataService?.DBContext.Specialties != null) { Model.Specialization newEntity = DataService?.DBContext?.Specializations?.Create(); if (newEntity != null) { DataService?.DBContext?.Specializations?.Add(newEntity); Entity = newEntity; Active = true; Model.Specialty specialty = DataService.DBContext.Specialties.FirstOrDefault(); SpecialtyId = specialty?.Id ?? 0; UserModify = DataService?.UserName; DateTimeOffset now = DateTimeOffset.Now; Entity.Created = now; OnPropertyChanged(nameof(Created)); Entity.LastModify = now; OnPropertyChanged(nameof(LastModify)); } } } catch (EntityException e) { OnEntityException(e); } catch (DbEntityValidationException e) { OnDbEntityValidationException(e); } catch (DbUpdateException e) { OnDbUpdateException(e); } }
public SpecialtyEntity(IDataService dataService, IMessenger messanger, Model.Specialty entity) : this(dataService, messanger, entity, 0) { }