private static NosDbDependency GetNosDBDependency(NosDBCacheDependency NosDBDep) { NosDbDependency protoNosDB = new NosDbDependency(); protoNosDB.timeout = NosDBDep.Timeout; protoNosDB.connectionString = NosDBDep.ConnectionString; protoNosDB.query = NosDBDep.QueryString; if (NosDBDep.CommandParams != null) { CommandHelper.PopulateValues(NosDBDep.CommandParams, protoNosDB.param); } return(protoNosDB); }
public static ExpirationHint GetExpirationHintObj(Alachisoft.NCache.Common.Protobuf.Dependency dependency, bool resyncOnExpiration, string serializationContext) { AggregateExpirationHint hints = new AggregateExpirationHint(); if (dependency != null && dependency.keyDep != null && dependency.keyDep.Count > 0) { for (int i = 0; i < dependency.keyDep.Count; i++) { Alachisoft.NCache.Caching.AutoExpiration.KeyDependency keyDep = new Alachisoft.NCache.Caching.AutoExpiration.KeyDependency(dependency.keyDep[i].keys.ToArray(), new DateTime(dependency.keyDep[i].startAfter)); hints.Add(keyDep); } } if (dependency != null && dependency.fileDep != null && dependency.fileDep.Count > 0) { for (int i = 0; i < dependency.fileDep.Count; i++) { Alachisoft.NCache.Caching.AutoExpiration.FileDependency fileDep = new Alachisoft.NCache.Caching.AutoExpiration.FileDependency(dependency.fileDep[i].filePaths.ToArray(), new DateTime(dependency.fileDep[i].startAfter)); hints.Add(fileDep); } } if (dependency != null && dependency.oleDbDep != null && dependency.oleDbDep.Count > 0) { for (int i = 0; i < dependency.oleDbDep.Count; i++) { OleDbCacheDependency oleDb = new OleDbCacheDependency(dependency.oleDbDep[i].connectionString, dependency.oleDbDep[i].dbCacheKey); hints.Add(oleDb); } } if (dependency != null && dependency.sql7Dep != null && dependency.sql7Dep.Count > 0) { for (int i = 0; i < dependency.sql7Dep.Count; i++) { Sql7CacheDependency sql7Dep = new Sql7CacheDependency(dependency.sql7Dep[i].connectionString, dependency.sql7Dep[i].dbCacheKey); hints.Add(sql7Dep); } } if (dependency != null && dependency.xtDep != null && dependency.xtDep.Count > 0) { try { for (int i = 0; i < dependency.xtDep.Count; i++) { IFormatter formater = new BinaryFormatter(); byte[] buffer = dependency.xtDep[i].data; object obj = null; using (MemoryStream stream = new MemoryStream(buffer)) { obj = formater.Deserialize(stream); } Alachisoft.NCache.Caching.AutoExpiration.ExtensibleDependency xtDep = new Alachisoft.NCache.Caching.AutoExpiration.ExtensibleDependency( (Runtime.Dependencies.ExtensibleDependency)obj); hints.Add(xtDep); } } catch (SerializationException ex) { throw new OperationFailedException(ex.Message); } } if (dependency != null && dependency.oracleDep != null && dependency.oracleDep.Count > 0) { for (int i = 0; i < dependency.oracleDep.Count; i++) { Hashtable parameters = new Hashtable(); for (int pc = 0; pc < dependency.oracleDep[i].param.Count; pc++) { OracleCommandParams commandParam = new OracleCommandParams((Runtime.Dependencies.OracleCmdParamsType)dependency.oracleDep[i].param[pc].cmdParam.dbType, dependency.oracleDep[i].param[pc].cmdParam.value, (Runtime.Dependencies.OracleParameterDirection)dependency.oracleDep[i].param[pc].cmdParam.direction); parameters.Add(dependency.oracleDep[i].param[pc].key, commandParam); } OracleCacheDependency oraDep = new OracleCacheDependency(dependency.oracleDep[i].connectionString, dependency.oracleDep[i].query, (CommandType)dependency.oracleDep[i].commandType, parameters); hints.Add(oraDep); } } if (dependency != null && dependency.yukonDep != null && dependency.yukonDep.Count > 0) { for (int i = 0; i < dependency.yukonDep.Count; i++) { Hashtable parameters = new Hashtable(); for (int pc = 0; pc < dependency.yukonDep[i].param.Count; pc++) { YukonCommandParam yukonParam = dependency.yukonDep[i].param[pc].cmdParam; SqlCmdParams commandParam = new SqlCmdParams((SqlDbType)yukonParam.dbType, yukonParam.value); commandParam.CmpInfo = (System.Data.SqlTypes.SqlCompareOptions)yukonParam.cmpOptions; commandParam.Direction = (ParameterDirection)yukonParam.direction; commandParam.IsNullable = yukonParam.isNullable; commandParam.LocaleID = yukonParam.localeId; commandParam.Offset = yukonParam.offset; commandParam.Precision = (byte)yukonParam.precision; commandParam.Scale = (byte)yukonParam.scale; commandParam.ParamSize = yukonParam.size; commandParam.SourceColumn = yukonParam.sourceColumn; commandParam.SourceColumnNullMapping = yukonParam.sourceColumnNull; commandParam.SqlValue = yukonParam.sqlValue; commandParam.SrcVersion = (DataRowVersion)yukonParam.version; commandParam.DbType = (SqlDbType)yukonParam.typeId; commandParam.TypeName = yukonParam.typeName; commandParam.UdtName = yukonParam.udtTypeName; if (!yukonParam.nullValueProvided) { string val = yukonParam.value as string; if (val != null) { if (commandParam.DbType == SqlDbType.Binary || commandParam.DbType == SqlDbType.VarBinary || commandParam.DbType == SqlDbType.Image || commandParam.DbType == SqlDbType.Timestamp) { System.Text.UTF8Encoding encoding = new System.Text.UTF8Encoding(); commandParam.Value = encoding.GetBytes(val); } else if (commandParam.DbType == SqlDbType.DateTime || commandParam.DbType == SqlDbType.DateTime2 || commandParam.DbType == SqlDbType.Date || commandParam.DbType == SqlDbType.SmallDateTime) { commandParam.Value = new DateTime(Convert.ToInt64(val)); } else if (commandParam.DbType == SqlDbType.Time) { commandParam.Value = new TimeSpan(Convert.ToInt64(val)); } else if (commandParam.DbType == SqlDbType.DateTimeOffset) { string[] dateOffset = val.Split(new char[] { ',' }); commandParam.Value = new DateTimeOffset(new DateTime(Convert.ToInt64(dateOffset[0])), TimeSpan.FromMinutes(Convert.ToInt32(dateOffset[1]))); } else if (commandParam.DbType == SqlDbType.Money || commandParam.DbType == SqlDbType.SmallMoney || commandParam.DbType == SqlDbType.Decimal) { commandParam.Value = Convert.ToDecimal(val); } else if (commandParam.DbType == SqlDbType.Int) { commandParam.Value = Convert.ToInt32(val); } else if (commandParam.DbType == SqlDbType.BigInt) { commandParam.Value = Convert.ToInt64(val); } else if (commandParam.DbType == SqlDbType.SmallInt) { commandParam.Value = Convert.ToInt16(val); } else if (commandParam.DbType == SqlDbType.Real) { commandParam.Value = Convert.ToSingle(val); } else if (commandParam.DbType == SqlDbType.UniqueIdentifier) { commandParam.Value = System.Data.SqlTypes.SqlGuid.Parse(val); } else if (commandParam.DbType == SqlDbType.TinyInt) { commandParam.Value = Convert.ToByte(val); } else if (commandParam.DbType == SqlDbType.Float) { commandParam.Value = Convert.ToDouble(val); } else if (commandParam.DbType == SqlDbType.Bit) { commandParam.Value = Convert.ToBoolean(val); } else { commandParam.Value = val; } } else { commandParam.Value = DBNull.Value; } } else { commandParam.Value = DBNull.Value; } parameters.Add(dependency.yukonDep[i].param[pc].key, commandParam); } SqlYukonCacheDependency yukonDep = new SqlYukonCacheDependency(dependency.yukonDep[i].connectionString, dependency.yukonDep[i].query, (CommandType)dependency.yukonDep[i].commandType, parameters); hints.Add(yukonDep); } } if (dependency != null && dependency.NosDep != null && dependency.NosDep.Count > 0) { for (int i = 0; i < dependency.NosDep.Count; i++) { Hashtable parameters = new Hashtable(); for (int pc = 0; pc < dependency.NosDep[i].param.Count; pc++) { parameters.Add(dependency.NosDep[i].param[pc].key, dependency.NosDep[i].param[pc].value); } NosDBCacheDependency oraDep = new NosDBCacheDependency(dependency.NosDep[i].connectionString, dependency.NosDep[i].query, dependency.NosDep[i].timeout, parameters); hints.Add(oraDep); } } if (resyncOnExpiration) { hints.SetBit(ExpirationHint.NEEDS_RESYNC); } IList <ExpirationHint> expHints = hints.Hints; if (expHints.Count == 0) { return(null); } if (expHints.Count == 1) { return(expHints[0]); } return(hints); }