using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace CMS
{
    public partial class teacher : Form
    {
        public teacher()
        {
            InitializeComponent();
        }
        public string str;
        private void 課程擔當ToolStripMenuItem_Click(object sender, EventArgs e)
        {
           
           
        }

        private void 個人住處查詢ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SqlConnection conn = null;
            DataSet ds = new DataSet();
            try
            {
                using (conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;;"))
                {
                    conn.Open();
                    string str2 = "select * from dbo.sky_teacher where 教師編號='"+str +"'";
                    SqlDataAdapter da = new SqlDataAdapter(str2, conn);
                    da.Fill(ds);

                    dataGridView1.DataSource = ds.Tables[0].DefaultView;
                }
                //conn = new SqlConnection("server=GEM\MIRROR;database=sky;integrated security=true;");
                //conn.Open();
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        private void 密碼修改ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            
        }

        private void 個人信息ToolStripMenuItem_Click(object sender, EventArgs e)
        {

        }

        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void 課程信息ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SqlConnection conn = null;
            DataSet ds = new DataSet();
            try
            {
                using (conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;;"))
                {
                    conn.Open();
                    string str2 = "select * from dbo.sky_kecheng where 課程號='" + str + "'";
                    SqlDataAdapter da = new SqlDataAdapter(str2, conn);
                    da.Fill(ds);

                    dataGridView1.DataSource = ds.Tables[0].DefaultView;
                }
                //conn = new SqlConnection("server=GEM\MIRROR;database=sky;integrated security=true;");
                //conn.Open();
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        private void 成績查看ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SqlConnection conn = null;
            DataSet ds = new DataSet();
            try
            {
                using (conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;"))
                {
                    conn.Open();
                    string str2 = "select * from dbo.sky_grade,dbo.sky_shouke where 教師編號='" + str + "' AND dbo.sky_grade.課程號=dbo.sky_shouke.課程號 ";
                    SqlDataAdapter da = new SqlDataAdapter(str2, conn);
                    da.Fill(ds);

                    dataGridView1.DataSource = ds.Tables[0].DefaultView;
                }
                //conn = new SqlConnection("server=localhost;database=zoo;integrated security=true;");
                //conn.Open();
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        private void 成績統計ToolStripMenuItem_Click(object sender, EventArgs e)
        {

        }

        private void 成績添加ToolStripMenuItem_Click(object sender, EventArgs e)
        {

        }

      private void 成績刪除ToolStripMenuItem_Click(object sender, EventArgs e)      //成績刪除。。。。。。。。。。。。。。。。呂俊杰
        {

            string str = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();
            SqlConnection conn = null;
          SqlCommand cmd=null ;
            if (MessageBox.Show("是否確定刪除", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                return;
            else
            {
               conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;");

            conn.Open();
            cmd  = new SqlCommand("delete from sky_grade where 編號='" + str + "' ", conn);

               
 
            }
            

           

            if (cmd.ExecuteNonQuery() > 0)                                                       //顯示提示信息。。。。。。呂俊杰
            {
                MessageBox.Show("刪除成功");
                conn.Close();

            }
            else
            {
                MessageBox.Show("刪除失敗");

            }

            
            DataSet ds = new DataSet();
            try
            {
                using (conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;"))  //重新刷新數據庫。。。。。呂俊杰
                {
                    conn.Open();
                    string str2 = "select * from dbo.sky_grade,dbo.sky_shouke where 教師編號='" + str + "' AND dbo.sky_grade.課程號=dbo.sky_shouke.課程號 ";
                    SqlDataAdapter da = new SqlDataAdapter(str2, conn);
                    da.Fill(ds);

                    dataGridView1.DataSource = ds.Tables[0].DefaultView;
                }
                //conn = new SqlConnection("server=localhost;database=sky;integrated security=true;");
                //conn.Open();
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }



        }
    }
}