public ActionResult Edit(PermisoEntity objPermiso)
{
if (ModelState.IsValid)
{
objPermiso.BaseRemoteIp = RemoteIp;
objPermiso.BaseIdUser = LoggedUserName;
int result = proxy.UpdatePermiso(objPermiso);
if (result == -1)
{
PermisoEntity objQuejaOld = proxy.GetPermiso(objPermiso.IdRol);
//PermisoEntity objA = proxy.GetPermiso(objPermiso.IdModule);
AssingMessageScript("El Permiso ya existe en el sistema, .", "error", "Error", true);
CheckNotify();
return(View(objPermiso));
}
if (result > 0)
{
AssingMessageScript("El Permiso se modifico en el sistema.", "success", "Éxito", true);
CheckNotify();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
return(View(objPermiso));
}
private void CargarListbox()
{
listBox1.Items.Clear();
listBox2.Items.Clear();
DataTable dt = PermisoBAL.GetAllPermisos();
GrupoBAL grupo = new GrupoBAL();
grupo.id = Int32.Parse(cboxGrupos.SelectedValue.ToString());
grupo.GetOneGrupo();
//int items2 = dt3.Rows.Count;
ListaPermisos = PermisoBAL.GetAllPermisos();
foreach (DataRow row in ListaPermisos.Rows)
{
PermisoEntity _permiso = new PermisoEntity();
_permiso.id = Int32.Parse(row["id"].ToString());
_permiso.name = row["name"].ToString();
bool exis = grupo.permissions.Any(x => x == _permiso.id);
if (exis == true)
{
listBox2.Items.Add(_permiso);
}
else
{
listBox1.Items.Add(_permiso);
}
}
}
public ActionResult Edit(PermisoEntity objPermiso)
{
if (ModelState.IsValid)
{
objPermiso.BaseRemoteIp = RemoteIp;
objPermiso.BaseIdUser = LoggedUserName;
int result = proxy.UpdatePermiso(objPermiso);
if (result == -1)
{
PermisoEntity objPermisoOld = proxy.GetPermiso(objPermiso.IdPermiso);
//ViewBag.VBRole = new SelectList(proxyRole.GetRoleList().Where(x => x.IdRol == objPermisoOld.IdRol).OrderBy(x => x.Nombre.Trim()).ToList(), "IdRol", "Nombre", objPermiso.IdRol);
//ViewBag.VBModule = new SelectList(proxyModule.GetModuleList().Where(x => x.IdModule == objPermisoOld.IdModule).OrderBy(x => x.Description.Trim()).ToList(), "IdModule", "Description", objPermiso.IdModule);
AssingMessageScript("El Permiso ya existe en el sistema, .", "error", "Error", true);
CheckNotify();
return(View(objPermiso));
}
if (result > 0)
{
AssingMessageScript("El Permiso se modifico en el sistema.", "success", "Éxito", true);
CheckNotify();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
return(View(objPermiso));
}
public ActionResult Details(int id = 0)
{
PermisoEntity objPermiso = proxy.GetPermiso(id);
if (objPermiso == null)
{
return(HttpNotFound());
}
return(PartialView(objPermiso));
}
public ActionResult Edit(int id = 0)
{
PermisosAccesoDeniedEdit("Permiso");
ViewBag.CustomScriptsPageValid = BuildScriptPageValid();
PermisoEntity objPermiso = proxy.GetPermiso(id);
if (objPermiso == null)
{
return(HttpNotFound());
}
return(View(objPermiso));
}
public ActionResult Edit(int id = 0)
{
PermisosAccesoDeniedEdit("Permiso");
ViewBag.CustomScriptsPageValid = BuildScriptPageValid();
PermisoEntity objPermiso = proxy.GetPermiso(id);
//ViewBag.VBRole = new SelectList(proxyRole.GetRoleList().OrderBy(x => x.Nombre.Trim()).ToList(), "IdRol", "Nombre");
//ViewBag.VBModule = new SelectList(proxyModule.GetModuleList().OrderBy(x => x.Description.Trim()).ToList(), "IdModule", "Description");
if (objPermiso == null)
{
return(HttpNotFound());
}
return(View(objPermiso));
}
public static PermisoEntity GetOneDeep(int?IdRol, int?IdModule)
{
PermisoEntity result = ProviderSoftv.Permiso.GetPermisoById(IdRol);
if (result.IdRol != null)
{
result.Role = ProviderSoftv.Role.GetRoleById(result.IdRol);
}
if (result.IdModule != null)
{
result.Module = ProviderSoftv.Module.GetModuleById(result.IdModule);
}
return(result);
}
/// <summary>
/// Edits a Permiso
///</summary>
/// <param name="Permiso"> Objeto Permiso a editar </param>
public override int EditPermiso(PermisoEntity entity_Permiso)
{
int result = 0;
using (SqlConnection connection = new SqlConnection(SoftvSettings.Settings.Permiso.ConnectionString))
{
SqlCommand comandoSql = CreateCommand("Softv_PermisoEdit", connection);
//AssingParameter(comandoSql, "@IdPermiso", entity_Permiso.IdPermiso);
AssingParameter(comandoSql, "@IdRol", entity_Permiso.IdRol);
AssingParameter(comandoSql, "@IdModule", entity_Permiso.IdModule);
AssingParameter(comandoSql, "@OptAdd", entity_Permiso.OptAdd);
AssingParameter(comandoSql, "@OptSelect", entity_Permiso.OptSelect);
AssingParameter(comandoSql, "@OptUpdate", entity_Permiso.OptUpdate);
AssingParameter(comandoSql, "@OptDelete", entity_Permiso.OptDelete);
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
result = int.Parse(ExecuteNonQuery(comandoSql).ToString());
}
catch (Exception ex)
{
throw new Exception("Error updating Permiso " + ex.Message, ex);
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
return(result);
}
public bool AddPermiso(PermisoEntity grupo)
{
var client = new RestClient(RutaBase.direccion);
client.CookieContainer = new System.Net.CookieContainer();
var request = new RestRequest("permisos/", Method.POST);
//request.RequestFormat = DataFormat.Json;
request.AddHeader("Authorization", "token " + Credencial.Token);
var json = request.JsonSerializer.Serialize(grupo);
request.AddParameter("application/json; charset=utf-8", json, ParameterType.RequestBody);
var response = client.Execute(request);
if (response.StatusCode == HttpStatusCode.Created)
{
return(true);
}
if (response.StatusCode == HttpStatusCode.BadRequest)
{
msError.ErrorMessage = response.Content.ToString();
return(false);
}
if (response.StatusCode == 0)
{
msError.ErrorMessage = "No es posible conectar con el servidor remoto";
return(false);
}
if (response.StatusCode == HttpStatusCode.Unauthorized)
{
msError.ErrorMessage = "No esta autorizado";
return(false);
}
if (response.StatusCode == HttpStatusCode.Forbidden)
{
msError.ErrorMessage = "Usted no tiene permisos.";
return(false);
}
msError.ErrorMessage = "----Error R21441 ----";
return(false);
}
/// <summary>
///</summary>
/// <param name="Permiso"> Object Permiso added to List</param>
public override int AddPermiso(PermisoEntity entity_Permiso)
{
int result = 0;
using (SqlConnection connection = new SqlConnection(SoftvSettings.Settings.Permiso.ConnectionString))
{
SqlCommand comandoSql = CreateCommand("Softv_PermisoAdd", connection);
AssingParameter(comandoSql, "@IdPermiso", null, pd: ParameterDirection.Output, IsKey: true);
AssingParameter(comandoSql, "@IdRol", entity_Permiso.IdRol);
AssingParameter(comandoSql, "@IdModule", entity_Permiso.IdModule);
AssingParameter(comandoSql, "@OptAdd", entity_Permiso.OptAdd);
AssingParameter(comandoSql, "@OptSelect", entity_Permiso.OptSelect);
AssingParameter(comandoSql, "@OptUpdate", entity_Permiso.OptUpdate);
AssingParameter(comandoSql, "@OptDelete", entity_Permiso.OptDelete);
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
result = ExecuteNonQuery(comandoSql);
}
catch (Exception ex)
{
throw new Exception("Error adding Permiso " + ex.Message, ex);
}
finally
{
connection.Close();
}
result = (int)comandoSql.Parameters["@IdPermiso"].Value;
}
return(result);
}
/// <summary>
/// Converts data from reader to entity
/// </summary>
protected virtual PermisoEntity GetPermisoFromReader(IDataReader reader)
{
PermisoEntity entity_Permiso = null;
try
{
entity_Permiso = new PermisoEntity();
entity_Permiso.IdRol = (int?)(GetFromReader(reader, "IdRol"));
entity_Permiso.IdModule = (int?)(GetFromReader(reader, "IdModule"));
entity_Permiso.OptAdd = (bool)(GetFromReader(reader, "OptAdd"));
entity_Permiso.OptSelect = (bool)(GetFromReader(reader, "OptSelect"));
entity_Permiso.OptUpdate = (bool)(GetFromReader(reader, "OptUpdate"));
entity_Permiso.OptDelete = (bool)(GetFromReader(reader, "OptDelete"));
}
catch (Exception ex)
{
throw new Exception("Error converting Permiso data to entity", ex);
}
return(entity_Permiso);
}
/// <summary>
/// Gets Permiso by
///</summary>
public override PermisoEntity GetPermisoById(int?IdPermiso)
{
using (SqlConnection connection = new SqlConnection(SoftvSettings.Settings.Permiso.ConnectionString))
{
SqlCommand comandoSql = CreateCommand("Softv_PermisoGetById", connection);
PermisoEntity entity_Permiso = null;
AssingParameter(comandoSql, "@IdPermiso", IdPermiso);
IDataReader rd = null;
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
rd = ExecuteReader(comandoSql, CommandBehavior.SingleRow);
if (rd.Read())
{
entity_Permiso = GetPermisoFromReader(rd);
}
}
catch (Exception ex)
{
throw new Exception("Error getting data Permiso " + ex.Message, ex);
}
finally
{
if (connection != null)
{
connection.Close();
}
if (rd != null)
{
rd.Close();
}
}
return(entity_Permiso);
}
}
public ActionResult Create(PermisoEntity objPermiso)
{
if (ModelState.IsValid)
{
objPermiso.BaseRemoteIp = RemoteIp;
objPermiso.BaseIdUser = LoggedUserName;
int result = proxy.AddPermiso(objPermiso);
if (result == -1)
{
AssingMessageScript("El Permiso ya existe en el sistema.", "error", "Error", true);
CheckNotify();
return(View(objPermiso));
}
if (result > 0)
{
AssingMessageScript("Se dio de alta el Permiso en el sistema.", "success", "Éxito", true);
return(RedirectToAction("Index"));
}
}
return(View(objPermiso));
}
/// <summary> /// Abstract method to update Permiso /// </summary> public abstract int EditPermiso(PermisoEntity entity_Permiso);
public static int Edit(PermisoEntity objPermiso)
{
int result = ProviderSoftv.Permiso.EditPermiso(objPermiso);
return(result);
}
public static int Add(PermisoEntity objPermiso)
{
int result = ProviderSoftv.Permiso.AddPermiso(objPermiso);
return(result);
}
public int UpdatePermiso(PermisoEntity objPermiso)
{
return(Permiso.Edit(objPermiso));
}
public object AfterReceiveRequest(ref Message request, IClientChannel channel, InstanceContext instanceContext)
{
//
List <String> lstUriAction = request.Headers.To.ToString().Split('/').ToList();
String Action = lstUriAction.Last().ToUpper();
String Module = lstUriAction[lstUriAction.Count() - 2].ToUpper();
if (WebOperationContext.Current.IncomingRequest.Method == "OPTIONS")
{
WebOperationContext.Current.OutgoingResponse.StatusCode = HttpStatusCode.OK;
return(null);
}
else
{
// Check to see if there is an Authorization in the header, otherwise throw a 401
if (WebOperationContext.Current.IncomingRequest.Headers["Authorization"] == null)
{
WebOperationContext.Current.OutgoingResponse.Headers.Add("WWW-Authenticate: Basic realm=\"myrealm\"");
throw new WebFaultException <string>("Acceso no autorizado, favor de validar autenticación", HttpStatusCode.Unauthorized);
}
else // Decode the header, check password
{
string encodedUnamePwd = "";
if (Module == "USUARIO" && Action == "LOGON")
{
encodedUnamePwd = GetEncodedCredentialsFromHeader();
if (!string.IsNullOrEmpty(encodedUnamePwd))
{
// Decode the credentials
byte[] decodedBytes = null;
try
{
decodedBytes = Convert.FromBase64String(encodedUnamePwd);
}
catch (FormatException)
{
return(false);
}
string credentials = ASCIIEncoding.ASCII.GetString(decodedBytes);
// Validate User and Password
string[] authParts = credentials.Split(':');
Usuario objUsuario = new Usuario();
UsuarioEntity objUsr = Usuario.GetusuarioByUserAndPass(authParts[0], authParts[1]);
if (objUsr == null)
{
WebOperationContext.Current.OutgoingResponse.Headers.Add("WWW-Authenticate: Basic realm=\"myrealm\"");
throw new WebFaultException <string>("Acceso no autorizado, favor de validar autenticación", HttpStatusCode.Unauthorized);
}
}
}
else
{
encodedUnamePwd = GetTokenFromHeader();
if (!string.IsNullOrEmpty(encodedUnamePwd))
{
List <SessionEntity> objSessionEntity = Session.GetAll();
if (!objSessionEntity.Any(x => x.Token == encodedUnamePwd))
{
WebOperationContext.Current.OutgoingResponse.Headers.Add("WWW-Authenticate: Basic realm=\"myrealm\"");
throw new WebFaultException <string>("Acceso no autorizado, favor de validar autenticación", HttpStatusCode.Unauthorized);
}
else
{
SessionEntity objSession = objSessionEntity.Where(x => x.Token == encodedUnamePwd).FirstOrDefault();
UsuarioEntity objUsr = Usuario.GetOne(objSession.IdUsuario);
if (!(lstInvaliAction.Where(x => (Action.StartsWith(x) || lstInvaliAction.Contains(Action))).Any()))
{
List <SecutityEntity> lstSecutityEntity = Secutity.GetPagedList(1, 99999, Globals.SerializeTool.Serialize <SecutityEntity>(new SecutityEntity()
{
Module = Module
})).ToList();
if (lstSecutityEntity.Any(x => x.Action == Action))
{
SecutityEntity objSecutity = lstSecutityEntity.Where(x => x.Action == Action).FirstOrDefault();
if (objSecutity != null)
{
List <PermisoEntity> lstPermisos = Permiso.GetXml(Globals.SerializeTool.Serialize <PermisoEntity>(new PermisoEntity()
{
IdRol = objUsr.IdRol
})).ToList();
PermisoEntity objPermisos = lstPermisos.Where(x => x.Module.ModulePath.ToUpper() == Module.ToUpper()).ToList().FirstOrDefault();
if (objPermisos != null)
{
switch (objSecutity.Permision)
{
case "S":
{
return(null);
}
case "A":
{
if (objPermisos.OptAdd == true)
{
return(null);
}
else
{
WebOperationContext.Current.OutgoingResponse.Headers.Add("WWW-Authenticate: Basic realm=\"myrealm\"");
throw new WebFaultException <string>("Acceso no autorizado, favor de validar autenticación", HttpStatusCode.Unauthorized);
}
}
case "D":
{
if (objPermisos.OptDelete == true)
{
return(null);
}
else
{
WebOperationContext.Current.OutgoingResponse.Headers.Add("WWW-Authenticate: Basic realm=\"myrealm\"");
throw new WebFaultException <string>("Acceso no autorizado, favor de validar autenticación", HttpStatusCode.Unauthorized);
}
}
case "U":
{
if (objPermisos.OptUpdate == true)
{
return(null);
}
else
{
WebOperationContext.Current.OutgoingResponse.Headers.Add("WWW-Authenticate: Basic realm=\"myrealm\"");
throw new WebFaultException <string>("Acceso no autorizado, favor de validar autenticación", HttpStatusCode.Unauthorized);
}
}
default:
{
WebOperationContext.Current.OutgoingResponse.Headers.Add("WWW-Authenticate: Basic realm=\"myrealm\"");
throw new WebFaultException <string>("Acceso no autorizado, favor de validar autenticación", HttpStatusCode.Unauthorized);
}
}
}
else
{
WebOperationContext.Current.OutgoingResponse.Headers.Add("WWW-Authenticate: Basic realm=\"myrealm\"");
throw new WebFaultException <string>("Acceso no autorizado, favor de validar autenticación", HttpStatusCode.Unauthorized);
}
}
}
else
{
WebOperationContext.Current.OutgoingResponse.Headers.Add("WWW-Authenticate: Basic realm=\"myrealm\"");
throw new WebFaultException <string>("Acceso no autorizado, favor de validar autenticación", HttpStatusCode.Unauthorized);
}
}
}
}
}
}
}
return(null);
}
public ActionResult QuickIndex(int?page, int?pageSize, bool?OptAdd, bool?OptSelect, bool?OptUpdate, bool?OptDelete, int?IdRol, int?IdModule)
{
int pageNumber = (page ?? 1);
int pSize = pageSize ?? SoftvMVC.Properties.Settings.Default.pagnum;
SoftvList <PermisoEntity> listResult = null;
List <PermisoEntity> listPermiso = new List <PermisoEntity>();
PermisoEntity objPermiso = new PermisoEntity();
PermisoEntity objGetPermiso = new PermisoEntity();
if ((OptAdd != null))
{
objPermiso.OptAdd = OptAdd;
}
if ((OptSelect != null))
{
objPermiso.OptSelect = OptSelect;
}
if ((OptUpdate != null))
{
objPermiso.OptUpdate = OptUpdate;
}
if ((OptDelete != null))
{
objPermiso.OptDelete = OptDelete;
}
if ((IdRol != null))
{
objPermiso.IdRol = IdRol;
}
if ((IdModule != null))
{
objPermiso.IdModule = IdModule;
}
pageNumber = pageNumber == 0 ? 1 : pageNumber;
listResult = proxy.GetPermisoPagedListXml(pageNumber, pSize, Globals.SerializeTool.Serialize(objPermiso));
if (listResult.Count == 0)
{
int tempPageNumber = (int)(listResult.totalCount / pSize);
pageNumber = (int)(listResult.totalCount / pSize) == 0 ? 1 : tempPageNumber;
listResult = proxy.GetPermisoPagedListXml(pageNumber, pSize, Globals.SerializeTool.Serialize(objPermiso));
}
listResult.ToList().ForEach(x => listPermiso.Add(x));
var PermisoAsIPagedList = new StaticPagedList <PermisoEntity>(listPermiso, pageNumber, pSize, listResult.totalCount);
if (PermisoAsIPagedList.Count > 0)
{
return(PartialView(PermisoAsIPagedList));
}
else
{
var result = new { tipomsj = "warning", titulomsj = "Aviso", Success = "False", Message = "No se encontraron registros con los criterios de búsqueda ingresados." };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public int AddPermiso(PermisoEntity objPermiso)
{
return(Permiso.Add(objPermiso));
}
/// <summary> /// Abstract method to add Permiso /// /summary> /// <param name="Permiso"></param> /// <returns></returns> public abstract int AddPermiso(PermisoEntity entity_Permiso);