added second location to seeds file
adding test batch files
modified sprocs to use location id
modified to use location id
refactored to use multiple locations
removed hack - db connect problem realted to stray sql select in view.