private void dodajRobuButton_Click(object sender, EventArgs e)
{
if (robaDGV.SelectedRows.Count > 0 && int.Parse(kolicinaTbox.Text) > 0)
{
try
{
connection.Open();
string sqlQuery;
sqlQuery = "insert into stavka_primka values (" + int.Parse(robaDGV.CurrentRow.Cells[0].Value.ToString()) + "," + idprimka + "," + int.Parse(kolicinaTbox.Text) + ")";
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
MessageBox.Show("Ta roba već postoji na primci");
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
else
{
MessageBox.Show("Nije odabrana roba");
}
}
public void TestNoPrepareNamedParamIn()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create procedure nunit_test(in p1 string, in p2 string) as throw p1; end_procedure", connection).ExecuteNonQuery();
NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection);
cmd.CommandType = CommandType.StoredProcedure;
NuoDbParameter param1 = new NuoDbParameter();
param1.ParameterName = "p2";
param1.Direction = ParameterDirection.Input;
param1.Value = "goodbye";
cmd.Parameters.Add(param1);
NuoDbParameter param2 = new NuoDbParameter();
param2.ParameterName = "p1";
param2.Direction = ParameterDirection.Input;
param2.Value = "hello";
cmd.Parameters.Add(param2);
try
{
cmd.ExecuteNonQuery();
Assert.Fail();
}
catch (Exception e)
{
Assert.IsTrue(e.Message.EndsWith("hello"), "Expected error: 'hello', received " + e.Message);
}
}
}
private void dodajPrimkuButton_Click(object sender, EventArgs e)
{
if (partneriCbox.SelectedIndex >= 0)
{
try
{
connection.Open();
string sqlQuery;
sqlQuery = "insert into primka values (default, '" + DateTime.Today.ToString("dd/MM/yyyy") + "', 0, " + idzaposlenik + ", " + idList[partneriCbox.SelectedIndex] + " ); ";
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (connection != null)
{
connection.Close();
}
GetPrimke();
}
}
else
{
MessageBox.Show("Nije odabran partner");
}
}
private void spremiButton_Click(object sender, EventArgs e)
{
try
{
connection.Open();
string sqlQuery;
if (idSkladiste == 999)
{
sqlQuery = "insert into skladiste values (default, '" + nazivTbox.Text + "', '" + adresaTbox.Text + "' );";
}
else
{
sqlQuery = "update skladiste set naziv = '" + nazivTbox.Text + "', adresa = '" + adresaTbox.Text + "' where idskladiste = " + idSkladiste + ";";
}
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
private void otkljucajPrimkuButton_Click(object sender, EventArgs e)
{
if (primkaDGV.SelectedRows.Count > 0 && int.Parse(primkaDGV.CurrentRow.Cells[2].Value.ToString()) == 1)
{
try
{
connection.Open();
string sqlQuery;
sqlQuery = "update primka set kontrola = 0 where idprimka = " + int.Parse(primkaDGV.CurrentRow.Cells[0].Value.ToString()) + "";
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (connection != null)
{
connection.Close();
}
GetPrimke();
}
}
else if (int.Parse(primkaDGV.CurrentRow.Cells[2].Value.ToString()) == 0)
{
MessageBox.Show("Primka je već otključana");
}
else
{
MessageBox.Show("Nije odabrana primka");
}
}
private void obrisiPartneraButton_Click(object sender, EventArgs e)
{
if (partneriDGV.SelectedRows.Count > 0)
{
try
{
connection.Open();
string sqlQuery;
sqlQuery = "delete from poslovni_partner where idposlovni_partner = " + int.Parse(partneriDGV.CurrentRow.Cells[0].Value.ToString()) + "";
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
MessageBox.Show("Poslovni partner se ne može brisati dok se navodi na računima ili primkama");
}
finally
{
if (connection != null)
{
connection.Close();
}
GetPartneri();
}
}
else
{
MessageBox.Show("Nije odabran partner");
}
}
private void spremiButton_Click(object sender, EventArgs e)
{
try
{
connection.Open();
string sqlQuery;
if (idPozicija == 999)
{
sqlQuery = "insert into pozicija values (default, '" + nazivTbox.Text + "', '" + opisTbox.Text + "' " + ", " + razinaTbox.Text + " ); ";
}
else
{
sqlQuery = "update pozicija set naziv = '" + nazivTbox.Text + "', opis = '" + opisTbox.Text + "', razina_prava = " + razinaTbox.Text + " where idpozicija = " + idPozicija + ";";
}
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
private void obrisiPozicijuButton_Click(object sender, EventArgs e)
{
if (pozicijaDGV.SelectedRows.Count > 0)
{
try
{
connection.Open();
string sqlQuery;
sqlQuery = "delete from pozicija where idpozicija = " + int.Parse(pozicijaDGV.CurrentRow.Cells[0].Value.ToString()) + "";
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
MessageBox.Show("Pozicija se ne može brisati dok se koristi za zaposlenika");
}
finally
{
if (connection != null)
{
connection.Close();
}
GetPozicija();
}
}
else
{
MessageBox.Show("Nije odabrana pozicija");
}
}
public void TestPrepareParamIn()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create procedure nunit_test(in p1 string) as throw p1; end_procedure", connection).ExecuteNonQuery();
NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Prepare();
Assert.IsTrue(cmd.Parameters.Contains("p1"));
Assert.AreEqual(ParameterDirection.Input, cmd.Parameters["p1"].Direction);
cmd.Parameters["p1"].Value = "hello";
try
{
cmd.ExecuteNonQuery();
Assert.Fail();
}
catch (Exception e)
{
Assert.IsTrue(e.Message.EndsWith("hello"), "Expected error: 'hello', received " + e.Message);
}
}
}
internal static void CreatePersonTable()
{
using (NuoDbConnection connection = new NuoDbConnection(connectionString))
{
connection.Open();
try
{
DbCommand dropCommand = new NuoDbCommand("drop table Person", connection);
dropCommand.ExecuteNonQuery();
}
catch (Exception)
{
// table is allowed to be missing
}
DbCommand createCommand = new NuoDbCommand("create table Person" +
"(" +
" Id char(38) not NULL primary key," +
" Name String" +
")", connection);
createCommand.ExecuteNonQuery();
DbCommand insertCommand = new NuoDbCommand("Insert into Person (Id, Name) Values (?,?)", connection);
insertCommand.Prepare();
insertCommand.Parameters[0].Value = new Guid("{F571197E-7A4F-4961-9363-7411EACCA841}");
insertCommand.Parameters[1].Value = "Klaus Müller";
insertCommand.ExecuteNonQuery();
}
}
internal static void CreateGameTable()
{
using (NuoDbConnection connection = new NuoDbConnection(connectionString))
{
connection.Open();
try
{
DbCommand dropCommand = new NuoDbCommand("drop table Game", connection);
dropCommand.ExecuteNonQuery();
}
catch (Exception)
{
// table is allowed to be missing
}
DbCommand createCommand = new NuoDbCommand("create table Game" +
"(" +
" Id bigint generated always as identity not NULL primary key," +
" Date DATE" +
")", connection);
createCommand.ExecuteNonQuery();
DbCommand insertCommand = new NuoDbCommand("Insert into Game (Date) Values (?)", connection);
insertCommand.Prepare();
insertCommand.Parameters[0].Value = "1970-01-01";
insertCommand.ExecuteNonQuery();
}
}
private void izdajRacunButton_Click(object sender, EventArgs e)
{
if (racuniDGV.SelectedRows.Count > 0 && int.Parse(racuniDGV.CurrentRow.Cells[3].Value.ToString()) == 0)
{
try
{
connection.Open();
string sqlQuery;
sqlQuery = "update racun set kontrola = 1 where idracun = " + int.Parse(racuniDGV.CurrentRow.Cells[0].Value.ToString()) + "";
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (connection != null)
{
connection.Close();
}
GetRacuni();
}
}
else if (int.Parse(racuniDGV.CurrentRow.Cells[3].Value.ToString()) == 1)
{
MessageBox.Show("Račun je već zaključan");
}
else
{
MessageBox.Show("Nije odabran račun");
}
}
private void obrisiStavkubutton_Click(object sender, EventArgs e)
{
if (primkaDGV.SelectedRows.Count > 0 && int.Parse(primkaDGV.CurrentRow.Cells[2].Value.ToString()) == 0 && stavkaDGV.SelectedRows.Count > 0)
{
try
{
connection.Open();
string sqlQuery;
sqlQuery = "delete from stavka_primka where primka_idprimka = " + int.Parse(primkaDGV.CurrentRow.Cells[0].Value.ToString()) + " and roba_idroba = " + int.Parse(stavkaDGV.CurrentRow.Cells[0].Value.ToString()) + "";
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (connection != null)
{
connection.Close();
}
GetStavke();
}
}
else if (int.Parse(primkaDGV.CurrentRow.Cells[2].Value.ToString()) == 1)
{
MessageBox.Show("Primka je zaključana i ne može se mijenjati");
}
else
{
MessageBox.Show("Nije odabrana primka");
}
}
public void DB4329()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
Utils.DropTable(connection, "ExpenseTest");
DbCommand createCommand = new NuoDbCommand("Create table ExpenseTest" +
"(" +
"SourceExpenseId int," +
"ExpenseAmount numeric(15,2)" +
")", connection);
createCommand.ExecuteNonQuery();
DbCommand insertCommand = new NuoDbCommand("Insert Into ExpenseTest(SourceExpenseId, ExpenseAmount) Values (?,?)", connection);
insertCommand.Prepare();
insertCommand.Parameters[0].Value = -1254524;
insertCommand.Parameters[1].Value = -135.35;
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 100100100;
insertCommand.Parameters[1].Value = -1325465.35;
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 100100101;
insertCommand.Parameters[1].Value = 200000.35;
insertCommand.ExecuteNonQuery();
DbCommand selectCommand = new NuoDbCommand("select SourceExpenseId, ExpenseAmount from ExpenseTest", connection);
using (DbDataReader reader = selectCommand.ExecuteReader())
{
bool hasNext = reader.Read();
Assert.IsTrue(hasNext);
Assert.AreEqual(-1254524, reader[0]);
Assert.AreEqual(-135.35, reader[1]);
hasNext = reader.Read();
Assert.IsTrue(hasNext);
Assert.AreEqual(100100100, reader[0]);
Assert.AreEqual(-1325465.35, reader[1]);
hasNext = reader.Read();
Assert.IsTrue(hasNext);
Assert.AreEqual(100100101, reader[0]);
Assert.AreEqual(200000.35, reader[1]);
}
}
}
internal static void DropTable(NuoDbConnection cnn, string tableName)
{
try
{
DbCommand dropCommand = new NuoDbCommand("drop table " + tableName, cnn);
dropCommand.ExecuteNonQuery();
}
catch (Exception)
{
// table is allowed to be missing
}
}
public void TestNoPrepareAnonymousParamOut()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create procedure nunit_test(out p1 string) as p1='hello'; end_procedure", connection).ExecuteNonQuery();
NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
Assert.AreEqual("hello", cmd.Parameters["p1"].Value);
}
}
public void TestTableValuedArgument()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery();
try
{
new NuoDbCommand("create procedure nunit_test(input_data(field1 string, field2 integer), out output_data string) " +
" as " +
" output_data = ''; " +
" for select field1 from input_data; " +
" output_data = output_data || field1 || ' '; " +
" end_for; " +
" end_procedure", connection).ExecuteNonQuery();
}
catch (NuoDbSqlException e)
{
if (e.Code.Code == -1)
{
// the server doesn't support table valued arguments for procedures
return;
}
else
{
throw;
}
}
NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Prepare();
DataTable table = new DataTable();
table.Columns.Add("f1", typeof(string));
table.Columns.Add("f2", typeof(int));
DataRow row1 = table.NewRow();
row1[0] = "hello";
row1[1] = 0;
table.Rows.Add(row1);
DataRow row2 = table.NewRow();
row2[0] = "world!";
row2[1] = 0;
table.Rows.Add(row2);
cmd.Parameters[0].Value = table;
cmd.ExecuteNonQuery();
Assert.AreEqual("hello world! ", cmd.Parameters[1].Value);
}
}
public void TestPrepareParamInOut()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create procedure nunit_test(inout p1 string) as if(p1='goodbye') p1='hello'; end_if; end_procedure", connection).ExecuteNonQuery();
NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Prepare();
Assert.IsTrue(cmd.Parameters.Contains("p1"));
Assert.AreEqual(ParameterDirection.InputOutput, cmd.Parameters["p1"].Direction);
cmd.Parameters["p1"].Value = "goodbye";
cmd.ExecuteNonQuery();
Assert.AreEqual("hello", cmd.Parameters["p1"].Value);
}
}
private void spremiButton_Click(object sender, EventArgs e)
{
decimal jed_cijena;
if (decimal.TryParse(jedcijenaTbox.Text, out jed_cijena))
{
try
{
connection.Open();
string sqlQuery;
if (idRoba == 999)
{
sqlQuery = "insert into roba values (default, '" + nazivTbox.Text + "', " + jedcijenaTbox.Text + " " + ", " + 0 + " " + ", '" + opisTbox.Text + "', " + idList[skladisteCbox.SelectedIndex] + " ); ";
}
else
{
sqlQuery = "update roba set naziv = '" + nazivTbox.Text + "', jedinicna_cijena = " + jedcijenaTbox.Text + ", opis = '" + opisTbox.Text + "', skladiste_idskladiste = " + idList[skladisteCbox.SelectedIndex] + " where idroba = " + idRoba + ";";
}
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
MessageBox.Show("Nije upisan iznos nije u pravilnom formatu");
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
else
{
MessageBox.Show("Nije upisan iznos nije u pravilnom formatu");
}
}
private void spremiButton_Click(object sender, EventArgs e)
{
double OIB;
int telBroj;
if (double.TryParse(oibTbox.Text, out OIB) && oibTbox.Text.Length == 11 && int.TryParse(telbrojTbox.Text, out telBroj) && tipCbox.SelectedIndex >= 0)
{
try
{
connection.Open();
string sqlQuery;
if (idPartner == 0)
{
sqlQuery = "insert into poslovni_partner values (default, '" + nazivTbox.Text + "', '" + OIB + "' " + ", '" + telBroj + "' " + ", '" + adresaTbox.Text + "' " + ", '" + brojracunaTbox.Text + "', " + idList[tipCbox.SelectedIndex] + " ); ";
}
else
{
sqlQuery = "update poslovni_partner set naziv = '" + nazivTbox.Text + "', oib = '" + oibTbox.Text + "', telefonski_broj = '" + telBroj + "', adresa = '" + adresaTbox.Text + "', broj_racuna = '" + brojracunaTbox.Text + "', tip_partnera_idtip_partnera = " + idList[tipCbox.SelectedIndex] + " where idposlovni_partner = " + idPartner + ";";
}
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
else
{
MessageBox.Show("Krivo upisani OIB");
}
}
public void TestNoPrepareAnonymousParamIn()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create procedure nunit_test(in p1 string) as throw p1; end_procedure", connection).ExecuteNonQuery();
NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("hello");
try
{
cmd.ExecuteNonQuery();
Assert.Fail();
}
catch (Exception e)
{
Assert.IsTrue(e.Message.EndsWith("hello"), "Expected error: 'hello', received " + e.Message);
}
}
}
public void TestNoPrepareNamedParamOut()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create procedure nunit_test(out p1 string, out p2 string) as p1='hello'; end_procedure", connection).ExecuteNonQuery();
NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection);
cmd.CommandType = CommandType.StoredProcedure;
NuoDbParameter param1 = new NuoDbParameter();
param1.ParameterName = "p2";
param1.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param1);
NuoDbParameter param2 = new NuoDbParameter();
param2.ParameterName = "p1";
param2.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param2);
cmd.ExecuteNonQuery();
Assert.AreEqual("hello", cmd.Parameters["p1"].Value);
}
}
private void spremiButton_Click(object sender, EventArgs e)
{
double OIB;
int telBroj;
if (double.TryParse(oibTbox.Text, out OIB) && oibTbox.Text.Length == 11 && int.TryParse(telbrojTbox.Text, out telBroj) && pozicijaCbox.SelectedIndex >= 0)
{
try
{
connection.Open();
string sqlQuery;
if (idZaposlenik == 999)
{
sqlQuery = "insert into zaposlenik values (default, '" + imeTbox.Text + "', '" + prezimeTbox.Text + "' " + ", '" + telBroj + "' " + ", '" + adresaTbox.Text + "', '" + OIB + "', '" + brojracunaTbox.Text + "', '" + korimeTbox.Text + "', '" + lozinkaTbox.Text + "'," + idList[pozicijaCbox.SelectedIndex] + " ); ";
}
else
{
sqlQuery = "update zaposlenik set ime = '" + imeTbox.Text + "', prezime = '" + prezimeTbox.Text + "', telefonski_broj = '" + telBroj + "', adresa = '" + adresaTbox.Text + "', oib = '" + OIB + "', broj_racuna = '" + brojracunaTbox.Text + "', korisnicko_ime = '" + korimeTbox.Text + "', lozinka = '" + lozinkaTbox.Text + "', pozicija_idpozicija = " + idList[pozicijaCbox.SelectedIndex] + " where idzaposlenik = " + idZaposlenik + ";";
}
NuoDbCommand command = new NuoDbCommand(sqlQuery, connection);
command.ExecuteNonQuery();
MessageBox.Show("Uspješno izvršeno");
}
catch (NuoDbSqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
}
internal static void DropTable(NuoDbConnection cnn, string tableName)
{
DbCommand dropCommand = new NuoDbCommand("drop table if exists " + tableName, cnn);
dropCommand.ExecuteNonQuery();
}
internal static void CreateHockeyTable()
{
using (NuoDbConnection connection = new NuoDbConnection(connectionString))
{
connection.Open();
try
{
DbCommand dropCommand = new NuoDbCommand("drop table hockey", connection);
dropCommand.ExecuteNonQuery();
}
catch (Exception)
{
// table is allowed to be missing
}
DbCommand createCommand = new NuoDbCommand("create table Hockey" +
"(" +
" Id bigint not NULL generated always as identity primary key," +
" Number Integer," +
" Name String," +
" Position String," +
" Team String" +
")", connection);
createCommand.ExecuteNonQuery();
DbCommand insertCommand = new NuoDbCommand("Insert into Hockey (Number, Name, Position, Team) Values (?,?,?,?)", connection);
insertCommand.Prepare();
insertCommand.Parameters[0].Value = 37;
insertCommand.Parameters[1].Value = "PATRICE BERGERON";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 48;
insertCommand.Parameters[1].Value = "CHRIS BOURQUE";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 11;
insertCommand.Parameters[1].Value = "GREGORY CAMPBELL";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 18;
insertCommand.Parameters[1].Value = "NATHAN HORTON";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 23;
insertCommand.Parameters[1].Value = "CHRIS KELLY";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 46;
insertCommand.Parameters[1].Value = "DAVID KREJCI";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 17;
insertCommand.Parameters[1].Value = "MILAN LUCIC";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 64;
insertCommand.Parameters[1].Value = "LANE MACDERMID";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 63;
insertCommand.Parameters[1].Value = "BRAD MARCHAND";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 20;
insertCommand.Parameters[1].Value = "DANIEL PAILLE";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 49;
insertCommand.Parameters[1].Value = "RICH PEVERLEY";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 91;
insertCommand.Parameters[1].Value = "MARC SAVARD";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 19;
insertCommand.Parameters[1].Value = "TYLER SEGUIN";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 22;
insertCommand.Parameters[1].Value = "SHAWN THORNTON";
insertCommand.Parameters[2].Value = "Forward";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 55;
insertCommand.Parameters[1].Value = "JOHNNY BOYCHUK";
insertCommand.Parameters[2].Value = "Defense";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 33;
insertCommand.Parameters[1].Value = "ZDENO CHARA";
insertCommand.Parameters[2].Value = "Defense";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 21;
insertCommand.Parameters[1].Value = "ANDREW FERENCE";
insertCommand.Parameters[2].Value = "Defense";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 27;
insertCommand.Parameters[1].Value = "DOUGIE HAMILTON";
insertCommand.Parameters[2].Value = "Defense";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 45;
insertCommand.Parameters[1].Value = "AARON JOHNSON";
insertCommand.Parameters[2].Value = "Defense";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 54;
insertCommand.Parameters[1].Value = "ADAM MCQUAID";
insertCommand.Parameters[2].Value = "Defense";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 44;
insertCommand.Parameters[1].Value = "DENNIS SEIDENBERG";
insertCommand.Parameters[2].Value = "Defense";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 35;
insertCommand.Parameters[1].Value = "ANTON KHUDOBIN";
insertCommand.Parameters[2].Value = "Goalie";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 40;
insertCommand.Parameters[1].Value = "TUUKKA RASK";
insertCommand.Parameters[2].Value = "Goalie";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
insertCommand.Parameters[0].Value = 1;
insertCommand.Parameters[1].Value = "MAX SUMMIT";
insertCommand.Parameters[2].Value = "Fan";
insertCommand.Parameters[3].Value = "Bruins";
insertCommand.ExecuteNonQuery();
}
}