public List <Patient> GetListOfPatients()
{
Server2DatabaseEntities db = new Server2DatabaseEntities();
var query = from p in db.Patients
select p;
return(query.ToList());
}
public Patient getPersonByGLID(int pss)
{
Server2DatabaseEntities db = new Server2DatabaseEntities();
Patient r = new Patient();
r = (from rr in db.Patients
where rr.pssl == pss
select rr).FirstOrDefault();
return(r);
}
public Patient getPatient(int id)
{
Server2DatabaseEntities db = new Server2DatabaseEntities();
Patient p = new Patient();
p = (from rr in db.Patients
where rr.Id == id
select rr).First();
return(p);
}
public Patient getPersonByEmail(string email)
{
Server2DatabaseEntities db = new Server2DatabaseEntities();
Patient r = new Patient();
r = (from rr in db.Patients
where rr.Email == email
select rr).FirstOrDefault();
return(r);
}
public Patient getPersonBySurname(string surname)
{
Server2DatabaseEntities db = new Server2DatabaseEntities();
Patient r = new Patient();
r = (from rr in db.Patients
where rr.Surname == surname
select rr).First();
//if(r.Any())
return(r);
}
public void deletePatient(int id)
{
Server2DatabaseEntities db = new Server2DatabaseEntities();
Patient p = new Patient();
p = (from rr in db.Patients
where rr.Id == id
select rr).First();
db.Patients.Remove(p);
db.SaveChanges();
}
public void addPatient(string name, string surname, bool student, string email, float height, float weight)
{
Server2DatabaseEntities db = new Server2DatabaseEntities();
Patient p = new Patient();
p.Name = name;
p.Surname = surname;
p.Student = student;
p.Email = email;
p.Weight = weight;
p.Height = height;
db.Patients.Add(p);
db.SaveChanges();
}
public void updatePatient(int id, string imie, string nazwisko, bool etat, string email, float height, float weight)
{
Server2DatabaseEntities db = new Server2DatabaseEntities();
Patient p = (from rr in db.Patients
where rr.Id == id
select rr).First();
p.Name = imie;
p.Surname = nazwisko;
p.Student = etat;
p.Email = email;
p.Weight = weight;
p.Height = height;
db.SaveChanges();
}
public List <String> GetMatchingSurnames(string __surname)
{
Server2DatabaseEntities db = new Server2DatabaseEntities();
Patient p = new Patient();
var query = from r in db.Patients
where r.Surname == __surname
select r;
var qry = query.ToList();
var qrarr = new List <String>();
foreach (Patient pp in qry)
{
// Don't make me ever do this again.
qrarr.Add(string.Format("{0}%%%{1}%%%{2}%%%{3}%%%{4}%%%{5}%%%{6}", pp.Name, pp.Surname, pp.Email, pp.pssl, pp.Student, pp.Height, pp.Weight));
}
return(qrarr);
}
