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