public void GivenqueryforUpdatingdataFromContactTypeTable_WhenDatabaseIsConnected_ShouldReturnTrue() { AddressBookRepo addressBookRepo = new AddressBookRepo(); bool actual = addressBookRepo.UpdateContactTypeTable("Contact_typeID =1"); Assert.IsTrue(actual); }
public void GivenRetrieveData_ShouldReturnTrue() { AddressBookRepo addressBookRepo = new AddressBookRepo(); bool result = addressBookRepo.GetAllDetails(); Assert.IsTrue(result); }
public void GivenStartDateAndEndDate_WhenImproper_ShouldReturnFalse() { AddressBookRepo addressBookRepo = new AddressBookRepo(); bool result = addressBookRepo.GetContactsByDateRange("2020-10-16", "2020-05-11"); Assert.IsFalse(result); }
public void GivenFirstNameAndLastName_WhenMatch_ShouldReturnTrue() { AddressBookRepo addressBookRepo = new AddressBookRepo(); bool result = addressBookRepo.UpdateContact("Aayush", "Kadam"); Assert.AreEqual(result, true); }
public void GivenStartDateAndEndDate_WhenMatch_ShouldReturnTrue() { AddressBookRepo addressBookRepo = new AddressBookRepo(); bool result = addressBookRepo.GetContactsByDateRange("2019-02-03", "2020-10-22"); Assert.IsTrue(result); }
public void TestMethod1() { List <AddressModel> addressModel = new List <AddressModel>(); //List for Multiple List // AddressBookRepo addressBookRepo = new AddressBookRepo(); //Addition of Multiple Address addressModel.Add(new AddressModel("Virat", "Kohli", "Captain", "Delhi", "NewDelhi", "India", "147852", "9999999", "*****@*****.**", new DateTime(2020, 11, 5))); addressModel.Add(new AddressModel("Mahi", "Dhoni", "Legend", "Ranchi", "Chennai", "India", "148852", "9989999", "*****@*****.**", new DateTime(2020, 8, 15))); //Time taken to Add Contact without Thread DateTime startDateTime = DateTime.Now; //Initialization addressBookRepo.AddMultipleAddress(addressModel); DateTime endDateTime = DateTime.Now; //Completion Console.WriteLine("Without Thread : " + (endDateTime - startDateTime)); //Time taken to Add Contact with Thread DateTime startDateTimeThread = DateTime.Now; //Initialization addressBookRepo.AddMultipleAddressWithThread(addressModel); DateTime endDateTimeThread = DateTime.Now; //Completion Console.WriteLine("With Thread : " + (endDateTimeThread - startDateTimeThread)); }
public void GivenFirstNameAndLastName_WhenNotMatch_ShouldReturnFalse() { AddressBookRepo addressBookRepo = new AddressBookRepo(); bool result = addressBookRepo.UpdateContact("Yash", "Rasal"); Assert.IsFalse(result); }
public void AddNewContact() { // Arrange AddressBookRepo addressBookRepo = new AddressBookRepo(); ContactDetails contact = new ContactDetails(); contact.FirstName = "Bhaskar"; contact.LastName = "chandra"; contact.PhoneNumber = "1212121212"; contact.Email = "*****@*****.**"; contact.Address = "this nagar"; contact.zip.zip = "123456"; contact.zip.city = "Mumbai"; contact.zip.state = "Maharastra"; contact.bookNameContactType.Add("yesBook", new List <string> { "Friend", "Family" }); // Act addressBookRepo.AddNewContact(contact); List <ContactDetails> actual = addressBookRepo.GetContacts().FindAll(contact => contact.FirstName == "Bhaskar" && contact.LastName == "chandra"); List <ContactDetails> expected = new List <ContactDetails> { contact }; // Assert CollectionAssert.AreEqual(actual, expected); }
public void GivenqueryforUpdatingdataFromContactTable_WhenDatabaseIsConnected_ShouldReturnFalse() { AddressBookRepo addressBookRepo = new AddressBookRepo(); bool actual = addressBookRepo.UpdateContactTable("PersonId = 45"); Assert.IsFalse(actual); }
public void GivenqueryforRetrivingdataFromContactTypeTable_WhenDatabaseIsConnected_ShouldReturnFalse() { AddressBookRepo addressBookRepo = new AddressBookRepo(); bool actual = addressBookRepo.GetAllDataOfContactType("ContactType"); Assert.IsFalse(actual); }
public void GivenAddressBookDB_WhenRetrieve_ThenReturnContactsFromDataBase() { AddressBookRepo addressbookrepo = new AddressBookRepo(); int result = addressbookrepo.RetrieveContactFromPerticularAddressBook(); int expect = 11; Assert.AreEqual(result, expect); }
public void GivenUpdate_ShouldBeUpdateInDatabase() { string expected = "California"; string actual = AddressBookRepo.UpdateDatabase(); Assert.AreEqual(expected, actual); }
public void RetrieveAllContacts_WhenCalled_AddContactsToList() { AddressBookRepo.RetrieveAllContacts(); var list = AddressBookRepo.contacts; Assert.That(list, Is.Not.Empty); }
public void GivenAddressBook_returnNumberOf_ContactsFromPerticularCityOrState() { AddressBookRepo addrepo = new AddressBookRepo(); int count = addrepo.RetrieveContactFromPerticularCityOrState(); int expected = 7; Assert.AreEqual(expected, count); }
public void GivenContactInsertDate_ThenReturnTotalEmployeeBetweenRange() { AddressBookRepo addrepo = new AddressBookRepo(); int count = addrepo.getContactDataWithGivenDate(); int expected = 5; Assert.AreEqual(expected, count); }
public void ChekConnection() { AddressBookRepo addressbookrepo = new AddressBookRepo(); bool result = addressbookrepo.EstablishConnection(); bool expect = true; Assert.AreEqual(result, expect); }
public void GivenqueryforAddingContactToTable_WhenDatabaseIsConnected_ShouldReturnFalse() { AddressBookModel addressBookModel = new AddressBookModel(); AddressBookRepo addressBookRepo = new AddressBookRepo(); bool actual = addressBookRepo.AddContact(addressBookModel); Assert.IsFalse(actual); }
public void GivenDeleteQuery_ShouldReturn_NumberofDeletedRows() { AddressBookRepo aRepo = new AddressBookRepo(); //Delete Rows with selected DateRange string deleteQuery = @"delete from ABookTable where DateAdded between '2012-07-29' and '2013-06-29';"; int actualRowsDeleted = aRepo.DeleteRowsForSelectedDateRange(deleteQuery); Assert.AreEqual(actualRowsDeleted, 3); }
public void Given_RetrieveContactsFromDatabase_ShouldReturnCount() { AddressBookRepo repo = new AddressBookRepo(); bool expected = true; bool result = repo.RetrieveFromDatabase(); Assert.AreEqual(expected, result); }
public void GivenQueryForAddingContact_WhenDatabaseConnected_ShouldReturnFalse_SadCase() { AddressBookRepo addressBookRepo = new AddressBookRepo(); AddressBookModel model = new AddressBookModel(); bool actual = addressBookRepo.AddContactToDatabase(model); Assert.IsFalse(actual); }
public void GivenNameFromDB_SearchContactShould_ReturnTrue() { AddressBookRepo repo = new AddressBookRepo(); bool expected = true; string firstName = "Edwin"; string lastName = "Jarvis"; bool result = repo.SearchContact(firstName, lastName); Assert.AreEqual(expected, result); }
public void RetrieveAllContactsInDateRange_WhenCalled_AddContactsToList() { var startDate = Convert.ToDateTime("01/01/2019"); var endDate = Convert.ToDateTime("01/01/2020"); AddressBookRepo.RetrieveAllContactsInDateRange(startDate, endDate); var list = AddressBookRepo.contacts; Assert.That(list, Is.Not.Empty); }
/// <summary> /// Givens the data to update data base it should return if exis false. /// </summary> public void GivenDataToUpdateDataBase_ItShouldReturnIfExisFalse() { /// Arrange string query = "update Address_Book set Address = 'Gowtham Nagar' where FullName = 'Sridhar"; AddressBookRepo addressBookRepo = new AddressBookRepo(); /// Act bool updateBasicPay = addressBookRepo.UpdateContactFromTable(query); /// Assert Assert.AreEqual(updateBasicPay, false); }
public void GivenNameNotInDB_SearchContactShould_ReturnFalse() { AddressBookRepo repo = new AddressBookRepo(); bool expected = false; string firstName = "No"; string lastName = "Contact"; bool result = repo.SearchContact(firstName, lastName); Assert.AreEqual(expected, result); }
public void GetContactsAddedInParticularPeriod() { // Arrange AddressBookRepo addressBookRepo = new AddressBookRepo(); // Act List <ContactDetails> actualContactList = addressBookRepo.GetContactsAddedInPeriod(new DateTime(2012, 05, 05), new DateTime(2013, 06, 06)); List <ContactDetails> expectedContactList = addressBookRepo.GetContacts("Abhi", "J"); // Assert CollectionAssert.AreEqual(actualContactList, expectedContactList); }
public void GivenUpdateStatement_ShouldCheck_UpdatedRow() { AddressBookRepo aRepo = new AddressBookRepo(); string updateQuery = @"update AddressInfo set State='T.L.' where FirstName='Mohanee';"; aRepo.UpdateContact(updateQuery); string testQuery = @"select State from AddressInfo where FirstName='Mohanee';"; string expectedData = aRepo.RetrieveForTesting(testQuery); string actualData = "T.L."; Assert.AreEqual(actualData, expectedData); }
public void Given_MultipleContactInfo_WhenAddedToDatabaseUsingThreads_Should_Return_NoOfContactsAdded() { AddressBookRepo addressBookRepo = new AddressBookRepo(); List <Contact> contactList = new List <Contact>(); int expected = 3; contactList.Add(new Contact("Tony", "Stark", "Stark Tower", "Manhattan", "NewYork", "10001", "8987224534", "*****@*****.**", "Home", "Family", DateTime.Now)); contactList.Add(new Contact("Pepper", "Potts", "Stark Tower", "Manhattan", "NewYork", "10001", "9987894434", "*****@*****.**", "Home", "Family", DateTime.Now)); contactList.Add(new Contact("Peter", "Parker", "Queens", "NewYork City", "NewYork", "12240", "7013456376", "*****@*****.**", "Home", "Friends", DateTime.Now)); int result = addressBookRepo.AddMultipleContactsUsingThreads(contactList); Assert.AreEqual(expected, result); }
public void GetContactsByCityOrState() { // Arrange AddressBookRepo addressBookRepo = new AddressBookRepo(); // Act List <ContactDetails> actualContactList = addressBookRepo.GetContactsByCityOrState("pala", "kerala"); List <ContactDetails> expectedContactList = addressBookRepo.GetContacts().FindAll(contact => contact.zip.city == "pala" && contact.zip.state == "kerala"); // Assert CollectionAssert.AreEqual(actualContactList, expectedContactList); }
public void UpdateContactAndTestTheDB() { // Arrange AddressBookRepo addressBookRepo = new AddressBookRepo(); // Act addressBookRepo.UpdateContact("Ravi", "kumar", "phoneNumber", "8888888889"); List <ContactDetails> contactlist = addressBookRepo.GetContacts("Ravi", "kumar"); ContactDetails contact = contactlist.Find(contact => contact.FirstName == "Ravi" && contact.LastName == "kumar"); // Assert Assert.AreEqual("8888888889", contact.PhoneNumber); }
public void AddMultipleNewContactWithThreads() { // Arrange AddressBookRepo addressBookRepo = new AddressBookRepo(); ContactDetails contact = new ContactDetails(); contact.FirstName = "Varun"; contact.LastName = "Arora"; contact.PhoneNumber = "4564564564"; contact.Email = "*****@*****.**"; contact.Address = "That nagar"; contact.zip.zip = "741258"; contact.zip.city = "Jaipur"; contact.zip.state = "Rajasthan"; contact.bookNameContactType.Add("Mybook", new List <string> { "Friend", "Family" }); // Add to list of contacts List <ContactDetails> contacts = new List <ContactDetails> { contact }; ContactDetails contact1 = new ContactDetails(); contact1.FirstName = "Bajaj"; contact1.LastName = "Honda"; contact1.PhoneNumber = "7896544569"; contact1.Email = "*****@*****.**"; contact1.Address = "Bike nagar"; contact1.zip.zip = "741258"; contact1.zip.city = "Jaipur"; contact1.zip.state = "Rajasthan"; contact1.bookNameContactType.Add("BroBook", new List <string> { "Friend", "Family" }); // Add contact to list contacts.Add(contact1); // Act addressBookRepo.InsertMultipleContactsWithThreads(contacts); List <ContactDetails> actual = addressBookRepo.GetContacts().FindAll(contact => (contact.FirstName == "Bajaj" && contact.LastName == "Honda") || (contact.FirstName == "Varun" && contact.LastName == "Arora")).OrderBy(c => c.FirstName).ToList(); List <ContactDetails> expected = new List <ContactDetails> { contact, contact1 }.OrderBy(c => c.FirstName).ToList(); // Assert CollectionAssert.AreEqual(actual, expected); }