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); } }