import { query } from '../config/database';

export const generateLeadId = async (): Promise<string> => {
    const result = await query('SELECT generate_lead_id() as lead_id');
    return result.rows[0].lead_id;
};

export const generateFileNumber = async (): Promise<string> => {
    const result = await query('SELECT generate_file_number() as file_number');
    return result.rows[0].file_number;
};
