using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Data.DataAccess
{
    using System.Data;
    using Data.DataModel;

    interface IProjectSQL
    {
        /// <summary>
        /// Method to add new member
        /// </summary>
        /// <param name="project">club member model</param>
        /// <returns>true or false</returns>
        bool AddProject(ProjectModel project);

        /// <summary>
        /// Method returns last created project Id
        /// </summary>
        /// <returns>Project Id</returns>
        DataRow GetLastProject();

        /// <summary>
        /// Method to get all club members
        /// </summary>
        /// <returns>Data table</returns>
        DataRow GetProjectById(int Id);

        /// <summary>
        /// Method to get all club members
        /// </summary>
        /// <returns>Data table</returns>
        DataRow GetProjectByName(string Name);

        /// <summary>
        /// Method to get all club members
        /// </summary>
        /// <returns>Data table</returns>
        DataTable GetAllProjects();

        /// <summary>
        /// Get count of layers
        /// </summary>
        /// <returns>int</returns>
        int GetCountOfLayers(int projectId);

        /// <summary>
        /// Get count of layers
        /// </summary>
        /// <returns>int</returns>
        DataTable GetProjectLayers(int projectId);

        /// <summary>
        /// Method to update project
        /// </summary>
        /// <param name="project">project</param>
        /// <returns>true / false</returns>
        bool UpdateProjectDefault(ProjectModel project);

        /// <summary>
        /// Method to update project
        /// </summary>
        /// <param name="project">project</param>
        /// <returns>true / false</returns>
        bool UpdateProject(ProjectModel project);

        /// <summary>
        /// Method to update project
        /// </summary>
        /// <param name="project">project</param>
        /// <returns>true / false</returns>
        bool UpdateProjectOutPath(int projectId, string outPath); //UpdateProject(project);

        /// <summary>
        /// Method to delete project
        /// </summary>
        /// <param name="projectId">project Id</param>
        /// <returns>true or false</returns>
        bool DeleteProject(int projectId);

        /// <summary>
        /// Method to delete project
        /// </summary>
        /// <param name="projectId">project Id</param>
        /// <returns>true or false</returns>
        bool DeleteProjectLayers(int projectId);

        /// <summary>
        /// Method to delete project
        /// </summary>
        /// <param name="projectId">project Id</param>
        /// <returns>true or false</returns>
        bool DeleteProjectColorProfiles(int projectId);
    }
}