Exemple #1
0
 public FundingTypeObject SaveFundingType(FundingTypeObject fundingType)
 {
     if (fundingType.FundingTypeId > 0) // Update
     {
         string sql = @"
             UPDATE  lu_FundingType
             SET     FundingType = @FundingType,
                     Description = @Description,
                     Active = @Active
             WHERE   FundingTypeId = @FundingTypeId";
         Config.Conn.Execute(sql, fundingType);
     }
     else
     {
         string sql = @"
             INSERT INTO lu_FundingType (
                 FundingType,
                 Description,
                 Active
             )
             VALUES (
                 @FundingType,
                 @Description,
                 @Active
             )
             SELECT CAST(SCOPE_IDENTITY() AS INT)";
         fundingType.FundingTypeId = Config.Conn.Query <int>(sql, fundingType).Single();
     }
     return(fundingType);
 }
Exemple #2
0
 public bool DeleteFundingType(FundingTypeObject fundingType)
 {
     try
     {
         Config.Conn.Execute("DELETE FROM lu_FundingType WHERE FundingTypeId = @FundingTypeId", fundingType);
     }
     catch { return(false); }
     return(true);
 }
Exemple #3
0
        public static List <FundingTypeObject> GetFundingTypes(bool enabledOnly = false, int?requiredId = null)
        {
            var cache = HttpContext.Current.Cache;
            List <FundingTypeObject> data = (List <FundingTypeObject>)cache[FundingTypeKey];

            if (data == null)
            {
                data = FundingTypeObject.GetFundingTypes();
                cache.Insert(FundingTypeKey, data, null, DateTime.Now.AddMinutes(60), Cache.NoSlidingExpiration);
            }
            return(data.Where(n => (!enabledOnly || n.Active || (requiredId.HasValue && n.FundingTypeId == requiredId.Value))).ToList());
        }