protected override void ExecuteInternal(IJobExecutionContext contex) { using (var db = new CC.Data.ccEntities()) { var users = db.MembershipUsers.Include("User").ToList(); foreach (var user in users) { if ((DateTime.Now - (user.LastLoginDate ?? DateTime.Now)).TotalDays > UserDisabledInDays) { var u = db.Users.SingleOrDefault(f => f.Id == user.User.Id); u.Disabled = true; db.SaveChanges(); } } } }
public static void SetString(string name, string value) { using (var db = new CC.Data.ccEntities()) { try { var item = db.GlobalStrings.SingleOrDefault(f => f.Name == name); if (item == null && value != null) { item = new CC.Data.GlobalString { Name = name, Value = value }; db.GlobalStrings.AddObject(item); } else if (item != null && value == null) { db.GlobalStrings.DeleteObject(item); } else if (item != null && value != null) { item.Value = value; } } catch { } try { db.SaveChanges(); if (value == null) { x.Set(name, DBNull.Value, new System.Runtime.Caching.CacheItemPolicy()); } else { x.Set(name, value, new System.Runtime.Caching.CacheItemPolicy()); } } catch (Exception) { throw; } } }