private void fillGunsList()
{
MySQLDatabase md = new MySQLDatabase();
MySQLDatabaseInterface mdi = md.getDatabaseInterface();
mdi.open();
string query = "SELECT * FROM fegyverek";
DataTable dTGuns = mdi.getToDataTable(query);
mdi.close();
foreach (DataRow row in dTGuns.Rows)
{
int gunID = Convert.ToInt32(row["FID"].ToString());
string gunManufact = row["gyarto"].ToString();
string gunName = row["nev"].ToString();
int gunType = Convert.ToInt32(row["tipus"].ToString());
int gunFps = Convert.ToInt32(row["FPS"].ToString());
int gunWeight = Convert.ToInt32(row["suly"].ToString());
string gunMaterial = row["anyag"].ToString();
int gunPrice = Convert.ToInt32(row["ar"].ToString());
int gunVariant = Convert.ToInt32(row["varians"].ToString());
Gun g = new Gun(gunID, gunManufact, gunName, gunType, gunFps, gunWeight, gunMaterial, gunPrice, gunVariant);
guns.Add(g);
}
}
public void deleteGunInDB(Gun delG)
{
MySQLDatabase msd = new MySQLDatabase();
MySQLDatabaseInterface mdi = msd.getDatabaseInterface();
string query = delG.getDeleteQuery();
mdi.open();
mdi.executeDMQuery(query); //insert update delete
mdi.close();
}
public void addGunToDB(Gun editedG)
{
MySQLDatabase msd = new MySQLDatabase();
MySQLDatabaseInterface mdi = msd.getDatabaseInterface();
string query = editedG.getInsertQuery();
mdi.open();
mdi.executeDMQuery(query); //insert update delete
mdi.close();
}
public void addcustomerToDatabase(Customer customer)
{
MySQLDatabase msd = new MySQLDatabase();
MySQLDatabaseInterface mdi = msd.getDatabaseInterface();
string query = customer.getInsertQuery();
mdi.open();
mdi.executeDMQuery(query);
System.Windows.Forms.MessageBox.Show(query);
mdi.close();
}
public int getFID()
{
MySQLDatabase ujID = new MySQLDatabase();
MySQLDatabaseInterface mdujid = ujID.getDatabaseInterface();
mdujid.open();
int max;
bool siker = int.TryParse(mdujid.executeScalarQuery("SELECT MAX(FID) FROM fegyverek"), out max);
if (!siker)
{
//MessageBox.Show("Nem lehet megállapítani a következő rekord kulcsát. Adatbázis lekérdezési hiba.", "Hiba...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
mdujid.close();
return(max + 1);
}
private void fillCustomersListFromDatabase()
{
MySQLDatabase md = new MySQLDatabase();
MySQLDatabaseInterface mdi = md.getDatabaseInterface();
mdi.open();
string query = "SELECT * FROM pvevo ";
DataTable dtCustomer = mdi.getToDataTable(query);
mdi.close();
foreach(DataRow row in dtCustomer.Rows)
{
int customerID = Convert.ToInt32(row["vazon"].ToString());
string customerName = row["vnev"].ToString();
string customerAddress = row["vcim"].ToString();
Customer c = new Customer(customerID, customerName, customerAddress);
customers.Add(c);
}
}