public void Archive(int listId)
{
Sql.ExecuteNonQuery("List_Archive",
new Dictionary <string, object>()
{
{ "listId", listId }
}
);
}
public void Delete(int boardId, int cardId)
{
Sql.ExecuteNonQuery("Card_Delete",
new Dictionary <string, object>()
{
{ "boardId", boardId },
{ "cardId", cardId }
}
);
}
public void Move(int boardId, int[] cardIds)
{
Sql.ExecuteNonQuery("List_Move",
new Dictionary <string, object>()
{
{ "boardId", boardId },
{ "ids", string.Join(",", cardIds) }
}
);
}
public void UpdateEmail(int userId, string email)
{
Sql.ExecuteNonQuery("User_UpdateEmail",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "email", email }
}
);
}
public void UpdatePassword(int userId, string password)
{
Sql.ExecuteNonQuery("User_UpdatePassword",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "password", password }
}
);
}
public void AllColor(int userId, bool allColor)
{
Sql.ExecuteNonQuery("User_AllColor",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "allcolor", allColor }
}
);
}
public void KeepMenuOpen(int userId, bool keepOpen)
{
Sql.ExecuteNonQuery("User_KeepMenuOpen",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "keepmenu", keepOpen }
}
);
}
public void UpdateDescription(int boardId, int cardId, string description)
{
Sql.ExecuteNonQuery("Card_UpdateDescription",
new Dictionary <string, object>()
{
{ "boardId", boardId },
{ "cardId", cardId },
{ "description", description }
}
);
}
public void UpdateBoard(Models.Board board)
{
Sql.ExecuteNonQuery(
"Board_Update",
new Dictionary <string, object>()
{
{ "boardId", board.boardId },
{ "teamId", board.teamId },
{ "name", board.name },
{ "color", board.color }
}
);
}
public void UpdateTeam(Models.Team team)
{
Sql.ExecuteNonQuery(
"Team_Update",
new Dictionary <string, object>()
{
{ "teamId", team.teamId },
{ "ownerId", team.ownerId },
{ "security", team.security },
{ "name", team.name },
{ "website", team.website },
{ "description", team.description }
}
);
}