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();