using System;
using System.Data.SqlClient;
using System.Data;
namespace AssetManagement
{
	/// <summary>
	/// serviceAgent 的摘要說明。
	/// </summary>
	public class serviceAgent:Connection
	{
		private SqlConnection connConnection;
		public serviceAgent()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}
		public void Open()
		{
			connConnection = new SqlConnection(this.getConnectionString);
			connConnection.Open();
		}
		public int ExecuteSQL(string strCommandString)
		{
			SqlCommand cmdCommand = new SqlCommand(strCommandString,connConnection);
			int nAffected = cmdCommand.ExecuteNonQuery();
			return nAffected;
		}
		public bool addAgent(string agentNo,string agentName,string agentAddress,string agentZipCode,string agentTelNo,string agentFaxNo,string agentEmail,string agentWebSite)
	    {
			SqlCommand cmd = new SqlCommand("AddServiceAgent",this.connConnection);
			cmd.CommandType = CommandType.StoredProcedure;
		    SqlParameter AgentNo = new SqlParameter("@agentNo",System.Data.SqlDbType.VarChar,10);
			AgentNo.Value = agentNo;
			cmd.Parameters.Add(AgentNo);
			SqlParameter AgentName = new SqlParameter("@agentName",System.Data.SqlDbType.VarChar,20);
			AgentName.Value = agentName;
			cmd.Parameters.Add(AgentName);
			SqlParameter AgentAddress = new SqlParameter("@agentAddress",System.Data.SqlDbType.VarChar,30);
			AgentAddress.Value = agentAddress;
			cmd.Parameters.Add(AgentAddress);
			SqlParameter AgentZipCode = new SqlParameter("@agentZipCode",System.Data.SqlDbType.VarChar,20);
			AgentZipCode.Value = agentZipCode;
			cmd.Parameters.Add(AgentZipCode);
			SqlParameter AgentTelNo = new SqlParameter("@agentTelNo",System.Data.SqlDbType.VarChar,20);
			AgentTelNo.Value = agentTelNo;
			cmd.Parameters.Add(AgentTelNo);
			SqlParameter AgentFaxNo = new SqlParameter("@agentFaxNo",System.Data.SqlDbType.VarChar,20);
			AgentFaxNo.Value = agentFaxNo;
			cmd.Parameters.Add(AgentFaxNo);
			SqlParameter AgentEmail = new SqlParameter("@agentEmail",System.Data.SqlDbType.VarChar,20);
			AgentEmail.Value = agentEmail;
			cmd.Parameters.Add(AgentEmail);
			SqlParameter AgentWebSite = new SqlParameter("@agentWebSite",System.Data.SqlDbType.VarChar,20);
			AgentWebSite.Value = agentWebSite;
			cmd.Parameters.Add(AgentWebSite);
			try
			{
				cmd.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
	    }
		public bool modifyAgent(string agentNo,string agentName,string agentAddress,string agentZipCode,string agentTelNo,string agentFaxNo,string agentEmail,string agentWebSite)
		{
			SqlCommand cmd = new SqlCommand("modifyAgent",this.connConnection);
			cmd.CommandType = CommandType.StoredProcedure;
			SqlParameter AgentNo = new SqlParameter("@agentNo",System.Data.SqlDbType.VarChar,10);
			AgentNo.Value = agentNo;
			cmd.Parameters.Add(AgentNo);
			SqlParameter AgentName = new SqlParameter("@agentName",System.Data.SqlDbType.VarChar,20);
			AgentName.Value = agentName;
			cmd.Parameters.Add(AgentName);
			SqlParameter AgentAddress = new SqlParameter("@agentAddress",System.Data.SqlDbType.VarChar,30);
			AgentAddress.Value = agentAddress;
			cmd.Parameters.Add(AgentAddress);
			SqlParameter AgentZipCode = new SqlParameter("@agentZipCode",System.Data.SqlDbType.VarChar,20);
			AgentZipCode.Value = agentZipCode;
			cmd.Parameters.Add(AgentZipCode);
			SqlParameter AgentTelNo = new SqlParameter("@agentTelNo",System.Data.SqlDbType.VarChar,20);
			AgentTelNo.Value = agentTelNo;
			cmd.Parameters.Add(AgentTelNo);
			SqlParameter AgentFaxNo = new SqlParameter("@agentFaxNo",System.Data.SqlDbType.VarChar,20);
			AgentFaxNo.Value = agentFaxNo;
			cmd.Parameters.Add(AgentFaxNo);
			SqlParameter AgentEmail = new SqlParameter("@agentEmail",System.Data.SqlDbType.VarChar,20);
			AgentEmail.Value = agentEmail;
			cmd.Parameters.Add(AgentEmail);
			SqlParameter AgentWebSite = new SqlParameter("@agentWebSite",System.Data.SqlDbType.VarChar,20);
			AgentWebSite.Value = agentWebSite;
			cmd.Parameters.Add(AgentWebSite);
			try
			{
				cmd.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
		}
		public void Close()
		{
			connConnection.Close();
		}
	}
}