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