<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="CompanyPage.Login" %>
<!DOCTYPE html>
///Login Page///
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.center
{
margin-left:400px;
margin-right:auto;
margin-top:150px;
}
</style>
</head>
<body style="background-color:#E6E6FA">
<form id="form1" runat="server">
<table class="center">
<tr>
<td colspan="2"><h3 align="center">Login Page</h3></td>
</tr>
<tr>
<td colspan="2"><asp:Label ID="lblResult" runat="server" Text=""></asp:Label></td>
</tr>
<tr>
<td>Email Id :</td>
<td><asp:TextBox ID="txtLogin" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Password :</td>
<td><asp:TextBox ID="txtPassword" runat="server" ></asp:TextBox></td>
</tr>
<tr>
<td><asp:Button ID="btnSubmit" runat="server" Text="Submit"
onclick="btnSubmit_Click" /></td>
<td><asp:Button ID="btnReset" runat="server" Text="Reset" /></td>
</tr>
<tr>
<td>
<asp:HyperLink ID="hlRegistration" runat="server" NavigateUrl="RegistrationDetail.aspx">New Registration</asp:HyperLink>
</td>
<td>
<asp:HyperLink ID="hlForgotPassword" runat="server"
NavigateUrl="~/ForgotPassword.aspx">Forgot Password</asp:HyperLink>
</td>
</tr>
</table>
</form>
</body>
</html>
namespace CompanyPage
{
public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings ["LoginConnectionString"].ConnectionString);
conn.Open();
string checkPasswordQuery = "select password from login where password='" + txtPassword.Text + "'";
SqlCommand passComm = new SqlCommand(checkPasswordQuery, conn);
string password = passComm.ExecuteScalar().ToString();
if (password == txtPassword.Text)
{
Session["New"] = txtPassword.Text;
Response.Write("Password is correct");
Response.Redirect("Main.aspx");
Server.Transfer("Main.aspx");
}
else
{
Response.Write("Password is not correct");
}
}
}
}
///Registration Page///
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="RegistrationDetail.aspx.cs" Inherits="CompanyPage.Registration_Detail" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style>
.center {
margin-left:400px;
margin-right:auto;
margin-top:100px;
border-width:2px;
}
</style>
</head>
<body style="background-color:#EEE8AA">
<form id="form1" runat="server">
<table class ="center">
<tr>
<td class="style1" colspan="2">
<h1 style="color:blue;"><strong>Registration Details</strong></h1></td>
</tr>
<tr>
<td class="style1" colspan="2">
</td>
</tr>
<tr>
<td class="style2">
Name :</td>
<td class="style3">
<asp:TextBox ID="txtname" runat="server" Text=""></asp:TextBox>
</td>
</tr>
<tr>
<td>
DOB :</td>
<td class="style4">
<asp:TextBox ID="txtDOB" runat="server" Text=""></asp:TextBox>
</td>
</tr>
<tr>
<td>
Gender :</td>
<td class="style4">
<asp:TextBox ID="txtGender" runat="server" Text=""></asp:TextBox>
</td>
</tr>
<tr>
<td>
Email ID :</td>
<td class="style4">
<asp:TextBox ID="txtEmail" runat="server" Text=""></asp:TextBox>
</td>
</tr>
<tr>
<td>
Password :</td>
<td>
<asp:TextBox ID="txtPassword" runat="server" Text=""></asp:TextBox>
</td>
</tr>
<tr>
<td><asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" />
</td>
</tr>
</table>
</form>
</body>
</html>
namespace CompanyPage
{
public partial class Registration_Detail : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings ["RegistrationConnectionString"].ConnectionString);
conn.Open();
string checkuser = "select count (*) from UserData where Email='" + txtEmail.Text + "'";
SqlCommand com = new SqlCommand(checkuser, conn);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
if (temp == 1)
{
Response.Write("User Exists");
}
conn.Close();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try {
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings ["RegistrationConnectionString"].ConnectionString);
conn.Open();
string insertQuery = "insert into UserData(Name,Email,Password,Gender) values (@name,@email,@password,@gender)";
SqlCommand com = new SqlCommand(insertQuery, conn);
com.Parameters.AddWithValue("@name", txtname.Text);
com.Parameters.AddWithValue("@email", txtEmail.Text);
com.Parameters.AddWithValue("@password", txtPassword.Text);
com.Parameters.AddWithValue("@gender", txtGender.Text);
com.ExecuteNonQuery();
Response.Write("Registration Successful");
Response.Redirect("Employee.aspx");
Server.Transfer("Employee.aspx");
conn.Close();
}
catch (Exception ex)
{
Response.Write("Error:" +ex.ToString());
}
}
}
}