internal void LoadGear(string filename, object side)
{
using (FileStream fs = new FileStream(filename, FileMode.Open))
{
String str;
Gear g;
StreamReader sr = new StreamReader(fs);
List<String> myLines = new List<String>();
while ((str = sr.ReadLine()) != null)
{
if (!myLines.Contains(str))
{
myLines.Add(str);
}
}
foreach(String s in myLines) {
g = new Gear(s, 1, 10, (Side)side);
this.InsertGear(g);
}
}
}
public void InsertInBothTables(Gear g, Unit u)
{
InsertGear(g);
InsertUnit(u);
}
public void UpdateGear(Gear g)
{
using (MySqlConnection conn = new MySqlConnection(this.ConnectionString))
{
conn.Open();
string commandText = "UPDATE Geschaeftspartner SET CLASSNAME = ?, UPGRADELEVEL = ?, PRICE = ? WHERE id = ?";
MySqlCommand cmd = new MySqlCommand(commandText, conn);
cmd.Parameters.AddWithValue("?", g.Classname);
cmd.Parameters.AddWithValue("?", g.UpgradeLevel);
cmd.Parameters.AddWithValue("?", g.Price);
ExecutionErrorHandler(cmd);
}
}
public void InsertGear(Gear g)
{
using (MySqlConnection conn = new MySqlConnection(this.ConnectionString))
{
conn.Open();
string commandText = "INSERT INTO Gear(CLASSNAME, UPGRADELEVEL, PRICE, SIDE) VALUES (?class, ?upgrade, ?price, ?side)";
MySqlCommand cmd = new MySqlCommand(commandText, conn);
cmd.Parameters.AddWithValue("?class", g.Classname);
cmd.Parameters.AddWithValue("?upgrade", Convert.ToInt32(g.UpgradeLevel));
cmd.Parameters.AddWithValue("?price", g.Price);
cmd.Parameters.AddWithValue("?side", g.Side);
ExecutionErrorHandler(cmd);
}
}