private void btnUkloniSponzora_Click(object sender, EventArgs e)
{
if (!Provera.chkIfSelected(dgvPostojeciSponzori))
{
return;
}
try
{
ISession s = DataLayer.GetSession();
Sponzor spon = dgvPostojeciSponzori.CurrentRow.DataBoundItem as Sponzor;
Sponzorise sp = (from z in s.Query <Sponzorise>()
where z.SponzoriseSponzor == spon && z.SponzoriseTurnir == Turn
select z).First();
s.Delete(sp);
s.Flush();
OsveziPostojeceGridove();
MessageBox.Show("Sponzor vise ne sponzorise turnir: " + Turn.Naziv);
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
return;
}
}
private void btnPoveziSponzora_Click(object sender, EventArgs e)
{
if (!Provera.chkIfSelected(dgvSviSponzori))
{
return;
}
try
{
ISession s = DataLayer.GetSession();
Sponzor sp = dgvSviSponzori.CurrentRow.DataBoundItem as Sponzor;
Sponzorise spon = new Sponzorise();
spon.SponzoriseSponzor = sp;
spon.SponzoriseTurnir = Turn;
//if ((from z in s.Query<Sponzorise>()
// where z.SponzoriseSponzor == sp && z.SponzoriseTurnir == Turn
// select z).Count() == 0)
if ((from z in s.Query <Turnir>()
where z.Id == Turn.Id && z.SponzoriseSponzor.All(x => x.SponzoriseSponzor.Naziv != sp.Naziv)
select z).Count() == 1)
{
s.Save(spon);
}
else
{
s.Close();
MessageBox.Show("Ovaj sponzor je vec prisutan");
return;
}
s.Flush();
OsveziPostojeceGridove();
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
return;
}
}
