private void button24_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
WebStranice w = s.Load <WebStranice>(47);
if (w != null)
{
MessageBox.Show(w.URL);
}
else
{
MessageBox.Show("Ne postoji web stranica sa zadatim identifikatorom");
}
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
}
// GET api/clanak/5
public WebStranice Get(int id)
{
WebStranice WebStranice = Crud <WebStranice> .Read(sesija, id);
WebStranice.PrakticniProjekat = null;
return(WebStranice);
}
// PUT api/clanak/5
public void Put(int id, [FromBody] WebStranice WebStranice)
{
//linija je dodata da bi mogli da testiramo sa objektima koje dobijemo kao rezultat
//kontrolera ge. Potavlja se objekat iz baze, zbog toga sto je u odgovarajucoj tabeli spoljni kljuc obavezan
WebStranice.PrakticniProjekat = Crud <PrakticniProjekat> .Read(sesija, 170);
Crud <WebStranice> .Update(sesija, WebStranice);
}
// POST api/clanak
public void Post([FromBody] WebStranice WebStranice)
{
//linija je dodata da bi mogli da testiramo sa objektima koje dobijemo kao rezultat
//kontrolera ge. Potavlja se objekat iz baze, zbog toga sto je u odgovarajucoj tabeli spoljni kljuc obavezan
WebStranice.PrakticniProjekat = new PrakticniProjekat()
{
Id = 167
};
Crud <WebStranice> .Create(sesija, WebStranice);
}
private void button1_Click(object sender, EventArgs e)
{
ISession s = DataLayer.GetSession();
WebStranice stranica = new WebStranice();
stranica.Link = textBox1.Text;
stranica.PripadaProjektu = (Projekat)comboBox1.SelectedItem;
s.Save(stranica);
s.Flush();
s.Close();
}
private void button2_Click(object sender, EventArgs e)
{
ISession s = DataLayer.GetSession();
WebStranice stranica = s.Load <WebStranice>(stranice.WebStraniceId);
stranica.Link = textBox2.Text;
stranica.PripadaProjektu = (Projekat)comboBox1.SelectedItem;
s.Update(stranica);
s.Flush();
s.Close();
}
public int RemoveWebStranice(int id)
{
try
{
ISession s = DataLayer.GetSession();
WebStranice ws = s.Get <WebStranice>(id);
s.Delete(ws);
s.Flush();
s.Close();
return(1);
}
catch (Exception)
{
return(-1);
}
}
public int AddWebStranice(WebStranice k)
{
try
{
ISession s = DataLayer.GetSession();
s.Save(k);
s.Flush();
s.Close();
return(1);
}
catch (Exception)
{
return(-1);
}
}
internal static DTWebStranice GetStranicu(int idWebStranice)
{
DTWebStranice webStranica = new DTWebStranice();
try
{
ISession s = DataLayer.GetSession();
WebStranice stranica = s.Load <WebStranice>(idWebStranice);
webStranica = new DTWebStranice(stranica.Id, stranica.Link);
s.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(webStranica);
}
public WebStraniceView GetWebStraniceView(int id)
{
try
{
ISession s = DataLayer.GetSession();
WebStranice ws = s.Get <WebStranice>(id);
if (ws == null)
{
return(new WebStraniceView());
}
return(new WebStraniceView(ws));
}
catch (Exception)
{
return(new WebStraniceView());
}
}
public int UpdateWebStranice(int id, WebStranice k)
{
try
{
ISession s = DataLayer.GetSession();
WebStranice ws = s.Get <WebStranice>(id);
ws.Link = k.Link;
s.Update(ws);
s.Flush();
s.Close();
return(1);
}
catch (Exception)
{
return(-1);
}
}
private void button25_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
WebStranice w = new WebStranice
{
URL = "www.noviprojekat.com",
};
PrakticniProjekat p = s.Load <PrakticniProjekat>(48);
w.PrakticniProjekat = p;
s.Save(w);
s.Flush();
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
}
public WebStraniceView(WebStranice w)
{
this.Id = w.Id;
this.Link = w.Link;
this.PripadaProjektu = new ProjekatView(w.PripadaProjektu);
}
// To delete item which is selected in listView
private void obrisiBtn_Click(object sender, EventArgs e)
{
ISession _session;
switch (this.LastLoadedData)
{
case 0: // Projekat
try
{
_session = DataLayer.GetSession();
Projekat projekat = _session.Load <Projekat>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(projekat.Naziv);
_session.Delete(projekat);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 1: // Predmet
try
{
_session = DataLayer.GetSession();
Predmet predmet = _session.Load <Predmet>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(predmet.Naziv);
_session.Delete(predmet);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 2: // Nastavnik
try
{
_session = DataLayer.GetSession();
Nastavnik n = _session.Load <Nastavnik>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(n.Ime);
_session.Delete(n);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 3: //Clanak
try
{
_session = DataLayer.GetSession();
Clanak c = _session.Load <Clanak>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(c.Naziv);
_session.Delete(c);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 4: // Rad
try
{
_session = DataLayer.GetSession();
Rad r = _session.Load <Rad>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(r.Id.ToString());
_session.Delete(r);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 5: // Knjiga
_session = DataLayer.GetSession();
Knjiga k = _session.Load <Knjiga>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(k.Naslov);
_session.Delete(k);
_session.Flush();
_session.Close();
break;
case 6: // Autor
_session = DataLayer.GetSession();
Autor a = _session.Load <Autor>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(a.Ime + " " + a.Prezime);
_session.Delete(a);
_session.Flush();
_session.Close();
break;
case 7: // Student
_session = DataLayer.GetSession();
Student s = _session.Load <Student>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(s.Ime + " " + s.Prezime);
_session.Delete(s);
_session.Flush();
_session.Close();
break;
case 8: // Grupe
_session = DataLayer.GetSession();
Grupa g = _session.Load <Grupa>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(g.Naziv);
_session.Delete(g);
_session.Flush();
_session.Close();
break;
case 9: // Izvestaji
_session = DataLayer.GetSession();
//ITransaction t = _session.BeginTransaction();
Izvestaj i = _session.Load <Izvestaj>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(i.Opis);
_session.Delete(i);
_session.Flush();
_session.Close();
UpdateListViewIzvestaji();
break;
case 10: // Web Stranice
_session = DataLayer.GetSession();
WebStranice w = _session.Load <WebStranice>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(w.Link);
_session.Delete(w);
_session.Flush();
_session.Close();
break;
}
}
public int Put(int id, [FromBody] WebStranice k)
{
DataProvider provider = new DataProvider();
return(provider.UpdateWebStranice(id, k));
}
public int Post([FromBody] WebStranice k)
{
DataProvider provider = new DataProvider();
return(provider.AddWebStranice(k));
}
