public IHttpActionResult GetStage(int id)
{
if (!stageLogic.existStage(id))
{
//No se encontró el recurso code 404
return(NotFound());
}
Report_Stage_Data stage = stageLogic.GetStage(id);
if (stage != null)
{
// ok code 200
return(Ok(stage));
}
else
{
//No se pudo crear el recurso por un error interno code 500
return(InternalServerError());
}
}
public Report_Stage_Data GetStage(int id)
{
Report_Stage_Data result = new Report_Stage_Data();
Stage data = new Stage();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existStage(id))
{
result = null;
return(result);
}
data = construyeEntities.Stages.Find(id);
result.id = data.id;
result.id_project = data.id_project;
result.name = data.name;
result.start_date = data.start_date;
result.status = data.status;
result.end_date = data.end_date;
result.description = data.description;
var costos = construyeEntities.usp_total_stage(id).First();
var idMaterials = construyeEntities.MaterialsxStages.Where(e => e.id_stage == id).ToList();
List <int> idmaterialList = new List <int>();
for (int i = 0; i < idMaterials.Count; ++i)
{
idmaterialList.Add(idMaterials.ElementAt(i).id_material);
}
var billList = data.Bills.ToList();
List <int> idbillList = new List <int>();
for (int i = 0; i < billList.Count; ++i)
{
idbillList.Add(billList.ElementAt(i).id);
}
if (costos.TotalPresupuesto == null || costos.TotalReal == null)
{
result.totalCost = 0;
result.totalBudget = 0;
result.idMaterials = idmaterialList;
result.idBills = idbillList;
return(result);
}
result.totalCost = (int)costos.TotalReal;
result.totalBudget = (int)costos.TotalPresupuesto;
result.idMaterials = idmaterialList;
result.idBills = idbillList;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public List <Object> GetListStage()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var stageList = construyeEntities.Stages.ToList();
int n = stageList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < stageList.Count; ++i)
{
Report_Stage_Data data = new Report_Stage_Data();
data.id = stageList.ElementAt(i).id;
data.id_project = stageList.ElementAt(i).id_project;
data.name = stageList.ElementAt(i).name;
data.status = stageList.ElementAt(i).status;
data.description = stageList.ElementAt(i).description;
data.start_date = stageList.ElementAt(i).start_date;
data.end_date = stageList.ElementAt(i).end_date;
var costos = construyeEntities.usp_total_stage(data.id).First();
var idMaterials = construyeEntities.MaterialsxStages.Where(e => e.id_stage == data.id).ToList();
List <int> idmaterialList = new List <int>();
for (int j = 0; j < idMaterials.Count; ++j)
{
idmaterialList.Add(idMaterials.ElementAt(j).id_material);
}
var billList = stageList.ElementAt(i).Bills.ToList();
List <int> idbillList = new List <int>();
for (int j = 0; j < billList.Count; j++)
{
idbillList.Add(billList.ElementAt(j).id);
}
if (costos.TotalPresupuesto == null || costos.TotalReal == null)
{
data.totalCost = 0;
data.totalBudget = 0;
data.idMaterials = idmaterialList;
data.idBills = idbillList;
dataList.Add(data);
continue;
}
data.totalCost = (int)costos.TotalReal;
data.totalBudget = (int)costos.TotalPresupuesto;
data.idMaterials = idmaterialList;
data.idBills = idbillList;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
