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);
}
