public List <JadwalObatModel> GetDaftarJadwalObat()
{
using (var db = new HLDatabaseContext())
{
List <JadwalObatModel> result = db.DaftarJadwalObat.ToList();
foreach (JadwalObatModel item in result)
{
if (item.Hari == "setiapHari")
{
item.Hari = "Setiap hari";
}
}
return(result);
}
}
public List <AirMinumModel> GetDaftarRiwayatHarian()
{
using (var db = new HLDatabaseContext())
{
return((
from item in db.DaftarAirMinum
group item by item.Tanggal into itemGroup
select new AirMinumModel
{
Tanggal = itemGroup.Key,
Jumlah = itemGroup.Sum(s => s.Jumlah)
}
).ToList());
}
}
private int GetDiastolikTerakhir()
{
try
{
using (var db = new HLDatabaseContext())
{
return(db.DaftarTekananDarah.OrderBy(o => o.Id).Last().Diastolik);
}
}
catch (InvalidOperationException)
{
// Saat belum ada data di database
return(0);
}
}
private void NotificationTimer_Tick(object sender, EventArgs e)
{
List <JadwalObatModel> notificationQueue;
using (var db = new HLDatabaseContext())
{
notificationQueue = db.DaftarJadwalObat
.Where(o => (o.Hari == HLBase.HariSekarang || o.Hari == "setiapHari") && o.Waktu == HLBase.WaktuSekarang)
.ToList();
}
List <NotifikasiWindow> notificationWindows = new List <NotifikasiWindow>();
foreach (JadwalObatModel item in notificationQueue)
{
string deskripsi = String.Format("Setiap {0}, pukul {1}", item.Hari == "setiapHari" ? "hari" : item.Hari, item.Waktu);
NotifikasiWindow notificationWindow = new NotifikasiWindow(item.Nama, deskripsi);
notificationWindow.Show();
notificationWindows.Add(notificationWindow);
}
}
private string GetUnitParameter()
{
string unitParam = "&units=";
using (var db = new HLDatabaseContext())
{
switch (TemperatureUnitPref)
{
case "C":
unitParam += "metric";
break;
case "F":
unitParam += "imperial";
break;
default:
case "K":
unitParam = "";
break;
}
}
return(unitParam);
}
