public static BlockedReferralCollection GetBlockedReferrals(int hostID)
{
CacheManager <string, BlockedReferralCollection> cache = GetBlockedReferralCache();
string key = GetCacheKey(hostID);
if (cache[key] == null)
{
Query blockedReferralQuery = BlockedReferral.CreateQuery().WHERE(BlockedReferral.Columns.HostID, hostID).OR(BlockedReferral.Columns.HostID, Comparison.Is, null);
BlockedReferralCollection blockedReferrals = new BlockedReferralCollection();
blockedReferrals.LoadAndCloseReader(blockedReferralQuery.ExecuteReader());
cache.Insert(key, blockedReferrals, 3600);
}
return(cache[key]);
}
public void Insert(string BlockedReferralHostname,int? HostID)
{
BlockedReferral item = new BlockedReferral();
item.BlockedReferralHostname = BlockedReferralHostname;
item.HostID = HostID;
item.Save(UserName);
}
public void Update(short BlockedReferralID,string BlockedReferralHostname,int? HostID)
{
BlockedReferral item = new BlockedReferral();
item.BlockedReferralID = BlockedReferralID;
item.BlockedReferralHostname = BlockedReferralHostname;
item.HostID = HostID;
item.MarkOld();
item.Save(UserName);
}
