public void addGame(Game obj, int num) { try { database = new OleDbConnection(connectionString); database.Open(); string queryString = "INSERT INTO Game (Title, Description, Publisher, ReleaseDate, Rating, PurchasePrice, Copies) " + "VALUES ('" + obj.Title + "', '" + obj.Description + "', '" + obj.Publisher + "', '" + obj.ReleaseDate + "', '" + obj.Rating + "', '" + obj.Price + "', '" + obj.Copies + "')"; string queryString2 = "SELECT * FROM Game WHERE Title = '" + obj.Title + "'"; string queryString3; OleDbCommand cmd = new OleDbCommand(queryString, database); OleDbCommand cmd2 = new OleDbCommand(queryString2, database); count = cmd.ExecuteNonQuery(); reader = cmd2.ExecuteReader(); Game temp = new Game(); reader.Read(); temp.Id = Int32.Parse(reader["ID"].ToString()); temp.Title = reader["Title"].ToString(); temp.Description = reader["Description"].ToString(); temp.Publisher = reader["Publisher"].ToString(); temp.ReleaseDate = reader["ReleaseDate"].ToString(); temp.Rating = reader["Rating"].ToString(); temp.Price = Double.Parse(reader["PurchasePrice"].ToString()); temp.Copies = Int32.Parse(reader["Copies"].ToString()); queryString3 = "INSERT INTO GameCopy (CheckedOut, GameID) " + "VALUES (false, '" + temp.Id + "')"; OleDbCommand cmd3 = new OleDbCommand(queryString3, database); for (int i = 0; i < num; i++) count2 = cmd3.ExecuteNonQuery(); if (count >= 1) MessageBox.Show(obj.Title + " has been added!"); else MessageBox.Show("Error: Could not add game!"); reader.Close(); database.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); reader.Close(); database.Close(); } }
private void okButton_Click_1(object sender, EventArgs e) { dbIO dataHandler = new dbIO(); Game newGame = new Game(0, titleTextBox.Text, descriptionTextBox.Text, publisherTextBox.Text, releaseDateMaskedTextBox.Text, ratingTextBox.Text, double.Parse(priceMaskedTextBox.Text), (int)numberOfCopiesUpDown.Value); dataHandler.addGame(newGame,(Int32)numberOfCopiesUpDown.Value); titleTextBox.Text = ""; descriptionTextBox.Text = ""; publisherTextBox.Text = ""; releaseDateMaskedTextBox.Text = ""; ratingTextBox.Text = ""; priceMaskedTextBox.Text = ""; numberOfCopiesUpDown.Value = 0; }
public void updateGame(Game obj) { try { database = new OleDbConnection(connectionString); database.Open(); string queryString = "UPDATE Game " + "SET Title = '" +obj.Title+ "', Description = '" +obj.Description+ "', Publisher = '" +obj.Publisher+ "', ReleaseDate = '" +obj.ReleaseDate+ "', Rating = '" +obj.Rating+ "', PurchasePrice = " +obj.Price+ ", Copies = " +obj.Copies+ " WHERE ID = " +obj.Id; OleDbCommand cmd = new OleDbCommand(queryString, database); count = cmd.ExecuteNonQuery(); if (count >= 1) MessageBox.Show(obj.Title + "'s record has been updated!"); else MessageBox.Show("Error: No game by that title!"); database.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); database.Close(); } }
public List<Game> searchGame(string name) { gameList.Clear(); try { database = new OleDbConnection(connectionString); database.Open(); string queryString = "SELECT * FROM Game Where Title LIKE ('%" +name+ "%')"; OleDbCommand cmd = new OleDbCommand(queryString, database); reader = cmd.ExecuteReader(); while (reader.Read()) { Game temp = new Game(); temp.Id =(Int32) reader["ID"]; temp.Title = reader["Title"].ToString(); temp.Description = reader["Description"].ToString(); temp.Publisher = reader["Publisher"].ToString(); temp.ReleaseDate = reader["ReleaseDate"].ToString(); temp.Rating = reader["Rating"].ToString(); temp.Price =(double) reader["PurchasePrice"]; temp.Copies =(Int32) reader["Copies"]; gameList.Add(temp); } reader.Close(); database.Close(); return gameList; } catch (Exception ex) { MessageBox.Show(ex.Message); gameList.Clear(); reader.Close(); database.Close(); return gameList; } }