public R_TV GetR_TV(int id)
{
ISession s = DataLayer.GetSession();
R_TV r_tv = s.Query <R_TV>().Where(x => x.id == id).Select(p => p).FirstOrDefault();
return(r_tv);
}
public R_TV Get(int id)
{
DataProvider provider = new DataProvider();
R_TV r_tv = provider.GetR_TV(id);
return(r_tv);
}
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 UpdateR_TV(R_TV r_tv)
{
try
{
ISession s = DataLayer.GetSession();
s.Update(r_tv);
s.Flush();
s.Close();
return(1);
}
catch (Exception)
{
return(-1);
}
}
public int Put(R_TV r_tv)
{
DataProvider provider = new DataProvider();
return(provider.UpdateR_TV(r_tv));
}
public int Delete(R_TV r_tv)
{
DataProvider provider = new DataProvider();
return(provider.RemoveR_TV(r_tv));
}
public int Post(R_TV r_tv)
{
DataProvider provider = new DataProvider();
return(provider.AddR_TV(r_tv));
}
