public List <Appointment> GetAppointments()
{
var uDal = new AppointmentDAL(_dbc);
var result = uDal.GetAppointments().Result;
return(result);
}
public int RemoveAppointment(int id)
{
var uDal = new AppointmentDAL(_dbc);
var result = uDal.RemoveAppointment(id).Result;
return(result);
}
/// <summary>
/// Deletes Record from Database.
/// </summary>
/// <param name="objDept">Object containing all data values.</param>
/// <returns>boolean value True if Record is deleted successfully
/// otherwise returns False.</returns>
public static bool Delete(Appointment objAppoint)
{
bool recDel;
recDel = AppointmentDAL.Delete(objAppoint.DBID);
return(recDel);
}
public int UpdateAppointment(Appointment appt)
{
var uDal = new AppointmentDAL(_dbc);
var result = uDal.UpdateAppointment(appt).Result;
return(result);
}
private void buttonDeletePatient_Click(object sender, EventArgs e)
{
var isPatientSelected = (this.listViewPatients.SelectedItems.Count > 0) ? true : false;
if (isPatientSelected)
{
// Get patient id
var patientId = int.Parse(this.listViewPatients.SelectedItems[0].SubItems[3].Text);
DialogResult okToProceed = MessageBox.Show("You are about to delete a patient", "Please confirm you would like to continue", MessageBoxButtons.YesNo);
if (okToProceed == DialogResult.Yes)
{
if (!AppointmentDAL.PatientHasAppointment(patientId))
{
PatientDAL.DeletePatient(patientId);
this.search();
}
else
{
MessageBox.Show("Patient has appointments and cannot be deleted");
}
}
}
else
{
MessageBox.Show("Please select a patient if you wish to delete.");
}
}
private bool validateAppointmentInfo(DateTime appointmentDateTime, int patientId, int doctorId, string reasons, Appointment ignoredAppointment = null)
{
if (appointmentDateTime < DateTime.Now)
{
MessageBox.Show("You cannot schedule an appointment in the past");
return(false);
}
if (AppointmentDAL.HasMatchingAppointment(appointmentDateTime, patientId: patientId, ignoredAppointment: ignoredAppointment))
{
MessageBox.Show("The patient cannot be scheduled for 2 appointments at the same time!");
return(false);
}
else if (AppointmentDAL.HasMatchingAppointment(appointmentDateTime, doctorId: doctorId, ignoredAppointment: ignoredAppointment))
{
MessageBox.Show("The doctor cannot be at 2 appointments at the same time!");
return(false);
}
if (String.IsNullOrWhiteSpace(reasons))
{
MessageBox.Show("Please include appointment reasons.");
return(false);
}
else if (reasons.Length > 200)
{
MessageBox.Show("Reasons length cannot exceed 200 characters");
return(false);
}
return(true);
}
/// <summary>
/// Creates a new appointment
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public Message AddAppointment([FromBody] JToken value)
{
int doctorid = 0, patientid = 0;
int.TryParse((string)value.SelectToken("doctorid"), out doctorid);
int.TryParse((string)value.SelectToken("patientid"), out patientid);
if (!DoctorDAL.DoctorExists(doctorid))
{
return(MessageHandler.Error("Incorrect doctorid. Not authorized to update patients"));
}
if (!PatientDAL.PatientExist(patientid))
{
return(MessageHandler.Error("Incorrect patientid. Patient not found!"));
}
string date = (string)value.SelectToken("date");
string time = (string)value.SelectToken("time");
if (date == null)
{
return(MessageHandler.Error("Please specify a date for this appointment."));
}
if (time == null)
{
return(MessageHandler.Error("Please specify a time for this appointment."));
}
AppointmentDAL.InsertAppointment(doctorid, patientid, (int)StatusEnum.Success, date, time,
(string)value.SelectToken("notes"));
UserActivity.AddDoctorActivity((int)ActivityEnum.CreateAppointment, doctorid, (int)StatusEnum.Success, "Success", value.ToString());
return(MessageHandler.Success("Appointment added!"));
}
public ActionResult BookAppointment_Post(FormCollection collection)
{
Appointment appointment = new Appointment();
appointment.Pusername = TempData["username"].ToString();
TempData.Keep();
appointment.Dfirstname = TempData["drfirstname"].ToString();
TempData.Keep();
appointment.Dlastname = TempData["drlastname"].ToString();
TempData.Keep();
TryUpdateModel(appointment);
if (ModelState.IsValid)
{
appointment.Dinfoid = 0;
appointment.Pinfoid = 0;
appointment.Status = 0;
AppointmentDAL.BookAppointment(appointment);
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
/// <see cref="AppointmentDAL.GetPatientsAppointments(Patient)"/>
public List <AppointmentDTO> GetPatientsAppointments(Patient patient)
{
if (patient == null || patient.ID == null)
{
throw new ArgumentNullException("patient and patientID cannot be null");
}
return(AppointmentDAL.GetPatientsAppointments(patient));
}
//Appointment
public ActionResult Appointments()
{
AppointmentDAL AppDAL = new AppointmentDAL();
int ID = int.Parse(Session["DoctorID"].ToString());
List <AppointmentDetails> details = Doc.getAppointmentDetails(ID);
return(View(details));
}
/// <see cref="AppointmentDAL.GetAppointmentInDateRange(DateTime, DateTime)"/>
public List <AppointmentDTO> GetAppointmentsInDateRange(DateTime startDate, DateTime endDate)
{
if (startDate == null || endDate == null)
{
throw new ArgumentNullException("startDate and endDate cannot be null");
}
return(AppointmentDAL.GetAppointmentInDateRange(startDate, endDate.AddDays(1)));
}
/// <see cref="AppointmentDAL.DeleteAppointment(Appointment)"/>
public bool DeleteAppointment(Appointment appt)
{
if (appt == null)
{
throw new ArgumentNullException("Appointment cannot be null");
}
return(AppointmentDAL.DeleteAppointment(appt));
}
private void loadAvailableDoctorDateTimes()
{
this.timeComboBox.Items.Clear();
this.availableTimes.Clear();
var appointmentTimes = AppointmentDAL.GetDoctorAppointmentTimes(this.SelectedDoctor.ID, this.apptDatePicker.Value);
this.getFormattedTimeComboList(appointmentTimes).ToList().ForEach(time => this.timeComboBox.Items.Add(time));
}
public ActionResult History()
{
string username = TempData["username"].ToString();
TempData.Keep();
List <Appointment> history = new List <Appointment>();
history = AppointmentDAL.History(username);
return(View(history));
}
private void loadAvailableDoctorDateTimes(DateTime timeToAdd)
{
this.timeComboBox.Items.Clear();
this.availableTimes.Clear();
var appointmentTimes = AppointmentDAL.GetDoctorAppointmentTimes(this.SelectedDoctor.ID, this.apptDatePicker.Value);
appointmentTimes.Remove(appointmentTimes.FirstOrDefault(date => date.Hour == timeToAdd.Hour));
this.getFormattedTimeComboList(appointmentTimes).ToList().ForEach(time => this.timeComboBox.Items.Add(time));
}
public List <Appointment> GetPatientAppointments([FromBody] JToken value)
{
int patientid = 0;
int.TryParse((string)value.SelectToken("patientid"), out patientid);
if (PatientDAL.PatientExist(patientid))
{
return(AppointmentDAL.GetPatientAppointments(patientid));
}
return(null);
}
public List <Appointment> GetDoctorAppointments([FromBody] JToken value)
{
int docId = 0;
int.TryParse((string)value.SelectToken("doctorid"), out docId);
if (DoctorDAL.DoctorExists(docId))
{
UserActivity.AddDoctorActivity((int)ActivityEnum.ViewAppointments, docId, (int)StatusEnum.Success, "Success", value.ToString());
return(AppointmentDAL.GetDoctorAppointments(docId));
}
return(null);
}
/// <summary>
/// Initalizes DAL objects
/// </summary>
public HealthcareController()
{
visitDAL = new VisitDAL();
appointmentDAL = new AppointmentDAL();
doctorDAL = new DoctorDAL();
personDAL = new PersonDAL();
loginDAL = new LoginDAL();
patientDAL = new PatientDAL();
nurseDAL = new NurseDAL();
testDAL = new TestDAL();
specialtyDAL = new SpecialityDAL();
}
public static string[] GetNames()
{
DataTable dTable = null;
string[] objNamesList = null;
dTable = AppointmentDAL.GetNames();
if (dTable.Rows.Count > 0)
{
objNamesList = dTable.AsEnumerable().Select(row => row.Field <string>("NAME")).ToArray();
}
return(objNamesList);
}
public static string[] GetAppointments()
{
DataTable dTable = null;
string[] objAppointmentList = null;
dTable = AppointmentDAL.GetAppointments();
if (dTable.Rows.Count > 0)
{
objAppointmentList = dTable.AsEnumerable().Select(row => row.Field <string>("APPOINTMENTNO")).ToArray();
}
return(objAppointmentList);
}
private void reloadAppointments()
{
this.listViewAppointments.Items.Clear();
List <Appointment> appointments = AppointmentDAL.GetAllAppointmentsForPatient(this.patient.PatientID.Value);
foreach (Appointment appointment in appointments)
{
string formattedDateTime = appointment.DateTime.ToShortDateString() + " " + appointment.DateTime.ToShortTimeString();
ListViewItem row = new ListViewItem(new[] { formattedDateTime, appointment.Reasons });
row.Tag = appointment;
this.listViewAppointments.Items.Add(row);
}
}
public void SetUp()
{
var appointmentDbSetMock = GetMockDbSet(_appointment);
var appointmentJobsDbSetMock = GetMockDbSet(_appointmentJob);
appointmentJobsDbSetMock.Setup(m => m.Include("Appointments")).Returns(appointmentJobsDbSetMock.Object);
_appointmentContextMock = new Mock <AppointmentContext>();
_appointmentContextMock.Setup(mock => mock.Appointments).Returns(appointmentDbSetMock.Object);
_appointmentContextMock.Setup(mock => mock.AppointmentJobs).Returns(appointmentJobsDbSetMock.Object);
_appointmentContextMock.Setup(mock => mock.SaveChangesAsync()).Returns(Task.FromResult(0));
_underTest = new AppointmentDAL(_appointmentContextMock.Object);
}
private async void finishEdit(object sender, RoutedEventArgs e)
{
try
{
this.ring.IsActive = true;
var patientDal = new PatientDAL();
var nurseDal = new NurseDAL();
var appointDal = new AppointmentDAL();
var vm = new RoutineCheckupViewModel();
var appnt = await appointDal.GetAppointmentById(this.AppointmentID);
var patient = await patientDal.GetPatientById(this.PatientId);
var nurse = await nurseDal.GetNurseByNurseId(this.NurseId);
var date = this.CheckupDate.Date.AddHours(this.CheckupTime.Hours).AddMinutes(this.CheckupTime.Minutes);
var sys = !string.IsNullOrWhiteSpace(this.SystolicReading.ToString())
? this.SystolicReading
: throw new ArgumentException("The Systolic Reading cannot be empty.");
var dbp = !string.IsNullOrWhiteSpace(this.DiastolicBloodPressure.ToString())
? this.DiastolicBloodPressure
: throw new ArgumentException("The blood pressure cannot be empty.");
var weght = !string.IsNullOrWhiteSpace(this.Weight.ToString())
? this.Weight
: throw new ArgumentException("The weight cannot be empty");
var tep = !string.IsNullOrWhiteSpace(this.Temperature.ToString())
? this.Temperature
: throw new ArgumentException("The tmeperature cannot be empty");
var diag = !string.IsNullOrWhiteSpace(this.InitialDiagnosis)
? this.InitialDiagnosis
: throw new ArgumentException("The initial diaggnosis cannot be empty");
var checkup = new RoutineCheck(appnt, nurse, patient, date, sys, dbp, weght, tep, diag);
await vm.EditCheckup(checkup);
this.Editing(false);
this.ChangesMade = true;
}
catch (Exception ex)
{
this.ring.IsActive = false;
this.error.Text = ex.Message;
await Task.Delay(4000);
this.error.Text = "";
}
this.ring.IsActive = false;
}
private void buttonSaveAppointment_Click(object sender, EventArgs e)
{
if (this.comboBoxAppointmentDoctor.SelectedValue == null)
{
MessageBox.Show("Please select a doctor");
return;
}
int patientId = this.patient.PatientID.Value;
DateTime appointmentDateTime = this.dateTimeAppointmentDate.Value;
string reasons = this.textBoxAppointmentReasons.Text;
int doctorId = Int32.Parse(this.comboBoxAppointmentDoctor.SelectedValue.ToString());
bool successful = false;
if (this.appointmentUpdateMode)
{
Appointment oldAppointment = (Appointment)this.listViewAppointments.SelectedItems[0].Tag;
if (this.validateAppointmentInfo(appointmentDateTime, patientId, doctorId, reasons, oldAppointment))
{
DateTime oldDateTime = oldAppointment.DateTime;
successful = AppointmentDAL.UpdateAppointment(this.patient.PatientID.Value, oldDateTime, appointmentDateTime, doctorId, reasons);
}
else
{
return;
}
}
else if (this.validateAppointmentInfo(appointmentDateTime, patientId, doctorId, reasons))
{
successful = AppointmentDAL.AddAppointment(patientId, appointmentDateTime, doctorId, reasons);
}
else
{
return;
}
if (successful)
{
this.reloadAppointments();
this.clearAppointmentDetailsFields();
this.groupBoxAppointmentInfo.Enabled = false;
this.toggleCurrentlyEditingAppointment(false);
}
else
{
MessageBox.Show("An error occured while saving the appointment");
}
}
/// <see cref="AppointmentDAL.UpdateAppointment(Appointment)"
public bool UpdateAppointment(Appointment appointment)
{
if (appointment == null || appointment.PatientID == null || appointment.DoctorID == null)
{
throw new ArgumentNullException("appointment, patientID, and doctorID cannot be null");
}
if (appointment.AppointmentDateTime == null)
{
throw new ArgumentNullException("please specify a time for the visit");
}
if (String.IsNullOrWhiteSpace(appointment.ReasonForVisit))
{
throw new ArgumentNullException("please give a reason for the visit");
}
return(AppointmentDAL.UpdateAppointment(appointment));
}
static void Main(string[] args)
{
Console.WriteLine("Starting tests");
AppointmentDAL.DEBUG = true;
//AppointmentDAL.InsertAppointment(1, 22, 1, "sometime", "sometime", "somet ime");
//List<Appointment> a = AppointmentDAL.GetDoctorAppointments(1);
AppointmentDAL.InsertAppointment(1, 32, (int)StatusEnum.Success, "2015-01-01", "8:00AM", "");
//TestDB();
//TestPatientSearch();
Console.ReadLine();
}
public ActionResult PatientAppointment(string date)
{
string username = TempData["username"].ToString();
TempData.Keep();
if (ModelState.IsValid)
{
List <Appointment> patientsList = new List <Appointment>();
patientsList = AppointmentDAL.GetAll(username, date);
return(View(patientsList));
}
else
{
ModelState.AddModelError("", "Enter valid date..!!");
return(View());
}
}
private void handleSaveAppointment()
{
if (this.IsEditingAppointment)
{
var appt = this.buildAppointment();
appt.ID = this.AppointmentControl.SelectedAppointment.ID;
AppointmentDAL.UpdateAppointment(appt);
MessageBox.Show("The appointment has been updated.", "Updated Appointment", MessageBoxButtons.OKCancel);
this.Close();
}
else
{
var appt = this.buildAppointment();
AppointmentDAL.InsertAppointment(appt);
MessageBox.Show("The appointment has been created.", "New Appointment", MessageBoxButtons.OKCancel);
this.Close();
}
}
/// <summary>
///
/// </summary>
/// <param name="objPOType"></param>
/// <returns></returns>
public static bool Save(Appointment objAppoint, User objCurUser)
{
bool flgSave;
try
{
using (TransactionScope objTScope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
if (objAppoint.IsEdited || objAppoint.IsNew)
{
AppointmentDAL.Save(objAppoint, objCurUser);
}
flgSave = true;
objTScope.Complete();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(flgSave);
}
private async void addCheckup(object sender, RoutedEventArgs e)
{
this.ring.IsActive = true;
try
{
var aId = int.Parse(this.aID.Text);
var nId = int.Parse(this.nID.Text);
var time = this.timeicker.Time;
var date = this.datePicker.Date.Date.AddHours(time.Hours).AddMinutes(time.Minutes);
var sys = int.Parse(this.sysReadind.Text);
var bPr = int.Parse(this.bPressure.Text);
var _weight = double.Parse(this.weight.Text);
var temp = double.Parse(this.temp.Text);
var ini = this.summaryTextBox.Text;
var appointmentdal = new AppointmentDAL();
var appointment = await appointmentdal.GetAppointmentById(aId);
var nursedal = new NurseDAL();
var nurse = await nursedal.GetNurseByNurseId(nId);
var checkup = new RoutineCheck(appointment, nurse, appointment.Patient, date, sys, bPr, _weight, temp,
ini);
await this.viewModel.AddCheckup(checkup);
await this.viewModel.LoadAllAppointments();
var confirmBox = new MessageDialog($"CheckUp completed {date.ToShortDateString()}");
this.ring.IsActive = false;
await confirmBox.ShowAsync();
}
catch (Exception ex)
{
this.ring.IsActive = false;
var messageDialog = new MessageDialog(ex.Message);
await messageDialog.ShowAsync();
}
}
