using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
namespace PK
{
	/// <summary>
	/// checkClass 的摘要說明。
	/// </summary>
	public class checkClass
	{
		public checkClass()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}
		private ArrayList clist;
		public ArrayList Clist
		{
			get
			{
				return clist;
			}
		}
		public void initUse()
		{
			foreach (Class c in this.clist)
			{
				c.IsUse = true;
			}
		}
		public void addClass()
		{
			Connection co = new Connection();
			SqlConnection conn = new SqlConnection(co.getConnectionString);
			conn.Open();
			string str =  "select * from class";
			SqlCommand cm = new SqlCommand(str,conn);
			SqlDataReader dr = cm.ExecuteReader();
			Class c = null;
			if (clist != null)
			{
				while (dr.Read())
				{
					c = new Class();
					c.ClassNo = Convert.ToString(dr["classNo"]);
					c.ContainNum = Convert.ToInt32(dr["containNum"]);
					c.IsUse = true;
					clist.Add(c);
					c = null;
				}
				dr.Close();
			}
			else
			{
				clist = new ArrayList();
				while (dr.Read())
				{
					c = new Class();
					c.ClassNo = Convert.ToString(dr["classNo"]);
					c.ContainNum = Convert.ToInt32(dr["containNum"]);
					c.IsUse = true;
					clist.Add(c);
					c = null;
				}
				dr.Close();
			}
			conn.Close();
		}
		public int chooseClass(course co)
		{
			Class cnear = null;
			bool flag = true;
			foreach (Class c in this.clist)
			{
				if (co.StudentNum <= c.ContainNum)
				{
					if (flag)
					{
						cnear = c;
						flag = false;
					}
					else
					{
						if (cnear.ContainNum - c.ContainNum > 0)
							cnear = c;
					}
				}
			}
			this.initUse();
			if (flag)
				return 0;
			else
			{
				co.ClassNo = cnear.ClassNo;
				return 1;
			}
		}
		public  int chooseClass(course co,ArrayList Course,string temp)
		{
			Class cnear = null;
			bool flag = true;
			foreach (course cou in Course)
			{
				if (temp != null&&cou.ClassTime!=null)
				{
					if (temp == cou.ClassTime.Substring(0,2))
					{
						foreach (Class cl in this.clist)
						{
							if (cou.ClassNo != null)
							{
								if (cou.ClassNo == cl.ClassNo)
								{
									cl.IsUse = false;
								}
							}
						}
					}
					if (cou.ClassTime.Length == 4)
					{
						if (temp == cou.ClassTime.Substring(2,2))
						{
							foreach (Class cl in this.clist)
							{
								if (cou.ClassNo != null)
								{
									if (cou.ClassNo == cl.ClassNo)
									{
										cl.IsUse = false;
									}
								}
							}
						}
					}
				}
			}
			foreach (Class c in this.clist)
			{
				if (c.IsUse)
				{
					if (co.StudentNum <= c.ContainNum)
					{
						if (flag)
						{
							cnear = c;
							flag = false;
						}
						else
						{
							if (cnear.ContainNum - c.ContainNum > 0)
								cnear = c;
						}
					}
				}
			}
			this.initUse();
			if (cnear == null)
				return 0;
			else
			{
				co.ClassNo = cnear.ClassNo;
				co.ClassTime += temp;
				return 1;
			}
		}
	}
}