using System;
using System.Data.SqlClient;
using System.Data;
namespace AssetManagement
{
	/// <summary>
	/// maintenance 的摘要說明。
	/// </summary>
	public class maintenance:Connection
	{
		private SqlConnection connConnection;
		public maintenance()
		{
			//
			// 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 void Close()
		{
			connConnection.Close();
		}
	  public bool addMaintenance(string maintenanceNo,string agentNo,string assetNo,string employeeNo,string maintenanceDate,string maintenanceDescription,string maintenanceCost)
		{
			SqlCommand mycommand = new SqlCommand("AddMaintenance",connConnection);
			mycommand.CommandType = CommandType.StoredProcedure;
			SqlParameter MaintenanceNo = new SqlParameter("@maintenanceNo",SqlDbType.VarChar,10);
		    MaintenanceNo.Value = maintenanceNo;
		    mycommand.Parameters.Add(MaintenanceNo);
		  SqlParameter AgentNo = new SqlParameter("@agentNo",SqlDbType.VarChar,10);
		  AgentNo.Value = agentNo;
		   mycommand.Parameters.Add(AgentNo);
		  SqlParameter AssetNo = new SqlParameter("@assetNo",SqlDbType.VarChar,10);
		  AssetNo.Value = assetNo;
		   mycommand.Parameters.Add(AssetNo);
		  SqlParameter EmployeeNo = new SqlParameter("@employeeNo",SqlDbType.VarChar,10);
		  EmployeeNo.Value = employeeNo;
		   mycommand.Parameters.Add(EmployeeNo);

		  SqlParameter Maintenancedate = new SqlParameter("@maintenanceDate",SqlDbType.VarChar,20);
		  Maintenancedate.Value = maintenanceDate;
		   mycommand.Parameters.Add(Maintenancedate);

		  SqlParameter MaintenanceDescription = new SqlParameter("@maintenanceDescription",SqlDbType.VarChar,50);
		  MaintenanceDescription.Value = maintenanceDescription;
		   mycommand.Parameters.Add(MaintenanceDescription);

		  SqlParameter MaintenanceCost = new SqlParameter("@maintenanceCost",SqlDbType.Float,8);
		  try
		  {
			  MaintenanceCost.Value = float.Parse(maintenanceCost);
			    mycommand.Parameters.Add(MaintenanceCost);
		  }
		  catch
		  {
             return false;
		  }

		  try
		  {
			  mycommand.ExecuteNonQuery();
			  return true;
		  }
		  catch
		  {
			  return false;
		  }
		} 
		public bool addMaintenance1(string maintenanceNo,string assetNo,string employeeNo,string maintenanceDate,string maintenanceDescription,string maintenanceCost)
		{
			SqlCommand mycommand = new SqlCommand("AddMaintenance1",connConnection);
			mycommand.CommandType = CommandType.StoredProcedure;
			SqlParameter MaintenanceNo = new SqlParameter("@maintenanceNo",SqlDbType.VarChar,10);
			MaintenanceNo.Value = maintenanceNo;
			mycommand.Parameters.Add(MaintenanceNo);
			SqlParameter AssetNo = new SqlParameter("@assetNo",SqlDbType.VarChar,10);
			AssetNo.Value = assetNo;
			mycommand.Parameters.Add(AssetNo);
			SqlParameter EmployeeNo = new SqlParameter("@employeeNo",SqlDbType.VarChar,10);
			EmployeeNo.Value = employeeNo;
			mycommand.Parameters.Add(EmployeeNo);

			SqlParameter Maintenancedate = new SqlParameter("@maintenanceDate",SqlDbType.VarChar,20);
			Maintenancedate.Value = maintenanceDate;
			mycommand.Parameters.Add(Maintenancedate);

			SqlParameter MaintenanceDescription = new SqlParameter("@maintenanceDescription",SqlDbType.VarChar,50);
			MaintenanceDescription.Value = maintenanceDescription;
			mycommand.Parameters.Add(MaintenanceDescription);

			SqlParameter MaintenanceCost = new SqlParameter("@maintenanceCost",SqlDbType.Float,8);
			try
			{
				MaintenanceCost.Value = float.Parse(maintenanceCost);
				mycommand.Parameters.Add(MaintenanceCost);
			}
			catch
			{
				return false;
			}

			try
			{
				mycommand.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
		} 

	}
}