public ConfigurationEntity GetConfigurationEntity(string configId)
{
string commandText = "SELECT * FROM tbl_config_detail WHERE config_id=@CONFIG_ID";
DataTable outputDataTable = new DataTable();
TalentDataAccess talentSqlAccessDetail = new TalentDataAccess();
try
{
//Construct The Call
talentSqlAccessDetail.Settings = settings;
talentSqlAccessDetail.CommandElements.CommandExecutionType = CommandExecution.ExecuteDataSet;
talentSqlAccessDetail.CommandElements.CommandParameter.Add(Utilities.ConstructParameter("@CONFIG_ID", configId));
ErrorObj err = new ErrorObj();
talentSqlAccessDetail.CommandElements.CommandText = commandText;
err = talentSqlAccessDetail.SQLAccess(DestinationDatabase.TALENT_CONFIG);
if ((!(err.HasError)) && (!(talentSqlAccessDetail.ResultDataSet == null)))
{
outputDataTable = talentSqlAccessDetail.ResultDataSet.Tables[0];
}
}
catch (Exception)
{
throw;
}
finally
{
talentSqlAccessDetail = null;
}
if (outputDataTable.Rows.Count > 0)
{
return(ConfigurationEntity.GetEntity(outputDataTable.Rows[0]));
}
return(null);
}
private ConfigurationEntity[] GetConfigurationEntities(DataTable outputDataTable)
{
System.Collections.Generic.List <ConfigurationEntity> list = new System.Collections.Generic.List <ConfigurationEntity>();
foreach (DataRow row in outputDataTable.Rows)
{
ConfigurationEntity entity = ConfigurationEntity.GetEntity(row);
entity.FormattedDisplayName = GetProperCase(entity.DisplayName);
entity.DisplayName = UpperCaseFirst(entity.DisplayName);
list.Add(entity);
}
return(list.ToArray());
}
/// <summary>
/// XML Comment
/// </summary>
/// <param name="masterConfigId"></param>
/// <param name="config"></param>
/// <remarks></remarks>
private void UpdateConfigItem(string masterConfigId, ConfigurationItem config)
{
if (!string.IsNullOrWhiteSpace(settings.VariableKey1))
{
var variableKey1 = settings.VariableKey1;
var dt = RetrieveConfigurationItem(masterConfigId, variableKey1);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
var generatedGuid = guidGenerator.GenerateGUIDString(System.Convert.ToInt32(row["ID"]), ConfigurationEntity.GetEntity(row));
var configID = Utilities.CheckForDBNull_String(row["CONFIG_ID"]);
if (CompareGUIDVaues(masterConfigId, configID))
{
string value = Utilities.CheckForDBNull_String(row["DEFAULT_VALUE"]);
config.DefaultValue = value;
config.CurrentValue = value;
config.UpdatedValue = value;
config.DisplayName = Utilities.CheckForDBNull_String(row["DISPLAY_NAME"]);
config.AllowedValues = GetAllowedValues(row);
config.AllowedPlaceHolders = Utilities.CheckForDBNull_String(row["ALLOWED_PLACE_HOLDER"]);
config.Description = Utilities.CheckForDBNull_String(row["DESCRIPTION"]);
}
else
{
throw (new InvalidConfigurationException("Invalid GUID"));
}
}
}
}
/// <summary>
/// XML Comment
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
/// <remarks></remarks>
private Dictionary <string, ConfigurationItem> GetConfigurationItems(DataTable dt)
{
var results = new Dictionary <string, ConfigurationItem>();
foreach (DataRow row in dt.Rows)
{
try
{
var id = Utilities.CheckForDBNull_String(row["ID"]);
var configID = Utilities.CheckForDBNull_String(row["CONFIG_ID"]);
ConfigurationItem config = new ConfigurationItem();
config.DisplayName = Utilities.CheckForDBNull_String(row["DISPLAY_NAME"]);
config.DefaultName = Utilities.CheckForDBNull_String(row["DEFAULT_NAME"]);
config.TableName = Utilities.CheckForDBNull_String(row["TABLE_NAME"]);
config.DefaultKey1 = Utilities.CheckForDBNull_String(row["DEFAULT_KEY1"]);
config.DefaultKey2 = Utilities.CheckForDBNull_String(row["DEFAULT_KEY2"]);
config.DefaultKey3 = Utilities.CheckForDBNull_String(row["DEFAULT_KEY3"]);
config.DefaultKey4 = Utilities.CheckForDBNull_String(row["DEFAULT_KEY4"]);
config.VariableKey1 = Utilities.CheckForDBNull_String(row["VARIABLE_KEY1"]);
config.VariableKey2 = Utilities.CheckForDBNull_String(row["VARIABLE_KEY2"]);
config.VariableKey3 = Utilities.CheckForDBNull_String(row["VARIABLE_KEY3"]);
config.VariableKey4 = Utilities.CheckForDBNull_String(row["VARIABLE_KEY4"]);
config.AllowedValues = GetAllowedValues(row);
config.AllowedPlaceHolders = Utilities.CheckForDBNull_String(row["ALLOWED_PLACE_HOLDER"]);
config.Description = Utilities.CheckForDBNull_String(row["DESCRIPTION"]);
config.DefaultValue = Utilities.CheckForDBNull_String(row["DEFAULT_VALUE"]);
config.CurrentValue = config.DefaultValue;
config.UpdatedValue = config.DefaultValue;
if (config.VariableKey1 == "*ALL")
{
UpdateConfigItem(configID, config);
}
config.GuidValue = guidGenerator.GenerateGUIDString(System.Convert.ToInt32(id), ConfigurationEntity.GetEntity(row));
var prevConfigId = configID.Substring(0, configID.LastIndexOf("-"));
var newConfigId = config.GuidValue.Substring(0, config.GuidValue.LastIndexOf("-"));
if (prevConfigId == newConfigId)
{
results.Add(configID, config);
}
}
catch (InvalidConfigurationException)
{
//NOTE: Do nothing so it will skip this configuration and proceed with next.
}
}
return(results);
}
