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

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

    interface IProgressSQL
    {
        /// <summary>
        /// Method to get all club members
        /// </summary>
        /// <returns>Data table</returns>
        DataRow GetProgressById(int Id);

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

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

        /// <summary>
        /// Method to create new member
        /// </summary>
        /// <param name="ProjectName">club member model</param>
        /// <returns>true or false</returns>
        bool AddProgress(ProgressModel progress);

        /// <summary>
        /// Method to update club member details
        /// </summary>
        /// <param name="project">club member</param>
        /// <returns></returns>
        bool UpdateProgress(ProgressModel progress);

        /// <summary>
        /// Method to delete a club member
        /// </summary>
        /// <param name="id">member id</param>
        /// <returns>true / false</returns>
        bool DeleteProgress(int id);


    }
}