Archive for category Projects
JobTime: Time Clock Web Application And Job Cost Tracking
Posted by Eric in .NET 2.0, AJAX, ASP.NET, Web Applications on September 5, 2009
Background The company needed to track time logged to particular jobs/projects. The initial idea was to use a site like ClickTime. However, for an employee to log time against a job, you would need to tell ClickTime all of your jobs (which would be tedious) or configure an integration app to automatically populate the available [...]
Automatic Email Alerts From Any SQL Query
Posted by Eric in .NET 2.0, Desktop Applications, MS SQL on September 2, 2009
Problem Reminder emails were needed to be sent out to remind sales staff to follow up on projects. Solution I developed a simple command line executable that takes 1 parameter which is an XML file. The contents of the XML file would look something like: <?xml version=”1.0″ encoding=”utf-8″ ?> <Settings> <ErrorEmail> <Email>email@gmail.com</Email> </ErrorEmail> <SummaryEmail> <Email>email@gmail.com</Email> [...]
E-manage Mobile Portal
Posted by Eric in .NET 3.5, ASP.NET, MS SQL, Web Applications, Web Services on August 18, 2009
Background: E-manage is a business management application. It is capable of managing customer databases (CRM) as well as projects, invoices, purchase orders, and inventory to name a few. The e-manage client application runs on a users desktop and uses Microsoft .NET as foundation along with a Microsoft SQL Server as the back-end. Problem: Getting information [...]
Outlook Signature
Posted by Eric in .NET 2.0, Desktop Applications, FTP, Microsoft Office Interop on August 17, 2009
Background: My company wanted to standardize the email signature for all of the employees. The signature was to contain images and links. Problem: Creating a signature in Microsoft Outlook that contains images and links is not the easiest thing in the world. Not to mention having everyone in the company try to create their own, [...]
Inventory Application
Posted by Eric in .NET 2.0, ASP.NET, Desktop Applications, MS SQL, Web Applications on August 17, 2009
Background: As for any company, physical inventory time is never fun. Our inventory software did not have a good interface for doing this. Problem: The process of taking physical inventory was long and tedious. The process typically involved printing our a huge list of parts, write in the quantity next to the part, then someone [...]
Company Intranet
Posted by Eric in ASP.NET, MS SQL, Web Applications on August 17, 2009
Background: A company I worked for had a new Internet (external) web site built. Problem: We already had a working Intranet (internal) site, but my company wanted to make the Intranet (internal) site to have a similar look and feel of the Internet (external) site. They also wanted it to be more database driven so [...]
Installation Schedule 2.0
Posted by Eric in AJAX, ASP.NET, MS SQL, Web Applications on August 17, 2009
Background: This project had a similar background to the Install Schedule application. We started using a software package called eManage (I worked for this company later and built a mobile web application to interface with their database) to manage several areas of our business. The software has a built in calendar that can be used [...]
Desktop Tools
Posted by Eric in .NET 2.0, Desktop Applications, MS SQL, Web Services on August 17, 2009
Background: I created a single page web page that was set as the background using the Active Desktop function of Windows XP. This web page allowed you to search the employee database for phone numbers or extensions. It also had a section to calculate shipping for certain items my company sells. Problem: Active Desktop started [...]
Custom Conversion Application
Posted by Eric in AJAX, ASP.NET, Desktop Applications, MS SQL, Web Applications, Web Services on August 17, 2009
Background: One of the many things my company does is file room conversions. To make this short and sweet, a file folder may need to be moved to a new location. In the process the folder may need a new label applied to the folder. This is simplistic example of a conversion. A client requested [...]
Cell Phone Usage
Posted by Eric in AJAX, ASP.NET, MS SQL, Web Applications on August 17, 2009
Background: My company uses Sprint as a cellular provider. Paper bills are 300+ pages and arrive in a box. Sprint offers a service to download cell data at the end of each month (for a cost). Problem: Flipping through the bill was very cumbersome and took sometimes several hours. My company wanted an easy way [...]
-
You are currently browsing the archives for the Projects category.
Technologies
