private void btnMentes_Click(object sender, EventArgs e)
{
DataRow row = ds.Tables[0].NewRow();
row[0] = txtID.Text;
row[1] = txtNev.Text;
row[2] = aktiv();
ds.Tables[0].Rows.Add(row);
try
{
objConnect.UpdateDatabase(ds);
MaxRows++;
inc = MaxRows - 1;
MessageBox.Show("Új beszallító elmentve");
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
btnUj.Enabled = true;
//btnNext.Enabled = true;
//btnPrev.Enabled = true;
comboBox1.Enabled = true;
btnTorles.Enabled = true;
btnMod.Enabled = true;
btnMegse.Enabled = false;
btnMentes.Enabled = false;
combofill();
}
private void btnMentes_Click(object sender, EventArgs e)
{
DataRow row = ds.Tables[0].NewRow();
row[0] = txtID.Text;
row[1] = txtEAN.Text;
row[2] = txtNev.Text;
row[3] = Arulhatoe();
row[4] = Rendelhetoe();
row[5] = comboBeszallito.SelectedItem.ToString();
ds.Tables[0].Rows.Add(row);
try
{
objConnect.UpdateDatabase(ds);
MaxRows++;
inc = MaxRows - 1;
MessageBox.Show("Új termék elmentve");
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
BoltKapcsolat();
btnUj.Enabled = true;
comboTermek.Enabled = true;
btnTorles.Enabled = true;
btnModosit.Enabled = true;
btnMegse.Enabled = false;
btnMentes.Enabled = false;
combofill();
}
private void BoltKapcsolat()
{
try
{
DatabaseConnection objBoltok = new DatabaseConnection();
conTermek = Properties.Settings.Default.DatabaseConnectionString;
objBoltok.connection_string = conTermek;
objBoltok.Sql = "select * from bolt";
DataSet dsBoltok = objBoltok.GetConnection;
int MaxRowsBoltok = dsBoltok.Tables[0].Rows.Count;
objBoltok.Sql = "select * from bolt_termek";
DataSet dsKapcsolat = objBoltok.GetConnection;
for (int i = 0; i < MaxRowsBoltok; i++)
{
DataRow boltRow = dsBoltok.Tables[0].Rows[i];
DataRow row = dsKapcsolat.Tables[0].NewRow();
row[0] = boltRow.ItemArray.GetValue(0).ToString();
row[1] = txtID.Text;
row[2] = 0;
dsKapcsolat.Tables[0].Rows.Add(row);
}
objBoltok.UpdateDatabase(dsKapcsolat);
MessageBox.Show("Új termék hozzáadva a boltokhoz");
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
