public static List <Group> GetAll() { using (var db = new AddressbookDataBase()) { var query = from groups in db.Groups select groups; return(query.ToList()); } }
public static List <Contact> GetAll() { using (var db = new AddressbookDataBase()) { var query = from contacts in db.Contacts select contacts; return(query.ToList()); } }
public static Group GetGroupById(string id) { using (var db = new AddressbookDataBase()) { var query = from groups in db.Groups where groups.Id == id select groups; return(query.FirstOrDefault()); } }
public static Contact GetContactById(string id) { using (var db = new AddressbookDataBase()) { var query = from contacts in db.Contacts where contacts.Id == id select contacts; return(query.FirstOrDefault()); } }
public static List <Contact> GetBirthdays() { using (var db = new AddressbookDataBase()) { var query = from contacts in db.Contacts where contacts.Birthday != "0" && contacts.Birthyear != "-" select contacts; return(query.ToList()); } }
public static List <Contact> GetContactsNotInGroups() { using (var db = new AddressbookDataBase()) { var query = from contacts in db.Contacts join groupContactRelations in db.GroupContactRelations on contacts.Id equals groupContactRelations.Id into table1 from newcontacts in table1.DefaultIfEmpty() where newcontacts.Group_Id == null select contacts; return(query.ToList()); } }
public static List <Contact> GetContactsInGroup(string id) { using (var db = new AddressbookDataBase()) { var query = from groupContactRelations in db.GroupContactRelations join contacts in db.Contacts on groupContactRelations.Id equals contacts.Id where groupContactRelations.Group_Id == id //join groups in db.Groups on groupContactRelations.Group_Id equals groups.Id select contacts; return(query.ToList()); } }