public static List <GroupData> GetAll()
{
using (AddressBookDB db = new AddressBookDB())
{
return((from g in db.Groups select g).ToList());
}
}
public static List <ContactData> GetAll()
{
using (AddressBookDB db = new AddressBookDB())
{
return((from co in db.Contacts.Where(x => x.Deprecated == "0000-00-00 00:00:00") select co).ToList());
}
}
public static List <ContactData> GetAll()
{
using (AddressBookDB db = new AddressBookDB())
{
return((from c in db.Contacts select c).ToList().FindAll
(cont => cont.Deprecated == "01.01.0001 0:00:00"));
}
}
public static List <GroupData> GetAll()
{
using (//в этой конструкции юзинга db.close вызывается автоматически, т.о. мы уменьшаем количество кода
AddressBookDB db = new AddressBookDB())
{
return((from g in db.Groups select g).Distinct().ToList());
}
}
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 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> GetAll()
{
//установить соединение
using (AddressBookDB db = new AddressBookDB())
{
return((from g in db.Groups select g).ToList());
}
}
public List <GroupData> GetGroups()
{
using (AddressBookDB db = new AddressBookDB())
{
return((from g in db.Groups
from gcr in db.GCRelation.Where(p => p.ContactId == Id && p.GroupId == g.Id && g.Deprecated == "0000-00-00 00:00:00")
select g).Distinct().ToList());
}
}
public List <ContactData> GetContacts()
{
using (AddressBookDB db = new AddressBookDB())
{
return((from c in db.Contacts
from gcr in db.GCR.Where(p => p.GroupId == Id && p.ContactId == c.id && c.Deprecated == "0000-00-00 00:00:00")
select c).Distinct().ToList());
}
}
public static List <GroupData> GetContactGroupName(ContactData contact)
{
using (AddressBookDB db = new AddressBookDB())
{
return((from gcr in db.GCR
from gr in db.Groups
where (contact.Id == gcr.ContactId && gcr.GroupId == gr.Id)
select gr).Distinct().ToList());
}
}
public static List <GroupData> GetAll()
{
using (AddressBookDB db = new AddressBookDB())
{
return((from g in db.Groups select g).ToList());
}
// AddressBookDB db = new AddressBookDB();
// List<GroupData> fromDb = (from g in db.Groups select g).ToList();
// db.Close();
}
public List <ContactData> GetContacts()
{
using (//в этой конструкции юзинга db.close вызывается автоматически, т.о. мы уменьшаем количество кода
AddressBookDB db = new AddressBookDB())
{
return((from c in db.Contacts
from gcr in db.GCR.Where(p => p.GroupId == Id &&
p.ContactId == c.Id && c.Depricated == "0000-00-00 00:00:00")
select c).ToList());
}
}
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);
}
