public void CanAppointmentRepositoryAdd()
{
// arrange
var mockSpaContext = new Mock <SpaContext>(new DbContextOptionsBuilder <SpaContext>().Options);
var mockReadOnlyContext = new Mock <IReadOnlySpaContext>();
AppointmentRepository repo = new AppointmentRepository(mockSpaContext.Object, mockReadOnlyContext.Object);
var testAppt = new Appointment()
{
AppTime = DateTime.Now,
Id = 0,
Description = "This is a test appointment",
CustomerId = 1,
ProviderId = 1
};
mockSpaContext.Setup(x => x.Appointments.Add(testAppt));
mockSpaContext.Setup(x => x.SaveChanges());
//act
repo.Add(testAppt);
// assert
var a = repo.Appointments.FirstOrDefault(x => x.Id == testAppt.Id);
Assert.NotNull(a);
}
public void TestCreatePatient()
{
AppointmentRepository appointmentRepository = new AppointmentRepository();
Appointment appointment1 = new Appointment("id1", "patient_id2", "diag1", false);
Assert.AreEqual(appointmentRepository.AppointmentsCount, 0);
appointmentRepository.Add(appointment1);
Assert.AreEqual(appointmentRepository.AppointmentsCount, 1);
Assert.AreEqual(appointmentRepository.GetByID(appointment1.ID), appointment1);
appointmentRepository.Add(new Appointment("id2", "patient_id2", "diag2", false));
Assert.AreEqual(appointmentRepository.AppointmentsCount, 2);
}
public Appointment CreateAppointment(Animal animal, Customer owner)
{
//Console.WriteLine("Creating appointment...");
//Console.WriteLine("Choose date:");
//var dateTime = Console.ReadLine();
var appointment = InstanceHelper.CreateInstance <Appointment>();
appointment.Owner = owner;
appointment.Animal = animal;
//var appointment = new Appointment
//{
// DateTime = dateTime,
// Animal = animal,
// Owner = owner
//};
Appointment.AppointmentCreatedEvent.Invoke(appointment, new AppointmentCreatedEventArgs
{
AppointmentNumber = ++AppointmentCounter
});
_appointmentRepository.Add(appointment);
return(appointment);
}
public void ScheduleRandomDateAppointment(AppointmentRepository repository, AppointmentCreateDto appointmentCreateDto)
{
var appointmentItem = _mapper.Map <AppointmentItem>(appointmentCreateDto);
appointmentItem.AppointmentDate = GetRandomAppointmentDate(_appSettings.MaximumDaysForRandomAppointmentDate);
repository.Add(appointmentItem);
repository.Save();
}
public ActionResult AppointmentByStudent(AppointmentByStudentModel model)
{
// A student wishes to make an appointment with their counseler.
if (ModelState.IsValid)
{
// Get the logged in student and counseler of the class the student is in.
var student = Student;
var @class = _classRepository.GetById(student.ClassId);
var counseler = CounselerRepository.GetById(@class.CounselerId);
if (counseler != null && student != null)
{
// Create the appointment for the student and couseler.
var appointment = new Appointment
{
CounselerId = counseler.Id,
StudentId = student.Id,
DateTime = model.DateTime,
Location = model.Location
};
int id = _appointmentRepository.Add(appointment);
// Send the appointment request mail.
var mail = new AppointmentMail
{
Counseler = counseler,
Student = student,
DateTime = appointment.DateTime,
Location = appointment.Location,
AcceptUrl = FullUrl("AppointmentResponse", new { id }),
FromCounseler = false
};
_mailHelper.SendAppointmentMail(mail);
return(RedirectToAction("Details", "Appointment", new { id }));
}
}
PrepareStudentCounselingRequestModel(model);
return(View(model));
}
public IActionResult AddAppointment([FromBody] Appointment appointment, string userName)
{
if (loggedInPatients.checkIfLoggedIn(userName))
{
var addedAppointment = appointmentRepository.Add(appointment);
return(Ok(addedAppointment));
}
else
{
return(Ok());
}
}
public ActionResult Create(Appointment appointments)
{
try
{
AppointmentRepository.Add(appointments);
repo.isAppointmentAvailable(appointments.AppTime);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public void CanAppointmentRepositoryCreate()
{
// arrange
var testAppt = new Appointment()
{
};
//act
AppointmentRepository.Add(testAppt);
// assert
var a = AppointmentRepository.Appointments.FirstOrDefault(x => x.Id == testAppt.Id);
Assert.NotNull(a);
}
public Appointment AddAppointment(string id, string patientId, string diagnostic, bool isEmergency)
{
if (patientRepository.Contains(patientId) == false)
{
throw new RepositoryException("Specified patient does not exist");
}
Appointment appointment = new Appointment();
appointment.ID = id;
appointment.PatientID = patientId;
appointment.Diagnostic = diagnostic;
appointment.IsEmergency = isEmergency;
appointment.Validate();
appointmentRepository.Add(appointment);
patientRepository.AddAppointment(id, patientId);
return(appointment);
}
public RedirectToActionResult CreateAppointment(AppointmentViewModel appointment)
{
if (context.Appointments.Where(x => x.AppointmentDate == appointment.AppointmentDate && x.Doctor.DoctorID == appointment.Doctor.DoctorID).Any())
{
return(RedirectToAction("AppointmentExists"));
}
else
{
Models.Appointment appointmentModel = new Models.Appointment();
appointmentModel.Doctor = context.Doctors.FirstOrDefault(x => x.DoctorID == appointment.Doctor.DoctorID);
appointmentModel.UserName = userManager.GetUserName(User);
appointmentModel.AppointmentDate = appointment.AppointmentDate;
Appointment newAppointment = _appointmentRepository.Add(appointmentModel);
context.SaveChanges();
}
return(RedirectToAction("MyAppointment"));
}
public ActionResult TruncateDB()
{
// _db.ExecuteCommand("TRUNCATE TABLE Entity");
_db.AppointmentTimeSlot.RemoveRange(_db.AppointmentTimeSlot);
_db.Appointment.RemoveRange(_db.Appointment);
_db.Pet.RemoveRange(_db.Pet);
_db.Specie.RemoveRange(_db.Specie);
_db.Member.RemoveRange(_db.Member);
_db.TimeSlot.RemoveRange(_db.TimeSlot);
_db.SaveChanges();
_db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('Appointment', RESEED, 0)");
_db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('AppointmentTimeSlot', RESEED, 0)");
_db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('Pet', RESEED, 0)");
_db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('Specie', RESEED, 0)");
_db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('Member', RESEED, 0)");
_db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('TimeSlot', RESEED, 0)");
// DateTime current = DateTime.Now;
// int day = DateTime.Now.Day;
// DateTime year;
TimeSpan start = new TimeSpan(09, 30, 0);
TimeSpan end = new TimeSpan(21, 00, 0);
//Start from monday -> sunday
DateTime today = new DateTime(2017, 11, 15);
// lastMonday is always the Monday before nextSunday.
// When date is a Sunday, lastMonday will be tomorrow.
int offset = today.DayOfWeek - DayOfWeek.Monday;
DateTime lastMonday = today.AddDays(-offset);
DateTime endWeek = lastMonday.AddDays(6);
// var monday = today.AddDays(-(int)DateTime.Today.DayOfWeek + (int)DayOfWeek.Monday);
//Loop for this week
while (lastMonday <= endWeek)
{
//Start from monday -> sunday
DateTime dt = new DateTime(lastMonday.Year, lastMonday.Month, lastMonday.Day);
//Loop for hour in day
DateTime startTime = new DateTime(dt.Year, dt.Month, dt.Day) + start;
DateTime endTime = new DateTime(dt.Year, dt.Month, dt.Day) + end;
var hours = new List <DateTime>();
hours.Add(startTime);
var next = new DateTime(startTime.Year, startTime.Month, startTime.Day,
startTime.Hour, startTime.Minute, 0, startTime.Kind);
while ((next = next.AddHours(0.5)) < endTime)
{
hours.Add(next);
}
hours.Add(endTime);
foreach (var hour in hours)
{
TimeSlot timeblock = new TimeSlot();
timeblock.startTime = hour;
timeblock.endTime = hour.AddHours(0.5);
timeblock.numberofCase = 0;
timeblock.status = "Free";
TimeSlotService.Add(timeblock);
var check = timeblock.id;
}
lastMonday = lastMonday.AddDays(1);
}
// Add member
List <Member> members = new List <Member>()
{
new Member {
email = "*****@*****.**", password = "******", name = "one", surname = "someone", address = "t1 address", phonenumber = "0950828781"
},
new Member {
email = "*****@*****.**", password = "******", name = "two", surname = "tomorrow", address = "t2 address", phonenumber = "0222222222"
},
new Member {
email = "*****@*****.**", password = "******", name = "three", surname = "teatime", address = "t3 home", phonenumber = "0333333333"
},
};
foreach (Member member in members)
{
MemberService.Add(member);
}
// Add type
List <Specie> types = new List <Specie>()
{
new Specie {
name = "cat"
},
new Specie {
name = "dog"
},
new Specie {
name = "rabbit"
},
new Specie {
name = "fish"
}
};
foreach (Specie type in types)
{
SpecieService.Add(type);
}
/* // Add type
* List<VAService> services = new List<VAService>()
* {
* new VAService {description ="Vaccination"},
* new VAService {description ="Health check"},
* new VAService {description ="Fllow up"},
* new VAService {description ="Surgery"},
* };
* foreach (VAService service in services)
* {
* VAService.Add(service);
* }*/
// Add pet
List <Pet> pets = new List <Pet>()
{
new Pet {
memberId = 1, name = "oneDog", specieId = 2
},
new Pet {
memberId = 1, name = "oneCat", specieId = 1
},
new Pet {
memberId = 2, name = "twoRabbit", specieId = 3
},
};
foreach (Pet pet in pets)
{
PetService.Add(pet);
}
//Update clinic
Clinic clinic = VCService.Get();
clinic.maximumCase = 2;
VCService.Update(clinic);
// Add appointment
//date for 7 aug
TimeSlot a = TimeSlotService.GetByID(1);
TimeSlot b = TimeSlotService.GetByID(2);
TimeSlot c = TimeSlotService.GetByID(8);
//
TimeSlot d = TimeSlotService.GetByID(9);
TimeSlot e = TimeSlotService.GetByID(10);
//
TimeSlot f = TimeSlotService.GetByID(11);
TimeSlot g = TimeSlotService.GetByID(14);
TimeSlot h = TimeSlotService.GetByID(26);
List <Appointment> appointments = new List <Appointment>()
{
new Appointment {
memberId = 1, petId = 2, serviceId = 1, detail = "Rabies vaccine",
suggestion = "",
startTime = a.startTime, endTime = a.endTime, status = "Complete"
},
new Appointment {
memberId = 2, petId = 3, serviceId = 2, detail = "",
suggestion = "",
startTime = a.startTime, endTime = b.endTime, status = "Complete"
},
new Appointment {
memberId = 1, petId = 1, serviceId = 4, detail = "Sterilization",
suggestion = "Stop drinking and eating 4 hour before come to the clinic",
startTime = c.startTime, endTime = f.endTime, status = "Waiting"
},
new Appointment {
memberId = 2, petId = 3, serviceId = 3, detail = "",
suggestion = "",
startTime = g.startTime, endTime = g.endTime, status = "Waiting"
},
new Appointment {
memberId = 2, petId = 3, serviceId = 4, detail = "",
suggestion = "",
startTime = h.startTime, endTime = h.endTime, status = "Waiting"
}
};
foreach (Appointment appointment in appointments)
{
AppointmentService.Add(appointment);
}
// Update timeslot's number of case and status
a.numberofCase = 2;
a.status = "Busy";
b.numberofCase = 1;
c.numberofCase = 1;
c.status = "Full";
d.numberofCase = 1;
d.status = "Full";
e.numberofCase = 1;
e.status = "Full";
f.numberofCase = 1;
f.status = "Full";
g.numberofCase = 1;
h.numberofCase = 1;
h.status = "Full";
TimeSlotService.Update(a);
TimeSlotService.Update(b);
TimeSlotService.Update(c);
TimeSlotService.Update(d);
TimeSlotService.Update(e);
TimeSlotService.Update(f);
TimeSlotService.Update(g);
TimeSlotService.Update(h);
//AppointmentTimeSlot
// Add pet
List <AppointmentTimeSlot> apptimes = new List <AppointmentTimeSlot>()
{
new AppointmentTimeSlot {
timeId = 1, appointmentID = 1
},
new AppointmentTimeSlot {
timeId = 1, appointmentID = 2
},
new AppointmentTimeSlot {
timeId = 2, appointmentID = 2
},
new AppointmentTimeSlot {
timeId = 8, appointmentID = 3
},
new AppointmentTimeSlot {
timeId = 9, appointmentID = 3
},
new AppointmentTimeSlot {
timeId = 10, appointmentID = 3
},
new AppointmentTimeSlot {
timeId = 11, appointmentID = 3
},
new AppointmentTimeSlot {
timeId = 14, appointmentID = 4
},
new AppointmentTimeSlot {
timeId = 26, appointmentID = 5
}
};
foreach (AppointmentTimeSlot app in apptimes)
{
AppTimeService.Add(app);
}
return(Json(new { Result = "Success" }));
}
public async Task <Appointment> Add(Appointment entity)
{
await _repository.Add(entity);
return(entity);
}