public SppCategoryFederalAgencyObject SaveSppCategoryFederalAgency(SppCategoryFederalAgencyObject sppCategoryFederalAgency) { if (sppCategoryFederalAgency.SppCategoryFederalAgencyId > 0) // Update { string sql = @" UPDATE lu_SppCategoryFederalAgency SET FederalAgency = @FederalAgency, Active = @Active WHERE SppCategoryFederalAgencyId = @SppCategoryFederalAgencyId"; Config.Conn.Execute(sql, sppCategoryFederalAgency); } else { string sql = @" INSERT INTO lu_SppCategoryFederalAgency ( FederalAgency, Active ) VALUES ( @FederalAgency, @Active ) SELECT CAST(SCOPE_IDENTITY() AS INT)"; sppCategoryFederalAgency.SppCategoryFederalAgencyId = Config.Conn.Query <int>(sql, sppCategoryFederalAgency).Single(); } return(sppCategoryFederalAgency); }
public bool DeleteSppCategoryFederalAgency(SppCategoryFederalAgencyObject sppCategoryFederalAgency) { try { Config.Conn.Execute("DELETE FROM lu_SppCategoryFederalAgency WHERE SppCategoryFederalAgencyId = @SppCategoryFederalAgencyId", sppCategoryFederalAgency); } catch { return(false); } return(true); }
public static List <SppCategoryFederalAgencyObject> GetSppFundingFederalAgencies(bool enabledOnly = false, int?requiredId = null) { var cache = HttpContext.Current.Cache; List <SppCategoryFederalAgencyObject> data = (List <SppCategoryFederalAgencyObject>)cache[SppFundingFedAgKey]; if (data == null) { data = SppCategoryFederalAgencyObject.GetSppCategoryFederalAgencies(); cache.Insert(SppFundingFedAgKey, data, null, DateTime.Now.AddMinutes(60), Cache.NoSlidingExpiration); } return(data.Where(n => (!enabledOnly || n.Active || (requiredId.HasValue && n.SppCategoryFederalAgencyId == requiredId.Value))).ToList()); }