<cfcomponent>

    <!------- Query to update form.editSubmit if defined *editdetail.cfm---->
    <cffunction name="updateTblBirthdays" returntype="void">
        <cfargument name="empName" default="" required="true">
        <cfargument name="birthDate" default="" required="true">
        <cfargument name="bid" default="" required="true">
        <cfquery datasource="dsnDB3-dev">
            UPDATE tblBirthdays
            SET empName = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.empName#">,
            birthDate = <cfqueryparam cfsqltype="cf_sql_date" value="#arguments.birthDate#">
            WHERE bid = <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.bid#">
        </cfquery>
        <cfreturn />
    </cffunction>

    <!------- Query to get list of users to populate dropdown list (SQL) *edit.cfm & *editdetail.cfm---->
    <cffunction name="getBirthdayReport" returntype="query">
        <cfargument name="locId" required="false">
        <cfargument name="bid" required="false">
        <cfset var local = {}>
        <cfquery name="local.birthdayReport" datasource ="dsnDB3-dev">
            SELECT empName, birthDate, bid
            From tblBirthdays
            WHERE 0=0
            <cfif IsNumeric(arguments.locId)>
                AND locId = <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.locId#">
            </cfif>
            <cfif IsNumeric(arguments.bid) AND structkeyexists(arguments, "bid")>
                AND bid = <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.bid#">
            </cfif>
            ORDER BY birthdate
        </cfquery>
        <cfreturn local.birthdayReport />
    </cffunction>


    <!------- Delete Current Data *index.cfm---->
    <cffunction name="deleteTblBirthdays" returntype="void">
        <cfquery datasource="dsnDB3-dev">
                DELETE FROM tblBirthdays
        </cfquery>
        <cfreturn />
    </cffunction>

    <!------- Insert Sorted Data *index.cfm---->
    <cffunction name="insertBirthday" returntype="void">
    <cfargument name="empName" default="" required="true">
    <cfargument name="locId" default="0" required="true">
    <cfargument name="birthDate" default="" required="true">
        <cfquery datasource="dsnDB3-dev">
            INSERT INTO tblBirthdays(empName, locID, BirthDate)
            VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.empName#">,
            <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.locId#">,
            <cfqueryparam cfsqltype="cf_sql_date" value="#arguments.birthDate#">
            )
        </cfquery>
    <cfreturn />
    </cffunction>


</cfcomponent>