Exemple #1
0
        public override clsMsg getData(clsCmd cmd)
        {
            var obj = new NTier.Request.clsGetDataView(_adapter);



            if (this.func.isEmpty() == false)
            {
                NTier.Request.iRequest iCmd = AppDomain.CurrentDomain.CreateInstance(this.assemblyName, this.classPath).Unwrap() as iRequest;
                iCmd.setTier(this._tier);
                object[] objParams = new object[] { cmd };
                var      m         = iCmd.GetType().GetMethod(this.func);
                clsMsg   msg       = (clsMsg)m.Invoke(iCmd, objParams);

                return(msg);
            }
            else
            {
                NTier.Request.iGetData iCmd = AppDomain.CurrentDomain.CreateInstance(this.assemblyName, this.classPath).Unwrap() as iGetData;
                iCmd.setTier(this._tier);
                return(iCmd.getData(cmd));
            }

            return(g.msg("", obj.getData(cmd)));
        }
        public clsMsg upload_bhavdata_row(clsCmd cmd)
        {
            int iDaily_PriceID = 0;

            string sDate1 = "";


            string sSymbol = "";
            string sSeries = "";


            sSymbol = cmd.getStringValue("symbol").Trim();
            sSeries = cmd.getStringValue("series").Trim();

            //DataRow[] rowsStock = getStockMaster().Select(string.Format(" symbol ='{0}' and series = '{1}' ", sSymbol, sSeries));

            NTier.CRUD.clsCRUD oCRUD_DailyPrice = _tier.getCRUD("tmp_bhavdata");


            //  iStockID = g.parseInt(rowsStock[0]["id"]);
            sDate1 = cmd.getStringValue("date1").Trim();
            //    iDaily_PriceID = oBLLStock.getDaily_PriceID(iStockID, sDate1);

            //cmd.setValue("mStockID", iStockID);
            cmd.setValue("id", 0);

            clsMsg msg = oCRUD_DailyPrice.save(cmd);

            return(msg);
        }
Exemple #3
0
        public override clsMsg getFileData(clsCmd cmd)
        {
            NTier.Request.iRequest oReq = _Assembly.createInstance(this.assemblyName, this.classPath) as iRequest;
            oReq.setTier(this._tier);

            object[] objParams = new object[] { cmd };
            var      m         = oReq.GetType().GetMethod(this.func);
            clsMsg   msg       = (clsMsg)m.Invoke(oReq, objParams);

            return(msg);
        }
Exemple #4
0
        private void sendDummyData(string data)
        {
            clsMsg tempMsg = new clsMsg
            {
                CLIENT_IP = clsCommon.Instance.ServerIP,
                Port      = clsCommon.Instance.SERVER_PORT,
                S_DATA    = data
            };

            QueueManager.Instance.SetTransmit(tempMsg);
        }
            public clsMsg getFileData(clsCmd cmd
                                      , iBussinessTier oTier)
            {
                NTier.Request.iRequest oReq = _oAssembly.createInstance(this.AssemblyName, this.classPath) as iRequest;
                oReq.setTier(oTier);

                object[] objParams = new object[] { cmd };
                var      m         = oReq.GetType().GetMethod(this.functionName);
                clsMsg   msg       = (clsMsg)m.Invoke(oReq, objParams);

                return(msg);
            }
Exemple #6
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            var cmd = new clsCmd();

            cmd.setValue("userid", txtUserID.Text);
            cmd.setValue("pwd", txtPwd.Text);
            var msg = _Tier.exec("login", cmd);

            if (msg.Validated)
            {
                result = msg;

                this.Close();
            }
            else
            {
                ui.warn(msg.Message);
            }
        }
        public clsMsg upload_bhavdata_row(clsCmd cmd)
        {
            int    iDaily_PriceID = 0;
            int    iStockID       = 0;
            string sDate1         = "";


            string sSymbol = "";
            string sSeries = "";


            sSymbol = cmd.getStringValue("symbol").Trim();
            sSeries = cmd.getStringValue("series").Trim();

            DataRow[] rowsStock = getStockMaster().Select(string.Format(" symbol ='{0}' and series = '{1}' ", sSymbol, sSeries));

            NTier.CRUD.clsCRUD oCRUD_DailyPrice = _tier.getCRUD("trDaily_Price");

            if (rowsStock.Length > 0)
            {
                iStockID       = g.parseInt(rowsStock[0]["id"]);
                sDate1         = cmd.getStringValue("date1").Trim();
                iDaily_PriceID = oBLLStock.getDaily_PriceID(iStockID, sDate1);

                cmd.setValue("mStockID", iStockID);
                cmd.setValue("id", iDaily_PriceID);

                clsMsg msg = oCRUD_DailyPrice.save(cmd);

                return(msg);
            }
            else
            {
                if (sSeries.ToUpper().Trim() == "EQ")
                {
                    string sMsg = string.Format("Stock Master not found for Series : {0} And Symbol : {1}", sSeries, sSymbol);
                    return(g.msg(sMsg));
                }
            }

            return(g.msg(""));
        }
        /*
         * private clsMsg getRequest_fork(string sRequestPath, clsCmd cmd)
         * {
         *  var oRequestPath = new requestPath(sRequestPath);
         *
         *
         *  var sPath = getPath(oRequestPath.getPath());
         *
         *  if (!System.IO.File.Exists(sPath))
         *      return g.msg("Request path not found !");
         *
         *  ///////////////////////////////////////////////
         *  string sRequestType = "";
         *  iRequest request = null;
         *
         *  var xDoc = getXmlDoc(oRequestPath.getPath());
         *
         *  var xNodeType = xDoc.SelectSingleNode("//request");
         *
         *  var attr = xNodeType.Attributes["type"];
         *  if (attr != null)
         *      sRequestType = attr.Value;
         *
         *  switch (sRequestType)
         *  {
         *      case "getData":
         *          var node = xDoc.SelectSingleNode("//request/dt[@name='" + oRequestPath.getQueryString("name") + "']/view");
         *          //request = getRequest(node);
         *          break;
         *  }
         *
         *  return request.getRequest(cmd);
         * }
         */


        //private iGetData getRequest(XmlNode node)
        //{

        //    var myRequest = new NTier.CRUD.clsReadSimple();
        //    myRequest.viewName = node.InnerText;
        //    return myRequest;
        //}

        public clsMsg getData(string sPath, clsCmd cmd)
        {
            XmlNode xNode = xDoc.SelectSingleNode("//appConfig/requestData[@type='getData']/dt[@name='" + sPath + "']");

            if (xNode.getXmlAttributeValue("type") == "view")
            {
                string sViewName = xNode.getXmlText("view");

                var obj = new NTier.Request.clsGetDataView(_adapter);
                obj.viewName = sViewName;
                obj.OrderBy  = xNode.getXmlText("orderby");

                return(g.msg("", obj.getData(cmd)));
            }
            else if (xNode.getXmlAttributeValue("type") == "other")
            {
                string sAssemblyName = xNode.getXmlAttributeValue("assemblyName");
                string sClassPath    = xNode.getXmlAttributeValue("classPath");
                string sFunc         = xNode.getXmlAttributeValue("func");

                NTier.Request.iGetData iCmd = AppDomain.CurrentDomain.CreateInstance(sAssemblyName, sClassPath).Unwrap() as iGetData;
                iCmd.setTier(this);

                if (!sFunc.isEmpty())
                {
                    object[] objParams = new object[] { cmd };
                    var      m         = iCmd.GetType().GetMethod(sFunc);
                    clsMsg   msg       = (clsMsg)m.Invoke(iCmd, objParams);
                    return(msg);
                }
                else
                {
                    return(iCmd.getData(cmd));
                }
            }

            return(g.msg(""));
        }
Exemple #9
0
 private void frmLogin_Load(object sender, EventArgs e)
 {
     result = g.msg("You are unable to logged in !");
 }
        public clsMsg exec(string sPath, clsCmd cmd)
        {
            XmlNode xNode = xDoc.SelectSingleNode("//appConfig/requestData[@type='cmd']/cmd[@name='" + sPath + "']");

            if (xNode == null)
            {
                throw new Exception("Command path " + sPath + " not found !");
            }

            string sCmdType = xNode.getXmlAttributeValue("type");

            if (sCmdType != "json")
            {
                var msg = validate(xNode, cmd);
                if (msg.Validated == false)
                {
                    return(msg);
                }
            }

            //Validation
            if (xNode != null)
            {
                //Declaration
                //string sCmdType = xNode.getXmlAttributeValue("type");
                string sCRUDName = xNode.getXmlAttributeValue("crudName");

                var oCRUD = getCRUD(sCRUDName);

                if (sCmdType == "save")
                {
                    try
                    {
                        return(oCRUD.save(cmd));
                    }
                    catch (Exception ex)
                    {
                        return(g.msg_exception(ex));
                    }
                }
                else if (sCmdType == "delete")
                {
                    try
                    {
                        oCRUD.delete(cmd);
                        return(g.msg(""));
                    }
                    catch (Exception ex)
                    {
                        return(g.msg_exception(ex));
                    }
                }
                else if (sCmdType == "other")
                {
                    string sAssemblyName = xNode.getXmlAttributeValue("assemblyName");
                    string sClassPath    = xNode.getXmlAttributeValue("classPath");
                    string sFunc         = xNode.getXmlAttributeValue("func");
                    //NTier.Request.iCommand iCmd = AppDomain.CurrentDomain.CreateInstance(sAssemblyName, sClassPath).Unwrap() as iCommand;
                    NTier.Request.iCommand iCmd = oAssembly.createInstance(sAssemblyName, sClassPath) as iCommand;

                    iCmd.setTier(this);

                    if (!sFunc.isEmpty())
                    {
                        object[] objParams = new object[] { cmd };
                        var      m         = iCmd.GetType().GetMethod(sFunc);
                        clsMsg   msg       = (clsMsg)m.Invoke(iCmd, objParams);
                        return(msg);
                    }
                    else
                    {
                        return(iCmd.exec(cmd));
                    }
                }
                else if (sCmdType == "cmd")
                {
                    string q = xNode.getXmlText("sql");
                    cmd.SQL = q;
                    try
                    {
                        _adapter.exec(cmd);
                        return(g.msg(""));
                    }
                    catch (Exception ex)
                    {
                        return(g.msg_exception(ex));
                    }
                }

                else if (sCmdType == "json")
                {
                    DataTable t = Newtonsoft.Json.JsonConvert.DeserializeObject <DataTable>(cmd.getStringValue("data"));

                    //validation start
                    int i = 0;
                    foreach (DataRow r in t.Rows)
                    {
                        i++;
                        var cmd2 = new clsCmd();
                        cmd2.AddValues(r);

                        var msg = validate(xNode, cmd2);
                        if (msg.Validated == false)
                        {
                            msg.Message = string.Format(" Row Number : {0} : {1} ", i, msg.Message);
                            return(msg);
                        }
                    }

                    //updation start

                    i = 0;
                    foreach (DataRow r in t.Rows)
                    {
                        i++;
                        var cmd2 = new clsCmd();
                        cmd2.AddValues(r);

                        string q = xNode.getXmlText("sql");
                        cmd2.SQL = q;

                        try
                        {
                            _adapter.exec(cmd2);
                            return(g.msg(""));
                        }
                        catch (Exception ex)
                        {
                            var msg = g.msg_exception(ex);
                            msg.Message = string.Format(" Row Number : {0} : {1} ", i, msg.Message);
                        }
                    }
                }
            }

            return(g.msg("Path not found !"));
        }