protected void Page_Load(object sender, EventArgs e) { try { if (this.IsPostBack) { } else { _Alerta_id = Convert.ToInt32(Request.QueryString["Alerta_id"]); if (Request.QueryString["reg"] != null) { _reg = Request.QueryString["reg"].ToString(); } if (_reg == "ver") { btnRegistrar.Visible = false; } _ALR_AlertasBE = _ALR_AlertasBL.TraerALR_AlertasById(_Alerta_id); lblAlerta_id.Text = _ALR_AlertasBE.Alerta_id.ToString(); txtFecha.Text = _ALR_AlertasBE.Fecha_alerta.ToString("dd/MM/yyyy"); if (_ALR_AlertasBE.Estado == 1) { rblEstado.SelectedValue = "2"; } else { rblEstado.SelectedValue = _ALR_AlertasBE.Estado.ToString(); } lTTB_GuardiaBE = _TB_GuardiaBL.ListarTB_GuardiaO_Act(); Session["Guardias"] = lTTB_GuardiaBE; lTTB_AreaBE = _TB_AreaBL.ListarTB_AreaO_Act(); Session["Areas"] = lTTB_AreaBE; lTALR_SistemaqaBE = _ALR_SistemaqaBL.ListarALR_SistemaqaO_Act(); Session["SistemasQA"] = lTALR_SistemaqaBE; LlenarComboOriginador(); ddlOriginador.SelectedValue = _ALR_AlertasBE.Originador.ToString(); LlenarComboDepartamento(); ddlDepartamento.SelectedValue = _ALR_AlertasBE.Departamento_id.ToString(); LlenarComboArea(); ddlArea.SelectedValue = _ALR_AlertasBE.Area_id.ToString(); LlenarComboGuardia(); ddlGuardia.SelectedValue = _ALR_AlertasBE.Guardia_id.ToString(); LlenarComboSistemaQA(); LlenarComboCriticidad(); ddlSistemaQA.SelectedValue = _ALR_AlertasBE.SistemaQA_id.ToString(); lblSistemaQA_nom.Text = TraerSistemaQANombre(_ALR_AlertasBE.SistemaQA_id); ddlClasificacion.SelectedValue = _ALR_AlertasBE.Clasificacion.ToString(); txtDescripcion.Text = _ALR_AlertasBE.Alerta_desc; GenerarTablaPlanInmediato(_Alerta_id, txtDescripcion.Text); GenerarTablaPlanSistemico(_Alerta_id, txtDescripcion.Text); } } catch (Exception x) { // Response.Redirect("error.aspx"); } }
public ALR_AlertasBE TraerALR_AlertasById(int _Alerta_id) { ALR_AlertasBE _AlertasBE = new ALR_AlertasBE(); DataSet dts = new DataSet(); try { cnx.ConnectionString = MiConexion.GetCnx(); cmd.Connection = cnx; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_TraerALR_AlertasById"; cmd.Parameters.Add(new SqlParameter("@Alerta_id", SqlDbType.Int)); cmd.Parameters["@Alerta_id"].Value = _Alerta_id; cnx.Open(); dtr = cmd.ExecuteReader(); if (dtr.HasRows == true) { dtr.Read(); var _with1 = _AlertasBE; _with1.Alerta_id = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("Alerta_id"))); _with1.Alerta_desc = dtr.GetValue(dtr.GetOrdinal("Alerta_desc")).ToString(); _with1.Clasificacion = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("Clasificacion"))); _with1.Departamento_id = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("Departamento_id"))); _with1.Area_id = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("Area_id"))); _with1.Guardia_id = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("guardia_id"))); _with1.ElementoClave_id = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("ElementoClave_id"))); _with1.SistemaQA_id = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("SistemaQA_id"))); _with1.Originador = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("Originador"))); _with1.Estado = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("estado"))); _with1.Fecha_alerta = Convert.ToDateTime(dtr.GetValue(dtr.GetOrdinal("Fecha_alerta"))); _with1.Fecha_registro = Convert.ToDateTime(dtr.GetValue(dtr.GetOrdinal("Fecha_registro"))); _with1.Registrador = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("Registrador"))); _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(_AlertasBE); }
public bool ActualizarALR_Alertas(ALR_AlertasBE _inseBE) { return(_ALR_AlertasADO.ActualizarALR_Alertas(_inseBE)); }
public int InsertarALR_Alertas(ALR_AlertasBE _inseBE) { return(_ALR_AlertasADO.InsertarALR_Alertas(_inseBE)); }
public bool ActualizarALR_Alertas(ALR_AlertasBE _AlertasBE) { cnx.ConnectionString = MiConexion.GetCnx(); cmd.Connection = cnx; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_ActualizarALR_Alertas"; SqlParameter par1; try { par1 = cmd.Parameters.Add(new SqlParameter("@Alerta_id", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Alerta_id"].Value = _AlertasBE.Alerta_id; par1 = cmd.Parameters.Add(new SqlParameter("@Alerta_desc", SqlDbType.VarChar, 800)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Alerta_desc"].Value = _AlertasBE.Alerta_desc; par1 = cmd.Parameters.Add(new SqlParameter("@Departamento_id", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Departamento_id"].Value = _AlertasBE.Departamento_id; par1 = cmd.Parameters.Add(new SqlParameter("@Area_id", SqlDbType.SmallInt)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Area_id"].Value = _AlertasBE.Area_id; par1 = cmd.Parameters.Add(new SqlParameter("@Guardia_id", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Guardia_id"].Value = _AlertasBE.Guardia_id; par1 = cmd.Parameters.Add(new SqlParameter("@SistemaQA_id", SqlDbType.SmallInt)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@SistemaQA_id"].Value = _AlertasBE.SistemaQA_id; par1 = cmd.Parameters.Add(new SqlParameter("@ElementoClave_id", SqlDbType.SmallInt)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@ElementoClave_id"].Value = _AlertasBE.ElementoClave_id; par1 = cmd.Parameters.Add(new SqlParameter("@Originador", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Originador"].Value = _AlertasBE.Originador; par1 = cmd.Parameters.Add(new SqlParameter("@Clasificacion", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Clasificacion"].Value = _AlertasBE.Clasificacion; par1 = cmd.Parameters.Add(new SqlParameter("@Estado", SqlDbType.SmallInt)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Estado"].Value = _AlertasBE.Estado; par1 = cmd.Parameters.Add(new SqlParameter("@Fecha_alerta", SqlDbType.DateTime)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Fecha_alerta"].Value = _AlertasBE.Fecha_alerta; par1 = cmd.Parameters.Add(new SqlParameter("@Registrador", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Registrador"].Value = _AlertasBE.Registrador; 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 int InsertarALR_Alertas(ALR_AlertasBE _AlertasBE) { cnx.ConnectionString = MiConexion.GetCnx(); cmd.Connection = cnx; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_InsertarALR_Alertas"; SqlParameter par1; try { //SqlParameter par4 = cmd.Parameters.Add("@@identity", SqlDbType.Int); //par4.Direction = ParameterDirection.ReturnValue; par1 = cmd.Parameters.Add(new SqlParameter("@Alerta_desc", SqlDbType.VarChar, 800)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Alerta_desc"].Value = _AlertasBE.Alerta_desc; par1 = cmd.Parameters.Add(new SqlParameter("@Departamento_id", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Departamento_id"].Value = _AlertasBE.Departamento_id; par1 = cmd.Parameters.Add(new SqlParameter("@Area_id", SqlDbType.SmallInt)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Area_id"].Value = _AlertasBE.Area_id; par1 = cmd.Parameters.Add(new SqlParameter("@Guardia_id", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Guardia_id"].Value = _AlertasBE.Guardia_id; par1 = cmd.Parameters.Add(new SqlParameter("@SistemaQA_id", SqlDbType.SmallInt)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@SistemaQA_id"].Value = _AlertasBE.SistemaQA_id; par1 = cmd.Parameters.Add(new SqlParameter("@ElementoClave_id", SqlDbType.SmallInt)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@ElementoClave_id"].Value = _AlertasBE.ElementoClave_id; par1 = cmd.Parameters.Add(new SqlParameter("@Clasificacion", SqlDbType.SmallInt)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Clasificacion"].Value = _AlertasBE.Clasificacion; par1 = cmd.Parameters.Add(new SqlParameter("@Originador", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Originador"].Value = _AlertasBE.Originador; par1 = cmd.Parameters.Add(new SqlParameter("@Estado", SqlDbType.SmallInt)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Estado"].Value = _AlertasBE.Estado; par1 = cmd.Parameters.Add(new SqlParameter("@Fecha_alerta", SqlDbType.DateTime)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Fecha_alerta"].Value = _AlertasBE.Fecha_alerta; par1 = cmd.Parameters.Add(new SqlParameter("@Registrador", SqlDbType.Int)); par1.Direction = ParameterDirection.Input; cmd.Parameters["@Registrador"].Value = _AlertasBE.Registrador; cnx.Open(); dtr = cmd.ExecuteReader(); dtr.Read(); _id_Alerta = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("Alerta_ID"))); } catch (SqlException x) { _id_Alerta = 0; } catch (Exception x) { _id_Alerta = 0; } finally { if (cnx.State == ConnectionState.Open) { cnx.Close(); } cmd.Parameters.Clear(); } return(_id_Alerta); }