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)
{
}
