using System;
using System.Data;
using System.Collections;
using System.Data.SqlClient;
using System.Windows.Forms;
using ExamCenter.ADLCTier;

namespace ExamCenter.BLCTier
{
	/// <summary>
	/// RoleBLC 的摘要說明。
	/// </summary>
	public class RoleBLC : BaseADLC
	{
		//一些要執行的sql語句
		private const string SQL_SELECT_ALL_ROLES = "SELECT * FROM role";
		private string SQL_SELECT_ROLE_BY_ID = "SELECT * FROM role WHERE roleID =";
		private string SQL_SELECT_USECASE_BY_ID = "SELECT * FROM allcoateusecase WHERE roleID =";
		
     
		public RoleBLC()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}

		public DataSet GetRoleById(int intRoleId)
		{
			//方法：public DataSet GetRoleById(int intRoleId)
			//參數：intRoleId為角色id
			//功能：根據角色id返回角色信息
			//返回：數據集

			//執行SQL_SELECT_ROLE_BY_ID查詢語句，返回角色
			SQL_SELECT_ROLE_BY_ID = SQL_SELECT_ROLE_BY_ID + intRoleId.ToString();
			return RoleBLC.ExecuteSqlReturnDs(SQL_SELECT_ROLE_BY_ID);
		}

		public DataSet GetAllRole()
		{
			//方法：public DataSet GetAllRole()
			//功能：返回角色表
			//返回：數據集
            
			//執行查詢語句SQL_SELECT_ALL_ROLES，返回角色表
			return RoleBLC.ExecuteSqlReturnDs(SQL_SELECT_ALL_ROLES);
		}
		
		public void UpdateRole(DataSet role)
		{
			//方法：public void UpdateRole(DataSet role)
			//功能：更新角色表

			RoleBLC.UpdateDataSource(role,SQL_SELECT_ALL_ROLES);
		}

		public DataSet GetAllUseCaseForRole(int intRoleId)
		{
			//方法 ：public void GetAllUseCaseForRole(string strRoleId)
			//參數 ：strRoleId為角色ID
			//功能 ：為此角色返回用例集
			//返回值：數據集
		
			SQL_SELECT_USECASE_BY_ID = SQL_SELECT_USECASE_BY_ID + intRoleId.ToString();
			return RoleBLC.ExecuteSqlReturnDs(SQL_SELECT_USECASE_BY_ID);
		}
		
		public void UpdateUseCaseForRole(DataSet dsUseCaseForRole,int intRoleId)
		{
			//方法 ：public void UpdateUseCase(DataSet dsUseCase)
			//參數 ：dsUseCase為要更改的數據集
			//功能 ：更改數據源
			//返回值：空
			SQL_SELECT_USECASE_BY_ID = SQL_SELECT_USECASE_BY_ID + intRoleId.ToString();
			RoleBLC.UpdateDataSource(dsUseCaseForRole,SQL_SELECT_USECASE_BY_ID);
		}

		public IList FindUseCaseIdsByRoleId(int intRoleId)
		{
			// 方法  ：public IList FindUseCaseIdsByRoleId(int intRoleId)
			// 參數  ：intRoleId是角色ID
			// 功能  ：通過角色ID查找到用例的ID
			// 返回值：IList（含有用例的所有ID）			
			IList ilistUseCaseIds = new ArrayList();
         
			string sqlSelectCommand="SELECT * FROM allcoateusecase WHERE roleID="+intRoleId.ToString ();
			DataSet dsUseCase=RoleBLC.ExecuteSqlReturnDs(sqlSelectCommand);

			foreach (DataRow dr in dsUseCase.Tables [0].Rows )
			{
				ilistUseCaseIds.Add (dr["usecaseID"]);
			}

			return ilistUseCaseIds;
		}

		public IList FindUseCaseIdsByRoleIds(IList iliRoleId)
		{
			//要返回的功能id列表
			IList ilistUseCaseIds = new ArrayList();
			//對于角色id列表中的任一角色id，找出其功能id，
			//如果在ilistUseCaseIds功能id列表中沒有此功能id，就添加
			foreach( int intRoleID in iliRoleId)
			{
				IList ilistTemp=this.FindUseCaseIdsByRoleId (intRoleID);
				foreach(int intUseCaseID in ilistTemp)
				{
					if (false == ilistUseCaseIds.Contains(intUseCaseID))
						ilistUseCaseIds.Add(intUseCaseID);
				}
			}
			return ilistUseCaseIds;
		}

	}
}