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())
{
}
}
