using System;
using CallCenter.DALFactory;
using CallCenter.IDAL;
using CallCenter.Modules;
using System.Collections;
using System.Data;

namespace CallCenter.BusinessLayer
{
	/// <summary>
	/// 服務商服務記錄數據操作類
	/// </summary>
	public class SPServiceNoteBLL
	{
		private ISPServiceNote dal = SPServiceNoteDAL.Create();
		public SPServiceNoteBLL()
		{
			// 
			// TODO: 在此處添加構造函數邏輯
			//
		}

		/// <summary>
		/// 添加服務記錄信息
		/// 判斷若已有滿意度，則先更新滿意度
		/// </summary>
		/// <param name="info"></param>
		/// <returns>服務記錄的編號</returns>
		public int addSPServiceNote(SPServiceNoteInfo info)
		{
			try
			{
				if(info.grade != 0){
					ServiceProviderBLL spb = new ServiceProviderBLL();
					spb.changeServiceProviderGrade(info.sid,info.grade);
				}
				return dal.addSPServiceNote(info);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		/// <summary>
		/// 更新指定服務記錄編號的服務記錄信息
		/// </summary>
		/// <param name="info">包含服務編號</param>
		public void updateSPServiceNote(SPServiceNoteInfo info)
		{
			try
			{
				dal.updateSPServiceNote(info);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		/// <summary>
		/// 刪除指定編號的服務記錄
		/// </summary>
		/// <param name="ids">以“,”分隔的服務記錄編號字符串</param>
		public void delSPServiceNoteById(string ids)
		{
			try
			{
				dal.delSPServiceNoteById(ids);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		/// <summary>
		/// 刪除指定服務商的服務記錄
		/// </summary>
		/// <param name="sids">以“,”分隔的服務商編號字符串</param>
		public void delSPServiceNoteBySIds(string sids)
		{
			try
			{
				dal.delSPServiceNoteBySIds(sids);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		/// <summary>
		/// 檢索指定編號的服務記錄信息
		/// </summary>
		/// <param name="id">服務記錄編號</param>
		/// <returns>服務記錄信息</returns>
		public SPServiceNoteInfo getSPServiceNoteById(int id)
		{
			try
			{
				return dal.getSPServiceNoteById(id);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		/// <summary>
		/// 檢索指定工單的服務記錄信息
		/// </summary>
		/// <param name="wbid">工單編號</param>
		/// <returns>服務記錄信息的集合，以服務記錄編號升序排列</returns>
		public ArrayList getSPServiceNoteByWBId(int wbid)
		{
			try
			{
				return dal.getSPServiceNoteByWBId(wbid);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		public DataSet getSPServiceNoteByWBId_DataSet(int wbid,string tableName)
		{
			try
			{
				return dal.getSPServiceNoteByWBId_DataSet(wbid,tableName);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		/// <summary>
		/// 檢索指定服務商的服務記錄
		/// </summary>
		/// <param name="sid">服務商編號</param>
		/// <returns>服務記錄信息的集合，以服務時間降序排列</returns>
		public ArrayList getSPServiceNoteBySId(int sid)
		{
			try
			{
				return dal.getSPServiceNoteBySId(sid);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		public DataSet getSPServiceNoteBySId_DataSet(int sid,string tableName)
		{
			try
			{
				return dal.getSPServiceNoteBySId_DataSet(sid,tableName);
			}
			catch(Exception e)
			{
				throw e;
			}
		}
	}
}