DBhelperPostgree 1.0.2

Used For getting Database Function value, Get SQL Query value, Call Database procedures

DataAccess _dataAccess = new DataAccess("Connectionstring");

    //CURRENT DATE Function without Params
    var Date = _dataAccess.getFunctionValue(new DB.Dtos.GetFunctionInput()
    {
        Name = "CURRENT_DATE",
        Parameters = null
    });


    //upper Function with Params
    var Uppervalue = _dataAccess.getFunctionValue(new DB.Dtos.GetFunctionInput()
    {
        Name = "upper",
        Parameters = new System.Collections.Generic.List<DbParams>()
        {
            new DbParams()
            {
                Type = DataType.String,
                value = "dataAccessLib"
            }
        }
    });

    //GetSqlQuery
    var queryResult = _dataAccess.GetSqlQueryValue(new GetQueryInput()
    {
        Query = "SELECT table_name FROM information_schema.tables WHERE table_schema = @PAR1 " +
                    "AND table_type = @PAR2; ",
        Parameters = new System.Collections.Generic.List<DbParams>()
        {
            //@PAR1
            new DbParams()
            {
                Type = DataType.String,
                value = "public"
            },
            //@PAR2
            new DbParams()
            {
                Type = DataType.String,
                value = "BASE TABLE"
            }
        }
    });
	
	//Call Database procedures with params
	_dataAccess.ExecuteProcedure(new GetProcedureInput()
        {
            ProcedureName = "procName",
            Parameters = new System.Collections.Generic.List<DbParams>()
            {
                new DbParams()
                {
                    name = "par1",
                    Type = DataType.String,
                    value = "FromC#"
                },
                new DbParams()
                {
                    name = "par2",
                    Type = DataType.String,
                    value = "FromValue"
                }
            }
        });
		
		//Call Database procedures with no params
	_dataAccess.ExecuteProcedure(new GetProcedureInput()
        {
            ProcedureName = "insertcontrolfile",
            Parameters = null
        });