void sqlDep_OnChange(object sender, SqlNotificationEventArgs e)
{
ts = new TacheService();
// test = Int32.Parse(HttpContext.Current.User.Identity.GetUserId());
int currentUserId = 0;
try
{
var userId = System.Web.HttpContext.Current.User.Identity.GetUserId();
currentUserId = Int32.Parse(userId);
if (userId != null)
{
currentUserId = Int32.Parse(userId);
}
}
catch (System.NullReferenceException)
{
// If no user is logged in, leave SESSION_CONTEXT null (all rows will be filtered)
}
Console.WriteLine("l id -sssssssssssssssssssssssssss = ");
if (e.Type == SqlNotificationType.Change)
{
SqlDependency sqlDep = sender as SqlDependency;
sqlDep.OnChange -= sqlDep_OnChange;
//from here we will send notification message to client
var notificationHub = GlobalHost.ConnectionManager.GetHubContext <MyHub>();
// notificationHub.Clients.All.notify("added");
if (ts.Matache(EventManage.Controllers.OrganizerController.test) == true)
{
notificationHub.Clients.All.notify("ok");
}
//re-register notification
RegisterNotification(DateTime.Now);
}
//else
//{
// SqlDependency sqlDep = sender as SqlDependency;
// sqlDep.OnChange -= sqlDep_OnChange;
// //from here we will send notification message to client
// var notificationHub = GlobalHost.ConnectionManager.GetHubContext<MyHub>();
// notificationHub.Clients.All.notify("display");
// //re-register notification
// RegisterNotification(DateTime.Now);
//}
}
public ActionResult IndexTache()
{
test = Int32.Parse(User.Identity.GetUserId());
Os = new OrganizerService();
Ts = new TacheService();
ViewBag.myid = "";
var currentUserId = Int32.Parse(User.Identity.GetUserId());
// ViewBag.myid = currentUserId;
if (Ts.Matache(currentUserId) == true)
{
ViewBag.myid = true;
}
else
{
ViewBag.myid = false;
}
List <TacheModelView> lists = new List <TacheModelView>();
List <Tache> liststache = new List <Tache>();
liststache = Ts.GetAll().Where(x => x.IsDeleted == false).ToList();
foreach (var item in liststache)
{
TacheModelView dvm = new TacheModelView();
dvm.IdTache = item.IdTache;
dvm.Nom = (EventManage.Models.NomTache)item.Nom;
if (item.DescTache.Length > 50)
{
var des = item.DescTache.Substring(0, 23) + " ...";
dvm.DescTache = des;
}
else
{
dvm.DescTache = item.DescTache;
}
dvm.DeadlineTache = item.DeadlineTache;
dvm.EtatdeTache = (EventManage.Models.EtatTache)item.EtatdeTache;
dvm.OrgNom = Os.GetById(item.OragnisateurFk).FirstName;
//dvm.Etat.Equals(item.Etat);
lists.Add(dvm);
}
var orgservice = Os.ListOrganizers();
List <OrganizerModelView> lorg = new List <OrganizerModelView>();
foreach (var item in orgservice)
{
OrganizerModelView org = new OrganizerModelView();
org.Id = item.Id;
org.FirstName = item.FirstName;
org.LastName = item.LastName;
org.Password = item.Password;
org.Email = item.Email;
org.EmailConfirmed = item.EmailConfirmed;
org.PasswordHash = item.PasswordHash;
org.PhoneNumber = item.PhoneNumber;
org.PhoneNumberConfirmed = item.PhoneNumberConfirmed;
org.TwoFactorEnabled = item.TwoFactorEnabled;
org.LockoutEndDateUtc = item.LockoutEndDateUtc;
org.LockoutEnabled = item.LockoutEnabled;
org.AccessFailedCount = item.AccessFailedCount;
org.UserName = item.UserName;
// org.Roles = item.Roles;
org.SecurityStamp = item.SecurityStamp;
lorg.Add(org);
}
// ViewData["Organ"] = new SelectList(lorg, "Id", "FirstName");
ViewData["Organ"] = new SelectList(lorg, "Id", "FirstName");
ViewBag.OrganisateurList = new SelectList(lorg, "Id", "FirstName");
ViewBag.TacheList = lists;
//CustomersEntities entities = new CustomersEntities();
return(View());
}