Pinoy Code

S2xDE Software Data Entry System - Batching Module (Part 1)

Ruben — Sun, 06 Jul 2008 13:15:00 -0400

A pre-defined number of documents to a batching unit including the link of images for production use. Instead of queuing document one at a time, the batch is queued containing a pre-defined number of documents. Normally, a batch for specific project will contain between 10 to 50 documents or many, it depends on the project data conversion.

screenshot Data Entry System (Batching Module)

Data Entry System - User Input
File Pattern     - the extension of image file (*.tif)
Client Code     - unique id for client (FA)
Project Name - client code plus unique id for project name (FA CL 1900)
Batch Code    - unique id for project name plus the county code (CL19AR59)
No. of Docs      - any number
Explorer View - control to navigate the image location
Fileview           - display the folder or image file during navigation of explorer view control.
                        - user should be highlight selected file image or folder in fileview control
                          to process during the batching.

Batch Number = contain Batch Code plus incremental value of record stored in Batch Header database (dbo.batch_hdr).

During batching process the system create a template record of document in the database table Entry 1 (dbo.e1) and Entry 2 (dbo.e2) and other related table (dbo.e1.bbd_names, dbo.e1.sgp_names) for production use. After the batches done in batching process will automatically available for production entry (E1 & E2) based on a project code. (screen shot below are the template table to be used in data entry).

Batch Header

Batch Detailed

Entry 1 Main Table

Borrower Names (Sub-Table)

Seller Names (Sub-Table)

to be continue... Next post will be the design view & code behind of Batching Module.

Previous post of S2xDE Software Data Entry System

S2xDE Software Data Entry System - Database Schema and Table Structure (Part 2)

Ruben — Sun, 29 Jun 2008 14:39:00 -0400

Table Structure of RES-1900 Project

Every Task processed in production group have a table repository:
ex: [E1] Entry 1
     dbo.e1_hdr
        -> batch header that contains batch no, user id, date issue, number of docs, number of record, number of character.
     dbo.e1
        -> main record captured on the documents.
     dbo.e1_bbd_names
        -> (sub-record) in one document are allowed four record of borrower names to be captured.
     dbo.e1_sgp_names
        -> (sub-record) in one document are allowed two record of seller names to be captured.

Batch Header Table

Entry 1 Main Table

Entry 1 sub table - borrower names

Entry 1 sub table - seller names

Visual idea of s2xde database schema and table structure, on my next post we proceed Batching module.

Previous Post of S2xDE Software

S2xDE Software Data Entry System - Database Schema and Table Structure (Part 1)

Ruben — Sat, 28 Jun 2008 23:00:00 -0400

S2xDE Software Database Schema
    1) RES-1900
    2) RES-ADC
    3) RES-EFX
    4) RES-MAP
    5) RES-TRACKING
    6) S2xDE

S2xDE Software Production Monitoring or Tracking
    - All activity task code are monitored by the Task Code
    BA    Batching
    E1    Entry 1
    E2    Entry 2
    CO    Compare
    RE    Research
    QC    QC Sampling
    ED Edit
    CV    Conversion

- All task are auto queuing its important to keep track batches by storing the information. See screenshot of RES-Tracking schema.

Batch Table

Monitoring Table

Pending Table

Audit Trail Table

Document Count Table

Accuracy Table

to be continue on next post of data entry system...

Previous Post of S2xDE Software

S2xDE Software Data Entry System

Ruben — Thu, 26 Jun 2008 18:48:00 -0400

Screenshot -> S2xDE Software - Admin User (Main Screen)

S2xDE Software is a highly robust and flexible customized data entry system application designed and developed specifically for Real Estate Solution projects (FA Core Logic). It was developed under VB.NET platform with a back-end database using MS SQL Server 2005.

This application contains 4 different project known as:
   1) RES-1900
   2) RES-ADC
   3) RES-Foreclosure/Mapping
   4) RES-EFX

Data Entry System Program Module
   1) Batching
   2) Entry 1 / Entry 2
   3) Compare
   4) Research
   5) QA
   6) Edit (Validation)
   7) Conversion
   8) Maintenance
   9) Reports
   ... etc.

Screenshot -> S2xDE Software Data Entry System

We put it on my blog site to share other newbies programmer how to develop a customized data entry system program from start process to end. Subscribe to receive updates regarding this S2xDE Software, i will post step by step module source code and screenshot including the short explanation how it works.

Petty Cash Monitoring System - Free Source Code

Ruben — Sun, 27 Apr 2008 15:25:00 -0400

This application written in Visual Basic 6, i made it last 5 years ago not properly commented but it might help from you to study. Some module i found also in open source site that give me a change to learn about in VB coding. Now i upload also in my blog site to share it with other novice programmer specially students that are willing to learn in Visual Basic language. Download the Petty Cash Monitoring System (PCMS.zip) ... Good Luck!

Free Source Code: PCMS.zip (43.5 mb)

Other programming eBooks located at Free PDF Book Download

Free Book PDF Download

Ruben — Wed, 16 Apr 2008 16:04:00 -0400

JAVA
Core Java, Vol. 2: Advanced Features, 8th Edition
by: Cay S. Horstmann, Gary Cornell
Kicking Butt with MIDP and MSA: Creating Great Mobile Applications
by: Jonathan Knudsen
Java Power Tools
by: John Ferguson Smart
Java Concepts for Java 5 and 6, 5th Edition
by: Cay S. Horstmann
Java For Dummies 4th edition
by: Barry Burd
Enterprise Java 2 Security: Building Secure and Robust J2EE Applications
by: Marco Pistoia, Nataraj Nagaratnam, Larry Koved, Anthony Nadalin
Java 2 Enterprise Edition 1.4 (J2EE 1.4) Bible
by: James McGovern, Rahim Adatia, Yakov Fain, Jason Gordon, Ethan Henry, Walter Hurst, Ashish Jain, Mark Little, Vaidyanathan Nagarajan, Harshad Oak, Lee Anne Phillips
Java in 60 Minutes a Day
by: Richard F. Raposa
Object-Oriented Programming: From Problem Solving to Java
by: Jose M. Garrido
Technical Java: Developing Scientific and Engineering Applications
by: Grant Palmer
Micro Java Game Development
by: David Fox
Core Java 2, Volume II: Advanced Features 5th Edition
by: Cay Horstmann, Gary Cornell
Java Cookbook: Solutions and Examples for Java Developers
by: Ian F. Darwin
Java Regular Expressions: Taming the java.util.regex Engine
by: Mehran Habibi
Java I/O
by: Elliotte Harold
Java: A Beginner's Guide, Third Edition
by: Herbert Schildt
Ground-Up Java
by: Philip Heller
Programming Wireless Devices with the Java 2 Platform Micro Edition, Second Edition
by: Roger Riggs, Antero Taivalsaari et al.
Java Number Cruncher: The Java Programmer's Guide to Numerical Computing
by: Ronald Mak
Core Java 2, Volume II - Advanced Features (7th Edition)
by: Cay Horstmann, Gary Cornell
Beginning J2EE 1.4: From Novice to Professional
by: James L. Weaver, Kevin Mukhar, James P. Crume
Beginning J2ME: From Novice to Professional, Third Edition
by: Jonathan Knudsen, Sing Li
Beginning Spring Framework 2
by: Thomas Van de Velde, Bruce Snyder et al.
Tricks of the Java Programming Gurus
by: Glenn L. Vanderburg
Core JSTL: Mastering the JSP Standard Tag Library
by: David Geary
J2EE Professional Projects
by: Pallavi Jain, Shadab Siddiqui
Beginning Hibernate: From Novice to Professional
by: Jeff Linwood, Dave Minter
Pro Java EE Spring Patterns: Best Practices and Design Strategies Implementing Java EE Patterns with the Spring Framework
by: Dhrubojyoti Kayal
Mastering AspectJ: Aspect-Oriented Programming in Java
by: Joseph D. Gradecki, Nicholas Lesiecki

VISUAL BASIC 2008
Visual Basic 2008 Programmer's Reference
by: Rod Stephens
Programming Visual Basic 2008
by: Tim Patrick
Professional Visual Basic 2008
by: Bill Evjen, Billy Hollis, Bill Sheldon, Kent Sharkey
Professional Refactoring in Visual Basic
by: Danijel Arsenovski
Mastering Microsoft Visual Basic 2008
by: Evangelos Petroutsos
Beginning VB 2008 Databases
by: Vidya Vrat Agarwal
Sams Teach Yourself Visual Basic 2008 in 24 Hours
by: James Foxall

SQL SERVER
Pro SQL Server 2008 Reporting Services
by: Rodney Landrum
Pro SQL Server 2008 XML
by: Michael Coles
Accelerated SQL Server 2008
by: Rob Walters
Microsoft SQL Server 2005 Programming For Dummies
by: Andrew Watt
Joe Celko's Analytics and OLAP in SQL
by: Joe Celko
Beginning SQL
by: Paul Wilton, John Colby
SQL Clearly Explained, Second Edition
by: Jan L. Harrington

VB.NET, ASP.NET, C# FREE BOOK DOWNLOAD
Professional ASP.NET 3.5 In C# and VB
by: Bill Evjen, Scott Hanselman, Devin Rader
Expert .NET Micro Framework
by: Jens Kühner
Pro WF: Windows Workflow in .NET 3.5
by: Bruce Bukovics
Practical WPF Graphics Programming
by: Jack Xu
Professional Visual Studio 2005
by: Andrew Parsons, Nick Randolph
MCAD/MCSD Visual Basic.NET Windows Applications Study Guide (Exam 70-306)
by: David Panagrosso
Wrox Beginning C# 3.0
by: Jack Purdum
Unlocking Microsoft C# v2.0 Programming Secrets
by: Richard Braden
Visual Studio .NET Tips and Tricks
by: Minh T. Nguyen
Professional Crystal Reports for Visual Studio .NET, Second Edition
by: David McAmis
Inside Microsoft Visual Studio .NET 2003
bY: Brian Johnson, Craig Skibo
A Programmer's Introduction to Visual Basic .Net
by: Craig Utley

NETWORKING
Handbook of Research on Wireless Multimedia: Quality of Service and Solutions
by: Nicola Cranley & Liam Murphy
WiMAX Technologies, Performance Analysis, and QoS
by: Syed Ahson & Ilyas
Global Mobile Multimedia Communications
by: Gour Karmakar & Laurence S. Dooley
Mobile WiMAX
by: Kwang-Cheng Chen, J.; Roberto B. de Marca (Editors)
WiMAX Applications
by: Syed Ahson & Ilyas
Analysis of Computer and Communication Networks
by: Fayez Gebali
Optical Switching Networks
by: Martin Maier
Session Initiation Protocol (SIP): Controlling Convergent Networks
by: Travis Russell
Stability of Queueing Networks
by: Maury Bramson
Information Theory and Network Coding
by: Raymond W. Yeung
Cisco Certified Entry Networking Technician Study Guide: ICND1 Exam 640-822 (CCENT)
by: Todd Lammle
Cisco Certified Network Associate Study Guide: Exam 640-802 (CCNA)
by: Todd Lammle
Voice Over WLANS
by: Michael F. Finneran
The Exploit: A Theory of Networks
by: Alexander R. Galloway
Designing the Mobile User Experience
by: Barbara Ballard
Optical Networking Best Practices Handbook
by: John R. Vacca
Introduction to Mobile Communications
by: Tony Wakefield & Assoc
Deploying Voice over Wireless LANs
by: Jim Geier
Wireless Ad Hoc Networking
by: Shih-Lin Wu & Yu-Chee Tseng
Fundamentals of WiMAX
by: Jeffrey G. Andrews & Assoc
Broadband Optical Access Networks and Fiber-to-the-Home: Systems Technologies and Deployment Strategies
by: Chinlon Lin (Editor)
Communication Systems for the Mobile Information Society
by: Martin Sauter
Advanced Wireless Networks: 4G Technologies
by: Savo G. Glisic
Home Wireless Networking in a Snap
by: Joe Habraken
Wireshark & Ethereal Network Protocol Analyzer Toolkit
by: Angela Orebaugh
Mobile Virtual Work
by: Editors : J.H. Erik & Vartianen
Cisco Wireless LAN Security
by: Andrew Balinsky & Assoc
WCDMA : Requirements & Practical Design
by: Tanner & Woodard
GPRS for Mobile Internet
by: Emmanuel Seurre, Patrick Savelli, Jean-Pierre Pietri
WLANs & WPANs towards 4G Wireless
by: Luis Munoz & Ramjee Prasad
Third Generation Wireless Communications
by: George M. Calhoun
Computer Networks: A Systems Approach, 3rd Edition
by: Peterson & Davie
The Handbook of Optical Communication Networks
by: Mohammad Ilyas, Hussein T. Mouftah (Editor)
Learning Bayesian Networks (Artificial Intelligence)
by: Richard E. Neapolitan
Storage Networks: The Complete Reference
by: Robert Spalding
Mobile VPN
by: Alex Shneyderman & Alessio Casati
Networks: Design and Management
by: Steven Karris
Communication Networks: Fundamentals Concepts and Key Architectures
by: Alberto Leon-Garcia
CCIE Cisco Certified Internetwork Expert Study Guide
by: John Swartz, Todd Lammle
Cisco IP Routing Fundamentals
by: Mark A. Sportack
Dictionary of Networking
by: Peter Dyson
Illustrated TCP/IP
by: Matthew G. Naugle
IP Routing Primer
by: Robert Wright
MCSE Networking Essentials
by: Glenn Berg
TCP/IP Network Administration
by: Craig Hunt

Petty Cash Monitoring System - Screenshot

Ruben — Mon, 14 Apr 2008 21:20:00 -0400

Petty Cash Monitoring System - Free Download

Ruben — Mon, 14 Apr 2008 20:42:00 -0400

Petty Cash Monitoring System

Petty Cash Monitoring System is a system to keep track expenditure in cash or other transaction. This software has been designed primarily to record all cash transactions in a basic accounting rules like account title description, transaction reference etc. It is usually more convenient to retrieve information on cash expenses by generating a report.
        a) Summary by Transaction
        b) Summary by Supplier
        c) Summary by Accounty Title
        d) Summary by Product
        e) Detailed by Transaction
        f) Detailed by Supplier
        g) Detailed by Account Title
        h) Detailed by Product
        i) Detailed by Category

System Requirement
Windows 98/2000/XP

Download the Installer and Try It... other information regarding Petty Cash process flow will be posted in this blogs.
Petty Cash Monitoring System.zip (43.5 mb)

NOTE:
***During the installation if error occur click ignore button to continue.
User Login: ADM
Password: admin

Open the file pcms.ini in Notepad then modify the company info.
[COMPANYINFO]
COMPANYNAME = MY COMPANY NAME
COMPANYPHONE = 123-456789
COMPANYFOX = 111-111111
COMPANYADDR = BLK-15 LOT-27 PH3B PNWC, BULACAN

PETTY CASH MONITORING SYSTEM - Screenshot

FREE BOOK PDF DOWNLOAD

Array Programming in VB.Net

Ruben — Thu, 10 Apr 2008 20:41:00 -0400

Array Programming in VB.Net
Array programming is a data structure consisting of a group of elements that are accessed by indexing. In most programming languages each element has the same data type and the array occupies a contiguous area of storage.

Arrays in VB.NET inherit from the Array class in the System namespace. All arrays in VB as zero based, meaning the index of the first element is zero and they are numbered sequentially. You must specify the number of array elements by indicating the upper bound of the array. The upper bound is the number that specifies the index of last element of the array. Arrays are declared using Dim, ReDim, Static, Private, Public and Protected keywords. An array can have one dimension or more than one (multidimensional arrays). The dimensionality of an array refers to the number of subscripts used to identify an individual element.

The following code demonstrates arrays.

'single dimension array
Dim cars(3) As String

'populate the elements of cars variable
cars(0) = "Olds"
cars(1) = "Nissan"
cars(2) = "Toyota"
cars(3) = "Geo"

'In order to extend the array element used Redim Preserve
ReDim Preserve cars(4)
cars(4) = "Mercedes"

'MessageBox.Show(cars(0))
'MessageBox.Show(cars(4))

Dim counter As Integer
For counter = 0 To cars.Length
MessageBox.Show(cars(counter))
Next

'two dimensional array
Dim trucks(2, 2) As String

'populate the elements of trucks variable
trucks(0, 0) = "Toyota Tundra"
trucks(0, 1) = "Toyota Sequoia"
trucks(0, 2) = "Toyota 4Runner"

trucks(1, 0) = "Nissan Xtera"
trucks(1, 1) = "Nissan Pathfinder"
trucks(1, 2) = "Nissan Titan"

trucks(2, 0) = "Chevy Blazer"
trucks(2, 1) = "Chevy Suburban"
trucks(2, 2) = "Chevy Tahoe"

Dim i As Integer
Dim j As Integer

'outer loop
For i = 0 To trucks.GetUpperBound(0)
    'inner loop
    For j = 0 To trucks.GetUpperBound(1)
        MessageBox.Show(trucks(i, j))
    Next
Next

'tree dimensional array
Dim flights(2, 3, 4) As String

'populate the elements of flights variable
flights(0, 0, 0) = "Chicago - Dallas - 5:00am"
flights(0, 0, 1) = "Chicago - Dallas - 6:00am"
flights(0, 0, 2) = "Chicago - Dallas - 7:00am"
flights(0, 0, 3) = "Chicago - Dallas - 8:30am"
flights(0, 0, 4) = "Chicago - Dallas - 9:45am"

flights(0, 1, 0) = "Dulles - Chicago - 4:45am"
flights(0, 1, 1) = "Dulles - chicago - 5:30am"

'Total of 60 flights

FREE PDF BOOK DOWNLOAD

SQL Server Free Download

Ruben — Thu, 10 Apr 2008 16:29:00 -0400

SQL Server Free Download

Looking for SQL Server-related add-ons and resources, you can find updates, tools and utilities, code samples, product documentation, and SQL Server technologies on the SQL Server home page (http://www.microsoft.com/downloads). See sample links below.

Microsoft SQL Server 2008 CTP, February 2008
Download the latest SQL Server 2008 Community Technology Preview (CTP) and try out the latest features of SQL Server 2008! The SQL Server development team uses your CTP feedback to help refine and enhance product features.

Microsoft SQL Server Management Studio Express
Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.

Microsoft SQL Server 2005 Express Edition Service Pack 2
Microsoft SQL Server 2005 Express Edition is a free, easy-to-use, lightweight version of SQL Server 2005. It is fast and easy to learn, allowing you to quickly develop and deploy dynamic data-driven applications.

MS SQL Server 2008 - Trial Software

FREE BOOK PDF DOWNLOAD

Dora the Explorer Games Download

Ruben — Wed, 09 Apr 2008 23:49:00 -0400

Dora the Explorer Games Download

Dora's Carnival Adventure

Candy Land - Dora the Explorer Edition

La Casa de Dora

Programming Online Degree and Certificate programs

Ruben — Tue, 08 Apr 2008 16:13:00 -0400

Programming Online Degree and Certificate programs

Computer Programming related jobs are in high demand across the country and around the world. Earning your online degree in Computer Programming with the help of today's technologies. An online degree in Computer Programming could also help you greatly improve your existing career. See the list of great site that offer programming online degree.

Online Programming Degree Programs
Computer programming online degree and certificate programs with specializations in software development, web application development, system design & development, Java programming and more.

Journal of Functional Programming
Journal of Functional Programming is the only journal devoted solely to the design, implementation, and application of functional programming languages, spanning the range from mathematical theory to industrial practice.

10 Sources for Free Computer Programming Courses Online
Looking to learn more about computer programming.

Online Degrees in Computer Programming
Master of Science (MS) in Information Technology - System Design and Development
Associate of Arts in Programming and Software Development
A.A.S. in Computer Information Systems/Programming
Bachelor of Science in Information Technology - Programming & Application Development
Associate of Science in Information Technology - Programming & Application Development
Bachelor of Science in Information Systems - Programming
Associate of Applied Science - Computer Programming - Java Option
Associate of Applied Science - Computer Programming
Bachelor of Science in Computer Information Science
B.S. in Information Technology/Programming
Bachelor of Information Technology (BIT) - Programming
Ph.D. in Information Technolology - Programming

ONLINE PROGRAMMING TRAINING COURSES
Learn to program in C, C++, Oracle, COBOL, Visual Basic, Object-Oriented Analysis, PowerBuilder, and other languages with these online programming courses.

Online Programming Bachelor Degree Programs
Online Bachelor degrees in Programming from accredited distance learning schools.

FREE BOOK PDF DOWNLOAD

Programming Manual in Visual Studio 2008

Ruben — Mon, 07 Apr 2008 21:32:00 -0400

Programming Manual in Visual Studio 2008 Learning Guide

There is much for developers and architects to absorb from the release of VS 2008. SearchVB.com is presenting a Visual Studio 2008 Learning Guide as an introduction to the language, performance, testing and data management improvements in VS 2008.

Included is Quick Start information on Visual Studio 2008, some Visual Studio 2008 Beta 2 News and Notes, as well as Tips and Tutorials of the tool suite, and more.

List of Topics
Visual Studio 2008 Quick Start
Visual Studio 2008 Tips and Tutorials
Visual Studio 2008 and LINQ
Visual Studio 2008 and Visual Basic 2008
Visual Studio 2008 and C# 3.0
Visual Studio 2008 and Multi-targeting
Visual Studio 2008 and Data Access
Visual Studio 2008 and .NET Architecture
Visual Studio 2008 and Smart Client Development
Visual Studio 2008 and Web Development
Visual Studio 2008 and JavaScript IntelliSense
Visual Studio 2008 Testing and Debugging
Visual Studio 2008 Products and Plug-ins

For more Info. visit: SearchVB.com

FREE BOOK PDF DOWNLOAD

Kids Educational Games - Free Online Games

Ruben — Mon, 07 Apr 2008 14:52:00 -0400

Kids Educational Games site that give our children smart, Try It.

All Science Educational Toys

Education Place

Educational Games and Activities Zone

Fun School

Games Fun Free Kid's Online Games

Kids Adventures

Kids Game

Kids Game - Play Online

Kids Book

Kids TV Times

Kinderweb educational children's Games

Knowledge Adventure

Learning Games - Learning is Fun!

Matermind Toys

Online Games, Jigsaw Puzzles, Coloring pages, Clip Art, Learning Toys & Movies

Play Smart at Every Level

Reading Rainbow (Parents & Teachers)

Young Writers & Illustratos Contest

VB.NET 2008 Free eBooks Reference Download

Ruben — Sun, 06 Apr 2008 22:42:00 -0400

VB.NET 2008 Free eBooks Reference Download

VB.NET 2008 eBook Reference

Beginning VB 2008 Beginning VB 2008 has been written to teach you how to use the Visual Basic programming language to solve problems. From the earliest chapters, and from the first introductory concepts, you'll be looking at real-world programming challenges and learning how Visual Basic can be used to overcome them. download this free ebook free ebook By the time you've finished reading this book and worked through the sample exercises, you'll be a confident and very competent Visual Basic programmer. You will still have many explorations of the .NET Framework API to look forward to in your future career, but you will have a firm foundation to build from and you will know exactly ISBN-13: 978-1590599389

Beginning.VB.2008.From.Novice.to.Professional.Feb.2008.pdf (11.17 mb)

Other eBooks Reference

FREE BOOK PDF DOWNLOAD