[![Dimiterdapp](https://img.shields.io/static/v1?label=Github&message=Dimiterdapp&color=%3CCOLOR%3E?style=social&logo=github)](https://github.com/Dimiterdapp)

# webforms-phonebook

This is ASP.Net Web application project with MS Sql database connection

# Features

* Insert Contacts
* Update Contacts
* Delete Contacts
* Paging
* Make Favourites
* Search by first name
* Filters

## Screenshots

![PhonebookIndex](https://user-images.githubusercontent.com/113189861/189528656-4b93a70a-18cf-4e3b-b4a0-033f6dd6c9a6.png)

![PhonebookSecond](https://user-images.githubusercontent.com/113189861/189528813-73874dc1-4497-439c-a587-08d5fd0a93ea.png)

![PhonebookUpdate](https://user-images.githubusercontent.com/113189861/194127757-d2698be3-260c-4706-bc50-7466d159a15b.png)

![PhonebookFilter](https://user-images.githubusercontent.com/113189861/194127882-cc543d4c-6c87-4064-9280-b94d0a3aadc5.png)

### How to Install

* Extract database.rar file
* Open all .sql files and Execute in Microsoft SQL
* Open Phonebook.sln in Visual Studio
* Clean then Rebuild Project/Solution
* Open class DataQuery and modify connection strings

If any problem occur with the insert/update functionality, track ModalControl.ascx.cs file then find insandupd_Click method,
replace Regex patterns with an empty strings and everything should be ready to go.

### Database Files are included in database.rar