public static int Create(string name, string description, ProjectModel project, UserModel creator)
{
return(ExecuteScalarInt(
@"INSERT INTO boards(guid, name, description, project_id, creator_id)
VALUES (@guid, @name, @description, @project_id, @creator_id); SELECT currval('boards_id_seq');"
, new { guid = Guid.NewGuid().ToString(), name, description, project_id = project.id, creator_id = creator?.id }
));
}
public static ProjectModel FindOrCreate(string name, UserModel creator, RepoModel repository)
{
var project = ProjectModel.FindBy("repository_id", repository.id) ??
ProjectModel.Find(ProjectModel.Create(name, creator, repository));
ProjectSetUp.Run(project, creator);
return(project);
}
public static Board Find(ProjectModel project, UserModel creator)
{
return(Connection().Query <Board>(
"SELECT * FROM boards WHERE project_id = @project_id AND creator_id = @creator_id LIMIT 1",
new {
project_id = project.id, creator_id = creator.id
}
).FirstOrDefault());
}
public static ProjectTeamMemberModel Create(ProjectModel project = null, UserModel user = null)
{
user = user ?? UserFaker.Create();
project = project ?? ProjectFaker.Create();
return(ProjectTeamMemberRepository.CreateAndGet(
project,
user
));
}
public static bool IsExist(ProjectModel project, UserModel user)
{
var res = Connection().ExecuteScalar <bool>(
"SELECT COUNT(1) FROM project_team_members WHERE project_id = @project_id AND user_id = @user_id",
new {
project_id = project.id, user_id = user.id
});
return(res);
}
public static void Delete(ProjectModel project)
{
var teamMembers = ProjectTeamMemberRepository.Get(project);
foreach (var member in teamMembers)
{
member.Delete();
}
project.Alias()?.Delete();
project.Delete();
}
public static bool IsExists(ProjectModel project, UserModel user)
{
return(ProjectTeamMemberModel.IsExist(project, user));
}
public static ProjectTeamMemberModel CreateAndGet(ProjectModel project, UserModel user)
{
return(ProjectTeamMemberModel.Find(ProjectTeamMemberModel.Create(project, user)));
}
public static ProjectTeamMemberModel Find(ProjectModel project, UserModel user)
{
return(ProjectTeamMemberModel.Find(project, user));
}
public static ProjectTeamMemberModel[] Get(ProjectModel project)
{
return(ProjectTeamMemberModel.Get(project));
}
public ProjectModel Project() => ProjectModel.Find(project_id);
public static ProjectTeamMember[] Get(ProjectModel project)
=> Connection().Query <ProjectTeamMember>(
"SELECT * FROM project_team_members WHERE project_id = @project_id",
new { project_id = project.id }
).ToArray();
public static ProjectModel FindByGuid(string guid) => ProjectModel.FindByGuid(guid);
public static int Create(ProjectModel project, UserModel user)
=> ExecuteScalarInt(
@"INSERT INTO project_team_members(project_id, user_id)
VALUES (@project_id, @user_id); SELECT currval('project_team_members_id_seq');"
, new { project_id = project.id, user_id = user.id }
);
public static ProjectModel FindBy(string col, int val) => ProjectModel.FindBy(col, val);
public static ProjectModel Find(int id)
{
return(ProjectModel.Find(id));
}
public static BoardModel Find(ProjectModel project, UserModel creator)
{
return(BoardModel.Find(project, creator));
}
public static ProjectModel[] GetNewest(int page, int pageSize) => ProjectModel.GetNewest(page, pageSize);
public static ProjectModel[] GetRandom() => ProjectModel.GetRandom();
public static ProjectModel FindRandom() => ProjectModel.FindRandom();
public static ProjectModel[] GetBy(string col, int val) => ProjectModel.GetBy(col, val);
public static BoardModel CreateAndGet(string name, string description, ProjectModel project, UserModel user = null)
{
return(BoardModel.Find(BoardModel.Create(name, description, project, user)));
}
public static ProjectTeamMember Find(ProjectModel project, UserModel user)
=> Connection().Query <ProjectTeamMember>(
"SELECT * FROM project_team_members WHERE project_id = @project_id AND user_id = @user_id LIMIT 1",
new { project_id = project.id, user_id = user.id }
).FirstOrDefault();
