public PopUp_Tarea_Response DatosPopUp(Tarea_Request obj)
{
try
{
return(PlanificarBL.DatosPopUp(obj));
}
catch (Exception)
{
throw;
}
}
public PopUp_Tarea_Response PopUpPlanificar(Tarea_Request obj)
{
try
{
return(planificarService.DatosPopUp(obj));
}
catch (Exception)
{
throw;
}
}
public PopUp_Tarea_Response DatosPopUp(Tarea_Request obj)
{
try
{
//PortafolioDA portafolioDA = new PortafolioDA();
PopUp_Tarea_Response response = new PopUp_Tarea_Response();
response.cbo_nivel = planificarDA.BuscarNivel();
return(response);
}
catch (Exception)
{
throw;
}
}
public List <Tarea_Response> BuscarTareas(Tarea_Request entidad)
{
List <Tarea_Response> retorno = null;
Tarea_Response tmp = null;
try
{
using (SqlConnection conection = new SqlConnection(ConfigurationManager.ConnectionStrings["cnxIndra"].ConnectionString))
{
conection.Open();
using (SqlCommand command = new SqlCommand("[pa_sps_proyecto_tarea]", conection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@vi_nid_proyecto", entidad.nid_proyecto);
using (SqlDataReader dr = command.ExecuteReader())
{
retorno = new List <Tarea_Response>();
if (dr.HasRows)
{
while (dr.Read())
{
tmp = new Tarea_Response();
tmp.nid_tarea = dr.GetInt32(dr.GetOrdinal("nid_tarea"));
tmp.nid_nivel = dr.GetInt32(dr.GetOrdinal("nid_nivel"));
tmp.no_codigo = dr.GetString(dr.GetOrdinal("no_codigo"));
tmp.no_nombre = dr.GetString(dr.GetOrdinal("no_nombre"));
tmp.fecha_inicio = dr.GetString(dr.GetOrdinal("fe_inicio"));
tmp.fecha_fin = dr.GetString(dr.GetOrdinal("fe_fin"));
tmp.po_programado = dr.GetInt32(dr.GetOrdinal("po_programado"));
tmp.po_real = dr.GetInt32(dr.GetOrdinal("po_real"));
retorno.Add(tmp);
}
}
else
{
retorno = new List <Tarea_Response>();
}
}
}
conection.Close();
}
return(retorno);
}
catch (Exception ex)
{
throw (ex);
}
}
