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