示例#1
0
        public ClientAuth GetClientDetails(int clientId)
        {
            ClientAuth clientObj = new ClientAuth();

            StringBuilder sb = new StringBuilder("SELECT CL.*,CLAU.* FROM CLIENT CL JOIN CLIENTAUTHENTICATION CLAU ON CL.CLIENTID=CLAU.CLIENTID WHERE CL.CLIENTID = @ClientId");

            if (ClientDA.GetClientDetails(clientId, sb.ToString(), clientObj))
            {
                return(clientObj);
            }
            else
            {
                return(null);
            }
        }