public IEnumerable <ReservaCommadResult> GetReservaSala(ReservaCommandRegister commad)
{
var sql = @"select * from Reservas " +
"where SalaId = @SalaId and HoraInicio >= @HoraInicio and HoraFim <= @HoraFim";
return(_contextStore.Connection.Query <ReservaCommadResult>(
sql, new { SalaId = commad.SalaId, HoraInicio = commad.HoraInicio, HoraFim = commad.HoraFim }
));
}
public ReservaCommadResultRegister Salvar(ReservaCommandRegister commad)
{
var reserva = _repository.GetReservaSala(commad);
if (reserva.Count() == 0)
{
var result = _handle.Handle(commad);
return(result);
}
return(null);
}
public object Post(object obj)
{
ReservaCommandRegister command = JsonConvert.DeserializeObject <ReservaCommandRegister>(obj.ToString());
if (command.HoraInicio != null)
{
var horainicio = command.DataInicio.ToString("dd-MM-yyyy") + " " + command.HoraInicio.TimeOfDay;
var horaFim = command.DataFim.ToString("dd-MM-yyyy") + " " + command.HoraFim.TimeOfDay;
command.HoraInicio = Convert.ToDateTime(horainicio);
command.HoraFim = Convert.ToDateTime(horaFim);
var result = _service.Salvar(command);
if (result != null)
{
return(result);
}
}
return(new
{
NotFound = true,
message = "Reserva não pode ser feita."
});
}
public ReservaCommadResultRegister Handle(ReservaCommandRegister commad)
{
var reserva = new Reservas(
commad.ReservaId,
commad.DataInicio,
commad.HoraInicio,
commad.DataFim,
commad.HoraFim,
commad.Café,
commad.QuantidadePessoa,
commad.UsuarioId,
commad.SalaId
);
var result = _repository.Salvar(reserva);
var commadResult = new ReservaCommadResultRegister(
result,
commad.DataInicio,
commad.DataFim
);
return(commadResult);
}
