public JsonResult DeleteRoomInConstruction(ParemetersRoom paremetersRoom, ParemetersRange paremetersRange) { Room room = ApplicationContext.Rooms.AsNoTracking().FirstOrDefault(x => x.Id == paremetersRoom.RoomId); if (room != null && room.Id == paremetersRoom.RoomId) { ApplicationContext.Rooms.Remove(room); ApplicationContext.SaveChanges(); } return(GetRoomsInConstruction(paremetersRoom, paremetersRange)); }
public JsonResult DeleteMachineInRoom(ParemetersMachine paremetersMachine, ParemetersRange paremetersRange) { Machine machine = ApplicationContext.Machines.FirstOrDefault(x => x.Id == paremetersMachine.MachineId); if (machine != null && machine.Id == paremetersMachine.MachineId) { ApplicationContext.Machines.Remove(machine); ApplicationContext.SaveChanges(); } return(GetMachinesInRoom(paremetersMachine, paremetersRange)); }
public JsonResult GetMachinesInConstruction(int constructionId, ParemetersRange paremetersRange) { var rooms = ApplicationContext.Rooms.AsNoTracking().Where(x => x.ConstructionId == constructionId).Include(x => x.Machines).ToList(); List <Machine> machines = new List <Machine>(); foreach (var room in rooms) { machines = machines.Concat(room.Machines).ToList(); } var machinesShort = machines.Skip(paremetersRange.Skip).Take(paremetersRange.Take).AsQueryable(); return(Json(machinesShort)); }
public JsonResult EditMachineInRoom(ParemetersMachine paremetersMachine, ParemetersRange paremetersRange) { Machine machine = ApplicationContext.Machines.FirstOrDefault(x => x.Id == paremetersMachine.MachineId); if (machine != null && machine.Id == paremetersMachine.MachineId) { machine.Name = paremetersMachine.Name; machine.CreateYear = paremetersMachine.CreateYear; ApplicationContext.Machines.Update(machine); ApplicationContext.SaveChanges(); } return(GetMachinesInRoom(paremetersMachine, paremetersRange)); }
public JsonResult AddMachineInRoom(ParemetersMachine paremetersMachine, ParemetersRange paremetersRange) { Machine machine = new Machine { Name = paremetersMachine.Name, CreateYear = paremetersMachine.CreateYear, RoomId = paremetersMachine.RoomId }; ApplicationContext.Machines.Add(machine); ApplicationContext.SaveChanges(); return(GetMachinesInRoom(paremetersMachine, paremetersRange)); }
public JsonResult EditRoomInConstruction(ParemetersRoom paremetersRoom, ParemetersRange paremetersRange) { Room room = ApplicationContext.Rooms.AsNoTracking().FirstOrDefault(x => x.Id == paremetersRoom.RoomId); if (room != null && room.Id == paremetersRoom.RoomId) { room.Name = paremetersRoom.Name; room.Floor = paremetersRoom.Floor; ApplicationContext.Rooms.Update(room); ApplicationContext.SaveChanges(); } return(GetRoomsInConstruction(paremetersRoom, paremetersRange)); }
public JsonResult AddRoomInConstruction(ParemetersRoom paremetersRoom, ParemetersRange paremetersRange) { Room room = new Room { Name = paremetersRoom.Name, Floor = paremetersRoom.Floor, ConstructionId = paremetersRoom.ConstructionId }; ApplicationContext.Rooms.Add(room); ApplicationContext.SaveChanges(); return(GetRoomsInConstruction(paremetersRoom, paremetersRange)); }
//Rooms public JsonResult GetRoomsInConstruction(ParemetersRoom paremetersRoom, ParemetersRange paremetersRange) { var rooms = ApplicationContext.Rooms.AsNoTracking().Where(x => x.ConstructionId == paremetersRoom.ConstructionId).Include(x => x.Machines) .Select(x => new { id = x.Id, name = x.Name, floor = x.Floor, constructionId = x.ConstructionId, haveMachine = x.Machines.Any() }).Skip(paremetersRange.Skip).Take(paremetersRange.Take); return(Json(rooms)); }
public JsonResult GetConstructions(ParemetersRange paremetersRange) { var constructions = ApplicationContext.Constructions.AsNoTracking().Include(x => x.Rooms) .Select(x => new { id = x.Id, name = x.Name, address = x.Address, haveMachine = x.Rooms .SelectMany(y => y.Machines) .Any() }).Skip(paremetersRange.Skip).Take(paremetersRange.Take); return(Json(constructions)); }
public JsonResult EditConstruction(ParemetersConstruction paremetersConstruction, ParemetersRange paremetersRange) { Construction construction = ApplicationContext.Constructions.FirstOrDefault(x => x.Id == paremetersConstruction.ConstructionId); if (construction != null && construction.Id == paremetersConstruction.ConstructionId) { construction.Name = paremetersConstruction.Name; construction.Address = paremetersConstruction.Address; ApplicationContext.Constructions.Update(construction); ApplicationContext.SaveChanges(); } return(GetConstructions(paremetersRange)); }
public JsonResult DeleteConstruction(ParemetersConstruction paremetersConstruction, ParemetersRange paremetersRange) { Construction construction = ApplicationContext.Constructions.FirstOrDefault(x => x.Id == paremetersConstruction.ConstructionId); if (construction != null && construction.Id == paremetersConstruction.ConstructionId) { ApplicationContext.Constructions.Remove(construction); ApplicationContext.SaveChanges(); } return(GetConstructions(paremetersRange)); }
public JsonResult AddConstruction(ParemetersConstruction paremetersConstruction, ParemetersRange paremetersRange) { Construction construction = new Construction { Name = paremetersConstruction.Name, Address = paremetersConstruction.Address }; ApplicationContext.Constructions.Add(construction); ApplicationContext.SaveChanges(); return(GetConstructions(paremetersRange)); }
public JsonResult GetMachinesInRoom(ParemetersMachine paremetersMachine, ParemetersRange paremetersRange) { var machines = ApplicationContext.Machines.AsNoTracking().Where(x => x.RoomId == paremetersMachine.RoomId).Skip(paremetersRange.Skip).Take(paremetersRange.Take); return(Json(machines)); }