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