public List <RutinaModel> getRutinasByPersonaID(personaModel _persona)
{
try
{
DDBBGateway data = new DDBBGateway();
data.prepareQuery("select * from Rutinas where idPersona = '" + _persona.id + "'");
data.sendQuery();
List <RutinaModel> listRutinas = new List <RutinaModel>();
while (data.getReader().Read())
{
RutinaModel aux = new RutinaModel();
aux.id = long.Parse(data.getReader()["id"].ToString());
aux.idPersona = long.Parse(data.getReader()["idPersona"].ToString());
aux.idEntrenamiento = long.Parse(data.getReader()["idEntrenamiento"].ToString());
aux.descripcion = data.getReader()["descripcion"].ToString();
aux.nombre = data.getReader()["nombre"].ToString();
listRutinas.Add(aux);
}
return(listRutinas);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Nueva(FormCollection collection)
{
try
{
personaModel personaLoged = (personaModel)Session["personaLogedIn" + Session.SessionID];
RutinaModel rutina = new RutinaModel();
rutina.idPersona = personaLoged.id;
rutina.idEntrenamiento = long.Parse(Request.Form["idEntrenamiento"]);
rutina.descripcion = Request.Form["descripcion"].ToString();
rutina.nombre = Request.Form["nombre"].ToString();
RutinaService rServ = new RutinaService();
if (rServ.newRutina(rutina) == false)
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("NuevaRutina"));
}
}
catch
{
return(View());
}
}
private void Eliminarbtn_Click(object sender, RoutedEventArgs e)
{
string result = null;
RutinaModel selectedModel = (RutinaModel)RutinaDataGrid.SelectedItem;
MessageBoxResult response;
response = MessageBox.Show("¿Está seguro que desea eliminar el registro seleccionado ?", "Confirmación", MessageBoxButton.YesNo, MessageBoxImage.Exclamation);
if (response == MessageBoxResult.Yes)
{
rutina.EntityState = EntityState.Deleted;
rutina.Id = selectedModel.Id;
result = rutina.Savechanges();
RutinaDataGrid.ItemsSource = rutina.GetAll();
MessageBox.Show(result);
}
}
private void EditarBtn_Click(object sender, RoutedEventArgs e)
{
RutinaModel selectedModel = (RutinaModel)RutinaDataGrid.SelectedItem;
RutinaForm form = new RutinaForm();
form.SetData(selectedModel.Id,
selectedModel.Dia,
selectedModel.Repeticiones,
selectedModel.Peso,
selectedModel.IdEjercicio,
selectedModel.IdCliente
);
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Dashboard))
{
(window as Dashboard).SwitchScreen(form, "Rutina • Editar rutina");
}
}
}
public bool newRutina(RutinaModel _rutina)
{
try
{
DDBBGateway data = new DDBBGateway();
data.prepareQuery(
"insert into Rutinas " +
"values ('" + _rutina.idPersona + "', '" + _rutina.idEntrenamiento + "', '" + _rutina.descripcion + "', '" + _rutina.nombre + "');");
data.sendStatement();
if (data.getAffectedRows() <= 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
