public Report_Project_Data GetProject(int id)
{
Report_Project_Data project = new Report_Project_Data();
Project pr;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existProject(id))
{
project = null;
return(project);
}
pr = construyeEntities.Projects.Where(e => e.id == id).ToList().First();
project.id = pr.id;
project.id_client = pr.id_client;
project.manager = pr.manager;
project.name = pr.name;
project.ubication = pr.ubication;
var costos = construyeEntities.usp_total_bills(id).First();
var etapasList = construyeEntities.Stages.Where(e => e.id_project == id).ToList();
List <int> idStageList = new List <int>();
for (int i = 0; i < etapasList.Count; ++i)
{
idStageList.Add(etapasList.ElementAt(i).id);
}
var anotationsList = construyeEntities.Anotations.Where(e => e.id_project == id).ToList();
List <int> idAnotationList = new List <int>();
for (int i = 0; i < anotationsList.Count; ++i)
{
idAnotationList.Add(anotationsList.ElementAt(i).id);
}
project.totalCost = (int)costos.TotalReal;
project.totalBudget = (int)costos.TotalPresupuesto;
project.idAnotations = idAnotationList;
project.idStages = idStageList;
return(project);
}
catch (Exception E)
{
project = null;
return(project);
}
}
}
public IHttpActionResult GetProject(int id)
{
if (!projectLogic.existProject(id))
{
//No se encontró el recurso code 404
return(NotFound());
}
Report_Project_Data project = projectLogic.GetProject(id);
if (project != null)
{
// ok code 200
return(Ok(project));
}
else
{
//No se pudo crear el recurso por un error interno code 500
return(InternalServerError());
}
}
public List <Object> GetListProject()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var projectList = construyeEntities.Projects.ToList();
int n = projectList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < projectList.Count; ++i)
{
Report_Project_Data project = new Report_Project_Data();
Project pr;
pr = projectList.ElementAt(i);
project.id = pr.id;
project.id_client = pr.id_client;
project.manager = pr.manager;
project.name = pr.name;
project.ubication = pr.ubication;
var costos = construyeEntities.usp_total_bills(pr.id).First();
var etapasList = construyeEntities.Stages.Where(e => e.id_project == pr.id).ToList();
List <int> idStageList = new List <int>();
for (int j = 0; j < etapasList.Count; ++j)
{
idStageList.Add(etapasList.ElementAt(j).id);
}
var anotationsList = construyeEntities.Anotations.Where(e => e.id_project == pr.id).ToList();
List <int> idAnotationList = new List <int>();
for (int j = 0; j < anotationsList.Count; ++j)
{
idAnotationList.Add(anotationsList.ElementAt(j).id);
}
if (costos.TotalPresupuesto == null || costos.TotalReal == null)
{
project.totalCost = 0;
project.totalBudget = 0;
project.idAnotations = idAnotationList;
project.idStages = idStageList;
dataList.Add(project);
continue;
}
project.totalCost = (int)costos.TotalReal;
project.totalBudget = (int)costos.TotalPresupuesto;
project.idAnotations = idAnotationList;
project.idStages = idStageList;
dataList.Add(project);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}