private int AddNewRawMaterialToRawMaterialTable(WorkCycleLines line)
{
_context.RawMaterials.Add(new RawMaterial {
Name = line.RawMaterialStringTemp, RawMaterialCategoryId = 1, Active = true
});
_context.SaveChanges();
return(_context.RawMaterials.SingleOrDefault(r => r.Name == line.RawMaterialStringTemp).Id);
}
private int CheckForOldRawMaterialsToActivate(WorkCycleLines line)
{
var rawMaterialInDb = _context.RawMaterials.SingleOrDefault(r => r.Name == line.RawMaterialStringTemp);
if (rawMaterialInDb == null)
{
return(0);
}
rawMaterialInDb.Active = true;
_context.SaveChanges();
return(rawMaterialInDb.Id);
}
private int AddNewSupplierToSupplierTable(WorkCycleLines line)
{
var checkForExistence = _context.Suppliers.SingleOrDefault(x => x.Name == line.SupplierStringTemp);
if (checkForExistence != null)
{
return(checkForExistence.Id);
}
_context.Suppliers.Add(new Supplier {
Name = line.SupplierStringTemp, Active = true
});
_context.SaveChanges();
return(_context.Suppliers.SingleOrDefault(s => s.Name == line.SupplierStringTemp).Id);
}
