public async Task PatientRepositroyUpdatePatientAsyncSuccessTest() { var testModel = new PatientModel() { Id = new Guid(), FirstName = "John", LastName = "Hu", Gender = Gender.male, DateOfBirth = new DateTime(1992, 2, 14), Email = "*****@*****.**", Phone = "0425789632", CreateTime = DateTime.Now, UpdateTime = DateTime.Now, }; var expected = new PatientModel() { Id = testModel.Id, FirstName = "Tee", LastName = "Hu", Gender = Gender.male, DateOfBirth = new DateTime(1992, 2, 14), Email = "*****@*****.**", Phone = "0425789632", CreateTime = DateTime.Now, UpdateTime = DateTime.Now, }; using (var context = new PatientDbContext(dbOptionsBuilder.Options)) { context.Patients.Add(testModel); context.SaveChanges(); var entity = context.Patients.Single(p => p.Id == testModel.Id); //To Avoid tracking error context.Entry(entity).State = EntityState.Detached; var repo = new PatientRepository(context); var result = await repo.UpdatePatientAsync( new PatientModel() { Id = testModel.Id, FirstName = "Tee", LastName = "Hu", Gender = Gender.male, DateOfBirth = new DateTime(1992, 2, 14), Email = "*****@*****.**", Phone = "0425789632", CreateTime = DateTime.Now, UpdateTime = DateTime.Now, }); context.SaveChanges(); Assert.AreEqual("Tee", result.FirstName); } }
public IActionResult ChangeDoctorData(Doctor newDoctorData) { if (!context.Doctor.Any(d => d.IdDoctor == newDoctorData.IdDoctor)) { return(NotFound("Such Doctor does not exists!")); } Doctor doctor = context.Doctor.Find(newDoctorData.IdDoctor); doctor.FirstName = newDoctorData.FirstName; doctor.LastName = newDoctorData.LastName; doctor.Email = newDoctorData.Email; context.SaveChanges(); return(Ok("Updated")); }
/// <summary> /// Seeds the specified patient database context. /// </summary> /// <param name="patientDbContext">The patient database context.</param> public static void Seed(this PatientDbContext patientDbContext) { patientDbContext.Add(new Patient { Forename = $"Arindam", Surname = $"Dhar", DateOfBirth = Convert.ToDateTime("23/10/1985"), Gender = true, TelephoneNumber = "{\"WorkNumber\" : \"123456789\"}" }); patientDbContext.Add(new Patient { Forename = $"User1", Surname = $"Surname1", DateOfBirth = Convert.ToDateTime("03/01/1989"), Gender = true, TelephoneNumber = "{\"MobileNumber\" : \"123456789\", \"WorkNumber\" : \"234567\" }" }); patientDbContext.Add(new Patient { Forename = $"User2", Surname = $"Surname2", DateOfBirth = Convert.ToDateTime("03/01/1999"), Gender = false, TelephoneNumber = "{\"MobileNumber\" : \"123456789\", \"HomeNumber\" : \"9998645\"}" }); patientDbContext.SaveChanges(); }
public async Task PatientRepositroyUpdatePatientAsyncNullTest() { var testModel = new PatientModel() { Id = new Guid(), FirstName = "John", LastName = "Hu", Gender = Gender.male, DateOfBirth = new DateTime(1992, 2, 14), Email = "*****@*****.**", Phone = "0425789632", CreateTime = DateTime.Now, UpdateTime = DateTime.Now, }; using (var context = new PatientDbContext(dbOptionsBuilder.Options)) { context.Patients.Add(testModel); context.SaveChanges(); var repo = new PatientRepository(context); var result = await repo.UpdatePatientAsync(new PatientModel() { Id = new Guid() }); Assert.IsNull(result); } }
public IActionResult AddPatient(Patient patientObj) { _logger.LogInformation("Add Patient"); _db.Patients.Add(patientObj); //in memory _db.SaveChanges(); //physical commit return(Content("result")); }
private void Save(object sender, RoutedEventArgs e) { patient.Title = txtTitle.Text; patient.FirstName = txtFirstName.Text; patient.LastName = txtLastName.Text; patient.PatientId = txtPatientId.Text; patient.Birthday = dtBirthday.DisplayDate; patient.Age = Int32.Parse(txtAge.Text != "" ? txtAge.Text : "0"); patient.AgeType = cbAgeType.SelectedIndex == 0 ? AgeType.Year : AgeType.Month; patient.StudyDate = dtStudyDate.DisplayDate; patient.StudyDescription = txtStudyDescription.Text; patient.RequestingPhysician = txtRequestingPhysician.Text; patient.AccessionNumber = txtAccessionNumber.Text; patient.Note = txtNote.Text; //patient.Pregnant = cbPregnant.IsChecked == true ? true : false; patient.NA = cbNa.IsChecked == true ? true : false; patient.Gender = rdMale.IsChecked == true ? GenderType.Male : rdFemale.IsChecked == true ? GenderType.Female : GenderType.None; if (patient.FirstName.Trim() == "") { MessageControl messageControl = new MessageControl("Warning", "Please enter firstname!"); messageControl.ShowDialog(); } else if (patient.LastName.Trim() == "") { MessageControl messageControl = new MessageControl("Warning", "Please enter lastname!"); messageControl.ShowDialog(); } else if (patient.PatientId.Trim() == "") { MessageControl messageControl = new MessageControl("Warning", "Please enter patient ID!"); messageControl.ShowDialog(); } else { var item = patientDbContext.Patients.FirstOrDefault(i => i.Id == patient.Id); if (item == null || item.Id == -1) { patient.Created = DateTime.Now; patientDbContext.Patients.Add(patient); } else { item = patient; } int value = patientDbContext.SaveChanges(); if (value > -1) { // MessageBox.Show("salam pesar!"); nowRefresh(); } } }
public Patient Insert(Patient p) { BeginTransaction(); try { context.Database.UseTransaction(Transaction as System.Data.Common.DbTransaction); dapper.Transaction = Transaction; //context.Patients.Attach(p); context.Entry <Patient>(p).State = EntityState.Added; context.Patients.Add(p); context.SaveChanges(); p.Address = "Updated Address Dpr"; dapper.Update(p); Transaction.Commit(); } catch (Exception ex) { Transaction.Rollback(); } return(p); }
public static void PopulateTestData(PatientDbContext dbContext) { dbContext.Patients.AddRange(new PatientEntity { Id = 1, Name = "TestPatient1" }, new PatientEntity { Id = 2, Name = "TestPatient2" }); dbContext.SaveChanges(); }
public IActionResult AddDoctor(DoctorRequest doctorRequest) { if (_context.Doctor.Any(e => e.IdDoctor == doctorRequest.IdDoctor)) { return(BadRequest("Doctor already exists.")); } else { var doctor = new Doctor() { IdDoctor = doctorRequest.IdDoctor, Email = doctorRequest.Email, FirstName = doctorRequest.FirstName, LastName = doctorRequest.LastName, prescriptions = new List <Prescription>() }; _context.Add(doctor); _context.SaveChanges(); return(Ok("Doctor " + doctor.Email + " added!")); } }
public void PatientRepositroyGetQueryablePatientTest() { var testData = TestDataGenerateHelper.createPatientModelData(); using (var context = new PatientDbContext(dbOptionsBuilder.Options)) { context.Patients.AddRange(testData); context.SaveChanges(); var repo = new PatientRepository(context); var result = repo.GetQueryablePatient(); Assert.IsNotNull(result); } }
private static void SeedSampleData(PatientDbContext dbContext) { dbContext.Patients.Add(new Entities.Patient { FirstName = "Firstname", LastName = "Lastname", Address = "Address", DateOfBirth = DateTime.Today, Phone = "111-222-3333", Sex = "F" }); dbContext.SaveChanges(); }
public async Task PatientRepositroyGetPatientByIdSuccessTest() { var testData = TestDataGenerateHelper.createPatientModelData(); using (var context = new PatientDbContext(dbOptionsBuilder.Options)) { context.Patients.AddRange(testData); context.SaveChanges(); var repo = new PatientRepository(context); var result = await repo.GetPatientByIdAsync(testData[0].Id); Assert.IsNotNull(result); } }
public void AddPatient(Patient patient) { patient.DateOfBirth = patient.DateOfBirth.Date; try { _patientDbContext.Patients.Add(patient); _patientDbContext.SaveChanges(); } catch (DbUpdateConcurrencyException e) { _logger.LogError(e, "A database concurrency error occured."); throw; } catch (Exception e) { _logger.LogError(e, "An error occured in the database service."); throw; } }
public void createPatient(Patient entity) { _patientContext.Patients.Add(entity); _patientContext.SaveChanges(); }