public static void SetSSOEndpointUrl(int customerId, string endpointUrl) { var db = new ClientDataContext(); var config = db.XAuthConfigurations.Single(c => c.CustomerId == customerId); config.SSOServiceEndpointUrl = endpointUrl; db.SubmitChanges(); }
/// <summary> /// Change the transactions of specified registrant to one day ago to settle them /// </summary> /// <param name="registerId"></param> public void ChangeTransactionDateToSettle(int registerId) { ClientDataContext db = new ClientDataContext(); List<Transaction> transactions = (from t in db.Transactions where t.RegisterId == registerId select t).ToList(); foreach (Transaction t in transactions) { if (t.TransDate.HasValue) { t.TransDate = t.TransDate.Value.AddDays(-1); } } db.SubmitChanges(); }
public void SetGroupDiscountPopUpMessage(int eventID, string message) { // If there is no custom pop up message use default message if (message == null) { UIUtil.DefaultProvider.WaitForDisplayAndClick("restore default", LocateBy.LinkText); } else { //S.DiscountRulesService discountRuleService = new S.DiscountRulesService(); //E.TList<E.DiscountRules> discountRules = discountRuleService.GetByEventId(eventID); List<DiscountRule> discountRules = new List<DiscountRule>(); ClientDataContext db = new ClientDataContext(); discountRules = (from d in db.DiscountRules where d.EventId == eventID select d).ToList(); if (discountRules.Count > 0) { foreach (DiscountRule discountRule in discountRules) { if (discountRule.isCurrent) { discountRule.Reg_Description = Convert.ToString(message); db.SubmitChanges(); //discountRuleService.Save(discountRule); break; } } } } }
/// <summary> /// Call database to set message /// </summary> /// <param name="message"></param> public void SetMinimumRegistrantMessageInDatabase(int eventId, string regTypeName, string message) { //S.EventRegTypesService regTypeService = new S.EventRegTypesService(); //E.TList<E.EventRegTypes> regTypes = regTypeService.GetByEventId(eventId); List<EventRegType> regTypes = new List<EventRegType>(); ClientDataContext db = new ClientDataContext(); regTypes = (from rt in db.EventRegTypes where rt.EventId == eventId select rt).ToList(); if (regTypes.Count > 0) { foreach (EventRegType regType in regTypes) { if (regType.Description == regTypeName) { regType.MinRegsMessage = Convert.ToString(message); db.SubmitChanges(); //regTypeService.Save(regType); break; } } } }
public void UndoCheckIn(string connectionString, int RegisterId) { //B.Data.DataProvider.ExecuteNonQuery(connectionString, System.Data.CommandType.Text, "checkOutRegistrant " + RegisterId.ToString()); ClientDataContext db = new ClientDataContext(); Registration reg = (from r in db.Registrations where r.Register_Id == RegisterId select r).Single(); reg.StatusId = 2; db.SubmitChanges(); }
public void SetRegistrationStatus(int RegisterId, int StatusId, Event evt) { ClientDataContext db = new ClientDataContext(); Registration reg = (from r in db.Registrations where r.Event == evt && r.Register_Id == RegisterId select r).Single(); reg.StatusId = StatusId; db.SubmitChanges(); //C.Registration reg = C.Registration.GetByRegistrationIDEventID(RegisterId, evt); //reg.UpdateStatus(RegisterId, (C.RegistrationStatusType)StatusId); }