public void MagFegyverHozzaad(MagikusF fegyver)
{
if (!_magfegyverek.Contains(fegyver))
{
magfegyverek.Add(fegyver);
}
}
public List <MagikusF> MagFegyverLekerdez()
{
FegyverRaktar fer = FegyverRaktar.getInstance();
List <string> magf = new List <string>();
List <int> seb = new List <int>();
string connectionString = "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" + "DBQ=" + Environment.CurrentDirectory + @"\Fajlok\DB\adatbazis.xlsx" + ";ReadOnly=0;";
string queryString =
"SELECT * FROM [MagikusF$]";
using (OdbcConnection connection =
new OdbcConnection(connectionString))
{
OdbcCommand command = new OdbcCommand(queryString, connection);
try
{
connection.Open();
OdbcDataReader reader = command.ExecuteReader();
while (reader.Read())
{
magf.Add((string)reader[0]);
seb.Add(int.Parse(reader[1].ToString()));
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
for (int i = 0; i < magf.Count; i++)
{
MagikusF ujf = new MagikusF();
ujf.nev = magf[i];
ujf.sebzes = seb[i];
fer.MagFegyverHozzaad(ujf);
}
return(fer.magfegyverek);
}
}
public void MagFegyverLekerdezTest()
{
FegyverAdatbazis fegy = FegyverAdatbazis.getInstance();
List <MagikusF> elvartfegyv = new List <MagikusF>();
List <string> elvartmagfegyverek = new List <string>();
List <int> elvartsebzesek = new List <int>();
elvartmagfegyverek.Add("tűz botja");
elvartmagfegyverek.Add("jég botja");
elvartmagfegyverek.Add("szél botja");
elvartmagfegyverek.Add("föld botja");
elvartmagfegyverek.Add("káosz gömbje");
elvartmagfegyverek.Add("éjtalizmán");
elvartsebzesek.Add(300);
elvartsebzesek.Add(300);
elvartsebzesek.Add(300);
elvartsebzesek.Add(300);
elvartsebzesek.Add(350);
elvartsebzesek.Add(250);
for (int i = 0; i < elvartmagfegyverek.Count; i++)
{
MagikusF magf = new MagikusF();
magf.nev = elvartmagfegyverek[i];
magf.sebzes = elvartsebzesek[i];
elvartfegyv.Add(magf);
}
List <MagikusF> lekerdezettfv = new List <MagikusF>();
List <string> lekerdezettmagf = new List <string>();
List <int> lekerdezettseb = new List <int>();
string connectionString = "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" + "DBQ=" + Environment.CurrentDirectory + @"\Fajlok\DB\adatbazis.xlsx" + ";ReadOnly=0;";
string queryString =
"SELECT * FROM [MagikusF$]";
using (OdbcConnection connection =
new OdbcConnection(connectionString))
{
OdbcCommand command = new OdbcCommand(queryString, connection);
try
{
connection.Open();
OdbcDataReader reader = command.ExecuteReader();
while (reader.Read())
{
lekerdezettmagf.Add((string)reader[0]);
lekerdezettseb.Add(int.Parse(reader[1].ToString()));
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
for (int i = 0; i < lekerdezettmagf.Count; i++)
{
MagikusF ujmagf = new MagikusF();
ujmagf.nev = lekerdezettmagf[i];
ujmagf.sebzes = lekerdezettseb[i];
lekerdezettfv.Add(ujmagf);
}
Assert.AreEqual(elvartfegyv.Count, lekerdezettfv.Count);
for (int i = 0; i < elvartfegyv.Count; i++)
{
Assert.AreEqual(elvartfegyv[i].nev, lekerdezettfv[i].nev);
Assert.AreEqual(elvartfegyv[i].sebzes, lekerdezettfv[i].sebzes);
}
}
}
