public static DoorDTO Read(int doorId)
{
DoorDTO doorRead = null;
try
{
databaseDataContext db = new databaseDataContext();
var find =
(from door in db.Doors
where door.Id == doorId
select door).Single();
doorRead = new DoorDTO()
{
Id = find.Id,
BoxId = find.BoxId,
Width = find.Width,
Height = find.Height,
Depth = find.Depth,
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(doorRead);
}
public static void Update(DoorDTO updateDoor)
{
try
{
databaseDataContext db = new databaseDataContext();
var find =
(from door in db.Doors
where door.Id == updateDoor.Id
select door).Single();
find.BoxId = updateDoor.BoxId;
find.Width = updateDoor.Width;
find.Height = updateDoor.Height;
find.Depth = updateDoor.Depth;
find.PositionX = updateDoor.PositionX;
find.PositionY = updateDoor.PositionY;
find.PositionZ = updateDoor.PositionZ;
find.Name = updateDoor.Name;
find.Texture = updateDoor.Texture;
find.pregrada = updateDoor.pregrada;
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public static int Create(DoorDTO doorCreate)
{
try
{
databaseDataContext db = new databaseDataContext();
Door door = new Door()
{
BoxId = doorCreate.BoxId,
Width = doorCreate.Width,
Height = doorCreate.Height,
Depth = doorCreate.Depth,
PositionX = doorCreate.PositionX,
PositionY = doorCreate.PositionY,
PositionZ = doorCreate.PositionZ,
Name = doorCreate.Name,
Texture = doorCreate.Texture,
pregrada = doorCreate.pregrada
};
db.Doors.InsertOnSubmit(door);
db.SubmitChanges();
return(door.Id);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(-1);
}
public void TestInitialize()
{
Mapper.CreateMap <Door, DoorDTO>();
Door d1 = new Door {
Id = 1, Make = "Test1", Model = "door"
};
Door d2 = new Door {
Id = 2, Make = "findme", Model = "door"
};
doors = new List <Door>();
doors.Add(d1);
doors.Add(d2);
DoorDTO dto1 = new DoorDTO {
Id = 1, Make = "findme", Model = "door"
};
DoorDTO dto2 = new DoorDTO {
Id = 2, Make = "Test2", Model = "DTO"
};
doorsDTO = new List <DoorDTO>();
doorsDTO.Add(dto1);
doorsDTO.Add(dto2);
filter = "FindMe";
}
public void PutShouldInsertItemAndReturnCorrectStatus()
{
//Arrange
var _doorrepo = new Mock <IEntityBaseRepository <Door> >();
_doorrepo.Setup(x => x.GetAll()).Returns(doors.AsQueryable());
var _errorrepo = new Mock <IEntityBaseRepository <Error> >();
var _uow = new Mock <IUnitOfWork>();
var AutoMapperMock = new Mock <IMapper>();
var config = new HttpConfiguration();
var request = new HttpRequestMessage(HttpMethod.Get, "http://localhost/api/door/");
var route = config.Routes.MapHttpRoute("DefaultApi", "api/{controller}/{id}");
var routeData = new HttpRouteData(route, new HttpRouteValueDictionary {
{ "controller", "door" }
});
var controller = new DoorController(_doorrepo.Object, _errorrepo.Object, _uow.Object);
controller.ControllerContext = new HttpControllerContext(config, routeData, request);
controller.Request = request;
controller.Request.Properties[HttpPropertyKeys.HttpConfigurationKey] = config;
DoorDTO newDoor = new DoorDTO {
Id = 2, Make = "NewDoor"
};
//Act
var _response = controller.Put(request, newDoor);
// Assert
Assert.AreEqual(_response.StatusCode, HttpStatusCode.Created);
}
public HttpResponseMessage Put(HttpRequestMessage request, DoorDTO doordto)
{
Door newDoor;
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response = null;
if (!ModelState.IsValid)
{
response = request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
else
{
newDoor = new Door(doordto.Id, doordto.Make, doordto.Model, doordto.YearOfManufacture, doordto.DateOfInstallation, doordto.NoOfWarrantyYears);
_DoorRepository.Add(newDoor);
_UnitOfWork.Commit();
doordto = Mapper.Map <Door, DoorDTO>(newDoor);
response = request.CreateResponse <DoorDTO>(HttpStatusCode.Created, doordto);
}
return response;
}));
}
public static void UpdateDoor(this Door door, DoorDTO doordto)
{
door.Id = doordto.Id;
door.Make = doordto.Make;
door.Model = doordto.Model;
door.NoOfWarrantyYears = doordto.NoOfWarrantyYears;
door.YearOfManufacture = doordto.YearOfManufacture;
door.DateOfInstallation = doordto.DateOfInstallation;
}
public static List <DoorDTO> DoorsInBox(int boxId)
{
List <DoorDTO> doors = new List <DoorDTO>();
try
{
databaseDataContext db = new databaseDataContext();
var find =
(from door in db.Doors
where door.BoxId == boxId
select door);
foreach (var d in find)
{
DoorDTO doorRead = new DoorDTO()
{
Id = d.Id,
BoxId = d.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 = d.pregrada
};
doors.Add(doorRead);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(doors);
}
public void UpdateShouldFunctionAndReturnStatusCodeOK()
{
//Arrange
var _doorrepo = new Mock <IEntityBaseRepository <Door> >();
_doorrepo.Setup(x => x.GetSingle(1)).Returns(new Door {
});
var _errorrepo = new Mock <IEntityBaseRepository <Error> >();
var _uow = new Mock <IUnitOfWork>();
var AutoMapperMock = new Mock <IMapper>();
var config = new HttpConfiguration();
var request = new HttpRequestMessage(HttpMethod.Get, "http://localhost/api/door/");
var route = config.Routes.MapHttpRoute("DefaultApi", "api/{controller}/{id}");
var routeData = new HttpRouteData(route, new HttpRouteValueDictionary {
{ "controller", "door" }
});
var controller = new DoorController(_doorrepo.Object, _errorrepo.Object, _uow.Object);
controller.ControllerContext = new HttpControllerContext(config, routeData, request);
controller.Request = request;
controller.Request.Properties[HttpPropertyKeys.HttpConfigurationKey] = config;
DoorDTO newDoor = new DoorDTO {
Id = 2, Make = "NewDoor"
};
DoorDTO updatedoor = doorsDTO.First();
updatedoor.Make = "Updated";
//Act
var _response = controller.Update(request, updatedoor);
// Assert
Assert.AreEqual(_response.StatusCode, HttpStatusCode.OK);
}
public HttpResponseMessage Update(HttpRequestMessage request, DoorDTO doordto)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response = null;
if (!ModelState.IsValid)
{
response = request.CreateResponse(HttpStatusCode.BadRequest,
ModelState.Keys.SelectMany(k => ModelState[k].Errors)
.Select(m => m.ErrorMessage).ToArray());
}
else
{
Door foundDoor = _DoorRepository.GetSingle(doordto.Id);
foundDoor.UpdateDoor(doordto);
_DoorRepository.Edit(foundDoor);
_UnitOfWork.Commit();
response = request.CreateResponse(HttpStatusCode.OK);
}
return response;
}));
}
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++;
}
}
