3tier is organized in to three layers
These layers are described below.
1. Application layer or Business layer
2. Business layer
a. Property layer(Sub layer of business layer)
3. data layer
Your authorization check is a functionality. you can send the user inputs in to Busiesslayer where you can do some validation [if required] on the inputs and send that inputs to function which written in Data layer. Data layer connects with Db and calls the stored procedure and return result.
1.Create stored procedure which returns 0 or 1 or true or false based on the input - if usr found 1 else 0 some thig like that..
2.Get that value to the dataaccess layer function and return that value all the way to presentation layer.
3.In the presentation layer, use that value and reply message to user saying user invalid or valid.
let us know if not working.
Saritha.rajeshkumar, if this helps please login to Mark As Answer. | Alert Moderator