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