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); } }