/// <summary>
/// METODO CONTROLADR DE LISTADO DE ROLES
/// </summary>
public AuthorizeAdminOrMember()
{
using (SqlConnection objConnection = new SqlConnection(Utils.ConnectionString()))
{
objConnection.Open();
try
{
var Cadena = new StringBuilder();
var ListadoRoles = SqlMapper.Query(objConnection, "CAPEX_SEL_ROLE", commandType: CommandType.StoredProcedure).ToList();
foreach (var Rol in ListadoRoles)
{
Cadena.Append(Rol.Name + ",");
}
Roles = Cadena.ToString();
Cadena = null;
}
catch (Exception err)
{
Utils.LogError("AuthorizeAdminOrMember, Mensaje: " + err.Message.ToString() + "-" + ", Detalle: " + err.StackTrace.ToString());
}
finally
{
objConnection.Close();
}
}
}
/// <summary>
/// METODO PARA RECUPERAR SOLICITUDES PENDIENTES
/// </summary>
/// <returns></returns>
private string NumeroSolicitudesPendientesAdm()
{
var Cadena = new StringBuilder();
string CapexAdminToken = ConfigurationManager.AppSettings.Get("CAPEX_ADMIN_TOKEN");
if (Convert.ToString(Session["CAPEX_SESS_USUTOKEN"]) == CapexAdminToken)
{
try
{
using (SqlConnection objConnection = new SqlConnection(Utils.ConnectionString()))
{
objConnection.Open();
try
{
var cantidad = SqlMapper.Query(objConnection, "CAPEX_SEL_SOLICITUDES_ADMIN_CONTADOR", commandType: CommandType.StoredProcedure).ToList();
foreach (var c in cantidad)
{
Cadena.Append(c.Pendientes);
}
return(Cadena.ToString());
}
catch (Exception err)
{
ExceptionResult = "NumeroSolicitudesPendientesAdm, Mensaje: " + err.Message.ToString() + "-" + ", Detalle: " + err.StackTrace.ToString();
Utils.LogError(ExceptionResult);
return("0");
}
finally
{
objConnection.Close();
}
}
}
catch (Exception ex)
{
return("0");
}
finally
{
Cadena = null;
}
}
else
{
return("0");
}
}
/// <summary>
/// NETODO PARA OBTENER NUMERO COMENTARIOS
/// </summary>
/// <param name="usuario"></param>
/// <returns></returns>
private string NumeroComentarios(string usuario)
{
var Cadena = new StringBuilder();
try
{
using (SqlConnection objConnection = new SqlConnection(Utils.ConnectionString()))
{
objConnection.Open();
try
{
var cantidad = SqlMapper.Query(objConnection, "CAPEX_SEL_OBTENER_CANTIDAD_COMENTARIOS", new { @usuario = usuario }, commandType: CommandType.StoredProcedure).ToList();
foreach (var c in cantidad)
{
Cadena.Append(c.Cuantos);
}
return(Cadena.ToString());
}
catch (Exception err)
{
ExceptionResult = "NumeroComentarios, Mensaje: " + err.Message.ToString() + "-" + ", Detalle: " + err.StackTrace.ToString();
Utils.LogError(ExceptionResult);
return("0");
}
finally
{
objConnection.Close();
}
}
}
catch (Exception ex)
{
return("0");
}
finally
{
Cadena = null;
}
}
/// <summary>
/// METODO ACTUALIZAR CLAVE
/// </summary>
/// <param name="Clave1"></param>
/// <param name="Clave2"></param>
/// <returns></returns>
public ActionResult ActualizarClave(string Clave1, string Clave2, string Usuario)
{
try
{
using (SqlConnection objConnection = new SqlConnection(Utils.ConnectionString()))
{
objConnection.Open();
try
{
var parametos = new DynamicParameters();
parametos.Add("Clave1", Clave1);
parametos.Add("Clave2", Clave2);
parametos.Add("Usuario", Usuario);
parametos.Add("Respuesta", dbType: System.Data.DbType.String, direction: System.Data.ParameterDirection.Output, size: 50);
SqlMapper.Query(objConnection, "CAPEX_UPD_ACTUALIZAR_CLAVE", parametos, commandType: CommandType.StoredProcedure).SingleOrDefault();
return(Json(new { Mensaje = "Actualizado" }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
ExceptionResult = "ActualizarClave, Mensaje: " + err.Message.ToString() + "-" + ", Detalle: " + err.StackTrace.ToString();
Utils.LogError(ExceptionResult);
return(Json(new { Mensaje = "Error" }, JsonRequestBehavior.AllowGet));
}
finally
{
objConnection.Close();
}
}
}
catch (Exception err)
{
ExceptionResult = "ActualizarClave, Mensaje: " + err.Message.ToString() + "-" + ", Detalle: " + err.StackTrace.ToString();
CapexInfraestructure.Utilities.Utils.LogError(ExceptionResult);
return(Json(new { Mensaje = "Error" }, JsonRequestBehavior.AllowGet));
}
}
