Summary

Contains generated LoginDAO class. This is part of Troika.ASP Framework - web development MVC framework for ASP 3.0. Please visit www.troika-asp.com for more details.

Version: $Revision: 1.4 $

Author: Pavel Chuchev pav@troika-asp.com

/**
* @fileoverview Contains generated <tt>LoginDAO</tt> class.
*
* 
* This is part of Troika.ASP Framework - web development MVC framework for ASP 3.0.
* Please visit {@link http://www.troika-asp.com www.troika-asp.com} for more details.
* 
*
* @author Pavel Chuchev pav@troika-asp.com
* @version $Revision: 1.4 $
*/
LoginDAO.prototype =  new Ado();
LoginDAO.prototype.constructor = LoginDAO;
/**
* @constructor
*/
function LoginDAO(connectionString) {

    if (arguments.length) {

        this.init(connectionString);
    }
}

LoginDAO.prototype.init = function (connectionString) {

    Ado.prototype.init.call(this, connectionString);
    return this;
};

LoginDAO.prototype.update = function (loginVO) {

    var conn = this.getConnection();
    try {

        var cmd =  new ActiveXObject("ADODB.Command");

        cmd.ActiveConnection = conn;
        cmd.CommandText = "UPDATE login SET MemberId = ?,Username = ?,Pwd = ?,SecurityRole = ?,SecretInfo = ? WHERE LoginId = ?";

        loginVO.flatten();

        cmd.Parameters.Append(cmd.CreateParameter("MemberId", adInteger, adParamInput, 1, parseInt(loginVO.memberId ? loginVO.memberId : 0, 10)));

        cmd.Parameters.Append(cmd.CreateParameter("Username", adVarChar, adParamInput, 25, loginVO.username.substring(0, 25)));

        cmd.Parameters.Append(cmd.CreateParameter("Pwd", adVarChar, adParamInput, 20, loginVO.password.substring(0, 20)));

        cmd.Parameters.Append(cmd.CreateParameter("SecurityRole", adVarChar, adParamInput, 10, loginVO.securityRole.substring(0, 10)));

        cmd.Parameters.Append(cmd.CreateParameter("SecretInfo", adVarChar, adParamInput, 80, loginVO.secretInfo.substring(0, 80)));

        cmd.Parameters.Append(cmd.CreateParameter("LoginId", adInteger, adParamInput, 1, parseInt(loginVO.loginId, 10)));

        cmd.Execute();
    }
    finally {

        conn.Close();
    }
};

LoginDAO.prototype.findByLoginId = function (loginVO, recordCount) {

    if (this.getObjectName(loginVO) != "LoginVO") {

        var loginId = arguments[0];
        loginVO =  new LoginVO();

        loginVO.loginId = loginId;

        if (arguments.length > 1) {

            recordCount = arguments[arguments.length - 1];
        }
        else {

            recordCount = undefined;
        }
    }

    var result = undefined;

    var conn = this.getConnection();
    try {

        var cmd =  new ActiveXObject("ADODB.Command");
        cmd.ActiveConnection = conn;

        cmd.CommandText = "SELECT * FROM login WHERE LoginId = ?";

        loginVO.flatten();

        cmd.Parameters.Append(cmd.CreateParameter("LoginId", adInteger, adParamInput, 1, parseInt(loginVO.loginId, 10)));

        var rs = cmd.Execute();

        if (recordCount) {

            result =  new ArrayList();
        }

        var count = 0;

        var returnAll = recordCount && recordCount == "all";
        var returnTop = recordCount && !returnAll ? parseInt(recordCount, 10) : 1;

        while (!rs.EOF && (returnAll || count < returnTop)) {

            var record =  new LoginVO();

            record.loginId = rs.Fields("LoginId").Value;

            record.memberId = rs.Fields("MemberId").Value;

            record.username = rs.Fields("Username").Value;

            record.password = rs.Fields("Pwd").Value;

            record.securityRole = rs.Fields("SecurityRole").Value;

            record.secretInfo = rs.Fields("SecretInfo").Value;

            rs.MoveNext();
            count++;

            if (recordCount) {

                result.add(record);
            }
            else {

                result = record;
            }
        }

    }
    finally {

        conn.Close();
    }

    return result;
};

LoginDAO.prototype.findByUsernameAndPassword = function (loginVO, recordCount) {

    if (this.getObjectName(loginVO) != "LoginVO") {

        var username = arguments[0];

        var password = arguments[1];
        loginVO =  new LoginVO();

        loginVO.username = username;
        loginVO.password = password;

        if (arguments.length > 2) {

            recordCount = arguments[arguments.length - 1];
        }
        else {

            recordCount = undefined;
        }
    }

    var result = undefined;

    var conn = this.getConnection();
    try {

        var cmd =  new ActiveXObject("ADODB.Command");
        cmd.ActiveConnection = conn;

        cmd.CommandText = "SELECT * FROM login WHERE Username = ? AND Pwd = ?";

        loginVO.flatten();

        cmd.Parameters.Append(cmd.CreateParameter("Username", adVarChar, adParamInput, 25, loginVO.username.substring(0, 25)));

        cmd.Parameters.Append(cmd.CreateParameter("Pwd", adVarChar, adParamInput, 20, loginVO.password.substring(0, 20)));

        var rs = cmd.Execute();

        if (recordCount) {

            result =  new ArrayList();
        }

        var count = 0;

        var returnAll = recordCount && recordCount == "all";
        var returnTop = recordCount && !returnAll ? parseInt(recordCount, 10) : 1;

        while (!rs.EOF && (returnAll || count < returnTop)) {

            var record =  new LoginVO();

            record.loginId = rs.Fields("LoginId").Value;

            record.memberId = rs.Fields("MemberId").Value;

            record.username = rs.Fields("Username").Value;

            record.password = rs.Fields("Pwd").Value;

            record.securityRole = rs.Fields("SecurityRole").Value;

            record.secretInfo = rs.Fields("SecretInfo").Value;

            rs.MoveNext();
            count++;

            if (recordCount) {

                result.add(record);
            }
            else {

                result = record;
            }
        }

    }
    finally {

        conn.Close();
    }

    return result;
};