public DoeFundingCategoryObject SaveDoeFundingCategory(DoeFundingCategoryObject doeFundingCategory) { if (doeFundingCategory.DoeFundingCategoryId > 0) // Update { string sql = @" UPDATE lu_DoeFundingCategory SET Category = @Category, Description = @Description, Active = @Active WHERE DoeFundingCategoryId = @DoeFundingCategoryId"; Config.Conn.Execute(sql, doeFundingCategory); } else { string sql = @" INSERT INTO lu_DoeFundingCategory ( Category, Description, Active ) VALUES ( @Category, @Description, @Active ) SELECT CAST(SCOPE_IDENTITY() AS INT)"; doeFundingCategory.DoeFundingCategoryId = Config.Conn.Query <int>(sql, doeFundingCategory).Single(); } return(doeFundingCategory); }
public bool DeleteDoeFundingCategory(DoeFundingCategoryObject doeFundingCategory) { try { Config.Conn.Execute("DELETE FROM lu_DoeFundingCategory WHERE DoeFundingCategoryId = @DoeFundingCategoryId", doeFundingCategory); } catch { return(false); } return(true); }
public static List <DoeFundingCategoryObject> GetDoeFunding(bool enabledOnly = false, int?requiredId = null) { var cache = HttpContext.Current.Cache; List <DoeFundingCategoryObject> data = (List <DoeFundingCategoryObject>)cache[DoeFundingKey]; if (data == null) { data = DoeFundingCategoryObject.GetDoeFundingCategories(); cache.Insert(DoeFundingKey, data, null, DateTime.Now.AddMinutes(60), Cache.NoSlidingExpiration); } return(data.Where(n => (!enabledOnly || n.Active || (requiredId.HasValue && n.DoeFundingCategoryId == requiredId.Value))).ToList()); }