Project Name INOffice1
Let us take the following steps:
Step (1) : Create a new website. Add a class named Login by right clicking on the solution name in the Solution Explorer and choosing the item 'Class' from the 'Add Item' dialog box. Name it as Login .cs.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Drawing.Imaging;
using System.Text;
namespace INOffice1
{
public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
FillCapctha();
}
}
void FillCapctha()
{
try
{
Random random = new Random();
string combination = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
StringBuilder captcha = new StringBuilder();
for (int i = 0; i < 6; i++)
captcha.Append(combination[random.Next(combination.Length)]);
Session["captcha"] = captcha.ToString();
imgCaptcha.ImageUrl = "GenrateCatch.aspx?" + DateTime.Now.Ticks.ToString();
}
catch
{
throw;
}
}
protected void btnRefresh_Click(object sender, EventArgs e)
{
FillCapctha();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Response.Redirect("REgistration.aspx");
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
Response.Redirect("ForgotPassword.aspx");
}
protected void LoginButton_Click1(object sender, EventArgs e)
{
string Firstname = firstname.Text.Trim();
string Password = password.Text.Trim();
SqlConnection conn = new SqlConnection("Data Source=MYPC-PC\\SQLEXPRESS;Initial Catalog=Rateesh;Integrated Security=True");
conn.Open();
// SqlCommand comm = new SqlCommand("Insert into Time");
SqlCommand com = new SqlCommand("Select * from Employe7");
SqlDataAdapter dd = new SqlDataAdapter(com.CommandText, conn);
DataTable dt = new DataTable();
dd.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
Firstname = dt.Rows[i]["Firstname"].ToString();
Password = dt.Rows[i]["Password"].ToString();
if (Firstname == firstname.Text && Password == password.Text)
{
Session["Firstname"] = Firstname;
if (Session["captcha"].ToString() != txtCaptcha.Text) {
Response.Write("Invalid Captcha Code"); }
else {
Response.Write("Valid Captcha Code");
FillCapctha();
conn.Open();
SqlCommand cmd = new SqlCommand("insert into login_info(Firstname,Login_Time) values('" + firstname.Text + "',getdate())", conn);
Response.Redirect("Welcome.aspx");
cmd.ExecuteNonQuery();
}
}
else
{
TextBox1.Text= "Invalid User Name or Password! Please try again!";
}
}
}
protected void Firstname_TextChanged(object sender, EventArgs e)
{
}
protected void Password_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
}
}
}
The source file should look as the following:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="INOffice1.Login" StylesheetTheme="Themes" %> <%@ Register assembly="Obout.Ajax.UI" namespace="Obout.Ajax.UI.Captcha" tagprefix="obout" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Login</title> <link runat="server" rel="shortcut icon" href="Oxygen-Icons.org-Oxygen-Apps-preferences-desktop-user-password.ico" type="image/x-icon"/> <link runat="server" rel="icon" href="Oxygen-Icons.org-Oxygen-Apps-preferences-desktop-user-password.ico" type="image/ico"/> <script type="javascript"> setInterval(blinktext, 500); var txt = ""; var count = 0; function blinktext() { var cntrl = document.getElementById("txtblinkingtext"); if (count == 0) txt = cntrl.value; if (count % 2 == 0) cntrl.value = ""; else cntrl.value = txt; count++; } </script> <script type="JavaScript1.2"> /* Animated Document title- By Dynamicdrive.com For full source, TOS, and 100s DTHML scripts Visit http://dynamicdrive.com */ if (document.all||document.getElementById){ var thetitle=document.title document.title='' } ////Animation code below ////based on script from http://wsabstract.com/script/script2/statusanimate.shtml var data="0123456789"; var done=1; function statusIn(text){ decrypt(text,2,1); } function statusOut(){ self.status=''; done=1; } //-------------------------\\ //decrypt(string, int, int)\\ //-------------------------\\ // //text(string): the text to be decrypted on //the status bar. // //max(int): the number of times a random string //is displayed before the next character is //'decrypted'. // //delay(int): the number of milliseconds between //each display of a random string // //Example: //decrypt('Enter my site.',10,10); // //text = 'Enter my site.' :: 'Enter my site.' is // //max = 10 :: a different random string is dis- //played 10 times before a new character is //decrypted function decrypt(text, max, delay){ if (done){ done = 0; decrypt_helper(text, max, delay, 0, max); } } function decrypt_helper(text, runs_left, delay, charvar, max){ if (!done){ runs_left = runs_left - 1; var status = text.substring(0,charvar); for(var current_char = charvar; current_char < text.length; current_char++){ status += data.charAt(Math.round(Math.random()*data.length)); } document.title = status; var rerun = "decrypt_helper('" + text + "'," + runs_left + "," + delay + "," + charvar + "," + max + ");" var new_char = charvar + 1; var next_char = "decrypt_helper('" + text + "'," + max + "," + delay + "," + new_char + "," + max + ");" if(runs_left > 0){ setTimeout(rerun, delay); } else{ if (charvar < text.length){ setTimeout(next_char, Math.round(delay*(charvar+3)/(charvar+1))); } else { done = 1; } } } } //if IE 4+ or NS 6+ if (document.all||document.getElementById) statusIn(thetitle) </script> <style type="text/css"> .auto-style1 { width: 68px; height: 70px; } .auto-style2 { margin-left: 0px; } </style> </head> <body> <form id="form1" runat="server"> <div style="background-position: center center; background-image: url('images/1385161065911.jpg'); background-color: #3399FF; font-size: large; font-weight: bolder; color: #66CCFF;"> <br /> <br /> <br /> <br /> <LoginButtonStyle BackColor="White" BorderColor="#507CD1" BorderStyle="Solid" BorderWidth="1px" Font-Names="Verdana" Font-Size="0.8em" ForeColor="#284E98" /> <TextBoxStyle Font-Size="0.8em" /> <TitleTextStyle BackColor="#507CD1" Font-Bold="True" Font-Size="0.9em" ForeColor="White" /> <br /> <br /> <br /> <br /> <br /> <br /> <input type="text" id="txtblinkingtext" name="txtblinkingtext" value="InOffice" readonly="readonly" style="height: 20px; width: 100px; background-color: Red; color: White; border: 0px none; text-align: center;"/><br /> <br /> <br /> <br /> <br /> <br /> <br /> <img alt="img" class="auto-style1" src="images/login-system-icon-13%20(2).png" /> <br /> <br /> Firstname : <asp:textbox id="firstname" runat="server" ontextchanged="Firstname_TextChanged" width="169px"></asp:textbox> <br /> <br /> Password : <asp:TextBox ID="password" runat="server" OnTextChanged="Password_TextChanged" TextMode="Password" Width="170px"></asp:TextBox> <br /> <br /> Enter Below Code : <asp:TextBox ID="txtCaptcha" runat="server" Width="163px" Height="17px"></asp:TextBox> <br /> <cc1:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"> </cc1:ToolkitScriptManager> <asp:UpdatePanel ID="UP1" runat="server"> <ContentTemplate> <asp:Image ID="imgCaptcha" runat="server" /> <asp:Button ID="btnRefresh" runat="server" Text="Refresh" OnClick="btnRefresh_Click" /> </ContentTemplate> </asp:UpdatePanel> <br /> <asp:Button ID="LoginButton" runat="server" CommandName="Login" OnClick="LoginButton_Click1" Text="Log In" ValidationGroup="Login1" /> <br /> <br /> <asp:LinkButton ID="LinkButton2" runat="server" Font-Size="Medium" OnClick="LinkButton2_Click">Forgot Password</asp:LinkButton> ? <asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click">New User</asp:LinkButton> !.<br /> <asp:TextBox ID="TextBox1" runat="server" OnTextChanged="TextBox1_TextChanged" Width="495px" Font-Bold="True" Font-Names="Arial Black" BackColor="Black" BorderColor="Black" BorderStyle="Dotted" CssClass="auto-style2" ForeColor="Red" Height="16px"></asp:TextBox> <br /> <br /> <br /> <br /> <br /> <br /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:masterConnectionString %>" SelectCommand="SELECT * FROM [Employe7]"></asp:SqlDataSource> <br /> <br /> <p style="color: #3399FF; font-size: large; font-weight: bolder;"> © <%: DateTime.Now.Year %>-Inoffice</p> <br /> <footer> </footer> </div> </form> </body> </html>
Step (2) : Create, Another WebForm name Registration.cs write the following code:By giving Sql Connection.
using System; using System.Collections.Generic; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Globalization; using System.Text; namespace INOffice1 { public partial class REgistration : Page { BO register = new BO(); #region SqlConnection Connection and Page Lode SqlConnection conn = new SqlConnection("Data Source=MYPC-PC\\SQLEXPRESS;Initial Catalog=Rateesh;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { BindGridView(); } } catch (Exception ex) { ShowMessage(ex.Message); } } void ShowMessage(string msg) { ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<scriptlanguage = 'javascript' > alert('" + msg + "');</ script > "); } /// <summary> /// This Function is used TextBox Empty. /// </summary> void clear() { TextBox1.Text = string.Empty; TextBox2.Text = string.Empty; TextBox3.Text = string.Empty; Gender.SelectedValue = null; TextBox5.Text = string.Empty; TextBox7.Text = string.Empty; TextBox8.Text = string.Empty;TextBox9.Text = string.Empty;TextBox10.Text = string.Empty; dd1.SelectedValue = null; TextBox1.Focus(); } #endregion #region bind data to GridViewStudent private void BindGridView() { try { if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand("Select * from Employe7 ORDER BY ID DESC;", conn); SqlDataAdapter adp = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adp.Fill(ds); /*gvEmployeeRecords.DataSource = ds;*/ gvEmployeeRecords.DataBind(); // lbltotalcount.Text = gvEmployeeRecords.Rows.Count.ToString(); } catch (SqlException ex) { ShowMessage(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } /*if (!this.IsPostBack) { this.BindGrid(); } } private void BindGrid() { using (Employe1Entities entities = new Employe1Entities()) { gvEmployeeRecords.DataSource = from Employe1 in entities.Employe1 select Employe1; gvEmployeeRecords.DataBind(); } }*/ /* if (!IsPostBack == true) { Get_Xml(); } } void Get_Xml() { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("Employeestore.xml")); if (ds != null && ds.HasChanges()) { gvEmployeeRecords.DataSource = ds; } else { gvEmployeeRecords.DataBind(); } }*/ protected void TextBox2_TextChanged(object sender, EventArgs e) { } protected void TextBox3_TextChanged(object sender, EventArgs e) { } protected void TextBox4_TextChanged(object sender, EventArgs e) { } protected void TextBox5_TextChanged(object sender, EventArgs e) { } protected void TextBox6_TextChanged(object sender, EventArgs e) { } protected void TextBox7_TextChanged(object sender, EventArgs e) { } protected void TextBox8_TextChanged(object sender, EventArgs e) { } protected void TextBox1_TextChanged(object sender, EventArgs e) { } protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e) { } protected void AddValues(object sender, EventArgs e) { } protected void btSubmit(object sender, EventArgs e) { /* string connetionString = null; SqlConnection cnn; connetionString = "Data Source=DELL;Initial Catalog=Master;User ID=sa;Password=Reddy22"; cnn = new SqlConnection(connetionString); try { cnn.Open(); ShowMessage("Connection Open ! "); cnn.Close(); } catch (Exception ex) { ShowMessage("Can not open connection ! "); } }*/ bool UserExist; UserExist = this.UserExit(); if (UserExist == false) { try { conn.Open(); SqlCommand cmd = new SqlCommand("Insert into Employe7 (ID,Firstname,Lastname,Password,Gender,DOB,Mobileno,Email,Remarks,Address,Designation)values(@ID,@Firstname, @Lastname,@Password,@Gender, @DOB,@Mobileno,@Email,@Remarks,@Address,@Designation)", conn); cmd.Parameters.AddWithValue("ID", txtName.Text); cmd.Parameters.AddWithValue("@Firstname", TextBox1.Text); cmd.Parameters.AddWithValue("@Lastname", TextBox2.Text); cmd.Parameters.AddWithValue("@Password", TextBox9.Text); cmd.Parameters.AddWithValue("@Gender", Gender.SelectedValue); cmd.Parameters.AddWithValue("@DOB", TextBox3.Text.ToString()); cmd.Parameters.AddWithValue("@Mobileno", TextBox5.Text); cmd.Parameters.AddWithValue("@Email", TextBox7.Text); cmd.Parameters.AddWithValue("@Address", TextBox10.Text); cmd.Parameters.AddWithValue("Designation", dd1.SelectedValue); cmd.Parameters.AddWithValue("@Remarks", TextBox8.Text); cmd.ExecuteNonQuery(); cmd.Dispose(); ShowMessage("Registered successfully......!"); clear(); BindGridView(); } catch (SqlException ex) { ShowMessage(ex.Message); } finally { conn.Close(); } TextBox1.Text = null; TextBox2.Text = null; TextBox3.Text = null; Gender.SelectedValue = null; TextBox5.Text = null; TextBox7.Text = null; TextBox8.Text = null; TextBox9.Text = null; TextBox10.Text = null; dd1.SelectedValue = null; } else { Label13.Text = "User Already Exists"; } try { /*conn.Open(); SqlCommand cmd = new SqlCommand("Insert into Desig(Designation,Remarks)Values(@Designation,@Remarks)", conn); cmd.Parameters.AddWithValue("@Designation", dd1.SelectedValue); cmd.Parameters.AddWithValue("@Remarks", TextBox8.Text); cmd.ExecuteNonQuery(); cmd.Dispose();*/ ShowMessage("Registered successfully......!"); clear(); BindGridView(); } catch (SqlException ex) { ShowMessage(ex.Message); } finally { conn.Close(); } } /* // creating object of XML DOCument class XmlDocument XmlDocObj = new XmlDocument(); //loading XML File in memory XmlDocObj.Load(Server.MapPath("Employeestore.xml")); //Select root node which is already defined XmlNode RootNode = XmlDocObj.SelectSingleNode("REgistration"); XmlNode REgistrationNode = RootNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "REgistration", "")); REgistrationNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "FirstName", "")).InnerText = TextBox1.Text; //adding node Author to book node and inside it data taking from Textbox1 REgistrationNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "LastName", "")).InnerText = TextBox2.Text; //adding node Year to book node and inside it data taking from Textbox2 REgistrationNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "DOB", "")).InnerText = TextBox3.Text; //adding node tbPrice to book node and inside it data taking from Textbox3 REgistrationNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Address", "")).InnerText = TextBox4.Text; REgistrationNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Phoneno", "")).InnerText = TextBox5.Text; REgistrationNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Landline", "")).InnerText = TextBox6.Text; REgistrationNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Mailid", "")).InnerText = TextBox7.Text; REgistrationNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Remarks", "")).InnerText = TextBox8.Text; //adding node tbPrice to book node and inside it data taking from Textbox4 //after adding node, saving Employeestore.xml back to the server XmlDocObj.Save(Server.MapPath("Employeestore.xml")); //Calling grid view binding method. gridDataBind(); TextBox1.Text = null; TextBox2.Text = null; TextBox3.Text = null; TextBox4.Text = null; TextBox5.Text = null; TextBox6.Text = null; TextBox7.Text = null; TextBox8.Text = null; } private void gridDataBind() { DataSet ds = new DataSet(); //reading data from the Employeestore.xml... ds.ReadXml(Server.MapPath("Employeestore.xml")); //Adding dataset ds as a datasource of the grid view... gvEmployeeRecords.DataSource = ds; //binding data with grid view... gvEmployeeRecords.DataBind(); }*/ protected void gvEmployeeRecords_RowEditing(object sender, GridViewEditEventArgs e) { /* gvEmployeeRecords.EditIndex = e.NewEditIndex; Get_Xml();*/ } protected void gvEmployeeRecords_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { clear(); /* gvEmployeeRecords.EditIndex = -1; Get_Xml();*/ } protected void gvEmployeeRecords_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { conn.Open(); string ID = lblID.Text; SqlCommand cmd = new SqlCommand("update Employe7 SetFirstname = @Firstname,Lastname= @Lastname,Password=@Password,Gender=@GenderDOB= @DOB, Mobileno = @Mobileno,,Email = @Email,Remarks=@Remarks where ID =@ID", conn); cmd.Parameters.AddWithValue("@Firstname", TextBox1.Text); cmd.Parameters.AddWithValue("@Lastname", TextBox2.Text); cmd.Parameters.AddWithValue("@Password", TextBox9.Text); cmd.Parameters.AddWithValue("@Gender", Gender.SelectedValue); cmd.Parameters.AddWithValue("@DOB", TextBox3.Text); cmd.Parameters.AddWithValue("@Mobileno", TextBox5.Text); cmd.Parameters.AddWithValue("@Email", TextBox7.Text); cmd.Parameters.AddWithValue("@Remarks", TextBox8.Text); cmd.Parameters.AddWithValue("ID", ID); cmd.ExecuteNonQuery(); cmd.Dispose(); ShowMessage("Employe Data update Successfully......!"); gvEmployeeRecords.EditIndex = -1; BindGridView(); } catch (SqlException ex) { ShowMessage(ex.Message); } finally { conn.Close(); } } /* int id = gvEmployeeRecords.Rows[e.RowIndex].DataItemIndex; TextBox FirstName = gvEmployeeRecords.Rows[e.RowIndex].FindControl("TxtEditREgFirstName") as TextBox; TextBox LastName = gvEmployeeRecords.Rows[e.RowIndex].FindControl("TxtEditREgLastName") as TextBox; TextBox DOB = gvEmployeeRecords.Rows[e.RowIndex].FindControl("TxtEditREgDOB") as TextBox; TextBox Address = gvEmployeeRecords.Rows[e.RowIndex].FindControl("TxtEditREgAdress") as TextBox; TextBox Phoneno = gvEmployeeRecords.Rows[e.RowIndex].FindControl("TxtEditREgPhnoeno") as TextBox; TextBox Landline = gvEmployeeRecords.Rows[e.RowIndex].FindControl("TxtEditREgLandline") as TextBox; TextBox Mailid = gvEmployeeRecords.Rows[e.RowIndex].FindControl("TxtEditREgMailid") as TextBox; TextBox Remarks = gvEmployeeRecords.Rows[e.RowIndex].FindControl("TxtEditRegRemarks") as TextBox; gvEmployeeRecords.EditIndex = -1; Get_Xml(); DataSet ds = gvEmployeeRecords.DataSource as DataSet; ds.Tables[0].Rows[id]["First Name"] = FirstName.Text; ds.Tables[0].Rows[id]["Last Name"] = LastName.Text; ds.Tables[0].Rows[id]["DOB"] = DOB.Text; ds.Tables[0].Rows[id]["Address"] = Address.Text; ds.Tables[0].Rows[id]["Phone no"] = Phoneno.Text; ds.Tables[0].Rows[id]["Landline"] = Landline.Text; ds.Tables[0].Rows[id]["Mailid"] = Mailid.Text; ds.Tables[0].Rows[id]["Remarks"] = Remarks.Text; ds.WriteXml(Server.MapPath("Employeestore.xml")); Get_Xml();*/ protected void gvEmployeeRecords_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { conn.Open(); int ID = Convert.ToInt32(gvEmployeeRecords.DataKeys[e.RowIndex].Value); SqlCommand cmd = new SqlCommand("Delete From Employe7 where ID='" + ID + "'", conn); cmd.ExecuteNonQuery(); cmd.Dispose(); ShowMessage("Employe Data Delete Successfully......!"); gvEmployeeRecords.EditIndex = -1; BindGridView(); } catch (SqlException ex) { ShowMessage(ex.Message); } finally { conn.Close(); } } /* Get_Xml(); DataSet ds = gvEmployeeRecords.DataSource as DataSet; ds.Tables[0].Rows[gvEmployeeRecords.Rows[e.RowIndex].DataItemIndex].Delete(); ds.WriteXml(Server.MapPath("Employeestore.xml"));*/ protected void gvEmployeeRecords_PageIndexChanging(object sender, GridViewPageEventArgs e) { // gvEmployeeRecords.PageIndex = e.NewPageIndex; //BindGridview(); } protected void gvEmployeeRecords_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { GridViewRow row = gvEmployeeRecords.SelectedRow; lblID.Text = row.Cells[2].Text; TextBox1.Text = row.Cells[3].Text; TextBox2.Text = row.Cells[4].Text; TextBox9.Text = row.Cells[5].Text; Gender.SelectedValue = row.Cells[6].Text; TextBox3.Text = row.Cells[7].Text; TextBox5.Text = row.Cells[8].Text; TextBox7.Text = row.Cells[9].Text; TextBox8.Text = row.Cells[10].Text; btnadd.Visible = false; } protected void TextBox9_TextChanged(object sender, EventArgs e) { } protected void Gender_SelectedIndexChanged(object sender, EventArgs e) { } protected void LinkButton1_Click(object sender, EventArgs e) { TextBox1.Text = null; TextBox2.Text = null; TextBox3.Text = null; Gender.SelectedValue = null; TextBox5.Text = null; TextBox7.Text = null; TextBox8.Text = null; TextBox9.Text = null; Response.Redirect("Login.aspx"); } protected void Button1_Click(object sender, EventArgs e) { } private bool UserExit() { SqlConnection con = new SqlConnection("Data Source = DELL; Initial Catalog = master; User ID = sa; Password=Reddy22"); SqlCommand cmd = new SqlCommand("Select * From Employe7 Where ID =@ID ",con); cmd.Parameters.AddWithValue("@ID", txtName.Text.Trim()); cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); SqlDataReader rdr; rdr = cmd.ExecuteReader(); if (rdr.HasRows) { return true; } else { return false; } } } } #endregion
The source file should look as the following:<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="INOffice1.Login" StylesheetTheme="Themes" %> <%@ Register assembly="Obout.Ajax.UI" namespace="Obout.Ajax.UI.Captcha" tagprefix="obout" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Login</title> <link runat="server" rel="shortcut icon" href="Oxygen-Icons.org-Oxygen-Apps-preferences-desktop-user-password.ico" type="image/x-icon"/> <link runat="server" rel="icon" href="Oxygen-Icons.org-Oxygen-Apps-preferences-desktop-user-password.ico" type="image/ico"/> <script type="javascript"> setInterval(blinktext, 500); var txt = ""; var count = 0; function blinktext() { var cntrl = document.getElementById("txtblinkingtext"); if (count == 0) txt = cntrl.value; if (count % 2 == 0) cntrl.value = ""; else cntrl.value = txt; count++; } </script> <script type="JavaScript1.2"> /* Animated Document title- By Dynamicdrive.com For full source, TOS, and 100s DTHML scripts Visit http://dynamicdrive.com */ if (document.all||document.getElementById){ var thetitle=document.title document.title='' } ////Animation code below ////based on script from http://wsabstract.com/script/script2/statusanimate.shtml var data="0123456789"; var done=1; function statusIn(text){ decrypt(text,2,1); } function statusOut(){ self.status=''; done=1; } //-------------------------\\ //decrypt(string, int, int)\\ //-------------------------\\ // //text(string): the text to be decrypted on //the status bar. // //max(int): the number of times a random string //is displayed before the next character is //'decrypted'. // //delay(int): the number of milliseconds between //each display of a random string // //Example: //decrypt('Enter my site.',10,10); // //text = 'Enter my site.' :: 'Enter my site.' is // //max = 10 :: a different random string is dis- //played 10 times before a new character is //decrypted function decrypt(text, max, delay){ if (done){ done = 0; decrypt_helper(text, max, delay, 0, max); } } function decrypt_helper(text, runs_left, delay, charvar, max){ if (!done){ runs_left = runs_left - 1; var status = text.substring(0,charvar); for(var current_char = charvar; current_char < text.length; current_char++){ status += data.charAt(Math.round(Math.random()*data.length)); } document.title = status; var rerun = "decrypt_helper('" + text + "'," + runs_left + "," + delay + "," + charvar + "," + max + ");" var new_char = charvar + 1; var next_char = "decrypt_helper('" + text + "'," + max + "," + delay + "," + new_char + "," + max + ");" if(runs_left > 0){ setTimeout(rerun, delay); } else{ if (charvar < text.length){ setTimeout(next_char, Math.round(delay*(charvar+3)/(charvar+1))); } else { done = 1; } } } } //if IE 4+ or NS 6+ if (document.all||document.getElementById) statusIn(thetitle) </script> <style type="text/css"> .auto-style1 { width: 68px; height: 70px; } .auto-style2 { margin-left: 0px; } </style> </head> <body> <form id="form1" runat="server"> <div style="background-position: center center; background-image: url('images/1385161065911.jpg'); background-color: #3399FF; font-size: large; font-weight: bolder; color: #66CCFF;"> <br /> <br /> <br /> <br /> <LoginButtonStyle BackColor="White" BorderColor="#507CD1" BorderStyle="Solid" BorderWidth="1px" Font-Names="Verdana" Font-Size="0.8em" ForeColor="#284E98" /> <TextBoxStyle Font-Size="0.8em" /> <TitleTextStyle BackColor="#507CD1" Font-Bold="True" Font-Size="0.9em" ForeColor="White" /> <br /> <br /> <br /> <br /> <br /> <br /> <input type="text" id="txtblinkingtext" name="txtblinkingtext" value="InOffice" readonly="readonly" style="height: 20px; width: 100px; background-color: Red; color: White; border: 0px none; text-align: center;"/><br /> <br /> <br /> <br /> <br /> <br /> <br /> <img alt="img" class="auto-style1" src="images/login-system-icon-13%20(2).png" /> <br /> <br /> Firstname : <asp:textbox id="firstname" runat="server" ontextchanged="Firstname_TextChanged" width="169px"></asp:textbox> <br /> <br /> Password : <asp:TextBox ID="password" runat="server" OnTextChanged="Password_TextChanged" TextMode="Password" Width="170px"></asp:TextBox> <br /> <br /> Enter Below Code : <asp:TextBox ID="txtCaptcha" runat="server" Width="163px" Height="17px"></asp:TextBox> <br /> <cc1:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"> </cc1:ToolkitScriptManager> <asp:UpdatePanel ID="UP1" runat="server"> <ContentTemplate> <asp:Image ID="imgCaptcha" runat="server" /> <asp:Button ID="btnRefresh" runat="server" Text="Refresh" OnClick="btnRefresh_Click" /> </ContentTemplate> </asp:UpdatePanel> <br /> <asp:Button ID="LoginButton" runat="server" CommandName="Login" OnClick="LoginButton_Click1" Text="Log In" ValidationGroup="Login1" /> <br /> <br /> <asp:LinkButton ID="LinkButton2" runat="server" Font-Size="Medium" OnClick="LinkButton2_Click">Forgot Password</asp:LinkButton> ? <asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click">New User</asp:LinkButton> !.<br /> <asp:TextBox ID="TextBox1" runat="server" OnTextChanged="TextBox1_TextChanged" Width="495px" Font-Bold="True" Font-Names="Arial Black" BackColor="Black" BorderColor="Black" BorderStyle="Dotted" CssClass="auto-style2" ForeColor="Red" Height="16px"></asp:TextBox> <br /> <br /> <br /> <br /> <br /> <br /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:masterConnectionString %>" SelectCommand="SELECT * FROM [Employe7]"></asp:SqlDataSource> <br /> <br /> <p style="color: #3399FF; font-size: large; font-weight: bolder;"> © <%: DateTime.Now.Year %>-Inoffice</p> <br /> <footer> </footer> </div> </form> </body> </html>
Step (3):After Creating Login & Registration, now create Welcome.cs
By Login with registration Form getting details from Database And
redirected To welcome.cs with session Login.
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace INOffice1
{
public partial class Welcome : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("Data Source=MYPC-PC\\SQLEXPRESS;Initial Catalog=Rateesh;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = "::" + Session["Firstname"] ;
conn.Open();
SqlCommand com = new SqlCommand("select * from Employe7 where Firstname='" + Session["Firstname"] + "'", conn);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
Label2.Text = ds.Tables[0].Rows[0]["Designation"].ToString();
Label3.Text = ds.Tables[0].Rows[0]["ID"].ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source = DELL; Initial Catalog = master; User ID = sa; Password=Reddy22");
conn.Open();
SqlCommand com = new SqlCommand("insert into login_info(Username,Logout_Time) values('" + Session["Firstname"] + "',getdate())", conn);
com.ExecuteNonQuery();
Response.Redirect("Login.aspx");
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
}
protected void OnMenuItemDataBound(object sender, MenuEventArgs e)
{
if (SiteMap.CurrentNode != null)
{
if (e.Item.Text == SiteMap.CurrentNode.Title)
{
if (e.Item.Parent != null)
{
e.Item.Parent.Selected = true;
}
else
{
e.Item.Selected = true;
}
}
}
}
protected void BulletedList1_Click(object sender, BulletedListEventArgs e)
{
}
}
}
The source file should look as the following:<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Welcome.aspx.cs" Inherits="INOffice1.Welcome" StyleSheetTheme="Themes" Theme="Themes" %> <%@ Register assembly="obout_EasyMenu_Pro" namespace="OboutInc.EasyMenu_Pro" tagprefix="oem" %> <%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %> <%@ Register assembly="Obout.Ajax.UI" namespace="Obout.Ajax.UI.ColorPicker" tagprefix="obout" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Home</title> <!-- Start WOWSlider.com HEAD section --> <link rel="stylesheet" type="text/css" href="engine1/style.css" /> <style> body {font-family: Verdana; font-size: XX-Small; margin: 20px;} .title {font-size: X-Large; padding: 20px; border-bottom: 2px solid gray;} </style> <style type="text/css"> .auto-style2 { width: 1275px; } .auto-style6 { margin-left: 832px; } .auto-style7 { left: 1px; top: 1px; } .auto-style8 { margin-left: 234px; } </style> <body onload="position_at_top();expand()"> <div style="position:absolute;color:black" id="test"></div> <form id="form1" runat="server"> <header style="background-position: center center; background-color: #CCFFFF; background-image: url('images/global-social-network.jpg'); font-size: large;"> <td style="width:50px;height:50px; background-color: #CCFFFF;"> <img style="width:50px;height:50px;" src="images/global-social-network.jpg" /> <asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Overline="True" Font-Underline="True" ForeColor="Red" Font-Size="Medium"></asp:Label> <asp:Label ID="Label2" runat="server" Font-Bold="True" Font-Overline="True" Font-Size="Medium" Font-Underline="True" ForeColor="Red"></asp:Label> <asp:Label ID="Label3" runat="server" Font-Bold="True" Font-Overline="True" Font-Underline="True" ForeColor="Red" Font-Size="Medium"></asp:Label> <asp:Panel ID="Panel" runat="server" BorderColor="Pink" BorderWidth="2" > <asp:Menu ID="Menu1" runat="server" BackColor="#F7F6F3" DynamicHorizontalOffset="2" Font-Names="Verdana" Font-Size="Medium" ForeColor="#7C6F57" OnMenuItemClick="Menu1_MenuItemClick" Orientation="Horizontal" StaticSubMenuIndent="10px"> <DynamicHoverStyle BackColor="#7C6F57" ForeColor="White" /> <DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" /> <DynamicMenuStyle BackColor="#F7F6F3" /> <DynamicSelectedStyle BackColor="#5D7B9D" /> <Items> <asp:MenuItem NavigateUrl="~/Welcome.aspx" Text="Home" Value="Home"></asp:MenuItem> <asp:MenuItem NavigateUrl="~/About us.aspx" Text="About us" Value="About"></asp:MenuItem> <asp:MenuItem NavigateUrl="~/Contact US.aspx" Text="Contact US" Value="Contact"></asp:MenuItem> </Items> <StaticHoverStyle BackColor="#FFFF99" ForeColor="White" /> <StaticMenuItemStyle BackColor="#66FFFF" Font-Bold="True" Font-Size="Larger" HorizontalPadding="100px" VerticalPadding="2px" /> <StaticSelectedStyle BackColor="#5D7B9D" /> </asp:Menu> <cc1:AnimationExtender ID="Menu1_AnimationExtender" runat="server" TargetControlID="Menu1"> </cc1:AnimationExtender> <asp:TreeView ID="TreeView1" runat="server" CssClass="auto-style6" ExpandDepth="0" ImageSet="Simple" Width="100px"> <HoverNodeStyle Font-Underline="True" ForeColor="#5555DD" /> <Nodes> <asp:TreeNode NavigateUrl="~/EditProfile.aspx" Text="EditProfile" Value="EditProfile"></asp:TreeNode> <asp:TreeNode NavigateUrl="~/ChangePassword.aspx" Text="ChangePassword" Value="ChangePassword"></asp:TreeNode> <asp:TreeNode NavigateUrl="~/Login.aspx" Text="Logout" Value="New Node"></asp:TreeNode> </Nodes> <NodeStyle Font-Names="Tahoma" Font-Size="10pt" ForeColor="Black" HorizontalPadding="0px" NodeSpacing="0px" VerticalPadding="0px" /> <ParentNodeStyle Font-Bold="False" /> <SelectedNodeStyle Font-Underline="True" ForeColor="#5555DD" HorizontalPadding="0px" VerticalPadding="0px" /> </asp:TreeView> </asp:Panel> <cc1:DropDownExtender ID="Label1_DropDownExtender" runat="server" DropDownControlID="panel" Enabled="True" TargetControlID="Label1"> </cc1:DropDownExtender> <br /> <script language="JavaScript1.2"> /* Neon Lights Text By JavaScript Kit (http://javascriptkit.com) For this script, TOS, and 100s more DHTML scripts, Visit http://www.dynamicdrive.com */ var message="InOffice" var neonbasecolor="gray" var neontextcolor="yellow" var flashspeed=100 //in milliseconds ///No need to edit below this line///// var n=0 if (document.all||document.getElementById){ document.write('<font color="'+neonbasecolor+'">') for (m=0;m<message.length;m++) document.write('<span id="neonlight'+m+'">'+message.charAt(m)+'</span>') document.write('</font>') } else document.write(message) function crossref(number){ var crossobj=document.all? eval("document.all.neonlight"+number) : document.getElementById("neonlight"+number) return crossobj } function neon(){ //Change all letters to base color if (n==0){ for (m=0;m<message.length;m++) //eval("document.all.neonlight"+m).style.color=neonbasecolor crossref(m).style.color=neonbasecolor } //cycle through and change individual letters to neon color crossref(n).style.color=neontextcolor if (n<message.length-1) n++ else{ n=0 clearInterval(flashing) setTimeout("beginneon()",1500) return } } function beginneon(){ if (document.all||document.getElementById) flashing=setInterval("neon()",flashspeed) } beginneon() </script> <oem:EasyMenu id="EasymenuMain" runat="server" ShowEvent="Always" StyleFolder="styles/MSVertical" Position="Vertical" Width="200" Font-Size="Large" CSSMenu="ParentMenu" CSSMenuItemContainer="ParentItemContainer" Font-Bold="True" > <CSSClassesCollection> <oem:CSSClasses ObjectType="OboutInc.EasyMenu_Pro.MenuItem" ComponentSubMenuCellOver="ParentItemSubMenuCellOver" ComponentContentCell="ParentItemContentCell" Component="ParentItem" ComponentSubMenuCell="ParentItemSubMenuCell" ComponentIconCellOver="ParentItemIconCellOver" ComponentIconCell="ParentItemIconCell" ComponentOver="ParentItemOver" ComponentContentCellOver="ParentItemContentCellOver"></oem:CSSClasses> <oem:CSSClasses ObjectType="OboutInc.EasyMenu_Pro.MenuSeparator" ComponentSubMenuCellOver="ParentSeparatorSubMenuCellOver" ComponentContentCell="ParentSeparatorContentCell" Component="ParentSeparator" ComponentSubMenuCell="ParentSeparatorSubMenuCell" ComponentIconCellOver="ParentSeparatorIconCellOver" ComponentIconCell="ParentSeparatorIconCell" ComponentOver="ParentSeparatorOver" ComponentContentCellOver="ParentSeparatorContentCellOver"></oem:CSSClasses> </CSSClassesCollection> <Components> <oem:MenuItem InnerHtml="Home" ID="HighlightsID"></oem:MenuItem> <oem:MenuItem InnerHtml="About" ID="LatestReleasesID"></oem:MenuItem> <oem:MenuItem InnerHtml="Contact" ID="UsingYourComputerID"></oem:MenuItem> </Components> <CommonSubMenuProperties StyleFolder="" OffsetHorizontal="0" OffsetVertical="0" ZIndex="0" UseIcons="False" IconsPosition="Left" Align="Cursor" AlignMenuCorner="TopRight" Position="Vertical" ShowEvent="MouseOver" Width="200px" DropdownIncrement="10" DropInterval="10" KeepOpen="False" RepeatColumns="1"></CommonSubMenuProperties> </oem:EasyMenu> <br /> <oem:EasyMenu id="HighlightsMenu" runat="server" ShowEvent="MouseOver" AttachTo="HighlightsID" Align="Right" Width="200" StyleFolder="styles/MSVertical1" BorderStyle="Solid" BackColor="#FF9966"> <Components> <oem:MenuItem InnerHtml="<img src='images\login.png'" Url="Welcome.aspx" ID="HighlightsMenuItemID"></oem:MenuItem> </Components> </oem:EasyMenu> <oem:EasyMenu id="LatestReleasesMenu" OffsetVertical="-33" runat="server" ShowEvent="MouseOver" AttachTo="LatestReleasesID" Align="Right" Width="200" StyleFolder="styles/MSVertical1"> <Components> <oem:MenuItem InnerHtml="<img src='images\login.png'" Url="About us.aspx" ID="LatestReleasesMenuItemID"></oem:MenuItem> </Components> </oem:EasyMenu> <oem:EasyMenu id="UsingYourComputerMenu" OffsetVertical="-66" runat="server" ShowEvent="MouseOver" AttachTo="UsingYourComputerID" Align="Right" Width="200" StyleFolder="styles/MSVertical1"> <Components> <oem:MenuItem InnerHtml="<img src='images\login.png'" Url="Contact US.aspx" ID="UsingYourComputerMenuItemID"></oem:MenuItem> </Components> </oem:EasyMenu>   <br /> </td> </h3> </header> <div style="background-position: center center; background-color: #FFFFFF; background-image: url('images/rat1.jpg');"> <br /> <!-- Start WOWSlider.com BODY section --> <div id="wowslider-container1"> <div class="ws_images"><ul> <li class="auto-style7"><img src="data1/images/aaeaaqaaaaaaaajfaaaajdq5ywfhytrjlwvlnjctngmwmi04odixlwi0mdhjyzdmngiymw.jpg" alt="Meetings" title="Meetings" id="wows1_0" class="auto-style8"/></li> <li><img src="data1/images/business_people_in_office.jpg" alt="GRoups" title="GRoups" id="wows1_1"/></li> <li><a href="http://wowslider.com"><img src="data1/images/globalsocialnetwork.jpg" alt="http://wowslider.com/" title="LOgo" id="wows1_2"/></a></li> <li><img src="data1/images/office027.jpg" alt="office" title="office" id="wows1_3"/></li> </ul></div> <div class="ws_bullets"><div> <a href="#" title="Meetings"><span><img src="data1/tooltips/aaeaaqaaaaaaaajfaaaajdq5ywfhytrjlwvlnjctngmwmi04odixlwi0mdhjyzdmngiymw.jpg" alt="Meetings"/>1</span></a> <a href="#" title="GRoups"><span><img src="data1/tooltips/business_people_in_office.jpg" alt="GRoups"/>2</span></a> <a href="#" title="LOgo"><span><img src="data1/tooltips/globalsocialnetwork.jpg" alt="LOgo"/>3</span></a> <a href="#" title="office"><span><img src="data1/tooltips/office027.jpg" alt="office"/>4</span></a> </div></div><div class="ws_script" style="position:absolute;left:-99%"><a href="http://wowslider.net">jquery carousel</a> by WOWSlider.com v8.7</div> <div class="ws_shadow"></div> </div> <script type="text/javascript" src="engine1/wowslider.js"></script> <script type="text/javascript" src="engine1/script.js"></script> <!-- End WOWSlider.com BODY section --> <br /> <br /> <br /> <br /> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Logout" /> <br /> <br /> <br /> <br /> <table> <tr style="width:1200px;height:20px;background-color:black;text-align:center;color:white;" > <td colspan="3" class="auto-style2" > INOFFICE Pvt. </td> </tr> </table> </div> </form> </body> </head> </html>
If we want we can Add number of webforms like forgotpassword,edit profile,etc. By using sql
database and Asp.net.
No comments:
Post a Comment