Some website's I've worked on or developed using ASP, ASP.NET, VB.NET, AJAX, T-SQL

So I was looking on craiglist.com looking at possible side jobs for .Net and such. Then got to wondering, how does someone know that I can actually do what they are asking versus someone who's just starting out and just trying to get the work for the money and doesn't really know what they are doing?

Then I got to thinking of all the sites I've worked on and all the internal web applications I've done, back since 1998? But even before then when the "Internet" was all new and everyone made neon color sites in 1994 give or take a year, I was making html static sites...

So note to whoever reads this. I AM NOT A FRONT-END DESIGNER. I am a back-end .net developer. I can make the page work and do what it does, and well.  I can not make the page look pretty and pleasing to the eye.  I can get close to what I think it pretty neat with some new cool Ajax controls, but always best to have someone else, who's sole purpose in life is to make things look good touch the pages I create.

So here we go...  SOME OF the sites I've worked on.  Now these sites, most of them were designed by someone else, I just made them work.

Edit: This page is not in any specific order, I add stuff as I remember.

 

Web TimeKeeper Add-On for Track-It!® Help Desk Management System (2001-2002): When I was at Masonite, we used were using a piece of software called Track-It. At the time it was owned by, and originally coded by, Blue Ocean.  Which later was bought out by Intuit and then re-purchased by Numara Software company.  Well back when Blue Ocean owned it, I had developed an add-on to the Track-It web application version of their helpdesk software that allowed manager to track their employees through the day.  This add-in worked so well that I was able to package it and sell it to a few clients of Blue Oceans. They sold it through be me because they had some clients that wanted this feature but it wasn't included in the product itself.  This product was developed using Classic ASP to provide up-to-the-minute tracking.  I had sold it under the name Digital Goblin, a site a friend and I made for doing side jobs.  Was a really cool app.  Then Track-It upgrade a version and went .NET they were supposed to release an API that never came and so the project faded away.

 

Internal Verizon Web Application OSI Server Support (2005): Worked on an internal application for Verizon that helps manage their servers. Large back-end MSSQL database.  Did a lot of screen scrapping from other internal web app's to consolidate server information.  Lot of cool tools here, links that connect to remote desktops and give you server stats.  Owners of servers and information relating to every server they are in charge of.  Pretty large application, it was started before me, and when I was contracted there for 6 months I slowly add new features and functionality.

 

HostedForYou.Com (2006 - 2008):  Created/Architected site in Classic ASP, integrated into a SQL 2005 backend database and Helm Control Panel for Hosting. Site uses pre-made HTML Design Layout. [Screen Shot Available]

HostedForYouDev (2007 - Present) - (In Progress):  Full ASP.NET 2.0 site with VB.NET code behind.  Using .NET features such as Menu Navigation, User Controls, AJAX, Themes.  Class Library developed for site functions.  SQL 2005 backend database and integrating into Helm Control Panel for Hosting. Site uses pre-made HTML Design Layout.

MastroInvestments.Com (2004 - 2007): Created / Architected full site win Classic ASP and Flash with a SQL 2005 database. Site uses pre-made HTML Design Layout.

CCTampa.Org  (2007 - 2008):  Full ASP.NET 2.0 with VB.NET code behind, utilizing all .NET features such as Menu, Master Pages, Themes, AJAX, Google Maps, SiteMap, User/Role Management and Security. SQL 2005 Back-end database. Design Layout created by Web Designer.

CCTampa

AAASouth.Com (2005 - 2008):  Sure a lot going with this site. Site is originally Classic ASP with a IBM DB2 back-end database. Supporting this site was part of the job, while slowly converting parts of the site over to .NET 2.0, utilizing AJAX, Controltool kit, custom developer classes/modules. Using .NET features such as Menu Navigation, Site Map, Localization for support of Spanish down the road. User Controls, Themes, custom Member Provider for Login and every other .NET feature I could use. Slowly over time the site should become more and more .NET.  Created even a session transfer sub-application to handle Session transfers from Classic to .NET and back.

 

Internal .NET 2.0 Web Application for AAA Auto Club South.Com (2007 - 2008):  This is an all .NET application migrated from 1.1 to 2.0. I handle back-end objects/classes and tie them into front-end pages. It's a three n-tier system, tying into a db2 database. No cool features used here, just straight VB.NET and some creative front-end validation and scripting.

 

ASP Classic PayPal Payment Control for RubyLuster.Com (2005): Developed in Classic ASP a server side script to handle communication to and from PayPal and manipulating an Access database to track paid/unpaid/expired member subscriptions.

 

.NET Gallery Control for RubyLuster.Com (2005):  Developed an ASP.NET 2.0 tool to handle creation of Photo Galleries. Utilizing custom GridViews and DetailView controls using a custom DataObjectSource control. Created back-end class libraries. Used AJAX.

 

Camp-Adventure.Com (2004):  Created/Architected/Designed Simple Classic ASP site no back-end or dynamic data.

CampAdventure

KLMPetroleum.Com (2007): Created/Architected Flash Site Only using pre-made Flash Design template. Tying contact pages to ASP Classic Forms sent via email.

 

GulfCoastTriathlon.Com (1998-2001): Created/Architected/Designed site in Classic ASP. Installed ASP based Forum system, dynamic participant searches and online application. Site was taken over and ported over to PHP.  Site design/content still my original work.

Flash Intro Video for GCT (1998): Developed Intro Flash movie back in Flash 2.0 or 3.0 for GulfCoastTriathlon.Com

 

Internal ASP Classic site for Navy Diving and Salvage Training Center division of the U.S. Navy. (1998-2000): Re-wrote the NDSTC's internal application from an Access Database passed from person to person to a web-based application using Classic ASP with SQL 7.0 back-end.

 

Internal ASP Classic for Masonite.Com - Developed internal Classic ASP web application to handle Masonite's customer service department. (Used to be named Premdor) Tied into MSSQL Server 2000. Application became a Customer Service Warranty Issues/Tracking System.

 

Handled Back-End Contact Form Control for Coupaws.Com (2007):  Tied Contact Us page to a Classic ASP back-end email script.

Assisted on Backend or Frontend Script Changes On:

AffinityFinancialPartners.Com
FlavorsOfRome.Com
HonestWarning.Com
Coupaws.com
MeryManEnviornmental.Com

 So there you have SOME of the websites and projects I've done.  I really can't keep track of it all.

Team Foundation TFS 2010/2008 Deleting / Solving Multiple Workspace Problem

So you're setting up a new Workspace for Team Foundation and you get an error when you try and point a Source Control Project to a local folder that someone else was using as well..... Then you get the error message....

Error: "The working folder ... is already in use by another workspace on this computer"

I ran into this problem setting up a contractor's PC after the previous contractor using that PC had left.

The problem is you can't just go load up and delete workspaces unless your the owner. So in order to solve the problem I had to run a command line command for Team Foundation. Open Visual Studio 200x Command Prompt.

Tf workspace /delete developer05;<domain>\jsmith

 

To get that info I needed the owner name of the workspace and the workspace name. You can do

 

tf workspaces

  

You can find a list of Team Foundation (tf) commands here:

http://msdn2.microsoft.com/en-us/library/z51z7zy0(VS.80).aspx
You can see commands on that MS site, however the two most useful to me in this situation was listing the information, so I could see who was the other person blocking access, and then deleting it.

 

tf workspaces [/owner:ownername] [/computer:computername]
[/server:servername] [/format:(brief|detailed)]
 


tf workspace /delete [/server:servername] workspacename[;workspaceowner]

Note: Common mistake is to forget the domain name of the owner if you are on a domain. <domain>\UserName

 

Update:

So you’ve swtiched to a new machine or OS because your other system crashed and now you have these ghost items checked out in TFS and can’t check them in?

Easy.

First on TFS server, list the worksspaces for that old computer name (It tells you in Source Control Who and what PC has it checked out)

tf workspaces /server:http://…/Project/  /computer:mastro-pc

This will give you the list of workspaces:

 

Workspace                          Owner   Computer  Comment
---------------------------------- ------- --------- --------------------------
MASTRO-PC                          FMastro MASTRO-PC
SQL Source Control  (eb0jrdmq.4mh) FMastro MASTRO-PC Used by SQL Source Control
SQL Source Control  (ge1lsqh5.3gk) FMastro MASTRO-PC Used by SQL Source Control
SQL Source Control  (hewpvhe2.wai) FMastro MASTRO-PC Used by SQL Source Control
SQL Source Control  (vqdacg1f.bgr) FMastro MASTRO-PC Used by SQL Source Control
WIM 2010 (MASTRO-PC)               FMastro MASTRO-PC

 

Now go in and delete each one.

tf workspace /delete /sever:http://…/Project/ “MASTRO-PC”
tf workspace /delete /sever:http://…/Project/ “SQL Source Control  (eb0jrdmq.4mh)”
tf workspace /delete /sever:http://…/Project/ “WIM 2010 (MASTRO-PC)”
etc..

That will clear our those old changes you had on the no longer existent system.

VB.Net Strip Numeric Characters from an Alpha-Numeric String

I see it everywhere, people with blogs posting up ASP.NET/VB.NET code snippets.  At work I'm always asked to create a quick function how to do something. Or someone will say, "how do I do this?" and I can't help myself but write out the code real quick.  So I thought why not me? Why don't I start putting up my own code on my own blog?  So here I am.

So my first piece of code is super simple, just strips out numeric characters from an alpha-numeric string.  Now maybe there's already a built-in method in .Net that does this already, but .Net is so full of methods and namespaces and such that I don't know them all. 

So here we begin a new blog theme.

   1: ''' <summary>
   2: ''' Strips out Numeric characters from a Alpha-Numeric String
   3: ''' </summary>
   4: ''' <param name="HotStripper">Send Alpha-Numeric String</param>
   5: ''' <returns>String</returns>
   6: Function StringOutNumbers(ByVal HotStripper As String) As String
   7:      Dim NewValue As String = ""
   8:      For I As Integer = 0 To HotStripper.Length - 1
   9:           If IsNumeric(HotStripper.Substring(I, 1)) = False Then
  10:                NewValue += HotStripper.Substring(I, 1)
  11:           End If
  12:      Next
  13:      Return NewValue
  14: End Function

Example:

Dim myString As String = StringOutNumbers("Something1234")

 

 

Note: If you wanted only to pull out the numbers you could just change line 9, from False to True.

Am I a good programmer?

I came across an article just the other day where this guy Daniel writes about how to recognize a good programmer. In this article he lists some bullet points on how to tell....

 Positive indicators:

  • Passionate about technology
  • Programs as a hobby
  • Will talk your ear off on a technical subject if encouraged
  • Significant (and often numerous) personal side-projects over the years
  • Learns new technologies on his/her own
  • Opinionated about which technologies are better for various usages
  • Very uncomfortable about the idea of working with a technology he doesn’t believe to be “right”
  • Clearly smart, can have great conversations on a variety of topics
  • Started programming long before university/work
  • Has some hidden “icebergs”, large personal projects under the CV radar
  • Knowledge of a large variety of unrelated technologies (may not be on CV)

Negative indicators:

  • Programming is a day job
  • Don’t really want to “talk shop”, even when encouraged to
  • Learns new technologies in company-sponsored courses
  • Happy to work with whatever technology you’ve picked, “all technologies are good”
  • Doesn’t seem too smart
  • Started programming at university
  • All programming experience is on the CV
  • Focused mainly on one or two technology stacks (e.g. everything to do with developing a java application), with no experience outside of it

... so naturally I started to see which ones apply to me.  What in this list would define where I stand? As I started to look at the list it made sense and actually I could see it applied to someone one else I know who always wants to be a better programmer but lacks some of the bullets from the first part.

As I read the bullets, everyone one of the positive bullets matched with me, only one of the negatives I felt matched as well.  The last one about technology stacks.  At first I thought that contradicted learning new technologies from the first one but it doesn't.  Example, I learned AJAX, I'm learning Silverlight, those are new technologies. I am stacking the technology because I'm using everything with VB.NET.  That's what I feel I stack.  I can read C# but slower to code in it then VB and ususaly when I want to get something done I default to VB.NET because I already know it's full sytax.

Anyway, it was an interesting read.

My Birthday Weekend

Well it's my birthday weekend and I thought about going out to party, but then I came down with a cold and now I don't feel like doing anything.  Would be nice if I had some local friends that could plan a party for myself.  However, they are all up in New Jersey or down in Miami. 

 Happy Birthday to me!