public List <Airtime> GetAirtime()
{
List <Airtime> airtimes = new List <Airtime>();
try
{
var conn = _dbContext.ConnectToDB();
var rdr = _dbContext.ExecuteQuery("SELECT origin, AVG(air_time) FROM flights GROUP BY origin", conn);
while (rdr.Read())
{
var airtime = new Airtime
{
Origin = rdr.GetString(0),
MeanAirtime = rdr.GetDouble(1)
};
airtimes.Add(airtime);
}
_dbContext.CloseConnections(rdr, conn);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(airtimes);
}
public bool EditAirtimeDetails(AirtimeDetailsVM model)
{
bool response = false;
//Check if Description Exist
if (_airtimeRepo.Exists(x => x.Id != model.Id && x.Description == model.Description))
{
return(response = false);
}
//retrieve the data from db
Airtime airtimeDTO = _airtimeRepo.SingleOrDefault(x => x.Id == model.Id);
//Checking for null
if (airtimeDTO != null)
{
// implement the changes
airtimeDTO.Description = model.Description;
airtimeDTO.Discount = model.Discount;
//commit the changes to db
try
{
_airtimeRepo.Update(airtimeDTO);
response = true;
}
catch (Exception)
{
response = false;
}
}
return(response);
}
public static void WriteJson(this Airtime value, JsonWriter writer, JsonSerializer serializer)
{
switch (value)
{
case Airtime.The2100: serializer.Serialize(writer, "21:00"); break;
case Airtime.The2200: serializer.Serialize(writer, "22:00"); break;
}
}
public ActionResult TransferAirtime([FromBody] Airtime value)
{
string DATA = JsonSerializer.Serialize(value);
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL_Airtime);
request.Method = "POST";
request.ContentType = "application/json";
request.ContentLength = DATA.Length;
StreamWriter requestWriter = new StreamWriter(request.GetRequestStream(), System.Text.Encoding.ASCII);
requestWriter.Write(DATA);
requestWriter.Close();
try
{
request.PreAuthenticate = true;
String username = "";
String password = "";
String encoded = System.Convert.ToBase64String(System.Text.Encoding.GetEncoding("ISO-8859-1").GetBytes(username + ":" + password));
request.Headers.Add("Authorization", "Basic " + encoded);
WebResponse webResponse = request.GetResponse();
Stream webStream = webResponse.GetResponseStream();
StreamReader responseReader = new StreamReader(webStream);
string response = responseReader.ReadToEnd();
Console.Out.WriteLine(response);
responseReader.Close();
return(Ok(response));
}
catch (Exception e)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(e.Message);
return(NotFound());
}
}