using System;
using System.Data.OleDb;
using StudentsMIS.DataAccess;

namespace StudentsMIS.Business
{
	/// <summary>
	/// AwardManager實現了Awards表的選、增、刪、改。
	/// </summary>
	public class AwardManager
	{
		public AwardManager()
		{
			
		}

    public void Insert(IEntity obj)
    {
      AwardEntity entity = (AwardEntity)obj;
      /*
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select * From students Where student_ID=@StudentID");
      objCommand.Parameters.Add("@StudentID",entity.AwardStudentID);
      if(!objCommand.ExecuteReader().HasRows)
      {
        CommandCloser.CloseOleDbCommand(objCommand);
        return 0;
      }
      */
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Insert Into awards(award_studentID,award_content,award_reason,award_date) Values(@AwardStudentID,@AwardContent,@AwardReason,@AwardDate)");
      objCommand.Parameters.Add("@AwardStudentID",entity.AwardStudentID);
      objCommand.Parameters.Add("@AwardContent",entity.AwardContent);
      objCommand.Parameters.Add("@AwardReason",entity.AwardReason);
      objCommand.Parameters.Add("@AwardDate",entity.AwardDate);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
    }

    public void Delete(string id)
    {
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Delete From awards Where award_ID=@AwardID");
      objCommand.Parameters.Add("@AwardID",id);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
    }

    public void Update(IEntity obj)
    {
      AwardEntity entity = (AwardEntity)obj;
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Update awards Set award_content=@AwardContent,award_reason=@AwardReason Where awards_ID=@AwardsID");
      objCommand.Parameters.Add("@AwardContent",entity.AwardContent);
      objCommand.Parameters.Add("@AwardReason",entity.AwardReason);
      objCommand.Parameters.Add("@AwardID",entity.AwardID);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
    }

	}
}