private ICollection <VulnerabilityDB> CheckIfInDB(List <VulnerabilityDB> vulnerabilityDBs)
{
ICollection <VulnerabilityDB> vulners = new List <VulnerabilityDB>();
foreach (VulnerabilityDB vul in vulnerabilityDBs)
{
VulnerabilityDB vulnerabilityDB = db.vulnerabilityDBs.ToList().Find(x => x.name == vul.name);
if (vulnerabilityDB != null)
{
vulners.Add(vulnerabilityDB);
}
}
HashSet <string> diffids = new HashSet <string>(db.vulnerabilityDBs.ToList().Select(s => s.name));
var results = vulnerabilityDBs.Where(m => !diffids.Contains(m.name)).ToList();
vulnerabilityDBs.Clear();
foreach (VulnerabilityDB vul in results)
{
vulners.Add(vul);
}
foreach (VulnerabilityDB vul in vulners)
{
vulnerabilityDBs.Add(vul);
}
return(vulnerabilityDBs);
}
public VulnerabilityDB SetParamsConsole(VulnerabilityDB vulnerability)
{
if (vulnerability.vulnerability == null)
{
Console.WriteLine("Set vulnerability:");
vulnerability.vulnerability = Convert.ToDouble(Console.ReadLine());
}
if (vulnerability.threats == null)
{
Console.WriteLine("Set threats:");
vulnerability.threats = Convert.ToDouble(Console.ReadLine());
}
if (vulnerability.techDamage == null)
{
Console.WriteLine("Set techDamage:");
vulnerability.techDamage = Convert.ToDouble(Console.ReadLine());
}
if (vulnerability.bizDamage == null)
{
Console.WriteLine("Set bizDamage:");
vulnerability.bizDamage = Convert.ToDouble(Console.ReadLine());
}
vulnerability.rezult = vulnerability.rezult == null?riskRules.Calculete(new double[] { vulnerability.vulnerability.GetValueOrDefault(), vulnerability.threats.GetValueOrDefault()
, vulnerability.techDamage.GetValueOrDefault(), vulnerability.bizDamage.GetValueOrDefault() }) : vulnerability.rezult;
return(vulnerability);
}
public void Delet(VulnerabilityDB obj)
{
context = new Context();
obj = context.vulnerabilityDBs.Find(obj.id);
if (obj == null)
{
return;
}
context.vulnerabilityDBs.Remove(obj);
context.SaveChanges();
}
public void Update(VulnerabilityDB obj)
{
context = new Context();
var entity = context.vulnerabilityDBs.Find(obj.id);
if (entity == null)
{
return;
}
context.Entry(entity).CurrentValues.SetValues(obj);
context.SaveChanges();
return;
}
public void Create(VulnerabilityDB vulnerabilityDB)
{
context = new Context();
context.vulnerabilityDBs.Add(vulnerabilityDB);
context.SaveChanges();
}
public void UpdateVulnerabilityDB(VulnerabilityDB vulnerability)
{
crudVulnerabilityDB.Update(vulnerability);
}
