cityssm/lottery-licence-manager

import { runSQL } from "./_runSQL.js";
export const updateOrganizationRepresentative = (organizationID, requestBody) => {
    runSQL("update OrganizationRepresentatives" +
        " set representativeName = ?," +
        " representativeTitle = ?," +
        " representativeAddress1 = ?," +
        " representativeAddress2 = ?," +
        " representativeCity = ?," +
        " representativeProvince = ?," +
        " representativePostalCode = ?," +
        " representativePhoneNumber = ?," +
        " representativePhoneNumber2 = ?," +
        " representativeEmailAddress = ?" +
        " where organizationID = ?" +
        " and representativeIndex = ?", [
        requestBody.representativeName, requestBody.representativeTitle,
        requestBody.representativeAddress1, requestBody.representativeAddress2,
        requestBody.representativeCity, requestBody.representativeProvince, requestBody.representativePostalCode,
        requestBody.representativePhoneNumber, requestBody.representativePhoneNumber2, requestBody.representativeEmailAddress,
        organizationID, requestBody.representativeIndex
    ]);
    const representativeObject = {
        organizationID,
        representativeIndex: requestBody.representativeIndex,
        representativeName: requestBody.representativeName,
        representativeTitle: requestBody.representativeTitle,
        representativeAddress1: requestBody.representativeAddress1,
        representativeAddress2: requestBody.representativeAddress2,
        representativeCity: requestBody.representativeCity,
        representativeProvince: requestBody.representativeProvince,
        representativePostalCode: requestBody.representativePostalCode,
        representativePhoneNumber: requestBody.representativePhoneNumber,
        representativePhoneNumber2: requestBody.representativePhoneNumber2,
        representativeEmailAddress: requestBody.representativeEmailAddress,
        isDefault: Number(requestBody.isDefault) > 0
    };
    return representativeObject;
};