/// <summary>
/// XML Comment
/// </summary>
/// <param name="businessUnit"></param>
/// <param name="configs"></param>
/// <returns></returns>
/// <remarks></remarks>
private Dictionary <string, string> RetrieveCurrentValuesData(System.Collections.Generic.List <ConfigurationItem> configs)
{
DataTable outputDataTable = new DataTable();
TalentDB2Access talentDB2AccessDetail = new TalentDB2Access();
ErrorObj err = new ErrorObj();
try
{
string commandText = "SELECT * FROM CD00A WHERE CONO0A = @CompanyCode";
//Construct The Call
talentDB2AccessDetail.Settings = settings;
talentDB2AccessDetail.CommandElements.CommandExecutionType = CommandExecution.ExecuteDataSet;
talentDB2AccessDetail.CommandElements.CommandText = commandText;
talentDB2AccessDetail.CommandElements.CommandParameter.Clear();
talentDB2AccessDetail.CommandElements.CommandParameter.Add(ConstructDB2Parameter("@CompanyCode", companyCode, 3));
err = talentDB2AccessDetail.DB2Access(DestinationDatabase.TALENTTKT);
if ((!(err.HasError)) && (!(talentDB2AccessDetail.ResultDataSet == null)))
{
outputDataTable = talentDB2AccessDetail.ResultDataSet.Tables[0];
}
}
catch (Exception)
{
}
finally
{
talentDB2AccessDetail = null;
}
return(GetCurrentValues(outputDataTable, configs));
}
public override List <ConfigurationEntity> RetrieveAlliSeriesValues(string companyCode, string[] defaultKeys, string[] variableKeys, string selectedColumns = "")
{
DataTable outputDataTable = new DataTable();
TalentDB2Access talentDB2AccessDetail = new TalentDB2Access();
ErrorObj err = new ErrorObj();
string columns = (selectedColumns != string.Empty ? selectedColumns : "*");
try
{
string commandText = string.Format("SELECT {0} FROM CD00A WHERE CONO0A = @CompanyCode", selectedColumns);
talentDB2AccessDetail.Settings = settings;
talentDB2AccessDetail.CommandElements.CommandExecutionType = CommandExecution.ExecuteDataSet;
talentDB2AccessDetail.CommandElements.CommandText = commandText;
talentDB2AccessDetail.CommandElements.CommandParameter.Clear();
talentDB2AccessDetail.CommandElements.CommandParameter.Add(ConstructDB2Parameter("@CompanyCode", companyCode, 3));
//Execute
err = talentDB2AccessDetail.DB2Access(DestinationDatabase.TALENTTKT);
if ((!(err.HasError)) && (!(talentDB2AccessDetail.ResultDataSet == null)))
{
outputDataTable = talentDB2AccessDetail.ResultDataSet.Tables[0];
}
}
catch (Exception)
{
throw;
}
finally
{
talentDB2AccessDetail = null;
}
return(GetConfigurationData(outputDataTable, defaultKeys, variableKeys));
}
/// <summary>
/// XML Comment
/// </summary>
/// <param name="companyCode"></param>
/// <param name="type51"></param>
/// <returns></returns>
/// <remarks></remarks>
public DataTable SelectByCompAndType(string companyCode, string type51)
{
//how to get company code, type code and active flag
string sqlStatement = string.Empty;
sqlStatement = " SELECT CODE51, DESC51, VALU51 FROM MD501 WHERE CONO51 = @CompanyCode AND TYPE51 = @Type AND ACTR51 = 'A' ";
DataTable outputDataTable = new DataTable();
TalentDB2Access talentDB2AccessDetail = new TalentDB2Access();
try
{
talentDB2AccessDetail.Settings = settings;
talentDB2AccessDetail.CommandElements.CommandExecutionType = CommandExecution.ExecuteDataSet;
talentDB2AccessDetail.CommandElements.CommandParameter.Clear();
talentDB2AccessDetail.CommandElements.CommandParameter.Add(ConstructDB2Parameter("@CompanyCode", companyCode, 3));
talentDB2AccessDetail.CommandElements.CommandParameter.Add(ConstructDB2Parameter("@Type", type51, 4));
ErrorObj err = new ErrorObj();
talentDB2AccessDetail.CommandElements.CommandText = sqlStatement;
err = talentDB2AccessDetail.DB2Access(DestinationDatabase.TALENTTKT);
if ((!(err.HasError)) && (!(talentDB2AccessDetail.ResultDataSet == null)))
{
outputDataTable = talentDB2AccessDetail.ResultDataSet.Tables[0];
}
}
catch (Exception)
{
throw;
}
finally
{
talentDB2AccessDetail = null;
}
return(outputDataTable);
}
public bool DoesDescriptionItemExist(string type, string code)
{
int affectedRows = 0;
TalentDB2Access talentDB2AccessDetail = new TalentDB2Access();
ErrorObj err = new ErrorObj();
string commandText = "SELECT 1 FROM MD501 WHERE CONO51 = @CompanyCode AND TYPE51 = @Type51 AND CODE51 = @Code51 AND ACTR51 = 'A'";
talentDB2AccessDetail.Settings = settings;
talentDB2AccessDetail.CommandElements.CommandExecutionType = CommandExecution.ExecuteDataSet;
talentDB2AccessDetail.CommandElements.CommandText = commandText;
talentDB2AccessDetail.CommandElements.CommandParameter.Clear();
talentDB2AccessDetail.CommandElements.CommandParameter.Add(ConstructDB2Parameter("@Type51", type, 4));
talentDB2AccessDetail.CommandElements.CommandParameter.Add(ConstructDB2Parameter("@Code51", code, 15, iDB2DbType.iDB2Char));
talentDB2AccessDetail.CommandElements.CommandParameter.Add(ConstructDB2Parameter("@CompanyCode", companyCode, 3));
//Execute
err = talentDB2AccessDetail.DB2Access(DestinationDatabase.TALENTTKT);
if ((!(err.HasError)) && (!(talentDB2AccessDetail.ResultDataSet == null)))
{
affectedRows = talentDB2AccessDetail.ResultDataSet.Tables[0].Rows.Count;
}
talentDB2AccessDetail = null;
return(affectedRows > 0 ? false : true);
}
