public void InitTimetablePreview(AdministrationEDSC.ActivityScheduleDTDataTable dt)
{
var schedule = CreateSeasonalTimetable(dt);
ListView1.DataSource = schedule;
ListView1.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
lblError.Visible = false;
if (infoIsValid())
{
if (timeTableDT == null)
{
timeTableDT = new AdministrationEDSC.ActivityScheduleGridDTDataTable();
}
ScheduleDT = getTimetable(false);
AdministrationEDSC.ActivityScheduleGridDTRow dr = timeTableDT.NewActivityScheduleGridDTRow();
if (txtEndDate.Text == "")
{
lblError.Text = "* Required";
txtEndDate.Focus();
}
else
{
var aSched = getTimetableInput();
ScheduleDT.AddActivityScheduleDTRow(aSched);
SetScheduleDataSource();
SetTimetableDataSource();
SetTimetablePreview();
btnAdd.Text = "Add another timetable";
}
}
else
{
lblError.Visible = true;
}
}
protected void lnkDelete2_Click(object sender, EventArgs e)
{
ScheduleDT = getTimetable(true);
SetScheduleDataSource();
SetTimetableDataSource();
SetTimetablePreview();
if (gridviewTimetable.Rows.Count == 0)
{
btnAdd.Text = "Add Timetable";
}
}
protected void lnkSelect2All_Click(object sender, EventArgs e)
{
AdministrationEDSC.ActivityScheduleDTDataTable dt = new AdministrationEDSC.ActivityScheduleDTDataTable();
foreach (GridViewRow row in gridviewTimetable.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkboxSelected = row.FindControl("chkboxSelected0") as CheckBox;
chkboxSelected.Checked = true;
}
}
}
public AdministrationEDSC.ActivityScheduleDTRow getTimetableInput()
{
if (ScheduleDT == null)
{
ScheduleDT = new AdministrationEDSC.ActivityScheduleDTDataTable();
}
var drShced = ScheduleDT.NewActivityScheduleDTRow();
drShced.OnMonday = false;
drShced.OnTuesday = false;
drShced.OnWednesday = false;
drShced.OnThursday = false;
drShced.OnFriday = false;
drShced.OnSaturday = false;
drShced.OnSunday = false;
drShced.ActivityStartDatetime = Convert.ToDateTime(txtCalendarFrom.Text + " " + ddlTimeStart.SelectedItem.Text);
drShced.ActivityEndDatetime = Convert.ToDateTime(txtEndDate.Text + " " + ddlTimeEnds.SelectedItem.Text);
drShced.ActivityExpiryDate = Convert.ToDateTime(txtEndDate.Text);
drShced.RecurrenceType = (int)SystemConstants.RecurrenceSchedule.Weekly;
if (radWeekly.Checked)
{
drShced.RecurEvery = 1;
}
else if (radFortnightly.Checked)
{
drShced.RecurEvery = 2;
}
else if (radMonthly.Checked)
{
drShced.RecurEvery = 4;
}
else if (radNoRecurrence.Checked)
{
drShced.RecurEvery = 0;
drShced.RecurrenceType = (int)SystemConstants.RecurrenceSchedule.NotRecurring;
}
drShced.OnMonday = chkMonday.Checked;
drShced.OnTuesday = chkTuesday.Checked;
drShced.OnWednesday = chkWebnesday.Checked;
drShced.OnThursday = chkThursday.Checked;
drShced.OnFriday = chkFriday.Checked;
drShced.OnSaturday = chkSaturday.Checked;
drShced.OnSunday = chkSunday.Checked;
return(drShced);
}
public void initTimetable(int TimetableType)
{
SetTimeDDL();
if (TimetableType == (int)SystemConstants.ScheduleViewFormat.noTimetable)
{
radEnableTimetable.Checked = false;
radNoTimetable.Checked = true;
divTimetable.Visible = false;
}
else
{
if (EditMode)
{
ScheduleDT = new AdministrationDAC().RetrieveActivitySchedules(ActivityID);
}
SetScheduleDataSource();
SetTimetableDataSource();
}
}
public void getExpiry(out DateTime activityExpiry, out bool usingTimetable)
{
usingTimetable = radEnableTimetable.Checked;
if (radEnableTimetable.Checked)
{
ScheduleDT = getTimetable(false);
List <DateTime> expiry = new List <DateTime>();
foreach (var dr in ScheduleDT)
{
expiry.Add(dr.ActivityExpiryDate);
}
expiry.Sort((a, b) => a.CompareTo(b));
activityExpiry = expiry[expiry.Count() - 1];
}
else
{
activityExpiry = DateTime.Now.AddDays(90);
}
}
private List <List <slot> > CreateSeasonalTimetable(AdministrationEDSC.ActivityScheduleDTDataTable SchedulesDT)
{
List <List <slot> > schedule = new List <List <slot> >();
List <slot> monday = new List <slot>();
List <slot> tuesday = new List <slot>();
List <slot> wednesday = new List <slot>();
List <slot> thursday = new List <slot>();
List <slot> friday = new List <slot>();
List <slot> saturday = new List <slot>();
List <slot> sunday = new List <slot>();
//var SortSchedulesDT = SchedulesDT.OrderByDescending(day => day.ActivityStartDatetime.Hour);
foreach (var schedules in SchedulesDT)
{
if (!schedules.OnMonday && !schedules.OnTuesday && !schedules.OnWednesday && !schedules.OnThursday &&
!schedules.OnFriday && !schedules.OnSaturday && !schedules.OnSunday)
{
DayOfWeek day = schedules.ActivityStartDatetime.DayOfWeek;
if (day == DayOfWeek.Monday)
{
schedules.OnMonday = true;
}
if (day == DayOfWeek.Tuesday)
{
schedules.OnTuesday = true;
}
if (day == DayOfWeek.Wednesday)
{
schedules.OnWednesday = true;
}
if (day == DayOfWeek.Thursday)
{
schedules.OnThursday = true;
}
if (day == DayOfWeek.Friday)
{
schedules.OnFriday = true;
}
if (day == DayOfWeek.Saturday)
{
schedules.OnSaturday = true;
}
if (day == DayOfWeek.Sunday)
{
schedules.OnSunday = true;
}
}
if (schedules.OnMonday)
{
slot slMon = new slot();
slMon.startTime = schedules.ActivityStartDatetime;
slMon.EndTime = schedules.ActivityEndDatetime;
slMon.Day = DayOfWeek.Monday.ToString();
monday.Add(slMon);
}
if (schedules.OnTuesday)
{
slot slTue = new slot();
slTue.startTime = schedules.ActivityStartDatetime;
slTue.EndTime = schedules.ActivityEndDatetime;
slTue.Day = DayOfWeek.Tuesday.ToString();
tuesday.Add(slTue);
}
if (schedules.OnWednesday)
{
slot slWednesday = new slot();
slWednesday.startTime = schedules.ActivityStartDatetime;
slWednesday.EndTime = schedules.ActivityEndDatetime;
slWednesday.Day = DayOfWeek.Wednesday.ToString();
wednesday.Add(slWednesday);
}
if (schedules.OnThursday)
{
slot slThursday = new slot();
slThursday.startTime = schedules.ActivityStartDatetime;
slThursday.EndTime = schedules.ActivityEndDatetime;
slThursday.Day = DayOfWeek.Thursday.ToString();
thursday.Add(slThursday);
}
if (schedules.OnFriday)
{
slot slFriday = new slot();
slFriday.startTime = schedules.ActivityStartDatetime;
slFriday.EndTime = schedules.ActivityEndDatetime;
slFriday.Day = DayOfWeek.Friday.ToString();
friday.Add(slFriday);
}
if (schedules.OnSaturday)
{
slot slSaturday = new slot();
slSaturday.startTime = schedules.ActivityStartDatetime;
slSaturday.EndTime = schedules.ActivityEndDatetime;
slSaturday.Day = DayOfWeek.Saturday.ToString();
saturday.Add(slSaturday);
}
if (schedules.OnSunday)
{
slot slSunday = new slot();
slSunday.startTime = schedules.ActivityStartDatetime;
slSunday.EndTime = schedules.ActivityEndDatetime;
slSunday.Day = DayOfWeek.Sunday.ToString();
sunday.Add(slSunday);
}
}
if (monday.Count() != 0)
{
monday.Sort((x, y) => y.startTime.CompareTo(x.startTime));
monday.Reverse();
schedule.Add(monday);
}
if (tuesday.Count() != 0)
{
tuesday.Sort((x, y) => y.startTime.CompareTo(x.startTime));
tuesday.Reverse();
schedule.Add(tuesday);
}
if (wednesday.Count() != 0)
{
wednesday.Sort((x, y) => y.startTime.CompareTo(x.startTime));
wednesday.Reverse();
schedule.Add(wednesday);
}
if (thursday.Count() != 0)
{
thursday.Sort((x, y) => y.startTime.CompareTo(x.startTime));
thursday.Reverse();
schedule.Add(thursday);
}
if (friday.Count() != 0)
{
friday.Sort((x, y) => y.startTime.CompareTo(x.startTime));
friday.Reverse();
schedule.Add(friday);
}
if (saturday.Count() != 0)
{
saturday.Sort((x, y) => y.startTime.CompareTo(x.startTime));
saturday.Reverse();
schedule.Add(saturday);
}
if (sunday.Count() != 0)
{
sunday.Sort((x, y) => y.startTime.CompareTo(x.startTime));
sunday.Reverse();
schedule.Add(sunday);
}
return(schedule);
}
public AdministrationEDSC.ActivityScheduleDTDataTable getTimetable(bool checkDelete)
{
ScheduleDT = new AdministrationEDSC.ActivityScheduleDTDataTable();
foreach (GridViewRow row in gridviewTimetable.Rows)
{
CheckBox chkboxSelected0 = row.FindControl("chkboxSelected0") as CheckBox;
HiddenField hdnStartDateTime = row.FindControl("hdnStartDateTime") as HiddenField;
HiddenField hdnEndDateTime = row.FindControl("hdnEndDateTime") as HiddenField;
HiddenField hdnExpiryDateTime = row.FindControl("hdnExpiryDateTime") as HiddenField;
HiddenField hdnRecurrenceType = row.FindControl("hdnRecurrenceType") as HiddenField;
HiddenField hdnRecurEvery = row.FindControl("hdnRecurEvery") as HiddenField;
HiddenField hdnOnMonday = row.FindControl("hdnOnMonday") as HiddenField;
HiddenField hdnOnTuesday = row.FindControl("hdnOnTuesday") as HiddenField;
HiddenField hdnOnWednesday = row.FindControl("hdnOnWednesday") as HiddenField;
HiddenField hdnOnThursday = row.FindControl("hdnOnThursday") as HiddenField;
HiddenField hdnOnFriday = row.FindControl("hdnOnFriday") as HiddenField;
HiddenField hdnOnSaturday = row.FindControl("hdnOnSaturday") as HiddenField;
HiddenField hdnOnSunday = row.FindControl("hdnOnSunday") as HiddenField;
if (checkDelete)
{
if (!chkboxSelected0.Checked)
{
var dr = ScheduleDT.NewActivityScheduleDTRow();
dr.ActivityID = ActivityID;
dr.ActivityStartDatetime = Convert.ToDateTime(hdnStartDateTime.Value);
dr.ActivityEndDatetime = Convert.ToDateTime(hdnEndDateTime.Value);
dr.ActivityExpiryDate = Convert.ToDateTime(hdnExpiryDateTime.Value);
dr.RecurrenceType = Convert.ToInt32(hdnRecurrenceType.Value);
dr.RecurEvery = Convert.ToInt32(hdnRecurEvery.Value);
dr.OnMonday = Convert.ToBoolean(hdnOnMonday.Value);
dr.OnTuesday = Convert.ToBoolean(hdnOnTuesday.Value);
dr.OnWednesday = Convert.ToBoolean(hdnOnWednesday.Value);
dr.OnThursday = Convert.ToBoolean(hdnOnThursday.Value);
dr.OnFriday = Convert.ToBoolean(hdnOnFriday.Value);
dr.OnSaturday = Convert.ToBoolean(hdnOnSaturday.Value);
dr.OnSunday = Convert.ToBoolean(hdnOnSunday.Value);
ScheduleDT.AddActivityScheduleDTRow(dr);
}
}
else
{
var dr = ScheduleDT.NewActivityScheduleDTRow();
dr.ActivityID = ActivityID;
dr.ActivityStartDatetime = Convert.ToDateTime(hdnStartDateTime.Value);
dr.ActivityEndDatetime = Convert.ToDateTime(hdnEndDateTime.Value);
dr.ActivityExpiryDate = Convert.ToDateTime(hdnExpiryDateTime.Value);
dr.RecurrenceType = Convert.ToInt32(hdnRecurrenceType.Value);
dr.RecurEvery = Convert.ToInt32(hdnRecurEvery.Value);
dr.OnMonday = Convert.ToBoolean(hdnOnMonday.Value);
dr.OnTuesday = Convert.ToBoolean(hdnOnTuesday.Value);
dr.OnWednesday = Convert.ToBoolean(hdnOnWednesday.Value);
dr.OnThursday = Convert.ToBoolean(hdnOnThursday.Value);
dr.OnFriday = Convert.ToBoolean(hdnOnFriday.Value);
dr.OnSaturday = Convert.ToBoolean(hdnOnSaturday.Value);
dr.OnSunday = Convert.ToBoolean(hdnOnSunday.Value);
ScheduleDT.AddActivityScheduleDTRow(dr);
}
}
return(ScheduleDT);
}
