package com.service;

import com.entity.Project;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.sql.SQLException;
import java.util.List;

/**
 *
 * Interface service for the project.
 *
 * @author Laurentiu Marcut
 */
@Service
public interface ProjectService {

    /**
     *
     * Select all projects.
     *
     * @param member
     * @return projects
     * @throws SQLException
     */
    @Transactional
    List<Project> selectAll(String member) throws SQLException;

    /**
     *
     * Insert project.
     *
     * @param project
     * @param createdBy
     * @param role
     * @throws SQLException
     */
    @Transactional
    void insert(String project, String createdBy, String role) throws SQLException;

    /**
     *
     * Delete project.
     *
     * @param project
     * @throws SQLException
     */
    @Transactional
    void delete(String project) throws SQLException;

}
