using System;
using System.Data;
using System.Data.SqlClient;
namespace PK
{
	/// <summary>
	/// dealClass 的摘要說明。
	/// </summary>
	public class dealClass:Connection
	{
		public dealClass()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}
		private SqlConnection connConnection;
		public SqlConnection getConnection
		{
			get
			{
				return new SqlConnection(this.getConnectionString);
			}
			set
			{
			}
		}
		public void Open()
		{
			connConnection = this.getConnection;
			connConnection.Open();
		}
		public void Close()
		{
			connConnection.Close();
		}
		public bool AddClassInfo(string classNo,int containNum)
		{
			SqlCommand command = new SqlCommand("addClass",this.connConnection);
			command.CommandType = CommandType.StoredProcedure;
			SqlParameter ClassNo = new SqlParameter("@classNo",SqlDbType.VarChar,20);
			ClassNo.Value = classNo;
			command.Parameters.Add(ClassNo);
			SqlParameter ContainNum = new SqlParameter("@containNum",SqlDbType.Int,4);
			ContainNum.Value = containNum;
			command.Parameters.Add(ContainNum);
			try
			{
				command.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
		}
		public bool DeleteClassInfo(string classNo)
		{
			SqlCommand command = new SqlCommand("deleteClass",this.connConnection);
			command.CommandType = CommandType.StoredProcedure;
			SqlParameter ClassNo = new SqlParameter("@classNo",SqlDbType.VarChar,20);
			ClassNo.Value = classNo;
			command.Parameters.Add(ClassNo);
			try
			{
				command.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
		}
	}
}