public TOTransaction GetInfoValidEeRelesPQ(int inp_cont) { DAOEeReles daoEeReles = new DAOEeReles(); try { bool enc = daoEeReles.infoValidEerelesPQ(inp_cont); if (enc) { throw new Exception("La encuesta ya fue diligenciada"); } return(new TOTransaction() { retorno = 0, txtRetorno = "" }); } catch (Exception ex) { return(new TOTransaction() { retorno = 1, txtRetorno = ex.Message }); } }
public TOTransaction <List <EeResem> > getInfoEeresem(int rem_cont, int emp_codi) { DAOEeReles daoEeReles = new DAOEeReles(); try { var infoResem = daoEeReles.getInfoEeresem(rem_cont, emp_codi); return(new TOTransaction <List <EeResem> > { retorno = 0, txtRetorno = "" }); } catch (Exception ex) { return(new TOTransaction <List <EeResem> > { retorno = 1, txtRetorno = ex.Message }); } }
public TOTransaction setInfoResem(List <EeResem> eeresem) { DAOEeReles daoEeReles = new DAOEeReles(); try { daoEeReles.insertEeresem(eeresem); return(new TOTransaction() { retorno = 0, txtRetorno = "" }); } catch (Exception ex) { return(new TOTransaction() { retorno = 1, txtRetorno = ex.Message }); } }
public TOTransaction <TOPqParam> GetInfoEerelesService(int rel_serv, int emp_codi) { DAOEeReles daoEeReles = new DAOEeReles(); try { TOPqParam pqrList = daoEeReles.GetEerelesServ(rel_serv, emp_codi); return(new TOTransaction <TOPqParam>() { objTransaction = pqrList, retorno = 0, txtRetorno = "" }); } catch (Exception ex) { return(new TOTransaction <TOPqParam>() { objTransaction = null, retorno = 1, txtRetorno = ex.Message }); } }
public TOTransaction <EeReles> GetInfoDataEeReles(int rel_cont, int rem_cont, int rel_serv, int inp_cont) { DAOEeReles daoEeReles = new DAOEeReles(); try { bool enc = daoEeReles.infoValidEereles(rem_cont, rel_serv, inp_cont); DataSet result = new DataSet(); EeReles objReles = new EeReles(); int countPreg = 0; result = daoEeReles.getEeReles(rel_cont, rem_cont, inp_cont); if (result.Tables[0].Rows.Count == 0) { throw new Exception("No se encontró parametrización para la encuesta especificada."); } string redEnc = ConfigurationManager.AppSettings["redEnc"]; if (string.IsNullOrEmpty(redEnc)) { redEnc = "S"; } objReles.red_encu = redEnc; objReles.rel_cont = Int32.Parse(result.Tables[0].Rows[0]["REL_CONT"].ToString()); objReles.rel_nomb = result.Tables[0].Rows[0]["REL_NOMB"].ToString(); objReles.par_rein = result.Tables[0].Rows[0]["PAR_REIN"].ToString(); foreach (DataRow dr in result.Tables[0].Rows) { EeDrele objDrele = new EeDrele(); objDrele.sec_nomb = dr["SEC_NOMB"].ToString(); objDrele.dre_secc = Convert.ToInt32(dr["DRE_SECC"].ToString()); if (!objReles.Secciones.Exists(x => x.sec_nomb == objDrele.sec_nomb)) { objReles.Secciones.Add(objDrele); } foreach (DataRow drr in result.Tables[0].Rows) { EeDrsee objDrsee = new EeDrsee(); objDrsee.drs_preg = drr["DRS_PREG"].ToString(); objDrsee.drs_clas = drr["DRS_CLAS"].ToString(); objDrsee.sec_cont = Convert.ToInt32(drr["SEC_CONT"].ToString()); objDrsee.drs_orde = Convert.ToInt32(drr["DRS_ORDE"].ToString()); objDrsee.rse_cont = Convert.ToInt32(drr["RSE_CONT"].ToString()); objDrsee.drs_cont = Convert.ToInt32(drr["DRS_CONT"].ToString()); objDrsee.drp_cont = Convert.ToInt32(drr["DRP_CONT"].ToString()); objDrsee.res_valo = drr["RES_VALO"].ToString(); if (enc == false) { if (!objDrele.Preguntas.Exists(x => x.drs_preg == objDrsee.drs_preg) && objDrele.dre_secc.Equals(objDrsee.sec_cont)) { objDrele.Preguntas.Add(objDrsee); } } else { if (!objDrele.Preguntas.Exists(x => x.drs_preg == objDrsee.drs_preg) && objDrele.dre_secc.Equals(objDrsee.sec_cont) && objDrsee.res_valo != "") { objDrele.Preguntas.Add(objDrsee); } } foreach (DataRow drrr in result.Tables[0].Rows) { if (drrr["DRS_CLAS"].ToString() == "M" || drrr["DRS_CLAS"].ToString() == "U") { EeDdprc objDdprc = new EeDdprc(); objDdprc.ddp_cont = Convert.ToInt32(drrr["DDP_CONT"].ToString()); objDdprc.drp_cont = Convert.ToInt32(drrr["DRP_CONT"].ToString()); objDdprc.ddp_opci = drrr["DPP_OPCI"].ToString(); objDdprc.dsp_orde = Convert.ToInt32(drrr["DSP_ORDE"].ToString()); if (!objDrsee.Respuestas.Exists(x => x.ddp_opci == objDdprc.ddp_opci) && objDrele.dre_secc.Equals(objDrsee.sec_cont) && !objDrsee.Respuestas.Exists(x => x.ddp_cont == objDdprc.ddp_cont) && objDdprc.drp_cont.Equals(objDrsee.drp_cont)) { objDrsee.Respuestas.Add(objDdprc); } } } } } for (int i = 0; i < objReles.Secciones.Count; i++) { countPreg += objReles.Secciones[i].Preguntas.Count; } objReles.num_preg = countPreg; return(new TOTransaction <EeReles>() { objTransaction = objReles, retorno = 0, txtRetorno = "" }); } catch (Exception ex) { return(new TOTransaction <EeReles>() { objTransaction = null, retorno = 1, txtRetorno = ex.Message }); } }