public AppUser ReadUser(string userId) { using (var context = new HomeDrawDbContext()) { return(context.Users.Find(userId)); } }
public Dictionary <int, Queue <string> > CreateRooms() { Dictionary <int, Queue <string> > Rooms = new Dictionary <int, Queue <string> >(); using (var context = new HomeDrawDbContext()) { var drawings = (from p in context.Drawings select p); foreach (Drawing drawing in drawings) { Queue <string> queue = new Queue <string>(); queue.Enqueue(drawing.MasterID); //foreach (AppUser user in drawing.JoinedUsers) //{ // queue.Enqueue(user.Id); //} Rooms.Add(drawing.DrawingID, queue); } } return(Rooms); }
public int CreateDrawing(DrawingDTO drawingDTO) { using (var context = new HomeDrawDbContext()) { int returnedId = 0; try { Drawing drawing = new Drawing() { DrawingID = drawingDTO.DrawingID, Name = drawingDTO.Name, Password = drawingDTO.Password, MasterID = drawingDTO.MasterID }; context.Drawings.Add(drawing); context.SaveChanges(); returnedId = drawing.DrawingID; } catch (Exception e) { Console.WriteLine(e.Message); } return(returnedId); } }
public DrawingObjectDTO ReadDrawingObject(int drawingObjectId) { using (var context = new HomeDrawDbContext()) { DrawingObjectDTO drawingObjectDTO = null; try { var foundDrawingObject = context.DrawingObjects.Find(drawingObjectId); drawingObjectDTO = new DrawingObjectDTO() { DrawingID = foundDrawingObject.DrawingID, DrawingObjectID = foundDrawingObject.DrawingObjectID, DrawingObjectType = foundDrawingObject.DrawingObjectType, PositionLeft = foundDrawingObject.PositionLeft, PositionTop = foundDrawingObject.PositionTop }; } catch (Exception e) { Console.WriteLine(e.Message); } return(drawingObjectDTO); } }
public int CreateDrawingObject(DrawingObjectDTO drawingObjectDTO) { using (var context = new HomeDrawDbContext()) { int returnedId = 0; try { DrawingObject newDrawingObject = new DrawingObject() { DrawingID = drawingObjectDTO.DrawingID, DrawingObjectType = drawingObjectDTO.DrawingObjectType, PositionLeft = drawingObjectDTO.PositionLeft, PositionTop = drawingObjectDTO.PositionTop }; context.DrawingObjects.Add(newDrawingObject); context.SaveChanges(); returnedId = newDrawingObject.DrawingObjectID; } catch (Exception e) { Console.WriteLine(e.Message); } return(returnedId); } }
public IEnumerable <DrawingObjectDTO> GetAllDrawingObjects() { using (var context = new HomeDrawDbContext()) { List <DrawingObjectDTO> foundDrawingObjectsDTO = new List <DrawingObjectDTO>(); try { var foundDrawingObjects = context.DrawingObjects.ToList(); foreach (var drawingObject in foundDrawingObjects) { DrawingObjectDTO newDrawingObjectDTO = null; newDrawingObjectDTO = new DrawingObjectDTO() { DrawingID = drawingObject.DrawingID, DrawingObjectID = drawingObject.DrawingObjectID, DrawingObjectType = drawingObject.DrawingObjectType, PositionLeft = drawingObject.PositionLeft, PositionTop = drawingObject.PositionTop }; foundDrawingObjectsDTO.Add(newDrawingObjectDTO); } } catch (Exception e) { Console.WriteLine(e.Message); } return(foundDrawingObjectsDTO); } }
public void UpdateUser(AppUser user) { using (var context = new HomeDrawDbContext()) { context.Entry(user).State = EntityState.Modified; context.SaveChanges(); } }
public AppUser ReadUserByLastConnectionId(string connectionId) { using (var context = new HomeDrawDbContext()) { var user = context.Users.Where(u => u.LastConnectionIdentification == connectionId).SingleOrDefault(); return(user); } }
public void DeleteDrawing(int drawingId) { using (var context = new HomeDrawDbContext()) { var drawingToDelete = context.Drawings.Find(drawingId); context.Drawings.Remove(drawingToDelete); context.SaveChanges(); } }
public IEnumerable <DrawingDTO> GetAllDrawings() { using (var context = new HomeDrawDbContext()) { List <DrawingDTO> foundDrawingsDTO = new List <DrawingDTO>(); try { List <Drawing> foundDrawings = context.Drawings.Include(dr => dr.DrawingObjects).ToList(); foreach (var drawing in foundDrawings) { DrawingDTO newDrawingDTO = null; newDrawingDTO = new DrawingDTO() { DrawingID = drawing.DrawingID, Name = drawing.Name, Password = drawing.Password, MasterID = drawing.MasterID, }; foreach (var drawingObject in drawing.DrawingObjects) { DrawingObjectDTO newDrawingObjectDTO = null; newDrawingObjectDTO = new DrawingObjectDTO() { DrawingID = drawingObject.DrawingID, DrawingObjectID = drawingObject.DrawingObjectID, DrawingObjectType = drawingObject.DrawingObjectType, PositionLeft = drawingObject.PositionLeft, PositionTop = drawingObject.PositionTop }; newDrawingDTO.DrawingObjects.Add(newDrawingObjectDTO); } foundDrawingsDTO.Add(newDrawingDTO); } } catch (Exception e) { Console.WriteLine(e.Message); } return(foundDrawingsDTO); } }
public DrawingDTO ReadDrawingByName(string drawingName) { using (var context = new HomeDrawDbContext()) { DrawingDTO drawingDto = null; try { var foundDrawing = context.Drawings.Where(d => d.Name == drawingName).Include(dro => dro.DrawingObjects).FirstOrDefault(); drawingDto = new DrawingDTO() { DrawingID = foundDrawing.DrawingID, Name = foundDrawing.Name, Password = foundDrawing.Password, MasterID = foundDrawing.MasterID, }; drawingDto.DrawingObjects = new List <DrawingObjectDTO>(); foreach (var drawingObject in foundDrawing.DrawingObjects) { DrawingObjectDTO drawingObjectDTO = null; drawingObjectDTO = new DrawingObjectDTO() { DrawingID = drawingObject.DrawingID, DrawingObjectID = drawingObject.DrawingObjectID, DrawingObjectType = drawingObject.DrawingObjectType, PositionLeft = drawingObject.PositionLeft, PositionTop = drawingObject.PositionTop }; drawingDto.DrawingObjects.Add(drawingObjectDTO); } } catch (Exception e) { Console.WriteLine(e.Message); } return(drawingDto); } }
public void UpdateDrawingObject(DrawingObjectDTO drawingObjectDTO) { using (var context = new HomeDrawDbContext()) { try { var foundDrawingObject = context.DrawingObjects.Where(d => d.DrawingObjectID == drawingObjectDTO.DrawingObjectID).FirstOrDefault(); foundDrawingObject.DrawingID = drawingObjectDTO.DrawingID; foundDrawingObject.DrawingObjectID = drawingObjectDTO.DrawingObjectID; foundDrawingObject.DrawingObjectType = drawingObjectDTO.DrawingObjectType; foundDrawingObject.PositionLeft = drawingObjectDTO.PositionLeft; foundDrawingObject.PositionTop = drawingObjectDTO.PositionTop; context.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.Message); } } }
public void UpdateDrawing(DrawingDTO drawingDTO) { using (var context = new HomeDrawDbContext()) { try { var foundDrawing = context.Drawings.Where(d => d.DrawingID == drawingDTO.DrawingID).Include(dro => dro.DrawingObjects).FirstOrDefault(); foundDrawing.Name = drawingDTO.Name; foundDrawing.Password = drawingDTO.Password; foundDrawing.MasterID = drawingDTO.MasterID; foundDrawing.DrawingObjects.Clear(); foreach (DrawingObjectDTO drawingObjectDTO in drawingDTO.DrawingObjects) { var existingDrawingObject = context.DrawingObjects.SingleOrDefault(dro => dro.DrawingObjectID == drawingObjectDTO.DrawingObjectID) ?? context.DrawingObjects.Add(new DrawingObject { DrawingID = drawingObjectDTO.DrawingID, DrawingObjectType = drawingObjectDTO.DrawingObjectType, DrawingObjectID = drawingObjectDTO.DrawingObjectID, PositionLeft = drawingObjectDTO.PositionLeft, PositionTop = drawingObjectDTO.PositionTop }); foundDrawing.DrawingObjects.Add(existingDrawingObject); } context.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.Message); } } }