public List <ContactInfo> GetContacts()
{
using (AddressBookDb db = new AddressBookDb())
{
return((from c in db.Contacts
from gcr in db.GCR.Where(x => x.GroupId == Id && x.ContactId == c.Id)
select c).Distinct().ToList());
}
}
public static List <GroupInfo> GetAllGroupsFromDb()
{
List <GroupInfo> groupsFromDb = new List <GroupInfo>();
using (AddressBookDb db = new AddressBookDb())
{
groupsFromDb = db.Groups.Select(group => group).ToList();
}
return(groupsFromDb);
}
public static List <ContactInfo> GetAllContactsFromDb()
{
List <ContactInfo> contactsFromDb = new List <ContactInfo>();
using (AddressBookDb db = new AddressBookDb())
{
//select all
contactsFromDb = (from contact in db.Contacts
//where contact.Deprecated == DateTime.MinValue // not working due to Date types mismatch :(
select contact
).ToList();
//then filter
contactsFromDb = contactsFromDb.Where(c => c.Deprecated == DateTime.MinValue).ToList();
return(contactsFromDb);
}
}
