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