public List<Person> GetListOfPeople() { DBEntities db = new DBEntities(); var query = from p in db.People select p; return query.ToList(); }
public Person getPerson(int id) { DBEntities db = new DBEntities(); Person r = new Person(); r = (from rr in db.People where rr.Id == id select rr).First(); return r; }
public void deletePerson(int id) { DBEntities db = new DBEntities(); Person r = new Person(); r = (from rr in db.People where rr.Id == id select rr).First(); db.People.Remove(r); db.SaveChanges(); }
public void addPerson(string name, string surname, bool student, string pld, string email) { DBEntities db = new DBEntities(); Person p = new Person(); p.Name = name; p.Surname = surname; p.Student = student; p.pssl = Convert.ToInt32(pld); p.Email = email; db.People.Add(p); db.SaveChanges(); }
public List<String> GetMatchingSurnames(string __surname) { DBEntities db = new DBEntities(); Person p = new Person(); var query = from r in db.People where r.Surname == __surname select r; var qry = query.ToList(); var qrarr = new List<String>(); foreach (Person pp in qry) { // Don't make me ever do this again. qrarr.Add(string.Format("{0}%%%{1}%%%{2}%%%{3}%%%{4}", pp.Name, pp.Surname, pp.Email, pp.pssl, pp.Student)); } return qrarr; }
public Person getPersonByGLID(int pss) { DBEntities db = new DBEntities(); Person r = new Person(); r = (from rr in db.People where rr.pssl == pss select rr).FirstOrDefault(); return r; }
public Person getPersonByEmail(string email) { DBEntities db = new DBEntities(); Person r = new Person(); r = (from rr in db.People where rr.Email == email select rr).FirstOrDefault(); return r; }
public void updatePerson(int id, string imie, string nazwisko, bool etat, string email) { DBEntities db = new DBEntities(); Person r = (from rr in db.People where rr.Id == id select rr).First(); r.Name = imie; r.Surname = nazwisko; r.Student = etat; r.Email = email; db.SaveChanges(); }
public Person getPersonBySurname(string surname) { DBEntities db = new DBEntities(); Person r = new Person(); r = (from rr in db.People where rr.Surname == surname select rr).First(); //if(r.Any()) return r; }