Prove to us that LightSwitch was the best tool for the job! You must answer the following questions in order to qualify:
- What does your application/extension do? What business problem does it solve?
The application allows those who are searching for work to track
job applications. Those of us who are unemployed might need to track dozens of
job applications and ensure we are following up on our applications. Ensuring
timely follow-ups will separate you from the pack.
- How many screens and entities does this application have?
The Job Hunter application has 10 screens, 3 entities, and 4 queries.
Additionally answer as many questions below to improve your chances to win.
- Did LightSwitch save your business money? How?It is not
a business application, but a get yourself back to business application. It will
save your bank account, by helping get back to work sooner.
- Would this application still be built if you didn’t have LightSwitch? If yes, with what?
Yes, I would have built it with WinForms, WPF, and an Access database or maybe
- How many users does this application support?
It is set
for one user, but the source code is available for expanding.
- How long did this application take to actually build using LightSwitch?
The program took about 15 hours to build, but I was learning Lightswitch at the time. I could build it in as little as three hours now.
- Does this application use any LightSwitch extensions? If so, which ones? Did you write any of these extensions yourself? If so, is it available to the public? Where?
The application uses the freely available controls; including Bing Maps
Lightswitch control, Web Address Type by Alessandro Del Sole, and the Office
Black and Silver Theme by Cromanty. All controls are available from the Visual
- How did LightSwitch make your developer life better? Was it faster to build compared to other options you considered?
Using Ligthswitch made building the application dramatically faster. I could
experiment and find the best way to build the application. It also allowed me to
try several variations of deployment, before beginning use.
There is one
part that I hope to finish in the near future. A complete installer as described
by Vincent at
Installer). This would be optimal to help someone who knows little about
installing a DB.
Links, Screenshots, Videos
Demo video of application can be view here.
Company List Detail - Company information
Company List Detail - Job Application and follow-up information
Company List Detail - Bing Map of where company is located
Follow-up Screen - "Active" job applications that have not been updated (modified) in more than 7 days.
Applications This Week - For US unemployment you need to fill out who you've applied to.
Other screen are search - All, Active, and Inactive.
A neat little bit of code I had to learn to create the LINQ query to look up active jobs that have not been modified in over 7 days.
<br />Private Sub FollowUpDue_PreprocessQuery(ByRef query As System.Linq.IQueryable(Of LightSwitchApplication.JobAppliedFor))
Dim DatePlus = Date.Now.AddDays(-7D)
query = From jobAppliedFors In query
Where jobAppliedFors.Active = True
Where jobAppliedFors.DateModified < DatePlus
Order By jobAppliedFors.DateModified
Points of Interest
Did you learn anything interesting/fun/annoying while writing the your application? Did you do anything particularly clever or wild or zany?
One thing I did learn is how to create basic LINQ queries and how to better
create a database. Building this application really has helped me understand how
to better understand development. LightSwitch reduces the initial learning curve
of database development and I would recommend it to anyone who wants to learn
more about software development. It should be used in school as a learning