// A method that saves the information of Build into the database ------------------------------------------------------
public void SaveBuild(Build build)
{
Open();
string Buildname = build.BuildName;
string Author = build.Author;
string Class = build.SelectedClass;
string Spec = build.SelectedSpec;
string Spell1 = null;
string Spell2 = null;
string Spell3 = null;
string Spell4 = null;
string Spell5 = null;
string Spell6 = null;
foreach (string spell in build.SelectedSpells)
{
if (Spell1 == null)
{
Spell1 = spell;
}
else if (Spell2 == null)
{
Spell2 = spell;
}
else if (Spell3 == null)
{
Spell3 = spell;
}
else if (Spell4 == null)
{
Spell4 = spell;
}
else if (Spell5 == null)
{
Spell5 = spell;
}
else if (Spell6 == null)
{
Spell6 = spell;
}
}
try
{
OleDbConnection myconnection = new OleDbConnection(accesconnectionstring);
OleDbCommand Command = myconnection.CreateCommand();
myconnection.Open();
Command.CommandText = "INSERT INTO Build ([BuildName],[Author],[Class],[Spec],[Spell1],[Spell2],[Spell3],[Spell4],[Spell5],[Spell6])" +
"VALUES('" + Buildname + "','" + Author + "','" + Class + "','" + Spec + "','" + Spell1 + "','" + Spell2 + "','" + Spell3 + "','" + Spell4 + "','" + Spell5 + "','" + Spell6 + "')";
Command.ExecuteNonQuery();
}
catch
{
}
Close();
}
public void SaveBuild(Build build)
{
Open();
string Buildname = build.BuildName;
string Author = build.Author;
string Class = build.SelectedClass;
string Spec = build.SelectedSpec;
string Spell1 = null;
string Spell2 = null;
string Spell3 = null;
string Spell4 = null;
string Spell5 = null;
string Spell6 = null;
foreach (string spell in build.SelectedSpells)
{
if(Spell1 == null)
{
Spell1 = spell;
}
else if (Spell2 == null)
{
Spell2 = spell;
}
else if (Spell3 == null)
{
Spell3 = spell;
}
else if (Spell4 == null)
{
Spell4 = spell;
}
else if (Spell5 == null)
{
Spell5 = spell;
}
else if (Spell6 == null)
{
Spell6 = spell;
}
}
try
{
OleDbConnection myconnection = new OleDbConnection(accesconnectionstring);
/*Command.Parameters.AddWithValue("@BuildName", Buildname);
Command.Parameters.AddWithValue("@BuildAuthor", Author);
Command.Parameters.AddWithValue("@Class", Class);
Command.Parameters.AddWithValue("@Spec", Spec);
Command.Parameters.AddWithValue("@Spell1", Spell1);
Command.Parameters.AddWithValue("@Spell2", Spell2);
Command.Parameters.AddWithValue("@Spell3", Spell3);
Command.Parameters.AddWithValue("@Spell4", Spell4);
Command.Parameters.AddWithValue("@Spell5", Spell5);
Command.Parameters.AddWithValue("@Spell6", Spell6);
Command.Connection = connection;
Command.ExecuteNonQuery();*/
OleDbCommand Command = myconnection.CreateCommand();
myconnection.Open();
Command.CommandText = "INSERT INTO Build ([BuildName],[Author],[Class],[Spec],[Spell1],[Spell2],[Spell3],[Spell4],[Spell5],[Spell6])" +
"VALUES('" + Buildname + "','" + Author + "','" + Class + "','" + Spec + "','" + Spell1 + "','" + Spell2 + "','" + Spell3 + "','" + Spell4 + "','" + Spell5 + "','" + Spell6 + "')";
Command.ExecuteNonQuery();
}
catch
{
}
Close();
}
