public void CompareRetrievedDataFromDB()
{
ContactsDB expected = new ContactsDB()
{
first_name = "Pranav",
last_name = "Jaguste",
address = "Mulund",
city = "Mumbai",
state = "Mh",
zipcode = 400081,
phone_no = "1234567890",
email = "*****@*****.**",
Contact_Type = "Family",
Book_Name = "Book1"
};
var actual = AddressBookRepoDB.RetrieveData();
Assert.AreEqual(expected.first_name, actual.first_name);
Assert.AreEqual(expected.last_name, actual.last_name);
Assert.AreEqual(expected.city, actual.city);
Assert.AreEqual(expected.phone_no, actual.phone_no);
Assert.AreEqual(expected.Book_Name, actual.Book_Name);
Assert.AreEqual(expected.Contact_Type, actual.Contact_Type);
}
public void GetDateBetweenRangeNow()
{
string expected = "RachitTanmayAkhil";
string actual = AddressBookRepoDB.GetDateBetweenRange();
Assert.AreEqual(expected, actual);
}
public void CompareUpdatedDataFromDB()
{
string expected = "Karnataka";
string actual = AddressBookRepoDB.UpdateDetailsInDB();
Assert.AreEqual(expected, actual);
}
public void AddContact()
{
bool expected = true;
ContactsDB contactDetails = new ContactsDB();
contactDetails.first_name = "Rakesh";
contactDetails.last_name = "Sharma";
contactDetails.Book_Name = "Book4";
contactDetails.Contact_Type = "Family";
contactDetails.B_ID = "BK4";
AddressBookRepoDB addressBookRepoDB = new AddressBookRepoDB();
bool actual = addressBookRepoDB.AddContactDetailsInDB(contactDetails);
Assert.AreEqual(expected, actual);
}
public void CompareRetrievedDataFromDB()
{
ContactsDB expected = new ContactsDB()
{
first_name = "Rachit",
last_name = "Rathi",
city = "Juhu",
phone = "123456789",
B_Name = "Book1",
B_Type = "Family"
};
var actual = AddressBookRepoDB.RetrieveData();
Assert.AreEqual(expected.first_name, actual.first_name);
Assert.AreEqual(expected.last_name, actual.last_name);
Assert.AreEqual(expected.city, actual.city);
Assert.AreEqual(expected.phone, actual.phone);
Assert.AreEqual(expected.B_Name, actual.B_Name);
Assert.AreEqual(expected.B_Type, actual.B_Type);
}
public void AddContact()
{
bool expected = true;
ContactsDB contactDetails = new ContactsDB();
contactDetails.first_name = "Rakesh";
contactDetails.last_name = "Sharma";
//contactDetails.address = "Khar";
//contactDetails.city = "Mumbai";
//contactDetails.state = "Maharashtra";
//contactDetails.zip = 400058;
//contactDetails.phone = "989879876";
//contactDetails.email = "*****@*****.**";
//contactDetails.Date = DateTime.Parse("2019-06-10");
contactDetails.B_Name = "Book4";
contactDetails.B_Type = "Family";
contactDetails.B_ID = "BK4";
AddressBookRepoDB addressBookRepoDB = new AddressBookRepoDB();
bool actual = addressBookRepoDB.AddContactDetailsInDB(contactDetails);
Assert.AreEqual(expected, actual);
}
public void AddMultipleContactUsingThred()
{
ContactsDB contactDetails = new ContactsDB();
contactDetails.first_name = "Rakesh";
contactDetails.last_name = "Sharma";
contactDetails.Book_Name = "Book4";
contactDetails.Contact_Type = "Family";
contactDetails.B_ID = "BK4";
ContactsDB contactsDB = new ContactsDB();
contactsDB.first_name = "Rahul";
contactsDB.last_name = "Singh";
contactsDB.Book_Name = "Book5";
contactsDB.Contact_Type = "Friends";
contactsDB.B_ID = "BK5";
List <ContactsDB> contactList = new List <ContactsDB>();
contactList.Add(contactDetails);
contactList.Add(contactsDB);
AddressBookRepoDB addressBookRepoDB = new AddressBookRepoDB();
addressBookRepoDB.AddContactDetailsInDBusingThread(contactList);
}
