Exemple #1
0
        public void InitializeDatabaseStructure()
        {
            if (!DataAccess.DatabaseFacade.DatabaseManager.IsDeviceCollectionExist)
            {
                var nDevice = new Entity.Device()
                {
                    Name         = "Localhost",
                    Description  = "LocalComputer",
                    LastModified = DateTime.Now,
                    IPAddress    = "127.0.0.1",
                    Components   = new List <Entity.Component>()
                    {
                        new Entity.Component()
                        {
                            Type = new Entity.ComponentType()
                            {
                                Category = "Ping", Mode = "HostAlive"
                            },
                            Compression  = 1,
                            IsActive     = true,
                            ValueType    = typeof(bool).ToString(),
                            CurrentValue = 0,
                            Interval     = 5,
                            Name         = "Host Alive"
                        }
                    }
                };

                Devices.Insert(nDevice);
                foreach (var item in nDevice.Components)
                {
                    item.Device = nDevice;
                    Components.Save(item);
                }
            }

            //Check and create other module
            //Each new query module has to be inserted here to be registered in the database
            if (!ComponentTypes.AsQueryable().Any(u => u.Mode == "HostAlive" & u.Category == "Ping"))
            {
                var nType = new Entity.ComponentType()
                {
                    Category = "Ping", Mode = "HostAlive"
                };

                ComponentTypes.Insert(nType);
            }
            if (!ComponentTypes.AsQueryable().Any(u => u.Mode == "Delay" & u.Category == "Ping"))
            {
                var nType = new Entity.ComponentType()
                {
                    Category = "Ping", Mode = "Delay"
                };

                ComponentTypes.Insert(nType);
            }
            if (!ComponentTypes.AsQueryable().Any(u => u.Mode == "DiskSpaceLeft" & u.Category == "WMI"))
            {
                var nType = new Entity.ComponentType()
                {
                    Category = "WMI", Mode = "DiskSpaceLeft", TemplateOptions = new Dictionary <string, string>()
                    {
                        { "Disk", "" }, { "User", "" }, { "Password", "" }, { "Unit", "" }
                    }
                };

                ComponentTypes.Insert(nType);
            }
            if (!ComponentTypes.AsQueryable().Any(u => u.Mode == "DiskPercentageLeft" & u.Category == "WMI"))
            {
                var nType = new Entity.ComponentType()
                {
                    Category = "WMI", Mode = "DiskPercentageLeft", TemplateOptions = new Dictionary <string, string>()
                    {
                        { "Disk", "" }, { "User", "" }, { "Password", "" }
                    }
                };

                ComponentTypes.Insert(nType);
            }
            if (!ComponentTypes.AsQueryable().Any(u => u.Mode == "MemSpaceLeft" & u.Category == "WMI"))
            {
                var nType = new Entity.ComponentType()
                {
                    Category = "WMI", Mode = "MemSpaceLeft", TemplateOptions = new Dictionary <string, string>()
                    {
                        { "User", "" }, { "Password", "" }, { "Unit", "" }
                    }
                };

                ComponentTypes.Insert(nType);
            }
            if (!ComponentTypes.AsQueryable().Any(u => u.Mode == "MemPercentageLeft" & u.Category == "WMI"))
            {
                var nType = new Entity.ComponentType()
                {
                    Category = "WMI", Mode = "MemPercentageLeft", TemplateOptions = new Dictionary <string, string>()
                    {
                        { "User", "" }, { "Password", "" }
                    }
                };

                ComponentTypes.Insert(nType);
            }
            if (!ComponentTypes.AsQueryable().Any(u => u.Mode == "CpuUsage" & u.Category == "WMI"))
            {
                var nType = new Entity.ComponentType()
                {
                    Category = "WMI", Mode = "CpuUsage", TemplateOptions = new Dictionary <string, string>()
                    {
                        { "User", "" }, { "Password", "" }
                    }
                };

                ComponentTypes.Insert(nType);
            }
            if (!ComponentTypes.AsQueryable().Any(u => u.Mode == "SNMP Get" & u.Category == "SNMP"))
            {
                var nType = new Entity.ComponentType()
                {
                    Category = "SNMP", Mode = "SNMP Get", TemplateOptions = new Dictionary <string, string>()
                    {
                        { "OID", "" }, { "CommunityString", "" }
                    }
                };

                ComponentTypes.Insert(nType);
            }
            if (!ComponentTypes.AsQueryable().Any(u => u.Mode == "ESXi Sensor" & u.Category == "VMWare"))
            {
                var nType = new Entity.ComponentType()
                {
                    Category = "VMWare", Mode = "ESXi Sensor", TemplateOptions = new Dictionary <string, string>()
                    {
                        { "User", "" }, { "Password", "" }, { "SensorName", "" }
                    }
                };

                ComponentTypes.Insert(nType);
            }

            //Configuration
            if (!Configurations.AsQueryable().Any(u => u.Name == "FromEmailAdress"))
            {
                var nConf = new Entity.Configuration()
                {
                    Name = "FromEmailAdress"
                };

                Configurations.Insert(nConf);
            }
            if (!Configurations.AsQueryable().Any(u => u.Name == "MailServer"))
            {
                var nConf = new Entity.Configuration()
                {
                    Name = "MailServer"
                };

                Configurations.Insert(nConf);
            }
        }