public List <Amigo> GetAmigos()
{
var result = new List <Amigo>();
try
{
if (_client.Open())
{
var command = new SqlCommand
{
Connection = _client.Conecction,
CommandText = "getamigos",
CommandType = CommandType.StoredProcedure
};
var dataReader = command.ExecuteReader();
while (dataReader.Read())
{
var amigo = new Amigo
{
idamigo = Convert.ToInt32(dataReader["idamigo"].ToString()),
nombre = dataReader["nombre"].ToString(),
fecnac = Convert.ToDateTime(dataReader["fecnac"].ToString()),
direccion = dataReader["direccion"].ToString(),
telefono = dataReader["telefono"].ToString()
};
result.Add(amigo);
}
}
}
catch
{
// ignored
}
finally
{
_client.Close();
}
return(result);
}
public List <Lista> GetCity(string nombre)
{
var result = new List <Lista>();
try
{
if (_client.Open())
{
var command = new SqlCommand
{
Connection = _client.Conecction,
CommandText = "getcity",
CommandType = CommandType.StoredProcedure
};
var par1 = new SqlParameter("@nombre", SqlDbType.NVarChar)
{
Direction = ParameterDirection.Input,
Value = nombre
};
command.Parameters.Add(par1);
var dataReader = command.ExecuteReader();
while (dataReader.Read())
{
var ciudad = new Lista
{
id = Convert.ToInt32(dataReader["idciudad"].ToString()),
name = dataReader["nombre"].ToString(),
country = dataReader["pais"].ToString(),
timezone = Convert.ToInt32(dataReader["tiempohorario"].ToString()),
sunrise = Convert.ToInt32(dataReader["amanecer"].ToString()),
sunset = Convert.ToInt32(dataReader["anochecer"].ToString()),
temp = Convert.ToDouble(dataReader["temperatura"].ToString()),
temp_max = Convert.ToDouble(dataReader["temperaturamax"].ToString()),
temp_min = Convert.ToDouble(dataReader["temperaturamin"].ToString()),
};
result.Add(ciudad);
}
}
}
catch
{
// ignored
}
finally
{
_client.Close();
}
return(result);
}