#include "pch.h"

using namespace System;
using namespace System::Data;
using namespace Oracle::DataAccess::Client;
using namespace Oracle::DataAccess::Types;

/// <summary>
/// レコード更新処理
/// </summary>
/// <param name="">変数名なし</param>
/// <returns>レコードを挿入する</returns>
int UpdateRecord(void) {

	OracleConnection^ conn = gcnew OracleConnection(
		L"user id=scott;password=tiger;data source=localhost/orcl");
	conn->Open();

	OracleCommand^ cmd = gcnew OracleCommand(
		L"UPDATE EmployeeDetails SET EmpName = :EmpName, EmpDesgn = :EmpDesgn, EmpSalary = :EmpSalary " +
	    "WHERE EmpId = 16");
	cmd->Connection = conn;

	OracleParameter^ p_empname = gcnew OracleParameter();
	p_empname->OracleDbType = OracleDbType::Varchar2;
	p_empname->Value = "伊藤理々杏";

	cmd->Parameters->Add(p_empname);

	OracleParameter^ p_empdesgn = gcnew OracleParameter();
	p_empdesgn->OracleDbType = OracleDbType::Varchar2;
	p_empdesgn->Value = "メンバー";

	cmd->Parameters->Add(p_empdesgn);

	OracleParameter^ p_empsalary = gcnew OracleParameter();
	p_empsalary->OracleDbType = OracleDbType::Double;
	p_empsalary->Value = 40.0000;

	cmd->Parameters->Add(p_empsalary);

	Console::WriteLine("----- レコード更新開始 -----\n");

	OracleDataReader^ reader = cmd->ExecuteReader();

	Console::WriteLine("----- レコード更新終了 -----\n");

	reader->Close();

	conn->Close();

	return 0;
}

int main(void)
{
	UpdateRecord();

	return 0;
}