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 ILayerSQL
    {
        /// <summary>
        /// Method to add new member
        /// </summary>
        /// <param name="layer">club member model</param>
        /// <returns>true or false</returns>
        bool AddLayer(LayerModel layer);

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

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

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

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

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

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

        /// <summary>
        /// Method to update layer
        /// </summary>
        /// <param name="layer">layer</param>
        /// <returns>true / false</returns>
        bool UpdateLayer(LayerModel layer);

        /// <summary>
        /// Method to delete member
        /// </summary>
        /// <param name="layer">club member model</param>
        /// <returns>true or false</returns>
        bool DeleteLayer(LayerModel layer);

        /// <summary>
        /// Service method to get project by Id
        /// </summary>
        /// <param name="id">project id</param>
        /// <returns>Data row</returns>
        DataRow GetColorProfileByLayerId(int layerId);

        /// <summary>
        /// Method to delete member
        /// </summary>
        /// <param name="layer">club member model</param>
        /// <returns>true or false</returns>
        bool DeleteColorProfile(LayerModel layer);
    }
}