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