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