Hello guys, welcome to the 23rd session on the SP dotnet VBA. In this lesson, we will learn how to establish the basic authentication for the our VBA. For that I have already created the employee table, which has the three fields ID name and the department department can be development or testing, and a user table, which has three field ID username and a password, and a two dummy user that our developer and the petitioner if logged in users available, then it must be able to see the only employee from the department development and if it's additional than it must be able to see only the employee from the testing. All that let's reissue the Visual Studio on the new project. Select the VBA I'm using the nmp 23 underscore Basic auth I enter. I'm going to use the VBA Hello project is created, open the solisten.

Right click on the solution, the new project select here class library name, employee data access that will contain the entity model for the API. Let's delete that class. Right click, select the Add New Item select the data add entity model employee model We are going to design from the database click on new connection write the SQL Server Name select the database click on Test Connection test was succeeded okay and change the name of do or entity that is a employee entity. Click on Next select the 6.0 and select the table that you want to use with the entity. We are going to use the employees and the user table and change the name of the model that is a employee and click on Finish. Here is our entity That was created.

Now we need to add a reference to that our entity project from the our VBA. Select the project and choose the employee data access. Within the our API project, right click and select a new ad class within a wall for user security this class content the method for the user security that is the login. Let's create a public static bool. login and pass the sharing user name and shame Boss Ward has a parameter it's a login and we need to use the using statement and the employee employee entities which was present in a different interest. So first of all we need to imported employee entities entities equal to new employee entities and the written entities dot users dot any Users such as tat user dot user name, dot equals username that passing the parameter and we are going to compare those user name without the comparing case.

And user dot password dot equals the password that plus in the parameter and a semicolon. Let's create a controller for our employee controller. Select the VBA to empty controller with DNA employee within that we will create our get method public I shoot up response message on which we use the using statement using employee and the DS which was present in a different namespace, so we are going to add it and the DS equal to new employee entities. And first of all we need to retrieve the logged in user name. For that we are using the machine user name equal to pi this example I'm going to use the question value that is down low but later we will change it to A dynamic way and we need to use the I enumerable. of type employee list of employees equal to null initially and based on the logged in user we will resubmit it the user name dot equals because they have low power then list of all employees call to entities dot employees dot where EMP such a tat EMP dot department dot equals the barrel of pain converted to the to least Sam apply for the testers use the LCFF and change to the district and use the testing as a department name.

And at the end we're going to return a request, though, to the response with the HTTP status code, okay, and the our list of all employees let's copy the connection string from the data access layer. Copy and paste it into the IP config connection single section. And from the VBA config, we need to comment the authentication setting Ctrl k C, and let's run it and open the our API page. That is the API slash as employee. You can see that it returned the all of the three developers If we modify the developer to the tester, then it will return the all of the tester from the database. In this as we created a new project of the mvpa, create the new entity model and add the entity model reference to the our VBA project and create a controller that will return the list of the employees based on the condition as well as the created user security class which contains one static method that is a login which takes a username and a password, which will return the boolean value based on the path username and the password are valid as per the database or not.

Thanks for watching. If you have any doubt, feel free to contact me