private void Form1_Load(object sender, EventArgs e)
{
foreach (ComboBox cb in tabPage2.Controls.OfType <ComboBox>())
{
cb.Items.Add("---Not Open---");
cb.Items.Add("Every Week");
cb.Items.Add("First and Third Week of the Month");
cb.Items.Add("Second and Forth Week of the Month");
cb.Items.Add("First Week of the Month");
cb.Items.Add("Second Week of the Month");
cb.Items.Add("Third Week of the Month");
cb.Items.Add("Forth Week of the Month");
}
CCFBOpenDayOfWeek.OpenDOW();
for (int i = 0; i < CCFBOpenDayOfWeek.DSetDOWRowsCount; i++)
{
for (int j = 0; j < cbList.Count; j++)
{
if (cbList[j].Tag.ToString() == CCFBOpenDayOfWeek.DSetDOW.Tables[0].Rows[i]["EditLabel"].ToString())
{
cbList[j].SelectedIndex = Int32.Parse(CCFBOpenDayOfWeek.DSetDOW.Tables[0].Rows[i]["FldVal"].ToString());
break;
}
}
}
ChangeMode(1);
}
private void selctionCommited(ComboBox cb)
{
for (int i = 0; i < CCFBOpenDayOfWeek.DSetDOWRowsCount; i++)
{
if (cb.Tag.ToString() == CCFBOpenDayOfWeek.DSetDOW.Tables[0].Rows[i]["EditLabel"].ToString())
{
CCFBOpenDayOfWeek.DSetDOW.Tables[0].Rows[i]["FldVal"] = cb.SelectedIndex;
break;
}
}
CCFBOpenDayOfWeek.updateDOW();
}
private void YearlyForm_Load(object sender, EventArgs e)
{
DateTime dateTest;
foreach (ComboBox cb in tabPage2.Controls.OfType <ComboBox>())
{
cb.Items.Add("---Not Open---");
cb.Items.Add("Every Week");
cb.Items.Add("First and Third Week of the Month");
cb.Items.Add("Second and Forth Week of the Month");
cb.Items.Add("First Week of the Month");
cb.Items.Add("Second Week of the Month");
cb.Items.Add("Third Week of the Month");
cb.Items.Add("Forth Week of the Month");
}
CCFBOpenDayOfWeek.OpenDOW();
for (int i = 0; i < CCFBOpenDayOfWeek.DSetDOWRowsCount; i++)
{
for (int j = 0; j < cbList.Count; j++)
{
if (cbList[j].Tag.ToString() == CCFBOpenDayOfWeek.DSetDOW.Tables[0].Rows[i]["EditLabel"].ToString())
{
cbList[j].SelectedIndex = Int32.Parse(CCFBOpenDayOfWeek.DSetDOW.Tables[0].Rows[i]["FldVal"].ToString());
break;
}
}
}
clsDaysOpen.openWhere("date = (SELECT MAX(date) From DaysOpen)");
if (clsDaysOpen.RowCount > 0)
{
dateTest = clsDaysOpen.date;
}
else
{
dateTest = DateTime.Today;
}
dateTest = dateTest.AddMonths(1);
string tmp = dateTest.Month.ToString() + "/01/" + dateTest.Year.ToString();
dtpPeriodStart.Value = DateTime.Parse(tmp);
dateTest = dtpPeriodStart.Value.AddYears(1).AddDays(-1);
dtpPeriodEnd.Value = dateTest;
ChangeMode(1);
}
public void BatchProcess(DateTime FirstDate, DateTime LastDate, int InsertMode, bool ForceIsCommodity)
{
int NbrRowsCleared = 0;
if (InsertMode == 0) //Clear All Dates
{
NbrRowsCleared = DeleteDateRange(FirstDate.ToString(), LastDate.ToString());
dset.Tables[tbName].Clear();
}
int[] DOWRules = new int[7];
//For each day of week
for (int i = 0; i < CCFBOpenDayOfWeek.DSetDOW.Tables[0].Rows.Count; i++)
{
DOWRules[i] = Convert.ToInt32(CCFBOpenDayOfWeek.DSetDOW.Tables[0].Rows[i]["FldVal"]);
}
DateTime WorkDate = FirstDate;
int myDOW = 0;
int WeekofMonth = 0;
do
{
myDOW = CCFBOpenDayOfWeek.findRow(WorkDate.DayOfWeek.ToString());
if (DOWRules[myDOW] > 0)
{
if (FindDate(WorkDate) > 0)
{
if (InsertMode == 1)
{
IsCommodity = ForceIsCommodity;
SpecialItems = "";
}
}
else
{
switch (DOWRules[myDOW])
{
case 1: //Sets day of week for every week
{
AddDate(WorkDate, ForceIsCommodity, "");
break;
}
case 2: //Sets for 1st and 3rd weeks
{
WeekofMonth = CalculateWeekofMonth(WorkDate);
if (WeekofMonth == 1 || WeekofMonth == 3)
{
AddDate(WorkDate, ForceIsCommodity, "");
}
break;
}
case 3: //Sets for 2nd and 4th weeks
{
WeekofMonth = CalculateWeekofMonth(WorkDate);
if (WeekofMonth == 2 || WeekofMonth == 4)
{
AddDate(WorkDate, ForceIsCommodity, "");
}
break;
}
case 4: //Sets for 1st week
{
WeekofMonth = CalculateWeekofMonth(WorkDate);
if (WeekofMonth == 1)
{
AddDate(WorkDate, ForceIsCommodity, "");
}
break;
}
case 5: //Sets for 2nd week
{
WeekofMonth = CalculateWeekofMonth(WorkDate);
if (WeekofMonth == 2)
{
AddDate(WorkDate, ForceIsCommodity, "");
}
break;
}
case 6: //Sets for 3rd week
{
WeekofMonth = CalculateWeekofMonth(WorkDate);
if (WeekofMonth == 3)
{
AddDate(WorkDate, ForceIsCommodity, "");
}
break;
}
case 7: //Sets for 4th week
{
WeekofMonth = CalculateWeekofMonth(WorkDate);
if (WeekofMonth == 4)
{
AddDate(WorkDate, ForceIsCommodity, "");
}
break;
}
}
}
}
WorkDate = WorkDate.AddDays(1);
} while (WorkDate <= LastDate);
update();
}