public static PerfilReturn Inicio(int id) { HealthyAppDataBaseDbContext dbContext = new HealthyAppDataBaseDbContext(); var query = (from p in dbContext.Perfils where p.LoginID == id select new { foto = p.Foto_paciente, nombre = p.Nombre + " " + p.Apellido, edad = p.Edad, genero = p.Genero }) .SingleOrDefault(); PerfilReturn perfil = new PerfilReturn(); perfil.foto = query.foto; perfil.nombre = query.nombre; perfil.edad = query.edad; perfil.genero = query.genero; return(perfil); }
public static ProgresoReturn Progreso(int id) { HealthyAppDataBaseDbContext dbContext = new HealthyAppDataBaseDbContext(); var query = (from p in dbContext.progresos join pr in dbContext.Perfils on p.PerfilID equals pr.ID join l in dbContext.Logins on pr.LoginID equals l.ID where l.ID == id orderby p.Fecha descending select p ).ToList(); bool flag = true; ProgresoReturn progreso = new ProgresoReturn(); foreach (var p in query) { if (flag) { flag = false; progreso.IMC = p.IMC; progreso.Peso = p.Peso; progreso.Estatura = p.Estatura; progreso.Medida_Cadera = p.Medida_Cadera; progreso.Medida_Cintura = p.Medida_Cintura; progreso.Edad_Metabolica = p.Edad_Metabolica; } } return(progreso); }
public static CitaReturn VerificarCita(int loginID) { HealthyAppDataBaseDbContext dbContext = new HealthyAppDataBaseDbContext(); var query = (from c in dbContext.citas where c.LoginID == loginID orderby c.Año, c.Mes, c.Dia select c).ToList(); bool flag = true; foreach (var cita in query) { if (cita.Año >= DateTime.Now.Year) { if (cita.Mes >= DateTime.Now.Month) { if (cita.Mes == DateTime.Now.Month) { if (cita.Dia >= DateTime.Now.Day) { if (flag) { flag = false; CitaReturn citaReturn = new CitaReturn(); citaReturn.Año = cita.Año; citaReturn.Mes = cita.Mes; citaReturn.Dia = cita.Dia; citaReturn.Horario = cita.Horario; return(citaReturn); } } } else { if (flag) { flag = false; CitaReturn citaReturn2 = new CitaReturn(); citaReturn2.Año = cita.Año; citaReturn2.Mes = cita.Mes; citaReturn2.Dia = cita.Dia; citaReturn2.Horario = cita.Horario; return(citaReturn2); } } } } } CitaReturn citaReturn3 = new CitaReturn(); citaReturn3.Año = 0; citaReturn3.Mes = 0; citaReturn3.Dia = 0; citaReturn3.Horario = " "; return(citaReturn3); }
public static int isLoged(string usuario, string contraseña) { HealthyAppDataBaseDbContext dbContext = new HealthyAppDataBaseDbContext(); int idUsuario = 0; var query = (from l in dbContext.Logins where l.Usuario == usuario && l.Password == contraseña select new { id = l.ID }).SingleOrDefault(); if (query != null) { idUsuario = query.id; return(idUsuario); } else { return(idUsuario); } }
public static List <string> Menu(int id, int Dia, int Tiempo) { HealthyAppDataBaseDbContext dbContext = new HealthyAppDataBaseDbContext(); var query = (from md in dbContext.MenuDes join m in dbContext.mi_Menus on md.MenuSemanalID equals m.ID join l in dbContext.Logins on m.LoginID equals l.ID join c in dbContext.comidas on md.ComidaID equals c.ID where l.ID == id && md.DiaID == Dia && md.TiempoID == Tiempo select new { comida = c.Descripcion }).ToList(); List <string> comidas = new List <string>(); foreach (var comida in query) { comidas.Add(comida.comida); } return(comidas); }
// GET: Login public ActionResult Login(UserModel usm) { if (Session["UserName"] == null) { if (ModelState.IsValid) { using (HealthyAppDataBaseDbContext dbCtx = new HealthyAppDataBaseDbContext()) { //string encryptedPass = EncryptionDecryption.EncriptarSHA1(usm.Password); var isLogged = dbCtx.Logins .Where(x => x.Usuario.Equals(usm.UserName) && x.Password.Equals(usm.Password)) .FirstOrDefault(); if (isLogged != null) { Session["UserName"] = usm.UserName.ToString(); Session["LoginID"] = 3; var path = Server.MapPath("~") + @"Files"; var fileName = "/Log.txt"; StreamWriter sw = new StreamWriter(path + fileName, true); sw.WriteLine("Login -" + DateTime.Now + " " + "El usuario : " + usm.UserName + " ingresó"); sw.Close(); return(RedirectToAction("Usuarios", "HomePage")); } else { //return RedirectToAction("Registrar","Login"); } } } } return(View(usm)); }
public static List <Decimal> Grafica(int id) { HealthyAppDataBaseDbContext dbContext = new HealthyAppDataBaseDbContext(); var query = (from p in dbContext.progresos join pr in dbContext.Perfils on p.PerfilID equals pr.ID join l in dbContext.Logins on pr.LoginID equals l.ID where l.ID == id orderby p.Fecha ascending select p ).ToList(); List <Decimal> grafica = new List <decimal>(); foreach (var p in query) { grafica.Add(p.IMC); } return(grafica); }
public static NutriologoResult Nutriologo() { HealthyAppDataBaseDbContext dbContext = new HealthyAppDataBaseDbContext(); var query = (from mn in dbContext.mi_Nutriologos select new { foto = mn.Foto, nombre = mn.Nombre + " " + mn.Apellido, cedula = mn.Cedula, telefono = mn.Telefono, descripcion = mn.Descripcion, calle = mn.Calle, numeroext = mn.Numero_Exterior, numeroint = mn.Numero_Interior, municipio = mn.Municipio, estado = mn.Estado, codigopostal = mn.Codigo_Postal }).SingleOrDefault(); NutriologoResult nutriologo = new NutriologoResult(); nutriologo.Foto = query.foto; nutriologo.Nombre = query.nombre; nutriologo.Cedula = query.cedula; nutriologo.Telefono = query.telefono; nutriologo.Descripcion = query.descripcion; nutriologo.Calle = query.calle; nutriologo.Numero_Exterior = query.numeroext; nutriologo.Numero_Interior = query.numeroint; nutriologo.Municipio = query.municipio; nutriologo.Estado = query.estado; nutriologo.Codigo_Postal = query.codigopostal; return(nutriologo); }