public static List <EventRequest> Migrate() { var oldData = EthicsClearance.GetAll(); foreach (EthicsClearance ec in oldData) { try { var request = MigrateEthicsClearance(ec); MigrateAttendees(request.Id, ec); MigrateAttachments(request.Id, ec); } catch (Exception ex) { SharePointHelper.HandleException(ex, "admin", "EthicsClearance.Migrate"); } } return(EventRequest.GetAll()); }
public override void MapFromList(ListItem item, bool includeChildren = false) { base.MapFromList(item); this.SharePointList = SharePointHelper.ToStringNullSafe(item["SharePointList"]); this.ViewName = SharePointHelper.ToStringNullSafe(item["ViewName"]); this.RecipientType = SharePointHelper.ToStringNullSafe(item["RecipientType"]); this.RecipientColumn = SharePointHelper.ToStringNullSafe(item["RecipientColumn"]); this.Subject = SharePointHelper.ToStringNullSafe(item["Subject"]); this.Frequency = SharePointHelper.ToStringNullSafe(item["Frequency"]); this.Body = SharePointHelper.ToStringNullSafe(item["Body"]); this.NextRunDate = Convert.ToDateTime(item["NextRunDateTime"]); this.LastRunDate = Convert.ToDateTime(item["LastRunDateTime"]); this.LastRunStatus = SharePointHelper.ToStringNullSafe(item["LastRunStatus"]); this.IncludeCc = Convert.ToBoolean(item["IncludeCC"]); this.Enabled = Convert.ToBoolean(item["Enabled"]); this.Application = SharePointHelper.ToStringNullSafe(item["Application"]); var dict = new Dictionary <string, string>(); dict = Settings.GetAppEmailFieldsDef(dict); if (Title == NotificationTypes.EXTENSION_DECISION || Title == NotificationTypes.EXTENSION_RECEIVED || Title == NotificationTypes.EXTENSION_REQUEST) { dict = ExtensionRequest.GetEmailFieldsDef(dict); } else if (this.Application == Constants.ApplicationName.OGE_FORM_450) { dict = OGEForm450.GetEmailFieldsDef(dict); } else if (this.Application == Constants.ApplicationName.EVENT_CLEARANCE) { dict = EventRequest.GetEmailFieldsDef(dict); } this.TemplateFields = dict; }
private static EventRequest MigrateEthicsClearance(EthicsClearance ec) { var request = new EventRequest(); request.Title = ec.EventName + " (" + ec.EventStartDate.Value.Year + ")"; request.SubmittedBy = UserInfo.GetUserByName(ec.Submitter); request.EventName = ec.EventName; request.GuestsInvited = ec.GuestInvited == "Yes"; request.EventStartDate = ec.EventStartDate; request.EventEndDate = ec.EventEndDate; request.EventContactName = ec.EventContactName; var individualData = ec.IndividualExtendingInvite.Split('|'); request.IndividualExtendingInvite = individualData.Length > 0 ? individualData[0] : ""; request.IsIndividualLobbyist = individualData.Length > 1 ? (individualData[1] == "Yes") : false; var orgData = ec.OrganizationExtendingInvite.Split('|'); var other = ""; request.OrgExtendingInvite = orgData.Length > 0 ? orgData[0] : ""; request.IsOrgLobbyist = orgData.Length > 1 ? (orgData[1] == "Yes") : false; request.TypeOfOrg = orgData.Length > 2 ? GetOrgType(orgData[2], ref other) : 0; request.OrgOther = other; var hostData = ec.OrganizerHostingEvent.Split('|'); request.OrgHostingEvent = hostData.Length > 0 ? hostData[0] : ""; request.IsHostLobbyist = hostData.Length > 1 ? (hostData[1] == "Yes") : false; other = ""; request.TypeOfHost = hostData.Length > 2 ? GetOrgType(hostData[2], ref other) : 0; request.HostOther = other; request.IsFundraiser = ec.Fundraiser == "Yes"; request.WhoIsPaying = ec.WhoIsPaying; request.FairMarketValue = ec.FairMarketValue; request.RequiresTravel = ec.RequiresTravel == "Yes"; request.InternationalTravel = ec.InternationalTravel == "Yes"; request.AdditionalInformation = ec.AdditionalInformation; request.EventLocation = ec.EventLocation; request.CrowdDescription = ec.EventCrowd; request.ApproximateAttendees = ec.EmployeesTotal; request.IsOpenToMedia = ec.OpenToMedia == "Yes"; request.GuidanceGiven = ec.GuidanceGiven; request.AssignedToUpn = UserInfo.GetUserByName(ec.AssignedTo); if (ec.Closed == "Yes") { if (!string.IsNullOrEmpty(ec.GuidanceGiven)) { // if it's closed and guidance was given, mark as closed approved request.Status = Constants.EventRequestStatus.APPROVED; } else if (ec.ClosedReason.ToLower().Contains("canceled") || ec.ClosedReason.ToLower().Contains("cancelled")) { // if it's closed and a reason was given, mark as closed - other request.Status = Constants.EventRequestStatus.CANCELED; } else if (ec.ClosedReason.ToLower().Contains("withdrew")) { // if it's closed and a reason was given, mark as closed - other request.Status = Constants.EventRequestStatus.WITHDRAWN; } else { request.Status = Constants.EventRequestStatus.CLOSED; } } else if (!string.IsNullOrEmpty(request.AssignedToUpn)) { request.Status = Constants.EventRequestStatus.OPEN; } else { request.Status = Constants.EventRequestStatus.UNASSIGNED; } request.ClosedReason = ec.ClosedReason; request.ClosedDate = ec.ClosedDate; request.ContactNumber = ec.ContactNumber; request.ContactEmail = ec.ContactEmail; request.ContactComponent = ec.ContactComponent; request.EventContactPhone = ec.EventContactPhone; request.AttachmentGuid = ec.OMBEthicsFormId; request.Submitter = ec.Submitter; return(request.Save()); }