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 <Reservation> RetrieveAllById(int usuario)
{
try
{
var instance = SqlDao.GetInstance();
var operation = reservationMapper.GetRetAllByIdStatement(usuario);
var lstResult = instance.ExecuteQueryProcedure(operation);
if (lstResult.Count <= 0)
{
return(default(List <Reservation>));
}
var objs = EntityObjectMapper.BuildObjects(lstResult);
return(objs.Cast <Reservation>().ToList());
}
catch (Exception e)
{
ManageException(e);
}
return(null);
}
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 List <Hotel> RetrieveAllAdministrador()
{
try
{
var lstResult = SqlDao.GetInstance()
.ExecuteQueryProcedure(
hotelMapper.GetRetriveAllAdministradorStatement()
);
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 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 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);
}
