internal static void SeedData(ITAMDbContext context)
{
context.Database.CreateIfNotExists();
}
private static void ImportJson()
{
Console.WriteLine(Inventory.ComputerName);
using (ITAMDbContext db = new ITAMDbContext(DbConnection))
{
using (Win32_Product_SQL product_SQL = new Win32_Product_SQL())
{
foreach (var productItem in Inventory.win32_Product.Items)
{
// Clear product_SQL, based on Inventory.win32_Product.Items
foreach (var property in productItem.GetType().GetProperties())
{
property.SetValue(product_SQL, null);
}
product_SQL.ComputerName = Inventory.ComputerName;
// Transfer data if not <null>
foreach (var property in productItem.GetType().GetProperties())
{
string value = (string)property.GetValue(productItem);
if (value != "<null>")
{
property.SetValue(product_SQL, value);
}
}
try
{
db.Product.Add(product_SQL);
db.SaveChanges();
}
catch (Exception ex)
{
string message = $"{ex.Source}\n{ex.Message}\n\n";
foreach (var item in productItem.GetType().GetProperties())
{
string value = (string)item.GetValue(productItem);
message += $"{item.Name.PadRight(17)} = {value.Length.ToString().PadLeft(3)}: {value}\n";
}
MessageBox.Show(message, $"Error {Inventory.ComputerName}: 0x{ex.HResult:X}", MessageBoxButton.OK, MessageBoxImage.Error);
//Console.WriteLine($"==== {product_SQL.ComputerName}");
//Console.WriteLine($"Name = {productItem.Name}: {productItem.Name.Length}");
//Console.WriteLine($"Vendor = {productItem.Vendor}: {productItem.Vendor.Length}");
//Console.WriteLine($"Version = {productItem.Version}: {productItem.Version.Length}");
//Console.WriteLine($"IdentifyNr = {productItem.IdentifyingNumber}: {productItem.IdentifyingNumber.Length}");
//Console.WriteLine($"InstalDate = {productItem.InstallDate}: {productItem.InstallDate.Length}");
//Console.WriteLine($"InstalLocati = {productItem.InstallLocation}: {productItem.InstallLocation.Length}");
//Console.WriteLine($"InstallSoure = {productItem.InstallSource}: {productItem.InstallSource.Length}");
//Console.WriteLine($"LocalPackage = {productItem.LocalPackage}: {productItem.LocalPackage.Length}");
//Console.WriteLine($"PackageCache = {productItem.PackageCache}: {productItem.PackageCache.Length}");
//Console.WriteLine($"PackageCode = {productItem.PackageCode}: {productItem.PackageCode.Length}");
//Console.WriteLine($"PackageName = {productItem.PackageName}: {productItem.PackageName.Length}");
//Console.WriteLine($"HelpLink = {productItem.HelpLink}: {productItem.HelpLink.Length}");
//Console.WriteLine($"URLInfoAbout = {productItem.URLInfoAbout}: {productItem.URLInfoAbout.Length}");
//Console.WriteLine($"URLUpdateInf = {productItem.URLUpdateInfo}: {productItem.URLUpdateInfo.Length}");
}
}
}
}
}
