public List <ContactData> GetContactsListWithGroup(string groupId) { using (AddressbookDB db = new AddressbookDB()) { return((from c in db.Contacts from gcr in db.GCR.Where(p => p.GroupId == groupId && p.ContactId == c.Id && c.Deprecated == "0000-00-00 00:00:00") select c).Distinct().ToList()); } }
public static List <ContactData> GetAll() { using (AddressbookDB db = new AddressbookDB()) { return((from c in db.Contacts.Where(x => x.Deprecated == "0000-00-00 00:00:00") select c).ToList()); } }
public static List <GroupData> GetAll() { using (AddressbookDB db = new AddressbookDB()) { return((from g in db.Groups select g).ToList()); } }
public int AddNewRelation(int contactId, int groupId) { using (var db = new AddressbookDB()) { return(db.GCR .Value(gcr => gcr.ContactId, contactId.ToString()) .Value(gcr => gcr.GroupId, groupId.ToString()) .Insert()); } }
public int?AddContact(ContactData contact) { using (AddressbookDB db = new AddressbookDB()) { return(db.Contacts .Value(c => c.FirstName, contact.FirstName) .Value(c => c.LastName, contact.LastName) .InsertWithInt32Identity()); } }
public int?AddGroup(GroupData group) { using (AddressbookDB db = new AddressbookDB()) { return(db.Groups .Value(g => g.Name, group.Name) .Value(g => g.Header, group.Header) .Value(g => g.Footer, group.Footer) .InsertWithInt32Identity()); } }