public bool DeleteObject(StavkaProforme objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); _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 CreateObject(StavkaProforme objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); objekat.Lajsna = _broker.ReturnByCriteria($"WHERE NazivLajsne LIKE '{objekat.Lajsna.NazivLajsne}'", objekat.Lajsna).OfType <Lajsna>().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 StavkaProforme SelectObject(StavkaProforme objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); StavkaProforme stavka = _broker.SelectObjectJoin(objekat) as StavkaProforme; _broker.Commit(); return(stavka); } 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 Delete(int id, StavkaProforme objekat) { try { return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
public ActionResult Edit(int id, StavkaProforme objekat) { try { _logic.UpdateObject(objekat); return(RedirectToAction(nameof(Index), "Proforma")); } catch (Exception ex) { return(View("Error", new Error() { Greska = ex.Message })); } }
// GET: StavkaProformeController/Delete/5 public ActionResult Delete(int id) { try { StavkaProforme objekat = _logic.SelectObject(new StavkaProforme() { RedniBroj = id }); _logic.DeleteObject(objekat); return(RedirectToAction(nameof(Index), "Proforma")); } catch (Exception ex) { return(View("Error", new Error() { Greska = ex.Message })); } }
// GET: StavkaProformeController/Edit/5 public ActionResult Edit(int id) { try { StavkaProforme objekat = _logic.SelectObject(new StavkaProforme() { RedniBroj = id }); List <Lajsna> lajsne = _logic.GetLajsne(); ViewBag.Lajsne = new SelectList(lajsne, "Id", "NazivLajsne", $"{objekat.Lajsna.NazivLajsne}"); return(View(objekat)); } catch (Exception ex) { return(View("Error", new Error() { Greska = ex.Message })); } }