public static List <ContactData> GetAllFromDb() { AddressBookDB db = new AddressBookDB(); List <ContactData> listFromDB = (from c in db.Contacts.Where(x => x.Depricated == "0000-00-00 00:00:00") select c).ToList(); db.Close(); return(listFromDB); }
public static List <GroupData> GetAllFromDb() { AddressBookDB db = new AddressBookDB(); List <GroupData> listFromDB = (from g in db.Groups select g).ToList(); db.Close(); return(listFromDB); }
public List <ContactData> GetContacts() { AddressBookDB db = new AddressBookDB(); List <ContactData> contactsForGroup = (from c in db.Contacts from gct in db.GroupContactRel.Where(p => p.GroupID == ID && p.ContactID == c.Id && c.Depricated == "0000-00-00 00:00:00") select c).Distinct().ToList(); db.Close(); return(contactsForGroup); }