public void DeleteSection(IList sectionModel)
{
var sectionDB = new SectionsEntities();
foreach (object item in sectionModel)
{
var testModel = (TestModel) item;
IQueryable<Test> testsToDel = from test in sectionDB.Test
where test.MasterAgentIP == testModel.MasterAgentIp
select test;
IQueryable<Opinion> opinionToDel = from op in sectionDB.Opinion
where op.MasterAgentIp == testModel.MasterAgentIp
select op;
foreach (Opinion op in opinionToDel)
{
sectionDB.DeleteObject(op);
}
foreach (Test test in testsToDel)
{
sectionDB.DeleteObject(test);
}
sectionDB.SaveChanges();
}
}
public void InsertSyndromModel(SyndromModel syndromModel)
{
if(syndromModel.Hosts == "[Brak]")
return;
var syndromDB = new SectionsEntities();
var opinion = new Opinion
{
Id = syndromDB.Opinion.NextId(v => v.Id),
Hosts = syndromModel.Hosts,
MasterAgentIp = syndromModel.MasterAgentIp,
Syndrom = syndromModel.Syndrom
};
syndromDB.AddToOpinion(opinion);
syndromDB.SaveChanges();
}
public void InsertTestModel(TestModel testModel)
{
var sectionDB = new SectionsEntities();
var test = new Test
{
ID = sectionDB.Test.NextId(v => v.ID),
TestID = testModel.TestId,
IPDest = testModel.IpDest,
IPSrc = testModel.IpSrc,
MasterAgentIP = testModel.MasterAgentIp,
Number = testModel.Number,
ControlUnitIP = testModel.ControlUnitIp
};
sectionDB.AddToTest(test);
sectionDB.SaveChanges();
}