Beispiel #1
0
 public void GetActualVersion()
 {
     using (Network_SchemeEntities db = new Network_SchemeEntities(DBUtils.getConnString()))
     {
         try
         {
             if (db.Network_Versions.Count() == 0)
             {
                 version     = 0;
                 version_id  = 0;
                 starting_id = (version_id + 1) * 1000;
             }
             else
             {
                 Network_Versions version_obj = db.Network_Versions.FirstOrDefault
                                                    (p => p.ID == db.Network_Versions.Max(x => x.ID));
                 version     = version_obj.C_Version_Number;
                 version_id  = version_obj.ID;
                 starting_id = (version_id + 1) * 1000;
             }
         }
         catch
         {
             MessageBox.Show("Ошибка получения актуальной версии");
         }
     }
 }
        private void button2_Click(object sender, EventArgs e)
        {
            if (selected_version_id != -1)
            {
                using (Network_SchemeEntities db = new Network_SchemeEntities(DBUtils.getConnString()))
                {
                    using (var transaction = db.Database.BeginTransaction())
                    {
                        try
                        {
                            db.Network_Connections.RemoveRange(db.Network_Connections.Where(c => c.C_Version == selected_version_id));
                            db.Network_Hardware.RemoveRange(db.Network_Hardware.Where(c => c.C_Version == selected_version_id));
                            db.Network_Settings.RemoveRange(db.Network_Settings.Where(c => c.C_Version == selected_version_id));
                            db.Network_Ports.RemoveRange(db.Network_Ports.Where(c => c.C_Version == selected_version_id));
                            db.Network_Versions.RemoveRange(db.Network_Versions.Where(c => c.ID == selected_version_id));

                            db.SaveChanges();
                            transaction.Commit();
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show("Ошибка cохранения версии : " + ex.ToString());
                            transaction.Rollback();
                            return;
                        }
                    }
                }
                workspace.NewScheme();
                GetVersions();
            }
        }
        public void GetVersions()
        {
            label2.Text = "Версия: ";
            label4.Text = "Дата: ";
            using (Network_SchemeEntities db = new Network_SchemeEntities(DBUtils.getConnString()))
            {
                List <Network_Versions> db_versions;
                try
                {
                    db_versions = db.Network_Versions.OrderByDescending(p => p.C_Version_Number).ToList();
                }
                catch
                {
                    MessageBox.Show("Ошибка загрузки актуальной версии");
                    return;
                }

                List <Control> listControls = new List <Control>();
                foreach (Control control in flowLayoutPanel1.Controls)
                {
                    listControls.Add(control);
                }
                foreach (Control control in listControls)
                {
                    flowLayoutPanel1.Controls.Remove(control);
                    control.Dispose();
                }

                for (int i = 0; i < db_versions.Count; i++)
                {
                    Network_Versions db_version = db_versions[i];

                    Button button = new Button();
                    button.Size      = new Size(flowLayoutPanel1.Width - 6, 30);
                    button.Tag       = i;
                    button.BackColor = SystemColors.ButtonFace;
                    button.Text      = "Версия " + db_version.C_Version_Number;
                    flowLayoutPanel1.Controls.Add(button);

                    button.Click += delegate
                    {
                        workspace.LoadDB(db_version.ID, db_version.C_Version_Number);

                        label2.Text = "Версия: " + db_version.C_Version_Number;
                        label4.Text = "Дата: " + db_version.C_Date;

                        selected_version_id = db_version.ID;
                    };
                }
            }
        }
 private void Form1_Load(object sender, EventArgs e)
 {
     using (Network_SchemeEntities db = new Network_SchemeEntities(DBUtils.getConnString()))
     {
         DbConnection conn = db.Database.Connection;
         try
         {
             conn.Open(); // проверка соединения
             Console.WriteLine("Connection success");
         }
         catch // ошибка соединения
         {
             MessageBox.Show("Не удалось подключиться к серверу базы данных");
             Console.WriteLine("Сonnection failed");
         }
     }
 }
Beispiel #5
0
        public void SaveToDB()
        {
            using (Network_SchemeEntities db = new Network_SchemeEntities(DBUtils.getConnString()))
            {
                Network_Versions new_version = new Network_Versions();
                new_version.C_Date           = DateTime.Now.ToString("d/M/yyyy");
                new_version.C_Version_Number = version + 1;
                new_version.ID = version_id + 1;

                List <Network_Hardware>    db_devices     = new List <Network_Hardware>();
                List <Network_Settings>    db_settings    = new List <Network_Settings>();
                List <Network_Ports>       db_ports       = new List <Network_Ports>();
                List <Network_Connections> db_connections = new List <Network_Connections>();

                int connection_id = 0;
                foreach (NetDevice device in devices)
                {
                    Network_Hardware db_device = new Network_Hardware();
                    db_device.ID            = starting_id + device.id_real;
                    db_device.C_Interface_X = device.sprite.Location.X;
                    db_device.C_Interface_Y = device.sprite.Location.Y;
                    db_device.C_Name        = device.name;
                    db_device.C_Type        = device.type;
                    db_device.C_Status      = false;
                    db_device.C_Version     = new_version.ID;

                    db_devices.Add(db_device);

                    foreach (NetPort port in device.ports)
                    {
                        Network_Settings db_setting = new Network_Settings();
                        db_setting.ID                = starting_id + port.settings.id_real;
                        db_setting.C_IP              = port.settings.IP;
                        db_setting.C_Subnet_Mask     = port.settings.subnet_mask;
                        db_setting.C_Default_Gateway = port.settings.default_gateway;
                        db_setting.C_Version         = new_version.ID;

                        db_settings.Add(db_setting);

                        Network_Ports db_port = new Network_Ports();
                        db_port.ID            = starting_id + port.id_real;
                        db_port.C_Status      = port.enabled;
                        db_port.C_Version     = new_version.ID;
                        db_port.C_Hardware_ID = db_device.ID;
                        db_port.C_Settings_ID = db_setting.ID;

                        db_ports.Add(db_port);

                        if (port.connected_port != null)
                        {
                            Network_Connections db_connection = new Network_Connections();
                            db_connection.ID             = starting_id + connection_id;
                            db_connection.C_Version      = new_version.ID;
                            db_connection.C_From_Port_ID = starting_id + port.id_real;
                            db_connection.C_To_Port_ID   = starting_id + port.connected_port.id_real;
                            db_connections.Add(db_connection);

                            connection_id++;
                        }
                    }
                }

                using (var transaction = db.Database.BeginTransaction())
                {
                    try
                    {
                        db.Network_Versions.Add(new_version);

                        foreach (Network_Settings db_setting in db_settings)
                        {
                            db.Network_Settings.Add(db_setting);
                        }
                        foreach (Network_Hardware db_device in db_devices)
                        {
                            db.Network_Hardware.Add(db_device);
                        }
                        foreach (Network_Ports db_port in db_ports)
                        {
                            db.Network_Ports.Add(db_port);
                        }
                        foreach (Network_Connections db_connection in db_connections)
                        {
                            db.Network_Connections.Add(db_connection);
                        }

                        db.SaveChanges();
                        transaction.Commit();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Ошибка cохранения версии : " + ex.ToString());
                        transaction.Rollback();
                    }
                }
            }
            MessageBox.Show("Успешно сохранена версия : " + (version + 1));
            GetActualVersion();
        }
Beispiel #6
0
        public void LoadDB(int load_version_id, int version_number)
        {
            GetActualVersion();
            using (Network_SchemeEntities db = new Network_SchemeEntities(DBUtils.getConnString()))
            {
                List <Network_Hardware>    db_devices;
                List <Network_Settings>    db_settings;
                List <Network_Ports>       db_ports;
                List <Network_Connections> db_connections;
                try
                {
                    db_devices     = db.Network_Hardware.Where(b => b.C_Version == load_version_id).ToList <Network_Hardware>();
                    db_settings    = db.Network_Settings.Where(b => b.C_Version == load_version_id).ToList <Network_Settings>();
                    db_ports       = db.Network_Ports.Where(b => b.C_Version == load_version_id).ToList <Network_Ports>();
                    db_connections = db.Network_Connections.Where(b => b.C_Version == load_version_id).ToList <Network_Connections>();
                }
                catch
                {
                    MessageBox.Show("Ошибка загрузки актуальной версии");
                    return;
                }
                panel.Controls.Clear();
                devices.Clear();

                NetDevice.id    = 0;
                NetSettings.id  = 0;
                NetPort.id      = 0;
                NetDevice.pc_id = 0;
                NetDevice.pr_id = 0;
                NetDevice.sw_id = 0;
                NetDevice.ro_id = 0;

                int max_real_id = 0;
                int id_shift    = (load_version_id) * (-1000);

                foreach (Network_Hardware db_device in db_devices)
                {
                    int id = id_shift + db_device.ID;
                    if (id > max_real_id)
                    {
                        max_real_id = id;
                    }
                    NetDevice device = new NetDevice(this, db_device.C_Type, false);
                    device.x          = db_device.C_Interface_X;
                    device.y          = db_device.C_Interface_Y;
                    device.name       = db_device.C_Name;
                    device.title.Text = device.name;
                    device.id_real    = id;

                    devices.Add(device);
                }
                NetDevice.id = max_real_id + 1;

                max_real_id = 0;
                foreach (Network_Ports db_port in db_ports)
                {
                    int id = id_shift + db_port.ID;
                    if (id > max_real_id)
                    {
                        max_real_id = id;
                    }
                    NetPort port = new NetPort(null);
                    port.id_real     = id;
                    port.enabled     = db_port.C_Status;
                    port.settings_id = id_shift + db_port.C_Settings_ID;

                    // set device
                    int device_id = id_shift + db_port.C_Hardware_ID;
                    foreach (NetDevice device in devices)
                    {
                        if (device.id_real == device_id)
                        {
                            port.device = device;
                            for (int i = 0; i < device.ports.Count; i++)
                            {
                                if (device.ports[i] == null)
                                {
                                    device.ports[i] = port;
                                    break;
                                }
                            }
                            break;
                        }
                    }
                }
                NetPort.id = max_real_id + 1;

                max_real_id = 0;
                foreach (Network_Settings db_setting in db_settings)
                {
                    int id = id_shift + db_setting.ID;
                    if (id > max_real_id)
                    {
                        max_real_id = id;
                    }
                    NetSettings setting = new NetSettings();
                    setting.id_real         = id;
                    setting.IP              = db_setting.C_IP;
                    setting.default_gateway = db_setting.C_Default_Gateway;
                    setting.subnet_mask     = db_setting.C_Subnet_Mask;

                    // set device
                    bool stop = false;
                    foreach (NetDevice device in devices)
                    {
                        if (stop)
                        {
                            break;
                        }
                        foreach (NetPort port in device.ports)
                        {
                            if (setting.id_real == port.settings_id)
                            {
                                port.settings = setting;
                                stop          = true;
                                break;
                            }
                        }
                    }
                }
                NetSettings.id = max_real_id + 1;

                foreach (Network_Connections db_connection in db_connections)
                {
                    int port_start_id = id_shift + db_connection.C_From_Port_ID;
                    int port_end_id   = id_shift + db_connection.C_To_Port_ID;

                    NetPort start_port = null;
                    NetPort end_port   = null;

                    bool stop = false;
                    foreach (NetDevice device in devices)
                    {
                        if (stop)
                        {
                            break;
                        }
                        foreach (NetPort port in device.ports)
                        {
                            if (port.id_real == port_start_id)
                            {
                                start_port = port;
                                stop       = true;
                                break;
                            }
                        }
                    }

                    stop = false;
                    foreach (NetDevice device in devices)
                    {
                        if (stop)
                        {
                            break;
                        }
                        foreach (NetPort port in device.ports)
                        {
                            if (port.id_real == port_end_id)
                            {
                                end_port = port;
                                stop     = true;
                                break;
                            }
                        }
                    }

                    start_port.connected_port = end_port;
                    end_port.connected_port   = start_port;
                }
            }
            RefreshDraw();
            panel.Refresh();
            MessageBox.Show("Успешно загружена версия : " + version_number);
        }