How to make bar slide into a position I set?

Andrew 0

I don't really know .net framework so I'm asking here

Jiale Xue - MSFT 44,751 Reputation points Microsoft Vendor

2023-09-07T10:30:49.01+00:00

Hi @Andrew , Welcome to Microsoft Q&A,

Can you tell me what you are using? Are you creating a Winforms C# Project? Or other languages and projects?
Andrew 0 Reputation points

2023-09-07T15:10:00.45+00:00

@Jiale Xue - MSFT Hello, im creating a .NET Framework Project,im still trying to make it work
Jiale Xue - MSFT 44,751 Reputation points Microsoft Vendor

2023-09-08T06:19:27.4566667+00:00

Hi @Andrew ,I still don't know what project you created. Just know that you are using .Net Framework. Do you mean this?https://learn.microsoft.com/en-us/dotnet/desktop/winforms/controls/trackbar-control-windows-forms?view=netframeworkdesktop-4.8
Jiale Xue - MSFT 44,751 Reputation points Microsoft Vendor

2023-09-14T09:14:03.7466667+00:00

Hi @Andrew , Is there any update in this issue?

Kesava Subhash Gullapudi 30

 public class WorkflowViewPoco : SearchPoco
 {
     public long? workFlowSeq { get; set; }
     public string? workflowName { get; set; }
     public string? workflowDescription { get; set; }
     public WorkFlowDocumentDTO? workflowDocument { get; set; }
     public bool? isEnabled { get; set; }
     public bool? isDefault { get; set; }
     public DateOnly? startDate { get; set; }
     public DateOnly? endDate { get; set; }
     public long? attribute1 { get; set; }
     public long? attribute2 { get; set; }
     public long? attribute3 { get; set; }
     public long? attribute4 { get; set; }
     public long? attribute5 { get; set; }
     public string? createUser { get; set; }
     public DateTime? createDate { get; set; }
     public string? updateUser { get; set; }
     public DateTime? updateDate { get; set; }
 }
 public class WorkFlowDocumentDTO
 {
     public string? workflowName { get; set; }
     public List<RulesDTO>? rules { get; set; }
     public WorkFlowDocumentDTO()
     {
         rules = new List<RulesDTO>();
     }
 }
 public class RulesDTO
 {
     public string? ruleName { get; set; }
     public string? Operator { get; set; }
     public string? successEvent { get; set; }
     public string? errorMessage { get; set; }
     public string? expression { get; set; }
     public string? actions { get; set; }
     public bool? enabled { get; set; }
     public ExpressionBuilderDTO? expressionBuilder { get; set; }

 }
 public class ExpressionBuilderDTO
 {
     public string? overallOperator { get; set; }
     public string? Operator { get; set; }
     public string? columnName { get; set; }
     public string? value { get; set; }
     public string? aliasTable { get; set; }
     public string? aliasColumn { get; set; }
     public string? expression { get; set; }
 }

I need To retrieve the data by using rule name and work flow name , here work flow document is the JSONB column how i can do that by using linq

public async Task<List<WorkflowViewPoco>> GetWorkflowByWorkflowNameAndRuleName(string workflowName, string ruleName)
{
    var result = new List<WorkflowViewPoco>();

    using(_dataContext)
    {
        var workflow =  _dataContext.WorkflowTable.Where(x=>x.workflowName == workflowName).ToList();
        var workFlowObj = workflow.Where(x => x.workflowDocument.rules.Any(r => r.ruleName == ruleName))
            .Select(w => new WorkflowViewPoco
            {
                workflowName = w.workflowName,
                endDate = w.endDate,
                startDate = w.startDate,
                workflowDescription = w.workflowDescription,
                workFlowSeq = w.workFlowSeq,
                workflowDocument = new WorkFlowDocumentDTO
                {
                    workflowName = w.workflowName,
                    rules = w.workflowDocument.rules.Select(r => new RulesDTO
                    {
                        ruleName = r.ruleName,
                        Operator = r.Operator,
                        successEvent = r.successEvent,
                        errorMessage = r.errorMessage,
                        expression = r.expression,
                        actions = r.actions,
                        enabled = r.enabled,
                        expressionBuilder = new ExpressionBuilderDTO
                        {
                            overallOperator = r.expressionBuilder.overallOperator,
                            Operator = r.expressionBuilder.Operator,
                            columnName = r.expressionBuilder.columnName,
                            value = r.expressionBuilder.value,
                            aliasTable = r.expressionBuilder.aliasTable,
                            aliasColumn = r.expressionBuilder.aliasColumn,
                            expression = r.expressionBuilder.expression
                        }
                        }).ToList()
                    
                }
            }).ToList();
    }
    return  result.ToList();
}

I tried by using Above Snippet upto here the data is retrieved but jsonb Column is not in actual format .., help me out from this issue ....

Share via

How to make bar slide into a position I set?

Your answer