public ActionResult Search(string filter, int? page, int? pagesize)
{
try
{
using (var db = new Context())
{
var _bll = new BLL.EstadoBLL(db, _idUsuario);
var result = _bll.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");
}
}
public ActionResult Create(EstadoVM model)
{
if (string.IsNullOrEmpty(model.Pais.nome))
{
ModelState.AddModelError("Pais.nome", "Informe o pais");
}
if (ModelState.IsValid)
{
try
{
using (var db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
var _pais = model.GetEstado();
var _bll = new BLL.EstadoBLL(db, _idUsuario);
_bll.Insert(_pais);
_bll.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(model);
}
public JsonResult JsCreate(Estado model)
{
try
{
using (var db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
var _bll = new BLL.EstadoBLL(db, _idUsuario);
_bll.Insert(model);
_bll.SaveChanges();
trans.Complete();
return Json(new { model = model }, JsonRequestBehavior.AllowGet);
}
}
}
catch (Exception ex)
{
Response.StatusCode = 500;
return Json(RP.Util.Exception.Message.Get(ex), JsonRequestBehavior.AllowGet);
}
}
public JsonResult JsSearch(string filter, int? page, int? pagesize)
{
try
{
using (var db = new Context())
{
var _bll = new BLL.EstadoBLL(db, _idUsuario);
var result = _bll.Search(filter, page, pagesize);
var list = result.Select(s => new
{
s.idEstado,
s.nome,
s.sigla,
pais = s.Pais.nome
});
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);
}
}
private ActionResult GetView(int id)
{
try
{
using (var db = new Context())
{
var _bll = new BLL.EstadoBLL(db, _idUsuario);
var _pais = _bll.FindSingle(e => e.idEstado == id, u => u.Pais);
return View(EstadoVM.GetEstado(_pais));
}
}
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 DeleteConfirmed(int id)
{
try
{
using (var db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
var _bll = new BLL.EstadoBLL(db, _idUsuario);
_bll.Delete(e => e.idEstado == id);
_bll.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);
}
}
