private void button1_Click(object sender, EventArgs e) { using (var db = new GameTrackerDBmodel()) { try { var game = new GAME { GENREID = Convert.ToInt32(genreTxt.Text), GAMENAME = nameTxt.Text, PUBLISHDATE = Convert.ToDateTime(publishTxt.Text), GAMEDESC = descTxt.Text }; db.GAMES.Add(game); db.SaveChanges(); MessageBox.Show("Your game has been added to the database", "Added Game", MessageBoxButtons.OK, MessageBoxIcon.Information); genreTxt.Clear(); nameTxt.Clear(); publishTxt.Clear(); descTxt.Clear(); var query = (from b in db.GAMES orderby b.GAMENAME select b).ToList(); dataGridView1.DataSource = query; } catch (Exception ex) { MessageBox.Show(ex.Message, "Data Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void button1_Click(object sender, EventArgs e) { using (var db = new GameTrackerDBmodel()) { try { var system = new SYSTEM { SYSTEMNAME = sysNameTxt.Text, SYSTEMRELEASE = Convert.ToDateTime(sysPubTxt.Text), SYSMANUFACTURE = sysMenuTxt.Text }; db.SYSTEMS.Add(system); db.SaveChanges(); MessageBox.Show("Your game has been added to the database", "Added Game", MessageBoxButtons.OK, MessageBoxIcon.Information); sysNameTxt.Clear(); sysMenuTxt.Clear(); sysPubTxt.Clear(); var query = (from b in db.SYSTEMS orderby b.SYSTEMNAME select b).ToList(); dataGridView1.DataSource = query; } catch (Exception ex) { MessageBox.Show(ex.Message, "Data Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public EditGames() { InitializeComponent(); using (var db = new GameTrackerDBmodel()) { var query = (from b in db.GAMES orderby b.GAMENAME select b).ToList(); dataGridView1.DataSource = query; } }
private void button2_Click(object sender, EventArgs e) { richTextBox1.Clear(); string ouputString = ""; using (var db = new GameTrackerDBmodel()) { var query = from b in db.GAMES orderby b.GAMENAME select b; foreach (var item in query) { ouputString += "Game ID: " + item.GAMEID + " , Genre ID: " + item.GENREID + " , " + item.GAMENAME + " , " + item.PUBLISHDATE + " , " + item.GAMEDESC + Environment.NewLine + Environment.NewLine; } richTextBox1.Text = ouputString; } }
private void showAllSysBtn_Click(object sender, EventArgs e) { richTextBox1.Clear(); string ouputString = ""; using (var db = new GameTrackerDBmodel()) { var query = from b in db.SYSTEMS orderby b.SYSTEMNAME select b; foreach (var item in query) { ouputString += "System ID: " + item.SYSID + Environment.NewLine + "System Name: " + item.SYSTEMNAME + Environment.NewLine + "System Release Date: " + item.SYSTEMRELEASE + Environment.NewLine + "System Manufacturer: " + item.SYSMANUFACTURE + Environment.NewLine + Environment.NewLine; } richTextBox1.Text = ouputString; } }
private void button2_Click(object sender, EventArgs e) { using (var db = new GameTrackerDBmodel()) { } }