using System;
using System.Collections.Generic;
using System.Text;

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

    public interface IProjectSQL
    {
        /// <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>
        /// Method to get all club members
        /// </summary>
        /// <returns>Data table</returns>
        DataTable GetAllProjectsForGridView();


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

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

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

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