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