public string FetchAttendeeId(int registrationId) { string attendeeID = string.Empty; var db = new DataAccess.ClientDataContext(ConfigReader.DefaultProvider.EnvironmentConfiguration.ClientDbConnection); var id = (from i in db.Registrations where i.Register_Id == registrationId select i.Attendee_Id).ToList(); attendeeID = id[0].ToString(); return attendeeID; }
public string FetchConfirmationEmailId(EmailCategory category, int eventId) { int regMailTriggerId = RegMailTriggerIdAttribute.GetRegMailTriggerId(category); string emailId = string.Empty; var db = new DataAccess.ClientDataContext(ConfigReader.DefaultProvider.EnvironmentConfiguration.ClientDbConnection); var id = (from i in db.RegMailResponders where i.EventId == eventId && i.RegMailTypeId == 2 && i.RegMailTriggerId == regMailTriggerId orderby i.Id descending select i.Id).ToList(); emailId = id[0].ToString(); return emailId; }
public string FetchInvitationEmailId(string emailName) { string emailId = string.Empty; var db = new DataAccess.ClientDataContext(ConfigReader.DefaultProvider.EnvironmentConfiguration.ClientDbConnection); var id = (from i in db.EmailJobs where i.CustomerId == Convert.ToInt32(ConfigReader.DefaultProvider.AccountConfiguration.Id) && i.Description == emailName select i.Id).ToList(); emailId = id[0].ToString(); return emailId; }
public void UpdateCustomFieldResponsesForRegistration() { RunTestToGetAPIToken(); if (this.cfResponses == null) { this.GetCustomFieldResponsesForRegistration(); } // There is only one custom field this.cfResponses[0].Response = "False"; ResultsOfBoolean result = this.service.UpdateCustomFieldResponsesForRegistration( header, this.eventId, this.registrationId, this.cfResponses); Assert.IsTrue(result.Success); Assert.IsTrue(result.Data); var db = new DataAccess.ClientDataContext(ConfigReader.DefaultProvider.EnvironmentConfiguration.ClientDbConnection); var response = from cfResponse in db.Custom_Field_Responses where cfResponse.rRegisterId == this.registrationId && cfResponse.EventId == this.eventId && cfResponse.CFId == this.cfId select cfResponse; List<DataAccess.Custom_Field_Response> responseList = response.ToList(); Assert.AreEqual(1, responseList.Count); Assert.AreEqual("False", responseList[0].Response); }
public void LoginRegistrant() { PrepareEventAndRegistrations(); // Get most recent registrant's email address string email = string.Empty; var db = new DataAccess.ClientDataContext(); var registrations = (from r in db.Registrations where r.Event_Id == this.eventId orderby r.Add_Date descending select r).ToList(); email = registrations[0].Attendee.Email_Address; Assert.That(!string.IsNullOrEmpty(email)); // Ensure the registrant can login to the API registrantAPIToken = this.LoginRegistrantToGetAPIToken(email); Assert.That(!string.IsNullOrEmpty(registrantAPIToken)); }
public void UpdateRenewDateAndRunReccuringFeeProcessor(int registrantId) { var db = new DataAccess.ClientDataContext(ConfigReader.DefaultProvider.EnvironmentConfiguration.ClientDbConnection); int rowsAffected; // Set time back to one hour ago so that Recurring Fee Processor can process it string command = string.Format( "UPDATE dbo.recurringFee SET nextPayDate = '{0}', renewDate = '{0}' WHERE registrationID = {1}", DateTime.Now.AddHours(-1).ToString("M/d/yyyy HH:mm:ss.fff"), registrantId); rowsAffected = db.ExecuteCommand(command); // Set registration date to sometime before now to make one time discount code works correctly command = string.Format( "UPDATE dbo.Registrations SET RegistrationDate = '{0}' WHERE Register_Id = {1}", DateTime.Now.AddYears(-1).ToString("M/d/yyyy HH:mm:ss.fff"), registrantId); rowsAffected = db.ExecuteCommand(command); UIUtil.DefaultProvider.OpenUrl( ConfigReader.DefaultProvider.AccountConfiguration.BaseUrlWithHttps + "recurringFeeProcessor.aspx?Token=E4627417-0596-427C-AC92-399F6EF5B826"); UIUtil.DefaultProvider.WaitForPageToLoad(); }
public void TennisAustraliaWebservice() { int newEventId = -1; using (ES.EventServiceSoapClient eventService = new ES.EventServiceSoapClient()) { //eventService.Url = "https://beta.regonline.com/webservices/Events/EventService.asmx"; //eventService. .AuthenticationHeaderValue = GetEventServiceAuthHeader(); int badEventId = 0; int sourceEventId = 625868; int desitinationCustomerId = 377427; DateTime now = DateTime.Now; string clientEventId = "TPTestClientEventID"; string eventTitle = "The Visual Test Event"; string city = "Amsterdam"; string state = "NH"; string country = "Netherlands"; string postalCode = "1111AB"; string redirectConfirmationURL = "http://www.tournamentsoftware.com/link/onlinepaymentreturn.aspx?id={rolid}"; DateTime? startDate = now; DateTime? endDate = now.AddDays(5); string creditCardDescriptor = "Test Descriptor"; ES.EventBasics eventBasics = new ES.EventBasics(); eventBasics.ClientEventID = clientEventId; eventBasics.EventTitle = eventTitle; eventBasics.City = city; eventBasics.State = state; eventBasics.PostalCode = postalCode; eventBasics.Country = country; eventBasics.StartDate = startDate; eventBasics.EndDate = endDate; eventBasics.CreditCardDescriptor = creditCardDescriptor; eventBasics.RedirectConfirmationURL = redirectConfirmationURL; ES.RegOnlineResponseOfInt32 eventResponse = eventService.CreateEventFromTemplate(GetEventServiceAuthHeader(), sourceEventId, desitinationCustomerId, eventBasics); newEventId = eventResponse.Value; Assert.Greater(eventResponse.Value, badEventId); RegOnlineAPIFixture apiFixture = new RegOnlineAPIFixture(); ResultsOfListOfEvent result = apiFixture.FetchEvent(User, Password, newEventId); Assert.IsTrue(result.Success); Assert.AreEqual(eventTitle, result.Data[0].Title); Assert.AreEqual(RegOnline.RegressionTest.Managers.Manager.Dashboard.DashboardManager.EventStatus.Active.ToString(), result.Data[0].Status); using (RegistrationService.RegistrationServiceSoapClient regService = new RegistrationService.RegistrationServiceSoapClient()) { //regService.Url = "https://beta.regonline.com/webservices/Registrations/RegistrationService.asmx"; //regService.AuthenticationHeaderValue = GetRegistrationServiceAuthHeader(); RS.RegOnlineResponseOfInitializeRegistrationSessionResponseType regResponse = regService.InitializeRegistrationSession(GetRegistrationServiceAuthHeader(), newEventId, 10, setupTemplatePersonalInfo()); Assert.That(regResponse.Status.Success); Assert.That(regResponse.Value.SessionId.Length > 0); Assert.That(regResponse.Value.RegistrationId > 0); Assert.That(regResponse.Value.URL.Length > 0); var db = new DataAccess.ClientDataContext(ConfigReader.DefaultProvider.EnvironmentConfiguration.ClientDbConnection); var regs = (from r in db.Registrations where r.Register_Id == regResponse.Value.RegistrationId select r).ToList(); Assert.That(regs[0].Test == false); } //now update the event eventBasics.City = "Sydney"; eventBasics.ID = newEventId; ES.RegOnlineResponseOfBoolean updateResponse = eventService.UpdateEvent(GetEventServiceAuthHeader(), eventBasics); Assert.That(updateResponse.Value); Assert.That(updateResponse.Status.Success); } }
private void VerifyActiveDateInDB() { var db = new DataAccess.ClientDataContext(ConfigReader.DefaultProvider.EnvironmentConfiguration.ClientDbConnection); var activeDate = (from e in db.Events where e.Id == eventID select e.ActiveDate).ToList(); string date = activeDate[0].ToString(); string[] dateAndTime = date.Split(new char[] { ' ' }); VerifyTool.VerifyValue(DateTime.Today.ToString("d"), dateAndTime[0], "Active Date: {0}"); }