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