public void TestDuplicateInspectionInspectorLogic()
{
using (var context = InitAndGetDbContext())
{
//Arrange
var repositori = new InspectionRepository(context);
Inspector Inspector1 = new Inspector()
{
Id = Guid.NewGuid(), Name = "Inspector 1", Created = DateTime.Today
};
Inspection Inspection1 = new Inspection()
{
Id = Guid.NewGuid(),
Customer = "Customer 1",
Address = "Address 1",
Observations = "Observation 1",
Status = Status.Done,
Created = DateTime.Today
};
InspectionInspector relation1 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(-1), InspectionId = Inspection1.Id, InspectorId = Inspector1.Id
};
Inspection1.InspectionInspector = new List <InspectionInspector>()
{
relation1
};
repositori.Create(Inspection1);
context.SaveChanges();
InspectorDTO inspectorDTO = new InspectorDTO()
{
Id = Inspector1.Id, Name = "Inspector 1"
};
InspectionDTO InspectionDTO = new InspectionDTO()
{
Id = Inspection1.Id,
Customer = "Customer 1",
Address = "Address 1",
Observations = "Observation 1",
status = Status.Done,
InspectionDate = relation1.InspectionDate,
Inspectors = new List <InspectorDTO>()
{
inspectorDTO
}
};
//Act
Inspection found = repositori.GetSingleEagerAsync(o => o.Id == InspectionDTO.Id &&
o.InspectionInspector.Any(ii => ii.InspectionDate == InspectionDTO.InspectionDate) &&
o.InspectionInspector.Any(ii => InspectionDTO.Inspectors.Any(i => i.Id == ii.InspectorId))).Result;
//Assert
Assert.NotNull(found);
}
}
private void Save()
{
var iiList = new List <InspectionInspector>();
foreach (var e in SelectedInspectors)
{
var ii = new InspectionInspector
{
Employee = _userRepository.Find(e.ID),
Inspection = _inspectionRepository.Find(_inspection.ID),
LastUpdated = DateTime.Now
};
e.InspectionInspectors.Add(ii);
_userRepository.Update(e);
iiList.Add(ii);
}
_inspection.InspectionInspectors = iiList;
_inspectionRepository.Update(_inspection);
MessageBox.Show("De wijzigingen zijn opgeslagen!");
_router.GoBack();
}
public void ShouldCreateWithInspectorInspector()
{
using (var context = InitAndGetDbContext())
{
//Arrange
var repositori = new InspectorRepository(context);
Inspector Inspector1 = new Inspector()
{
Name = "Inspector 1", Created = DateTime.Today
};
Inspection Inspection1 = new Inspection()
{
Customer = "Customer 1",
Address = "Address 1",
Observations = "Observation 1",
Status = Status.Done,
Created = DateTime.Today
};
InspectionInspector relation1 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(-1), InspectionId = Inspection1.Id, InspectorId = Inspector1.Id
};
Inspector1.InspectionInspector = new List <InspectionInspector>()
{
relation1
};
//Act
repositori.Create(Inspector1);
Inspector result = repositori.Find(Inspector1.Id);
//Assert
Assert.NotNull(result);
}
}
public static void Initialize(CotecnaEFContext context)
{
if (!context.Inspection.Any() && !context.Inspector.Any())
{
#region Inspector
Inspector Inspector1 = new Inspector()
{
Name = "Inspector 1", Created = DateTime.Today
};
Inspector Inspector2 = new Inspector()
{
Name = "Inspector 2", Created = DateTime.Today
};
Inspector Inspector3 = new Inspector()
{
Name = "Inspector 3", Created = DateTime.Today
};
context.Inspector.AddRange(
Inspector1,
Inspector2,
Inspector3
);
#endregion Inspector
#region Inspection
Inspection Inspection1 = new Inspection()
{
Customer = "Customer 1",
Address = "Address 1",
Observations = "Observation 1",
Status = Status.Done,
Created = DateTime.Today
};
InspectionInspector relation1 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(-1), InspectionId = Inspection1.Id, InspectorId = Inspector1.Id
};
InspectionInspector relation2 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(-1), InspectionId = Inspection1.Id, InspectorId = Inspector2.Id
};
Inspection1.InspectionInspector = new List <InspectionInspector>()
{
relation1,
relation2
};
Inspection Inspection2 = new Inspection()
{
Customer = "Customer 2",
Address = "Address 2",
Observations = "Observation 2",
Status = Status.InProgress,
Created = DateTime.Today
};
InspectionInspector relation3 = new InspectionInspector()
{
InspectionDate = DateTime.Today, InspectionId = Inspection2.Id, InspectorId = Inspector2.Id
};
InspectionInspector relation4 = new InspectionInspector()
{
InspectionDate = DateTime.Today, InspectionId = Inspection2.Id, InspectorId = Inspector3.Id
};
Inspection2.InspectionInspector = new List <InspectionInspector>()
{
relation3,
relation4
};
Inspection Inspection3 = new Inspection()
{
Customer = "Customer 3",
Address = "Address 3",
Observations = "Observation 3",
Status = Status.New,
Created = DateTime.Today
};
InspectionInspector relation5 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(2), InspectionId = Inspection3.Id, InspectorId = Inspector1.Id
};
InspectionInspector relation6 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(2), InspectionId = Inspection3.Id, InspectorId = Inspector3.Id
};
Inspection3.InspectionInspector = new List <InspectionInspector>()
{
relation5,
relation6
};
Inspection Inspection4 = new Inspection()
{
Customer = "Customer 4",
Address = "Address 4",
Observations = "Observation 4",
Status = Status.New,
Created = DateTime.Today
};
InspectionInspector relation7 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(2), InspectionId = Inspection4.Id, InspectorId = Inspector2.Id
};
InspectionInspector relation8 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(2), InspectionId = Inspection4.Id, InspectorId = Inspector3.Id
};
Inspection4.InspectionInspector = new List <InspectionInspector>()
{
relation7,
relation8
};
Inspection Inspection5 = new Inspection()
{
Customer = "Customer 5",
Address = "Address 5",
Observations = "Observation 5",
Status = Status.New,
Created = DateTime.Today
};
InspectionInspector relation9 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(2), InspectionId = Inspection5.Id, InspectorId = Inspector2.Id
};
InspectionInspector relation0 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(2), InspectionId = Inspection5.Id, InspectorId = Inspector3.Id
};
Inspection5.InspectionInspector = new List <InspectionInspector>()
{
relation9,
relation0
};
context.Inspection.AddRange(
Inspection1,
Inspection2,
Inspection3,
Inspection4,
Inspection5
);
#endregion Inspection
context.SaveChanges();
}
}
public IEnumerable <Inspection> GetInspectionsWithInspectors()
{
IEnumerable <Inspector> inspectors = GetInspectors();
Inspection Inspection1 = new Inspection()
{
Customer = "Customer 1",
Address = "Address 1",
Observations = "Observation 1",
Status = Status.Done,
Created = DateTime.Today
};
InspectionInspector relation1 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(-1), InspectionId = Inspection1.Id, InspectorId = inspectors.ElementAt(0).Id
};
InspectionInspector relation2 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(-1), InspectionId = Inspection1.Id, InspectorId = inspectors.ElementAt(1).Id
};
Inspection1.InspectionInspector = new List <InspectionInspector>()
{
relation1,
relation2
};
Inspection Inspection2 = new Inspection()
{
Customer = "Customer 2",
Address = "Address 2",
Observations = "Observation 2",
Status = Status.InProgress,
Created = DateTime.Today
};
InspectionInspector relation3 = new InspectionInspector()
{
InspectionDate = DateTime.Today, InspectionId = Inspection2.Id, InspectorId = inspectors.ElementAt(1).Id
};
InspectionInspector relation4 = new InspectionInspector()
{
InspectionDate = DateTime.Today, InspectionId = Inspection2.Id, InspectorId = inspectors.ElementAt(2).Id
};
Inspection2.InspectionInspector = new List <InspectionInspector>()
{
relation3,
relation4
};
Inspection Inspection3 = new Inspection()
{
Customer = "Customer 3",
Address = "Address 3",
Observations = "Observation 3",
Status = Status.New,
Created = DateTime.Today
};
InspectionInspector relation5 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(2), InspectionId = Inspection3.Id, InspectorId = inspectors.ElementAt(0).Id
};
InspectionInspector relation6 = new InspectionInspector()
{
InspectionDate = DateTime.Today.AddDays(2), InspectionId = Inspection3.Id, InspectorId = inspectors.ElementAt(2).Id
};
Inspection3.InspectionInspector = new List <InspectionInspector>()
{
relation5,
relation6
};
return(new List <Inspection>()
{
Inspection1, Inspection2, Inspection3
});
}
