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