//首先建立實體資料模型
        //設定連接資料庫，選擇參考物件，設定單複數，精靈自動創立edmx

    public Form1()
    {
        InitializeComponent();
    }
    NorthwindEntities context = new NorthwindEntities(); //建立連接資料庫
    private void button1_Click(object sender, EventArgs e)
    {
        var customers = context.Customers.ToList();
        dataGridView1.DataSource = customers;
        (sender as Button).Text = "OK";
        //查詢所有客戶資料，並顯示在GRIDVIEW
      
    }

    private void button2_Click(object sender, EventArgs e)
    {
        var customer = context.Customers.Where(c => c.ContactName == "Janine Labrune").FirstOrDefault();
        if (customer != null)
        {
            var orders = customer.Orders.ToList();
            textBox1.Text = "";
            foreach (var order in orders)
            {
                textBox1.Text += order.OrderID + " " + order.OrderDate + " \\t\\n" ;
            }
        }
        else
        {
            textBox1.Text = "none";
        }
        (sender as Button).Text = "OK";
        //查詢客戶名稱為「Janine Labrune」並將OrderID、OrderDate顯示在textBox上
    }

    private void button3_Click(object sender, EventArgs e)
    {
        var product = context.Products.Where(p => p.ProductID == 79).FirstOrDefault();
        if (product!= null)
        {
            product.UnitInStock = 100;
            context.SaveChanges();
            MessageBox.Show("Changed");
        }
        else
        {
            MessageBox.Show("None");
        }
        (sender as Button).Text = "OK";
        //修改Product第79筆資料的UnitInStock為100
    }

    private void button4_Click(object sender, EventArgs e)
    {
        var newCustomer = new Customer
        {
            CustomerID = "test id",
            CompanyName = "test company",
            ContactName = "test name",
            ContactTitle = "test title",
            Address = "test address",
            City = "test city",
            Region = "test region",
            PostalCode = "test code",
            Phone = "test phone",
            Fax = "test fax"
        };
        context.Customers.Add(newCustomer);
        context.SaveChanges();
        (sender as Button).Text = "OK";
        //新增一筆客戶資料，並儲存到資料庫(Update-Insert)
    }

    private void button5_Click(object sender, EventArgs e)
    {
        //刪除測試的客戶資料
        var customer = context.Customers.Where(c => c.ContactName == "test name").FirstOrDefault();
        if (customer!= null)
        {
            context.Customers.Remove(customer);
            context.SaveChanges();
            (sender as Button).Text = "OK";
        }
        else
        {
            (sender as Button).Text = "None";
        }
        
    }
}