Example #1
0
        public int Update()
        {
            string Statement = string.Format("tipoArticulo_update|Id@INT={0}&Descripcion@VARCHAR={1}", Id, Descripcion);
            int    result;

            try
            {
                result = DBMysql_.ExecuteProcedureInt(Statement, "Result");
                return(result);
            }
            catch (DBException ex)
            {
                throw ex;
            }
            catch (MySqlException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
        }
Example #2
0
        public int Update()
        {
            string Statement = string.Format("PedidoAjuste_add_upd|Id@INT={0}&Id_pedido@INT={1}&Concepto@VARCHAR={2}&Total@DOUBLE={3}&TipoMovimiento@VARCHAR={4}",
                                             Id,
                                             Id_pedido,
                                             Concepto,
                                             Total,
                                             TipoMovimiento
                                             );
            int result;

            try
            {
                result = DBMysql_.ExecuteProcedureInt(Statement, "Result");
                return(result);
            }
            catch (DBException ex)
            {
                throw ex;
            }
            catch (MySqlException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
        }
Example #3
0
        public int Update()
        {
            string Statement = string.Format("Productos_add_upd|Id@INT={0}&IdTipoProducto@INT={1}&Pagina@VARCHAR={2}&Codigo@VARCHAR={3}&Descripcion@VARCHAR={4}&IdCliente@INT={5}&id_nota@INT={6}&PrecioCotizacion@DOUBLE={7}",
                                             Id,
                                             IdTipoProducto,
                                             Pagina,
                                             Codigo,
                                             Descripcion,
                                             IdCliente,
                                             IdNota,
                                             PrecioCotizacion
                                             );
            int result;

            try
            {
                result = DBMysql_.ExecuteProcedureInt(Statement, "Result");
                return(result);
            }
            catch (DBException ex)
            {
                throw ex;
            }
            catch (MySqlException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
        }
Example #4
0
        public int Update()
        {
            string Statement = string.Format("Invercionista_update|Id@INT={0}&Nombre@VARCHAR={1}&isActive@INT={2}",
                                             Id,
                                             Nombre,
                                             (isActive ? 1: 0)
                                             );
            int result;

            try
            {
                result = DBMysql_.ExecuteProcedureInt(Statement, "Result");
                return(result);
            }
            catch (DBException ex)
            {
                throw ex;
            }
            catch (MySqlException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
        }
Example #5
0
        public int Delete()
        {
            string Statement = string.Format("Pedido_delete|Id@INT={0}",
                                             Id
                                             );
            int result;

            try
            {
                result = DBMysql_.ExecuteProcedureInt(Statement, "Result");
                return(result);
            }
            catch (DBException ex)
            {
                throw ex;
            }
            catch (MySqlException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
        }