Hjælp med login
Hej Eksperten,Jeg er nybegynder i asp.net, og er ved at "oversætte" mine gamle asp 3.0 filer til asp.net filer. jeg har denne login fil i asp som jeg gerne vil have jeres hjælp til at oversætte til asp.net i C#:
<%
' Henter input data
dim DS
DS = "Active"
User_Ip = Request.ServerVariables("HTTP_X_FORWARDED_FOR")
If User_Ip ="" Then User_Ip = Request.ServerVariables("REMOTE_ADDR")
Session("User_Ip") = User_Ip
UserName = Request.form("username")
PassWord = Request.form("password")
SystemCode = Request.form("systemcode")
' Tjekker Brugernavn og password
UserSQL = "SELECT * FROM Users where User_Name = '" & UserName & "' and User_Password = '" & PassWord & "'"
set User = Conn.execute(UserSQL)
If Not (User.BOF Or User.Eof) Then
Session("User_Id") = User("User_Id")
Session("User_Name") = UserName
Session("User_Password") = PassWord
Session("User_Status") = User("User_Status")
' Tjekker System code
SystemSQL = "SELECT * FROM SystemCode where SystemCode = '" & SystemCode & "'"
set System = Conn.execute(SystemSQL)
If Not (System.BOF Or System.Eof) Then
Session("System_Code_Status") = "ok"
' Tjekker den brugte pc's ip
IpSQL = "SELECT * FROM IP where IP_Num = '"& Session("User_Ip") & "' and IP_Status = 'Active'"
set Ip = Conn.execute(IpSQL)
If Not (Ip.BOF Or Ip.Eof) Then
session("Ip_Status") = "ok"
Ip2SQL = "SELECT * FROM User_IP where IP_Id = '" & Ip("IP_Id") & "' and User_Id = '" & session("User_Id") &"'"
set Ip2 = Conn.execute(Ip2SQL)
If Not (Ip2.BOF Or Ip2.Eof) Then
Session("Login_Status") = null
Session("Login_Done") = "ok"
%>
<!--#include file="login_stat.asp" -->
<%
Response.Redirect("page_content.asp?ConId=0")
Else
Login_Error = "User and Ip mismatch"
%>
<!--#include file="login_error.asp" -->
<%
Session("Login_Status") = "Access denied !! The computer you using and user account is not matching"
Response.Redirect("default.asp")
End If
Else
Login_Error = "Ip is not authorized"
%>
<!--#include file="login_error.asp" -->
<%
'Pc'ens ip er ikke godkendt
Session("Login_Status") = "Access denied !! The computer you using is not authorized"
Response.Redirect("default.asp")
End if
Else
Login_Error = "System Code is not correct"
%>
<!--#include file="login_error.asp" -->
<%
' System code forkert
Session("Login_Status") = "Access denied !! System Code is not correct"
Response.Redirect("default.asp")
End if
Else
' brugernavn eller password forkert
Login_Error = "Username or Password Code is not correct"
%>
<!--#include file="login_error.asp" -->
<%
Session("Login_Status") = "Access denide !! Username or Password is not correct"
Response.Redirect("default.asp")
End If
%>