/// <summary> /// Elimina un detalle del parámetro /// </summary> /// <param name="model"></param> /// <returns></returns> public ResponserData EliminarDetalle(BEParametroItem model) { try { return(DA.EliminarDetalle(model)); } catch (Exception ex) { throw ex; } }
public ActionResult SVkwTXVC(string sid) { CustomJSON globalResponse = new CustomJSON(); ResponserData oResponse = new ResponserData(); int id = 0; if (User != null) { try { if (sid != string.Empty) { id = Convert.ToInt16(Peach.DecriptText(sid)); } BEParametroItem detalle = new BEParametroItem { Id = Convert.ToInt16(id), RowAudit = new IRowAudit { IUsr = Convert.ToInt16(Peach.DecriptText(User.CID)), IP = Common.PageUtility.GetUserIpAddress() } }; oResponse = new BLParametro().EliminarDetalle(detalle); globalResponse.DATA = oResponse; } catch (Exception ex) { globalResponse.ERR = ex.Message; } } else { return(RedirectToAction("Index", "Account", new { act = "timeout" })); } return(Json(globalResponse, JsonRequestBehavior.AllowGet)); }
public BEParametroItem ListarDetalle_byId(BEParametro model) { BEParametroItem Detalle = new BEParametroItem(); try { using (SqlConnection oConexion = new SqlConnection(DBConexion)) { SqlCommand oComando = new SqlCommand(sp_listarDetalle, oConexion); oComando.CommandType = CommandType.StoredProcedure; oComando.Parameters.Add("@p_idp", SqlDbType.Int).Value = 0; oComando.Parameters.Add("@p_idd", SqlDbType.Int).Value = model.Detalle.Id; oConexion.Open(); using (SqlDataReader dr = oComando.ExecuteReader()) { while (dr.Read() && dr.HasRows) { Detalle.CID = Peach.EncriptText(DataUtil.ObjectToString(dr["i_idd"])); Detalle.Texto = DataUtil.ObjectToString(dr["s_tex"]); Detalle.Valor = DataUtil.ObjectToString(dr["s_val"]); Detalle.Ayuda = DataUtil.ObjectToString(dr["s_ayu"]); Detalle.Orden = DataUtil.ObjectToInt16(dr["i_ord"]); Detalle.IsGrupo = new ItemGenerico { IntValue = DataUtil.ObjectToInt(dr["i_gru"]) }; } } oComando.Dispose(); } } catch (Exception ex) { throw ex; } return(Detalle); }
// Elimina un parámetro public ResponserData EliminarDetalle(BEParametroItem model) { ResponserData Responser = new ResponserData(); try { using (SqlConnection oConexion = new SqlConnection(DBConexion)) { SqlCommand oComando = new SqlCommand(sp_eliminarDetalle, oConexion); oComando.CommandType = CommandType.StoredProcedure; oComando.Parameters.Add("@p_idd", SqlDbType.Int).Value = model.Id; oComando.Parameters.Add("@p_usr", SqlDbType.SmallInt).Value = model.RowAudit.IUsr; oComando.Parameters.Add("@p_ipc", SqlDbType.VarChar, 15).Value = model.RowAudit.IP; oConexion.Open(); using (SqlDataReader dr = oComando.ExecuteReader()) { while (dr.Read()) { Responser.XID = DataUtil.ObjectToInt(dr["i_id"]); Responser.Mensaje = DataUtil.ObjectToString(dr["s_msg"]); Responser.Estado = (ResponserEstado)DataUtil.ObjectToInt(dr["i_est"]); Responser.TipoAlerta = (BootstrapAlertType)DataUtil.ObjectToInt(dr["i_btp"]); } } oComando.Dispose(); } } catch (Exception ex) { throw ex; } return(Responser); }