Ejemplo n.º 1
0
        /// <summary>
        ///Nombre Metodo: Search_ItemsServicios
        ///Función: Permite Consultar servicios Lucky
        /// </summary>

        public DataTable ObtenerItemServicios(int iCodStrategy, int icompanyid)
        {
            DataTable         dt = oConn.ejecutarDataTable("UP_WEB_SEARCHITEMSSERVICIOS", iCodStrategy, icompanyid);
            EStrategit_Points oeStrategyPoint = new EStrategit_Points();
            EEstrategy        oeEstrategy     = new EEstrategy();


            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i <= dt.Rows.Count - 1; i++)
                    {
                        oeStrategyPoint.idcodPoint       = Convert.ToInt32(dt.Rows[i]["id_cod_Point"].ToString().Trim());
                        oeStrategyPoint.codPoint         = dt.Rows[i]["cod_Point"].ToString().Trim();
                        oeStrategyPoint.DescriptionPoint = dt.Rows[i]["Description_Point"].ToString().Trim();
                        oeEstrategy.codCountry           = dt.Rows[i]["cod_Country"].ToString().Trim();
                        oeStrategyPoint.codStrategy      = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
                        oeStrategyPoint.company_id       = Convert.ToInt32(dt.Rows[i]["company_id"].ToString().Trim());
                        oeStrategyPoint.cod_Channel      = dt.Rows[i]["cod_Channel"].ToString().Trim();
                        oeStrategyPoint.Report_Id        = Convert.ToInt32(dt.Rows[i]["Report_Id"].ToString().Trim());
                        oeStrategyPoint.StatusPoint      = Convert.ToBoolean(dt.Rows[i]["Status_Point"].ToString().Trim());
                        oeStrategyPoint.PointCreateBy    = dt.Rows[i]["Point_CreateBy"].ToString().Trim();
                        oeStrategyPoint.PointDateBy      = dt.Rows[i]["Point_DateBy"].ToString().Trim();
                        oeStrategyPoint.PointModiBy      = dt.Rows[i]["Point_ModiBy"].ToString().Trim();
                        oeStrategyPoint.PointDateModiBy  = dt.Rows[i]["Point_DateModiBy"].ToString().Trim();
                    }
                }
                return(dt);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 2
0
        //Nombre Metodo: SEARCHinfvsserv
        //Función: Permite Consultar informes vs servicios


        public DataTable ObtenerRepVsEs(int icodStrategy, int ReportId)
        {
            DataTable         dt          = oConn.ejecutarDataTable("UP_WEB_SEARCHINFvsSERV", icodStrategy, ReportId);
            EReportsStrategit oeRepvsEs   = new EReportsStrategit();
            EEstrategy        oeEstrategy = new EEstrategy();

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i <= dt.Rows.Count - 1; i++)
                    {
                        oeRepvsEs.ReportSt_id     = Convert.ToInt32(dt.Rows[i]["ReportSt_id"].ToString().Trim());
                        oeRepvsEs.Report_id       = Convert.ToInt32(dt.Rows[i]["Report_id"].ToString().Trim());
                        oeEstrategy.codCountry    = (dt.Rows[i]["cod_Country"].ToString().Trim());
                        oeRepvsEs.cod_Strategy    = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
                        oeRepvsEs.ReportSt_Status = Convert.ToBoolean(dt.Rows[i]["ReportSt_Status"].ToString().Trim());
                    }
                }
                return(dt);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 3
0
        /// <summary>
        ///Nombre Metodo: Search_Servicios
        ///Función: Permite Consultar servicios Lucky
        /// </summary>

        public DataTable ObtenerServicios(string sStrategyName, string scodcountry)
        {
            DataTable  dt          = oConn.ejecutarDataTable("UP_WEB_SEARCHSERVICIOS", sStrategyName, scodcountry);
            EEstrategy oeEstrategy = new EEstrategy();


            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i <= dt.Rows.Count - 1; i++)
                    {
                        oeEstrategy.codStrategy         = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
                        oeEstrategy.StrategyName        = dt.Rows[i]["Strategy_Name"].ToString().Trim();
                        oeEstrategy.StrategyDescription = dt.Rows[i]["Strategy_Description"].ToString().Trim();
                        oeEstrategy.codCountry          = dt.Rows[i]["cod_Country"].ToString().Trim();
                        oeEstrategy.StrategyStatus      = Convert.ToBoolean(dt.Rows[i]["Strategy_Status"].ToString().Trim());
                        oeEstrategy.StrategyCreateBy    = dt.Rows[i]["Strategy_CreateBy"].ToString().Trim();
                        oeEstrategy.StrategyDateBy      = dt.Rows[i]["Strategy_DateBy"].ToString().Trim();
                        oeEstrategy.StrategyModiBy      = dt.Rows[i]["Strategy_ModiBy"].ToString().Trim();
                        oeEstrategy.StrategyDateModiBy  = dt.Rows[i]["Strategy_DateModiBy"].ToString().Trim();
                    }
                }
                return(dt);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 4
0
        //----Metodo que permite Actualizar Servicios Ing. Carlos Alberto Hernandez

        public EEstrategy Actualizar_Servicios(int icodstrategy, string sStrategyName, string sStrategyDescription, string scodCountry, bool sStrategyStatus, string sStrategyModiBy, string sStrategyDateModiBy)
        {
            Lucky.Data.Common.Application.DEstrategy odaservicios = new Lucky.Data.Common.Application.DEstrategy();
            EEstrategy oeaservicios = odaservicios.Actualizar_Servicios(icodstrategy, sStrategyName, sStrategyDescription, scodCountry, sStrategyStatus, sStrategyModiBy, sStrategyDateModiBy);

            odaservicios = null;
            return(oeaservicios);
        }
Ejemplo n.º 5
0
        //----Metodo que permite registrar Servicios

        public EEstrategy RegistrarServicios(string sStrategyName, string sStrategyDescription, string scodCountry, bool sStrategyStatus, string sStrategyCreateBy, string sStrategyDateBy, string sStrategyModiBy, string sStrategyDateModiBy)
        {
            Lucky.Data.Common.Application.DEstrategy odrservicios = new Lucky.Data.Common.Application.DEstrategy();
            EEstrategy oeservicios = odrservicios.RegistrarServiciosPK(sStrategyName, sStrategyDescription, scodCountry, sStrategyStatus, sStrategyCreateBy, sStrategyDateBy, sStrategyModiBy, sStrategyDateModiBy);

            odrservicios = null;
            return(oeservicios);
        }
Ejemplo n.º 6
0
        //---Metodo de Consulta de Servicios

        public DataTable BuscarServicios(string sStrategyName, string scodcountry)
        {
            Lucky.Data.Common.Application.DEstrategy odsestrategias = new Lucky.Data.Common.Application.DEstrategy();
            EEstrategy oeestrategias = new EEstrategy();
            DataTable  dtServicios   = odsestrategias.ObtenerServicios(sStrategyName, scodcountry);

            odsestrategias = null;
            return(dtServicios);
        }
Ejemplo n.º 7
0
        //Método para Actualizar Servicios Ing. Carlos Alberto Hernandez
        public EEstrategy Actualizar_Servicios(int icodstrategy, string sStrategyName, string sStrategyDescription, string scodCountry, bool sStrategyStatus, string sStrategyModiBy, String sStrategyDateModiBy)
        {
            DataTable  dt           = oConn.ejecutarDataTable("UP_WEB_ACTUALIZAR_SERVICIOS", icodstrategy, sStrategyName, sStrategyDescription, scodCountry, sStrategyStatus, sStrategyModiBy, sStrategyDateModiBy);
            EEstrategy oeaServicios = new EEstrategy();

            oeaServicios.codStrategy         = icodstrategy;
            oeaServicios.StrategyName        = sStrategyName;
            oeaServicios.StrategyDescription = sStrategyDescription;
            oeaServicios.codCountry          = scodCountry;
            oeaServicios.StrategyStatus      = Convert.ToBoolean(sStrategyStatus.ToString().Trim());
            oeaServicios.StrategyModiBy      = sStrategyModiBy;
            oeaServicios.StrategyDateModiBy  = sStrategyDateModiBy;
            return(oeaServicios);
        }
Ejemplo n.º 8
0
        //Método para Registrar Servicios
        public EEstrategy RegistrarServiciosPK(string sStrategyName, string sStrategyDescription, string scodCountry, bool sStrategyStatus, string sStrategyCreateBy, string sStrategyDateBy, string sStrategyModiBy, String sStrategyDateModiBy)
        {
            DataTable  dt           = oConn.ejecutarDataTable("UP_WEB_REGISTERSERVICES", sStrategyName, sStrategyDescription, scodCountry, sStrategyStatus, sStrategyCreateBy, sStrategyDateBy, sStrategyModiBy, sStrategyDateModiBy);
            EEstrategy oerServicios = new EEstrategy();

            oerServicios.StrategyName        = sStrategyName;
            oerServicios.StrategyDescription = sStrategyDescription;
            oerServicios.codCountry          = scodCountry;
            oerServicios.StrategyStatus      = Convert.ToBoolean(sStrategyStatus.ToString().Trim());
            oerServicios.StrategyCreateBy    = sStrategyCreateBy;
            oerServicios.StrategyDateBy      = sStrategyDateBy;
            oerServicios.StrategyModiBy      = sStrategyModiBy;
            oerServicios.StrategyDateModiBy  = sStrategyDateModiBy;
            return(oerServicios);
        }
Ejemplo n.º 9
0
        // Metodo para consultar Asignación de informe por usuario de tabla CLIE_Users_Reports
        /// <summary>
        /// Modificación: se modifica consulta se cambia de grilla a consulta normal con cuatro parametros
        /// 12/10/2010 Magaly Jiménez
        /// </summary>
        /// <param name="iCompany_id"></param>
        /// <param name="iPerson_id"></param>
        /// <param name="scod_Channel"></param>
        /// <param name="icod_Strategy"></param>
        /// <returns>dt</returns>
        public DataTable ConsultarAsignciónInfoaUsu(int iCompany_id, int iPerson_id, string scod_Channel, int icod_Strategy)
        {
            DataTable     dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_CONSULTARCLIE_USERS_REPORTS", iCompany_id, iPerson_id, scod_Channel, icod_Strategy);
            EInfoaUsaurio oeCinfoaUsuario = new EInfoaUsaurio();
            ECompany      oeCliente       = new ECompany();
            EUsuario      oeUsuario       = new EUsuario();
            EEstrategy    oeStrategy      = new EEstrategy();
            ECanales      oeCanal         = new ECanales();


            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i <= dt.Rows.Count - 1; i++)
                    {
                        oeCinfoaUsuario.id_userinforme = Convert.ToInt32(dt.Rows[i]["id_userinforme"].ToString().Trim());
                        oeCinfoaUsuario.Person_id      = Convert.ToInt32(dt.Rows[i]["Person_id"].ToString().Trim());
                        //oeUsuario.nameuser = dt.Rows[i]["name_user"].ToString().Trim();
                        oeCinfoaUsuario.cod_Channel    = dt.Rows[i]["cod_Channel"].ToString().Trim();
                        oeCinfoaUsuario.cod_subchannel = dt.Rows[i]["cod_subchannel"].ToString().Trim();
                        oeCinfoaUsuario.cod_Subnivel   = dt.Rows[i]["cod_Subnivel"].ToString().Trim();
                        //oeCanal.ChannelName = dt.Rows[i]["Canal"].ToString().Trim();
                        oeCinfoaUsuario.cod_Strategy = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
                        //oeStrategy.StrategyName = dt.Rows[i]["Strategy_Name"].ToString().Trim();
                        oeCinfoaUsuario.Company_id = Convert.ToInt32(dt.Rows[i]["Company_id"].ToString().Trim());
                        // oeCliente.CompanyName = dt.Rows[i]["Company_Name"].ToString().Trim();
                        oeCinfoaUsuario.userinfo_status     = Convert.ToBoolean(dt.Rows[i]["userinfo_status"].ToString().Trim());
                        oeCinfoaUsuario.userinfo_CreateBy   = dt.Rows[i]["userinfo_CreateBy"].ToString().Trim();
                        oeCinfoaUsuario.userinfo_DateBy     = Convert.ToDateTime(dt.Rows[i]["userinfo_DateBy"].ToString().Trim());
                        oeCinfoaUsuario.userinfo_ModiBy     = dt.Rows[i]["userinfo_ModiBy"].ToString().Trim();
                        oeCinfoaUsuario.userinfo_DateModiBy = Convert.ToDateTime(dt.Rows[i]["userinfo_DateModiBy"].ToString().Trim());
                    }
                }
                return(dt);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 10
0
        public DataTable Menu(string spresupuesto)
        {
            Conexion   oConn      = new Conexion();
            DataTable  dt         = null;
            EEstrategy oesUsuario = new EEstrategy();

            dt = oConn.ejecutarDataTable("UP_WEBSIGE_PLALLENASERVICES", spresupuesto);
            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i <= dt.Rows.Count - 1; i++)
                    {
                        oesUsuario.codStrategy  = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
                        oesUsuario.StrategyName = dt.Rows[i]["Strategy_Name"].ToString().Trim();
                    }
                }
                return(dt);
            }
            else
            {
                return(null);
            }
        }