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