protected void BtnBuscar_Click(object sender, EventArgs e) { if (TXTBuscar.Text.Trim() == string.Empty) { TXTBuscar.BorderColor = System.Drawing.Color.Red; AlertaID.Visible = true; ListarProblema(); } else { Controlador.ControladorTareas AuxControladorTarea = new Controlador.ControladorTareas(); Modelo.Reportar_Problema reportar = new Modelo.Reportar_Problema(); reportar = AuxControladorTarea.ObtenerIDReportarProblema(Convert.ToInt32(TXTBuscar.Text)); if (reportar.ID_PROBLEMA1 != Convert.ToInt32(TXTBuscar.Text)) { TXTBuscar.BorderColor = System.Drawing.Color.Red; AlertaIDNoExiste.Visible = true; AlertaID.Visible = false; } else { TXTBuscar.BorderColor = System.Drawing.Color.Green; AlertaID.Visible = false; AlertaIDNoExiste.Visible = false; ListarProblemaConFiltro(); } } }
protected void BtnAgregarMotivo_Click(object sender, EventArgs e) { if (TXTMotivo.Text.Trim() == string.Empty) { TXTBuscar.BorderColor = System.Drawing.Color.Red; Alerta.Visible = true; AlertaExito.Visible = false; } else { TXTMotivo.BorderColor = System.Drawing.Color.Green; Alerta.Visible = false; AlertaExito.Visible = true; Controlador.ControladorTareas AuxControladorTarea = new Controlador.ControladorTareas(); Modelo.Reportar_Problema AuxReportar = new Modelo.Reportar_Problema(); AuxReportar.ID_TAREA1 = Convert.ToInt32(IDTRANSFERIDO.Text); AuxReportar.Motivo1 = TXTMotivo.Text; AuxReportar.FechaHoy1 = DateTime.Today; AuxControladorTarea.ReportarProblema(AuxReportar); ListarProblema(); } }
public bool ReportarProblema(Modelo.Reportar_Problema reportar) { try { Conexion conexion = new Conexion(); OracleConnection conn = new OracleConnection(); conn = conexion.getConn(); conn.Open(); OracleCommand comando = new OracleCommand("AGREGARREPORTARPROBLEMA", conn); comando.CommandType = System.Data.CommandType.StoredProcedure; comando.Parameters.Add("@idtarea", OracleDbType.Int32).Value = reportar.ID_TAREA1; comando.Parameters.Add("@motivo", OracleDbType.Varchar2).Value = reportar.Motivo1; comando.Parameters.Add("@fecha", OracleDbType.Date).Value = reportar.FechaHoy1; comando.ExecuteNonQuery(); conn.Close(); } catch (Exception) { return(false); } return(true); }
public Modelo.Reportar_Problema ObtenerIDReportarProblema(int idproblema) { Modelo.Reportar_Problema reportar = new Modelo.Reportar_Problema(); Conexion conexion = new Conexion(); OracleConnection conn = new OracleConnection(); conn = conexion.getConn(); conn.Open(); OracleCommand comando = new OracleCommand("SELECT * FROM REPORTAR_PROBLEMA WHERE ID_PROBLEMA = :IDPROBLEMA", conn); comando.Parameters.Add(":IDPROBLEMA", idproblema); OracleDataReader lector = comando.ExecuteReader(); if (lector.Read()) { reportar.ID_PROBLEMA1 = Convert.ToInt32(lector["ID_PROBLEMA"].ToString()); } conn.Close(); return(reportar); }