Exemple #1
0
 public static void Logout()
 {
     _account = null;
 }
Exemple #2
0
        //
        // Constructors
        //
        #region Constructors

        /// <summary>
        /// Initializes the members of this instance.
        /// </summary>
        static Globals()
        {
            _database = new SQLServerDatabase(@"Gamer-PC\SQLEXPRESS", "HCS");
            _account = null;
            _kwh = 0;
            _microcontroller = null;
            /*bool flag = false;
            foreach (ConnectionStringSettings css in ConfigurationManager.ConnectionStrings)
            {
                try
                {
                    _database = new SQLServerDatabase(css.ConnectionString);
                    flag = true;
                    break;
                }
                catch { }
            }
            if (!flag) throw new ArgumentException("No connection string was valid.");*/
        }
Exemple #3
0
        //
        // Methods
        //
        #region Methods

        //
        // Accounts
        //
        #region Accounts
        public static async Task<bool> Login(string username, string password)
        {
            var salt = await _database.CallSPScalarAsync("Salt", "Accounts_GetSalt",
                new SqlParameter("@Username", SqlDbType.Char, 16) { Value = username.Trim().Truncate(16) });
            if (salt == null) return false;
            var hashed = Hash.ComputeHash(password, Hash.Algorithms["SHA512"], System.Text.Encoding.UTF8.GetBytes(salt.ToString()));
            var table = await _database.CallSPReaderAsync("Account", "Accounts_Login", new SqlParameter("@Username", SqlDbType.Char, 16) { Value = username.Trim().Truncate(16) }, new SqlParameter("@Password", SqlDbType.Char, 96) { Value = hashed });
            _account = new Account(
                (int)table.Rows[0]["AccountID"],
                table.Rows[0]["Username"].ToString().Trim(),
                table.Rows[0]["Password"].ToString().Trim(),
                table.Rows[0]["Salt"].ToString().Trim(),
                table.Rows[0]["AccountType"].ToString().Trim(),
                (bool)table.Rows[0]["Active"]);
            return (salt != null && hashed != null && table != null);
            //var hashed = Hash.ComputeHash(password, Hash.Algorithms["SHA512"], System.Text.Encoding.UTF8.GetBytes(salt.ToString()));
            //System.Threading.Thread.Sleep(1000);
            //return salt != null;
        }