public List <clsCatalogo> ConsultarCatalogo() { List <clsCatalogo> lstCatalogo = new List <clsCatalogo>(); DataTable dtRespuesta = null; clsPersistenciaCatalogo objPersistenciaCatalogo = new clsPersistenciaCatalogo(); try { dtRespuesta = objPersistenciaCatalogo.ConsultarCatalogo("AppMovil"); if (dtRespuesta != null) { foreach (DataRow dr in dtRespuesta.Rows) { clsCatalogo objCatalogo = new clsCatalogo(); objCatalogo.idCatalogo = dr[0].ToString(); objCatalogo.nombreCatalogo = dr[1].ToString(); objCatalogo.catalogoPadre = bool.Parse(dr[2].ToString()); objCatalogo.idCatalogoPadre = dr[3].ToString(); DateTime fecha = DateTime.Parse(dr[4].ToString()); objCatalogo.fechaCreacionCatalogo = fecha.ToString("dd-MM-yyyy HH:mm:ss"); objCatalogo.estadoCatalogo = bool.Parse(dr[5].ToString()); lstCatalogo.Add(objCatalogo); } } } catch (Exception) { throw; } return(lstCatalogo); }
public ActionResult AgregarCatalogo() { clsCatalogo objCat = new clsCatalogo(); List <clsCatalogo> lstCatalogos = new List <clsCatalogo>(); List <SelectListItem> items = new List <SelectListItem>(); try { if (Session["login"] != null) { lstCatalogos = (List <clsCatalogo>)Session["catalogosRegistrados"]; lstCatalogos = lstCatalogos.FindAll(x => x.catalogoPadre == true); foreach (clsCatalogo objCatalogo in lstCatalogos) { items.Add(new SelectListItem { Text = objCatalogo.nombreCatalogo, Value = objCatalogo.idCatalogo }); } ViewBag.lstCatalogoPadre = items; return(View(objCat)); } else { return(RedirectToAction("Login", "Home")); } } catch (Exception) { return(RedirectToAction("Error", "Home")); } }
protected void grvCatalogo_RowCommand(object sender, GridViewCommandEventArgs e) { try { string intPrimaryCatalogoID = ""; stp_getListCatalogo_Result mdl = new stp_getListCatalogo_Result(); switch (e.CommandName) { case "Estatus": intPrimaryCatalogoID = e.CommandArgument.ToString(); mdl = lstCat.First(x => x.vchCatalogoID == intPrimaryCatalogoID); mdl.bitActivo = !mdl.bitActivo; CatalogoRequest request = new CatalogoRequest(); clsCatalogo cat = new clsCatalogo(); request.mdlUser = Usuario; cat.intCatalogoID = Convert.ToInt32(ddlListCatalogo.SelectedValue.ToString()); cat.intPrimaryKey = Convert.ToInt32(intPrimaryCatalogoID); cat.bitActivo = (bool)mdl.bitActivo; request.mdlCat = cat; stp_updateCatEstatus_Result result = new stp_updateCatEstatus_Result(); result = RisService.updateCatalogoEstatus(request); if (result != null) { if (result.vchMensaje == "OK") { ShowMessage("Se actualizó correctamente.", MessageType.Correcto, "alert_container"); //fillCat(); cargaCatalgo(); } else { ShowMessage("Existe un error al actualizar: " + result.vchDescripcion, MessageType.Error, "alert_container"); } } else { ShowMessage("Existe un error al actualizar, favor de revisar la información. ", MessageType.Correcto, "alert_container"); } break; case "viewEditar": intPrimaryCatalogoID = e.CommandArgument.ToString(); mdl = lstCat.First(x => x.vchCatalogoID == intPrimaryCatalogoID); txtValorCatalogo.Text = mdl.vchCatalogo; lblCatalogo.Text = ddlListCatalogo.SelectedItem.Text; lblPrimary.Text = "ID = " + mdl.vchCatalogoID; bitEdicion = true; break; } } catch (Exception eRU) { Log.EscribeLog("Existe un error grvCatalogo_RowCommand: " + eRU.Message, 3, Usuario.vchUsuario); } }
private void cargaCatalgo() { try { if (ddlListCatalogo.SelectedItem.Value != "" && ddlListCatalogo.SelectedItem.Value != "0") { List <stp_getListCatalogo_Result> lst = new List <stp_getListCatalogo_Result>(); CatalogoRequest request = new CatalogoRequest(); clsUsuario user = new clsUsuario(); clsCatalogo cat = new clsCatalogo(); user = Usuario; request.mdlUser = user; cat.intCatalogoID = Convert.ToInt32(ddlListCatalogo.SelectedValue); request.mdlCat = cat; lst = RisService.getListCatalogo(request); if (lst != null) { if (lst.Count > 0) { lstCat = lst; grvCatalogo.DataSource = lst.OrderBy(x => x.vchCatalogoID).ToList(); } else { lstCat = null; grvCatalogo.DataSource = null; } } else { lstCat = null; grvCatalogo.DataSource = null; } } else { lstCat = null; grvCatalogo.DataSource = null; } grvCatalogo.DataBind(); limpiarControlAdd(); } catch (Exception ecc) { Log.EscribeLog("Existe un error grvCatalogo_PageIndexChanging: " + ecc.Message, 3, Usuario.vchUsuario); } }
public ActionResult ModificarCatalogo(string idCatalogo) { clsServicioApp objServicioApp = new clsServicioApp(); try { if (Session["login"] != null) { lstCatalogo = (List <clsCatalogo>)Session["catalogosRegistrados"]; clsCatalogo objCatalogo = lstCatalogo.Find(x => x.idCatalogo == idCatalogo); return(View(objCatalogo)); } else { return(RedirectToAction("Login", "Home")); } } catch (Exception) { return(RedirectToAction("Error", "Home")); } }
public CatalogoRequest() { mdlUser = new clsUsuario(); mdlCat = new clsCatalogo(); }
protected void btnAddItemCat_Click(object sender, EventArgs e) { try { CatalogoRequest request = new CatalogoRequest(); clsUsuario user = new clsUsuario(); clsCatalogo cat = new clsCatalogo(); if (ddlListCatalogo.SelectedItem.Value != "" && ddlListCatalogo.SelectedItem.Value != "0") { if (bitEdicion)//Editar { user = Usuario; cat.vchUserAdmin = user.vchUsuario; cat.intCatalogoID = Convert.ToInt32(ddlListCatalogo.SelectedValue.ToString()); cat.intPrimaryKey = Convert.ToInt32(lblPrimary.Text.Replace("ID =", "").Trim()); cat.vchValor = txtValorCatalogo.Text; request.mdlCat = cat; request.mdlUser = user; stp_updateCatalogo_Result response = new stp_updateCatalogo_Result(); response = RisService.updateCatalogo(request); if (response != null) { if (response.vchMensaje == "OK") { limpiarControlAdd(); cargaCatalgo(); ShowMessage("Cambios correctos.", MessageType.Correcto, "alert_container"); } else { ShowMessage("Existe un error al guardar: " + response.vchDescripcion, MessageType.Error, "alert_container"); } } } else//Agregar { user = Usuario; cat.vchUserAdmin = user.vchUsuario; cat.intCatalogoID = Convert.ToInt32(ddlListCatalogo.SelectedValue.ToString()); //cat.intPrimaryKey = Convert.ToInt32(lblPrimary.Text.Replace("ID =", "").Trim()); cat.vchValor = txtValorCatalogo.Text; request.mdlCat = cat; request.mdlUser = user; stp_setItemCatalogo_Result response = new stp_setItemCatalogo_Result(); response = RisService.setItemCatalogo(request); if (response != null) { if (response.vchMensaje == "OK") { limpiarControlAdd(); cargaCatalgo(); ShowMessage("Cambios correctos.", MessageType.Correcto, "alert_container"); } else { ShowMessage("Existe un error al guardar: " + response.vchDescripcion, MessageType.Error, "alert_container"); } } } } else { ShowMessage("Seleccionar el tipo de catálogo.", MessageType.Error, "alert_container"); } } catch (Exception ebAI) { Log.EscribeLog("Existe un error en btnAddItemCat_Click: " + ebAI.Message, 3, Usuario.vchUsuario); ShowMessage("Existe un error al guardar: " + ebAI.Message, MessageType.Error, "alert_container"); } }