66 lines
1.8 KiB
C#
66 lines
1.8 KiB
C#
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);
|
|
}
|
|
}
|