public List <Workouts> recentWorkouts(string id)
{
List <Workouts> listadoW = new List <Workouts>();
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
Usuarios usuBD = (from usu in fitDB.Usuarios
where usu.Id_Usuario == Int32.Parse(id)
select usu).Single();
if (usuBD.WorkOuts != null)
{
List <string> workoutsUsu = (from u in fitDB.Usuarios
where u.Id_Usuario == Int32.Parse(id)
select u.WorkOuts).Single().Split(new char[] { '$' }).ToList();
foreach (var work in workoutsUsu)
{
if (work != "")
{
var workoutBD = (from workout in fitDB.Workouts
where workout.Id_Workout == Int32.Parse(work)
select workout).Single();
if (!listadoW.Contains(workoutBD))
{
listadoW.Add(workoutBD);
}
}
}
}
return(listadoW);
}
public void saveWorkout(string id, int idWorkout, int pointsWorkout)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = (from usu in fitDB.Usuarios
where usu.Id_Usuario == Int32.Parse(id)
select usu).Single();
usuBD.Points += pointsWorkout;
int levelAct = levelActual(usuBD.Points);
if (levelAct != usuBD.Level)
{
usuBD.Level = levelAct;
}
usuBD.WorkOuts += "$" + idWorkout.ToString();
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public List <Entrenadores> recuperaEntrenadores()
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
List <Entrenadores> entrenadoresList = (from entrenador in fitDB.Entrenadores
select entrenador).ToList();
return(entrenadoresList);
}
public List <Entrenamientos> recuperaEntrenamientos()
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
List <Entrenamientos> entrenamientosList = (from entrenamiento in fitDB.Entrenamientos
select entrenamiento).ToList();
return(entrenamientosList);
}
//....RECUPERAR....
public Usuarios recuperaUsuario(string id)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = (from usu in fitDB.Usuarios
where usu.Id_Usuario == Int32.Parse(id)
select usu).Single();
return(usuBD);
}
public int recuperaPOINTSworkOut(string work)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var pointsWorkoutBD = (from w in fitDB.Workouts
where w.Nombre == work
select w.Puntos).Single();
return(pointsWorkoutBD);
}
public ActionResult Show(string id)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var img = (from i in fitDB.Usuarios
where i.Id_Usuario == int.Parse(id)
select i.Foto).Single().ToArray();
return(File(img, "image/jpg"));
}
public List <Levels> recuperaLevels()
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
List <Levels> listadoLevels = (from level in fitDB.Levels
select level).ToList();
return(listadoLevels);
}
public Entrenamientos recuperaEntrenamiento(string id)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
Entrenamientos entrenamiento = (from entren in fitDB.Entrenamientos
where entren.Id_Entrenamiento == id
select entren).Single();
return(entrenamiento);
}
public Usuarios recuperaUsuarioConEmail(string email)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = (from usu in fitDB.Usuarios
where usu.Email == email
select usu).Single();
return(usuBD);
}
public Entrenadores recuperaEntrenador(string id)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
Entrenadores entrenador = (from entren in fitDB.Entrenadores
where entren.Id_Entrenador == id
select entren).Single();
return(entrenador);
}
public int recuperaIDworkOut(string work)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var idWorkoutBD = (from w in fitDB.Workouts
where w.Nombre == work
select w.Id_Workout).Single();
return(idWorkoutBD.Value);
}
public ActionResult showFotoEntrenamiento(string id)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var img = (from i in fitDB.Entrenamientos
where i.Id_Entrenamiento == id
select i.Foto).Single().ToArray();
return(File(img, "image/jpg"));
}
public List <Tracks> listadoTracks()
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
List <Tracks> tracksBD = (from t in fitDB.Tracks
orderby t.Nombre
select t).ToList();
return(tracksBD);
}
public List <Usuarios> listadoLeaders()
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
List <Usuarios> ususBD = (from usu in fitDB.Usuarios
orderby usu.Level descending
select usu).ToList();
return(ususBD);
}
public List <Entrenamientos> recuperaEntrenamientoFamilia(string familia)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
List <Entrenamientos> entrenamientosList = (from entrenamiento in fitDB.Entrenamientos
where entrenamiento.Familia == familia
select entrenamiento).ToList();
return(entrenamientosList);
}
public int recuperaID(UsuarioLogin usuLogin)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = (from usu in fitDB.Usuarios
where usu.Email == usuLogin.email &&
usu.Password == usuLogin.password
select usu).Single();
return(usuBD.Id_Usuario);
}
public List <Tracks> listadoTracksCon(string busqueda)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
List <Tracks> tracksBD = (from t in fitDB.Tracks
where t.Nombre.Contains(busqueda)
orderby t.Nombre
select t).ToList();
return(tracksBD);
}
public Boolean datosCorrectos(string idUsu, string actualPassword)
{
bool correcto;
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = from usu in fitDB.Usuarios
where usu.Id_Usuario == Int32.Parse(idUsu) &&
usu.Password == actualPassword
select usu;
return(correcto = usuBD.Any() ? correcto = true : correcto = false);
}
public bool existeTarjetaUsu(int id)
{
bool existe;
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var tarjetaBD = from t in fitDB.Tarjetas
where t.Id_Usuario == id
select t;
return(existe = tarjetaBD.Any() ? existe = true : existe = false);
}
public Boolean existeUsuario(UsuarioRegistro usuReg)
{
bool existe;
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = from usu in fitDB.Usuarios
where usu.Email == usuReg.email
select usu;
return(existe = usuBD.Any() ? existe = true : existe = false);
}
//....EXISTE....
public Boolean existeUsuario(UsuarioLogin usuLogin)
{
bool existe;
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = from usu in fitDB.Usuarios
where usu.Email == usuLogin.email &&
usu.Password == usuLogin.password
select usu;
return(existe = usuBD.Any() ? existe = true : existe = false);
}
public void insertaEntrenador(Entrenadores nuevoEntrenador)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
fitDB.Entrenadores.InsertOnSubmit(nuevoEntrenador);
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//....INSERTAR....
public void insertaUsuario(Usuarios nuevoUsuario)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
fitDB.Usuarios.InsertOnSubmit(nuevoUsuario);
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public List <Workouts> listadoWorkouts()
{
List <Workouts> listadoW = new List <Workouts>();
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var workoutsBD = (from workout in fitDB.Workouts
select workout).ToArray();
foreach (var workout in workoutsBD)
{
listadoW.Add(workout);
}
return(listadoW);
}
public void updatePassword(Usuarios usu, string newPass)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = (from u in fitDB.Usuarios
where u.Email == usu.Email
select u).Single();
usuBD.Password = newPass;
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void updateBirthday(string idUsu, DateTime fecha)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = (from u in fitDB.Usuarios
where u.Id_Usuario == Int32.Parse(idUsu)
select u).Single();
usuBD.Birthday = fecha;
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void insertaFotoEntrenamiento(byte[] foto, string id)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var entrenamientoDb = (from entr in fitDB.Entrenamientos
where entr.Id_Entrenamiento == id
select entr).Single();
entrenamientoDb.Foto = foto;
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void updateEdad(string idUsu, int edad)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = (from u in fitDB.Usuarios
where u.Id_Usuario == Int32.Parse(idUsu)
select u).Single();
usuBD.Age = edad;
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//....CARGA FOTO....
public void uploadFoto(string idUsu, byte[] array)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = (from usu in fitDB.Usuarios
where usu.Id_Usuario == int.Parse(idUsu)
select usu).Single();
usuBD.Foto = array;
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
