and use it in procedure to display only current logged in user details only
Please Help..
Registered Employee Login Form .aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPageHeaderFooter.master" AutoEventWireup="true" CodeFile="Registered Employee Login Form.aspx.cs" Inherits="_Default" %>
Employee Login ID : | ||
Password : | | |
Registered Employee Login Form .aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.Security;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ButtonRegisteredEmployeeLoginFormLogin_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (AuthenticateAdministrator(TextBoxRegisteredEmployeeLoginFormUserID.Text, TextBoxRegisteredEmployeeLoginFormPassword.Text))
{
FormsAuthentication.RedirectFromLoginPage(TextBoxRegisteredEmployeeLoginFormUserID.Text, CheckBoxRememberMe.Checked);
Response.Redirect("~/Registered Employee/Registered Employee Page.aspx");
}
else
{
LabelLoginFailedMessage.Text = "Login Data is are Not Correct Please Try Again.";
}
}
}
private bool AuthenticateAdministrator(string EmployeeID, string EmployeePassword)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection Con = new SqlConnection(CS))
{
SqlCommand Cmd = new SqlCommand("spEmployeeLogin", Con);
Cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter ParaEmployeeID = new SqlParameter("@EmployeeID", EmployeeID.ToString());
SqlParameter ParaEmployeePassword = new SqlParameter("@EmployeePassword", EmployeePassword.ToString());
Cmd.Parameters.Add(ParaEmployeeID);
Cmd.Parameters.Add(ParaEmployeePassword);
Con.Open();
int ReturnCode = Convert.ToInt32(Cmd.ExecuteScalar());
return ReturnCode == 1;
}
}
protected void CheckBoxRememberMe_CheckedChanged(object sender, EventArgs e)
{
}
}
Register Employee Page.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPageHeaderFooter.master" AutoEventWireup="true" CodeFile="Registered Employee Page.aspx.cs" Inherits="_Default" %>
Register Employee Page.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.Security;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection Con = new SqlConnection(CS))
{
Con.Open();
SqlCommand Cmd = new SqlCommand("spShowDataToLoggedInEmployee", Con);
Cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader Rdr = Cmd.ExecuteReader();
GridView1.DataSource = Rdr;
GridView1.DataBind();
}
}
}
Database Files
Employee Details Table
Create Table EmployeeDetails
(EmployeeID Integer Primary Key IDENTITY(0001,1),
EmployeeFirstName Varchar(15) Not Null,
EmployeeMiddleName Varchar(15),
EmployeeLastName Varchar(15),
EmployeeGender Char(6) Not Null,
EmployeeEmailAddress Varchar(40) Not Null,
EmployeeMobileNumber Varchar(50) Not Null,
EmployeeAddress Varchar(100) Not Null,
EmployeeState Char(25) Not Null,
EmployeeCity Char(20) Not Null,
EmployeePinCode Integer Not Null)
Go
Procedure to show logged in employee Data
Create Procedure spShowDataToLoggedInEmployee
as
Begin
Select EmployeeID as [Employee ID],
EmployeeFirstName as [First Name],
EmployeeMiddleName as [Middle Name],
EmployeeLastName as [Last Name],
EmployeeGender as [Gender],
EmployeeEmailAddress as [Email Adderss],
EmployeeMobileNumber as [Mobile Number],
EmployeeAddress as [Address],
EmployeeState as [State],
EmployeeCity as [City],
EmployeePinCode as [Pin Code]
From EmployeeDetails
End
Employee Login Details
Create Table EmployeeLoginDetails
(EmployeeID NVarchar(10) Primary Key,
EmployeePassword NVarchar(16) Not Null)
Go
Procedure Form Employee Login
Create Procedure spEmployeeLogin
@EmployeeID NVarchar(10),
@EmployeePassword NVarchar(16)
as
Begin
Declare @Count int
Select @Count = COUNT(EmployeeID) from EmployeeLoginDetails
Where EmployeeID = @EmployeeID
AndEmployeePassword = @EmployeePassword
if(@Count = 1)
Begin
Select 1 as ReturnCode
End
Else
Begin
Select -1 as ReturnCode
End
End
Lakshmanan Sethu SankaranarayanPosted Apr 1, 2014, 1:53 AM