Question SMJ - Save My Job

Toggle sidebar Toggle sidebar
Status
Not open for further replies.
PrabhakaranKaruppaih

PrabhakaranKaruppaih

Distinguished
BANNED
May 18, 2016
188
2
18,585
I recently joined an institution. They have an intranet (just only internet is being shared currently). I am the only software Developer across the entire institute (But many Hardware Engineers are present). I know only to program within a single PC by programming VBA or through any other software tools. Here the requirements are very less and much simpler when comes to a single pc. But my Bosses (Not a single Boss) want me to make an LMS (Leave Management System) available though out the institute. This requirement is also very very simple. The problem is, I never got exposure to a network of PCs so far. Never have touched a server tool like SharePoint server or Microsoft Exchange Server or any other utilities like these.

The requirement is simple:
Employees have to open a webpage (intranet or cloud may be) in a "Browser". It has to show a number (number of available leaves left for them to avail. Nothing else). I know we just need Label control (caption) and change it dynamically after assessing who is operating the PC wherever the browser is being operated.

Please advise...

With Hope,
Prabhakaran
 
Leave calculation is very complex is many counties. There are many different types of leave (sick leave, annual leave, long service leave, etc..). Different leave accumulation rates and formulas. It is usually linked to the payroll system. Which is in turn linked to the accounting and HR systems.

Don't re-invent the wheel. Especially as you clearly don't have existing expertise in this area. Just buy and off the shelf package that is already debugged and already has interfaces into other systems.
 
Just to add:
The requirements are surely not very simple. It is just that your bosses have neglected to document 90% of the requirements.

A few examples from what is probably a list of dozens of things that they have forgotten.
- How to add new employees
- How to remove employees
- How to initially load the starting values of leave
- How to deal with different types of leave (multiple totals per employee)
- How adjust the total when leave is taken
- Formulas to accumulate leave of various types
- Can leave go negative?
- Is the calculation for whole days only, or per hour, or minutes?
- Admin access & functions for HR
- Backups
- Security
- Authentication of the employees
- List of devices that need supporting (e.g. iPhones)
- Synchronisation of data with the payroll system

Your bosses clearly know nothing about software development. You should make it your job to educate them and offer a solution. So start researching premade off the shelf packages, then give them some options to pick from.
 
Last edited:
  • Like
Reactions: PrabhakaranKaruppaih
  1. Built a Query in Ms Access named: "Leave Balance"
  2. Created an asp.net WebForm using vb.net named: "Leaves.aspx"
  3. Dragged a DataGrid control bound it to a datasource leading to: "Leave Balance"
  4. Published it on IIS.
  5. Done :)
 
PrabhakaranKaruppaih said:
  1. Built a Query in Ms Access named: "Leave Balance"
  2. Created an asp.net WebForm using vb.net named: "Leaves.aspx"
  3. Dragged a DataGrid control bound it to a datasource leading to: "Leave Balance"
  4. Published it on IIS.
  5. Done :)
Click to expand...
While I LOVE MS Access, and have built many large applications with it....there are MANY ways for a devious user to do devious things if you're not careful.

And even if you ARE careful.

A long term secretary in my office recently got released from a 4 year jail sentence. With a $1.5 million dollar restitution to pay.
Had been manipulating her work and vacation hours for a decade.
 
  1. Built a Query in Ms Access named: "Leave Balance"
  2. Created an asp.net WebForm using vb.net named: "Leaves.aspx"
  3. Dragged a DataGrid control bound it to a datasource leading to: "Leave Balance"
  4. Published it on IIS.
  5. Done :)
What about testing?

Have actual end users gone "hands on"?
 
Ralston18 said:
  1. Built a Query in Ms Access named: "Leave Balance"
  2. Created an asp.net WebForm using vb.net named: "Leaves.aspx"
  3. Dragged a DataGrid control bound it to a datasource leading to: "Leave Balance"
  4. Published it on IIS.
  5. Done :)
What about testing?

Have actual end users gone "hands on"?
Click to expand...
Not so soon. Will take sometime. No Testing needed as for the Access Database is already on production. I just have created a 'Dyno-Static' webpage where user is gonna read how much leave is available for him.
 
Status
Not open for further replies.

TRENDING THREADS

Latest posts

Moderators online

Share this page

COMPANY
RESOURCES
FOLLOW
Top Bottom