private StringBuilder CreateQuery()

in Source/Actions/Microsoft.Deployment.Actions.Salesforce/ADFDeployPipelines.cs [289:379]
89 lines of code
13 McCabe index (conditional complexity)

        private StringBuilder CreateQuery(Field o, string tableFields, bool oneTimePipeline, string startTime = null, string endTime = null)
        {
            StringBuilder query = new StringBuilder();
            query.Append("\"$$Text.Format('SELECT");
            foreach (var item in o.Item2)
            {
                query.Append(" " + item.name + ",");
            }
            query.Remove(query.Length - 1, 1);

            if (oneTimePipeline)
            {
                if (tableFields.ToLowerInvariant().Contains("createddate"))
                {
                    if (tableFields.ToLowerInvariant().Contains("isdeleted"))
                    {
                        query.Append(" FROM " + o.Item1 + $" WHERE (IsDeleted = FALSE OR IsDeleted = TRUE) AND ((CreatedDate > {startTime} AND CreatedDate <= {endTime}) OR (LastModifiedDate > {startTime} AND LastModifiedDate <= {endTime}))')\"");
                    }
                    else
                    {
                        query.Append(" FROM " + o.Item1 + $" WHERE (CreatedDate > {startTime} AND CreatedDate <= {endTime}) OR (LastModifiedDate > {startTime} AND LastModifiedDate <= {endTime})')\"");
                    }
                }
                else
                {
                    if (tableFields.Contains("isdeleted"))
                    {
                        query.Append(" FROM " + o.Item1 + $" WHERE (IsDeleted = FALSE OR IsDeleted = TRUE) AND (LastModifiedDate > {startTime} AND LastModifiedDate <=  {endTime})')\"");
                    }
                    else
                    {
                        query.Append(" FROM " + o.Item1 + $" WHERE LastModifiedDate > {startTime} AND LastModifiedDate <= {endTime}')\"");
                    }
                }
            }
            else
            {
                if (!tableFields.ToLowerInvariant().Contains("lastmodifieddate"))
                {
                    if (tableFields.ToLowerInvariant().Contains("createddate"))
                    {
                        if (tableFields.ToLowerInvariant().Contains("isdeleted"))
                        {
                            query.Append(" FROM " + o.Item1 + " WHERE (IsDeleted = FALSE OR IsDeleted = TRUE) AND (CreatedDate > {0:yyyy-MM-ddTHH:mm:sssZ} AND CreatedDate <= {1:yyyy-MM-ddTHH:mm:sssZ})', WindowStart,WindowEnd)\"");
                        }
                        else
                        {
                            query.Append(" FROM " + o.Item1 + " WHERE (CreatedDate > {0:yyyy-MM-ddTHH:mm:sssZ} AND CreatedDate <= {1:yyyy-MM-ddTHH:mm:sssZ})', WindowStart,WindowEnd)\"");
                        }
                    }
                    else
                    {
                        if (tableFields.ToLowerInvariant().Contains("isdeleted"))
                        {
                            query.Append(" FROM " + o.Item1 + " WHERE (IsDeleted = FALSE OR IsDeleted = TRUE)', WindowStart,WindowEnd)\"");
                        }
                        else
                        {
                            query.Append(" FROM " + o.Item1 + "')\"");
                        }
                    }
                }
                else
                {
                    if (tableFields.ToLowerInvariant().Contains("createddate"))
                    {
                        if (tableFields.ToLowerInvariant().Contains("isdeleted"))
                        {
                            query.Append(" FROM " + o.Item1 + " WHERE (IsDeleted = FALSE OR IsDeleted = TRUE) AND ((CreatedDate > {0:yyyy-MM-ddTHH:mm:sssZ} AND CreatedDate <= {1:yyyy-MM-ddTHH:mm:sssZ}) OR (LastModifiedDate > {0:yyyy-MM-ddTHH:mm:sssZ} AND LastModifiedDate <= {1:yyyy-MM-ddTHH:mm:sssZ}))', WindowStart,WindowEnd)\"");
                        }
                        else
                        {
                            query.Append(" FROM " + o.Item1 + " WHERE (CreatedDate > {0:yyyy-MM-ddTHH:mm:sssZ} AND CreatedDate <= {1:yyyy-MM-ddTHH:mm:sssZ}) OR (LastModifiedDate > {0:yyyy-MM-ddTHH:mm:sssZ} AND LastModifiedDate <= {1:yyyy-MM-ddTHH:mm:sssZ})', WindowStart,WindowEnd)\"");
                        }
                    }
                    else
                    {
                        if (tableFields.ToLowerInvariant().Contains("isdeleted"))
                        {
                            query.Append(" FROM " + o.Item1 + " WHERE (IsDeleted = FALSE OR IsDeleted = TRUE) AND (LastModifiedDate > {0:yyyy-MM-ddTHH:mm:sssZ} AND LastModifiedDate <= {1:yyyy-MM-ddTHH:mm:sssZ})', WindowStart,WindowEnd)\"");
                        }
                        else
                        {
                            query.Append(" FROM " + o.Item1 + " WHERE LastModifiedDate > {0:yyyy-MM-ddTHH:mm:sssZ} AND LastModifiedDate <= {1:yyyy-MM-ddTHH:mm:sssZ}', WindowStart,WindowEnd)\"");
                        }
                    }
                }
            }

            return query;
        }