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