public override void Delete(DatabaseHelper dbHelper)
{
try {
OracleCommand command = dbHelper.Connection.CreateCommand();
command.CommandText = QRY_LOCK;
command.ExecuteNonQuery();
command.CommandText = String.Format(QRY_DELETE, Id);
command.ExecuteNonQuery();
dbHelper.LogTransaction(LogActions.Undo, String.Format(QRY_FULL_INSERT, Id, Name, MinimumPlayerNumber, MaximumPlayerNumber, MinimumAge, AverageGameTime));
dbHelper.LogTransaction(LogActions.Redo, command.CommandText);
dbHelper.Transaction.Commit();
BoardGameCollection.Instance().BoardGames.Remove(this);
}
catch (OracleException e) {
Name = Memento.Name;
MinimumPlayerNumber = Memento.MinimumPlayerNumber;
MaximumPlayerNumber = Memento.MaximumPlayerNumber;
MinimumAge = Memento.MinimumAge;
AverageGameTime = Memento.AverageGameTime;
throw e;
}
}
public override void Insert(DatabaseHelper dbHelper)
{
try {
OracleDecimal output;
OracleCommand command = dbHelper.Connection.CreateCommand();
command.CommandText = QRY_LOCK;
command.ExecuteNonQuery();
command.CommandText = String.Format(QRY_INSERT, Name, MinimumPlayerNumber, MaximumPlayerNumber, MinimumAge, AverageGameTime);
command.Parameters.Add("output", OracleDbType.Decimal, ParameterDirection.ReturnValue);
command.ExecuteNonQuery();
output = (OracleDecimal)command.Parameters["output"].Value;
this.Id = output.ToInt32();
dbHelper.LogTransaction(LogActions.Undo, String.Format(QRY_DELETE, output.ToInt32()));
dbHelper.LogTransaction(LogActions.Redo, String.Format(QRY_INSERT, Name, MinimumPlayerNumber, MaximumPlayerNumber, MinimumAge, AverageGameTime));
dbHelper.Transaction.Commit();
BoardGameCollection.Instance().BoardGames.Add(this);
}
catch (OracleException e) {
throw e;
}
}
public MainWindow()
{
InitializeComponent();
dbHelper = new DatabaseHelper(DBCONFIG);
statusLabel.Text = "Connecté";
BoardGameEventCollection.Instance().LoadBoardEventsFromDatabase(dbHelper.Connection);
BoardGameCollection.Instance().LoadBoardGamesFromDatabase(dbHelper.Connection);
PlayerCollection.Instance().LoadPlayersFromDatabase(dbHelper.Connection);
}
private void MainWindow_Load(object sender, EventArgs e)
{
eventsDataGridView.Width = eventsTabPage.Width - eventsDataGridView.Location.X;
eventsDataGridView.Height = eventsTabPage.Height - 80;
playersDataGridView.Width = playersTabPage.Width - playersDataGridView.Location.X;
playersDataGridView.Height = playersTabPage.Height - 80;
boardGamesDataGridView.Width = boardGamesTabPage.Width - boardGamesDataGridView.Location.X;
boardGamesDataGridView.Height = boardGamesTabPage.Height - 80;
eventPlayersDataGridView.AutoGenerateColumns = false;
eventBoardGamesDataGridView.AutoGenerateColumns = false;
eventsDataGridView.AutoGenerateColumns = false;
boardGamesDataGridView.AutoGenerateColumns = false;
playersDataGridView.AutoGenerateColumns = false;
eventForAdultDataGridView.AutoGenerateColumns = false;
upcomingEventsDataGridView.AutoGenerateColumns = false;
eventsDataGridView.DataSource = BoardGameEventCollection.Instance().BoardgameEvents;
boardGamesDataGridView.DataSource = BoardGameCollection.Instance().BoardGames;
playersDataGridView.DataSource = PlayerCollection.Instance().Players;
}
public void LoadBoardGamesFromDatabase(OracleConnection connection)
{
try {
OracleCommand command = connection.CreateCommand();
command.CommandText = String.Format(QRY_SELECT_BOARDGAMES, _id);
connection.Open();
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
BoardGameList.Add(BoardGameCollection.Instance().BoardGames.Where(s => s.Id == Int32.Parse(reader["BOARDGAME_ID"].ToString())).First());
}
}
catch (OracleException e) {
throw e;
}
finally {
connection.Close();
}
}
private void eventComboBox_SelectedValueChanged(object sender, EventArgs e)
{
if (tabControl.SelectedIndex == 3 && eventComboBox.SelectedItem != null)
{
BoardGameEvent selectedEvent = eventComboBox.SelectedItem as BoardGameEvent;
selectedEvent.PlayerList.Clear();
selectedEvent.BoardGameList.Clear();
selectedEvent.LoadPlayersFromDatabase(dbHelper.Connection);
selectedEvent.LoadBoardGamesFromDatabase(dbHelper.Connection);
List <Player> playerList = new List <Player>();
foreach (Player player in PlayerCollection.Instance().Players)
{
if (!selectedEvent.PlayerList.Exists(x => x.Id == player.Id))
{
playerList.Add(player);
}
}
List <BoardGame> boardGameList = new List <BoardGame>();
foreach (BoardGame boardgame in BoardGameCollection.Instance().BoardGames)
{
if (!selectedEvent.BoardGameList.Exists(x => x.Id == boardgame.Id))
{
boardGameList.Add(boardgame);
}
}
RefreshEventPlayersListBox(playerList);
RefreshEventBoardGamesListBox(boardGameList);
eventPlayersDataGridView.DataSource = selectedEvent.PlayerList;
eventBoardGamesDataGridView.DataSource = selectedEvent.BoardGameList;
}
}
private void RefreshBoardGamesGrid()
{
boardGamesDataGridView.DataSource = null;
boardGamesDataGridView.DataSource = BoardGameCollection.Instance().BoardGames;
}
