public int UpdateDuzi(int id, Duzi r)
{
try
{
ISession s = DataLayer.GetSession();
IQuery query = s.CreateQuery("select r from Duzi r where r.IdDuzenja = " + id);
Duzi duzi = query.UniqueResult <Duzi>();
duzi.DatumDo = r.DatumDo;
duzi.DatumOd = r.DatumOd;
s.SaveOrUpdate(duzi);
s.Flush();
s.Close();
return(1);
}
catch (Exception exc)
{
System.Windows.Forms.MessageBox.Show(exc.Message);
return(-1);
}
}
public DuziView(Duzi d)
{
this.IdDuzenja = d.IdDuzenja;
this.DatumOd = d.DatumOd;
this.DatumDo = d.DatumDo;
this.Putnicko = d.PutnickaVozila.RegOznaka;
this.Nadzornik = d.Nadzornici.Ime;
}
public DuziView GetDuzi(int id)
{
ISession s = DataLayer.GetSession();
Duzi d = s.Query <Duzi>().Where(e => e.IdDuzenja == id).Select(p => p).FirstOrDefault();
DuziView duzenje = new DuziView(d);
return(duzenje);
}
/*
* public int AddDuzi(Duzi d)
* {
* try
* {
* ISession s = DataLayer.GetSession();
* s.Save(d);
* s.Flush();
* s.Close();
* return 1;
* }
* catch (Exception e)
* {
* return -1;
* }
* }
*/
public int RemoveDuzi(int id)
{
try
{
ISession s = DataLayer.GetSession();
Duzi d = s.Load <Duzi>(id);
s.Delete(d);
s.Flush();
s.Close();
return(1);
}
catch (Exception e)
{
return(-1);
}
}
private void btnDuzi_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
Duzi d = new Duzi();
d.DatumOd = new DateTime(2016, 2, 9);
d.DatumDo = new DateTime(2016, 4, 11);
d.Nadzornici = s.Load <Nadzornik>(2);
d.PutnickaVozila = s.Load <Putnicko>("NI-001-01");
s.Save(d);
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
}
// POST api/duzi
/* public int Post([FromBody]Duzi value)
* {
* DataProvider dp = new DataProvider();
* return dp.AddDuzi(value);
* }*/
// PUT api/duzi/5
public int Put(int id, [FromBody] Duzi value)
{
DataProvider provider = new DataProvider();
return(provider.UpdateDuzi(id, value));
}
