public HttpResponseMessage GCP0001_RFC_LIST_0003(BEGCP01_RFC oBe)
{
try
{
var oBr = new BRGCP01_RFC();
var oBeR = new BEGCP_Beneficio();
var oBrR = new BRGCP_Beneficio();
oBe.acci = 2;
oBeR.acci = 2;
var oList = oBr.GCP0001_RFC_LIST(oBe);
oBeR.rfc_Codigo = oList[0].rfc_Codigo;
var oListR = oBrR.GCP0008_Beneficio_LIST(oBeR);
var oListCodigos = new List <int>();
var oBeReturn = oList[0];
oListR.ForEach(obj => {
oBeReturn.bene_codigos.Add(obj.ben_Codigo);
});
return(Request.CreateResponse(HttpStatusCode.OK, oBeReturn));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
/// <summary>
/// RFC STATUS
/// </summary>
/// <param name="oBe"></param>
public void GCP0005_RFC_STATUS(BEGCP01_RFC oBe)
{
if (ocn.State == ConnectionState.Closed)
{
ocn.Open();
}
using (var obts = ocn.BeginTransaction())
{
try
{
using (var ocmd = odb.GetStoredProcCommand("GCP0005_RFC_STATUS", oBe.rfc_Codigo,
oBe.rfc_Estado,
oBe.rfc_SubEstado,
oBe.acci))
{
ocmd.CommandTimeout = 2000;
odb.ExecuteNonQuery(ocmd, obts);
obts.Commit();
}
}
catch (Exception ex)
{
obts.Rollback();
throw new Exception(ex.Message);
}
finally
{
ocn.Close();
}
}
}
/// <summary>
/// RFC STATUS
/// </summary>
/// <param name="oBe"></param>
public void GCP0005_RFC_STATUS(BEGCP01_RFC oBe)
{
try
{
oda.GCP0005_RFC_STATUS(oBe);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public HttpResponseMessage GCP0006_RFC_0001(BEGCP01_RFC oBe)
{
try
{
var oBr = new BRGCP01_RFC();
oBe.acci = 1;
oBr.GCP0006_RFC(oBe);
return(Request.CreateResponse(HttpStatusCode.OK, "OK"));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
/// <summary>
/// OBTENER LA LISTA DE LAS RFCS O UNA INDIVIDUAL
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public List <BEGCP01_RFC> GCP0001_RFC_LIST(BEGCP01_RFC oBe)
{
try
{
using (var odr = oda.GCP0001_RFC_LIST(oBe))
{
var oList = new List <BEGCP01_RFC>();
var iLst = oList;
((IList)iLst).LoadFromReader <BEGCP01_RFC>(odr);
var cont = 1;
oList.ForEach(obj => {
obj.key = cont;
cont++;
});
return(oList);
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
/// <summary>
/// OPERACIONES DE MANTENIMIENTO
/// </summary>
/// <param name="oBe"></param>
public void GCP0006_RFC(BEGCP01_RFC oBe)
{
if (ocn.State == ConnectionState.Closed)
{
ocn.Open();
}
using (var obts = ocn.BeginTransaction())
{
try
{
using (var ocmd = odb.GetStoredProcCommand("GCP0006_RFC", oBe.rfc_Codigo,
oBe.rfc_FechaSolicitud,
oBe.rfc_NivelImpacto,
oBe.rfc_Asunto,
oBe.rfc_Descripcion,
oBe.pro_Codigo,
oBe.per_Codigo,
oBe.GCP13_EncargadosRFC_per_Codigo,
oBe.est_Codigo,
oBe.acci))
{
ocmd.CommandTimeout = 2000;
odb.ExecuteNonQuery(ocmd, obts);
oBe.rfc_Codigo = Convert.ToInt32(odb.GetParameterValue(ocmd, "@rfc_Codigo"));
obts.Commit();
}
}
catch (Exception ex)
{
obts.Rollback();
throw new Exception(ex.Message);
}
finally
{
ocn.Close();
}
}
}
/// <summary>
/// OBTENER LA LISTA DE LAS RFCS O UNA RFC INDIVIDUAL
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public IDataReader GCP0001_RFC_LIST(BEGCP01_RFC oBe)
{
try
{
if (ocn.State == ConnectionState.Closed)
{
ocn.Open();
}
var ocmd = odb.GetStoredProcCommand("GCP0001_RFC_LIST", oBe.rfc_Codigo, oBe.acci);
ocmd.CommandTimeout = 2000;
var odr = odb.ExecuteReader(ocmd);
return(odr);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
finally
{
ocn.Close();
}
}
public HttpResponseMessage GCP0001_RFC_LIST_0002(BEGCP01_RFC oBe)
{
try
{
var oBr = new BRGCP01_RFC();
var oBeR = new BEGR_Requerimiento();
var oBrR = new BRGR_Requerimiento();
oBe.acci = 2;
oBeR.acci = 1;
var oList = oBr.GCP0001_RFC_LIST(oBe);
oBeR.lir_Codigo = oList[0].pro_Codigo;
var oListR = oBrR.GCP0002_GR_Requerimiento_LIST(oBeR);
var oBeReturn = oList[0];
oBeReturn.LST_REQU = oListR;
return(Request.CreateResponse(HttpStatusCode.OK, oBeReturn));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
