public ConcreteLiquidation getConcreteById(int idConcrete)
{
ConcreteLiquidation concreteLiquidation = null;
using (SqlConnection sqlConnection = getConnection())
{
sqlConnection.Open();
String query = "select c.date_received, c.year, c.status from ConcreteLiquidation c where c.id_concrete = " + idConcrete + ";";
SqlCommand sqlSelect = new SqlCommand(query, sqlConnection);
using (SqlDataReader reader = sqlSelect.ExecuteReader())
{
while (reader.Read())
{
concreteLiquidation = new ConcreteLiquidation();
concreteLiquidation.DateReceived = reader.GetDateTime(0);
concreteLiquidation.Year = reader.GetString(1);
string statusConcrete = reader.GetString(2);
char[] cadConcrete = statusConcrete.ToCharArray();
concreteLiquidation.Status = cadConcrete[0];
}
sqlConnection.Close();
}
return(concreteLiquidation);
}
}
//GET: Employee/EditConcreteLiquidation/5
public ActionResult EditConcreteLiquidation(int Id, int idLogin)
{
this.ViewBag.Id = idLogin;
concreteLiquidation = employeeData.getConcreteById(Id);
concreteLiquidation.Id = Id;
return(View(concreteLiquidation));
}
public ActionResult EditConcreteLiquidation(int Id, DateTime dateReceived, string year, int idLogin)
{
try
{
this.ViewBag.Id = idLogin;
ConcreteLiquidation concreteLiquidation = new ConcreteLiquidation(Id, dateReceived, year);
employeeData.updateConcreteLiquidation(concreteLiquidation);
employeeData.insertBitacora(idLogin, "Modifico una asociacion");
return(RedirectToAction("Search", "Employee", new { loginUser = idLogin }));
}
catch
{
return(View());
}
}
/// <summary>
///
/// </summary>
/// <param name="association"></param>
public void updateConcreteLiquidation(ConcreteLiquidation concreteLiquidation)
{
string queryConcrete = null;
Association association = new Association();
using (SqlConnection sqlConnection = getConnection())
{
sqlConnection.Open();
queryConcrete = "UPDATE ConcreteLiquidation SET date_received = '" + concreteLiquidation.DateReceived + "', " +
"year = '" + concreteLiquidation.Year + "'" +
"WHERE ConcreteLiquidation.id_concrete = " + concreteLiquidation.Id;
SqlCommand sqlConcrete = new SqlCommand(queryConcrete, sqlConnection);
sqlConcrete.ExecuteNonQuery();
}
}
/*FOR SEARCH ASSOCIATION*/
public Association getAssociationId(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);
}
}
public List <Association> getAllAssotiations()
{
List <Association> assotiations;
assotiations = new List <Association>();
Association association;
WorkPlan workPlan;
Settlement settlement;
EconomicReport economicReport;
ConcreteLiquidation concreteLiquidation;
using (SqlConnection conn = GetConnection())
{
conn.Open();
SqlCommand commandGetAssotiation = new SqlCommand("getAllAssotiations", conn);
using (SqlDataReader reader = commandGetAssotiation.ExecuteReader())
{
while (reader.Read())
{
//Obtengo asociacion
int id = reader.GetInt32(0);
int registryCode = reader.GetInt32(1);
int type = reader.GetInt32(2);
string name = reader.GetString(3);
string region = reader.GetString(4);
string canton = reader.GetString(5);
string province = reader.GetString(6);
string status = reader.GetString(7);
string active = reader.GetString(8);
string adequacy = reader.GetString(9);
string affiavit = reader.GetString(10);
string legalDocument = reader.GetString(15);
string superavit = reader.GetString(16);
workPlan = new WorkPlan();
//work plan assotiation
workPlan.Id = reader.GetInt32(8);
workPlan.AssemblyDate = reader.GetString(9);// averiguar
workPlan.Status = reader.GetString(10);
settlement = new Settlement();
//settlement association
settlement.Id = reader.GetInt32(11);
settlement.DateReceived = reader.GetDateTime(12);
settlement.Year = reader.GetString(13);
string statusSettlement = reader.GetString(14);
char[] cadSettlement = statusSettlement.ToCharArray();
settlement.Status = cadSettlement[0];
economicReport = new EconomicReport();
//economic report assotiation
economicReport.Id = reader.GetInt32(15);
economicReport.DateReceived = reader.GetDateTime(16);
economicReport.Year = reader.GetString(17);
economicReport.Balance = (float)reader.GetDouble(18);
string statusEconomic = reader.GetString(19);
char[] cadEconomic = statusEconomic.ToCharArray();
economicReport.Status = cadEconomic[0];
concreteLiquidation = new ConcreteLiquidation();
//concrete
concreteLiquidation.Id = reader.GetInt32(20);
concreteLiquidation.DateReceived = reader.GetDateTime(21);
concreteLiquidation.Year = reader.GetString(22);
string statusConcrete = reader.GetString(23);
char[] cadConcrete = statusConcrete.ToCharArray();
concreteLiquidation.Status = cadConcrete[0];
association = new Association(id, registryCode, name, region, canton, status, active, province, legalDocument, superavit, adequacy, affiavit, type,
workPlan, settlement, economicReport, concreteLiquidation);
assotiations.Add(association);
}
conn.Close();
}
return(assotiations);
}
}
