public static int Create(string name, BoardModel board, short boardOrder)
{
return(ExecuteScalarInt(
@"INSERT INTO board_columns(guid, name, board_id, board_order)
VALUES (@guid, @name, @board_id, @board_order); SELECT currval('board_columns_id_seq');"
, new { guid = Guid.NewGuid().ToString(), name, board_id = board.id, board_order = boardOrder }
));
}
public static BoardColumn Find(BoardModel board, short boardOrder)
{
return(Connection().Query <BoardColumn>(
"SELECT * FROM board_columns WHERE board_id = @board_id AND board_order = @board_order LIMIT 1",
new {
board_id = board.id, board_order = boardOrder
}
).FirstOrDefault());
}
public static BoardModel Find(int id)
{
return(BoardModel.Find(id));
}
public static BoardModel UpdateAndRefresh(BoardModel model, JObject data)
{
model.name = data.Value <string>("name") ?? model.name;
model.description = data.Value <string>("description") ?? model.description;
return(model.Save());
}
public static BoardModel CreateAndGet(string name, string description, ProjectModel project, UserModel user = null)
{
return(BoardModel.Find(BoardModel.Create(name, description, project, user)));
}
public static BoardModel Find(ProjectModel project, UserModel creator)
{
return(BoardModel.Find(project, creator));
}
public static BoardModel FindByGuid(string guid)
{
return(BoardModel.FindByGuid(guid));
}
public BoardModel Board() => BoardModel.Find(board_id);
public static BoardColumnModel CreateAndGet(string name, BoardModel board, short boardOrder)
{
return(BoardColumnModel.Find(BoardColumnModel.Create(name, board, boardOrder)));
}
public static BoardColumnModel Find(BoardModel board, short boardOrder)
{
return(BoardColumnModel.Find(board, boardOrder));
}
