private void btnUkloniOrganizatora_Click(object sender, EventArgs e)
{
if (!Provera.chkIfSelected(dgvPostojeciOrganizatori))
{
return;
}
try
{
ISession s = DataLayer.GetSession();
Organizator o = dgvPostojeciOrganizatori.CurrentRow.DataBoundItem as Organizator;
Organizuje org = (from z in s.Query <Organizuje>()
where z.OrganizujeOrganizator == o && z.OrganizujeTurnir == Turn
select z).First();
s.Delete(org);
s.Flush();
OsveziPostojeceGridove();
MessageBox.Show("Organizator vise ne organizuje turnir: " + Turn.Naziv);
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
return;
}
}
private void btnMTM_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
Organizuje o = new Organizuje();
Turnir t = s.Load <TurnirEgzibicioniHumanitarni>(503);
Organizator r = s.Load <Organizator>("734234");
o.OrganizujeOrganizator = r;
o.OrganizujeTurnir = t;
s.SaveOrUpdate(o);
//s.SaveOrUpdate(t);
// s.SaveOrUpdate(r);
s.Flush();
s.Close();
MessageBox.Show("Uspesno dodata veza Many to many");
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
MessageBox.Show("Desila se greska");
}
}
private void btnPoveziOrganizatora_Click(object sender, EventArgs e)
{
if (!Provera.chkIfSelected(dgvSviOrganizatori))
{
return;
}
try
{
ISession s = DataLayer.GetSession();
Organizator o = dgvSviOrganizatori.CurrentRow.DataBoundItem as Organizator;
Organizuje org = new Organizuje();
org.OrganizujeOrganizator = o;
org.OrganizujeTurnir = Turn;
//if ((from z in s.Query<Organizuje>()
// where z.OrganizujeOrganizator == o && z.OrganizujeTurnir == Turn
// select z).Count() == 0)
if ((from z in s.Query <Turnir>()
where z.Id == Turn.Id && z.OrganizujeOrganizator.All(x => x.OrganizujeOrganizator.MatBr != o.MatBr)
select z).Count() == 1)
{
s.Save(org);
}
else
{
s.Close();
MessageBox.Show("Ovaj organizator je vec prisutan");
return;
}
s.Flush();
OsveziPostojeceGridove();
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
return;
}
}
