using System;
using System.Collections.Generic;
using System.Text;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Web.Configuration;
using System.Web;
using System.Data;
using Model;
using System.Data.SqlClient;

namespace Server
{
    public  class ClassManage
    {
        //系部管理員添加課程
        public static bool AddClass(class_tb cs)
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConn"].Trim());
            SqlCommand cmd = new SqlCommand("DeptAddClass",conn );
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@Class_id", SqlDbType.VarChar).Value = cs.Class_id;
            cmd.Parameters.Add("@class_name", SqlDbType.VarChar).Value = cs.Class_name;
            cmd.Parameters.Add("@class_dep_id", SqlDbType.Int).Value = cs.Class_dep_id;
            cmd.Parameters.Add("@Class_kind", SqlDbType.VarChar).Value = cs.Class_kind;
            cmd.Parameters.Add("@Class_credit", SqlDbType.Int ).Value = cs.Class_credit;
            cmd.Parameters.Add("@Class_hour", SqlDbType.DateTime).Value = cs.Class_hour;
            cmd.Parameters.Add("@Class_table", SqlDbType.VarChar).Value = cs.Class_table;
            cmd.Parameters.Add("@class_long", SqlDbType.Int ).Value = cs.Class_long;
            cmd.Parameters.Add("@class_info",SqlDbType.VarChar).Value=cs.Class_info;
            cmd.Parameters.Add("@class_big", SqlDbType.Int).Value = cs.Class_big;

            SqlParameter pm = new SqlParameter("@anwer",SqlDbType.Int);
            pm.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(pm);
            try
            {
                conn.Open();
                cmd.ExecuteNonQuery();
                return Convert.ToBoolean(pm.Value);
            }
            catch
            {
                return Convert.ToBoolean(pm.Value);
            }
            finally
            {
                conn.Close();            
            }
        }
        //各系部老師申請課程
        public static string ApplyClass(applyClass_tb ac)
        {

            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConn"].Trim());

            SqlCommand cmd = new SqlCommand("ApplyClass", conn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@class_id", SqlDbType.BigInt).Value = ac.Class_id;
            cmd.Parameters.Add("@teacher_id", SqlDbType.BigInt).Value = ac.Teacher_id;
            cmd.Parameters.Add("@dept_id", SqlDbType.BigInt).Value = ac.Dept_id;
            cmd.Parameters.Add("@fun", SqlDbType.VarChar).Value = ac.Fun;

            SqlParameter pm = new SqlParameter("@anwer", SqlDbType.VarChar, 50);
            pm.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(pm);

            try
            {
                conn.Open();
                cmd.ExecuteNonQuery();
                conn.Close();
                return pm.Value.ToString();
            }
            catch
            {
                return "申請失敗";
            }
            finally
            {

            }
        }
        //各系部老師取消課程的申請
        public static string CancelApplyingClass(applyClass_tb ac)
        {
//            @teacher_id bigint,
//@class_id bigint,
//@dept_id bigint,
//@anwer varchar(50)
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConn"].Trim());
            SqlCommand cmd = new SqlCommand("CancelApplyingClass",conn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@teacher_id", SqlDbType.BigInt).Value = ac.Teacher_id;
            cmd.Parameters.Add("@class_id", SqlDbType.BigInt).Value = ac.Class_id;
            cmd.Parameters.Add("@dept_id", SqlDbType.BigInt).Value = ac.Dept_id;

            SqlParameter pm = new SqlParameter("@anwer", SqlDbType.VarChar,50);
            pm.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(pm);

            try
            {
                conn.Open();
                cmd.ExecuteNonQuery();
                return pm.Value.ToString();
            }
            catch
            {
                return "取消失敗";
            }
            finally
            {
                conn.Close();
            }
        }
        public static string[] SeeClassTable(class_tb ac)
        {
            string[]class_tb=new string[10];
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConn"].Trim());
            SqlCommand cmd = new SqlCommand("select * from class_tb where class_id=@class_id",conn);
            cmd.Parameters.Add("@class_id", SqlDbType.BigInt).Value =Convert.ToInt64( ac.Class_id);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            da.Dispose();
            class_tb[0]=ds.Tables[0].Rows[0]["class_credit"].ToString();
            class_tb[1] = ds.Tables[0].Rows[0]["class_hour"].ToString();
            class_tb[2] = ds.Tables[0].Rows[0]["class_info"].ToString();
            class_tb[3] = ds.Tables[0].Rows[0]["class_kind"].ToString();
            class_tb[4] = ds.Tables[0].Rows[0]["class_long"].ToString();//課時
            class_tb[5] = ds.Tables[0].Rows[0]["class_name"].ToString();
            class_tb[6] = ds.Tables[0].Rows[0]["class_table"].ToString();
            if (null != ds.Tables[0].Rows[0]["class_people"].ToString())
            {
                class_tb[7] = ds.Tables[0].Rows[0]["class_people"].ToString();
            }
            if (null != ds.Tables[0].Rows[0]["class_big"].ToString())
            {
                class_tb[8] = ds.Tables[0].Rows[0]["class_big"].ToString();
            }

            if (null != ds.Tables[0].Rows[0]["class_teach_id"].ToString())
            {
                class_tb[9] = ds.Tables[0].Rows[0]["class_teach_id"].ToString();
            }
            conn.Close();
            return class_tb;
        }
       
    }
}