/// <summary>
/// OBTENER LA LISTA DE USUARIOS
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public List <BESHMC_USUA> P0002SHPR_USUA_LIST(BESHMC_USUA oBe)
{
using (var odr = oDa.P0002SHPR_USUA_LIST(oBe))
{
var oList = new List <BESHMC_USUA>();
((IList)oList).LoadFromReader <BESHMC_USUA>(odr);
return(oList);
}
}
/// <summary>
/// ACTUALIZAR REGISTRO DE USUARIOS DESDE MOBILE
/// </summary>
/// <param name="oBe"></param>
public void P0006SHPR_USUA(BESHMC_USUA oBe)
{
try
{
oDa.P0006SHPR_USUA(oBe);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public HttpResponseMessage P0005SHPR_USUA(BESHMC_USUA oBe)
{
var oBr = new BRSHMC_USUA();
try
{
oBr.P0006SHPR_USUA(oBe);
return(Request.CreateResponse(HttpStatusCode.OK, oBe));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, ex.Message));
}
}
/// <summary>
/// ACTUALIZAR REGISTRO DE USUARIOS
/// </summary>
/// <param name="oBe"></param>
public void P0005SHPR_USUA(BESHMC_USUA oBe)
{
try
{
oDb = oDg.getDataBase();
oCon = oDg.getConnection();
if (oCon.State == ConnectionState.Closed)
{
oCon.Open();
}
using (var obts = oCon.BeginTransaction())
{
try
{
using (var ocmd = oDb.GetStoredProcCommand("P0005SHPR_USUA",
oBe.COD_AGEN,
oBe.COD_USUA,
oBe.ALF_PASS,
oBe.COD_TIPO_USUA,
oBe.IND_ACTI,
oBe.NUM_TOKE,
oBe.COD_USUA_CREA,
oBe.COD_USUA_MODI,
oBe.NUM_ACCI))
{
ocmd.CommandTimeout = 2000;
oDb.ExecuteNonQuery(ocmd, obts);
oBe.NUM_TOKE = Convert.ToInt32(oDb.GetParameterValue(ocmd, "@P0005NUM_TOKE"));
obts.Commit();
}
}
catch (Exception ex)
{
obts.Rollback();
throw new ArgumentException(ex.Message);
}
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
finally
{
oCon.Close();
}
}
public HttpResponseMessage P0002SHPR_USUA_LIST(BESHMC_USUA oBe)
{
try
{
if (string.IsNullOrWhiteSpace((string)HttpContext.Current.Session["username"]))
{
return(Request.CreateErrorResponse(HttpStatusCode.Unauthorized, "Acceso no autorizado."));
}
var oBr = new BRSHMC_USUA();
var oList = oBr.P0002SHPR_USUA_LIST(oBe);
return(Request.CreateResponse(HttpStatusCode.OK, oList));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage P0001SHPR_USUA_LIST(BESHMC_USUA oBe)
{
try
{
var oBr = new BRSHMC_USUA();
var oList = oBr.P0001SHPR_USUA_LIST(oBe);
if (oList.Count == 0)
{
throw new ArgumentException("Credenciales de usuario invalidas.");
}
HttpContext.Current.Session["username"] = oBe.COD_USUA;
return(Request.CreateResponse(HttpStatusCode.OK, oBe));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage P0005SHPR_USUA(BESHMC_USUA oBe)
{
try
{
if (string.IsNullOrWhiteSpace((string)HttpContext.Current.Session["username"]))
{
return(Request.CreateErrorResponse(HttpStatusCode.Unauthorized, "Acceso no autorizado."));
}
if (oBe.COD_AGEN == 0)
{
throw new ArgumentException("Seleccione un colaborador.");
}
if (string.IsNullOrEmpty(oBe.COD_USUA))
{
throw new ArgumentException("Especifique un nombre de usuario.");
}
if (string.IsNullOrEmpty(oBe.ALF_PASS))
{
throw new ArgumentException("La contraseña no puede ser un datos en blanco.");
}
if (!oBe.ALF_PASS.Equals(oBe.ALF_PASS_REPE))
{
throw new ArgumentException("Las contraseñas no coinciden.");
}
if (oBe.COD_TIPO_USUA == 0)
{
throw new ArgumentException("Seleccione un tipo de usuario.");
}
var oBr = new BRSHMC_USUA();
oBe.COD_USUA_CREA = (string)HttpContext.Current.Session["username"];
oBe.COD_USUA_MODI = (string)HttpContext.Current.Session["username"];
oBr.P0005SHPR_USUA(oBe);
return(Request.CreateResponse(HttpStatusCode.OK, oBe));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
/// <summary>
/// OBTENER LA LISTA DE USUARIOS
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public IDataReader P0002SHPR_USUA_LIST(BESHMC_USUA oBe)
{
try
{
oDb = oDg.getDataBase();
oCon = oDg.getConnection();
if (oCon.State == ConnectionState.Closed)
{
oCon.Open();
}
var ocmd = oDb.GetStoredProcCommand("P0002SHPR_USUA_LIST", oBe.COD_USUA,
oBe.NUM_ACCI);
ocmd.CommandTimeout = 2000;
var odr = oDb.ExecuteReader(ocmd);
return(odr);
}
finally
{
oCon.Close();
}
}
public HttpResponseMessage P0005SHPR_USUA(BESHMC_USUA oBe)
{
var oBr = new BRSHMC_USUA();
var oBeR = new BESHMC_USUA_RESP();
try
{
oBr.P0006SHPR_USUA(oBe);
oBeR.IND_ESTA = true;
oBeR.ALF_MESA = "";
oBeR.ALF_AGEN = oBe.ALF_AGEN;
return(Request.CreateResponse(HttpStatusCode.OK, oBeR));
}
catch (Exception ex)
{
oBeR.IND_ESTA = false;
oBeR.ALF_MESA = ex.Message;
oBeR.ALF_AGEN = "";
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, oBeR));
}
}
/// <summary>
/// ACTUALIZAR REGISTRO DE USUARIOS DESDE MOBILE
/// </summary>
/// <param name="oBe"></param>
public void P0006SHPR_USUA(BESHMC_USUA oBe)
{
try
{
oDb = oDg.getDataBase();
oCon = oDg.getConnection();
if (oCon.State == ConnectionState.Closed)
{
oCon.Open();
}
using (var obts = oCon.BeginTransaction())
{
try
{
using (var ocmd = oDb.GetStoredProcCommand("P0006SHPR_USUA",
oBe.COD_USUA,
oBe.NUM_TOKE))
{
ocmd.CommandTimeout = 2000;
oDb.ExecuteNonQuery(ocmd, obts);
obts.Commit();
}
}
catch (Exception ex)
{
obts.Rollback();
throw new ArgumentException(ex.Message);
}
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
finally
{
oCon.Close();
}
}
