public static List <ContactData> GetAll() { using (AddressbookDB db = new AddressbookDB()) { return((from c in db.Contacts where c.IsActive == "0000-00-00 00:00:00" select c).ToList()); } }
public static List <GroupData> GetGroupsListFromDb() { using (AddressbookDB database = new AddressbookDB()) { return((from g in database.Groups select g).ToList()); } }
public static List <GroupData> GetAll() { using (AddressbookDB db = new AddressbookDB()) { return((from g in db.Groups select g).OrderBy(x => x.Name).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 <ContactData> GetContactsListFromDb() { using (AddressbookDB database = new AddressbookDB()) { return((from c in database.Contacts.Where(x => x.Deprecated == "0000-00-00 00:00:00") select c).ToList()); } }
public List <ContactData> GetContacts() { using (AddressbookDB database = new AddressbookDB()) { return((from c in database.Contacts from gcr in database.GroupContactRelations.Where(p => p.GroupId == Id && p.ContactId == c.Id && c.Deprecated == "0000-00-00 00:00:00") select c).Distinct().ToList()); } }
public List <GroupData> GetGroups() { using (AddressbookDB db = new AddressbookDB()) { return((from q in db.Groups from g in db.GCR.Where( p => p.ContactId == Id && p.GroupId == q.Id) select q).ToList()); } }
public List <ContactData> GetContacts() { using (AddressbookDB db = new AddressbookDB()) { return((from c in db.Contacts from g in db.GCR.Where( p => p.GroupId == Id && p.ContactId == c.Id && c.Deprecated == "0000-00-00 00:00:00") select c).Distinct().ToList()); } }