public CoreCapabilitiesObject SaveCoreCapabilities(CoreCapabilitiesObject coreCapabilities) { if (coreCapabilities.CoreCapabilitiesId > 0) // Update { string sql = @" UPDATE lu_CoreCapabilities SET Name = @Name, Active = @Active WHERE CoreCapabilitiesId = @CoreCapabilitiesId"; Config.Conn.Execute(sql, coreCapabilities); } else { string sql = @" INSERT INTO lu_CoreCapabilities ( Name, Active ) VALUES ( @Name, @Active ) SELECT CAST(SCOPE_IDENTITY() AS INT)"; coreCapabilities.CoreCapabilitiesId = Config.Conn.Query <int>(sql, coreCapabilities).Single(); } return(coreCapabilities); }
public static List <CoreCapabilitiesObject> GetCoreCapabilities(bool enabledOnly = false, int?requiredId = null) { var cache = HttpContext.Current.Cache; List <CoreCapabilitiesObject> data = (List <CoreCapabilitiesObject>)cache[CoreCapabilitiesKey]; if (data == null) { data = CoreCapabilitiesObject.GetCoreCapabilitiess(); cache.Insert(CoreCapabilitiesKey, data, null, DateTime.Now.AddMinutes(60), Cache.NoSlidingExpiration); } return(data.Where(n => (!enabledOnly || n.Active || (requiredId.HasValue && n.CoreCapabilitiesId == requiredId.Value))).ToList()); }