Skip to content

This is a test for the company so they know how I work.

Notifications You must be signed in to change notification settings

rlucianord/AbsenceTest

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

AbsenceTest

This app have been created as a test: Instructions In the app directory App_Code, ther is a SLQ script, you have to open it and run it on your SQL Server, in the web config file there is a Connection commented, so you then can change it, also if you open the project directly in visual studio, the Data base is attached as localdb and you can develop there, then anyway you have to create an Script and run it in you SQL EXpress or Enterprise Server for the application to run if you want to take it on production enviroment.

Important to know:

From the App_Code Folder

ClDataReturn Is a General class to manage all data return in a table. Connection manage all connected object to SQL. Absence Manage All Absence Data that you are creating or listening It is important to run this app in Visual Studio 2019 or higer

//2020,11/20 22PM

I have change the proyect for it to run with Entity Framework and Object Model Class and Inteface, have added new foltder Interfces for separte the Model from Process. I also have changed the DataBase name, since I had problem with the other DataBase , know the name is DbTest. Also, since gridview work with dataview, datatable, I have done a class for convert a Linq Queryable to a DataTable for bind the gridview when it necessary, because the linq querable and list does not support Pager propertie on gridview.

Changed all WebForm to a new Directory, Called Site, It will work in order like MVC project, just without controller, But Interfaces, Model and View(forms). In webconfig I have used My MSSQL express Server, jus just execute the script from the App_Data that contain Database and Change the Credencials for your MSSQL Express Server

If you want now or in the future, you can create separate proyects for Model (DataObjects), DAL(Data Access Layer), In a big proyect it is recommendated, but since this is a little test I dont see it necesesary

About

This is a test for the company so they know how I work.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published