public FrmNuevoEditarCardio(int idSeleccionado, GimnasioContext dbEnviado)
{
InitializeComponent();
dbGimnasio = dbEnviado;
cardio = new Cardio();
this.cargarCardio(idSeleccionado);
}
public IActionResult Update(int id, Cardio cardio)
{
if (cardio == null || cardio.Id != id)
{
return(BadRequest());
}
var findCardioSession = context.Cardio.Find(id);
if (findCardioSession == null)
{
return(NotFound());
}
findCardioSession.Id = cardio.Id;
findCardioSession.CardioType = cardio.CardioType;
findCardioSession.Date = cardio.Date;
findCardioSession.Distance = cardio.Distance;
findCardioSession.Time = cardio.Time;
findCardioSession.Person = cardio.Person;
findCardioSession.PersonId = cardio.PersonId;
context.Cardio.Update(findCardioSession);
context.SaveChanges();
return(View("Index"));
}
public ActionResult SaveCardio(Cardio cardio)
{
if (!ModelState.IsValid)
{
return(View("Create"));
}
context.Cardio.Add(cardio);
context.SaveChanges();
return(View("CardioAdded", cardio));
}
public FrmEditarRutina(int idSeleccionado, GimnasioContext dbEnviado)
{
InitializeComponent();
dbGimnasio = dbEnviado;
rutina = new Rutina();
cardio = new Cardio();
calentamiento = new Calentamiento();
ejercicio = new Ejercicio();
tipo_Rutina = new Tipo_Rutina();
cargarRutina(idSeleccionado);
}
//is workout null
public bool CreateWorkoutLog(WorkoutLogDTO workout)
{
using (var dbTransaction = db.Database.BeginTransaction())
{
try
{
int getUserID = (from cred in db.Credentials
where workout.userName == cred.UserName
select cred.UserID).FirstOrDefault();
WorkoutLog work = new WorkoutLog
{
UserID = getUserID,
WorkoutType = workout.WorkoutType,
Date_Time = workout.Date_Time,
};
db.Workouts.Add(work);
if (workout.WorkoutType.Equals("Cardio"))
{
Cardio card = new Cardio
{
CardioType = workout.CardioType,
Distance = workout.Distance,
Time = workout.Time
};
db.Cardios.Add(card);
}
else if (workout.WorkoutType.Equals("WeightLifting"))
{
WeightLifting weight = new WeightLifting
{
LiftingType = workout.LiftingType,
Reps = workout.Reps,
Sets = workout.Sets
};
db.WeightLiftings.Add(weight);
}
//add into database t he new instance and saves
db.SaveChanges();
dbTransaction.Commit();
return(true);
}
catch (SqlException)
{
dbTransaction.Rollback();
return(false);
}
catch (DataException)
{
dbTransaction.Rollback();
return(false);
}
}
}
public bool CreateWorkout()
{
using (var dbTransaction = db.Database.BeginTransaction())
{
try
{
WorkoutLog w = new WorkoutLog
{
UserID = 1,
WorkoutType = "WeightLifting",
Date_Time = new DateTime(2015, 12, 12)
};
db.Workouts.Add(w);
if (w.WorkoutType.Equals("Cardio"))
{
Cardio card = new Cardio
{
CardioType = "sprinting",
Distance = 12.21,
Time = "12:32"
};
db.Cardios.Add(card);
}
else if (w.WorkoutType.Equals("WeightLifting"))
{
WeightLifting weight = new WeightLifting
{
LiftingType = "Curls",
Reps = 12,
Sets = 11
};
db.WeightLiftings.Add(weight);
}
//add into database t he new instance and saves
db.SaveChanges();
dbTransaction.Commit();
return(true);
}
catch (SqlException)
{
dbTransaction.Rollback();
return(false);
}
catch (DataException)
{
dbTransaction.Rollback();
return(false);
}
}
}
private void AddExercise(object obj)
{
if (IsCardio)
{
var serEx = JsonConvert.SerializeObject(tempExercise);
Cardio newTemp = JsonConvert.DeserializeObject <Cardio>(serEx);
tempWorkOut.ExerciseList.Add(newTemp);
}
else
{
var serEx = JsonConvert.SerializeObject(tempExercise);
StrTrain newTemp = JsonConvert.DeserializeObject <StrTrain>(serEx);
tempWorkOut.ExerciseList.Add(newTemp);
}
TempExercise = new Exercise();
}
private void btnEliminar_Click(object sender, EventArgs e)
{
if (gridCardio.Rows.Count > 0 && gridCardio.SelectedRows.Count > 0 && gridCardio.CurrentRow != null)
{
int idSeleccionado = (int)Helper.CeldaFilaActual(gridCardio, 0);
string mensaje = "¿Está seguro que desea eliminar?";
string titulo = "Eliminación";
DialogResult respuesta = MessageBox.Show(mensaje, titulo, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (respuesta == DialogResult.Yes)
{
cardio = dbGimnasio.Cardios.Find(idSeleccionado);
cardio.IsDelete = true;
dbGimnasio.SaveChanges();
listarGrillaCardios();
}
}
}
public IActionResult Report()
{
string OPDNO = HttpContext.Session.GetString("Cardio_OPDNO");
if (OPDNO != null && OPDNO != String.Empty)
{
Cardio data = new Cardio
{
UserData = _db.UserDatas.Where(c => c.OPDNo == OPDNO).FirstOrDefault(),
CardioClinicalSymptom = _gmidb.CardioClinicalSymptoms.Where(c => c.OPDNO == OPDNO).FirstOrDefault(),
CardioComorbidity = _gmidb.CardioComorbidities.Where(c => c.OPDNO == OPDNO).FirstOrDefault(),
CardioPersonal = _gmidb.CardioPersonals.Where(c => c.OPDNO == OPDNO).FirstOrDefault(),
CardioGeneralExamination = _gmidb.CardioGeneralExaminations.Where(c => c.OPDNO == OPDNO).FirstOrDefault(),
CardioCNS = _gmidb.CardioCNSs.Where(c => c.OPDNO == OPDNO).FirstOrDefault(),
CardioRespSystem = _gmidb.CardioRespSystems.Where(c => c.OPDNO == OPDNO).FirstOrDefault(),
CardioAbdExam = _gmidb.CardioAbdExams.Where(c => c.OPDNO == OPDNO).FirstOrDefault(),
CardioCVS = _gmidb.CardioCVSs.Where(c => c.OPDNO == OPDNO).FirstOrDefault(),
CardioInvestigation = _gmidb.CardioInvestigations.Where(c => c.OPDNO == OPDNO).FirstOrDefault(),
CardioOther = _gmidb.CardioOthers.Where(c => c.OPDNO == OPDNO).FirstOrDefault()
};
return(View(data));
}
return(RedirectToAction("Index", new { res = "First enter OPDNO" }));
}
public void setCardio(int _cardio)
{
Cardio = Cardio + _cardio;
cardio.text = Cardio.ToString();
}
public FrmNuevoEditarCardio()
{
InitializeComponent();
dbGimnasio = new GimnasioContext();
cardio = new Cardio();
}
public Task <int> Update(Cardio cardio)
{
throw new NotImplementedException();
}
public async Task Add(Cardio cardio)
{
await _db.Insert(cardio);
}
public FrmNuevoEditarCardio(GimnasioContext dbEnviado)
{
InitializeComponent();
dbGimnasio = dbEnviado;
cardio = new Cardio();
}
private void cargarCardio(int idSeleccionado)
{
cardio = dbGimnasio.Cardios.Find(idSeleccionado);
txtDuración.Text = cardio.Duracion;
txtRitmo.Text = cardio.ritmo;
}
public void EditCardio(Cardio cardio)
{
var Cardioedit = _context.Entry(cardio);
Cardioedit.State = EntityState.Modified;
}
public void AddCardio(Cardio cardio)
{
_context.Cardios.Add(cardio);
}
