public static GroupData GetGroupWithContacts()
{
using (AddressBookDb db = new AddressBookDb())
{
// get all relations
GroupContactRelation firstRelation = (from gcr in db.GCR select gcr).ToList().First();
// get first relation and get group using group_id
GroupData group = (from g in db.Groups where g.Id == firstRelation.GroupId select g).First();
return(group);
}
}
public void RemoveContactsFromGroupTest()
{
GroupData group = GroupContactRelation.GetGroupWithContacts();
List <ContactData> oldContacts = group.GetContacts();
ContactData toBeRemoved = oldContacts[0];
app.Contacts.RemoveContactFromGroup(toBeRemoved, group);
List <ContactData> newContacts = group.GetContacts();
oldContacts.RemoveAt(0);
oldContacts.Sort();
newContacts.Sort();
Assert.AreEqual(oldContacts, newContacts);
}
public void RemoveGroupContactRelationFromDB(GroupContactRelation gcr)
{
ExecuteCmd($"DELETE FROM `address_in_groups` WHERE `address_in_groups`.`id` = {gcr.ContactID} AND `address_in_groups`.`group_id` = {gcr.GroupID}");
}
public void AddGroupContactRelationInDB(GroupContactRelation gcr)
{
ExecuteCmd($"insert into address_in_groups set group_id = {gcr.GroupID}, id = {gcr.ContactID}, created = '{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}', modified = '{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}'");
}
public int AddContactToGroupDb(int contactId, int groupId)
{
GroupContactRelation gcr = new GroupContactRelation();
return(gcr.AddNewRelation(contactId, groupId));
}
