Summary

Contains generated MemberDAO 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>MemberDAO</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 $
*/
MemberDAO.prototype =  new Ado();
MemberDAO.prototype.constructor = MemberDAO;
/**
* @constructor
*/
function MemberDAO(connectionString) {

    if (arguments.length) {

        this.init(connectionString);
    }
}

MemberDAO.prototype.init = function (connectionString) {

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

MemberDAO.prototype.insert = function (memberVO) {

    var conn = this.getConnection();
    try {

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

        cmd.ActiveConnection = conn;
        cmd.CommandText = "INSERT INTO member (FirstName,Surname,Age) VALUES ( ?,?,? ) ";

        memberVO.flatten();

        cmd.Parameters.Append(cmd.CreateParameter("FirstName", adVarChar, adParamInput, 25, memberVO.firstName.substring(0, 25)));

        cmd.Parameters.Append(cmd.CreateParameter("Surname", adVarChar, adParamInput, 30, memberVO.lastName.substring(0, 30)));

        cmd.Parameters.Append(cmd.CreateParameter("Age", adInteger, adParamInput, 1, parseInt(memberVO.age ? memberVO.age : 0, 10)));

        cmd.Execute();
    }
    finally {

        conn.Close();
    }
};

MemberDAO.prototype.update = function (memberVO) {

    var conn = this.getConnection();
    try {

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

        cmd.ActiveConnection = conn;
        cmd.CommandText = "UPDATE member SET FirstName = ?,Surname = ?,Age = ? WHERE MemberId = ?";

        memberVO.flatten();

        cmd.Parameters.Append(cmd.CreateParameter("FirstName", adVarChar, adParamInput, 25, memberVO.firstName.substring(0, 25)));

        cmd.Parameters.Append(cmd.CreateParameter("Surname", adVarChar, adParamInput, 30, memberVO.lastName.substring(0, 30)));

        cmd.Parameters.Append(cmd.CreateParameter("Age", adInteger, adParamInput, 1, parseInt(memberVO.age ? memberVO.age : 0, 10)));

        cmd.Parameters.Append(cmd.CreateParameter("MemberId", adInteger, adParamInput, 1, parseInt(memberVO.memberId, 10)));

        cmd.Execute();
    }
    finally {

        conn.Close();
    }
};

MemberDAO.prototype.deleteById = function (id) {

    var conn = this.getConnection();
    try {

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

        cmd.ActiveConnection = conn;
        cmd.CommandText = "DELETE FROM member WHERE MemberId = ?";

        cmd.Parameters.Append(cmd.CreateParameter("MemberId", adInteger, adParamInput, 1, id));

        cmd.Execute();
    }
    finally {

        conn.Close();
    }
};

MemberDAO.prototype.findByMemberId = function (memberVO, recordCount) {

    if (this.getObjectName(memberVO) != "MemberVO") {

        var memberId = arguments[0];
        memberVO =  new MemberVO();

        memberVO.memberId = memberId;

        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 member WHERE MemberId = ?";

        memberVO.flatten();

        cmd.Parameters.Append(cmd.CreateParameter("MemberId", adInteger, adParamInput, 1, parseInt(memberVO.memberId, 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 MemberVO();

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

            record.firstName = rs.Fields("FirstName").Value;

            record.lastName = rs.Fields("Surname").Value;

            record.age = rs.Fields("Age").Value;

            rs.MoveNext();
            count++;

            if (recordCount) {

                result.add(record);
            }
            else {

                result = record;
            }
        }

    }
    finally {

        conn.Close();
    }

    return result;
};

MemberDAO.prototype.findByFirstName = function (memberVO, recordCount) {

    if (this.getObjectName(memberVO) != "MemberVO") {

        var firstName = arguments[0];
        memberVO =  new MemberVO();

        memberVO.firstName = firstName;

        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 member WHERE FirstName = ?";

        memberVO.flatten();

        cmd.Parameters.Append(cmd.CreateParameter("FirstName", adVarChar, adParamInput, 25, memberVO.firstName.substring(0, 25)));

        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 MemberVO();

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

            record.firstName = rs.Fields("FirstName").Value;

            record.lastName = rs.Fields("Surname").Value;

            record.age = rs.Fields("Age").Value;

            rs.MoveNext();
            count++;

            if (recordCount) {

                result.add(record);
            }
            else {

                result = record;
            }
        }

    }
    finally {

        conn.Close();
    }

    return result;
};

MemberDAO.prototype.findByFirstNameAndLastName = function (memberVO, recordCount) {

    if (this.getObjectName(memberVO) != "MemberVO") {

        var firstName = arguments[0];

        var lastName = arguments[1];
        memberVO =  new MemberVO();

        memberVO.firstName = firstName;
        memberVO.lastName = lastName;

        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 member WHERE FirstName = ? AND Surname = ?";

        memberVO.flatten();

        cmd.Parameters.Append(cmd.CreateParameter("FirstName", adVarChar, adParamInput, 25, memberVO.firstName.substring(0, 25)));

        cmd.Parameters.Append(cmd.CreateParameter("Surname", adVarChar, adParamInput, 30, memberVO.lastName.substring(0, 30)));

        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 MemberVO();

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

            record.firstName = rs.Fields("FirstName").Value;

            record.lastName = rs.Fields("Surname").Value;

            record.age = rs.Fields("Age").Value;

            rs.MoveNext();
            count++;

            if (recordCount) {

                result.add(record);
            }
            else {

                result = record;
            }
        }

    }
    finally {

        conn.Close();
    }

    return result;
};

MemberDAO.prototype.searchMembersByAge = function (memberVO, recordCount) {

    if (this.getObjectName(memberVO) != "MemberVO") {

        var age = arguments[0];
        memberVO =  new MemberVO();

        memberVO.age = age;

        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 member WHERE Age = ? ORDER BY Age ASC";

        memberVO.flatten();

        cmd.Parameters.Append(cmd.CreateParameter("Age", adInteger, adParamInput, 1, parseInt(memberVO.age ? memberVO.age : 0, 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 MemberVO();

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

            record.firstName = rs.Fields("FirstName").Value;

            record.lastName = rs.Fields("Surname").Value;

            record.age = rs.Fields("Age").Value;

            rs.MoveNext();
            count++;

            if (recordCount) {

                result.add(record);
            }
            else {

                result = record;
            }
        }

    }
    finally {

        conn.Close();
    }

    return result;
};