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