public TransactionTypesDTO GetTTUsingttnameTTCode(string TTidentifier, string TTName, string PipelineDuns)
{
TransactionTypesDTO itemObj = new TransactionTypesDTO();
var data = (from pt in DbContext.Pipeline_TransactionType_Map
join tt in DbContext.metadataTransactionType on pt.TransactionTypeID equals tt.ID
where pt.PipeDuns == PipelineDuns && pt.IsActive == true && tt.IsActive &&
tt.Name == TTName && tt.Identifier == TTidentifier
select new
{
id = pt.ID,
name = tt.Name,
identifier = tt.Identifier,
sequence = tt.SequenceNo,
isActive = tt.IsActive,
pathType = pt.PathType
}).FirstOrDefault();
if (data != null)
{
itemObj.ID = data.id;
itemObj.Identifier = data.identifier;
itemObj.Name = data.name;
itemObj.SequenceNo = data.sequence;
itemObj.IsActive = data.isActive;
itemObj.PathType = data.pathType;
}
return(itemObj);
}
public List <TransactionTypesDTO> GetTTByMappingPipeline(string pipelineDuns, string pathType)
{
List <TransactionTypesDTO> resultantData = new List <TransactionTypesDTO>();
var data = (from pt in DbContext.Pipeline_TransactionType_Map
join tt in DbContext.metadataTransactionType on pt.TransactionTypeID equals tt.ID
where pt.PipeDuns == pipelineDuns && pt.IsActive == true && (pt.PathType.Trim() == pathType) &&
tt.IsActive
select new
{
id = pt.ID,
name = tt.Name,
identifier = tt.Identifier,
sequence = tt.SequenceNo,
isActive = tt.IsActive,
pathType = pt.PathType
}).ToList();
foreach (var tt in data)
{
TransactionTypesDTO itemObj = new TransactionTypesDTO();
itemObj.ID = tt.id;
itemObj.Identifier = tt.identifier;
itemObj.Name = tt.name;
itemObj.SequenceNo = tt.sequence;
itemObj.IsActive = tt.isActive;
itemObj.PathType = tt.pathType;
resultantData.Add(itemObj);
}
return(resultantData);
}
