/// <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); }