コード例 #1
0
ファイル: SqlServerDbService.cs プロジェクト: s18732/cw3
        public Boolean CreatePassword(LoginRequest req)
        {
            var id   = req.Login;
            var pass = req.Haslo;

            var salt = IStudentsDbService.CreateSalt();
            var s    = IStudentsDbService.Create(pass, salt);

            using (SqlConnection con = new SqlConnection(ConnString))
                using (SqlCommand com = new SqlCommand())
                {
                    con.Open();
                    SqlTransaction trans = con.BeginTransaction();
                    com.Connection  = con;
                    com.Transaction = trans;
                    try
                    {
                        com.CommandText = "update student set Salt = @salt, Password = @pass where IndexNumber = @id";
                        com.Parameters.AddWithValue("id", id);
                        com.Parameters.AddWithValue("salt", salt);
                        com.Parameters.AddWithValue("pass", s);
                        com.ExecuteNonQuery();
                        trans.Commit();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                        trans.Rollback();
                        return(false);
                    }
                }
            return(true);
        }
コード例 #2
0
ファイル: SqlServerDbService.cs プロジェクト: s18371/cw3
        public string CreatePassword(LoginRequestDto req)
        {
            string login = req.Login;
            string haslo = req.Haslo;
            string salt  = IStudentsDbService.CreateSalt();
            string pass  = IStudentsDbService.Create(haslo, salt);

            using (SqlConnection con = new SqlConnection(ConnString))
                using (SqlCommand com = new SqlCommand())
                {
                    con.Open();
                    SqlTransaction trans = con.BeginTransaction();
                    com.Connection  = con;
                    com.Transaction = trans;
                    try
                    {
                        com.CommandText = "update student set Salt = @salt, Password = @password where IndexNumber = @login";
                        com.Parameters.AddWithValue("login", login);
                        com.Parameters.AddWithValue("salt", salt);
                        com.Parameters.AddWithValue("password", pass);
                        com.ExecuteNonQuery();
                        trans.Commit();
                    }
                    catch (Exception e)
                    {
                        trans.Rollback();
                        return("blad: " + e.ToString());
                    }
                }

            return("Ustawiono bezpieczne haslo");
        }
コード例 #3
0
        public IActionResult RegisterAccount(Student student)
        {
            var salt = _dbService.CreateSalt();

            var hash = _dbService.CreateHash(student.password, salt);


            if (!_dbService.TryHash(student, salt, hash).GetType().Equals("BadRequestObjectResult"))
            {
                return(Ok());
            }

            return(Unauthorized());
        }