public ActionResult Create(NalogZaUtovar nalogzautovar) { if (ModelState.IsValid) { db.NalogZaUtovar.Add(nalogzautovar); db.SaveChanges(); return(RedirectToAction("Details", "DnevnikPrevoza", new { id = nalogzautovar.IdDnevnik })); } /* * String godina = "/" + DateTime.Today.Year.ToString().Substring(2, 2); * * var nalozi = db.NalogZaUtovar.Where(c => c.BrojNaloga.EndsWith(godina)).ToList().Select(c => new { Broj = Convert.ToInt32(c.BrojNaloga.Replace(godina, "")) }); * * string nalog = ""; * * if (nalozi.Count() == 0) * nalog = "1" + godina; * else * nalog = (nalozi.Max(c => c.Broj) + 1).ToString() + godina; * */ ViewBag.BrojNaloga = db.DnevnikPrevoza.Find(nalogzautovar.IdDnevnik).SerijskiBroj; ViewBag.IdDnevnik = nalogzautovar.IdDnevnik; ViewBag.IdSubjekt = new SelectList(db.Subjekt, "IdSubjekt", "Naziv"); return(View(nalogzautovar)); }
// GET: NalogController/Edit/5 public ActionResult Edit(int id) { try { NalogZaUtovar objekat = _logic.SelectObject(new NalogZaUtovar() { Id = id }); List <Carinik> carinici = _logic.GetCarinici(); List <Porudzbina> porudzbine = _logic.GetPorudzbineUpdate(); List <Prevoznik> prevoznici = _logic.GetPrevoznici(); ViewBag.Porudzbine = new SelectList(porudzbine, "Id", "Id", $"{objekat.Porudzbina.Id}"); ViewBag.Prevoznici = new SelectList(prevoznici, "Id", "NazivKompanije", $"{objekat.Prevoznik.NazivKompanije}"); ViewBag.CariniciIzvoz = new SelectList(carinici, "Id", "NazivKompanije", $"{objekat.CarinikIzvoz.NazivKompanije}"); ViewBag.CariniciUvoz = new SelectList(carinici, "Id", "NazivKompanije", $"{objekat.CarinikIzvoz.NazivKompanije}"); return(View(objekat)); } catch (Exception ex) { return(View("Error", new Error() { Greska = ex.Message })); } }
public bool DeleteObject(NalogZaUtovar objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); NalogZaUtovar nalog = _broker.SelectObject(objekat) as NalogZaUtovar; _broker.DeleteObject(objekat); _broker.Commit(); return(true); } catch (SqlException ex) { Debug.Write(">>>>>>>> " + ex.Message); _broker.Rollback(); throw new Exception(ex.Message); } catch (Exception ex) { Debug.WriteLine(">>>> " + ex.Message); _broker.Rollback(); throw new Exception(ex.Message); } finally { _broker.CloseConnection(); } }
public bool UpdateObject(NalogZaUtovar objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); if (!_broker.UpdateObject(objekat)) { throw new Exception(); } _broker.Commit(); return(true); } catch (SqlException ex) { Debug.Write(">>>>>>>> " + ex.Message); _broker.Rollback(); throw new Exception(ex.Message); } catch (Exception ex) { Debug.WriteLine(">>>> " + ex.Message); _broker.Rollback(); return(false); } finally { _broker.CloseConnection(); } }
public bool CreateObject(NalogZaUtovar objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); objekat.Prevoznik = _broker.ReturnByCriteriaJoin($" WHERE NazivKompanije LIKE '{objekat.Prevoznik.NazivKompanije}'", objekat.Prevoznik).OfType <Prevoznik>().ToList().FirstOrDefault(); objekat.CarinikIzvoz = _broker.ReturnByCriteriaJoin($" WHERE NazivKompanije LIKE '{objekat.CarinikIzvoz.NazivKompanije}'", objekat.CarinikIzvoz).OfType <Carinik>().ToList().FirstOrDefault(); objekat.CarinikUvoz = _broker.ReturnByCriteriaJoin($" WHERE NazivKompanije LIKE '{objekat.CarinikUvoz.NazivKompanije}'", objekat.CarinikUvoz).OfType <Carinik>().ToList().FirstOrDefault(); _broker.InsertObject(objekat); _broker.Commit(); return(true); } catch (SqlException ex) { Debug.Write(">>>>>>>> " + ex.Message); _broker.Rollback(); throw new Exception(ex.Message); } catch (Exception ex) { Debug.WriteLine(">>>> " + ex.Message); _broker.Rollback(); throw new Exception(ex.Message); } finally { _broker.CloseConnection(); } }
public List <NalogZaUtovar> SelectAll(NalogZaUtovar objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); List <NalogZaUtovar> list = _broker.SelectAllJoin(objekat).OfType <NalogZaUtovar>().ToList(); _broker.Commit(); return(list); } catch (SqlException ex) { Debug.Write(">>>>>>>> " + ex.Message); _broker.Rollback(); throw new Exception(ex.Message); } catch (Exception ex) { Debug.WriteLine(">>>> " + ex.Message); _broker.Rollback(); throw new Exception(ex.Message); } finally { _broker.CloseConnection(); } }
public ActionResult DeleteConfirmed(int id) { NalogZaUtovar nalogzautovar = db.NalogZaUtovar.Find(id); db.NalogZaUtovar.Remove(nalogzautovar); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(int id = 0) { NalogZaUtovar nalogzautovar = db.NalogZaUtovar.Find(id); if (nalogzautovar == null) { return(HttpNotFound()); } return(View(nalogzautovar)); }
public ActionResult Edit(NalogZaUtovar nalogzautovar) { if (ModelState.IsValid) { db.Entry(nalogzautovar).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", "DnevnikPrevoza", new { id = nalogzautovar.IdDnevnik })); } ViewBag.IdDnevnik = new SelectList(db.DnevnikPrevoza, "IdDnevnik", "BrojNaloga", nalogzautovar.IdDnevnik); ViewBag.IdSubjekt = new SelectList(db.Subjekt, "IdSubjekt", "Naziv", nalogzautovar.IdSubjekt); return(View(nalogzautovar)); }
public ActionResult Edit(int id = 0) { NalogZaUtovar nalogzautovar = db.NalogZaUtovar.Find(id); if (nalogzautovar == null) { return(HttpNotFound()); } ViewBag.IdDnevnik = new SelectList(db.DnevnikPrevoza, "IdDnevnik", "BrojNaloga", nalogzautovar.IdDnevnik); ViewBag.IdSubjekt = new SelectList(db.Subjekt, "IdSubjekt", "Naziv", nalogzautovar.IdSubjekt); return(View(nalogzautovar)); }
public ActionResult Create(NalogZaUtovar objekat) { try { _logic.CreateObject(objekat); return(RedirectToAction(nameof(Index))); } catch (Exception ex) { return(View("Error", new Error() { Greska = ex.Message })); } }
// GET: NalogController/Details/5 public ActionResult Details(int id) { try { NalogZaUtovar objekat = _logic.SelectObject(new NalogZaUtovar() { Id = id }); return(View(objekat)); } catch (Exception ex) { return(View("Error", new Error() { Greska = ex.Message })); } }