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);
}