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;
}
