void writeName(string name, eParamType tp) { if (isClosed) { throw new InvalidOperationException("This request is closed, please create another one"); } if (null == name) { throw new ArgumentNullException("name"); } int nameBytesCount = encNames.GetByteCount(name); if (nameBytesCount >= 0x40) { throw new ArgumentException($"Parameter name is too long, they're limited to 63 bytes"); } // For each parameter, the first byte represent the parameter type index in two highest bits ( 6 - 7 ) and the length of the parameter name ( param_name_len ) in the low 6 bits( 0 - 5 ) byte firstByte = (byte)tp; firstByte |= (byte)nameBytesCount; buffer.WriteByte(firstByte); buffer.write(name, nameBytesCount, encNames); parametersCount++; }
public ProtocolParam(int hiByteNum, int loByteNum, string desc, eParamType paramType) { HiByteNumber = hiByteNum; LoByteNumber = loByteNum; Describtion = desc; Value = -1; ParamType = paramType; }
public ProtocolParam(int hiByteNum, int loByteNum, string desc) { HiByteNumber = hiByteNum; LoByteNumber = loByteNum; Describtion = desc; Value = -1; ParamType = eParamType.TypeDecimal; }
public static eParamType GetParamType(int i_iParamType) { eParamType eRet = eParamType.Undefined; switch (i_iParamType) { case (int)eParamType.GeneralPurpose: eRet = eParamType.GeneralPurpose; break; case (int)eParamType.EmailLen: eRet = eParamType.EmailLen; break; case (int)eParamType.EmailAge: eRet = eParamType.EmailAge; break; case (int)eParamType.CalendarAge: eRet = eParamType.CalendarAge; break; case (int)eParamType.Alias: eRet = eParamType.Alias; break; case (int)eParamType.TTSRate: eRet = eParamType.TTSRate; break; case (int)eParamType.AlternateNumber: eRet = eParamType.AlternateNumber; break; case (int)eParamType.DefaultWebpage: eRet = eParamType.DefaultWebpage; break; default: eRet = eParamType.Undefined; break; } return(eRet); }
} // LoadFromTableByUserid public bool LoadFromTableByTypeValue(eParamType i_eType, string i_sValue) { bool bRet = true; try { IDbConnection sqlConn = null; if (RunningSystem.RunningDatabase == Database.MsSql) { if (m_sSqlConn.Length <= 0) { sqlConn = new SqlConnection(ConfigurationManager.AppSettings["SqlConnStr"]); } else { sqlConn = new SqlConnection(m_sSqlConn); } } else if (RunningSystem.RunningDatabase == Database.PostgreSql) { if (m_sSqlConn.Length <= 0) { sqlConn = new NpgsqlConnection(ConfigurationManager.AppSettings["NpgsqlConnStr"]); } else { sqlConn = new NpgsqlConnection(m_sSqlConn); } } using (sqlConn) using (IDbCommand sqlCmd = sqlConn.CreateCommand()) { sqlCmd.CommandText = "SELECT uParamKey, uUserID, sParamName FROM tblUserParams WHERE iParamType = @ParamType AND sParamValue = @ParamValue"; if (RunningSystem.RunningDatabase == Database.MsSql) { sqlCmd.Parameters.Add(new SqlParameter("@ParamType", ((int)i_eType).ToString())); sqlCmd.Parameters.Add(new SqlParameter("@ParamValue", i_sValue)); } else if (RunningSystem.RunningDatabase == Database.PostgreSql) { sqlCmd.Parameters.Add(new NpgsqlParameter("@ParamType", ((int)i_eType).ToString())); sqlCmd.Parameters.Add(new NpgsqlParameter("@ParamValue", i_sValue)); } sqlConn.Open(); using (IDataReader sqlReader = sqlCmd.ExecuteReader()) { while (sqlReader.Read()) { UserPref userprefTmp = new UserPref(); userprefTmp.ParamKey = sqlReader[m_csParamKeyColumn].ToString(); userprefTmp.Userid = sqlReader[m_csUserIDColumn].ToString(); userprefTmp.ParamType = i_eType; userprefTmp.ParamName = sqlReader[m_csParamNameColumn].ToString(); userprefTmp.ParamValue = i_sValue; Add(userprefTmp); } } sqlConn.Close(); } } catch (Exception exc) { Console.Error.WriteLine(String.Format("{0} SBConfigStore.UserPrefs.LoadFromTableByTypeValue exception: {1}", DateTime.Now, exc.ToString())); // FIX - log error string sErr = exc.ToString(); bRet = false; } return(bRet); } // LoadFromTableByTypeValue