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
