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