//public List<ProblemTypeEntity> SHPR_TICKET_PRO_LIST(ProblemTypeEntity oBe) //{ // using (var odr = oDa.SHPR_TICKET_PRO(oBe)) // { // var oList = new List<ProblemTypeEntity>(); // ((IList)oList).LoadFromReader<ProblemTypeEntity>(odr); // return (oList); // } //} public List <TipoSolucionEntity> SHPR_TICKET_PRO_SOL_LIST(TipoSolucionEntity oBe) { using (var odr = oDa.SHPR_TICKET_PRO_SOL(oBe)) { var oList = new List <TipoSolucionEntity>(); ((IList)oList).LoadFromReader <TipoSolucionEntity>(odr); return(oList); } }
public HttpResponseMessage P0005SHPR_PRO_SOL_LIST(TipoSolucionEntity oBe) { try { if (string.IsNullOrWhiteSpace((string)HttpContext.Current.Session["username"])) { return(Request.CreateErrorResponse(HttpStatusCode.Unauthorized, "Acceso no autorizado.")); } var oBr = new TicketRule(); var oList = oBr.SHPR_TICKET_PRO_SOL_LIST(oBe); return(Request.CreateResponse(HttpStatusCode.OK, oList)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public IDataReader SHPR_TICKET_PRO_SOL(TipoSolucionEntity oBe) { try { oDb = oDg.getDataBase(); oCon = oDg.getConnection(); if (oCon.State == ConnectionState.Closed) { oCon.Open(); } var ocmd = oDb.GetStoredProcCommand("up_ListarSolucion", oBe.SOL_PROD_Id); ocmd.CommandTimeout = 2000; var odr = oDb.ExecuteReader(ocmd); return(odr); } catch (Exception ex) { throw ex; } finally { oCon.Close(); } }