private void CreateTimeSlots(EntitiesDataContext _EDC, ShippingPoint _sp, UpdateToolStripEvent _update) { _update(this, new ProgressChangedEventArgs(1, "CreateTimeSlots starting")); for (int _i = 0; _i < Properties.Settings.Default.NumberOfDays; _i++) { DateTime _dy = DateTime.Now.Date + TimeSpan.FromDays(_i); _update(this, new ProgressChangedEventArgs(1, _dy.ToShortDateString())); if (_dy.DayOfWeek == DayOfWeek.Sunday || _dy.DayOfWeek == DayOfWeek.Saturday) { continue; } List <TimeSlotTimeSlot> _ts = new List <TimeSlotTimeSlot>(); short _strtTm = 8; for (int _indx = _strtTm; _indx <= _strtTm + Properties.Settings.Default.TimeSlotsPerDay; _indx++) { DateTime _bgn = _dy + TimeSpan.FromHours(_indx); DateTime _end = _bgn + TimeSpan.FromHours(1); _ts.Add(new TimeSlotTimeSlot() { EntryTime = _bgn, EndTime = _end, ExitTime = _end, Occupied = Occupied.Free, TimeSlot2ShippingPointLookup = _sp, StartTime = _bgn }); _update(this, new ProgressChangedEventArgs(1, _bgn.ToShortDateString())); } _EDC.TimeSlot.InsertAllOnSubmit(_ts); _EDC.SubmitChanges(); } }
internal void AddShippingPoint(PreliminaryDataRouteShippingPointRow _shippingPoint) { Warehouse _wh = GetOrAdd <Warehouse>(m_EDC.Warehouse, m_Warehouse, _shippingPoint.Warehouse, false); ShippingPoint _sp = Create <ShippingPoint>(m_EDC.ShippingPoint, m_ShippingPoint, _shippingPoint.Title, false); _sp.ShippingPointDescription = _shippingPoint.Description; _sp.Direction = ParseDirection(_shippingPoint.Direction); _sp.WarehouseTitle = _wh; }
private void CreateTimeSlotTemplates(EntitiesDataContext _EDC, ShippingPoint _sp) { Dictionary <TimeSlotsTemplateStartHour, TimeSlotsTemplateEndHour> _hours = new Dictionary <TimeSlotsTemplateStartHour, TimeSlotsTemplateEndHour>() { { TimeSlotsTemplateStartHour._0, TimeSlotsTemplateEndHour._1 }, { TimeSlotsTemplateStartHour._1, TimeSlotsTemplateEndHour._2 }, { TimeSlotsTemplateStartHour._2, TimeSlotsTemplateEndHour._3 }, { TimeSlotsTemplateStartHour._3, TimeSlotsTemplateEndHour._4 }, { TimeSlotsTemplateStartHour._4, TimeSlotsTemplateEndHour._5 }, { TimeSlotsTemplateStartHour._5, TimeSlotsTemplateEndHour._6 }, { TimeSlotsTemplateStartHour._6, TimeSlotsTemplateEndHour._7 }, { TimeSlotsTemplateStartHour._7, TimeSlotsTemplateEndHour._8 }, { TimeSlotsTemplateStartHour._8, TimeSlotsTemplateEndHour._9 }, { TimeSlotsTemplateStartHour._9, TimeSlotsTemplateEndHour._10 }, { TimeSlotsTemplateStartHour._10, TimeSlotsTemplateEndHour._11 }, { TimeSlotsTemplateStartHour._11, TimeSlotsTemplateEndHour._12 }, { TimeSlotsTemplateStartHour._12, TimeSlotsTemplateEndHour._13 }, { TimeSlotsTemplateStartHour._13, TimeSlotsTemplateEndHour._14 }, { TimeSlotsTemplateStartHour._14, TimeSlotsTemplateEndHour._15 }, { TimeSlotsTemplateStartHour._15, TimeSlotsTemplateEndHour._16 }, { TimeSlotsTemplateStartHour._16, TimeSlotsTemplateEndHour._17 }, { TimeSlotsTemplateStartHour._17, TimeSlotsTemplateEndHour._18 }, { TimeSlotsTemplateStartHour._18, TimeSlotsTemplateEndHour._19 }, { TimeSlotsTemplateStartHour._19, TimeSlotsTemplateEndHour._20 }, { TimeSlotsTemplateStartHour._20, TimeSlotsTemplateEndHour._21 }, { TimeSlotsTemplateStartHour._21, TimeSlotsTemplateEndHour._22 }, { TimeSlotsTemplateStartHour._22, TimeSlotsTemplateEndHour._23 }, { TimeSlotsTemplateStartHour._23, TimeSlotsTemplateEndHour._0 } }; ScheduleTemplate _schedule = new ScheduleTemplate() { ShippingPointLookupTitle = _sp, Title = _sp.Title() + " All day schedule." }; _EDC.ScheduleTemplate.InsertOnSubmit(_schedule); _EDC.SubmitChanges(); List <TimeSlotsTemplateDay> _days = new List <TimeSlotsTemplateDay>() { { TimeSlotsTemplateDay.Friday }, { TimeSlotsTemplateDay.Monday }, { TimeSlotsTemplateDay.Saturday }, { TimeSlotsTemplateDay.Sunday }, { TimeSlotsTemplateDay.Thursday }, { TimeSlotsTemplateDay.Tuesday }, { TimeSlotsTemplateDay.Wednesday } }; foreach (TimeSlotsTemplateDay _day in _days) { List <TimeSlotsTemplate> _ts = new List <TimeSlotsTemplate>(); foreach (TimeSlotsTemplateStartHour _sh in _hours.Keys) { _ts.Add(new TimeSlotsTemplate() { TimeSlotsTemplateDay = _day, TimeSlotsTemplateEndHour = _hours[_sh], TimeSlotsTemplateEndMinute = TimeSlotsTemplateEndMinute._0, TimeSlotsTemplateStartHour = _sh, TimeSlotsTemplateStartMinute = TimeSlotsTemplateStartMinute._0, ScheduleTemplateTitle = _schedule }); } _EDC.TimeSlotsTemplate.InsertAllOnSubmit(_ts); _EDC.SubmitChanges(); } }