public void InitTimetablePreview(ProviderEDSC.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 ProviderEDSC.ActivityScheduleGridDTDataTable(); } ScheduleDT = getTimetable(false); ProviderEDSC.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; } }
public void Refresh() { dt = new ProviderDAC().RetrieveActivitySchedules(ActivityID); if (dt != null) { SetdataSource(); } }
public ProviderEDSC.ActivityScheduleDTRow getTimetableInput() { if (ScheduleDT == null) { ScheduleDT = new ProviderEDSC.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.ActivityExpiryDate = Convert.ToDateTime(txtEndDate.Text); if (ddlTimeEnds.SelectedItem.Value != SystemConstants.nodate.ToShortTimeString()) { drShced.ActivityEndDatetime = Convert.ToDateTime(txtEndDate.Text + " " + ddlTimeEnds.SelectedItem.Text); } else { drShced.ActivityEndDatetime = SystemConstants.nodate; } 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); }
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 lnkSelectAll_Click(object sender, EventArgs e) //{ // ProviderEDSC.ActivityScheduleDTDataTable dt = new ProviderEDSC.ActivityScheduleDTDataTable(); // foreach (GridViewRow row in gridviewPreview.Rows) // { // if (row.RowType == DataControlRowType.DataRow) // { // CheckBox chkboxSelected = row.FindControl("chkboxSelected") as CheckBox; // chkboxSelected.Checked = true; // } // } //} protected void lnkSelect2All_Click(object sender, EventArgs e) { ProviderEDSC.ActivityScheduleDTDataTable dt = new ProviderEDSC.ActivityScheduleDTDataTable(); foreach (GridViewRow row in gridviewTimetable.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkboxSelected = row.FindControl("chkboxSelected0") as CheckBox; chkboxSelected.Checked = true; } } }
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); } }
public void initTimetable() { SetTimeDDL(); var dr = new ProviderDAC().RetrieveActivity(ActivityID); if (dr != null) { if (dr.TimetableType == (int)SystemConstants.ScheduleViewFormat.noTimetable) { radEnableTimetable.Checked = false; radNoTimetable.Checked = true; divTimetable.Visible = false; } else { if (EditMode) { ScheduleDT = new ProviderDAC().RetrieveActivitySchedules(ActivityID); } SetScheduleDataSource(); //SetTimetableDataSource(); } } }
public ProviderEDSC.ActivityScheduleDTDataTable getTimetable(bool checkDelete) { ScheduleDT = new ProviderEDSC.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); }
/* * public static void UpdateActivity(ProviderEDSC.ActivityDTRow drDetail, ProviderEDSC.ActivityContactDetailDTRow contactDetails, ProviderEDSC.ActivityGroupingDTRow drActGrouping, ProviderEDSC.ActivityScheduleDTDataTable dtActSchedule) * { * ProviderDAC dac = new ProviderDAC(); * * * dac.UpdateActivities(drDetail); * dac.UpdateActivityContactDetail(contactDetails); * dac.DeleteActivitySchedules(drDetail.ID); * foreach (var drActSchedule in dtActSchedule) * dac.CreateActivitySchedule(drActSchedule); * dac.UpdateActivityGrouping(drActGrouping); * * * } * * public static void UpdateActivity(ProviderEDSC.ActivityDTRow drDetail, ProviderEDSC.ActivityContactDetailDTRow contactDetails, ProviderEDSC.ActivityGroupingDTRow drActGrouping) * { * ProviderDAC dac = new ProviderDAC(); * * * dac.UpdateActivities(drDetail); * dac.UpdateActivityContactDetail(contactDetails); * dac.DeleteActivitySchedules(drDetail.ID); * dac.UpdateActivityGrouping(drActGrouping); * } * * public static void SaveActivity(ProviderEDSC.ActivityDTRow ActivityDetailDR, ProviderEDSC.ActivityContactDetailDTRow contactDetailsDR, ProviderEDSC.ActivityGroupingDTRow ActGroupingDR, ProviderEDSC.ActivityScheduleDTDataTable ActScheduleDT, out int activityID) * { * ProviderDAC dac = new ProviderDAC(); * * using (TransactionScope trans = new TransactionScope()) * { * activityID = 0; * dac.CreateActivities(ActivityDetailDR, out activityID); * * //Activity was Created, update all foreign key * contactDetailsDR.ActivityID = activityID; * ActGroupingDR.ActivityID = activityID; * * //CreateContactDetails * dac.CreateActivityContactDetail(contactDetailsDR); * * //Create Schedule * foreach (var ActScheduleDR in ActScheduleDT) * { * ActScheduleDR.ActivityID = activityID; * dac.CreateActivitySchedule(ActScheduleDR); * } * //Create Grouping * dac.CreateActivityGrouping(ActGroupingDR); * * trans.Complete(); * * } * } * * public static void SaveActivity(ProviderEDSC.ActivityDTRow ActivityDetailDR, ProviderEDSC.ActivityContactDetailDTRow contactDetailsDR, ProviderEDSC.ActivityGroupingDTRow ActGroupingDR, out int activityID) * { * ProviderDAC dac = new ProviderDAC(); * * using (TransactionScope trans = new TransactionScope()) * { * activityID = 0; * dac.CreateActivities(ActivityDetailDR, out activityID); * * //Activity was Created, update all foreign key * contactDetailsDR.ActivityID = activityID; * ActGroupingDR.ActivityID = activityID; * * //CreateContactDetails * dac.CreateActivityContactDetail(contactDetailsDR); * * //Create Grouping * dac.CreateActivityGrouping(ActGroupingDR); * * trans.Complete(); * * } * } */ public static void SaveActivity(ProviderEDSC.ActivityDTRow ActivityDetailDR, ProviderEDSC.ActivityContactDetailDTRow contactDetailsDR, ProviderEDSC.ActivityGroupingDTRow ActGroupingDR, ProviderEDSC.ActivityScheduleDTDataTable ActScheduleDT, ProviderEDSC.ActivityImageDTRow ImageDetail, ProviderEDSC.ActivityImageDetailDTDataTable Images, out int activityID) { ProviderDAC dac = new ProviderDAC(); using (TransactionScope trans = new TransactionScope()) { activityID = 0; dac.CreateActivities(ActivityDetailDR, out activityID); //Activity was Created, Creat other contactDetailsDR.ActivityID = activityID; ActGroupingDR.ActivityID = activityID; //CreateContactDetails dac.CreateActivityContactDetail(contactDetailsDR); if (ActScheduleDT != null) { //Create Schedule foreach (var ActScheduleDR in ActScheduleDT) { ActScheduleDR.ActivityID = activityID; dac.CreateActivitySchedule(ActScheduleDR); } } //Create Grouping dac.CreateActivityGrouping(ActGroupingDR); //Create Images if (ImageDetail.ImageAmount != 0) { ImageDetail.ActivityID = activityID; int imgDetID = 0; dac.createActivityImageInformation(ImageDetail, out imgDetID); int count = 1; foreach (var drImageDetail in Images) { if (count == 1) { drImageDetail.isPrimaryImage = true; } drImageDetail.ActivityID = activityID; drImageDetail.ActivityImageID = imgDetID; dac.CreateActivityImage(drImageDetail); count++; } } trans.Complete(); } }
public static void UpdateActivity(int activityID, ProviderEDSC.ActivityDTRow ActivityDetailDR, ProviderEDSC.ActivityContactDetailDTRow contactDetailsDR, ProviderEDSC.ActivityGroupingDTRow ActGroupingDR, ProviderEDSC.ActivityScheduleDTDataTable ActScheduleDT) { ProviderDAC dac = new ProviderDAC(); dac.DeleteActivitySchedules(activityID); using (TransactionScope trans = new TransactionScope()) { ActivityDetailDR.ID = contactDetailsDR.ActivityID = ActGroupingDR.ActivityID = activityID; //Activity was update, Create other dac.UpdateActivities(ActivityDetailDR); //CreateContactDetails dac.UpdateActivityContactDetail(contactDetailsDR); //Delete old Schedule before insert new one if (ActScheduleDT != null) { //Create Schedule foreach (var ActScheduleDR in ActScheduleDT) { ActScheduleDR.ActivityID = activityID; dac.CreateActivitySchedule(ActScheduleDR); } } //Create Grouping dac.UpdateActivityGrouping(ActGroupingDR); trans.Complete(); } }
private List <List <slot> > CreateSeasonalTimetable(ProviderEDSC.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); }