public void DA_Registrar_REUNION(AP_Reunion r)
{
try
{
using (SqlConnection conexion = new SqlConnection(conexionString))
{
SqlCommand cmd = new SqlCommand("GAP_REUNION_INSERT", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id_Campanhia", r.Id_Campanhia);
cmd.Parameters.AddWithValue("@Id_Regional", r.Id_Regional);
cmd.Parameters.AddWithValue("@Tipo_Reunion", r.Tipo_Reunion);
cmd.Parameters.AddWithValue("@Lugar", r.Lugar);
cmd.Parameters.AddWithValue("@Fecha", r.Fecha);
cmd.Parameters.AddWithValue("@Conclusion", r.Conclusion);
cmd.Parameters.AddWithValue("@Consulta", "REUNION");
conexion.Open();
cmd.ExecuteNonQuery();
conexion.Close();
}
}
catch (Exception err)
{
throw (new Exception(err.ToString() + "-" + err.Source.ToString() + "-" + err.Message.ToString()));
}
}
protected void Registrar_REUNION()
{
DB_AP_Reunion insert = new DB_AP_Reunion();
AP_Reunion r = new AP_Reunion();
r.Id_Campanhia = Convert.ToInt32(LblIdCamp.Text);
r.Id_Regional = Convert.ToInt32(DDLRegional.SelectedValue);
r.Tipo_Reunion = DDLTipoReunion.SelectedValue;
r.Lugar = TxtLugar.Text;
r.Fecha = Convert.ToDateTime(LblFecha.Text);
r.Conclusion = TxtConclucion.Text;
insert.DB_Registrar_REUNION(r);
DB_AP_Registro_Org aux = new DB_AP_Registro_Org();
LblIdReunion.Text = aux.DB_MaxId("AP_REUNION", "Id_Reunion");
Registrar_ASISTENCIA();
Registrar_TEMAS();
}
public void DB_Registrar_REUNION(AP_Reunion r)
{
DA_AP_Reunion Inscripcion = new DA_AP_Reunion();
Inscripcion.DA_Registrar_REUNION(r);
}
