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