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