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);
}
}
//....INSERTAR....
public void insertaUsuario(Usuarios nuevoUsuario)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
fitDB.Usuarios.InsertOnSubmit(nuevoUsuario);
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void insertaEntrenador(Entrenadores nuevoEntrenador)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
fitDB.Entrenadores.InsertOnSubmit(nuevoEntrenador);
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);
}
}
//....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);
}
}
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 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);
}
}
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);
}
}
//....MODIFICACIONES....
public void updateUser(string id, string areaAboutYou)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var usuBD = (from usu in fitDB.Usuarios
where usu.Id_Usuario == int.Parse(id)
select usu).Single();
usuBD.Description = areaAboutYou;
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void updateTarjeta(int id, UsuarioTarjeta usuTarjeta)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
var tarjetaBD = (from t in fitDB.Tarjetas
where t.Id_Usuario == id
select t).Single();
tarjetaBD.CardNumber = usuTarjeta.cardNumber;
tarjetaBD.SecurityCode = usuTarjeta.securityCode;
tarjetaBD.Caducity = usuTarjeta.month.Split(new char[] { '-' })[1] + usuTarjeta.year;
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void logUsuEntre(int idUsu, string idEnt)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
Usuario_Entrenamiento usu_ent = new Usuario_Entrenamiento();
usu_ent.Id_Usuario = idUsu;
usu_ent.Id_Entrenamiento = idEnt;
fitDB.Usuario_Entrenamiento.InsertOnSubmit(usu_ent);
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void grabaTarjeta(int id, UsuarioTarjeta usuTarjeta)
{
FitocracyDBDataContext fitDB = new FitocracyDBDataContext();
Tarjetas tarj = new Tarjetas();
tarj.Id_Usuario = id;
tarj.CardNumber = usuTarjeta.cardNumber;
tarj.SecurityCode = usuTarjeta.securityCode;
tarj.Caducity = usuTarjeta.month.Split(new char[] { '-' })[1] + usuTarjeta.year;
fitDB.Tarjetas.InsertOnSubmit(tarj);
try
{
fitDB.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
