public bool Import(string importPath, int userId)
{
bool ok = false;
DataSheetFeedImport imp = new DataSheetFeedImport()
{
DateStamp = DateTime.Now,
UserId = userId,
FileName = importPath,
FileContent = ReadFile(importPath)
};
try
{
imp = sSvc.Validate(imp);
if (imp.IsValid)
{
XmlDocument xdoc = new XmlDocument();
xdoc.LoadXml(imp.FileContent);
XmlNode docRoot = xdoc.DocumentElement;
XmlNodeList datasheetDocs = docRoot.SelectNodes("Datasheet");
foreach (XmlNode datasheetDoc in datasheetDocs)
{
XmlDocument dsDoc = new XmlDocument();
Entity entity = new Entity()
{
Active = true,
DateStamp = DateTime.Now,
EntityType = (int)EntityTypeEnum.Product,
UserId = userId
};
dsDoc.LoadXml(datasheetDoc.OuterXml);
entity.OtherId = GetEntityID(dsDoc);
entity.EntityName = GetEntityName(dsDoc);
db.Entities.Add(entity);
db.SaveChanges();
// SaveChapter(entity, dsDoc, "InformationFromExportingSystem", userId);
}
db.Imports.Add(imp);
db.SaveChanges();
}
}
catch (Exception ex)
{
Log.Error(ex, "Import File Name:" + importPath);
}
return(ok);
}
public Document Save(Document document)
{
if (document.Id == 0)
{
db.Add <Document>(document);
}
else
{
db.Update <Document>(document);
}
db.SaveChanges();
return(document);
}
public bool Delete(User user)
{
bool ok = false;
try
{
db.Users.Remove(user);
db.SaveChanges();
ok = true;
}
catch (Exception ex)
{
Log.Error(ex, "UserService>Delete");
}
return(ok);
}
/// <summary>
/// Updates an application setting
/// </summary>
///<param name="appSetting"></param>
/// <returns></returns>
public bool Save(ApplicationSetting appSetting)
{
bool ok = false;
try
{
if (appSetting.Id == 0)
{
db.AppSettings.Add(appSetting);
}
else
{
db.AppSettings.Update(appSetting);
}
ok = (db.SaveChanges() == 1);
}
catch (Exception ex)
{
Log.Error(ex, "ApplicationSettingService>AddNew");
}
return(ok);
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public Entity Save(Entity entity)
{
if (entity.Id == 0)
{
db.Add <Entity>(entity);
}
else
{
db.Update(entity);
}
db.SaveChanges();
return(entity);
}
public void LoadComponents()
{
try
{
List <Entity> entList = eSvc.GetByType(EntityTypeEnum.Component);
db.Entities.RemoveRange(entList);
db.SaveChanges();
List <ApplicationSetting> appSetList = aSvc.GetByArea("SUBSTANCES");
db.AppSettings.RemoveRange(appSetList);
db.SaveChanges();
XmlDocument xdoc = new XmlDocument();
xdoc.Load("files/reg-substances-export.xml");
XmlNode root = xdoc.DocumentElement;
db.AppSettings.Add(new ApplicationSetting()
{
Area = "SUBSTANCES",
Setting = "EXPORT_DATE",
DataValue = root.Attributes["exportDate"].Value
});
db.AppSettings.Add(new ApplicationSetting()
{
Area = "SUBSTANCES",
Setting = "LAST_UPDATED",
DataValue = root.Attributes["lastUpdate"].Value
});
db.AppSettings.Add(new ApplicationSetting()
{
Area = "SUBSTANCES",
Setting = "COUNT",
DataValue = root.Attributes["uniqueSustances"].Value
});
db.SaveChanges();
//------------------------------------------------------------------------------------
List <Entity> entities = new List <Entity>();
XmlNodeList substanceNodes = xdoc.SelectNodes(xpath: "RegisteredSubstances/results/result");
int x = 0;
foreach (XmlNode substanceNode in substanceNodes)
{
Entity entity = new Entity();
entity.Active = true;
entity.DateStamp = DateTime.Now;
entity.EntityName = substanceNode.SelectSingleNode("name").InnerText;
entity.EntityType = 2;
entity.Id = 0;
entity.OtherId = substanceNode.SelectSingleNode("casNumber").InnerText;
entity.UserId = 1;
entity.Properties = GetEntityProperties(substanceNode, xdoc);
entities.Add(entity);
x++;
if (x >= 1000)
{
db.Entities.AddRange(entities);
db.SaveChanges();
x = 0;
entities = new List <Entity>();
}
}
db.Entities.AddRange(entities);
db.SaveChanges();
}
catch (Exception ex)
{
Log.Error(ex.Message);
}
}
public void CreateFacets(List <Facet> facetList)
{
db.AddRange(facetList);
db.SaveChanges();
}
