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