public int AddCharacter(int accId, string nickname, string race, string className, char sex)
{
dbConnection.OpenConnection();
OracleCommand cmd = dbConnection.connection.CreateCommand();
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = ProcedureName.BuildProcedureName(PackageType.NORMAL, ProcedureName.add_character);
cmd.BindByName = true;
cmd.Parameters.Add("Return_Value", OracleDbType.Int16, ParameterDirection.ReturnValue);
cmd.Parameters.Add("acc_id", accId);
cmd.Parameters.Add("nick", nickname);
cmd.Parameters.Add("rasa", race);
cmd.Parameters.Add("klasa", className);
cmd.Parameters.Add("plec", sex);
cmd.ExecuteNonQuery();
return(Convert.ToInt16(cmd.Parameters["Return_value"].Value.ToString()));
}
catch (OracleException ex)
{
Console.WriteLine("Cannot run procedure!");
Console.WriteLine("Exception message: " + ex.Message);
Console.WriteLine("Exception source: " + ex.Source);
return(-1);
}
}
public int GeneratePosition()
{
dbConnection.OpenConnection();
OracleCommand cmd = dbConnection.connection.CreateCommand();
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = ProcedureName.BuildProcedureName(PackageType.NORMAL, ProcedureName.generate_position);
cmd.BindByName = true;
cmd.Parameters.Add("Return_Value", OracleDbType.Int16, ParameterDirection.ReturnValue);
cmd.ExecuteNonQuery();
return(Convert.ToInt16(cmd.Parameters["Return_value"].Value.ToString()));
}
catch (OracleException ex)
{
Console.WriteLine("Cannot run procedure!");
Console.WriteLine("Exception message: " + ex.Message);
Console.WriteLine("Exception source: " + ex.Source);
return(-1);
}
}
public bool CheckIsAccountExists(int id)
{
dbConnection.OpenConnection();
OracleCommand cmd = dbConnection.connection.CreateCommand();
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = ProcedureName.BuildProcedureName(PackageType.NORMAL, ProcedureName.check_is_account_exists);
cmd.BindByName = true;
cmd.Parameters.Add("Return_Value", OracleDbType.Int16, ParameterDirection.ReturnValue);
cmd.Parameters.Add("acc_id", id);
cmd.ExecuteNonQuery();
return(Convert.ToBoolean(Convert.ToInt16(cmd.Parameters["Return_value"].Value.ToString())));
}
catch (OracleException ex)
{
Console.WriteLine("Cannot run procedure!");
Console.WriteLine("Exception message: " + ex.Message);
Console.WriteLine("Exception source: " + ex.Source);
return(false);
}
}
