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