public static void Update(DrawerDTO updateDrawer)
{
try
{
databaseDataContext db = new databaseDataContext();
var find =
(from drawer in db.Drawers
where drawer.Id == updateDrawer.Id
select drawer).Single();
find.BoxId = updateDrawer.BoxId;
find.Width = updateDrawer.Width;
find.Height = updateDrawer.Height;
find.Depth = updateDrawer.Depth;
find.BoardThickness = updateDrawer.BoardThickness;
find.PositionX = updateDrawer.PositionX;
find.PositionY = updateDrawer.PositionY;
find.PositionZ = updateDrawer.PositionZ;
find.Name = updateDrawer.Name;
find.Texture = updateDrawer.Texture;
find.pregrada = updateDrawer.pregrada;
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public static int Create(DrawerDTO drawerCreate)
{
try
{
databaseDataContext db = new databaseDataContext();
Drawer drawer = new Drawer()
{
BoxId = drawerCreate.BoxId,
Width = drawerCreate.Width,
Height = drawerCreate.Height,
Depth = drawerCreate.Depth,
BoardThickness = drawerCreate.BoardThickness,
PositionX = drawerCreate.PositionX,
PositionY = drawerCreate.PositionY,
PositionZ = drawerCreate.PositionZ,
Name = drawerCreate.Name,
Texture = drawerCreate.Texture,
pregrada = drawerCreate.pregrada
};
db.Drawers.InsertOnSubmit(drawer);
db.SubmitChanges();
return(drawer.Id);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(-1);
}
public static List <DrawerDTO> DrawersInBox(int boxId)
{
List <DrawerDTO> drawers = new List <DrawerDTO>();
try
{
databaseDataContext db = new databaseDataContext();
var find =
(from drawer in db.Drawers
where drawer.BoxId == boxId
select drawer);
foreach (var d in find)
{
DrawerDTO drawerRead = new DrawerDTO()
{
Id = d.Id,
BoxId = d.BoxId,
Width = d.Width,
Height = d.Height,
Depth = d.Depth,
BoardThickness = d.BoardThickness,
PositionX = d.PositionX,
PositionY = d.PositionY,
PositionZ = d.PositionZ,
Name = d.Name,
Texture = d.Texture,
pregrada = d.pregrada
};
drawers.Add(drawerRead);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(drawers);
}
public static DrawerDTO Read(int drawerId)
{
DrawerDTO drawerRead = null;
try
{
databaseDataContext db = new databaseDataContext();
var find =
(from drawer in db.Drawers
where drawer.Id == drawerId
select drawer).Single();
drawerRead = new DrawerDTO()
{
Id = find.Id,
BoxId = find.BoxId,
Width = find.Width,
Height = find.Height,
Depth = find.Depth,
BoardThickness = find.BoardThickness,
PositionX = find.PositionX,
PositionY = find.PositionY,
PositionZ = find.PositionZ,
Name = find.Name,
Texture = find.Texture,
pregrada = find.pregrada
};
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(drawerRead);
}
public void SaveConfiguration(string ArrayOfObjects, int planId)
{
//List<ObjectDTO> objects = (List<ObjectDTO>)JsonSerializer.DeserializeFromString(ArrayOfObjects, typeof(List<ObjectDTO>));
ObjectDTO o = (ObjectDTO)JsonSerializer.DeserializeFromString(ArrayOfObjects, typeof(ObjectDTO));
//foreach (ObjectDTO o in objects)
//{
//}
BoxDTO box = new BoxDTO()
{
PlanId = planId,
Width = o.Width,
Height = o.Height,
Depth = o.Depth,
BoardThickness = o.BoardThickness,
PositionX = o.PositionX,
PositionY = o.PositionY,
PositionZ = o.PositionZ,
Name = o.Name,
Texture = o.Texture,
vertikalno = o.vertikalno,
horizontalno = o.horizontalno,
globalX = o.globalX,
globalY = o.globalY,
globalZ = o.globalZ
};
int boxId = Boxs.Create(box);
foreach (BoardDTO b in o.childs)
{
BoardDTO board = new BoardDTO()
{
BoxId = boxId,
Width = b.Width,
Height = b.Height,
Depth = b.Depth,
BoardThickness = b.BoardThickness,
PositionX = b.PositionX,
PositionY = b.PositionY,
PositionZ = b.PositionZ,
Name = b.Name,
Texture = b.Texture
};
int boardId = Boards.Create(board);
}
List <int> pozicije = new List <int>();
if (o.pozicije_fioka != null)
{
for (int i = 0; i < o.childs.Count + 1; i++)
{
if (o.pozicije_fioka[i] == true)
{
pozicije.Add(i);
}
}
}
int k = 0;
foreach (DrawerDTO d in o.nizFioka)
{
DrawerDTO drawer = new DrawerDTO()
{
BoxId = boxId,
Width = d.Width,
Height = d.Height,
Depth = d.Depth,
BoardThickness = d.BoardThickness,
PositionX = d.PositionX,
PositionY = d.PositionY,
PositionZ = d.PositionZ,
Name = d.Name,
Texture = d.Texture,
pregrada = pozicije[k]
};
int drawerId = Drawers.Create(drawer);
k++;
}
pozicije = new List <int>();
if (o.pozicije_vrata != null)
{
for (int i = 0; i < o.childs.Count + 1; i++)
{
if (o.pozicije_vrata[i] == true)
{
pozicije.Add(i);
}
}
}
k = 0;
foreach (DoorDTO d in o.nizVrata)
{
DoorDTO door = new DoorDTO()
{
BoxId = boxId,
Width = d.Width,
Height = d.Height,
Depth = d.Depth,
PositionX = d.PositionX,
PositionY = d.PositionY,
PositionZ = d.PositionZ,
Name = d.Name,
Texture = d.Texture,
pregrada = pozicije[k]
};
int doorId = Doors.Create(door);
k++;
}
}
