public string Consult2(bool checkin = false)
        {
            var result   = new Checkin().Select(checkin);
            var checkins = new List <CheckinViewModel>();

            while (result.Read())
            {
                var obj = new CheckinViewModel()
                {
                    hospede = new ClientViewModel()
                    {
                        nome = result[0].ToString()
                    },
                    dataEntrada      = Convert.ToDateTime(result[3]),
                    dataSaida        = Convert.ToDateTime(result[4]),
                    adicionalVeiculo = Convert.ToBoolean(result[5])
                };
                Calcula(obj);
                checkins.Add(obj);
            }
            return(JsonConvert.SerializeObject(checkins));
        }