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