public ActionResult Object_Create([DataSourceRequest] DataSourceRequest request, ViewModelObjeto model) { try { if (model != null && ModelState.IsValid) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); Objeto obj = new Objeto { Activo = true, Descripcion = model.Description, IdObjetoPadre = model.IdNewPermissionParent, IdProducto = model.IdProduct, Nombre = model.Name }; db.Objeto.Add(obj); db.SaveChanges(); } } catch (Exception ex) { ModelState.AddModelError("Model", ex.Message); } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }
public ActionResult OperarMenu(Models.Data.Menu model) { try { if (ModelState.IsValid) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); if (model.IdMenu <= 0) { db.Menu.Add(model); db.SaveChanges(); //model.Add(); } else { var original = db.Menu.Find(model.IdMenu); if (original != null) { db.Entry(original).CurrentValues.SetValues(model); db.SaveChanges(); } // model.Update(); } } } catch (Exception ex) { ModelState.AddModelError("s", ex); } return(PartialView("Menu", model)); }
public ActionResult DeleteUserToRole(int pIdRole, int pIdUser) { try { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); UsuarioPorRol model = db.UsuarioPorRol.Where(x => x.IdRol == pIdRole && x.IdUsuario == pIdUser).FirstOrDefault(); db.UsuarioPorRol.Attach(model); db.Entry(model).State = EntityState.Deleted; HistoricoUsuarioPorRol model2 = new HistoricoUsuarioPorRol(); model2.IdRol = model.IdRol; model2.IdUsuario = model.IdUsuario; model2.TransacUser = model.TransacUser; model2.TransacDateTime = model.TransacDateTime; model2.HistoricTransacUser = "******"; model2.HistoricTransacDateTime = DateTime.Now; db.HistoricoUsuarioPorRol.Add(model2); db.SaveChanges(); return(Json(new { success = true, error = "" })); } catch (Exception ex) { return(Json(new { success = false, error = ex.Message })); } }
public ActionResult RoleToPermission(int pIdRole) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); Rol rol = db.Rol.Where(x => x.IdRol == pIdRole).FirstOrDefault(); return(View(rol)); }
public ActionResult UserType_Read([DataSourceRequest] DataSourceRequest request) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); List <TipoUsuario> userTypesList = db.TipoUsuario.Where(x => x.Activo == true).ToList(); return(Json(userTypesList .ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public ActionResult GlobalParameter_Read([DataSourceRequest] DataSourceRequest request, int?pIdOwner) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); return(new JsonNetResult { Data = db.ParametroGeneral.Where(x => x.Activo && (pIdOwner == null || x.IdPropietario == pIdOwner)).ToList() .ToDataSourceResult(request), JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult GetProducts(int?IdOwner) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); return(Json(db.Producto.Where(y => ((y.IdPropietario == IdOwner && IdOwner != null) || IdOwner == null) && y.Activo).ToList() .Select(x => new DropDownListItem { Text = x.Nombre, Value = x.IdProducto.ToString() }).OrderBy(e => e.Text).ToList(), JsonRequestBehavior.AllowGet)); }
/// <summary> /// Request de la información de propietarios. /// </summary> /// <param name="request"></param> /// <returns></returns> public ActionResult Owner_Read([DataSourceRequest] DataSourceRequest request) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); return(new JsonNetResult { Data = db.Propietario.Where(x => x.Activo == true).ToList() .ToDataSourceResult(request), JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult Product_Create([DataSourceRequest] DataSourceRequest request, Producto model) { if (model != null && ModelState.IsValid) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); model.Activo = true; db.Producto.Add(model); db.SaveChanges(); } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }
public JsonResult GetOwners() { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); return(Json(db.Propietario.Where(x => x.Activo).ToList() .Select(x => new DropDownListItem { Text = x.Nombre, Value = x.IdPropietario.ToString() }).OrderBy(e => e.Text).ToList(), JsonRequestBehavior.AllowGet)); }
private string GetGlobalParametersEnum(int pIdOwner) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); string result = "public enum Parameters <br> { <br>"; db.ParametroGeneral.Where(y => y.Activo && y.IdPropietario == pIdOwner).ToList().ForEach(x => { result += " " + x.Nombre.Replace(" ", "") + "" + x.ParametroTipo.Nombre + " = " + x.IdPropietario + ", <br>"; }); result += " } "; return(result); }
public JsonResult AssignedUsers_Read([DataSourceRequest] DataSourceRequest request, int pIdRole) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); List <Usuario> result = db.UsuarioPorRol.Where(x => x.IdRol == pIdRole).Select(x => x.Usuario).ToList(); return(new JsonNetResult { Data = result .ToTreeDataSourceResult(request), JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult UsersToAsign_Read([DataSourceRequest] DataSourceRequest request, int pIdRole) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); List <Usuario> result = db.Usuario.Where(x => db.UsuarioPorRol.Where(y => y.IdUsuario == x.IdUsuario && y.IdRol == pIdRole).Count() == 0).ToList(); return(new JsonNetResult { Data = result .ToTreeDataSourceResult(request), JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
/// <summary> /// Elimina una relación de un permiso con un rol. /// </summary> /// <param name="IdPermission">Identificador del permiso</param> /// <param name="IdRole">Identificador del rol</param> /// <param name="UserTransac">Usuario realiza la transacción</param> public void Delete(int IdObjeto, int IdRol, string UserTransac) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); if (IdObjeto > 0 && IdRol > 0 && UserTransac.Length > 0) { db.SP_PermisoAObjeto_Del(IdObjeto, IdRol, UserTransac); } else { throw new Exception("Error en en los identificadores."); } }
public ActionResult Users() { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); ViewBag.UserTypes = db.TipoUsuario.Where(x => x.Activo == true) .Select(x => new DropDownListItem { Text = x.Nombre, Value = x.IdTipoUsuario.ToString() }).OrderBy(e => e.Text).ToList(); return(View()); }
private List <Objeto> GetAllChilds(int idObjeto) { List <Objeto> result = new List <Objeto>(); BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); db.Objeto.Where(x => x.Activo && x.IdObjetoPadre == idObjeto).ToList().ForEach(x => { result.Add(x); result.AddRange(GetAllChilds(x.IdObjeto)); }); return(result); }
public ActionResult GlobalParameter_Update([DataSourceRequest] DataSourceRequest request, ParametroGeneral model) { try { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); var original = db.ParametroGeneral.Find(model.IdParametroGeneral); model.TransacUser = this.HttpContext.GetActualUser().NombreUsuario; model.TransacDateTime = DateTime.Now; if (ModelState.IsValid && original != null) { switch (model.IdParametroTipo) { case (int)EParametroTipo.Entero: Convert.ToInt32(model.Valor); break; case (int)EParametroTipo.Decimal: Convert.ToDecimal(model.Valor); break; case (int)EParametroTipo.Booleano: Convert.ToBoolean(model.Valor); break; case (int)EParametroTipo.FechaHora: Convert.ToDateTime(model.Valor); break; case (int)EParametroTipo.Hora: Convert.ToDateTime(model.Valor); break; case (int)EParametroTipo.EncryptString: BarcoSoftUtilidades.Utilidades.Cryptography.Decrypt(model.Valor); break; } db.Entry(original).CurrentValues.SetValues(model); db.SaveChanges(); } } catch (Exception ex) { ModelState.AddModelError("Error", ex.Message); } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }
public JsonResult GetPermission(int IdProduct, int?IdPermission) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); var hijos = new List <Objeto>(); if (IdPermission != null) { hijos = GetAllChilds((int)IdPermission); } return(Json(db.Objeto.Where(y => y.Activo && y.IdProducto == IdProduct && (IdPermission == null || (y.IdObjeto != IdPermission && hijos.Where(z => z.IdObjeto == y.IdObjeto).Count() == 0))) .Select(x => new DropDownListItem { Text = x.Nombre, Value = x.IdObjeto.ToString() }).OrderBy(e => e.Text).ToList(), JsonRequestBehavior.AllowGet)); }
public ActionResult ChangePassword(ChangePasswordViewModel model) { try { if (ModelState.IsValid) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); } } catch (Exception ex) { ViewBag.boolResultado = false; ViewBag.mensajerError = ex.Message; } return(View()); }
public ActionResult Menu(int pIdObject, string pObject) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); var menu = db.Menu.Where(x => x.IdObjeto == pIdObject);//new SecurityBL.General.Menu().GetActive().Where(x => x.IdPermission == pIdPermission); if (menu.Count() == 0) { Models.Data.Menu newMenu = new Models.Data.Menu(); newMenu.IdObjeto = pIdObject; newMenu.Nombre = pObject; return(PartialView("Menu", newMenu)); } else { return(PartialView("Menu", menu.FirstOrDefault())); } }
public ActionResult Object_Read([DataSourceRequest] DataSourceRequest request, int pIdProduct) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); return(Json(db.Objeto.Where(x => x.Activo && pIdProduct == x.IdProducto).Select(y => new Models.ViewModelObjeto { IdPermission = y.IdObjeto, IdNewPermissionParent = y.IdObjetoPadre, IdProduct = y.IdProducto, IdPermissionParent = y.IdObjetoPadre, Name = y.Nombre, ProductName = y.Producto.Nombre, Description = y.Descripcion, IdOwner = y.Producto.IdPropietario }).ToList(). ToTreeDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public ActionResult Role_Create([DataSourceRequest] DataSourceRequest request, Rol model) { try { if (model != null && ModelState.IsValid) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); model.Activo = true; db.Rol.Add(model); db.SaveChanges(); } } catch (Exception ex) { ModelState.AddModelError("Model", ex.Message); } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }
public ActionResult UserType_Update([DataSourceRequest] DataSourceRequest request, TipoUsuario model) { try { if (model != null && ModelState.IsValid) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); db.TipoUsuario.Attach(model); db.Entry(model).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { ModelState.AddModelError("Model", ex.Message); } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }
public ActionResult Products() { try { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); ViewBag.Owner = db.Propietario.Where(x => x.Activo == true).ToList() .Select(x => new DropDownListItem { Text = x.Nombre, Value = x.IdPropietario.ToString() }).OrderBy(e => e.Text).ToList(); } catch (Exception ex) { ViewBag.Error = ex.Message; } return(View()); }
public ActionResult Owner_Create([DataSourceRequest] DataSourceRequest request, Propietario model) { try { if (model != null && ModelState.IsValid) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); model.Activo = true; db.Propietario.Add(model); db.SaveChanges(); } } catch (Exception ex) { ViewBag.isError = "Error"; ViewBag.Error = ex.Message; } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }
public ActionResult ObjectManager() { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); ViewBag.Products = db.Producto.Where(x => x.Activo == true).ToList() .Select(x => new DropDownListItem { Text = x.Nombre, Value = x.IdProducto.ToString() }).OrderBy(e => e.Text).ToList(); ViewBag.PermissionsParent = db.Objeto.Where(x => x.Activo == true) .Select(x => new DropDownListItem { Text = x.IdObjeto + " | " + x.Nombre, Value = x.IdObjeto.ToString() }).OrderBy(e => e.Text).ToList(); return(View()); }
public ActionResult AddUserToRole(int pIdRole, int pIdUser) { try { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); UsuarioPorRol model = new UsuarioPorRol(); model.IdRol = pIdRole; model.IdUsuario = pIdUser; model.TransacUser = "******"; model.TransacDateTime = DateTime.Now; db.UsuarioPorRol.Add(model); db.SaveChanges(); return(Json(new { success = true, error = "" })); } catch (Exception ex) { return(Json(new { success = false, error = ex.Message })); } }
public ActionResult GlobalParameters() { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); ViewBag.Owner = db.Propietario.Where(x => x.Activo == true).ToList() .Select(x => new DropDownListItem { Text = x.Nombre, Value = x.IdPropietario.ToString() }).OrderBy(e => e.Text).ToList(); ViewBag.ParameterType = db.ParametroTipo .Select(x => new DropDownListItem { Text = x.Nombre, Value = x.IdParametroTipo.ToString() }).OrderBy(e => e.Text).ToList(); return(View()); }
public ActionResult Role_Update([DataSourceRequest] DataSourceRequest request, Rol model) { try { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); var original = db.Rol.Find(model.IdRol); if (model != null && ModelState.IsValid && original != null) { db.Entry(original).CurrentValues.SetValues(model); db.SaveChanges(); } } catch (Exception ex) { ModelState.AddModelError("Model", ex.Message); } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }
public ActionResult Product_Update([DataSourceRequest] DataSourceRequest request, Producto model) { try { if (model != null && ModelState.IsValid) { BarcoSoftDBEntities db = new BarcoSoftDBEntities(true); db.Producto.Attach(model); db.Entry(model).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { ViewBag.isError = "Error"; ViewBag.Error = ex.Message; } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }