private static async Task <List <string> > ProcessHttpRequestMessage(string eventKey) { using (EventsContext eventsContext = _connection.GetSqlContext()) { await eventsContext.Database.EnsureCreatedAsync(); await _registrationsContext.ConfigureConnectionAsync(); Event eventEntry = await eventsContext.Events.SingleOrDefaultAsync(e => e.EventKey == eventKey); List <string> registrants = await _registrationsContext.GetRegistrantsForEvent(eventKey); return(registrants); } }
public void GenerateSignInSheet(int eventId) { using (EventsContext context = new EventsContext()) { var eventItem = context.Events.SingleOrDefault(e => e.Id == eventId); eventItem.SignInDocumentUrl = PROCESSING_URI; context.SaveChanges(); this.Event = eventItem; } this.SignInSheetState = SignInSheetState.SignInDocumentProcessing; }
private void GenerateSignInSheetServiceBus(EventsContext context, Event eventItem, QueueMessage message) { QueueClient client = QueueClient.CreateFromConnectionString(serviceBusConnectionString, signInQueueName); BrokeredMessage queueMessage = new BrokeredMessage(message); client.Send(queueMessage); eventItem.SignInDocumentUrl = PROCESSING_URI; context.SaveChanges(); this.Event = eventItem; this.SignInSheetState = SignInSheetState.SignInDocumentProcessing; }
private static void HandleSignInMessage(QueueMessage message) { using (EventsContext context = new EventsContext()) { Event eventItem = context.Events.SingleOrDefault(e => e.Id == message.EventId); using (MemoryStream stream = _documentGenerator.CreateSignInDocument(eventItem)) { Uri documentUrl = _blobManager.CreateBlob(stream, eventItem.EventKey); eventItem.SignInDocumentUrl = documentUrl.AbsoluteUri; } context.SaveChanges(); } }
private static async Task <MemoryStream> ProcessStorageMessage(string eventKey) { SignInDocumentGenerator documentGenerator = new SignInDocumentGenerator(); using (EventsContext eventsContext = _connection.GetSqlContext()) { await eventsContext.Database.EnsureCreatedAsync(); Event eventEntry = await eventsContext.Events.SingleOrDefaultAsync(e => e.EventKey == eventKey); List <string> registrants = new List <string>(); return(MemoryStream.Null as MemoryStream); } }
public IActionResult Index([FromServices] EventsContext eventsContext, [FromServices] IOptions <ApplicationSettings> appSettings) { var upcomingEvents = eventsContext.Events .Where(e => e.StartTime >= DateTime.Today) .OrderBy(e => e.StartTime) .Take(appSettings.Value.LatestEventCount) .ToList <Event>(); UpcomingEventsViewModel viewModel = new UpcomingEventsViewModel { Events = upcomingEvents }; return(View(viewModel)); }
private void GenerateSignInSheetTableStorage(EventsContext context, Event eventItem, string message) { eventItem.SignInDocumentUrl = PROCESSING_URI; context.SaveChanges(); this.Event = eventItem; this.SignInSheetState = SignInSheetState.SignInDocumentProcessing; CloudStorageAccount account = CloudStorageAccount.Parse(ConfigurationManager.AppSettings["Microsoft.WindowsAzure.Storage.ConnectionString"]); CloudQueueClient client = account.CreateCloudQueueClient(); CloudQueue queue = client.GetQueueReference(signInQueueName); queue.AddMessage(new CloudQueueMessage(message)); }
public EventsGridViewModel(IPAddress server) { IPAddress = server; try { using (EventsContext context = new EventsContext(server)) { this.Events = context.Events.OrderByDescending(e => e.StartTime).ToList(); } } catch (Exception ex) { ErrorMessage = ex.ToString(); } }
public SignInViewModel(string eventKey) { using (EventsContext context = new EventsContext()) { context.SignInDocuments.Add( new SignInDocument { EventKey = eventKey, Generated = false, Document = null } ); context.SaveChanges(); } }
public Contexts() { core = new CoreContext(); events = new EventsContext(); uIListeners = new UIListenersContext(); var postConstructors = System.Linq.Enumerable.Where( GetType().GetMethods(), method => System.Attribute.IsDefined(method, typeof(Entitas.CodeGeneration.Attributes.PostConstructorAttribute)) ); foreach (var postConstructor in postConstructors) { postConstructor.Invoke(this, null); } }
public bool PersistRegistration() { using (EventsContext context = new EventsContext()) { this.Event = context.Events.SingleOrDefault(e => e.EventKey == this.Event.EventKey); this.Registration.Timestamp = DateTime.Now; this.Registration.Event = this.Event; this.Registration = context.EventRegistrants.Add(this.Registration); context.SaveChanges(); return(true); } }
private static void HandleSignInMessage(QueueMessage message) { using (EventsContext context = new EventsContext()) { var eventItem = context.Events.SingleOrDefault(e => e.Id == message.EventId); IEnumerable <string> names = _tableHelper.GetRegistrantNames(eventItem.EventKey); using (MemoryStream stream = _documentGenerator.CreateSignInDocument(eventItem.Title, names)) { Uri documentUrl = _blobHelper.CreateBlob(stream, eventItem.EventKey); eventItem.SignInDocumentUrl = documentUrl.AbsoluteUri; } context.SaveChanges(); } }
public Contexts() { events = new EventsContext(); game = new GameContext(); gameState = new GameStateContext(); input = new InputContext(); simulate = new SimulateContext(); var postConstructors = System.Linq.Enumerable.Where( GetType().GetMethods(), method => System.Attribute.IsDefined(method, typeof(Entitas.CodeGeneration.Attributes.PostConstructorAttribute)) ); foreach (var postConstructor in postConstructors) { postConstructor.Invoke(this, null); } }
public RegisterViewModel(string eventKey) { using (EventsContext context = new EventsContext()) { this.Event = context.Events.SingleOrDefault(e => e.EventKey == eventKey); } string connectionString = ConfigurationManager.AppSettings["Microsoft.WindowsAzure.Storage.ConnectionString"]; var storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse(connectionString); var tableClient = storageAccount.CreateCloudTableClient(); var table = tableClient.GetTableReference("EventRegistrations"); string partitionKey = String.Format("Stub_{0}", this.Event.EventKey); string filter = TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, partitionKey); TableQuery query = new TableQuery().Where(filter); IEnumerable <DynamicTableEntity> tableEntities = table.ExecuteQuery(query); DynamicTableEntity tableEntity = tableEntities.SingleOrDefault(); this.RegistrationStub = DynamicEntity.GenerateDynamicItem(tableEntity); }
private void GenerateSignInSheetTableStorage(EventsContext context, Event eventItem, string message) { CloudStorageAccount storageAccount = CloudStorageAccount.Parse(tableStorageConnectionString); CloudQueueClient queueClient = storageAccount.CreateCloudQueueClient(); CloudQueue queue = queueClient.GetQueueReference(signInQueueName); queue.CreateIfNotExists(); CloudQueueMessage queueMessage = new CloudQueueMessage(message); queue.AddMessage(queueMessage); eventItem.SignInDocumentUrl = PROCESSING_URI; context.SaveChanges(); this.Event = eventItem; this.SignInSheetState = SignInSheetState.SignInDocumentProcessing; }
static void Main(string[] args) { SqlServerTypes.Utilities.LoadNativeAssemblies(AppDomain.CurrentDomain.BaseDirectory); var storageAccount = CloudStorageAccount.DevelopmentStorageAccount; var tableClient = storageAccount.CreateCloudTableClient(); var table = tableClient.GetTableReference("EventRegistrations"); table.DeleteIfExists(); table.CreateIfNotExists(); List <Registration> registrationList = new List <Registration>(); using (EventsContext context = new EventsContext()) { context.Database.Delete(); } using (EventsContext context = new EventsContext()) { context.Events.RemoveRange(context.Events); context.SaveChanges(); for (int i = 0; i < 55; i++) { var result = CreateEvent(context); registrationList.AddRange(result); } } registrationList = registrationList.OrderBy(r => rand.Next()).ToList(); foreach (var registrationGroup in registrationList.GroupBy(r => r.PartitionKey)) { TableBatchOperation operation = new TableBatchOperation(); foreach (var registration in registrationGroup) { operation.Insert(registration); } table.ExecuteBatch(operation); } }
public IActionResult Index([FromServices] EventsContext eventsContext, [FromServices] IOptions <ApplicationSettings> appSettings, int?page) { int currentPage = page ?? 1; int totalRows = eventsContext.Events.Count(); int pageSize = appSettings.Value.GridPageSize; var pagedEvents = eventsContext.Events .OrderByDescending(e => e.StartTime) .Skip(pageSize * (currentPage - 1)) .Take(pageSize); EventsGridViewModel viewModel = new EventsGridViewModel { CurrentPage = currentPage, PageSize = pageSize, TotalRows = totalRows, Events = pagedEvents }; return(View(viewModel)); }
public async Task <IActionResult> Register([FromServices] EventsContext eventsContext, [FromServices] RegistrationContext registrationsContext, [FromForm] IFormCollection form, string key) { dynamic registration = new ExpandoObject(); foreach (var name in form.Keys.Except(new List <string> { "__RequestVerificationToken" })) { (registration as IDictionary <string, object>)[name.Replace("RegistrationStub.", String.Empty)] = form[name].FirstOrDefault(); } string viewModel = await registrationsContext.UploadEventRegistrationAsync(registration); Event eventItem = await eventsContext.Events.SingleOrDefaultAsync(e => e.EventKey == key); eventItem.RegistrationCount++; await eventsContext.SaveChangesAsync(); return(View("Registered", viewModel)); }
static void Main(string[] args) { var storageAccount = CloudStorageAccount.DevelopmentStorageAccount; var tableClient = storageAccount.CreateCloudTableClient(); var table = tableClient.GetTableReference("EventRegistrations"); table.DeleteIfExists(); table.CreateIfNotExists(); List<Registration> registrationList = new List<Registration>(); using (EventsContext context = new EventsContext()) { context.Database.Delete(); } using (EventsContext context = new EventsContext()) { context.Events.RemoveRange(context.Events); context.SaveChanges(); for (int i = 0; i < 55; i++) { var result = CreateEvent(context); registrationList.AddRange(result); } } registrationList = registrationList.OrderBy(r => rand.Next()).ToList(); foreach (var registrationGroup in registrationList.GroupBy(r => r.PartitionKey)) { TableBatchOperation operation = new TableBatchOperation(); foreach (var registration in registrationGroup) { operation.Insert(registration); } table.ExecuteBatch(operation); } }
private void CheckMessages() { using (EventsContext context = new EventsContext()) { var unprocessedMessages = from message in context.SignInDocuments.Include(s => s.Event.Registrations) where !message.Generated select message; var messages = unprocessedMessages.ToList(); if (messages.Any()) { foreach (var message in messages) { HandleMessage(message); context.SaveChanges(); } } } }
static void Main(string[] args) { var storageAccount = CloudStorageAccount.Parse(ConfigurationManager.AppSettings["StorageConnectionString"]); var tableClient = storageAccount.CreateCloudTableClient(); var table = tableClient.GetTableReference("EventRegistrations"); table.CreateIfNotExists(); List <Registration> registrationList = new List <Registration>(); using (EventsContext context = new EventsContext()) { context.Database.Delete(); } using (EventsContext context = new EventsContext()) { context.Events.RemoveRange(context.Events); context.SaveChanges(); for (int i = 0; i < 55; i++) { var result = CreateEvent(context); registrationList.AddRange(result); } } registrationList = registrationList.OrderBy(r => rand.Next()).ToList(); foreach (var registrationGroup in registrationList.GroupBy(r => r.PartitionKey)) { TableBatchOperation operation = new TableBatchOperation(); foreach (var registration in registrationGroup) { operation.Insert(registration); } table.ExecuteBatch(operation); } }
public async Task <IActionResult> Register([FromServices] EventsContext eventsContext, [FromServices] RegistrationContext registrationsContext, string key) { var matchedEvent = await eventsContext.Events.SingleOrDefaultAsync(e => e.EventKey == key); var registrationStub = default(GeneralRegistration); if (matchedEvent.EventRegistrationType == RegistrationType.Internal) { registrationStub = new InternalConferenceRegistration { EventKey = matchedEvent.EventKey }; } else if (matchedEvent.EventRegistrationType == RegistrationType.Sales) { registrationStub = new SalesConferenceRegistration { EventKey = matchedEvent.EventKey }; } else if (matchedEvent.EventRegistrationType == RegistrationType.Technical) { registrationStub = new TechnicalConferenceRegistration { EventKey = matchedEvent.EventKey }; } else { registrationStub = new GeneralRegistration { EventKey = matchedEvent.EventKey }; } RegisterViewModel viewModel = new RegisterViewModel { Event = matchedEvent, RegistrationStub = registrationStub }; return(View(viewModel)); }
private static async Task <MemoryStream> ProcessStorageMessage(string eventKey) { SignInDocumentGenerator documentGenerator = new SignInDocumentGenerator(); using (EventsContext eventsContext = _connection.GetSqlContext()) { await eventsContext.Database.EnsureCreatedAsync(); await _registrationsContext.ConfigureConnectionAsync(); Event eventEntry = await eventsContext.Events.SingleOrDefaultAsync(e => e.EventKey == eventKey); List <string> registrants = await _registrationsContext.GetRegistrantsForEvent(eventKey); MemoryStream stream = documentGenerator.CreateSignInDocument(eventEntry.Title, registrants); stream.Seek(0, SeekOrigin.Begin); eventEntry.SignInDocumentUrl = $"{eventKey}.docx"; await eventsContext.SaveChangesAsync(); return(stream); } }
public SignInSheetViewModel(string eventKey) { this.SignInSheetState = default(SignInSheetState); using (EventsContext context = new EventsContext()) { var eventItem = context.Events.SingleOrDefault(e => e.EventKey == eventKey); this.Event = eventItem; if (this.Event.SignInDocumentUrl == PROCESSING_URI) { this.SignInSheetState = SignInSheetState.SignInDocumentProcessing; } else if (!String.IsNullOrEmpty(this.Event.SignInDocumentUrl)) { this.SignInSheetState = SignInSheetState.SignInDocumentAlreadyExists; } else { GenerateSignInSheetTableStorage(context, eventItem); } } }
public static List <Registration> CreateEvent(EventsContext context) { var latLong = latLongs[rand.Next(0, latLongs.Count)]; var startTime = new DateTime(rand.Next(DateTime.Today.Year + 1, DateTime.Today.Year + 7), rand.Next(1, 13), rand.Next(1, 29), rand.Next(9, 22), rand.Next(0, 60), 0); var eventType = types[rand.Next(0, types.Count)]; var name = String.Format("FY{0:yy} {0:MMMM} {1}", startTime, eventType.Key); var description = descriptions[rand.Next(0, descriptions.Length)]; var registrationCount = (short)rand.Next(0, 55); var eventKey = String.Format("FY{0:yyMMM}{1}", startTime, eventType.Value == typeof(Registration) ? "GeneralConference" : eventType.Value.Name.Replace("Registration", String.Empty)); int previousCount = context.Events.Count(e => e.EventKey.StartsWith(eventKey)); if (previousCount > 0) { eventKey += (previousCount + 1); } var eventResult = context.Events.Add(new Event { EventKey = eventKey, StartTime = startTime, EndTime = startTime.AddDays(3.5d), Title = name, Description = description, RegistrationCount = registrationCount, Latitude = latLong.Key, Longitude = latLong.Value }); context.SaveChanges(); List <Registration> registrationList = new List <Registration>(); if (eventType.Value == typeof(Registration)) { registrationList.Add(new Registration(String.Format("Stub_{0}", eventResult.EventKey)) { IsStub = true }); } else if (eventType.Value == typeof(TechnicalConferenceRegistration)) { registrationList.Add(new TechnicalConferenceRegistration(String.Format("Stub_{0}", eventResult.EventKey)) { IsStub = true }); } else if (eventType.Value == typeof(SalesConferenceRegistration)) { registrationList.Add(new SalesConferenceRegistration(String.Format("Stub_{0}", eventResult.EventKey)) { IsStub = true, Region = String.Empty }); } else if (eventType.Value == typeof(InternalConferenceRegistration)) { registrationList.Add(new InternalConferenceRegistration(String.Format("Stub_{0}", eventResult.EventKey)) { IsStub = true, EmployeeID = String.Empty, Department = String.Empty }); } for (int i = 0; i < registrationCount; i++) { string personName = names.Except(new string[] { name }).ToList()[rand.Next(0, names.Length - 1)]; string firstName = personName.Split(' ')[0]; string lastName = personName.Split(' ')[1]; string region = regions[rand.Next(0, regions.Length)]; string department = departments[rand.Next(0, departments.Length)]; string employeeID = Guid.NewGuid().ToString().Substring(0, 8).ToUpper(); int numberOfKeyFobs = rand.Next(1, 5); int annualSales = rand.Next(15000, 350000); bool onMainCampus = Convert.ToBoolean(rand.Next(0, 2)); if (eventType.Value == typeof(Registration)) { registrationList.Add(new Registration(eventResult.EventKey) { FirstName = firstName, LastName = lastName }); } else if (eventType.Value == typeof(TechnicalConferenceRegistration)) { registrationList.Add(new TechnicalConferenceRegistration(eventResult.EventKey) { FirstName = firstName, LastName = lastName, NumberOfKeyFobs = numberOfKeyFobs }); } else if (eventType.Value == typeof(SalesConferenceRegistration)) { registrationList.Add(new SalesConferenceRegistration(eventResult.EventKey) { FirstName = firstName, LastName = lastName, AnnualSales = annualSales }); } else if (eventType.Value == typeof(InternalConferenceRegistration)) { registrationList.Add(new InternalConferenceRegistration(eventResult.EventKey) { FirstName = firstName, LastName = lastName, EmployeeID = employeeID, Department = department }); } } return(registrationList); }
public static List<Registration> CreateEvent(EventsContext context) { var latLong = latLongs[rand.Next(0, latLongs.Count)]; var location = DbGeography.PointFromText(String.Format("POINT({0} {1})", latLong.Value, latLong.Key), 4326); var startTime = new DateTime(rand.Next(DateTime.Today.Year + 1, DateTime.Today.Year + 7), rand.Next(1, 13), rand.Next(1, 29), rand.Next(9, 22), rand.Next(0, 60), 0); var eventType = types[rand.Next(0, types.Count)]; var name = String.Format("FY{0:yy} {0:MMMM} {1}", startTime, eventType.Key); var description = descriptions[rand.Next(0, descriptions.Length)]; var registrationCount = (short)rand.Next(0, 55); var eventKey = String.Format("FY{0:yyMMM}{1}", startTime, eventType.Value == typeof(Registration) ? "GeneralConference" : eventType.Value.Name.Replace("Registration", String.Empty)); int previousCount = context.Events.Count(e => e.EventKey.StartsWith(eventKey)); if (previousCount > 0) { eventKey += (previousCount + 1); } var eventResult = context.Events.Add(new Event { EventKey = eventKey, StartTime = startTime, EndTime = startTime.AddDays(3.5d), Title = name, Description = description, RegistrationCount = registrationCount, Location = location }); context.SaveChanges(); List<Registration> registrationList = new List<Registration>(); if (eventType.Value == typeof(Registration)) { registrationList.Add(new Registration(String.Format("Stub_{0}", eventResult.EventKey)) { IsStub = true }); } else if (eventType.Value == typeof(TechnicalConferenceRegistration)) { registrationList.Add(new TechnicalConferenceRegistration(String.Format("Stub_{0}", eventResult.EventKey)) { IsStub = true }); } else if (eventType.Value == typeof(SalesConferenceRegistration)) { registrationList.Add(new SalesConferenceRegistration(String.Format("Stub_{0}", eventResult.EventKey)) { IsStub = true, Region = String.Empty }); } else if (eventType.Value == typeof(InternalConferenceRegistration)) { registrationList.Add(new InternalConferenceRegistration(String.Format("Stub_{0}", eventResult.EventKey)) { IsStub = true, EmployeeID = String.Empty, Department = String.Empty }); } for (int i = 0; i < registrationCount; i++) { string personName = names.Except(new string[] { name }).ToList()[rand.Next(0, names.Length - 1)]; string firstName = personName.Split(' ')[0]; string lastName = personName.Split(' ')[1]; string region = regions[rand.Next(0, regions.Length)]; string department = departments[rand.Next(0, departments.Length)]; string employeeID = Guid.NewGuid().ToString().Substring(0, 8).ToUpper(); int numberOfKeyFobs = rand.Next(1, 5); int annualSales = rand.Next(15000, 350000); bool onMainCampus = Convert.ToBoolean(rand.Next(0, 2)); if (eventType.Value == typeof(Registration)) { registrationList.Add(new Registration(eventResult.EventKey) { FirstName = firstName, LastName = lastName }); } else if (eventType.Value == typeof(TechnicalConferenceRegistration)) { registrationList.Add(new TechnicalConferenceRegistration(eventResult.EventKey) { FirstName = firstName, LastName = lastName, NumberOfKeyFobs = numberOfKeyFobs }); } else if (eventType.Value == typeof(SalesConferenceRegistration)) { registrationList.Add(new SalesConferenceRegistration(eventResult.EventKey) { FirstName = firstName, LastName = lastName, AnnualSales = annualSales }); } else if (eventType.Value == typeof(InternalConferenceRegistration)) { registrationList.Add(new InternalConferenceRegistration(eventResult.EventKey) { FirstName = firstName, LastName = lastName, EmployeeID = employeeID, Department = department }); } } return registrationList; }
public MyEventsModel(EventsContext context) { _context = context; }
public EventsRepository() { _db = new EventsContext(); }
public EventsRepository(EventsContext context) { this.context = context; }
public EventsRepository() { context = new EventsContext(); }
public ActivateFeatureSystem(Contexts contexts) : base(contexts.events) { _coreContext = contexts.core; _eventsContext = contexts.events; }
public EventsManagerController(EventsContext context, IStringLocalizer <SharedResource> sharedLocalizer) { EventsContext = context; _sharedLocalizer = sharedLocalizer; }
public EventRepository(EventsContext context) { _context = context; }