public ActionResult Create(Appointment AppointmentVM, int id)
{
var patientEmail = User.Identity.Name;
var listpatient = serviceUser.GetMany();
var patient = listpatient.SingleOrDefault(pt => pt.Email == patientEmail);
Domain.Entities.Appointment App = new Domain.Entities.Appointment()
{
message = AppointmentVM.message,
HourAppointment = AppointmentVM.HourAppointment,
state = "Invalider",
datePriseRDV = System.DateTime.Now,
reason = AppointmentVM.reason,
dateAppointmentJEE = AppointmentVM.dateAppointmentJEE,
IdPatient = patient.Id,
Iddoctor = id
};
ServiceRDV.Add(App);
ServiceRDV.Commit();
return(RedirectToAction("Index", "PatientAppointement"));
}
public Appointment Create(Appointment appointment)
{
if (appointment == null)
throw new ApplicationException();
appointment.ID = appointments.Count() + 1;
appointments.Add(appointment);
return appointments.Last();
}
public void CreateTest()
{
// Arrange
IAppointmentRepository repository = new AppointmentRepository();
// Arrange
Appointment appointment = new Appointment()
{
Patient = new Patient { FirstName = "Test", LastName = "Test" }
};
// Act
Appointment result = repository.Create(appointment);
// Assert
Assert.AreEqual(appointment, result);
Assert.AreEqual(1, appointment.ID);
}
public List <Visite> MesVisite(string email)
{
var listpatient = serviceUser.GetMany();
var patient = listpatient.SingleOrDefault(pt => pt.Email == email);
Domain.Entities.Appointment App = new Domain.Entities.Appointment();
var p = patient.Id;
List <Visite> visites = new List <Visite>();
string connectionString = @"Data Source=AMAL;Initial Catalog=Epione;Integrated Security=True";
using (SqlConnection s = new SqlConnection(connectionString))
{
s.Open();
using (SqlCommand cmdSelect = new SqlCommand($"SELECT dateAppointment , datePriseRDV , reason , firstName ,lastName , Email , PhoneNumber , Address , note from Appointments a JOIN Users u on a.Iddoctor = u.Id where a.IdPatient={p} and a.state='valider' ", s))
{
cmdSelect.CommandType = CommandType.Text;
using (SqlDataReader sqlDataReader = cmdSelect.ExecuteReader())
{
while (sqlDataReader.Read())
{
visites.Add(new Visite
{
dateAppointment = (DateTime)sqlDataReader[0],
datePriseRDV = (DateTime)sqlDataReader[1],
reason = sqlDataReader[2].ToString(),
firstName = sqlDataReader[3].ToString(),
lastName = sqlDataReader[4].ToString(),
Email = sqlDataReader[5].ToString(),
PhoneNumber = sqlDataReader[6].ToString(),
Address = sqlDataReader[7].ToString(),
note = (int)sqlDataReader[8],
});
}
}
}
}
return(visites);
}
public List <Appointment> AnnulerAppointment(string email)
{
var listpatient = serviceUser.GetMany();
var patient = listpatient.SingleOrDefault(pt => pt.Email == email);
Domain.Entities.Appointment App = new Domain.Entities.Appointment();
var p = patient.Id;
var Rdvs = new List <Appointment>();
string connectionString = @"Data Source=AMAL;Initial Catalog=Epione;Integrated Security=True";
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand command = new SqlCommand($"DELETE FROM Appointments WHERE CONVERT(VARCHAR(10), datePriseRDV, 101) = CONVERT(VARCHAR(10), GETDATE(), 101)and appointmentId = (SELECT MAX(appointmentId) FROM Appointments where IdPatient = {p})", con))
using (SqlDataReader reader = command.ExecuteReader()) { };
}
return(Rdvs);
}
public void CreateAppointmentTest()
{
// Arrange
IAppointmentRepository repository = new AppointmentRepository();
IAppointmentService service = new AppointmentService(repository);
// Arrange
Appointment appointment = new Appointment()
{
Patient = new Patient { FirstName = "Test", LastName = "Test" }
};
// Arrange
CreateAppointmentRequest request = new CreateAppointmentRequest() { Appointment = appointment };
// Act
AppointmentResponse result = service.CreateAppointment(request);
// Assert
Assert.AreEqual(appointment.ID, result.Appointment.ID);
Assert.AreEqual(appointment.Patient, result.Appointment.Patient);
Assert.IsTrue(result.Success);
}
