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