public void RegisterUser(RegisterForm RegisterForm)
{
// 既に登録済みのデータか確認
UserSearchService SearchService = new UserSearchService();
UserDto UserInfoDto = SearchService.SearchUserWithPrimaryKeyUserId(RegisterForm.UserId);
if (UserInfoDto != null)
{
// ユーザ情報が存在する場合
Console.WriteLine("ユーザー情報がありません.");
return;
}
OracleConnection Connection = null;
try
{
// 接続文字列の取得(Web.configから取得)
string ConnectionString = ConfigurationManager.ConnectionStrings["OracleConnectionString"].ConnectionString;
// DB接続の準備
Connection = new OracleConnection(ConnectionString);
// DB接続開始
Connection.Open();
// SQL生成
string RegisterSql = "INSERT INTO USER_MNG.USER_MNG_TBL(USER_ID, PASSWORD, USER_NAME, USER_GENDER, REGISTER_PROG_ID, REGISTER_USER_ID, REGISTER_DATE, UPDATE_PROG_ID, UPDATE_USER_ID, UPDATE_DATE) "
+ "VALUES (:USER_ID, :PASSWORD, :USER_NAME, :USER_GENDER, :REGISTER_PROG_ID, :REGISTER_USER_ID, :REGISTER_DATE, :UPDATE_PROG_ID, :UPDATE_USER_ID, :UPDATE_DATE)";
// 実行するSQLの準備
OracleCommand Command = new OracleCommand(RegisterSql, Connection);
Command.Parameters.Add(new OracleParameter(":USER_ID", RegisterForm.UserId));
Command.Parameters.Add(new OracleParameter(":PASSWORD", RegisterForm.Password));
Command.Parameters.Add(new OracleParameter(":USER_NAME", RegisterForm.UserName));
Command.Parameters.Add(new OracleParameter(":USER_GENDER", RegisterForm.UserGender));
Command.Parameters.Add(new OracleParameter(":REGISTER_PROG_ID", "REGISTER"));
Command.Parameters.Add(new OracleParameter(":REGISTER_USER_ID", RegisterForm.UserId));
Command.Parameters.Add(new OracleParameter(":REGISTER_DATE", DateTime.Now));
Command.Parameters.Add(new OracleParameter(":UPDATE_PROG_ID", "REGISTER"));
Command.Parameters.Add(new OracleParameter(":UPDATE_USER_ID", RegisterForm.UserId));
Command.Parameters.Add(new OracleParameter(":UPDATE_DATE", DateTime.Now));
// SQL実行
Command.ExecuteNonQuery();
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
throw;
}
finally
{
// DB接続終了
Connection.Close();
Connection.Dispose();
}
}
/// <summary>
/// ユーザ情報更新
/// </summary>
/// <param name="EditForm"></param>
public void UpdateUserWithPrimaryKey(EditForm EditForm)
{
// ユーザ情報が存在することを確認
UserSearchService SearchService = new UserSearchService();
UserDto UserInfoDto = SearchService.SearchUserWithPrimaryKeyUserId(EditForm.UserId);
if (UserInfoDto == null)
{
// ユーザ情報が存在しない場合
return;
}
OracleConnection Connection = null;
try
{
// 接続文字列の取得(Web.configから取得)
string ConnectionString = ConfigurationManager.ConnectionStrings["OracleConnectionString"].ConnectionString;
// DB接続の準備
Connection = new OracleConnection(ConnectionString);
// DB接続開始
Connection.Open();
// トランザクション開始
OracleTransaction Transaction = Connection.BeginTransaction();
// SQL生成
string UpdateSql = "UPDATE USER_MNG.USER_MNG_TBL SET USER_NAME = :USER_NAME, USER_GENDER = :USER_GENDER, UPDATE_PROG_ID = :UPDATE_PROG_ID, UPDATE_USER_ID = :UPDATE_USER_ID, UPDATE_DATE = :UPDATE_DATE "
+ "WHERE USER_ID = :USER_ID";
// 実行するSQLの準備
OracleCommand Command = new OracleCommand(UpdateSql, Connection);
// パラメータ値の設定
Command.Parameters.Add(new OracleParameter(":USER_NAME", EditForm.UserName));
Command.Parameters.Add(new OracleParameter(":USER_GENDER", EditForm.UserGender));
Command.Parameters.Add(new OracleParameter(":UPDATE_PROG_ID", "UPDATE"));
Command.Parameters.Add(new OracleParameter(":UPDATE_USER_ID", EditForm.UserId));
Command.Parameters.Add(new OracleParameter(":UPDATE_DATE", DateTime.Now));
Command.Parameters.Add(new OracleParameter(":USER_ID", EditForm.UserId));
// SQL実行
Command.ExecuteNonQuery();
Transaction.Commit();
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
throw;
}
finally
{
// DB接続終了
Connection.Close();
Connection.Dispose();
}
}
