eBiss 3

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Generic select on any DB table  ======

Sample code for:
  * Wago.Ebiss.MapFn.DbSelect(<on the table>, <returned column>, <search on the column>, <search for>)

For the DB connection, the connection string from the variable **Db.MapFunction.Connection** is used by the standard system partner.

Sample call:
  * MyCompanyName.Ebiss.DbSelect("Document", "DocType", "DocNumber", "01-4673848")

Referenced assemblies: eBiss.Api.dll und Pranke.Orm.TypeLib.dll

<code>
using eBiss.Api;
using eBiss.Api.Data;
using Pranke.Orm.Interfaces;
using System;
using System.Collections;

namespace MyCompanyName.Ebiss
{
    public class MapFn : IMapFunctionExtender, ILoggingObject, IApplicationConsumer, ISystemVariableConsumer
    {
        private static string Db_Connection_Variable = "Db.MapFunction.Connection";
        public ILogContext Log { get; set; }
        public IApplication Application { get; set; }
        public IDictionary Variables { get; set; }

        //  Wago.Ebiss.MapFn.DbSelect("Document", "DocType", "DocNumber", "01-4673848")
        [eBiss.Api.MappingFunction]
        public object DbSelect(string table, string colunn, string selectOnColumn, string selectValue)
        {
            string rv = "";
            using (Log.EnterScope($"Execute MapFn.DbSelect on talbe {table}"))
            {
                try
                {
                    Pranke.Orm.Interfaces.IEntities entities = Pranke.Orm.EntitiesBase.Connect(Pranke.Orm.DatabaseType.MsSql, GetDbConnection());

                    IOrmCommand cmd = entities.CreateTextCommand();

                    table = entities.DbAdapter.ReplaceSpecialCharacters(table);
                    colunn = entities.DbAdapter.ReplaceSpecialCharacters(colunn);
                    selectOnColumn = entities.DbAdapter.ReplaceSpecialCharacters(selectOnColumn);
                    selectValue = entities.DbAdapter.ReplaceSpecialCharacters(selectValue);

                    cmd.CommandText = $"SELECT {colunn} FROM {table} WHERE {selectOnColumn} = '{selectValue}' ";
                    Log.Debug("Execute: " + cmd.CommandText);
                    using (IOrmReader ormReader = cmd.ExecuteReader())
                    {
                        while (ormReader.Read())
                        {
                            rv = ormReader.GetString(colunn);
                            break;
                        }
                    }
                }
                catch (Exception ex)
                {
                    Log.Exception(ex);
                    throw;
                }
            }

            return rv;
        }

        private string GetDbConnection()
        {
            if (Variables.Contains(Db_Connection_Variable) && string.IsNullOrWhiteSpace(Variables[Db_Connection_Variable].ToString()) == false)
            {
                return Variables[Db_Connection_Variable].ToString();
            }
            else
            {
                throw new System.ApplicationException($"Missing Variable {Db_Connection_Variable}!");
            }
        }


    }
}

</code>
eBiss 3

User Tools

Site Tools

Page Tools
