C# pickle

CountingCrows · 03-06-2015 10:19am #1

I'm querying a table which has a 0/1 (true/false) delivery indicator for each weekday. I need to store the delivery cycles.

delivery cycle = (delivery day + 1) to next deliveryday

E.g

MO 1
TU 1
WE 1
TH 0
FR 0
SA 0
SO 0

Cycle 1 = Tuesday only
Cycle 2 = Wednesday only
Cycle 3 = Thursday + Friday + Saturday + Sunday + Monday

Can't get my head around a suitable routine to return this. Any ideas?

seamus · 03-06-2015 10:25am

Not entirely sure I understand the question, but from what I can gather, given a specific day you want to calculate when the delivery will occur? E.g. Given a Tuesday, you say the delivery will occur on Wednesday. Given a Friday, it returns Monday?

CountingCrows · 03-06-2015 10:28am

seamus wrote: »

Not entirely sure I understand the question, but from what I can gather, given a specific day you want to calculate when the delivery will occur? E.g. Given a Tuesday, you say the delivery will occur on Wednesday. Given a Friday, it returns Monday?

I need a routine to store all the possible delivery cycles. E.g using the example data I gave, the routine should return/store the 3 cycles at the bottom of the example.

Giblet · 03-06-2015 11:18am

Domain language is confusing, what is the definition of a cycle.

03-06-2015 11:30am

Yeah, it's not clear at all what you're looking for. Why does Cycle 3 include Monday but not Tuesday or Wednesday? If, in your example, Tuesday was a 0, what would the cycles be?

CountingCrows · 03-06-2015 11:31am

Giblet wrote: »

what is the definition of a cycle.

delivery cycle = (delivery day + 1) to next deliveryday

Using example data;

delivery cycle 1 = (Monday + 1 day) to Tuesday
delivery cycle 1 = Tuesday to Tuesday
delivery cycle 1 = Tuesday

CountingCrows · 03-06-2015 11:34am

28064212 wrote: »

Why does Cycle 3 include Monday but not Tuesday or Wednesday?

delivery cycle = (delivery day + 1) to next deliveryday

Cycle 3 = (Wednesday + 1 day) to next delivery-day (Monday)
Cycle 3 = Thursday-Monday

dazberry · 03-06-2015 11:49am

CountingCrows wrote: »

MO 1
TU 1
WE 1
TH 0
FR 0
SA 0
SO 0

Cycle 1 = Tuesday only
Cycle 2 = Wednesday only
Cycle 3 = Thursday + Friday + Saturday + Sunday + Monday

What cycles would you get from:

MO 1
TU 1
WE 0
TH 1
FR 0
SA 0
SO 0

D.

CountingCrows · 03-06-2015 11:53am

dazberry wrote: »

What cycles would you get from:

MO 1
TU 1
WE 0
TH 1
FR 0
SA 0
SO 0

D.

delivery cycle = (delivery day + 1) to next deliveryday

cycle 1 = (Monday + 1) to Tuesday
cycle 1 = Tuesday

cycle 2 = (Tuesday+ 1) to Thursday
cycle 2 = Wednesday+Thursday

cycle 3 = (Thursday + 1) to Monday
cycle 3 = Friday+Saturday+Sunday+Monday

dazberry · 03-06-2015 12:49pm

Thanks, what cycles would you get from this also?

MO 1
TU 0
WE 1
TH 0
FR 1
SA 0
SO 0

D.

CountingCrows · 03-06-2015 2:29pm

Solved it. Key function I needed was to loop through the week starting on a specific day, in the this case the Delivery day + 1.

DayOfWeek startDayPlusOne = startDay + 1;

var daysOfWeek = Enum.GetValues(typeof(DayOfWeek))
            .OfType<DayOfWeek>()
            .OrderBy(day => day < startDayPlusOne);

foreach (DayOfWeek day in daysOfWeek)
{                
[INDENT]foreach (DeliveryDay nextDelivery in deliveryDays)[/INDENT]
[INDENT]{[/INDENT]

Note to self - writing out a problem with other viewers in mind is a great way to take a step back as opposed to banging away with code!

seamus · 03-06-2015 2:43pm

This is one of those problems that there are multiple ways of doing this but most of them extremely ugly. I spent about 30 minutes doing various solution on this, all too ugly to post up here

Note to self, sometimes code doesn't have to be pretty.

C# pickle

Comments