private void CargarAreas()
{
BLL.AreaBLL ctrArea = new BLL.AreaBLL();
List <EArea> Areas = null;
Areas = ctrArea.getAll();
if (Areas.Count > 0)
{
cboArea.DisplayMember = "nombre";
cboArea.ValueMember = "codigo";
cboArea.DataSource = Areas;
}
}
public ActionResult Search(string filter, int? page, int? pagesize)
{
try
{
LogBLL.Insert(new LogDado("Search()", "Area", _idUsuario));
using (Context db = new Context())
{
BLL.AreaBLL areaBLL = new BLL.AreaBLL(db, _idUsuario);
var result = areaBLL.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); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Index");
}
}
public ActionResult Query(string area, string descricao, string modulo, int? page, int? pagesize, bool searching = false)
{
try
{
if (searching)
{
LogBLL.Insert(new LogDado("Query()", "Area", _idUsuario));
using (Context db = new Context())
{
BLL.AreaBLL areaBLL = new BLL.AreaBLL(db, _idUsuario);
var result = areaBLL.Search(area, descricao, modulo, page, pagesize);
return View("Query", result);
}
}
return View("Query");
}
catch (Exception ex)
{
this.AddFlashMessage(RP.Util.Exception.Message.Get(ex), FlashMessage.ERROR); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Query");
}
}
public ActionResult Details(int id)
{
try
{
LogBLL.Insert(new LogDado("Details()", "Area", _idUsuario));
using (Context db = new Context())
{
BLL.AreaBLL areaBLL = new BLL.AreaBLL(db, _idUsuario);
Area area = areaBLL.FindSingle(e => e.idArea == id, i => i.Modulo);
return View(RP.Sistema.Web.Models.Area.AreaVM.E2VM(area));
}
}
catch (Exception ex)
{
this.AddFlashMessage(RP.Util.Exception.Message.Get(ex), FlashMessage.ERROR); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Index");
}
}
public JsonResult JsDetails(int idArea)
{
try
{
using (Context db = new Context())
{
BLL.AreaBLL areaBLL = new BLL.AreaBLL(db, _idUsuario);
Area area = areaBLL.FindSingle(e => e.idArea == idArea, i => i.Modulo);
if (area == null)
{
return Json(string.Empty, JsonRequestBehavior.AllowGet);
}
var result = new
{
area.idArea,
area.nmArea,
area.dsArea
};
return Json(result, 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 (Context db = new Context())
{
BLL.AreaBLL areaBLL = new BLL.AreaBLL(db, _idUsuario);
var result = areaBLL.Search(filter, page, pagesize);
var list = result.Select(s => new {
s.idArea,
s.nmArea,
s.dsArea
});
return Json(new JsonCollection{ result = list, count = result.TotalCount }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
Response.StatusCode = 500;
return Json(Util.Exception.Message.Get(ex), JsonRequestBehavior.AllowGet);
}
}
public ActionResult Report(string filter)
{
//if (report.Acao == RP.Report.TipoAcao.Agendar)
//{
// return RP.Report.Generic.Json(report);
//}
int idUsuario = _idUsuario > 0 ? _idUsuario : Convert.ToInt32(Request["idUsuario"]);
Dictionary<string, System.Data.DataSet> listData = new Dictionary<string, System.Data.DataSet>();
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.DataTable table = new System.Data.DataTable("table");
System.Data.DataRow row;
string titulo;
BLL.AreaBLL areaBLL;
try
{
using (var db = new Context())
{
areaBLL = new BLL.AreaBLL(db, idUsuario);
var areas = areaBLL.Search(filter);
table.Columns.Add(new System.Data.DataColumn("idarea", System.Type.GetType("System.Int32")));
table.Columns.Add(new System.Data.DataColumn("nmarea", System.Type.GetType("System.String")));
table.Columns.Add(new System.Data.DataColumn("dsarea", System.Type.GetType("System.String")));
table.Columns.Add(new System.Data.DataColumn("flusaurl", System.Type.GetType("System.String")));
foreach (Area area in areas)
{
row = table.NewRow();
row["idarea"] = area.idArea;
row["nmarea"] = area.nmArea;
row["dsarea"] = area.dsArea;
row["flusaurl"] = area.flUsaURL;
table.Rows.Add(row);
}
ds.Tables.Add(table);
listData.Add("subentidade.rpt", RP.Sistema.BLL.EntidadeBLL.getDtSetEntidade(db));
listData.Add("table", ds);
}
titulo = string.Format("<center>Relação de Áreas{0}</center>", !string.IsNullOrEmpty(filter) ? ("</br>Nome contendo: " + filter) : "");
//return View();
return RP.Report.Generic.Report(new RP.Report.Generic.GenericData
{
exportTO = RP.Report.Generic.stringTOExportFormatType("PDF"),
fileRPT = "relArea.rpt",
listData = listData,
parameters = new Dictionary<string, object> { { "titulo", titulo } },
});
}
catch (RP.Report.Exception rex)
{
RP.Util.Entity.ErroLog.Add(rex, Session.SessionID, idUsuario);
return RedirectToAction("Index", "Erro");
}
catch (Exception ex)
{
RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, idUsuario);
return RedirectToAction("Index", "Erro");
}
finally
{
ds.Dispose();
}
}
public ActionResult DeleteConfirmed(int id)
{
try
{
LogBLL.Insert(new LogDado("DeleteConfirmed", "Area", _idUsuario));
using (Context db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
BLL.AreaBLL areaBLL = new BLL.AreaBLL(db, _idUsuario);
areaBLL.Delete(e => e.idArea == id);
areaBLL.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); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Delete", id);
}
}
public ActionResult Edit(RP.Sistema.Web.Models.Area.AreaVM viewData)
{
try
{
LogBLL.Insert(new LogDado("Edit(RP.Sistema.Web.Models.Area.AreaVM viewData)", "Area", _idUsuario));
if (ModelState.IsValid)
{
var area = viewData.VM2E();
using (Context db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
area.flUsaURL = area.flUsaURL.ToLower() == "true" || area.flUsaURL.ToLower() == "sim" ? "Sim" : "Não";
area.idModulo = area.idModulo;
BLL.AreaBLL areaBLL = new BLL.AreaBLL(db, _idUsuario);
areaBLL.Update(area);
areaBLL.SaveChanges();
trans.Complete();
this.AddFlashMessage(RP.Util.Resource.Message.EDIT_SUCCESS, FlashMessage.SUCCESS);
return RedirectToAction("Index");
}
}
}
return View(viewData);
}
catch (Exception ex)
{
this.AddFlashMessage(RP.Util.Exception.Message.Get(ex), FlashMessage.ERROR); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Index");
}
}
