import com.bookmobile.ampersandlaunch.beans.User;

component displayName="UserService" extends="Service" {

	public function init(required string dsn) {

		super.init(argumentCollection=arguments);
		instance.dsn = arguments.dsn;
	}

	public User function getUser(string username="", string password="") {

		local.user =  new User();

		if( len(arguments.username) gt 0 and len(arguments.password) gt 0) {

			local.qs = new query();

			qs.setDatasource(instance.dsn);
			qs.addParam("username", value=arguments.username, cfsqltype="varchar");
			qs.addParam("password", value=arguments.password, cfsqltype="varchar");

			local.sql = "
				SELECT
					E.username
				FROM
					Employees E
				WHERE
					E.username = :username AND
					E.password = :password
			";

			local.result = qs.execute(sql);

			if( result.recordCount eq 1 ) {

				user.setUsername(result.username);
			}
		}

		return user;
	}
}