/// <summary> /// OBTENER LA LISTA DE MOROSOS /// </summary> /// <param name="oBe"></param> /// <returns></returns> public List <BESHMC_AGEN> P0007SHPR_MORO_LIST(BESHMC_MORO oBe) { using (var odr = oDa.P0007SHPR_MORO_LIST(oBe)) { var oList = new List <BESHMC_AGEN>(); ((IList)oList).LoadFromReader <BESHMC_AGEN>(odr); return(oList); } }
public HttpResponseMessage P0005SHPR_USUA(BESHMC_MORO oBe) { var oBr = new BRSHMC_MORO(); try { var oList = oBr.P0007SHPR_MORO_LIST(oBe); return(Request.CreateResponse(HttpStatusCode.OK, oList)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
/// <summary> /// OBTENER LA LISTA DE MOROSOS /// </summary> /// <param name="oBe"></param> /// <returns></returns> public IDataReader P0007SHPR_MORO_LIST(BESHMC_MORO oBe) { try { oDb = oDg.getDataBase(); oCon = oDg.getConnection(); if (oCon.State == ConnectionState.Closed) { oCon.Open(); } var ocmd = oDb.GetStoredProcCommand("P0007SHPR_MORO_LIST", oBe.COD_AGEN, oBe.NUM_ACCI); ocmd.CommandTimeout = 2000; var odr = oDb.ExecuteReader(ocmd); return(odr); } finally { oCon.Close(); } }