public ActionResult Create() { var Numsads = db.Numbers.Where(a => a.IsChoosen == true && a.Sales.Count == 0).ToList(); for (int i = 0; i < Numsads.Count; i++) { Numsads[i].IsChoosen = false; } if (Numsads.Count > 0) { db.SaveChanges(); } var Nums = db.Numbers.Where(a => a.IsChoosen != true && a.Sales.Count > 0).ToList(); foreach (var item in Nums) { if (item.Sales.FirstOrDefault().StatusID != 3) { item.IsChoosen = true; } } if (Nums.Count > 0) { db.SaveChanges(); } //for zeros var Numers = db.Numbers.ToList(); foreach (var item in Numers) { string num = item.No; if (num[0] != '0') { item.No = "0" + item.No; } } db.SaveChanges(); NumbersHub.Show(); var Numbers = db.Numbers.Where(a => a.IsChoosen != true && a.IsPrivate != true).ToList(); string userId = User.Identity.GetUserId(); var user = (new ApplicationDbContext()).Users.FirstOrDefault(s => s.Id == userId); var roles = DefualtDB.Roles.Where(a => a.Users.Any(x => x.UserId == userId)).ToList(); if (roles.Count > 0) { ViewBag.UserRole = roles[0].Name; } return(View(Numbers)); }
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) { NumbersHub.Show(); }