public void InsertUser(Person person, int addId)
{
var sql = "INSERT INTO DBUser(FIRSTNAME, SURNAME, BIRTH_DATE, PHONE, EMAIL, USER_PASSWORD, TIME_CREATED, ROLE_ROLE_ID, ADDRESS_ADDRESS_ID, SALT) VALUES (:fName, :sName, :bd, :phone, :email, :pw, :created, :role, :aID, :salt)";
var cmd = new OracleCommand(sql, Connection)
{
CommandType = CommandType.Text
};
var salt = RandomUtils.RandomSalt(30);
var pass = HashUtils.ComputeSha256Hash(HashUtils.SaltPassword("password", salt));
var parameters2 = new []
{
new OracleParameter {
OracleDbType = OracleDbType.NVarchar2, Value = person.FirstName
},
new OracleParameter {
OracleDbType = OracleDbType.NVarchar2, Value = person.LastName
},
new OracleParameter {
OracleDbType = OracleDbType.Date, Value = person.BirthDate
},
new OracleParameter {
OracleDbType = OracleDbType.NVarchar2, Value = person.PhoneNumber
},
new OracleParameter {
OracleDbType = OracleDbType.NVarchar2, Value = person.Email
},
new OracleParameter {
OracleDbType = OracleDbType.NVarchar2, Value = pass
},
new OracleParameter {
OracleDbType = OracleDbType.Date, Value = DateTime.Now
},
new OracleParameter {
OracleDbType = OracleDbType.Int32, Value = "3"
},
new OracleParameter {
OracleDbType = OracleDbType.Int32, Value = addId.ToString()
},
new OracleParameter {
OracleDbType = OracleDbType.NVarchar2, Value = salt
}
};
cmd.Parameters.AddRange(parameters2);
Connection.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Connection.Close();
}
Connection.Close();
}
internal static string GetUID(this ItemDrop.ItemData self)
{
var stringBuilder = new StringBuilder();
stringBuilder.AppendLine(self.m_dropPrefab.name);
stringBuilder.AppendLine(self.m_stack.ToString(CultureInfo.InvariantCulture));
stringBuilder.AppendLine(self.m_durability.ToString(CultureInfo.InvariantCulture));
stringBuilder.AppendLine(self.m_equiped.ToString(CultureInfo.InvariantCulture));
stringBuilder.AppendLine(self.m_quality.ToString(CultureInfo.InvariantCulture));
stringBuilder.AppendLine(self.m_variant.ToString(CultureInfo.InvariantCulture));
stringBuilder.AppendLine(self.m_crafterID.ToString(CultureInfo.InvariantCulture));
stringBuilder.AppendLine(self.m_crafterName);
return(HashUtils.ComputeSha256Hash(stringBuilder.ToString()));
}
