public Association getAssociationById(int idAssociation) { Association association = null; using (SqlConnection sqlConnection = getConnection()) { sqlConnection.Open(); String query = "SELECT a.registry_code, ISNULL(a.type,0), ISNULL(a.name_association, 'No disponible'), ISNULL(a.region, 'No disponible')," + " ISNULL(a.canton, 'No disponible'), ISNULL(a.province, 'No disponible'), ISNULL(a.status, '0'), ISNULL(a.active, 'No')," + " ISNULL(a.adequacy, 'No'), ISNULL(a.affidavit, 'No'), ISNULL(a.legal_document, 'No disponible'), ISNULL(a.superavit, 'No')," + " ISNULL(a.id_economic, 0), ISNULL(a.id_settlement, 0), ISNULL(a.id_work, 0), ISNULL(a.id_concrete, 0)" + " from Association a Where a.registry_code = " + idAssociation + ";"; SqlCommand sqlSelect = new SqlCommand(query, sqlConnection); string varStatus; string varActive; string varAdequacy; string varAffidavit; string varSuperavit; using (SqlDataReader reader = sqlSelect.ExecuteReader()) { while (reader.Read()) { /*Association*/ int registryCode = reader.GetInt32(0); int type = reader.GetInt32(1); string name = reader.GetString(2); string region = reader.GetString(3); string canton = reader.GetString(4); string province = reader.GetString(5); string status = reader.GetString(6); string active = reader.GetString(7); string adequacy = reader.GetString(8); string affidavit = reader.GetString(9); string legalDocument = reader.GetString(10); string superavit = reader.GetString(11); int idEconomic = reader.GetInt32(12); int idSettlement = reader.GetInt32(13); int idWork = reader.GetInt32(14); int idConcrete = reader.GetInt32(15); /*WorkPlan*/ if (idWork.Equals(0)) { workPlan = new WorkPlan(0, "1/1/1", "Pendiente"); } else { workPlan = getWorkPlanById(idWork); } /*EconomicReport*/ if (idEconomic.Equals(0)) { economicReport = new EconomicReport(0, new DateTime(1, 1, 1), "0000", 0f, 'N'); } else { economicReport = getEconomicReportById(idEconomic); } /*Settlement*/ if (idSettlement.Equals(0)) { settlement = new Settlement(0, new DateTime(1, 1, 1), "0000", 'N'); } else { settlement = getSettlementById(idSettlement); } /*ConcreteLiquitation*/ if (idConcrete.Equals(0)) { concreteLiquidation = new ConcreteLiquidation(0, new DateTime(1, 1, 1), "0000", 'N'); } else { concreteLiquidation = getConcreteById(idConcrete); } /*Status*/ if (status.Equals("1")) { varStatus = "Al Día"; } else { varStatus = "Pendiente"; } /*Active*/ if (active.Equals("YES")) { varActive = "Activa"; } else { varActive = "Inactiva"; } /*Adequacy*/ if (adequacy.Equals("YES")) { varAdequacy = "Si"; } else { varAdequacy = "No"; } /*Affidavit*/ if (affidavit.Equals("YES")) { varAffidavit = "Si"; } else { varAffidavit = "No"; } /*Superavit*/ if (superavit.Equals("YES")) { varSuperavit = "Si"; } else { varSuperavit = "No"; } status = varStatus; active = varActive; adequacy = varAdequacy; affidavit = varAffidavit; superavit = varSuperavit; association = new Association(registryCode, name, region, canton, status, active, province, legalDocument, superavit, adequacy, affidavit, type, workPlan, settlement, economicReport, concreteLiquidation); } sqlConnection.Close(); } return(association); } }