I'm a web-lovin, webapp maker kinda guy

Archive for the ‘Database’ Category

Facebook login integration, Paypal transactions, Google language translations, Javascript snippets, Memberships

Have you ever wanted to learn how to invest in stocks? If yes, you’ll need to learn chinese 🙂

So a couple months ago, a former work colleague and friend asked me to start the development of a website for him. He’s taken a successful English-based website and created a website for Chinese-speaking investors. His website is now live at www.5168options.com

His website is basically a free and paid membership-based content management system. Users who pay for the membership are given access to highly informative and frequently updated content. He needed a quick, yet working mock-up of the site to present to his inner circle.

I created his website using Dreamweaver as the developer environment. I included the Facebook login integration into the site for a more user-friendly experience. The paid transactions are done with Paypal’s e-commerce Merchant Services. The language translation between Chinese Simplified to Chinese Traditional was done with Google’s Website Translator. ASP and Access database stores the user login data and memberships. And the stock ticker is simply a javascript snippet.

update: due to time contraints I have relieved myself from the day-to-day maintenance of the site.

This is a test

My UI design has been given a patent!

Patent

The most commonly used feature of our web-based software is officially granted a patent today. I was one of three developers who worked on this feature. My responsibility was to come up with the UI design and develop it. The summary on the patent says,

A method on a computer for providing critical chain-based project management is disclosed. The method includes receiving at least one project plan for a project comprising a plurality of task and calculating a task priority for each...

The summary goes on and on… in other words, I created something very complex and we don’t want anyone else stealing our ideas.

My patents,

*update: If you want to read the entire summary, I now have a framed plaque with the patent to show you! Yay!

My web-based customer support portal!

web-based customer portal

The Realization technical support team needed a way to streamline their processes with customers using a web-based application. They occasionally conduct workshops and learning sessions and needed a way for our clients to register for these classes. The IT team also needed a way for certain clients to be allowed to download files and software releases. It was my responsibility to come up with a design and take it to completion.

I created this web application using ASP.Net with SQL Server as the database. The application administrator section allows the admin to add/remove workshops, upload files for users to download, and set the user’s permissions.

Realization Customer Support Portal

Keypoint’s e-Project made with ASP!

Aside from being a web consultant for Keypoint – traveling to bay area companies to help clients with their websites – I am also one of two web application developers for Keypoint’s in-house software, e-Project.

The Keypoint team and I use e-Project to track the number of hours we spend programming (or graphics designing for the graphics guys) for a certain client. When it is time to bill our clients, e-Project calculates our rates and the time we spend so it can prepare an invoice for the client.

*update: Our e-project is now available to other companies who wish to use a web-based Time and Resource Billing application.

KeyPoint.com

My first e-Commerce site! Buy your Metabolife now!

my first e-Commerce and ASP site!

A high school buddy and I decided to dabble in eCommerce. He is somewhat a medical expert and I am somewhat a technical expert so I took on the task of creating an eCommerce website for us. Our website allows consumers to buy Metabolife and other supplements through an online store.

This was my first time using ASP to create an entire website. With ASP I was able to construct a shopping cart feature and use SQL to store our orders in a database. The orders are processed through a 3rd party merchant. 

We launched the website a couple weeks after my college graduation and called it SynergyCommerce.

*update: SynergyCommerce was short-lived but was great for my continuing self-education.