public BE_COMBO listarRolCombo() { BE_COMBO objComboBE = new BE_COMBO(); try { List <KeyValuePair <string, string> > lstDataBE = new List <KeyValuePair <string, string> >(); sdr = SqlHelper.ExecuteReader(constr_dya, "SEGURIDAD.SP_ROL_LISTAR_COMBO"); lstDataBE.Add(new KeyValuePair <string, string>("-Seleccione-", "0")); while (sdr.Read()) { lstDataBE.Add(new KeyValuePair <string, string>( Convert.ToString(sdr["DES_ROL_VC"]), Convert.ToString(sdr["ID_ROL_IN"]) ) ); } objComboBE.lstDataBE = lstDataBE; objComboBE.dataSelect = "0"; } catch (Exception ex) { throw ex; } finally { if (sdr != null) { sdr.Close(); } } return(objComboBE); }
public ActionResult Usuario() { BL_ROL objRolBL = new BL_ROL(); BL_TIPO_CUENTA objTipoCuentaBL = new BL_TIPO_CUENTA(); BE_COMBO lstRolBE = objRolBL.listarRolCombo(); BE_COMBO lstTipoCuentaBE = objTipoCuentaBL.listarRolCombo(); ViewData["lstRolBE"] = lstRolBE; ViewData["lstTipoCuentaBE"] = lstTipoCuentaBE; return(View()); }
public JsonResult listarRolCombo() { BE_COMBO lstRolBE = new BE_COMBO(); SessionValidate objSessionValidate = new SessionValidate(); if (objSessionValidate.isSuccess()) { BL_ROL objRolBL = new BL_ROL(); lstRolBE = objRolBL.listarRolCombo(); } return(Json(lstRolBE, JsonRequestBehavior.AllowGet)); }