예제 #1
0
        public ArrayList ListarItems(string vNombreApp, string vNombreSP, string vParametroSalida, string vValueMember, string vDisplayMember)
        {
            DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter(vParametroSalida, DbType.Object, ParameterDirection.Output) };
            Clarify     objClarify           = new Clarify(vNombreApp);
            DAABRequest obRequest            = objClarify.CreaRequest();

            obRequest.CommandType = CommandType.StoredProcedure;
            obRequest.Command     = vNombreSP;
            obRequest.Parameters.AddRange(arrParam);
            ArrayList   lista = new ArrayList();
            IDataReader dr    = null;

            try
            {
                dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader;
                while (dr.Read())
                {
                    ItemGenerico item = new ItemGenerico();
                    item.Codigo      = Funciones.CheckStr(dr[vValueMember]);
                    item.Descripcion = Funciones.CheckStr(dr[vDisplayMember]);
                    lista.Add(item);
                }
            }
            catch (Exception e) { throw e; }
            finally
            {
                if (dr != null)
                {
                    dr.Close();
                }
                obRequest.Factory.Dispose();
            }
            return(lista);
        }
예제 #2
0
        public bool ConsultaValidacionCliente(string tipoDocumento, string nroDocumento, string nroTelefono, ref string flag_valida, ref string msg_text)
        {
            DAABRequest.Parameter[] arrParam =
            {
                new DAABRequest.Parameter("P_PHONE",       DbType.String,  20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_TIPO_DOC",    DbType.String,  20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_NUM_DOC",     DbType.String,  20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FLAG_VALIDA", DbType.String,  20, ParameterDirection.Output),
                new DAABRequest.Parameter("P_MSG_TEXT",    DbType.String, 200, ParameterDirection.Output),
                new DAABRequest.Parameter("REFCURSOR",     DbType.Object, ParameterDirection.Output)
            };
            int  i;
            bool retorno = true;

            for (i = 0; i < arrParam.Length; i++)
            {
                arrParam[i].Value = DBNull.Value;
            }

            i = 0; arrParam[i].Value = nroTelefono;
            ++i; arrParam[i].Value = tipoDocumento;
            ++i; arrParam[i].Value = nroDocumento;

            Clarify     obj       = new Clarify(BaseDatos.BD_CLARIFY);
            DAABRequest obRequest = obj.CreaRequest();

            obRequest.CommandType = CommandType.StoredProcedure;
            obRequest.Command     = BaseDatos.NOMBRE_PACKAGE_CUSTOMER_CLFY + ".SP_VALIDATITULARIDAD";
            obRequest.Parameters.AddRange(arrParam);

            try
            {
                obRequest.Factory.ExecuteNonQuery(ref obRequest);
                obRequest.Factory.CommitTransaction();
            }
            catch (Exception e)
            {
                flag_valida = "";
                msg_text    = "Error Conexion a BD Clarify: " + e.Message;
                retorno     = false;
            }
            finally
            {
                IDataParameter parSalida1, parSalida2;
                parSalida1  = (IDataParameter)obRequest.Parameters[3];
                parSalida2  = (IDataParameter)obRequest.Parameters[4];
                flag_valida = Funciones.CheckStr(parSalida1.Value);
                msg_text    = Funciones.CheckStr(parSalida2.Value);
                obRequest.Factory.Dispose();
            }
            return(retorno);
        }
예제 #3
0
        public Cliente ObtenerCliente(string vPHONE, string vACCOUNT, string vCONTACTOBJID_1, string vFLAG_REG, ref string vFLAG_CONSULTA, ref string vMSG_TEXT)
        {
            if (vCONTACTOBJID_1 == "")
            {
                vCONTACTOBJID_1 = null;
            }
            DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_PHONE",          DbType.String,              20, vPHONE,                    ParameterDirection.Input),
                                                 new DAABRequest.Parameter("P_ACCOUNT",        DbType.String,              80, vACCOUNT,                  ParameterDirection.Input),
                                                 new DAABRequest.Parameter("P_CONTACTOBJID_1", DbType.Int64,  vCONTACTOBJID_1, ParameterDirection.Input),
                                                 new DAABRequest.Parameter("P_FLAG_REG",       DbType.String,              20, vFLAG_REG,                 ParameterDirection.Input),
                                                 new DAABRequest.Parameter("P_FLAG_CONSULTA",  DbType.String,             255, vFLAG_CONSULTA,            ParameterDirection.Output),
                                                 new DAABRequest.Parameter("P_MSG_TEXT",       DbType.String,             255, vMSG_TEXT,                 ParameterDirection.Output),
                                                 new DAABRequest.Parameter("CUSTOMER",         DbType.Object, ParameterDirection.Output) };


            Clarify     objClarify = new Clarify(BaseDatos.BD_CLARIFY);
            DAABRequest obRequest  = objClarify.CreaRequest();

            obRequest.CommandType = CommandType.StoredProcedure;
            obRequest.Command     = BaseDatos.NOMBRE_PACKAGE_CUSTOMER_CLFY + ".SP_CUSTOMER_CLFY";
            string[] sTab = { "Resultado" };
            obRequest.TableNames = sTab;
            obRequest.Parameters.AddRange(arrParam);
            Cliente   item = new Cliente();
            DataTable dt   = new DataTable();

            try
            {
                dt = obRequest.Factory.ExecuteDataset(ref obRequest).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    item = MapearTablaToCliente(dt.Rows[0]);
                }
            }
            catch (Exception e) { throw e; }
            finally
            {
                obRequest.Factory.Dispose();
            }
            return(item);
        }
예제 #4
0
        public bool InsertarPlantillaInteraccion(PlantillaInteraccion item, string vInteraccionId, ref string rFlagInsercion, ref string rMsgText)
        {
            DAABRequest.Parameter[] arrParam =
            {
                new DAABRequest.Parameter("P_NRO_INTERACCION",     DbType.String,                        255, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_1",             DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_2",             DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_3",             DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_4",             DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_5",             DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_6",             DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_7",             DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_8",             DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_9",             DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_10",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_11",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_12",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_13",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_14",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_15",            DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_16",            DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_17",            DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_18",            DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_19",            DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_20",            DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_21",            DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_22",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_23",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_24",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_25",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_26",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_27",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_28",            DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_29",            DbType.String,                        255, ParameterDirection.Input),
                new DAABRequest.Parameter("P_INTER_30",            DbType.String,                       1000, ParameterDirection.Input),
                new DAABRequest.Parameter("P_PLUS_INTER2INTERACT", DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_ADJUSTMENT_AMOUNT",   DbType.Double,  ParameterDirection.Input),
                new DAABRequest.Parameter("P_ADJUSTMENT_REASON",   DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_ADDRESS",             DbType.String,                        100, ParameterDirection.Input),
                new DAABRequest.Parameter("P_AMOUNT_UNIT",         DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_BIRTHDAY",            DbType.Date,    ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLARIFY_INTERACTION", DbType.String,                         15, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLARO_LDN1",          DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLARO_LDN2",          DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLARO_LDN3",          DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLARO_LDN4",          DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLAROLOCAL1",         DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLAROLOCAL2",         DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLAROLOCAL3",         DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLAROLOCAL4",         DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLAROLOCAL5",         DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLAROLOCAL6",         DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CONTACT_PHONE",       DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_DNI_LEGAL_REP",       DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_DOCUMENT_NUMBER",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_EMAIL",               DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FIRST_NAME",          DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FIXED_NUMBER",        DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FLAG_CHANGE_USER",    DbType.String,                          1, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FLAG_LEGAL_REP",      DbType.String,                          1, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FLAG_OTHER",          DbType.String,                          1, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FLAG_TITULAR",        DbType.String,                          1, ParameterDirection.Input),
                new DAABRequest.Parameter("P_IMEI",                DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_LAST_NAME",           DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_LASTNAME_REP",        DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_LDI_NUMBER",          DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_NAME_LEGAL_REP",      DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLARO_LDN1",      DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLARO_LDN2",      DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLARO_LDN3",      DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLARO_LDN4",      DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLAROLOCAL1",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLAROLOCAL2",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLAROLOCAL3",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLAROLOCAL4",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLAROLOCAL5",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_CLAROLOCAL6",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_DOC_NUMBER",      DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_FIRST_NAME",      DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_FIXED_PHONE",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_LAST_NAME",       DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_LDI_NUMBER",      DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OLD_FIXED_NUMBER",    DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OPERATION_TYPE",      DbType.String,                         50, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OTHER_DOC_NUMBER",    DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OTHER_FIRST_NAME",    DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OTHER_LAST_NAME",     DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OTHER_PHONE",         DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_PHONE_LEGAL_REP",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_REFERENCE_PHONE",     DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_REASON",              DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_MODEL",               DbType.String,                         50, ParameterDirection.Input),
                new DAABRequest.Parameter("P_LOT_CODE",            DbType.String,                         50, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FLAG_REGISTERED",     DbType.String,                          1, ParameterDirection.Input),
                new DAABRequest.Parameter("P_REGISTRATION_REASON", DbType.String,                         80, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLARO_NUMBER",        DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_MONTH",               DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OST_NUMBER",          DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_BASKET",              DbType.String,                         50, ParameterDirection.Input),
                new DAABRequest.Parameter("P_EXPIRE_DATE",         DbType.Date,    ParameterDirection.Input),
                new DAABRequest.Parameter("P_ADDRESS5",            DbType.String,                        200, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CHARGE_AMOUNT",       DbType.Decimal, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CITY",                DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_CONTACT_SEX",         DbType.String,                          1, ParameterDirection.Input),
                new DAABRequest.Parameter("P_DEPARTMENT",          DbType.String,                         40, ParameterDirection.Input),
                new DAABRequest.Parameter("P_DISTRICT",            DbType.String,                        200, ParameterDirection.Input),
                new DAABRequest.Parameter("P_EMAIL_CONFIRMATION",  DbType.String,                          1, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FAX",                 DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_FLAG_CHARGE",         DbType.String,                          1, ParameterDirection.Input),
                new DAABRequest.Parameter("P_MARITAL_STATUS",      DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_OCCUPATION",          DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_POSITION",            DbType.String,                         30, ParameterDirection.Input),
                new DAABRequest.Parameter("P_REFERENCE_ADDRESS",   DbType.String,                         50, ParameterDirection.Input),
                new DAABRequest.Parameter("P_TYPE_DOCUMENT",       DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_ZIPCODE",             DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("P_ICCID",               DbType.String,                         20, ParameterDirection.Input),
                new DAABRequest.Parameter("ID_INTERACCION",        DbType.String,                        255, ParameterDirection.Output),
                new DAABRequest.Parameter("FLAG_CREACION",         DbType.String,                        255, ParameterDirection.Output),
                new DAABRequest.Parameter("MSG_TEXT",              DbType.String,                        255, ParameterDirection.Output)
            };
            for (int j = 0; j < arrParam.Length; j++)
            {
                arrParam[j].Value = System.DBNull.Value;
            }

            int      i          = 0;
            DateTime dateInicio = new DateTime(1, 1, 1);


            if (vInteraccionId != null)
            {
                arrParam[i].Value          = vInteraccionId;       // P_NRO_INTERACCION
                item.X_PLUS_INTER2INTERACT = Funciones.CheckDbl(vInteraccionId);
            }

            i++;
            if (item.X_INTER_1 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_1);                // P_INTER_1
            }
            i++;
            if (item.X_INTER_2 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_2);                // P_INTER_2
            }
            i++;
            if (item.X_INTER_3 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_3);                // P_INTER_3
            }
            i++;
            if (item.X_INTER_4 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_4);                // P_INTER_4
            }
            i++;
            if (item.X_INTER_5 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_5);                // P_INTER_5
            }
            i++;
            if (item.X_INTER_6 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_6);                // P_INTER_6
            }
            i++;
            if (item.X_INTER_7 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_7);                // P_INTER_7
            }
            i++;
            //if ( item.X_INTER_8 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_8);            // P_INTER_8

            i++;
            //if ( item.X_INTER_9 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_9);            // P_INTER_9

            i++;
            //if ( item.X_INTER_10 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_10);            // P_INTER_10

            i++;
            //if ( item.X_INTER_11 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_11);            // P_INTER_11

            i++;
            //if ( item.X_INTER_12 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_12);            // P_INTER_12

            i++;
            //if ( item.X_INTER_13 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_13);            // P_INTER_13

            i++;
            //if ( item.X_INTER_14 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_14);            // P_INTER_14

            i++;
            if (item.X_INTER_15 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_15);                // P_INTER_15
            }
            i++;
            if (item.X_INTER_16 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_16);                // P_INTER_16
            }
            i++;
            if (item.X_INTER_17 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_17);                // P_INTER_17
            }
            i++;
            if (item.X_INTER_18 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_18);                // P_INTER_18
            }
            i++;
            if (item.X_INTER_19 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_19);                // P_INTER_19
            }
            i++;
            if (item.X_INTER_20 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_20);                // P_INTER_20
            }
            i++;
            if (item.X_INTER_21 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_21);                // P_INTER_21
            }
            i++;
            //if ( item.X_INTER_22 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_22);            // P_INTER_22

            i++;
            //if ( item.X_INTER_23 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_23);            // P_INTER_23

            i++;
            //if ( item.X_INTER_24 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_24);            // P_INTER_24

            i++;
            //if ( item.X_INTER_25 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_25);            // P_INTER_25

            i++;
            //if ( item.X_INTER_26 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_26);            // P_INTER_26

            i++;
            //if ( item.X_INTER_27 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_27);            // P_INTER_27

            i++;
            //if ( item.X_INTER_28 != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_INTER_28);            // P_INTER_28

            i++;
            if (item.X_INTER_29 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_29);                // P_INTER_29
            }
            i++;
            if (item.X_INTER_30 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_INTER_30);                // P_INTER_30
            }
            i++;
            //if ( item.X_PLUS_INTER2INTERACT != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_PLUS_INTER2INTERACT);            // P_PLUS_INTER2INTERACT

            i++;
            //if ( item.X_ADJUSTMENT_AMOUNT != null )
            arrParam[i].Value = Funciones.CheckDbl(item.X_ADJUSTMENT_AMOUNT);            // P_ADJUSTMENT_AMOUNT

            i++;
            if (item.X_ADJUSTMENT_REASON != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_ADJUSTMENT_REASON);                // P_ADJUSTMENT_REASON
            }
            i++;
            if (item.X_ADDRESS != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_ADDRESS);                // P_ADDRESS
            }
            i++;
            if (item.X_AMOUNT_UNIT != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_AMOUNT_UNIT);                // P_AMOUNT_UNIT
            }
            i++;
            if (item.X_BIRTHDAY != dateInicio)
            {
                arrParam[i].Value = Funciones.CheckDate(item.X_BIRTHDAY);                // P_BIRTHDAY
            }
            i++;
            if (item.X_CLARIFY_INTERACTION != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLARIFY_INTERACTION);                // P_CLARIFY_INTERACTION
            }
            i++;
            if (item.X_CLARO_LDN1 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLARO_LDN1);                // P_CLARO_LDN1
            }
            i++;
            if (item.X_CLARO_LDN2 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLARO_LDN2);                // P_CLARO_LDN2
            }
            i++;
            if (item.X_CLARO_LDN3 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLARO_LDN3);                // P_CLARO_LDN3
            }
            i++;
            if (item.X_CLARO_LDN4 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLARO_LDN4);                // P_CLARO_LDN4
            }
            i++;
            if (item.X_CLAROLOCAL1 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLAROLOCAL1);                // P_CLAROLOCAL1
            }
            i++;
            if (item.X_CLAROLOCAL2 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLAROLOCAL2);                // P_CLAROLOCAL2
            }
            i++;
            if (item.X_CLAROLOCAL3 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLAROLOCAL3);                // P_CLAROLOCAL3
            }
            i++;
            if (item.X_CLAROLOCAL4 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLAROLOCAL4);                // P_CLAROLOCAL4
            }
            i++;
            if (item.X_CLAROLOCAL5 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLAROLOCAL5);                // P_CLAROLOCAL5
            }
            i++;
            if (item.X_CLAROLOCAL6 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLAROLOCAL6);                // P_CLAROLOCAL6
            }
            i++;
            if (item.X_CONTACT_PHONE != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CONTACT_PHONE);                // P_CONTACT_PHONE
            }
            i++;
            if (item.X_DNI_LEGAL_REP != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_DNI_LEGAL_REP);                // P_DNI_LEGAL_REP
            }
            i++;
            if (item.X_DOCUMENT_NUMBER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_DOCUMENT_NUMBER);                // P_DOCUMENT_NUMBER
            }
            i++;
            if (item.X_EMAIL != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_EMAIL);                // P_EMAIL
            }
            i++;
            if (item.X_FIRST_NAME != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_FIRST_NAME);                // P_FIRST_NAME
            }
            i++;
            if (item.X_FIXED_NUMBER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_FIXED_NUMBER);                // P_FIXED_NUMBER
            }
            i++;
            if (item.X_FLAG_CHANGE_USER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_FLAG_CHANGE_USER);                // P_FLAG_CHANGE_USER
            }
            i++;
            if (item.X_FLAG_LEGAL_REP != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_FLAG_LEGAL_REP);                // P_FLAG_LEGAL_REP
            }
            i++;
            if (item.X_FLAG_OTHER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_FLAG_OTHER);                // P_FLAG_OTHER
            }
            i++;
            if (item.X_FLAG_TITULAR != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_FLAG_TITULAR);                // P_FLAG_TITULAR
            }
            i++;
            if (item.X_IMEI != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_IMEI);                // P_IMEI
            }
            i++;
            if (item.X_LAST_NAME != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_LAST_NAME);                // P_LAST_NAME
            }
            i++;
            if (item.X_LASTNAME_REP != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_LASTNAME_REP);                // P_LASTNAME_REP
            }
            i++;
            if (item.X_LDI_NUMBER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_LDI_NUMBER);                // P_LDI_NUMBER
            }
            i++;
            if (item.X_NAME_LEGAL_REP != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_NAME_LEGAL_REP);                // P_NAME_LEGAL_REP
            }
            i++;
            if (item.X_OLD_CLARO_LDN1 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLARO_LDN1);                // P_OLD_CLARO_LDN1
            }
            i++;
            if (item.X_OLD_CLARO_LDN2 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLARO_LDN2);                // P_OLD_CLARO_LDN2
            }
            i++;
            if (item.X_OLD_CLARO_LDN3 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLARO_LDN3);                // P_OLD_CLARO_LDN3
            }
            i++;
            if (item.X_OLD_CLARO_LDN4 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLARO_LDN4);                // P_OLD_CLARO_LDN4
            }
            i++;
            if (item.X_OLD_CLAROLOCAL1 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLAROLOCAL1);                // P_OLD_CLAROLOCAL1
            }
            i++;
            if (item.X_OLD_CLAROLOCAL2 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLAROLOCAL2);                // P_OLD_CLAROLOCAL2
            }
            i++;
            if (item.X_OLD_CLAROLOCAL3 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLAROLOCAL3);                // P_OLD_CLAROLOCAL3
            }
            i++;
            if (item.X_OLD_CLAROLOCAL4 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLAROLOCAL4);                // P_OLD_CLAROLOCAL4
            }
            i++;
            if (item.X_OLD_CLAROLOCAL5 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLAROLOCAL5);                // P_OLD_CLAROLOCAL5
            }
            i++;
            if (item.X_OLD_CLAROLOCAL6 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_CLAROLOCAL6);                // P_OLD_CLAROLOCAL6
            }
            i++;
            if (item.X_OLD_DOC_NUMBER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_DOC_NUMBER);                // P_OLD_DOC_NUMBER
            }
            i++;
            if (item.X_OLD_FIRST_NAME != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_FIRST_NAME);                // P_OLD_FIRST_NAME
            }
            i++;
            if (item.X_OLD_FIXED_PHONE != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_FIXED_PHONE);                // P_OLD_FIXED_PHONE
            }
            i++;
            if (item.X_OLD_LAST_NAME != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_LAST_NAME);                // P_OLD_LAST_NAME
            }
            i++;
            if (item.X_OLD_LDI_NUMBER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_LDI_NUMBER);                // P_OLD_LDI_NUMBER
            }
            i++;
            if (item.X_OLD_FIXED_NUMBER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OLD_FIXED_NUMBER);                // P_OLD_FIXED_NUMBER
            }
            i++;
            if (item.X_OPERATION_TYPE != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OPERATION_TYPE);                // P_OPERATION_TYPE
            }
            i++;
            if (item.X_OTHER_DOC_NUMBER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OTHER_DOC_NUMBER);                // P_OTHER_DOC_NUMBER
            }
            i++;
            if (item.X_OTHER_FIRST_NAME != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OTHER_FIRST_NAME);                // P_OTHER_FIRST_NAME
            }
            i++;
            if (item.X_OTHER_LAST_NAME != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OTHER_LAST_NAME);                // P_OTHER_LAST_NAME
            }
            i++;
            if (item.X_OTHER_PHONE != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OTHER_PHONE);                // P_OTHER_PHONE
            }
            i++;
            if (item.X_PHONE_LEGAL_REP != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_PHONE_LEGAL_REP);                // P_PHONE_LEGAL_REP
            }
            i++;
            if (item.X_REFERENCE_PHONE != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_REFERENCE_PHONE);                // P_REFERENCE_PHONE
            }
            i++;
            if (item.X_REASON != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_REASON);                // P_REASON
            }
            i++;
            if (item.X_MODEL != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_MODEL);                // P_MODEL
            }
            i++;
            if (item.X_LOT_CODE != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_LOT_CODE);                // P_LOT_CODE
            }
            i++;
            if (item.X_FLAG_REGISTERED != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_FLAG_REGISTERED);                // P_FLAG_REGISTERED
            }
            i++;
            if (item.X_REGISTRATION_REASON != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_REGISTRATION_REASON);                // P_REGISTRATION_REASON
            }
            i++;
            if (item.X_CLARO_NUMBER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CLARO_NUMBER);                // P_CLARO_NUMBER
            }
            i++;
            if (item.X_MONTH != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_MONTH);                // P_MONTH
            }
            i++;
            if (item.X_OST_NUMBER != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OST_NUMBER);                // P_OST_NUMBER
            }
            i++;
            if (item.X_BASKET != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_BASKET);                // P_BASKET
            }
            i++;
            if (item.X_EXPIRE_DATE != dateInicio)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_EXPIRE_DATE);                // P_EXPIRE_DATE
            }
            i++;
            if (item.X_ADDRESS5 != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_ADDRESS5);                // P_ADDRESS5
            }
            i++;
            arrParam[i].Value = Funciones.CheckDbl(item.X_CHARGE_AMOUNT);            // P_CHARGE_AMOUNT
            i++;
            if (item.X_CITY != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CITY);                // P_CITY
            }
            i++;
            if (item.X_CONTACT_SEX != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_CONTACT_SEX);                // P_CONTACT_SEX
            }
            i++;
            if (item.X_DEPARTMENT != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_DEPARTMENT);                // P_DEPARTMENT
            }
            i++;
            if (item.X_DISTRICT != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_DISTRICT);                // P_DISTRICT
            }
            i++;
            if (item.X_EMAIL_CONFIRMATION != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_EMAIL_CONFIRMATION);                // P_EMAIL_CONFIRMATION
            }
            i++;
            if (item.X_FAX != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_FAX);                // P_FAX
            }
            i++;
            if (item.X_FLAG_CHARGE != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_FLAG_CHARGE);                // P_FLAG_CHARGE
            }
            i++;
            if (item.X_MARITAL_STATUS != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_MARITAL_STATUS);                // P_MARITAL_STATUS
            }
            i++;
            if (item.X_OCCUPATION != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_OCCUPATION);                // P_OCCUPATION
            }
            i++;
            if (item.X_POSITION != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_POSITION);                // P_POSITION
            }
            i++;
            if (item.X_REFERENCE_ADDRESS != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_REFERENCE_ADDRESS);                // P_REFERENCE_ADDRESS
            }
            i++;
            if (item.X_TYPE_DOCUMENT != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_TYPE_DOCUMENT);                // P_TYPE_DOCUMENT
            }
            i++;
            if (item.X_ZIPCODE != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_ZIPCODE);                // P_ZIPCODE
            }
            i++;
            if (item.X_ICCID != null)
            {
                arrParam[i].Value = Funciones.CheckStr(item.X_ICCID);                // P_ICCID
            }
            Clarify objClarify = new Clarify(BaseDatos.BD_CLARIFY);

            DAABRequest obRequest = objClarify.CreaRequest();

            obRequest.CommandType = CommandType.StoredProcedure;
            obRequest.Command     = BaseDatos.NOMBRE_PACKAGE_INTERCCION_CLFY + ".SP_CREATE_PLUS_INTER";
            obRequest.Parameters.AddRange(arrParam);
            obRequest.Transactional = true;
            try
            {
                obRequest.Factory.ExecuteNonQuery(ref obRequest);
                obRequest.Factory.CommitTransaction();
                //log.Info(String.Format("Base de Datos : Correcto"));
            }
            catch (Exception ex)
            {
                obRequest.Factory.RollBackTransaction();
                //log.Info(String.Format("Error Base de Datos : {0}", ex.ToString()));
                throw ex;
            }
            finally
            {
                IDataParameter parSalida1, parSalida2;
                parSalida1     = (IDataParameter)obRequest.Parameters[obRequest.Parameters.Count - 2];
                parSalida2     = (IDataParameter)obRequest.Parameters[obRequest.Parameters.Count - 1];
                rFlagInsercion = Funciones.CheckStr(parSalida1.Value);
                rMsgText       = Funciones.CheckStr(parSalida2.Value);
                if (rMsgText == "")
                {
                    rMsgText = "No hay Errores";
                }
                //log.Info(String.Format("Recibe Datos de Salida"));
                //log.Info(string.Format("Interaccion Id : {0}, Flag Insercion : {1}, Mensaje : {2}",vInteraccionId, rFlagInsercion, rMsgText));
                //log.Info(String.Format("Termina Operaciones Insertar Plantilla Interaccion"));
                //obRequest.Factory.Dispose();
            }
            return(true);
        }
예제 #5
0
        public ItemGenerico InsertarInteraccion(Interaccion item)
        {
            DAABRequest.Parameter[] arrParam =
            {
                new DAABRequest.Parameter("P_CONTACTOBJID_1",  DbType.Int64,  ParameterDirection.Input),
                new DAABRequest.Parameter("P_SITEOBJID_1",     DbType.Int64,  ParameterDirection.Input),
                new DAABRequest.Parameter("P_ACCOUNT",         DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_PHONE",           DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_TIPO",            DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_CLASE",           DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_SUBCLASE",        DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_METODO_CONTACTO", DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_TIPO_INTER",      DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_AGENTE",          DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_USR_PROCESO",     DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_HECHO_EN_UNO",    DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_NOTAS",           DbType.String,                      4000,ParameterDirection.Input),
                new DAABRequest.Parameter("P_FLAG_CASO",       DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("P_RESULTADO",       DbType.String,                       255,ParameterDirection.Input),
                new DAABRequest.Parameter("ID_INTERACCION",    DbType.String,                       255,ParameterDirection.Output),
                new DAABRequest.Parameter("FLAG_CREACION",     DbType.String,                       255,ParameterDirection.Output),
                new DAABRequest.Parameter("MSG_TEXT",          DbType.String,                       255,ParameterDirection.Output)
            };
            for (int j = 0; j < arrParam.Length; j++)
            {
                arrParam[j].Value = System.DBNull.Value;
            }

            int i = 0;

            if (item.OBJID_CONTACTO != null)
            {
                arrParam[i].Value = Funciones.CheckInt64(item.OBJID_CONTACTO);               // P_CONTACTOBJID_1
            }
            i++;
            if (item.OBJID_SITE != null)
            {
                arrParam[i].Value = Funciones.CheckInt64(item.OBJID_SITE);               // P_SITEOBJID_1
            }
            i++;
            if (item.CUENTA != null)
            {
                arrParam[i].Value = item.CUENTA;               // P_ACCOUNT
            }
            i++;
            if (item.TELEFONO != null)
            {
                arrParam[i].Value = item.TELEFONO;               // P_PHONE
            }
            i++;
            if (item.TIPO != null)
            {
                arrParam[i].Value = item.TIPO;               // P_TIPO
            }
            i++;
            if (item.CLASE != null)
            {
                arrParam[i].Value = item.CLASE;               // P_CLASE
            }
            i++;
            if (item.SUBCLASE != null)
            {
                arrParam[i].Value = item.SUBCLASE;               // P_SUBCLASE
            }
            i++;
            if (item.METODO != null)
            {
                arrParam[i].Value = item.METODO;               // P_METODO_CONTACTO
            }
            i++;
            if (item.TIPO_INTER != null)
            {
                arrParam[i].Value = item.TIPO_INTER;               // P_TIPO_INTER
            }
            i++;
            if (item.AGENTE != null)
            {
                arrParam[i].Value = item.AGENTE;               // P_AGENTE
            }
            i++;
            if (item.USUARIO_PROCESO != null)
            {
                arrParam[i].Value = item.USUARIO_PROCESO;               // P_USR_PROCESO
            }
            i++;
            if (item.HECHO_EN_UNO != null)
            {
                arrParam[i].Value = item.HECHO_EN_UNO;                // P_HECHO_EN_UNO
            }
            i++;
            if (item.NOTAS != null)
            {
                arrParam[i].Value = item.NOTAS;                // P_NOTAS
            }
            i++;
            if (item.FLAG_CASO != null)
            {
                arrParam[i].Value = item.FLAG_CASO;                // P_FLAG_CASO
            }
            i++;
            if (item.RESULTADO != null)
            {
                arrParam[i].Value = item.RESULTADO;                // P_RESULTADO
            }
            ItemGenerico itemDatos  = new ItemGenerico();
            Clarify      objClarify = new Clarify(BaseDatos.BD_CLARIFY);
            DAABRequest  obRequest  = objClarify.CreaRequest();

            obRequest.CommandType = CommandType.StoredProcedure;
            obRequest.Command     = BaseDatos.NOMBRE_PACKAGE_INTERCCION_CLFY + ".SP_CREATE_INTERACT";
            obRequest.Parameters.AddRange(arrParam);
            obRequest.Transactional = true;
            try
            {
                obRequest.Factory.ExecuteNonQuery(ref obRequest);
                obRequest.Factory.CommitTransaction();
            }
            catch (Exception ex)
            {
                obRequest.Factory.RollBackTransaction();
                itemDatos.estado      = Funciones.CheckStr(ex.Source);
                itemDatos.Descripcion = Funciones.CheckStr(ex.Message);
            }
            finally
            {
                IDataParameter parSalida1, parSalida2, parSalida3;
                parSalida1 = (IDataParameter)obRequest.Parameters[obRequest.Parameters.Count - 3];
                parSalida2 = (IDataParameter)obRequest.Parameters[obRequest.Parameters.Count - 2];
                parSalida3 = (IDataParameter)obRequest.Parameters[obRequest.Parameters.Count - 1];
                // ItemGenerico
                itemDatos.Codigo      = Funciones.CheckStr(parSalida1.Value);
                itemDatos.estado      = Funciones.CheckStr(parSalida2.Value);
                itemDatos.Descripcion = Funciones.CheckStr(parSalida3.Value);

                obRequest.Factory.Dispose();
            }
            return(itemDatos);
        }