public Worked_Hours_Data GetWorkedHours(int ID)
{
Worked_Hours_Data result = new Worked_Hours_Data();
Worked_hours wh;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existWorkedHours(ID))
{
result = null;
return(result);
}
wh = construyeEntities.Worked_hours.Find(ID);
result.id = wh.id;
result.id_employee = wh.id_employee;
result.id_project = wh.id_project;
result.hours = wh.hours;
result.date = wh.date;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public bool addWorkedHours(Worked_Hours_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
Worked_hours newwh = new Worked_hours();
newwh.id = data.id;
newwh.id_employee = data.id_employee;
newwh.id_project = data.id_project;
newwh.hours = data.hours;
newwh.date = data.date;
newwh.Project = construyeEntities.Projects.Find(data.id_project);
newwh.Employee = construyeEntities.Employees.Find(data.id_employee);
try
{
construyeEntities.Worked_hours.Add(newwh);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public IHttpActionResult addWorkedHour([FromBody] Worked_Hours_Data data)
{
if (data == null)
{
//Bad request code 400
return(BadRequest());
}
/*
* if (worked_Hours_Logic.existWorkedHours(data.id))
* {
* //petición correcta pero no pudo ser procesada porque ya existe el archivo code 202
* return StatusCode(HttpStatusCode.Accepted);
* }
*/
if (worked_Hours_Logic.addWorkedHours(data))
{
//petición correcta y se ha creado un nuevo recurso code 201
return(StatusCode(HttpStatusCode.Created));
}
else
{
//No se pudo crear el recurso por un error interno code 500
return(InternalServerError());
}
}
public IHttpActionResult GetWorkedHours(int id)
{
if (!worked_Hours_Logic.existWorkedHours(id))
{
//No se encontró el recurso code 404
return(NotFound());
}
Worked_Hours_Data wh = worked_Hours_Logic.GetWorkedHours(id);
if (wh != null)
{
// ok code 200
return(Ok(wh));
}
else
{
//No se pudo crear el recurso por un error interno code 500
return(InternalServerError());
}
}
public bool updateWorkedHours(Worked_Hours_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var wh = construyeEntities.Worked_hours.Find(data.id);
wh.id = data.id;
wh.id_employee = data.id_employee;
wh.id_project = data.id_project;
wh.hours = data.hours;
wh.date = data.date;
wh.Project = construyeEntities.Projects.Find(data.id_project);
wh.Employee = construyeEntities.Employees.Find(data.id_employee);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public IHttpActionResult updateWorkedHours([FromBody] Worked_Hours_Data data)
{
if (data == null)
{
//Bad request code 400
return(BadRequest());
}
if (!worked_Hours_Logic.existWorkedHours(data.id))
{
//petición correcta pero no pudo ser procesada porque no existe el archivo code 404
return(NotFound());
}
if (worked_Hours_Logic.updateWorkedHours(data))
{
//petición correcta y se ha creado un nuevo recurso code 200 ok
return(Ok());
}
else
{
//No se pudo crear el recurso por un error code 500
return(InternalServerError());
}
}
public List <Object> GetListWorkedHours()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var whList = construyeEntities.Worked_hours.ToList();
int n = whList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < whList.Count; ++i)
{
Worked_Hours_Data data = new Worked_Hours_Data();
data.id = whList.ElementAt(i).id;
data.id_employee = whList.ElementAt(i).id_employee;
data.id_project = whList.ElementAt(i).id_project;
data.hours = whList.ElementAt(i).hours;
data.date = whList.ElementAt(i).date;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
