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