public IEnumerable<Contact> search()
{
List<Contact> ContactsList = new List<Contact>();
string qu1 = string.Format(@"select * from contact where owner_id = '{0}';", ownerId);
SQLiteDataReader data = db.selectQuery(qu1);
while (data.Read())
{
Contact newContact = new Contact();
newContact.name = data["contact_name"].ToString();
newContact.email = data["contact_email"].ToString();
newContact.ownerId = Convert.ToInt32(data["owner_id"]);
newContact.id = Convert.ToInt32(data["contact_id"]);
ContactsList.Add(newContact);
}
IEnumerable<Contact> d = (IEnumerable<Contact>)ContactsList;
data.Close();
return d;
}
public IEnumerable<Contact> getContacts()
{
List<Contact> contacts = new List<Contact>();
string qy1 = string.Format(@"select * from contact_category
inner join contact on `contact_category`.`contact_id` = `contact`.`contact_id`
where category_id = '{0}';", this.id);
SQLiteDataReader data = db.selectQuery(qy1);
while (data.Read())
{
Contact nc = new Contact();
nc.id = Convert.ToInt32(data["contact_id"]);
nc.name = data["contact_name"].ToString();
nc.email = data["contact_email"].ToString();
nc.ownerId = Convert.ToInt32(data["owner_id"]);
contacts.Add(nc);
}
data.Close();
IEnumerable<Contact> EnumContacts = (IEnumerable<Contact>)contacts;
return EnumContacts;
}