static void Main(string[] args) { var repo = new PersonRepository("Data Source=.;Initial Catalog=Salutem.Database;Integrated Security=True;Pooling=False"); repo.Add(new Entities.Person { Name = "test", LastName="fdf" }); var data = repo.GetAllWithDeleted(); foreach (var item in data) { Console.WriteLine(item.Name); } var upd = data.FirstOrDefault(); upd.Name = "Changed"; repo.Update(upd); Console.WriteLine(); data = repo.GetAll(); foreach (var item in data) { Console.WriteLine(item.Name); } Console.WriteLine(); Console.WriteLine(repo.GetById(data.FirstOrDefault().ID).Name); Console.WriteLine(); repo.Delete(data.Where(w => w.Name == "test").FirstOrDefault()); Console.WriteLine(); data = repo.GetAll(); foreach (var item in data) { Console.WriteLine(item.Name); } Console.ReadKey(); }
public void CustomRepo_Added_TestPersons_Get_Ordered_Descending() { List<TestPerson> testPersons; using (IPersonRepository personRepository = new PersonRepository(new TestDatabaseContext())) { personRepository.Add(new TestPerson { Age = 28, Name = "Zebra" }); personRepository.Add(new TestPerson { Age = 28, Name = "Adam" }); personRepository.Add(new TestPerson { Age = 28, Name = "Fabian" }); personRepository.Save(); testPersons = personRepository.GetAll(orderBy: q => q.OrderByDescending(x => x.Name)).ToList(); } Assert.IsNotNull(testPersons); Assert.IsTrue(testPersons[2].Name == "Adam"); Assert.IsTrue(testPersons[1].Name == "Fabian"); Assert.IsTrue(testPersons[0].Name == "Zebra"); }
public void Create_Contact_Not_Called_When_Existing_Contact_Found() { var xdbContactRepository = SetupXdbContactMock(LockAttemptStatus.Success); var personRepository = new PersonRepository(xdbContactRepository.Object, null); personRepository.Add(new Person() { Surname = "Mr Existing", FirstName = "Bob" }); xdbContactRepository.Verify(t => t.CreateContact(It.IsAny<Person>()), Times.Never); }
public void CanDeletePerson() { // Arrange var repository = new PersonRepository(); var person1 = new Person { Age = 1, FirstName = "Zebra", Surname = "Zebra" }; var person2 = new Person { Age = 1, FirstName = "Alpha", Surname = "Beta" }; var person3 = new Person { Age = 1, FirstName = "MandM", Surname = "MandM" }; //Act repository.Add(person1); repository.Add(person2); repository.Add(person3); repository.Delete(person2); // Assert Assert.AreEqual(repository.Count(), 2); Assert.IsTrue(repository.Contains(person3)); Assert.IsTrue(repository.Contains(person1)); Assert.IsFalse(repository.Contains(person2)); }
public void AddPerson() { var person = Person.CreatePerson(-1, "Test First", "Test Last", 21); // Act PersonRepository target = new PersonRepository(context); var result = target.Add(person); // Assert Assert.AreEqual(person, result); }
public void CanAddAPerson() { // Arrange var repository = new PersonRepository(); var person1 = new Person { Age = 1, FirstName = "Alpha", Surname = "Beta" }; //Act repository.Add(person1); // Assert Assert.AreEqual(repository.ToList().First(), person1); }
public ActionResult Register(Person person) { if (ModelState.IsValid) { PersonRepository personRepository = new PersonRepository();//получить доступ к репозиторию ОRM Jigoku.Core.Entities.Person dbPerson = new Jigoku.Core.Entities.Person{NickName = person.NickName, Password = person.Password, PrimaryMail = person.PrimaryMail, Projects = null, UserPhoto = null}; //создать объект "Пользователь" personRepository.Add(dbPerson); //добавить его в БД return View("UserInfo", person); //вернуть страницу с информацией о пользователе } else { return View("Register"); } }
private async void PerformDatabaseOperations() { DatabaseContext databaseContext = new DatabaseContext(); IPersonRepository personRepository = new PersonRepository(databaseContext); IThingRepository thingRepository = new ThingRepository(databaseContext); personRepository.Add(new Person()); thingRepository.Add(new Thing()); personRepository.Save(); List<Person> persons = await personRepository.GetAllASync().Result.ToListAsync(); Console.WriteLine(persons.Count); personRepository.MyNewFunction(6); await personRepository.SaveASync(); List<Person> allASync = await personRepository.GetAllASync().Result.ToListAsync(); thingRepository.Dispose(); personRepository.Dispose(); }
public void CustomRepo_Add_Without_Save_Entry_Does_Not_Exists() { List<TestPerson> testPersons; using (IPersonRepository personRepository = new PersonRepository(new TestDatabaseContext())) { personRepository.Add(new TestPerson()); testPersons = personRepository.GetAll().ToList(); } Assert.IsTrue(testPersons.Count == 0); }
public void DataIsSortedUsingDefaultSortKey() { // Arrange var repository = new PersonRepository(); var person1 = new Person {Age = 1, FirstName = "Alpha", Surname = "Beta"}; var person2 = new Person { Age = 2, FirstName = "Aleph", Surname = "Bate" }; var person3 = new Person { Age = 0, FirstName = "Aleph", Surname = "Bates" }; //Act repository.Add(person1); repository.Add(person3); repository.Add(person2); // Assert Assert.AreEqual(repository.First(), person2); Assert.AreEqual(repository.Last(), person1); }
public void Add(Person person) { _personRepository.Add(person); }
public ActionResult Index(Person person) { PersonRepository.Add(person); return(RedirectToAction("DisplayPersonInfo", "Home", person)); }
public void CustomRepo_Update_Entry_Is_Updated() { TestPerson findByUpdated; using (IPersonRepository personRepository = new PersonRepository(new TestDatabaseContext())) { personRepository.Add(new TestPerson { Age = 28, Name = "Fabian" }); personRepository.Save(); TestPerson findBy = personRepository.GetSingle(x => x.Name == "Fabian"); findBy.Name = "Claudio"; personRepository.Update(findBy); personRepository.Save(); findByUpdated = personRepository.GetSingle(x => x.Name == "Claudio"); } Assert.IsNotNull(findByUpdated); Assert.IsTrue(findByUpdated.Name == "Claudio"); }
public void Post([FromBody] Person person) => _people.Add(person);
public void CustomRepo_Delete_Entry_With_Id_Is_Deleted() { List<TestPerson> testPersons; using (IPersonRepository personRepository = new PersonRepository(new TestDatabaseContext())) { personRepository.Add(new TestPerson { Age = 28, Name = "Fabian" }); personRepository.Save(); TestPerson findBy = personRepository.GetSingle(x => x.Name == "Fabian"); personRepository.Delete(findBy.Id); personRepository.Save(); testPersons = personRepository.GetAll().ToList(); } Assert.IsTrue(testPersons.Count == 0); }
public void AddDefaultPerson() { PersonsVM.Add(new PersonViewModel(personRepo.Add("Specify FirstName", "Specify LastName", 0, "Specify Phone"))); SelectedPersonViewModel = PersonsVM[PersonsVM.Count - 1]; }
public ActionResult Create(Person model) { model.RowGuid = Guid.NewGuid().ToString(); db.Add(model); return(Redirect("Index")); }
/// <summary> /// person region /// </summary> /// <param name="personDto"></param> public string AddPerson(PersonDto personDto) { try { string nationalIdentity = personDto.NationalIdentity; PersonRepository repository = new PersonRepository(); if (repository.ActiveContext.Persons.Where(p => p.NationalIdentity == nationalIdentity).Count() != 0) return "person with this natinal identity is there "; personDto.CustomerId = repository.ActiveContext.Persons.Select(o => o.CustomerId).DefaultIfEmpty(0).Max() + 1; personDto.Id = Guid.NewGuid(); Person person = new Person(); person.InjectFrom<UnflatLoopValueInjection>(personDto); person.ContactInfo.InjectFrom<UnflatLoopValueInjection>(personDto); repository.Add(person); return "person is added successfully by customerId :" + personDto.CustomerId.ToString(); } catch (Exception exception) { return exception.Message; } }
public void AddPerson(Person person) { personRepository.Add(person); }
public void Create_Complex_Account2() { PersonRepository context = new PersonRepository(); Person person = PersonTest.CreatePerson(); Customer customer = PersonTest.CreateCustomer(person); Lawyer lawyer = PersonTest.CreateLawyer(person); if (person != null) { context.Add(person); } /* GeneralAccount generalAccount = CreateGeneralAccount(); IndexAccount indexAccount = CreateIndexAccount(); Account account = CreateAccount(); indexAccount.Accounts.Add(account); generalAccount.IndexAccounts.Add(indexAccount); context.Add(generalAccount); CustomerRepository customerRepository = new CustomerRepository(); customer.Accounts.Add(account); customerRepository.Add(customer); LawyerRepository lawyerRepository = new LawyerRepository(); lawyer.Accounts.Add(account); lawyerRepository.Add(lawyer);*/ }
public int AddPerson(Person person) { return(_personRepository.Add(person)); }