using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Text;
using Newtonsoft.Json.Linq;
using OT.COM.LogisticsUtil;
using OT.COM.SignalerMessage;
using SoldierData;
using OT.COM.ArsenalDB;


namespace CounsellorBL
{
    /*
     // CMD code Template
      public CResponseMessage OOXX(CRequestMessage i_crm)
        {
            CResponseMessage crm = null;
            string sMsg = null;

            try
            {
                do
                {
                    Dictionary<string, object> dicFormData = null;

                    CResponseMessage crmCheckToken = checkTokenWithCRequestMessage(i_crm, out dicFormData);

                    if (EResponseResult.RR_FALSE == crmCheckToken.RESULT)
                    {
                        sMsg = crmCheckToken.MSG;
                        break;
                    }
                }
                while(false);
            }
            catch(Exception ex)
            {
                sMsg = new Util().GetLastExceptionMsg(ex);
            }

            if (null != sMsg)
            {
                crm = new CErrorResponseMessage(sMsg, i_crm);
            }

            return crm;
        }
      
     */

    public partial class BLServiceBase : DBService
    {
  
        /// <summary>
        /// Get Selection option - Get PK/f_s_name as key/value
        /// </summary>
        /// <param name="i_crm"></param>
        /// <returns></returns>
        //public CResponseMessage SelectOptions(CRequestMessage i_crm)
        //{
        //    CResponseMessage crm = null;
        //    string sMsg = null;            

        //    try
        //    {
        //        do
        //        {
        //            string sEntityName = _fetchString(i_crm, BLWording.CMDENTITYTYPE);

        //            if (null == sEntityName)
        //            {
        //                sMsg = "NO MATCHED ENTITY";
        //                break;
        //            }
                    
        //            Dictionary<string, object> dicFormData = null;

        //            CResponseMessage crmCheckToken = checkTokenWithCRequestMessage(i_crm, out dicFormData);

        //            if (EResponseResult.RR_FALSE == crmCheckToken.RESULT)
        //            {
        //                sMsg = crmCheckToken.MSG;
        //                break;
        //            }

        //            //sMsg = oc.GetObjects(string.Format("tb_{0}", sEntityName), out o_olRes);
        //            object oWhere = null;

        //            sMsg = new ClassHelper().GetInstByClassName(sEntityName, out oWhere);
        //            if (null != sMsg)
        //            {
        //                break;
        //            }


        //            //EntityBase ebWhere = oWhere as EntityBase;
        //            Command cSelect = Command.SetupSelectCmd(GetMasterDBTableInfo(oWhere.GetType()), null, null);

        //            QueryDataTable qdt = this.adbm.RunQuery(cSelect);


        //            if (null != sMsg)
        //            {
        //                break;
        //            }

        //            DataTable dt = qdt.DATA;

        //            crm = new CSuccessResponseMessage(null, i_crm);

        //            List<Dictionary<string, object>> ldic = new List<Dictionary<string, object>>();

        //            foreach (DataRow dr in dt.Rows)
        //            {
        //                Dictionary<string, object> dicTemp = new Dictionary<string, object>();

        //                foreach (DataColumn dc in dt.Columns)
        //                {
        //                    if (dr[dc.ColumnName] is DBNull)
        //                    {
        //                        dicTemp.Add(dc.ColumnName, null);
        //                    }
        //                    else
        //                    {
        //                        dicTemp.Add(dc.ColumnName, dr[dc.ColumnName]);
        //                    }

        //                }

        //                ldic.Add(dicTemp);
        //            }

        //            crm.DATA.Add(BLWording.ENTITYS, ldic);

        //        }
        //        while (false);
        //    }
        //    catch (Exception ex)
        //    {
        //        sMsg = new Util().GetLastExceptionMsg(ex);
        //    }

        //    if (null != sMsg)
        //    {
        //        crm = new CResponseMessage(i_crm) { RESULT = EResponseResult.RR_FALSE, MSG = sMsg };
        //    }

        //    return crm;
        //}

        //protected tb_role getRole(string i_sRoleName)
        //{
        //    tb_role rRes = null;

        //    rRes = msdbMaster.RunQuerySingleORM<tb_role>(Command.SetupSelectCmd(null, new tb_role() { f_s_name = i_sRoleName }));

        //    return rRes;
        //}
    }
}