public List <BPs> listPatientWithAlertsBP() { ModelMedAcContainer context = new ModelMedAcContainer(); List <BPs> bpp = new List <BPs>(); List <BP> bpss = context.BPs.Where(i => i.Alerta == true).ToList(); foreach (BP item in bpss) { BPs bpssa = new BPs(); bpssa.SNS = item.Utente.SNS; bpssa.FirstName = item.Utente.Nome; bpssa.LastName = item.Utente.Apelido; bpssa.Birthdate = Convert.ToDateTime(item.Utente.DataNasc); bpssa.Age = Calculateage(bpssa.Birthdate); bpssa.Value1 = item.Valor1; bpssa.Value2 = item.Valor2; bpssa.Date = item.Data; bpp.Add(bpssa); } return(bpp); }
public bool AddValuesBP(BPs values) { ModelMedAcContainer context = new WcfServiceLayer.ModelMedAcContainer(); Utente ut = context.Utentes.Where(i => i.SNS == values.SNS).FirstOrDefault(); if (ut == null) { return(false); } else { BP bp = new WcfServiceLayer.BP(); bp.Valor1 = values.Value1; bp.Valor2 = values.Value2; bp.Data = values.Date; bp.Alerta = values.Alert; bp.Utente = ut; context.BPs.Add(bp); context.SaveChanges(); return(true); } }
public List <BPs> listUserAlertsBPs(int sns, DateTime di, DateTime df) { ModelMedAcContainer context = new ModelMedAcContainer(); List <BPs> bpp = new List <BPs>(); List <BP> bpps = context.BPs.Where(i => i.Utente.SNS == sns && i.Data >= di && i.Data <= df).ToList(); foreach (BP item in bpps) { BPs bpssa = new BPs(); bpssa.Value1 = item.Valor1; bpssa.Value2 = item.Valor2; bpssa.Date = item.Data; bpssa.SNS = item.Utente.SNS; bpssa.FirstName = item.Utente.Nome; bpssa.LastName = item.Utente.Apelido; bpssa.Birthdate = Convert.ToDateTime(item.Utente.DataNasc); bpssa.Age = Calculateage(bpssa.Birthdate); bpp.Add(bpssa); } return(bpp); }