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