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