private async void Main_Shown(object sender, EventArgs e) { try { Properties.Settings.Default.CityCode = await cityController.GetCityCode(); } catch (Exception ex) { MessageBox.Show("Could not get city code" + Environment.NewLine + "Error : " + ex.Message, "An Error occured", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (shalatRepository.CheckIfDataExists(TimeHelper.GetCurrentDateWithUSFormat())) { waktuShalat = shalatRepository.GetByDate(TimeHelper.GetCurrentDateWithUSFormat()); } else { waktuShalat = await shalatController.GetJadwal(); shalatRepository.Insert(waktuShalat); } ayat = await ayatController.GetAyat(); Task.Run(() => ayatRepository.Insert(ayat)); ShowData(); var data = timeController.ShalatSelanjutnya(waktuShalat); ValidateBeforeStartCountdown(data); }
public async Task <List <Ayat> > GetAyat() { List <Ayat> listAyat = new List <Ayat>(); SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM ayat", db); SQLiteDataReader rd = (SQLiteDataReader)await cmd.ExecuteReaderAsync(); if (rd.HasRows) { while (rd.Read()) { Ayat ayat = new Ayat(); ayat.id = int.Parse(rd["id"].ToString()); ayat.surah = rd["surah"].ToString(); ayat.isi = rd["isi"].ToString(); ayat.terjemah = rd["terjemah"].ToString(); listAyat.Add(ayat); } } return(listAyat); }
public async Task <Ayat> GetAyat() { Uri RequestUrl = new Uri("https://api.banghasan.com/quran/format/json/acak"); Ayat ayat = new Ayat(); HttpResponseMessage response = await APIHttpHandler.GetResponse(RequestUrl); var AyatData = await response.Content.ReadAsStringAsync(); JObject data = JObject.Parse(AyatData); JToken acak = data.SelectToken("acak"); JToken id = acak.SelectToken("id"); ayat.terjemah = id.SelectToken("teks").ToString(); JToken ar = acak.SelectToken("ar"); ayat.isi = ar.SelectToken("teks").ToString(); JToken surah = data.SelectToken("surat"); ayat.surah = surah.SelectToken("nama").ToString(); return(ayat); }
public async void Insert(Ayat ayat) { SQLiteCommand cmd = new SQLiteCommand("INSERT INTO ayat(surah, isi, terjemah) VALUES(?,?,?)", db); cmd.Parameters.AddWithValue("@surah", ayat.surah); cmd.Parameters.AddWithValue("@isi", ayat.isi); cmd.Parameters.AddWithValue("@terjemah", ayat.terjemah); try { await cmd.ExecuteNonQueryAsync(); } catch (Exception ex) { throw new Exception("Unable to insert to the database"); } }
public async Task <Ayat> GetRandom() { Ayat ayat = null; SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM ayat ORDER BY RANDOM() LIMIT 1", db); SQLiteDataReader rd = (SQLiteDataReader)await cmd.ExecuteReaderAsync(); if (rd.HasRows) { while (rd.Read()) { ayat = new Ayat(); ayat.id = int.Parse(rd["id"].ToString()); ayat.surah = rd["surah"].ToString(); ayat.isi = rd["isi"].ToString(); ayat.terjemah = rd["terjemah"].ToString(); } } return(ayat); }