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)); } }