Example #1
0
        private List <VMX_CONTOLPOLIZA_LINE> getListVMX_CONTOLPOLIZA_LINE_CXC_TCPago()
        {
            List <VMX_CONTOLPOLIZA_LINE> lstVMXPoliza = new List <VMX_CONTOLPOLIZA_LINE>();

            foreach (DataRow dr_i in _dtDetalla_IVA.Rows)
            {
                VMX_CONTOLPOLIZA_LINE oPL = new VMX_CONTOLPOLIZA_LINE();

                oPL.NO_TRANSACCION  = ID;
                oPL.BANK_ACCOUNT_ID = dr_i["BANK_ACCOUNTID"].ToString();
                oPL.VAT_AMOUNT      = "0";
                oPL.SELL_RATE       = double.Parse(dr_i["TC_FACTURA"].ToString());
                oPL.MONTO           = double.Parse(dr_i["IVA_MXN_TRASLADAR_FACT"].ToString());
                oPL.CUENTA          = dr_i["VAT_GL_ACCTID"].ToString();
                oPL.DESCRIPCION     = dr_i["DESCRIPCION"].ToString();
                oPL.CUENTA_TRASLADO = dr_i["TRASLADO"].ToString();
                oPL.DESCRIPTION     = dr_i["TRASLADO"].ToString();
                oPL.CHECK_ID        = dr_i["CONTROL_NO"].ToString();
                oPL.TIPO_OPERACION  = "CXC";
                oPL.CUSTOMER_ID     = dr_i["Cliente"].ToString();

                lstVMXPoliza.Add(oPL);
            }

            return(lstVMXPoliza);
        }
Example #2
0
        public void createVMX_CONTOLPOLIZA_LINE_CXP(VMX_CONTOLPOLIZA_LINE oVMXLine)
        {
            string sCons = string.Empty;

            try
            {
                string query = MapeoQuerySql.ObtenerPorId("AdminGeneralJournal.createVMX_CONTOLPOLIZA_LINE_CXP");

                sCons = string.Format(query
                                      , oVMXLine.NO_TRANSACCION, oVMXLine.BANK_ACCOUNT_ID, oVMXLine.CONTROL_NO
                                      , oVMXLine.VAT_AMOUNT, oVMXLine.SELL_RATE, oVMXLine.MONTO
                                      , oVMXLine.CUENTA, oVMXLine.DESCRIPCION, oVMXLine.CUENTA_TRASLADO, oVMXLine.DESCRIPTION, oVMXLine.TIPO_OPERACION, oVMXLine.CUSTOMER_ID, oVMXLine.PERDIDA_GANANCIA, oVMXLine.IVA_DEPOSITO, oVMXLine.SITE_ID, oVMXLine.MONTO_RET, oVMXLine.RET_DEPOSITO);

                _trace.AppendLine(sCons);
                _oSQL.EjecutarDML(sCons);
            }
            catch (Exception ex)
            {
                throw new Exception("Error al insertar en VMX_CONTOLPOLIZA_LINE - CXP. Detalle: " + ex.Message);
            }
        }