public void ProcessRequest(HttpContext context) { using (MainDataContext db = new MainDataContext()) { var profilesForToday = from p in CRM_FundraisingGiftProfile.PublicBaseSet(db).ToArray() where p.NextPaymentDate.Date == UKTime.Now.Date where p.IsDateActive select p; foreach (CRM_FundraisingGiftProfile profile in profilesForToday) { CRM_FundraisingGiftProfileLog log = new CRM_FundraisingGiftProfileLog() { AmountCharged = profile.AmountToCharge, IsConfirmed = false, CRM_FundraisingGiftProfileID = profile.ID, PaymentReference = profile.PaymentReference, TimestampCreated = UKTime.Now.Date, TimestampConfirmed = null }; db.CRM_FundraisingGiftProfileLogs.InsertOnSubmit(log); db.SubmitChanges(); if (profile.IsDateActive) { DateTime nextMonth = UKTime.Now.AddMonths(profile.EveryXMonth); profile.NextPaymentDate = new DateTime(nextMonth.Year, nextMonth.Month, profile.DayOfMonth); db.SubmitChanges(); } } } }
public void ProcessRequest(HttpContext context) { byte route = Convert.ToByte(HttpContext.Current.Request.QueryString["route"]); string recordid = HttpContext.Current.Request.QueryString["recordid"]; string returnurl = HttpContext.Current.Request.QueryString["returnURL"]; string message = "Done"; using (MainDataContext db = new MainDataContext()) { AuthAdmin auth = new AuthAdmin(db); if (auth.Authorise() == null) { context.Response.Write("Admin Auth Error"); context.Response.End(); } db.Dispose(); } DateTime timekey = DateTime.Parse(HttpUtility.UrlDecode(HttpContext.Current.Request.QueryString["timekey"])); if (UKTime.Now > timekey.AddMinutes(62)) { NoticeManager.SetMessage("This action has expired for security reasons - did you use your browser back button?", HttpUtility.UrlDecode(returnurl)); } else { bool disableNoticeManager = false; using (MainDataContext db = new MainDataContext()) { switch (route) { case (byte)ActionLink.Route.RemoveAdminFromCalendarItem: { CRM_CalendarAdmin calendarAdmin = db.CRM_CalendarAdmins.Single(c => c.ID.ToString() == recordid); message = calendarAdmin.AdminName + " removed from " + calendarAdmin.CRM_Calendar.DisplayName; db.CRM_CalendarAdmins.DeleteOnSubmit(calendarAdmin); db.SubmitChanges(); } break; case (byte)ActionLink.Route.RemoveFamilyPerson: { CRM_FamilyPerson familyPerson = db.CRM_FamilyPersons.Single(f => f.ID.ToString() == recordid); message = familyPerson.CRM_Person.Fullname + " removed from the " + familyPerson.CRM_Family.Name + " family"; db.CRM_FamilyPersons.DeleteOnSubmit(familyPerson); db.SubmitChanges(); } break; case (byte)ActionLink.Route.ArchiveTaskParticipant: { CRM_TaskParticipant participant = db.CRM_TaskParticipants.Single(t => t.ID.ToString() == recordid); participant.IsArchived = true; db.SubmitChanges(); message = participant.Name + " archived."; } break; case (byte)ActionLink.Route.ReinstateTaskParticipant: { CRM_TaskParticipant participant = db.CRM_TaskParticipants.Single(t => t.ID.ToString() == recordid); participant.IsArchived = false; db.SubmitChanges(); message = participant.Name + " reinstated."; } break; case (byte)ActionLink.Route.ArchivePassPerson: { CRM_AnnualPassPerson person = db.CRM_AnnualPassPersons.Single(t => t.ID.ToString() == recordid); person.IsArchived = true; db.SubmitChanges(); message = person.DisplayName + " archived."; } break; case (byte)ActionLink.Route.ReinstatePassPerson: { CRM_AnnualPassPerson person = db.CRM_AnnualPassPersons.Single(t => t.ID.ToString() == recordid); person.IsArchived = false; db.SubmitChanges(); message = person.DisplayName + " reinstanted."; } break; case (byte)ActionLink.Route.ToggleReadStatus: { NoteManager manager = new NoteManager(); bool IsRead = manager.IsRead(Convert.ToInt32(recordid)); disableNoticeManager = true; if (IsRead) { MarkAsUnread(recordid); message = "Marked as unread."; } else { MarkAsRead(recordid); message = "Marked as read."; } } break; case (byte)ActionLink.Route.MarkNoteAsRead: { MarkAsRead(recordid); db.SubmitChanges(); message = "Marked as read."; } break; case (byte)ActionLink.Route.MarkNoteAsUnread: { MarkAsUnread(recordid); db.SubmitChanges(); message = "Marked as unread."; } break; case (byte)ActionLink.Route.DeleteOrganisationSchool: { CRM_OrganisationSchool orgSchool = db.CRM_OrganisationSchools.FirstOrDefault(s => s.ID.ToString() == recordid); if (orgSchool != null) { db.CRM_OrganisationSchools.DeleteOnSubmit(orgSchool); db.SubmitChanges(); message = "Link removed"; } } break; case (byte)ActionLink.Route.ToggleInviteIsAttended: { CRM_CalendarInvite invite = db.CRM_CalendarInvites.FirstOrDefault(s => s.ID.ToString() == recordid); if (invite != null) { invite.IsAttended = !invite.IsAttended; db.SubmitChanges(); message = "Invite Attendance Toggled"; } } break; case (byte)ActionLink.Route.ToggleInviteIsBooked: { CRM_CalendarInvite invite = db.CRM_CalendarInvites.FirstOrDefault(s => s.ID.ToString() == recordid); if (invite != null) { invite.IsBooked = !invite.IsBooked; db.SubmitChanges(); message = "Invite Booked Toggled"; } } break; case (byte)ActionLink.Route.ToggleInviteIsCancelled: { CRM_CalendarInvite invite = db.CRM_CalendarInvites.FirstOrDefault(s => s.ID.ToString() == recordid); if (invite != null) { invite.IsCancelled = !invite.IsCancelled; db.SubmitChanges(); message = "Invite Cancellation Toggled"; } } break; case (byte)ActionLink.Route.ToggleInviteIsInvited: { CRM_CalendarInvite invite = db.CRM_CalendarInvites.FirstOrDefault(s => s.ID.ToString() == recordid); if (invite != null) { invite.IsInvited = !invite.IsInvited; db.SubmitChanges(); message = "Invite Toggled"; } } break; case (byte)ActionLink.Route.DeleteInvite: { CRM_CalendarInvite invite = db.CRM_CalendarInvites.FirstOrDefault(s => s.ID.ToString() == recordid); if (invite != null) { db.CRM_CalendarInvites.DeleteOnSubmit(invite); db.SubmitChanges(); message = "Invite Removed"; } } break; case (byte)ActionLink.Route.ToggleGiftAidRecord: { CRM_FundraisingGiftProfileLog log = db.CRM_FundraisingGiftProfileLogs.FirstOrDefault(f => f.ID.ToString() == recordid); if (log != null) { if (!log.IsConfirmed) { log.TimestampConfirmed = UKTime.Now; log.IsConfirmed = true; } else { log.TimestampConfirmed = null; log.IsConfirmed = false; } db.SubmitChanges(); message = "Gift aid record toggled"; } } break; case (byte)ActionLink.Route.DeleteGiftAidRecord: { CRM_FundraisingGiftProfileLog log = db.CRM_FundraisingGiftProfileLogs.FirstOrDefault(f => f.ID.ToString() == recordid); if (log != null) { db.CRM_FundraisingGiftProfileLogs.DeleteOnSubmit(log); db.SubmitChanges(); message = "Gift aid record deleted"; } } break; } db.Dispose(); if (!disableNoticeManager) { NoticeManager.SetMessage(message, HttpUtility.UrlDecode(returnurl)); } else { HttpContext.Current.Response.Redirect(returnurl); } } } }