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));
}
