public JsonResult ListarInsumo(int id) { ListaInsumoOutDTO resp = new ListaInsumoOutDTO(); resp = _insumo.ListarInsumo(id); return(Json(resp, JsonRequestBehavior.AllowGet)); }
public ListaInsumoOutDTO ListarInsumo(int categoriaInsumoId) { ListaInsumoOutDTO response = new ListaInsumoOutDTO(); InsumoOutDTO insumo = new InsumoOutDTO(); response.listaInsumos = new List <InsumoOutDTO>(); _IResultlSetHelper.setDataSource(conectionString); var responseDTO = new ResponseDTO(); string packageName = "pkg_iteracion_2"; string procedureName = "LISTAR_INSUMO"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); inParam.Add(categoriaInsumoId.ToString()); outParam.Add("o_cursor"); outParam.Add("o_error"); var oReader = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam, "o_cursor"); if (oReader.Rows.Count > 0) { foreach (DataRow row in oReader.Rows) { insumo.insumoId = int.Parse(row[0].ToString()); insumo.nombre = row[1].ToString(); insumo.marca = row[2].ToString(); insumo.categoriaInsumo = row[3].ToString(); insumo.precio = int.Parse(row[4].ToString()); insumo.unidadMedida = row[5].ToString(); response.listaInsumos.Add(insumo); } response.code = 0; response.message = "OK"; } else { response.code = 999; response.message = String.Concat("NoOk - ", result[2].ToString()); } return(response); }