protected void BtnAgregarMotivo_Click(object sender, EventArgs e) { if (TXTMotivo.Text.Trim() == string.Empty) { TXTBuscar.BorderColor = System.Drawing.Color.Red; Alerta.Visible = true; } else { TXTBuscar.BorderColor = System.Drawing.Color.Green; Alerta.Visible = false; int idrecibido = Convert.ToInt32(IDTRANSFERIDO.Text); Controlador.ControladorTareas AuxControladorTarea = new Controlador.ControladorTareas(); Modelo.AtrasoTarea AuxAtrasoTarea = new Modelo.AtrasoTarea(); AuxAtrasoTarea.ID_Tarea1 = idrecibido; AuxAtrasoTarea.Motivo1 = TXTMotivo.Text; AuxAtrasoTarea.Fecha_Hoy1 = DateTime.Today; AuxControladorTarea.AgregarAtrasoTarea(AuxAtrasoTarea); ListarAtraso(); } }
protected void BtnBuscar_Click(object sender, EventArgs e) { if (TXTBuscar.Text.Trim() == string.Empty) { TXTBuscar.BorderColor = System.Drawing.Color.Red; AlertaID.Visible = true; AlertaIDNoExiste.Visible = false; ListarAtraso(); } else { Controlador.ControladorTareas AuxControladorTarea = new Controlador.ControladorTareas(); Modelo.AtrasoTarea ATRASO = new Modelo.AtrasoTarea(); ATRASO = AuxControladorTarea.ObtenerIDAtrasoTarea(Convert.ToInt32(TXTBuscar.Text)); if (ATRASO.ID_Tarea1 != Convert.ToInt32(TXTBuscar.Text)) { TXTBuscar.BorderColor = System.Drawing.Color.Red; AlertaID.Visible = false; AlertaIDNoExiste.Visible = true; } else { TXTBuscar.BorderColor = System.Drawing.Color.Green; AlertaID.Visible = false; AlertaIDNoExiste.Visible = false; FiltrarAtraso(); } } }
public bool AgregarAtrasoTarea(Modelo.AtrasoTarea atraso) { try { Conexion conexion = new Conexion(); OracleConnection conn = new OracleConnection(); conn = conexion.getConn(); conn.Open(); OracleCommand comando = new OracleCommand("AGREGARATRASOTAREA", conn); comando.CommandType = System.Data.CommandType.StoredProcedure; comando.Parameters.Add("ID_TAREA", OracleDbType.Int32).Value = atraso.ID_Tarea1; comando.Parameters.Add("MOTIVO_ATRASO", OracleDbType.Varchar2).Value = atraso.Motivo1; comando.Parameters.Add("FECHA_ATRASO", OracleDbType.Date).Value = atraso.Fecha_Hoy1; comando.ExecuteNonQuery(); conn.Close(); } catch (Exception) { return(false); } return(true); }
public Modelo.AtrasoTarea ObtenerIDAtrasoTarea(int idatraso) { Modelo.AtrasoTarea atraso = new Modelo.AtrasoTarea(); Conexion conexion = new Conexion(); OracleConnection conn = new OracleConnection(); conn = conexion.getConn(); conn.Open(); OracleCommand comando = new OracleCommand("SELECT * FROM ATRASO WHERE ID_ATRASO = :IDATRASO", conn); comando.Parameters.Add(":IDATRASO", idatraso); OracleDataReader lector = comando.ExecuteReader(); if (lector.Read()) { atraso.ID_Tarea1 = Convert.ToInt32(lector["ID_ATRASO"].ToString()); } conn.Close(); return(atraso); }