private string buildLookupKey(string appName, LookupPropertyType type, string key) { var bldr = new StringBuilder( String.Concat(appName.Length, type.ToString().Length, key.Length + 3)); bldr.Append(appName); bldr.Append("_"); bldr.Append(type.ToString()); bldr.Append("_"); bldr.Append(key); return bldr.ToString(); }
private int getKeyValueFromDatabase(string appName, LookupPropertyType type, string key) { object returnObj = null; var logParams = new SqlParameter[3]; logParams[0] = new SqlParameter("@in_appName", SqlDbType.NVarChar, 150); logParams[0].Direction = ParameterDirection.Input; logParams[0].Value = appName; logParams[1] = new SqlParameter("@in_propertyType", SqlDbType.NVarChar, 50); logParams[1].Direction = ParameterDirection.Input; logParams[1].Value = type.ToString(); logParams[2] = new SqlParameter("@in_key", SqlDbType.NVarChar, 150); logParams[2].Direction = ParameterDirection.Input; logParams[2].Value = key; using (SqlConnection conn = new SqlConnection(utility.getParameter("RfgTrackingDb"))) { conn.Open(); { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Get_Key_Value"; attachParameters(cmd, logParams); returnObj = cmd.ExecuteScalar(); } } } if (returnObj == null) { throw new Exception( String.Format("NameValue Look failed for {0}, {1}, {2}" , appName, type.ToString(), key)); } return Convert.ToInt32(returnObj); }