public Models.TemperatureAndMusicList GetInformationByCity(string city)
{
Models.TemperatureAndMusicList info = null;
try
{
//var client = new RestClient($"http://localhost:50879/api/Music/city/{city}");
//var client = new RestClient($"http://localhost/ingaiawebapi/api/Music/city/{city}");
var client = new RestClient($"https://ingaiachallenge.azurewebsites.net/api/Music/city/{city}");
var request = new RestRequest(Method.GET);
request.AddHeader("Content-Type", "application/json");
request.AddHeader("Accept", "application/json");
request.AddHeader("Authorization", Constants.ConstValues.SECURITY_KEY);
IRestResponse response = client.Execute(request);
if (response.IsSuccessful)
{
info = SimpleJson.DeserializeObject <Models.TemperatureAndMusicList>(response.Content);
}
else
{
if (response != null && response.Content.Length > 0)
{
ErrorApiMessage err = SimpleJson.DeserializeObject <Models.ErrorApiMessage>(response.Content);
if (err != null && err.message.Length > 0)
{
throw new Exception(err.message);
}
}
else
{
throw new Exception(response.ErrorException.Message);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(info);
}
public bool SaveLogCity(Models.TemperatureAndMusicList info)
{
bool ret = false;
this.Error = string.Empty;
try
{
string strcmd = @" INSERT INTO LOGCITY (DTREAD, CITY, TEMP)
VALUES (GETDATE(), @_city, @_temp )
";
using (SqlConnection sqlcon = new SqlConnection(this.ConnString))
{
sqlcon.Open();
if (sqlcon.State == ConnectionState.Open)
{
using (SqlCommand sqlcmd = new SqlCommand(strcmd, sqlcon))
{
sqlcmd.Parameters.AddWithValue("_city", info.CityName.ToUpper().Trim());
sqlcmd.Parameters.AddWithValue("_temp", info.Temperature);
sqlcmd.ExecuteNonQuery();
}
}
sqlcon.Close();
}
ret = true;
}
catch (Exception ex)
{
this.Error = ex.Message;
}
return(ret);
}