public static List <DateTime> GetAutoSchedulesAsDtList() { var workList = new List <DateTime>(); List <AutoUpdateSchedule> autoSchedules = null; var jsonAutoSchedules = SqlCe.GetAutoEnforceSchedules(); if (!string.IsNullOrEmpty(jsonAutoSchedules)) { autoSchedules = JsonConvert.DeserializeObject <List <AutoUpdateSchedule> >(jsonAutoSchedules).OrderBy(x => x.DayOfWeek).ToList(); if (!autoSchedules.Where(x => x.IsActive).Any()) { return(null); } } else { return(null); } var now = DateTime.Now; var day = (int)now.DayOfWeek; var thisweek = Convert.ToDateTime(now.AddDays(-day).ToString("yyyy-MM-dd")); foreach (var autoSchedule in autoSchedules) { if (!autoSchedule.IsActive) { continue; } try { var tempdate = thisweek.AddDays(autoSchedule.DayOfWeek); var aus = _is24HourEnvironement ? $"{tempdate:yyyy-MM-dd} {autoSchedule.Hour}:{autoSchedule.Minute}" : $"{tempdate:yyyy-MM-dd} {autoSchedule.Hour}:{autoSchedule.Minute} {autoSchedule.AmPm}"; var dt = Convert.ToDateTime(aus); if (dt < now.AddSeconds(-10)) { dt = dt.AddDays(7); } workList.Add(dt); } catch (Exception ex) { _log.Error(ex.Message); } } return(workList); }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { DataContext = Globals.Settings.PlannerSettings; var hours = _is24HourEnvironement ? _l24hours : _l12hours; HourMo.ItemsSource = hours; HourTu.ItemsSource = hours; HourWe.ItemsSource = hours; HourTh.ItemsSource = hours; HourFr.ItemsSource = hours; HourSa.ItemsSource = hours; HourSu.ItemsSource = hours; MinuteMo.ItemsSource = _minutes; MinuteTu.ItemsSource = _minutes; MinuteWe.ItemsSource = _minutes; MinuteTh.ItemsSource = _minutes; MinuteFr.ItemsSource = _minutes; MinuteSa.ItemsSource = _minutes; MinuteSu.ItemsSource = _minutes; AmPmMo.ItemsSource = _ampm; AmPmTu.ItemsSource = _ampm; AmPmWe.ItemsSource = _ampm; AmPmTh.ItemsSource = _ampm; AmPmFr.ItemsSource = _ampm; AmPmSa.ItemsSource = _ampm; AmPmSu.ItemsSource = _ampm; HourMo.SelectedIndex = 0; HourTu.SelectedIndex = 0; HourWe.SelectedIndex = 0; HourTh.SelectedIndex = 0; HourFr.SelectedIndex = 0; HourSa.SelectedIndex = 0; HourSu.SelectedIndex = 0; MinuteMo.SelectedIndex = 0; MinuteTu.SelectedIndex = 0; MinuteWe.SelectedIndex = 0; MinuteTh.SelectedIndex = 0; MinuteFr.SelectedIndex = 0; MinuteSa.SelectedIndex = 0; MinuteSu.SelectedIndex = 0; AmPmMo.SelectedIndex = 0; AmPmTu.SelectedIndex = 0; AmPmWe.SelectedIndex = 0; AmPmTh.SelectedIndex = 0; AmPmFr.SelectedIndex = 0; AmPmSa.SelectedIndex = 0; AmPmSu.SelectedIndex = 0; AmPmMo.Visibility = _is24HourEnvironement ? Visibility.Hidden : Visibility.Visible; AmPmTu.Visibility = _is24HourEnvironement ? Visibility.Hidden : Visibility.Visible; AmPmWe.Visibility = _is24HourEnvironement ? Visibility.Hidden : Visibility.Visible; AmPmTh.Visibility = _is24HourEnvironement ? Visibility.Hidden : Visibility.Visible; AmPmFr.Visibility = _is24HourEnvironement ? Visibility.Hidden : Visibility.Visible; AmPmSa.Visibility = _is24HourEnvironement ? Visibility.Hidden : Visibility.Visible; AmPmSu.Visibility = _is24HourEnvironement ? Visibility.Hidden : Visibility.Visible; var json = SqlCe.GetAutoEnforceSchedules(); if (!string.IsNullOrEmpty(json)) { SetSchedules(json); } }