public void Initialize(string agencyId, string roleId, string userId) { // NotifierEntity = NotifierEntity.FromJson(value); var contexts = _connections.GetConnections(Context.User.Identity.Name).Where(x => x.ConnectionId == Context.ConnectionId).ToList(); contexts.ForEach(x => { x.AgencyId = agencyId; x.RoleId = roleId; x.UserId = userId; }); Parallel.ForEach(contexts, (current) => { _connections.Add(Context.User.Identity.Name, current); }); NotifierEntity = new NotifierEntity(); NotifierEntity.SqlConnectionString = ConfigurationManager.ConnectionStrings[FingerprintsData.connection.ConnectionString].ConnectionString; NotifierEntity.SqlQuery = "SELECT [YakkrId],[ClientId],[StaffID],[StaffIDR] from [dbo].[YakkrRouting]"; NotifierEntity.SqlParameters = new List <SqlParameter>(); //if (NotifierEntity == null) // return; Action <String> dispatcher = (t) => { DispatchToClient(); }; PushSqlDependency.Instance(NotifierEntity, dispatcher); }
public void Initialize(string value) { NotifierEntity = NotifierEntity.FromJson(value); if (NotifierEntity == null) { return; } Action <string> dispatcher = (t) => { DispatchToClient(); }; PushSqlDependency.Instance(NotifierEntity, dispatcher); }
public static NotifierEntity GetNotifierEntity <TEntity>(this DbContext dbContext, IQueryable iQueryable) where TEntity : EntityBase { var objectQuery = dbContext.GetObjectQuery <TEntity>(iQueryable); var notifier = new NotifierEntity() { SqlQuery = objectQuery.ToTraceString(), SqlConnectionString = objectQuery.SqlConnectionString(), SqlParameters = objectQuery.SqlParameters() }; return(notifier); }
public void Initialize(String userName) { if (!string.IsNullOrEmpty(userName)) { NotifierEntity = db.GetNotifierEntity <Messages>(db.Messages.Where(x => x.ApplicationUser.UserName == userName && !x.Status)); if (NotifierEntity == null) { return; } Action <String> dispatcher = (t) => { DispatchToClient(); }; PushSqlDependency.Instance(NotifierEntity, dispatcher); } }
public void SetNotificationEntry() { NotifierEntity = new NotifierEntity(); NotifierEntity.SqlConnectionString = ConfigurationManager.ConnectionStrings[FingerprintsData.connection.ConnectionString].ConnectionString; NotifierEntity.SqlQuery = "SELECT [ClientId],[AttendanceDate],[CenterID],[ClassroomId] from [dbo].[ClientAttendance]"; NotifierEntity.SqlParameters = new List <SqlParameter>(); Action <String> dispatcher = (t) => { _executiveDashboardTicker.BroadCastExecutiveDashboardTicker(); }; PushSqlDependency.Instance(NotifierEntity, dispatcher); }
public static NotifierEntity GetNotifierEntityForNomStatus(this DbContext dbContext, IQueryable <DashNominationStatus> iQueryable) { var objectQuery = GetObjectQueryForNom(dbContext, iQueryable); var notifier = new NotifierEntity() { SqlQuery = objectQuery.ToTraceString(), SqlConnectionString = objectQuery.SqlConnectionString(), // SqlParamVal = objectQuery.SqlParameters().FirstOrDefault().Value.ToString(), // SqlParam= objectQuery.SqlParameters().FirstOrDefault().ParameterName, SqlParameters = objectQuery.SqlParameters() }; return(notifier); }
private void SetNotificationEntry() { NotifierEntity = new NotifierEntity(); NotifierEntity.SqlConnectionString = ConfigurationManager.ConnectionStrings[FingerprintsData.connection.ConnectionString].ConnectionString; NotifierEntity.SqlQuery = "SELECT [YakkrId],[ClientId],[StaffID],[StaffIDR] from [dbo].[YakkrRouting]"; NotifierEntity.SqlParameters = new List <SqlParameter>(); Action <String> dispatcher = (t) => { _yakkrTicker.BroadcastYakkrTicker(); }; PushSqlDependency.Instance(NotifierEntity, dispatcher); }