public List <Request> RetrieveIdByHotel(Request request) { try { var rqMapper = new RequestMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( rqMapper.GetRetriveAllByIdStatement(request) ); if (lstResult.Count <= 0) { return(default(List <Request>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Request>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public Check getDateOut(int fkSubReservacion) { try { CheckMapper mapper = new CheckMapper(); var lstResult = SqlDao.GetInstance().ExecuteQueryProcedure ( mapper.GetDateOutStatement(fkSubReservacion) ); if (lstResult.Count <= 0) { return(null); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Check>().ToList().FirstOrDefault()); } catch (Exception e) { ManageException(e); } return(null); }
public List <QRCode> RetrieveAllByReservationId(int idReservation) { try { var qrCodeMapper = new QRCodeMapper(); var instance = SqlDao.GetInstance(); var operation = qrCodeMapper.GetRetrieveAllByReservationIdStatement(idReservation); var lstResult = instance.ExecuteQueryProcedure(operation); if (lstResult.Count <= 0) { return(default(List <QRCode>)); } var objs = EntityObjectMapper.BuildObjects(lstResult); return(objs.Cast <QRCode>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <Commission> getCommission(Commission cedulaJuridicaDeHotel) { try { CommissionMapper commissionMapper = new CommissionMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( commissionMapper.GetCommissionStatement(cedulaJuridicaDeHotel) ); if (lstResult.Count <= 0) { return(default(List <Commission>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Commission>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <Hotel> RetrieveAllByUser(string user) { try { HotelMapper hotelMapper = new HotelMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( hotelMapper.GetRetriveAllByIdStatement(user) ); if (lstResult.Count <= 0) { return(default(List <Hotel>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Hotel>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <Rol> RetrieveAllByUser(Rol rol) { try { var rolMapper = new RolMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( rolMapper.GetRetrieveAllByUser(rol) ); if (lstResult.Count <= 0) { return(default(List <Rol>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Rol>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <ProductoCarrito> RetrieveAllByUser(int carrito) { try { ProductoCarritoMapper productoCarritoMapper = new ProductoCarritoMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( productoCarritoMapper.GetRetriveAllByIdStatement(carrito) ); if (lstResult.Count <= 0) { return(default(List <ProductoCarrito>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <ProductoCarrito>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <AvailableRooms> RetrieveAll <AvailableRooms> (int idHotel, int cantPersonas, DateTime checkin, DateTime checkout) { try { AvailableRoomsMapper armapper = new AvailableRoomsMapper(); var lstResult = SqlDao.GetInstance().ExecuteQueryProcedure ( armapper.GetRetriveAllStatement(idHotel, cantPersonas, checkin, checkout) ); if (lstResult.Count <= 0) { return(default(List <AvailableRooms>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <AvailableRooms>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <Room> RetrieveAllById(int hotel) { var roomMapper = new RoomMapper(); try { var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( roomMapper.GetRetriveAllByIdStatement(hotel) ); if (lstResult.Count <= 0) { return(default(List <Room>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Room>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public T RetrieveByRoomNumber <T>(Room room) { var roomMapper = new RoomMapper(); try { var instance = SqlDao.GetInstance(); var operation = roomMapper.GetRetrieveByRoomNumberStatement(room.IdHotel, room.RoomNumber); var lstResult = instance.ExecuteQueryProcedure(operation); if (lstResult.Count <= 0) { return(default(T)); } var objs = EntityObjectMapper.BuildObjects(lstResult); return(objs.Cast <T>().ToList()[0]); } catch (Exception e) { ManageException(e); } return(default(T)); }
public List <Service> RetrieveAllByHotel(int idHotel) { try { ServiceMapper serviceMapper = new ServiceMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( serviceMapper.GetRetriveAllByIdStatement(idHotel) ); if (lstResult.Count <= 0) { return(default(List <Service>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Service>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public T Retrieve <T>(BaseEntity entity) { try { var instance = SqlDao.GetInstance(); var operation = EntityMapperGeneric.GetRetriveStatement(entity); var lstResult = instance.ExecuteQueryProcedure(operation); if (lstResult.Count <= 0) { return(default(T)); } var objs = EntityObjectMapper.BuildObjects(lstResult); return(objs.Cast <T>().ToList()[0]); } catch (Exception e) { ManageException(e); } return(default(T)); }
public List <VistaReservacion> RetrieveAllPermisos(int id) { try { var lstResult = SqlDao.GetInstance().ExecuteQueryProcedure(vistaReservacionMapper.GetRetriveAllPermisosStatement(id)); if (lstResult.Count <= 0) { return(default(List <VistaReservacion>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <VistaReservacion>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <T> RetrieveAll <T>() { try { var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( EntityMapperGeneric.GetRetriveAllStatement() ); if (lstResult.Count <= 0) { return(default(List <T>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <T>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <CantVentasByDayStats> RetrieveCantVentasByDayStats() { try { CantVentasByDayStatsMapper mapper = new CantVentasByDayStatsMapper(); var lstResult = SqlDao.GetInstance().ExecuteQueryProcedure(mapper.GetCantVentasByDayStats()); if (lstResult.Count <= 0) { return(default(List <CantVentasByDayStats>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <CantVentasByDayStats>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <Producto> GetRetriveAllByHotelServicioStatement(int idHotel, int idService) { try { var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( productoMapper.GetRetriveAllByHotelServicioStatement(idHotel, idService) ); if (lstResult.Count <= 0) { return(default(List <Producto>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Producto>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public Commission IsAdminHotelRegistered(int fkHotel) { try { var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( commisionMapper.IsAdminHotelRegistered(fkHotel) ); if (lstResult.Count <= 0) { return(null); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Commission>().ToList().FirstOrDefault()); } catch (Exception e) { ManageException(e); } return(null); }
public T RetAllGanaciasMembresia <T>() { try { var instance = SqlDao.GetInstance(); var operation = platStatsMapper.GetRetAllGanaciasMembresia(); var lstResult = instance.ExecuteQueryProcedure(operation); if (lstResult.Count <= 0) { return(default(T)); } var objs = EntityObjectMapper.BuildObjects(lstResult); return(objs.Cast <T>().ToList()[0]); } catch (Exception e) { ManageException(e); } return(default(T)); }
public List <Hotel> RetrieveAllByFiltro(HotelFiltro hotelFiltro) { try { var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( hotelMapper.GetRetrieveAllByFiltroStatement(hotelFiltro) ); if (lstResult.Count <= 0) { return(default(List <Hotel>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Hotel>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public T Validate <T>(Rol rol) { try { var instance = SqlDao.GetInstance(); var operation = rolMapper.Validate(rol); var lstResult = instance.ExecuteQueryProcedure(operation); if (lstResult.Count <= 0) { return(default(T)); } var objs = EntityObjectMapper.BuildObjects(lstResult); return(objs.Cast <T>().ToList()[0]); } catch (Exception e) { ManageException(e); } return(default(T)); }
public T CreateSubreservation <T>(Reservation reservation, User user) { try { var instance = SqlDao.GetInstance(); var operation = reservationMapper.GetCreateSubreservation(reservation, user); var lstResult = instance.ExecuteQueryProcedure(operation); if (lstResult.Count <= 0) { return(default(T)); } var objs = EntityObjectMapper.BuildObjects(lstResult); return(objs.Cast <T>().ToList()[0]); } catch (Exception e) { ManageException(e); } return(default(T)); }
public T RetrieveByCorreo <T>(User user) { try { var instance = SqlDao.GetInstance(); var operation = userMapper.GetRetriveByCorreoStatement(user.Correo); var lstResult = instance.ExecuteQueryProcedure(operation); if (lstResult.Count <= 0) { return(default(T)); } var objs = EntityObjectMapper.BuildObjects(lstResult); return(objs.Cast <T>().ToList()[0]); } catch (Exception e) { ManageException(e); } return(default(T)); }
public InfoChatBot RetrieveAllById(int fkSubreserva) { try { var infoMapper = new InfoChatBotMapper(); var instance = SqlDao.GetInstance(); var op = infoMapper.GetRetrieveAllByIdStatement(fkSubreserva); var lstResult = instance.ExecuteQueryProcedure(op); var objts = EntityObjectMapper.BuildObjects(lstResult); if (lstResult.Count <= 0) { return(null); } return(objts.Cast <InfoChatBot>().ToList().FirstOrDefault()); } catch (Exception e) { ManageException(e); } return(null); }
public Code getCodeConfirmation(string correo) { try { var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( codeMapper.GetCodeStatement(correo) ); if (lstResult.Count <= 0) { return(default(Code)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Code>().ToList().FirstOrDefault()); } catch (Exception e) { ManageException(e); } return(null); }
public List <HotelAnualAverageIncome> RetrieveHotelAnualAverageIncome(int fkHotel) { try { var lstResult = SqlDao.GetInstance().ExecuteQueryProcedure( (EntityMapperGeneric as HotelAnualIncomeMapper)?.GetHotelAnualAverageIncome(fkHotel) ); if (lstResult.Count <= 0) { return(default(List <HotelAnualAverageIncome>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <HotelAnualAverageIncome>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }
public List <User> RetrieveAllSubAdministradorByHotel(int idHotel) { try { var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( userMapper.GetRetriveAllSubAdministradorByHotelStatement(idHotel) ); if (lstResult.Count <= 0) { return(default(List <User>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <User>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }