//dayalerts פונקציה שממלאה את טבלת public static bool initDayAlertsList(UserMedicines userMedicine) { try { TimeSpan c = DateTime.Today.Subtract(userMedicine.fromDate.Value); if (c.TotalDays % userMedicine.frequency == 0) { List <Alerts> listAlerts = Connect.DB.Alerts.Where(p => p.userMedicineId == userMedicine.id).ToList(); for (var i = 0; i < listAlerts.Count; i++) { DayAlerts dayAlert = new DayAlerts() { alertId = listAlerts[i].id, isTaken = false, date = DateTime.Today, }; bool da = addDayAlert(dayAlert); } } return(true); } catch (Exception e) { return(false); } }
public static bool initDayAlertsList() { try { //מרוקן את טבלת האלרטים היומית var results = Connect.DB.DayAlerts.ToList(); results.ForEach(r => Connect.DB.DayAlerts.Remove(r)); //כאן צריך לרוקן את טבלת התרופות הלא רלוונטיות foreach (var userMedicine in Connect.DB.UserMedicines) { TimeSpan c = DateTime.Today.Subtract(userMedicine.fromDate.Value); if (c.TotalDays % userMedicine.frequency == 0 && userMedicine.toDate >= DateTime.Today) { List <Alerts> listAlerts = Connect.DB.Alerts.Where(p => p.userMedicineId == userMedicine.id).ToList(); for (var i = 0; i < listAlerts.Count; i++) { DayAlerts dayAlert = new DayAlerts() { alertId = listAlerts[i].id, isTaken = false, date = DateTime.Today, }; bool da = addDayAlert(dayAlert); } } } Connect.DB.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public static bool addDayAlert(DayAlerts dayAlert) { try { Connect.DB.DayAlerts.Add(dayAlert); Connect.DB.SaveChanges(); return(true); } catch (Exception e) { return(false); } }