Click here to Skip to main content
Click here to Skip to main content

Lightswitch Job Hunter Application

, 19 Jan 2012 CPOL
Rate this:
Please Sign up or sign in to vote.
Job application tracker for those out of work built using Visual Studio Lightswitch 2011.

Job Hunter LS

Introduction

Prove to us that LightSwitch was the best tool for the job! You must answer the following questions in order to qualify:

  1. 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.
  2. 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.

  1. 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.
  2. 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 Excel.
  3. How many users does this application support?
    It is set for one user, but the source code is available for expanding.
  4. 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.
  5. 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 Studio Gallery
  6. 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 kartones.net (Lightswitch 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. Screenshots
Home Screen
Home or "Start" Screen

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.

' Preprocess Query to select only 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))
    ' Today minus 7 days
    Dim DatePlus = Date.Now.AddDays(-7D)
    '  query jobAppliedFors Table that are active and last modified over 7 days ago.
    query = From jobAppliedFors In query
            Where jobAppliedFors.Active = True
            Where jobAppliedFors.DateModified < DatePlus
            Order By jobAppliedFors.DateModified
End Sub

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 tool!

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

stuxstu
Product Manager
United States United States
Hobby coder - VB.NET, C#, and Lightswitch advocate! I am a product manager specializing in data analysis systems for industrial manufacturing.
Follow on   Twitter

Comments and Discussions

 
QuestionInvalid download link for source Pinmemberdatasmith691-Dec-13 8:12 
Questionnot able to compile Pinmemberg_dev16-Mar-13 7:13 
Hello,
 
Thank you for this application. I liked validation prompts, highlighted with blue and I would like to use it in my application, but have no idea, how you created it. Could you, please, help me to find out.
And I'm not able to compile the application, because there are several dependent libraries ( extentions). Where I have to get these extentions from ( like Lightswitch Utilities)?
 
Thanks.
Alla
Question5/5 PinmemberJan Van der Haegen28-Jan-12 8:30 
AnswerRe: 5/5 Pinmemberstuxstu28-Jan-12 10:23 
GeneralMy vote of 5 Pinmemberdefwebserver23-Jan-12 8:35 
GeneralRe: My vote of 5 Pinmemberstuxstu23-Jan-12 8:43 
QuestionMessage PinmemberEric Castellon19-Jan-12 18:14 
AnswerRe: Message Pinmemberstuxstu20-Jan-12 4:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.141220.1 | Last Updated 19 Jan 2012
Article Copyright 2012 by stuxstu
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid