Addcom.xaml.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using MySql.Data.MySqlClient;

namespace MQTT
{
    /// <summary>
    /// Addcom.xaml 的互動邏輯
    /// </summary>
    public partial class Addcom : Window
    {
        private MainWindow mainWindow;
        public Addcom(MainWindow mainWindow)
        {
            InitializeComponent();
            this.mainWindow = mainWindow;
            this.WindowState = WindowState.Maximized;
        }
        List<string> comID = new List<string>();
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            string database = "company_db";
            string databaseServer = "220.132.141.9";
            string databasePort = "6833";
            string databaseUser = "root";
            string databasePassword = "edys1234";
            string connectionString = $"server={databaseServer};" + $"port={databasePort};" + $"user={databaseUser};" + $"password={databasePassword};" + $"database={database};" + "charset=utf8;";
            if (txtid.Text.Length > 0 && txtname.Text.Length > 0 && txtphone.Text.Length > 0)
            {
                using (MySqlConnection connection = new MySqlConnection(connectionString))
                {
                    connection.Open();  //資料庫連線my'Unable to connect to any of the specified MySQL hosts.''Unable to connect to any of the specified MySQL hosts.'
                    // 在這裡執行資料庫操作
                    string sql = "SELECT * FROM company_info_db";
                    using (MySqlCommand cmd = new MySqlCommand(sql, connection))
                    {
                        using (MySqlDataReader reader = cmd.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                comID.Add(reader.GetString("Company_ID"));
                            }
                        }
                    }
                    connection.Close();
                }
                var foundItems = comID.Where(item => item.Contains(txtid.Text)).ToList();
                if (foundItems.Any())
                {
                    MessageBox.Show("部門ID不能重複");
                    return;
                }
            }
            else
            {
                MessageBox.Show("資料不能有空");
                return;
            }
            MessageBoxResult result = MessageBox.Show("確定要上傳嗎?", "警告", MessageBoxButton.YesNo, MessageBoxImage.Question);
            if (result == MessageBoxResult.Yes){
                string buff="";
                for (int i = 0; i < txtphone.Text.Length; i++)
                {
                    if (char.IsDigit(txtphone.Text[i]))
                    {
                        buff += txtphone.Text[i];
                    }
                }
                if (buff[1].ToString()=="9")
                {
                    if(buff.Length != 10) //0932690245
                    {
                        MessageBox.Show("行動電話有誤或不完整");
                        return;
                    }
                }
                else
                {
                    if (buff.Length != 9) //055875935
                    {
                        MessageBox.Show("室內電話有誤或不完整");
                        return;
                    }
                }
                txtphone.Text = buff;
                using (MySqlConnection connection = new MySqlConnection(connectionString))
                {
                    connection.Open();
                    string insertSql =
                        "INSERT INTO company_info_db (Company_ID, Name, Address, Cellphone) VALUES (@id, @name, @address, @cellphone)";
                    using (MySqlCommand insertCommand = new MySqlCommand(insertSql, connection))
                    {
                        insertCommand.Parameters.AddWithValue("@id", txtid.Text);
                        insertCommand.Parameters.AddWithValue("@name", txtname.Text);
                        insertCommand.Parameters.AddWithValue("@address",txtaddress.Text);
                        insertCommand.Parameters.AddWithValue("@cellphone", txtphone.Text);
                        int rowsAffected = insertCommand.ExecuteNonQuery();
                    }
                    connection.Close();
                }
                mainWindow.MySQLCreatelist();
                this.Close();
            }else{
                return;
            }
        }
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            MessageBoxResult result = MessageBox.Show("確定要放棄嗎?", "警告", MessageBoxButton.YesNo, MessageBoxImage.Question);
            if (result == MessageBoxResult.Yes){
                this.Close();
            }else{
                return;
            }
        }
    }
}