public DataTable GetTransformationStrategySteponKey(Tuple <string, string, string> trAssetOReportType) { string filter = string.Format("PortRecon_{0}_{1}_Transformation", trAssetOReportType.Item1.Replace('-', '_'), trAssetOReportType.Item2); if (!trAssetOReportType.Item3.Equals(string.Empty)) { filter = string.Format("PortRecon_{0}_{1}_{2}_Transformation", trAssetOReportType.Item1.Replace('-', '_'), trAssetOReportType.Item2, trAssetOReportType.Item3); } string sqlQuery = string.Format("SELECT [Id],[StepName],[TableViewName],[TransactSQL],MetaData FROM [CMRS_MASTER].[common].[TransformationStrategyStep] where StepName = '{0}'", filter); var obj = AdoDbAccessor.ExecuteQuery(sqlQuery, ConfigurationManager.ConnectionStrings["CMRS_MASTER"].ConnectionString); obj.TableName = "CSVTransformation"; return(obj); }
public List <XformTransformationDetail> GetXformTransformationDetails() { var colmnList = new List <XformTransformationDetail>(); string sqlQuery = string.Format("SELECT [Id] ,[StepName] ,[Description] ,[SourceSliceId] ,[TransformationSliceId] ,[OrderSequence] ,[IsActive] ,[Version] ,[ModifiedBy] ,[ModifiedDateTime] ,[IsFilterEnable] ,[IsOrderEnable] ,[IsMappingEnable] ,[IsCorrelationEnable] ,[IsTargetFilterEnable] FROM [XFormSvc].[dbo].[TransformationStepDetails] WHERE IsActive=1"); var obj = AdoDbAccessor.ExecuteQuery(sqlQuery, ConfigurationManager.ConnectionStrings["Xform_connection_String"].ConnectionString); if (obj == null) { return(null); } colmnList.AddRange(from DataRow rowdata in obj.Rows select new XformTransformationDetail { Id = Int32.Parse(rowdata["Id"].ToString()), StepName = rowdata["StepName"].ToString() }); return(colmnList); }
public List <XformRawSchema> GetXformRawSchemaNames() { var schmList = new List <XformRawSchema>(); string sqlQuery = string.Format("SELECT [Id] ,[DbDetailId],[SchemaName],[SchemaType],[IsSystemGenerated],[HeaderRow],[IgnorableRows],[IgnorableRowsStartingWith],[Version],[ModifiedBy],[ModifiedDateTime],[PackageId],[SsisDbDetailId],[SourceDateFormatId],[SourceDateTimeFormatId],[IsActive],[SchemaTableName],[SchemaDescription] FROM [XFormSvc].[dbo].[SchemaDetail]"); var obj = AdoDbAccessor.ExecuteQuery(sqlQuery, ConfigurationManager.ConnectionStrings["Xform_connection_String"].ConnectionString); if (obj == null) { return(null); } schmList.AddRange(from DataRow rowdata in obj.Rows select new XformRawSchema { Id = Int32.Parse(rowdata["Id"].ToString()), SchemaName = rowdata["SchemaName"].ToString() }); return(schmList); }
public List <SchemaColumnDetail> GetColumnNamesOnSchema(string schemaName) { var colmnList = new List <SchemaColumnDetail>(); string sqlQuery = string.Format("select SCD.*,SD.SchemaName from dbo.SchemaColumnDetail SCD join dbo.SchemaDetail SD on SCD.RawSchemaDetailId = SD.Id where SD.IsActive=1 AND SCD.IsSelected=1 AND SD.SchemaName='{0}'", schemaName); var obj = AdoDbAccessor.ExecuteQuery(sqlQuery, ConfigurationManager.ConnectionStrings["Xform_connection_String"].ConnectionString); if (obj == null) { return(null); } colmnList.AddRange(from DataRow rowdata in obj.Rows select new SchemaColumnDetail { Id = Int32.Parse(rowdata["Id"].ToString()), ColumnDataType = Int32.Parse(rowdata["ColumnDataTypeId"].ToString()), ColumnName = rowdata["ColumnName"].ToString(), RawSchemaDetailId = Int32.Parse(rowdata["RawSchemaDetailId"].ToString()), SchemaName = rowdata["SchemaName"].ToString() }); return(colmnList); }