private void Guardar(ReservaAlumnoViewModel reservaAlumnoViewModel, int sillaId) { try { int reservaId = Convert.ToInt32(Session["ReservaId"]); if (reservaId > 0) { SillaReserva sillaReservaAnt = this.fachadaSillaReserva.RetornarSillaPorReserva(reservaId); if (sillaReservaAnt != null) { this.fachadaSillaReserva.EliminarSillaReserva(sillaReservaAnt.SillaReservaId); } } else { reservaId = this.fachadaReservaAlumno.InsertarReserva(new DTOReservaAlumno { dtoAlumno = new DTOAlumno { AlumnoId = reservaAlumnoViewModel.AlumnoId }, dtoCurso = new DTOCurso { CursoId = reservaAlumnoViewModel.CursoId } }); Session["ReservaId"] = reservaId; } this.fachadaSillaReserva.InsertarSillaReserva(new DTOSillaReserva { dtoReserva = new DTOReservaAlumno { ReservaId = reservaId }, dtoSilla = new DTOSilla { SillaId = sillaId } }); } catch (Exception) { throw; } }
public bool InsertarSillaReserva(DTOSillaReserva dtoSillaReserva) { try { SillaReserva sillaReserva = new SillaReserva { ReservaAlumnoId = Convert.ToInt32(dtoSillaReserva.dtoReserva.ReservaId), SillaId = dtoSillaReserva.dtoSilla.SillaId }; this.accesoDatosSillaReserva.InsertarSillaReserva(sillaReserva); return(true); } catch (Exception) { throw; } }
private void Borrar(ReservaAlumnoViewModel reservaViewModel, int sillaId) { try { int reservaId = Convert.ToInt32(Session["ReservaId"]); SillaReserva sillareserva = this.fachadaSillaReserva.BuscarSillaReserva(reservaId, sillaId); this.fachadaSillaReserva.EliminarSillaReserva(sillareserva.SillaReservaId); this.fachadaReservaAlumno.EliminarReserva(reservaId); Session["ReservaId"] = null; ViewBag.Mensaje = "Chair Free"; } catch (Exception) { throw; } }
public DTOSillaReserva ObtenerSillaReserva(int id) { SillaReserva sillaReserva = this.accesoDatosSillaReserva.ObtenerSillaReservaId(id); DTOSillaReserva dtoSillaReserva = new DTOSillaReserva { SillaReservaId = id, dtoReserva = new DTOReservaAlumno { ReservaId = sillaReserva.ReservaAlumnoId, dtoAlumno = new DTOAlumno { AlumnoId = sillaReserva.ReservaAlumno.AlumnoId }, dtoCurso = new DTOCurso { CursoId = sillaReserva.ReservaAlumno.CursoId } }, dtoSilla = new DTOSilla { SillaId = sillaReserva.SillaId, Codigo = sillaReserva.Silla.Codigo } }; return(dtoSillaReserva); }
public int InsertarSillaReserva(SillaReserva sillaReserva) { this.contexto.SillasReserva.Add(sillaReserva); return(this.contexto.SaveChanges()); }
public SillaReserva BuscarSillaReservaPorId(int reservaId, int sillaId) { SillaReserva sillaReserva = this.contexto.SillasReserva.FirstOrDefault(r => r.ReservaAlumnoId == reservaId && r.SillaId == sillaId); return(sillaReserva); }
public SillaReserva ObtenerSillaReservaId(int id) { SillaReserva sillaReserva = this.contexto.SillasReserva.Find(id); return(sillaReserva); }