develop an application to calculate the SLA deadline of a captured complaint based on the configured working hours. When a complaint is captured it should have a maximum time to get resolved. Some low priority complaints can have 24 hours but some high
priority complaints can have 4 hours to be resolved. All hours are business hours. For this reason you are expected to develop a database structure to store operating hours and business closures such as weekends, national and religious holidays. If a complaint
is captured just before a national holiday, since we are counting for business hours only it should skip the non working hours during the national holiday. The requirements are as follows: 1) The application should be a web based application using a SQL server
database for configuration of working days, hours and business closures such as national holidays. 2) Application input screen should have the following fields a. Complaint priority type, drop down b. Case capture date and time (eg. 12 Nov 2006, 15:23) 3)
Application should output the following: a. The expected case resolution time considering the configured business hours 4) To save time you should NOT build a configuration screens but instead have database tables for a. Configuring weekends b. Configuring
working hours c. Configuring other business closures because of national holidays, special events etc d. Please be aware that business closures can be full day as well as couple of hours during a specific day
Journey Man
