public Panoi Get(int id) { DataProvider provider = new DataProvider(); Panoi panoi = provider.GetPanoi(id); return(panoi); }
public Panoi GetPanoi(int id) { ISession s = DataLayer.GetSession(); Panoi panoi = s.Query <Panoi>().Where(x => x.id > id).Select(p => p).FirstOrDefault(); return(panoi); }
private void buttonPotvrdi_Click(object sender, EventArgs e) { try { ISession s = DataLayer.GetSession(); if (radioButtonStampa.Checked) { Stampa st = new Stampa(); st.nazivLista = textBoxList.Text; st.kolor = textBoxKolor.Text; st.iznos = Convert.ToInt32(textBoxIznos.Text); st.pocetakReklamiranja = dateTimePicker1.Value; st.krajReklamiranja = dateTimePicker2.Value; s.Save(st); } else if (radioButtonPanoi.Checked) { Panoi pn = new Panoi(); pn.grad = textBoxGrad.Text; pn.nazivAgencije = textBoxAgencija.Text; pn.adresa = textBoxAdresa.Text; pn.povrsinaPanoa = Convert.ToInt16(textBoxPovrsina.Text); pn.iznos = Convert.ToInt32(textBoxIznos.Text); pn.pocetakReklamiranja = dateTimePicker1.Value; pn.krajReklamiranja = dateTimePicker2.Value; s.Save(pn); } else if (radioButtonTV.Checked) { R_TV rt = new R_TV(); rt.nazivStanice = textBoxTV.Text; rt.trajanje = Convert.ToInt32(textBoxTrajanje.Text); rt.brojEmitovanja = Convert.ToInt16(textBoxEmitovanja.Text); rt.iznos = Convert.ToInt32(textBoxIznos.Text); rt.pocetakReklamiranja = dateTimePicker1.Value; rt.krajReklamiranja = dateTimePicker2.Value; s.Save(rt); } s.Flush(); s.Close(); MessageBox.Show("Uspesno ste dodali podatke u bazu."); g.RefreshGridPanoi(); g.RefreshGridR_TV(); g.RefreshGridStampa(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public int UpdatePanoi(Panoi pano) { try { ISession s = DataLayer.GetSession(); s.Update(pano); s.Flush(); s.Close(); return(1); } catch (Exception) { return(-1); } }
public int AddPanoi(Panoi pan) { try { ISession s = DataLayer.GetSession(); s.Save(pan); s.Flush(); s.Close(); return(1); } catch (Exception) { return(-1); } }
public int Put(Panoi pano) { DataProvider provider = new DataProvider(); return(provider.UpdatePanoi(pano)); }
public int Delete(Panoi pano) { DataProvider provider = new DataProvider(); return(provider.RemovePanoi(pano)); }
public int Post(Panoi pan) { DataProvider provider = new DataProvider(); return(provider.AddPanoi(pan)); }