public IHttpActionResult GetViewStatusLocomotive()
{
try
{
EFTabRepairs ef_trep = new EFTabRepairs(new EFDbContext());
string sql = "select * from [dbo].[get_last_wms]() order by idNumLoko";
List <view_status_lokomotive> list = ef_trep.Database.SqlQuery <view_status_lokomotive>(sql).ToList();
return(Ok(list));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public int PutCloseTabRepairs(int id)
{
try
{
EFTabRepairs ef_trep = new EFTabRepairs(new EFDbContext());
TabRepairs value = ef_trep.Context.Where(r => r.idRepair == id).FirstOrDefault();
value.DateTimeEndRepair = DateTime.Now;
ef_trep.Update(value);
return(ef_trep.Save());
}
catch (Exception e)
{
return(-1);
}
}
public IHttpActionResult GetTabRepairs()
{
try
{
EFTabRepairs ef_trep = new EFTabRepairs(new EFDbContext());
List <TabRepairs> list = ef_trep
.Context
.ToList()
.Select(m => m.GetTabRepairs())
.ToList();
return(Ok(list));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public int PutOpenTabRepairs(int id)
{
try
{
EFTabRepairs ef_trep = new EFTabRepairs(new EFDbContext());
TabRepairs value = new TabRepairs()
{
idRepair = 0,
IDNumLoko = id,
DateTimeStartRepair = DateTime.Now,
DateTimeEndRepair = null
};
ef_trep.Add(value);
return(ef_trep.Save());
}
catch (Exception e)
{
return(-1);
}
}
