// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
SqlDependency.Start(conn.getDbConnection().ConnectionString);
services.AddControllersWithViews();
// services.AddMvc().AddNewtonsoftJson(opt => opt.SerializerSettings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore);
services.AddDbContext <AppDbContext>(options =>
options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));
services.AddTransient <IMessageRepository, MessageRepository>();
services.AddIdentity <User, IdentityRole>(options => {
options.Password.RequireDigit = false;
options.Password.RequireLowercase = false;
options.Password.RequireNonAlphanumeric = false;
options.Password.RequireUppercase = false;
options.Password.RequiredLength = 6;
})
.AddEntityFrameworkStores <AppDbContext>()
.AddDefaultTokenProviders();
services.AddSignalR();
services.AddControllersWithViews()
.AddNewtonsoftJson(options =>
options.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
);
services.AddDistributedMemoryCache();
services.AddSession(options =>
{
options.Cookie.Name = ".AdventureWorks.Session";
options.IdleTimeout = TimeSpan.FromSeconds(10);
options.Cookie.IsEssential = true;
});
}
public List <Message> GetAllNotifications()
{
notifications = new List <Message>();
SingletonDbConnect conn = SingletonDbConnect.getDbInstance();
using (HomeController.command = new SqlCommand("select Id, Name, ChatId from dbo.Messages where ChatId = 28", conn.getDbConnection()))
{
HomeController.command.Notification = null;
if (HomeController.dependency == null)
{
SqlDependency dependency = new SqlDependency(HomeController.command);
dependency.OnChange += new OnChangeEventHandler(GetAllNotificationsDep_OnChange);
// HomeController.dependency = new SqlDependency(HomeController.command);
// HomeController.dependency.OnChange += new OnChangeEventHandler(GetAllNotificationsDep_OnChange);
}
var reader = HomeController.command.ExecuteReader();
while (reader.Read())
{
var Message = new Message
{
Id = Convert.ToInt32(reader["Id"]),
Name = reader["Name"].ToString(),
ChatId = Convert.ToInt32(reader["ChatId"])
};
notifications.Add(Message);
}
}
return(notifications);
}
