private void button_UsersAccountsManagerForm_Apply_Click(object sender, System.EventArgs e)
    {
        DataSet_ConnectingServiceDB.ClientsSecurityDataBaseDataTable clientsSecurityDataBaseDataTable_obj = ConnectingServiceDBSupplier.ConnectingServiceDB.ClientsSecurityDataBase;

        DataRow dataRow_EditedRecord = null;

        DateTime dateTime_CreationTime = DateTime.Now;

        dataRow_EditedRecord = ConnectingServiceDBSupplier.ConnectingServiceDB.ClientsSecurityDataBase[EditedRecordIndex];

        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.UserNameColumn]        = this.textBox_UsersAccountsManagerForm_FirstName.Text;
        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.UserLastNameColumn]    = this.textBox_UsersAccountsManagerForm_LastName.Text;
        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.UserMiddleNameColumn]  = this.textBox_UsersAccountsManagerForm_MiddleName.Text;
        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.EMailColumn]           = this.textBox_UsersAccountsManagerForm_EMailAddress.Text;
        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.ICQColumn]             = this.textBox_UsersAccountsManagerForm_ICQ.Text;
        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.CompanyColumn]         = this.textBox_UsersAccountsManagerForm_Company.Text;
        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.WorkPhoneColumn]       = this.textBox_UsersAccountsManagerForm_WorkPhone.Text;
        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.HomePhoneColumn]       = this.textBox_UsersAccountsManagerForm_HomePhome.Text;
        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.PrivateCellularColumn] = this.textBox_UsersAccountsManagerForm_PrivateCellular.Text;
        dataRow_EditedRecord[clientsSecurityDataBaseDataTable_obj.CreationTimeColumn]    = dateTime_CreationTime;

        this.Close();
    }
    public void FillClientsSecurityDataBase()
    {
        try
        {
            if (ConnectingServiceDB.ClientsSecurityDataBase.Rows.Count < 0)
            {
                return;
            }

            DataRow dataRow_NewRecord = null;

            DataSet_ConnectingServiceDB.ClientsSecurityDataBaseDataTable securityDataBaseDataTable_obj = ConnectingServiceDB.ClientsSecurityDataBase;

            ClientsNetworkSecurity.UserAccount userAccount_NewAccount = null;

            for (int int_CycleCount = 0; int_CycleCount != securityDataBaseDataTable_obj.Rows.Count; int_CycleCount++)
            {
                dataRow_NewRecord = ConnectingServiceDB.ClientsSecurityDataBase.Rows[int_CycleCount];

                userAccount_NewAccount = new ClientsNetworkSecurity.UserAccount();

                userAccount_NewAccount.FirstName  = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.UserFirstNameColumn];;
                userAccount_NewAccount.SecondName = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.UserMiddleNameColumn];;
                userAccount_NewAccount.LastName   = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.UserLastNameColumn];

                userAccount_NewAccount.ICQ   = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.ICQColumn];
                userAccount_NewAccount.EMail = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.EMailColumn];

                userAccount_NewAccount.Work = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.CompanyColumn];

                userAccount_NewAccount.HomePhone   = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.HomePhoneColumn];
                userAccount_NewAccount.WorkPhone   = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.WorkPhoneColumn];
                userAccount_NewAccount.MobilePhone = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.PrivateCellularColumn];

                userAccount_NewAccount.ActivationCode = (ulong)dataRow_NewRecord[securityDataBaseDataTable_obj.ActivationCodeColumn];
                userAccount_NewAccount.IsActivated    = (bool)dataRow_NewRecord[securityDataBaseDataTable_obj.IsActivatedColumn];

                userAccount_NewAccount.IsEnabled = (bool)dataRow_NewRecord[securityDataBaseDataTable_obj.EnabledAccountStateColumn];
                userAccount_NewAccount.Password  = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.UserPasswordColumn];
                userAccount_NewAccount.UIN       = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.UINColumn];
                userAccount_NewAccount.UserName  = (string)dataRow_NewRecord[securityDataBaseDataTable_obj.UserNameColumn];

                userAccount_NewAccount.CreationTime = (DateTime)dataRow_NewRecord[securityDataBaseDataTable_obj.CreationTimeColumn];
                userAccount_NewAccount.IsActivated  = (bool)dataRow_NewRecord[securityDataBaseDataTable_obj.IsActivatedColumn];

                if (userAccount_NewAccount.IsActivated == true)
                {
                    userAccount_NewAccount.ActivationTime = (DateTime)dataRow_NewRecord[securityDataBaseDataTable_obj.ActivationTimeColumn];
                }

                dataRow_NewRecord = ConnectingServiceDB.ClientsSecurityDataBase.Rows[int_CycleCount];

                ClientsNetworkSecurity.AddNewUser(userAccount_NewAccount);
            }
        }

        catch (Exception)
        {
            if (File.Exists("ConnectingServiceDB"))
            {
                File.Delete("ConnectingServiceDB");
            }

            MessageBox.Show(ServerStringFactory.GetString(128, MainForm.CurrentLanguage), ServerStringFactory.GetString(1, MainForm.CurrentLanguage));

            return;
        }
    }