protected void ibnActualizar_Click(object sender, ImageClickEventArgs e)
{
int _Estado;
TRG_Trigger_RiesgosBE _TRG_Trigger_RiesgosBE = new TRG_Trigger_RiesgosBE();
ImageButton ibn = (ImageButton)sender;
RepeaterItem fila = (RepeaterItem)ibn.Parent;
int _Registro_id = int.Parse(((Label)fila.Controls[1]).Text);
string _Var = ((Label)fila.Controls[3]).Text;
if (_Var == "Si")
{
_TRG_Trigger_RiesgosBE.Estado = false;
}
else
{
_TRG_Trigger_RiesgosBE.Estado = true;
}
_TRG_Trigger_RiesgosBE.Trigger_id = Convert.ToInt32(Request.QueryString["Trigger_id"]);
_TRG_Trigger_RiesgosBE.Registro_id = _Registro_id;
_TRG_Trigger_RiesgosBE.Usuario_update = ((Fnc_FuncionariosBE)Session["FNC_Funcionarios"]).Funcionario_Id;
if (_Var == "Si")
{
if (_TB_PlanAccionBL.ContarTB_PlanAccionByRegistro(_Registro_id, 4) > 0)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "jAlert", "jAlert('No puede cerrar Riesgo si existe Planes pendientes');", true);
}
else
{
ltlAlert.Text = "";
if (!_TRG_Trigger_RiesgosBL.ActualizarTRG_Trigger_Riesgos(_TRG_Trigger_RiesgosBE))
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "jAlert", "jAlert('No se pudo actualizar riesgo!');", true);
}
}
}
if (_Var == "No")
{
if (_TRG_Trigger_RiesgosBL.ActualizarTRG_Trigger_Riesgos(_TRG_Trigger_RiesgosBE))
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "jAlert", "window.open('../admin/RegistrarPlanAccion.aspx?tipoPlan=1&Registro_id=" + _Registro_id + "&Titulo=Trigger&Sistema_id=4','Dates','scrollbars=no,resizable=yes','height=300px', 'width=200px')", true);
}
else
{
String mensaje = "<script language='JavaScript'>window.alert('error, no se pudo actualizar el registro')";
mensaje += Environment.NewLine;
this.Page.Response.Write(mensaje);
}
}
GenerarTabla(int.Parse(Request.QueryString["Trigger_id"]));
}
public bool ActualizarTRG_Trigger_RiesgosFin(TRG_Trigger_RiesgosBE _TRG_Trigger_RiesgosBE)
{
cnx.ConnectionString = MiConexion.GetCnx();
cmd.Connection = cnx;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_ActualizarTRG_Trigger_RiesgosFin";
SqlParameter par1;
bool _vcod;
try
{
par1 = cmd.Parameters.Add(new SqlParameter("@Registro_id", SqlDbType.Int));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Registro_id"].Value = _TRG_Trigger_RiesgosBE.Registro_id;
par1 = cmd.Parameters.Add(new SqlParameter("@Trigger_id", SqlDbType.Int));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Trigger_id"].Value = _TRG_Trigger_RiesgosBE.Trigger_id;
par1 = cmd.Parameters.Add(new SqlParameter("@Estado", SqlDbType.Bit));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Estado"].Value = _TRG_Trigger_RiesgosBE.Estado;
par1 = cmd.Parameters.Add(new SqlParameter("@usuario_update", SqlDbType.SmallInt));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@usuario_update"].Value = _TRG_Trigger_RiesgosBE.Usuario_update;
cnx.Open();
cmd.ExecuteNonQuery();
_vcod = true;
}
catch (SqlException x)
{
_vcod = false;
}
catch (Exception x)
{
_vcod = false;
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
return(_vcod);
}
public List <TRG_Trigger_RiesgosBE> ListarTRG_Trigger_RiesgosO_Act()
{
string conexion = MiConexion.GetCnx();
List <TRG_Trigger_RiesgosBE> lTRG_Trigger_RiesgosBE = null;
try
{
SqlConnection con = new SqlConnection(conexion);
con.Open();
SqlCommand cmd = new SqlCommand("sp_ListarTRG_Trigger_Riesgos_Act", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader drd = cmd.ExecuteReader(CommandBehavior.SingleResult);
if (drd != null)
{
lTRG_Trigger_RiesgosBE = new List <TRG_Trigger_RiesgosBE>();
int posRegistro_id = drd.GetOrdinal("Registro_id");
int posTrigger_id = drd.GetOrdinal("Trigger_id");
int posRiesgo_id = drd.GetOrdinal("Riesgo_id");
int posUsuario_update = drd.GetOrdinal("usuario_update");
int posActivo = drd.GetOrdinal("Activo");
TRG_Trigger_RiesgosBE obeCategoriaBE = null;
while (drd.Read())
{
obeCategoriaBE = new TRG_Trigger_RiesgosBE();
obeCategoriaBE.Registro_id = drd.GetInt32(posRiesgo_id);
obeCategoriaBE.Trigger_id = drd.GetInt32(posRiesgo_id);
obeCategoriaBE.Riesgo_id = drd.GetInt32(posRiesgo_id);
obeCategoriaBE.Usuario_update = drd.GetInt16(posUsuario_update);
obeCategoriaBE.Activo = drd.GetBoolean(posActivo);
lTRG_Trigger_RiesgosBE.Add(obeCategoriaBE);
}
drd.Close();
}
con.Close();
}
catch (SqlException ex)
{
}
catch (Exception ex)
{
}
return(lTRG_Trigger_RiesgosBE);
}
public int InsertarTRG_Trigger_Riesgos(TRG_Trigger_RiesgosBE _TRG_Trigger_RiesgosBE)
{
cnx.ConnectionString = MiConexion.GetCnx();
cmd.Connection = cnx;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_InsertarTRG_Trigger_Riesgos";
SqlParameter par1;
int _Categoria_id;
try
{
par1 = cmd.Parameters.Add(new SqlParameter("@Trigger_id", SqlDbType.SmallInt));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Trigger_id"].Value = _TRG_Trigger_RiesgosBE.Trigger_id;
par1 = cmd.Parameters.Add(new SqlParameter("@Riesgo_id", SqlDbType.SmallInt));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Riesgo_id"].Value = _TRG_Trigger_RiesgosBE.Riesgo_id;
par1 = cmd.Parameters.Add(new SqlParameter("@usuario_update", SqlDbType.Int));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@usuario_update"].Value = _TRG_Trigger_RiesgosBE.Usuario_update;
cnx.Open();
dtr = cmd.ExecuteReader();
dtr.Read();
_Categoria_id = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("@@identity")));
}
catch (SqlException x)
{
_Categoria_id = 0;
}
catch (Exception x)
{
_Categoria_id = 0;
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
return(_Categoria_id);
}
public TRG_Trigger_RiesgosBE TraerTRG_Trigger_RiesgosById(int _Riesgo_id)
{
TRG_Trigger_RiesgosBE _TRG_Trigger_RiesgosBE = new TRG_Trigger_RiesgosBE();
DataSet dts = new DataSet();
try
{
cnx.ConnectionString = MiConexion.GetCnx();
cmd.Connection = cnx;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_TraerTRG_Trigger_RiesgosById";
cmd.Parameters.Add(new SqlParameter("@Riesgo_id", SqlDbType.Int));
cmd.Parameters["@Riesgo_id"].Value = _Riesgo_id;
cnx.Open();
dtr = cmd.ExecuteReader();
if (dtr.HasRows == true)
{
dtr.Read();
var _with1 = _TRG_Trigger_RiesgosBE;
_with1.Registro_id = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("Riesgo_id")));
_with1.Trigger_id = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("Riesgo_id")));
_with1.Registro_id = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("Riesgo_id")));
_with1.Usuario_update = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("Valor")));
_with1.Activo = Convert.ToBoolean(dtr.GetValue(dtr.GetOrdinal("activo")));
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
return(_TRG_Trigger_RiesgosBE);
}
public bool ActualizarTRG_Trigger_RiesgosFin(TRG_Trigger_RiesgosBE _inseBE)
{
return(_TRG_Trigger_RiesgosADO.ActualizarTRG_Trigger_RiesgosFin(_inseBE));
}
public int InsertarTRG_Trigger_Riesgos(TRG_Trigger_RiesgosBE _inseBE)
{
return(_TRG_Trigger_RiesgosADO.InsertarTRG_Trigger_Riesgos(_inseBE));
}