public static void RefreshSchedules() { //Update a collection of all ship schedules for single terminal try { //Clear and update ship schedules _Schedules.Clear(); DateTime dateMin = DateTime.Today.AddDays(-App.Config.ScheduleDaysBack); DateTime dateMax = DateTime.Today.AddDays(App.Config.ScheduleDaysForward); DateTime date = DateTime.Today; for (int i = 0; i < App.Config.PastBusinessDays; i++) { date = date.AddDays(-1); while (date.DayOfWeek == DayOfWeek.Saturday || date.DayOfWeek == DayOfWeek.Sunday) { date = date.AddDays(-1); } } ShipScheduleDataset schedules = ShipScheduleGateway.GetShipSchedules(date); _Schedules.Merge(schedules.ShipScheduleTable.Select("ScheduleDate >= '" + dateMin + "' AND ScheduleDate <= '" + dateMax + "'")); } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } finally { if (SchedulesChanged != null) { SchedulesChanged(null, EventArgs.Empty); } } }
public static ShipSchedule SchedulesArchiveItem(long sortCenterID, string sortCenter, DateTime scheduleDate) { //Return an archived ship schedule ShipSchedule schedule = null; try { // ShipScheduleDataset schedules = new ShipScheduleDataset(); schedules.Merge(ShipScheduleGateway.GetShipSchedules(scheduleDate)); if (schedules.ShipScheduleTable.Rows.Count > 0) { DataRow[] rows = schedules.ShipScheduleTable.Select("SortCenterID=" + sortCenterID + " AND ScheduleDate='" + scheduleDate + "'"); if (rows.Length > 0) { ShipScheduleDataset scheduleDS = new ShipScheduleDataset(); scheduleDS.ShipScheduleTable.AddShipScheduleTableRow("", sortCenterID, sortCenter, scheduleDate, DateTime.Now, Environment.UserName); schedule = new ShipSchedule(scheduleDS.ShipScheduleTable[0]); schedule.Changed += new EventHandler(OnShipScheduleChanged); } } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } return(schedule); }