public int CrearReserva(int p_comensale, LePapeoGenNHibernate.Enumerated.LePapeo.EstadoReservaEnum p_estado, int p_registrado, int p_restaurante, bool p_finalizada, Nullable <DateTime> p_fecha_hora, Nullable <DateTime> p_fecha_solicitud)
{
/*PROTECTED REGION ID(LePapeoGenNHibernate.CP.LePapeo_Reserva_crearReserva) ENABLED START*/
IReservaCAD reservaCAD = null;
ReservaCEN reservaCEN = null;
int result = -1;
try
{
SessionInitializeTransaction();
reservaCAD = new ReservaCAD(session);
reservaCEN = new ReservaCEN(reservaCAD);
RestauranteCAD restauranteCAD = new RestauranteCAD(session);
RestauranteEN restauranteEN = restauranteCAD.ReadOIDDefault(p_restaurante);
if ((restauranteEN.Max_comen - restauranteEN.Current_comen) >= p_comensale)
{
result = reservaCEN.New_(p_registrado, p_restaurante, p_comensale, p_estado, p_finalizada, p_fecha_hora, p_fecha_solicitud);
restauranteEN.Current_comen += p_comensale;
restauranteCAD.Modify(restauranteEN);
}
SessionCommit();
}
catch (Exception ex)
{
SessionRollBack();
throw ex;
}
finally
{
SessionClose();
}
return(result);
/*PROTECTED REGION END*/
}
public void Checkout(int p_oid)
{
/*PROTECTED REGION ID(LePapeoGenNHibernate.CP.LePapeo_Reserva_checkout) ENABLED START*/
IReservaCAD reservaCAD = null;
ReservaCEN reservaCEN = null;
ReservaEN reservaEN = null;
try
{
SessionInitializeTransaction();
reservaCAD = new ReservaCAD(session);
reservaCEN = new ReservaCEN(reservaCAD);
reservaEN = reservaCAD.ReadOIDDefault(p_oid);
RestauranteCAD restauranteCAD = new RestauranteCAD(session);
RestauranteEN restauranteEN = restauranteCAD.ReadOIDDefault(reservaEN.Restaurante.Id);
restauranteEN.Current_comen -= reservaEN.Comensales;
reservaEN.Finalizada = true;
restauranteCAD.Modify(restauranteEN);
reservaCAD.Modify(reservaEN);
SessionCommit();
}
catch (Exception ex)
{
SessionRollBack();
throw ex;
}
finally
{
SessionClose();
}
/*PROTECTED REGION END*/
}
public ReservaCEN(IReservaCAD _IReservaCAD)
{
this._IReservaCAD = _IReservaCAD;
}
public ReservaCEN()
{
this._IReservaCAD = new ReservaCAD();
}
public ReservaCEN(IReservaCAD _IReservaCAD)
{
this._IReservaCAD = _IReservaCAD;
}
public ReservaCEN()
{
this._IReservaCAD = new ReservaCAD ();
}
