public void DeletePersonOnlyName() { DataBase dataBase = new DataBase(); string name = Guid.NewGuid().ToString(); PersonInfo personInfo = new PersonInfo {Name = name}; int rowsInserted = dataBase.PersonInfoInsert(personInfo); Assert.AreEqual(1, rowsInserted, "Person not inserted!"); List<PersonInfo> list = dataBase.PersonInfoGetAll(); Assert.IsNotNull(list, "At least one person info was expected!"); PersonInfo info = list.Find(p => p.Name == name); Assert.AreEqual(name, info.Name, "PersonInfo not found! '{0}'", name); int rowsDeleted = dataBase.PersonInfoDelete(info.Id); Assert.AreEqual(1, rowsDeleted, "Person not deleted!"); }
public void UpdatePersonInfo() { DataBase dataBase = new DataBase(); string name = Guid.NewGuid().ToString(); PersonInfo personInfo = new PersonInfo { Name = name, SurName = "surname", NickName = "nickname", Description = "description", Address = "adddress", PostNumber = 123, City = "city", Email = "*****@*****.**", Telephone = "00386 2 876 1234", TelephoneMobile = "++386 40 123 456", Fax = "+386 2 8761 211" }; int rowsInserted = dataBase.PersonInfoInsert(personInfo); Assert.AreEqual(1, rowsInserted, "Person not inserted!"); List<PersonInfo> list = dataBase.PersonInfoGetAll(); Assert.IsNotNull(list); PersonInfo find = list.Find(p => p.Name == name); Assert.IsNotNull(find); string newName = Guid.NewGuid().ToString(); find.Name = newName; int rowsUpdated = dataBase.PersonInfoUpdate(find); Assert.AreEqual(1, rowsUpdated); PersonInfo updatedPersonInfo = dataBase.PersonInfoGet(find.Id); Assert.AreEqual(newName, updatedPersonInfo.Name); Assert.AreEqual(personInfo.SurName, updatedPersonInfo.SurName); Assert.AreEqual(personInfo.NickName, updatedPersonInfo.NickName); Assert.AreEqual(personInfo.Description, updatedPersonInfo.Description); Assert.AreEqual(personInfo.Address, updatedPersonInfo.Address); Assert.AreEqual(personInfo.PostNumber, updatedPersonInfo.PostNumber); Assert.AreEqual(personInfo.City, updatedPersonInfo.City); Assert.AreEqual(personInfo.Email, updatedPersonInfo.Email); Assert.AreEqual(personInfo.Telephone, updatedPersonInfo.Telephone); Assert.AreEqual(personInfo.TelephoneMobile, updatedPersonInfo.TelephoneMobile); Assert.AreEqual(personInfo.Fax, updatedPersonInfo.Fax); }