#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 InsertRecord(void) {

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

	OracleCommand^ cmd = gcnew OracleCommand(
		L"INSERT INTO EmployeeDetails VALUES(16, '伊藤理々杏', 'メンバー', 45.0000)");
	cmd->Connection = conn;

	OracleParameter^ p_empid = gcnew OracleParameter();
	p_empid->OracleDbType = OracleDbType::Int32;
	p_empid->Value = 16;

	cmd->Parameters->Add(p_empid);

	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 = 45.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)
{
	InsertRecord();

	return 0;
}