public static Card Find(string name, UserModel creator, BoardColumnModel column)
{
return(Connection().Query <Card>(
"SELECT * FROM cards WHERE name = @name AND creator_id = @creator_id AND column_id = @column_id LIMIT 1",
new {
name, creator_id = creator.id, column_id = column.id
}
).FirstOrDefault());
}
public static int Create(
string name, string description, int columnOrder, BoardColumnModel column, UserModel creator
)
{
return(ExecuteScalarInt(
@"INSERT INTO cards(guid, name, description, column_order, column_id, creator_id)
VALUES (@guid, @name, @description, @column_order, @column_id, @creator_id); SELECT currval('cards_id_seq');"
, new {
guid = Guid.NewGuid().ToString(), name, description, column_order = columnOrder,
column_id = column.id, creator_id = creator?.id
}
));
}
public static CardModel CreateAndGet(
string name, string description, int columnOrder, BoardColumnModel column, UserModel creator
)
{
return(CardModel.Find(CardModel.Create(name, description, columnOrder, column, creator)));
}
public static CardModel Find(string name, UserModel creator, BoardColumnModel column)
{
return(CardModel.Find(name, creator, column));
}
public BoardColumnModel Column() => BoardColumnModel.Find(column_id);
public static BoardColumnModel Find(int id)
{
return(BoardColumnModel.Find(id));
}
public static BoardColumnModel UpdateAndRefresh(BoardColumnModel model, JObject data)
{
model.name = data.Value <string>("name") ?? model.name;
model.board_order = data.Value <short?>("board_order") ?? model.board_order;
return(model.Save());
}
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));
}
public static BoardColumnModel FindByGuid(string guid)
{
return(BoardColumnModel.FindByGuid(guid));
}
