@misc{Shaji, type = {Master Thesis}, author = {Shaji, Anith}, title = {The Implementation and Enhancement of Timesheet Management Process Based on Stored Procedure via .NET}, url = {http://nbn-resolving.de/urn:nbn:de:hbz:1383-opus4-3411}, school = {Hochschule Rhein-Waal}, pages = {81}, abstract = {Stored Procedures perform a significant role in the implementation of complex business logic in the database management system. Web-based application systems that handle a large amount of data with complex calculation and transformation rules, they prove to improve the system efficiency, maintainability, data integrity and reliability to a large extent. This research will attempt to enhance a FoxPro based timesheet management system by implementing a web-driven Relational Database Management System with SQL based stored procedure and user-defined functions for faster and efficient data processing. The thesis explores the issues and the processing stages of the current timesheet management process and develops user-friendly responsive intranet online web-application portal with minimal processing steps. That accomplished by writing the processing logic using stored procedures in association with the user-defined table-valued and scalar-valued function in SQL Server and integrating them with Entity Framework three-tier web application architecture in ASP.NET MVC. The final timesheet booking data generated by the stored procedure is modified to a specific format using SpreadsheetLight, an open source spreadsheet library for the .NET framework for uploading the output booking file on SAP Business ByDesign web portal. Outcomes show that using stored procedures in a comprehensive business application can enhance the application performance by lessening the processing time and processing stages.}, language = {en} }