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