public ActionResult Search(string filter, int? page, int? pagesize)
{
try
{
using (Context db = new Context())
{
BLL.ControleBLL controleBLL = new BLL.ControleBLL(db, _idUsuario);
var result = controleBLL.Search(filter, page, pagesize);
return View("Index", result);
}
}
catch (Exception ex)
{
this.AddFlashMessage(RP.Util.Exception.Message.Get(ex), FlashMessage.ERROR); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Index", new {@clear = true });
}
}
public ActionResult Details(int id)
{
try
{
using (Context db = new Context())
{
BLL.ControleBLL controleBLL = new BLL.ControleBLL(db, _idUsuario);
//Controle controle = controleBLL.Select(id);
Controle controle = controleBLL.FindSingle(u => u.idControle == id, q => q.Area);
return View(ControleVM.E2VM(controle));
}
}
catch (Exception ex)
{
this.AddFlashMessage(RP.Util.Exception.Message.Get(ex), FlashMessage.ERROR); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Index");
}
}
public ActionResult Create(ControleVM viewData)
{
if (ModelState.IsValid)
{
try
{
Controle controle = viewData.VM2E();
using (Context db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
BLL.ControleBLL controleBLL = new BLL.ControleBLL(db, _idUsuario);
controleBLL.Insert(controle);
controleBLL.SaveChanges();
trans.Complete();
this.AddFlashMessage(RP.Util.Resource.Message.INSERT_SUCCESS, FlashMessage.SUCCESS);
return RedirectToAction("Index");
}
}
}
catch (Exception ex)
{
this.AddFlashMessage(RP.Util.Exception.Message.Get(ex), FlashMessage.ERROR); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Index");
}
}
return View(viewData);
}
public JsonResult JsSearch(string filter, int? page, int? pagesize)
{
try
{
using (Context db = new Context())
{
BLL.ControleBLL controleBLL = new BLL.ControleBLL(db, _idUsuario);
var result = controleBLL.Search(filter, page, pagesize);
var list = result.Select(s => new
{
s.idControle,
s.nmControle,
s.dsControle,
s.Area.nmArea
});
return Json(new Util.Class.JsonCollection { result = list, count = result.TotalCount }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
Response.StatusCode = 500;
return Json(RP.Util.Exception.Message.Get(ex), JsonRequestBehavior.AllowGet);
}
}
public ActionResult DeleteConfirmed(int id)
{
try
{
using (Context db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
BLL.ControleBLL controleBLL = new BLL.ControleBLL(db, _idUsuario);
controleBLL.Delete(u => u.idControle == id);
controleBLL.SaveChanges();
trans.Complete();
this.AddFlashMessage(RP.Util.Resource.Message.DELETE_SUCCESS, FlashMessage.SUCCESS);
return RedirectToAction("Index");
}
}
}
catch (Exception ex)
{
RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
this.AddFlashMessage(RP.Util.Exception.Message.Get(ex), FlashMessage.ERROR); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Delete", id);
}
}