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

Orion - MiniCRM Lightswitch and Azure

By , 19 Jan 2012
 
Prize winner in Competition "LightSwitch Star Contest" (Second Prize level)

Azure.jpg

What does your application (or extension) do? What business problem does it solve?

Orion is a Mini-CRM (That's how I call it). It is based on all my client needs like POS records, service requests, field technicians workload, inventory, inventory tracking, fuel management and operational reports. It's in Spanish because of my client needs.

The features (modules, as I call them) are adapted to the business needs:

  • POS Records (Publicity, Contracts, POS Category Level per Sales)
  • System Requests
  • Service Requests
  • Ticket Cancellations (Cancellations that have been requested of lottery tickets printed on their proprietary terminals)
  • Line Reports (Phone/Internet issues that have been reported to the provider)
  • Inventory/Historical/Tracking Assets
  • Field Technicians/Operator Workload and Rating (Who is the best technician/operator and what is his assignment level)
  • Sales Reports
  • Claims from customers
  • Operational Reports (Weekly reports with charts of all the operations the business has done)
  • Fuel Management (Weekly, Monthly and Yearly)
  • Automated Emails
  • Reports to Outlook

Before Orion, my client used emails, lots of papers and spreadsheets to keep track of from all the POS (more than 700 POS approx). Now with Orion, they have all the business data in one place.They have access from anywhere thanks to Azure and also the control of all the data that comes in and goes out in the business.

It was impossible to them to have such control in the past.

How many Screens and Entities Does this Application Have?

37 Screens and 19 Entities

Orion1.jpg

Orion2.jpg

Orion3.jpg

Orion4.jpg

Orion5.jpg

Orion6.jpg

Did LightSwitch Save your Business Money? How?

Lightswitch saved me a lot of time by reducing the development timeline considerably. Because Lightswitch is very scalable, Orion is rented as SaaS, everytime my client needs a new module, I can build it very quickly and thanks to the fact that my app is deployed in Windows Azure, I don't have to worry about all the infrastucture or support on hardware. As an independent developer, time is money for me. I wouldn't have achieved that by using any other technology by myself only.

How Many Users Does this Application Support?

At the moment, it is supporting 25 users.Technically, it can support as many users as the business asks for.

How Long Did This Application Take to Actually Build using LightSwitch?

I took 2 months developing it by myself. At the beginning, it was designed to run on premises, but then I changed my mind and I thought it was better to publish it as a desktop deploy on Azure. In this way, I could save my client on buying server or licenses and also make my software more profitable as SaaS.

However ORION is always under development, I keep adding features and improving the app for my client.

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?

I used several extensions from third parties vendors due the need for making my application like an affordable CRM with powerful tools:

  • DevExpress Reports
  • Infragistics Net Advantage controls
  • ComponentOne OLAP

How did LightSwitch make your developer life better? Was it faster to build compared to other options you considered?

Lightswitch and Windows Azure made my life easier by enabling me to reach the SaaS market. Now I have one company which trusts in my product, thanks to the quick response to their needs everytime.

A Mini-CRM using Windows Forms would have taken me a LOT of time to develop, debug and maintain. That's why I considered using Lightswitch for my project.

I say Lightswitch is a very innovative tool. It saves us developers a lot of time and headaches when developing CRUD applications. Lightswitch is a symbol of fast-developing tool with quality. Now I use Lightswitch as a framework for rapid-developing business apps.

License

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

About the Author

Julio Iglesias Vázquez
Dominican Republic Dominican Republic
Member
No Biography provided

Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page   
QuestionFound something that could help with thismemberMember 999049315 Apr '13 - 17:12 
This software is very good http://www.reportingsoftware.info/reporting-software-features/latch-on-the-secrets-of-business-efficiency/[^]
GeneralMy vote of 1membercorethor15 Feb '12 - 11:35 
where is the source code ?!
GeneralRe: My vote of 1memberJulio Iglesias Vázquez20 Feb '12 - 2:02 
There is no source code.This submission was for Lightswitch Star Contest and source code was not required.
GeneralMy vote of 5memberajguerra10130 Jan '12 - 7:27 
Phenomenal application very practical ...AJ
GeneralMy vote of 5mvpKanasz Robert20 Jan '12 - 1:51 
Excellent. You've got my 5
GeneralRe: My vote of 5memberJulio Iglesias Vázquez20 Jan '12 - 2:40 
Thank you!!
GeneralMy vote of 5memberErnesto Herrera13 Jan '12 - 5:46 
Disculpa ahora si esta bien
GeneralRe: My vote of 5memberJulio Iglesias Vázquez13 Jan '12 - 5:48 
Smile | :)
QuestionExcelente TrabajomemberErnesto Herrera12 Jan '12 - 12:02 
Excelente Trabajo Julio, muy profesional, algun modo de contactarte? twitter linked o email, gracias y saludos desde venezuela
AnswerRe: Excelente TrabajomemberJulio Iglesias Vázquez13 Jan '12 - 1:23 
Hola,
 
Gracias! Mi correo es jiglesiasvazquez@gmail.com y mi skype julio.iglesias21
Saludos igual! Y no te olvides de votar! =)
AnswerRe: Excelente TrabajomemberJulio Iglesias Vázquez13 Jan '12 - 5:44 
El voto era en el artículo jajaja, no en el mensaje,pero gracias de todas formas =)
Questionsource codememberkiquenet AE11 Jan '12 - 23:19 
where is the source code ? any sample code ? thx
AE

AnswerRe: source codememberJulio Iglesias Vázquez12 Jan '12 - 2:01 
Well I can't release the project due the fact that my app is using 3rd parties controls..so you would need those controls in order to run the project.
 
I shared some example with a member in this thread,you can check it.
QuestionMy 5memberMehdi Gholam7 Jan '12 - 5:07 
Excellent work, my 5!
Its the man, not the machine - Chuck Yeager
If at first you don't succeed... get a better publicist
If the final destination is death, then we should enjoy every second of the journey.

AnswerRe: My 5memberJulio Iglesias Vázquez9 Jan '12 - 1:40 
Thanks!
GeneralMy vote of 5memberPedro Hernández1 Jan '12 - 16:19 
Excellent Work !!!
GeneralRe: My vote of 5memberJulio Iglesias Vázquez2 Jan '12 - 1:28 
Thank you!!
QuestionMy Vote of 5memberDelordson Kallon20 Dec '11 - 8:17 
Love this. Very well done!
AnswerRe: My Vote of 5memberJulio Iglesias Vázquez20 Dec '11 - 8:20 
Thank you!..It's good to know that my work is appreciated.
GeneralRe: My Vote of 5memberHillmann21 Dec '11 - 23:34 
is there any source - code to download ???
GeneralRe: My Vote of 5memberJulio Iglesias Vázquez22 Dec '11 - 2:13 
Well I could release my entire project to the public but in order to debug it people must have the extensions I used.So I think most of them don't have them.
 
So I will share with you some features I write on it.
 
I created a table named Tracking_Logs to keep all the historial per assets(equipment).So everytime an operator assign or remove an asset from a particular POS I save this record on this table for historial purpose.The code is pretty simple :
'Saving Logs
Private Sub Inventories_Inserting(entity As Inventory)
Dim track = Inventory_TrackLogs.AddNew 'I add a new record on the table Inventory_TrackLogs
track.AssignedDate = Date.Now 'Get the date
track.Equipment = entity.Equipment 'Get the Equipment (Asset) in the table Inventory and insert it into Track_Logs.Equipment
track.Type = 0 '0 = Installation
End Sub
You can apply the same example for the other methods.The idea is to fill the table with all the assets historial.
 
Another thing I did was when a user created a repair lab service request for an asset,change the Asset status from "Operational" to "In Repair Lab".The code for this is pretty simple as well :
'Change Equipment.Status_Id = 1
Private Sub Equipment_Issues_Inserting(entity As Equipment_Issue)
Dim UpdatedEntry As Equipment = entity.Equipment
UpdatedEntry.Status_Id = 1 '1 = In Repair Lab Status
End Sub

GeneralRe: My Vote of 5memberJulio Iglesias Vázquez22 Dec '11 - 2:15 
If you are interested in other features let me know Wink | ;)
GeneralRe: My Vote of 5memberHillmann22 Dec '11 - 2:24 
Never mind ok its a problem while you are using 3rd Party Products !
 
Thanks and merry Christmas
Juergen Hillmann
GeneralRe: My Vote of 5memberJulio Iglesias Vázquez22 Dec '11 - 2:32 
Thank you and merry Christmas for you too Smile | :)
GeneralMy vote of 5memberPaulSPatterson20 Dec '11 - 6:39 
Great work Julio!

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

Permalink | Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 19 Jan 2012
Article Copyright 2011 by Julio Iglesias Vázquez
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid