private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 3) {
try
{
foreach (DataGridViewRow row in dataGridView2.Rows)
{
if (((Egzemplarz)row.Cells["Egzemplarz"].Value).IdEgzemplarza == (int)dataGridView1.Rows[e.RowIndex].Cells["IdEgzemplarza"].Value)
return;
}
using (var db = new KsiegarniaEntities())
{
Egzemplarz egzemplarz = ((Egzemplarz)egzemplarzBindingSource[0]);
var oferta = new OfertaOferenta
{
CenaHurtowa = 11 ,
Egzemplarz_IdEgzemplarza =(int)dataGridView1.Rows[e.RowIndex].Cells["IdEgzemplarza"].Value,
Oferent_IdOferenta = db.Oferents.First().IdOferenta
};
db.OfertaOferentas.Add(oferta);
db.SaveChanges();
reload(sender, e);
return;
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
return;
}
}
}
private void zatwierdzButton_Click(object sender, EventArgs e)
{
if (!DesignMode)
{
Egzemplarz eg = new Egzemplarz();
Oferent of = new Oferent();
OfertaOferenta oo = new OfertaOferenta();
eg = (Egzemplarz)egzemplarzBindingSource.Current;
of = (Oferent)oferentBindingSource.Current;
oo = (OfertaOferenta)ofertaOferentaBindingSource.Current;
oo.Oferent_IdOferenta = of.IdOferenta;
ofertaOferentaBindingSource.ResetBindings(false);
Funkcje.Instance._context.SaveChanges();
}
}
private void zatwierdzButton_Click(object sender, EventArgs e)
{
if (!DesignMode)
{
Egzemplarz eg = new Egzemplarz();
Oferent of = new Oferent();
OfertaOferenta oo = new OfertaOferenta();
eg = (Egzemplarz)egzemplarzBindingSource.Current;
of = (Oferent)oferentBindingSource.Current;
oo = (OfertaOferenta)ofertaOferentaBindingSource.Current;
oo.Oferent_IdOferenta = of.IdOferenta;
ofertaOferentaBindingSource.ResetBindings(false);
Funkcje.Instance._context.SaveChanges();
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 3)
{
try
{
foreach (DataGridViewRow row in dataGridView2.Rows)
{
if (((Egzemplarz)row.Cells["Egzemplarz"].Value).IdEgzemplarza == (int)dataGridView1.Rows[e.RowIndex].Cells["IdEgzemplarza"].Value)
{
return;
}
}
using (var db = new KsiegarniaEntities())
{
Egzemplarz egzemplarz = ((Egzemplarz)egzemplarzBindingSource[0]);
var oferta = new OfertaOferenta
{
CenaHurtowa = 11,
Egzemplarz_IdEgzemplarza = (int)dataGridView1.Rows[e.RowIndex].Cells["IdEgzemplarza"].Value,
Oferent_IdOferenta = db.Oferents.First().IdOferenta
};
db.OfertaOferentas.Add(oferta);
db.SaveChanges();
reload(sender, e);
return;
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
return;
}
}
}
