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