Passenger Reservation System(PRS)
<%@ Page Language= "C#" AutoEventWireup= "true" CodeFile= "Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" > <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server" > <title>Home Page</title> <link rel="shortcut icon" href= "Image/Train.ico" /> <script type="text/javascript" src= "script/jquery-1.3.1.min.js" ></script> <script type="text/javascript" > $(document).ready(function () { slideShow(); }); function slideShow() { $('#gallery a' ).css({ opacity: 0.0 }); $('#gallery a:first' ).css({ opacity: 1.0 }); $('#gallery .caption' ).css({ opacity: 0.7 }); $('#gallery .caption' ).css({ width: $('#gallery a' ).find( 'img' ).css( 'width' ) }); $('#gallery .content' ).html($( '#gallery a:first' ).find( 'img' ).attr( 'rel' )).animate({ opacity: 0.7 }, 400); 6000 = change to next image after 6 seconds setInterval('gallery()' , 2500); } function gallery() { var current = ($( '#gallery a.show' ) ? $( '#gallery a.show' ) : $( '#gallery a:first' )); rotate it back to the first image var next = ((current.next().length) ? ((current.next().hasClass( 'caption' )) ? $( '#gallery a:first' ) : current.next()) : $( '#gallery a:first' )); var caption = next.find( 'img' ).attr( 'rel' ); next.css({ opacity: 0.0 }).addClass('show' ).animate({ opacity: 1.0 }, 1000); current.animate({ opacity: 0.0 }, 1000).removeClass('show' ); $('#gallery .caption' ).animate({ opacity: 0.0 }, { queue: false , duration: 0 }).animate({ height: '1px' }, { queue: true , duration: 300 }); $('#gallery .caption' ).animate({ opacity: 0.7 }, 100).animate({ height: '100px' }, 500); $('#gallery .content' ).html(caption); } </script> <style type="text/css" > body { font-family: arial } .clear { clear: both } #gallery { position: relative; height: 360px } #gallery a { float : left; position: absolute; } #gallery a img { border: none; } #gallery a.show { z-index: 500 } #gallery .caption { z-index: 600; background-color: #000; color: #ffffff; height: 100px; width: 100%; position: absolute; bottom: 0; } #gallery .caption .content { margin: 5px } #gallery .caption .content h3 { margin: 0; padding: 0; color: #1DCCEF; } </style> </head> <body> <form id="form1" runat= "server" > <div style="width: 258px; margin-left: auto; margin-right:auto; height: 113px;" > <asp:Login ID="Login1" Style= "margin:auto" runat= "server" BackColor= "#F7F7DE" BorderColor= "#CCCC99" BorderStyle= "Solid" BorderWidth= "1px" Font-Names= "Verdana" Font-Size= "10pt" Font-Bold= "True" OnAuthenticate= "Login1_Authenticate" TitleText= "Log In To PRS" LoginButtonText= "Sign In" > <TitleTextStyle BackColor="#6B696B" Font-Bold= "True" ForeColor= "White" /> <LoginButtonStyle Font-Bold="True" /> </asp:Login> <b><u>New Registration:</u></b> <asp:LinkButton ID="lnkSignUp" runat= "server" PostBackUrl= "~/Passenger_Registration.aspx" Font-Bold= "True" Style="z-index: 50; left: 510px; position: absolute; top: 138px" Width=" 77px">Sign Up</asp:LinkButton> </div> <br /><br /> <table> <tr> <td> <div id="gallery" > <a href="#" class = "show" > <img src="Image/Train6.jpeg" alt= "Flowing Rock" width= "400" height= "260" title= "" alt= "" rel= "<h3>Wel Come To PRS(Passenger Reservation System)</h3>LifeLine of The Nation....." /> </a> <a href="#" > <img src="Image/Train1.jpeg" alt= "Grass Blades" width= "400" height= "260" title= "" alt= "" rel= "<h3>At Your Service</h3>The All Weather Route with Center to Center Convenience . " /> </a> <a href="#" > <img src="Image/Train2.jpeg" alt= "Ladybug" width= "400" height= "260" title= "" alt= "" rel= "<h3>Rail Road</h3>The Standard Railroad of the World." /> </a> <a href="#" > <img src="Image/Train3.jpeg" alt= "Lightning" width= "400" height= "260" title= "" rel= "<h3>Old Reliable</h3>But the Railroad Always Runs ." /> </a> <a href="#" > <img src="Image/Train4.jpeg" alt= "Lotus" width= "400" height= "260" title= "" alt= "" rel= "<h3>Lotus</h3>Room to Move, Think, Relax ." /> </a> <a href="#" > <img src="Image/Train5.jpeg" alt= "Mojave" width= "400" height= "260" title= "" alt= "" rel= "<h3>Western Railways</h3>Good Ideas Make a Great Railway." /> </a> <div class = "caption" > <div class = "content" ></div> </div> </div> <div class = "clear" ></div> </td> </tr> </table> <iframe src="marqeePage.htm" width= "400" height= "260" style="z-index: 100; left: 573px; position: absolute; top: 170px"></iframe> </form> </body> </html>
Default.aspx.cs
using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { ConnClass conn = new ConnClass(); protected void Page_Load(object sender, EventArgs e) { } #region Login ctrl protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { try { string unm = Login1.UserName.ToUpper(); if (unm == "ADMIN" ) { string UserNm = Login1.UserName; string Pwd = Login1.Password; string connect = conn.GetConnection(); SqlConnection scon = new SqlConnection(connect); SqlCommand cmd = new SqlCommand( "dbo.SP_Login" , scon); cmd.CommandType = CommandType.StoredProcedure; scon.Open(); DataSet ds = new DataSet(); cmd.Parameters.Add("@UName" , System.Data.SqlDbType.VarChar, 50).Value = UserNm; cmd.Parameters.Add("@Pwd" , System.Data.SqlDbType.VarChar, 50).Value = Pwd; SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(ds); for ( int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { Session["UserName" ] = UserNm; string MainURL = "Admin.aspx? url1=" + ds.Tables[0].Rows[i][" PassengerId"]; Response.Redirect(MainURL); } } else { string UserNm = Login1.UserName; string Pwd = Login1.Password; string connect = conn.GetConnection(); SqlConnection scon = new SqlConnection(connect); SqlCommand cmd = new SqlCommand( "dbo.SP_Login" , scon); cmd.CommandType = CommandType.StoredProcedure; scon.Open(); DataSet ds = new DataSet(); cmd.Parameters.Add("@UName" , System.Data.SqlDbType.VarChar, 50).Value = UserNm; cmd.Parameters.Add("@Pwd" , System.Data.SqlDbType.VarChar, 50).Value = Pwd; SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(ds); for ( int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { Session["UserName" ] = UserNm; string MainURL = "BookTrains.aspx? url1=" + ds.Tables[0].Rows[i][" PassengerId"]; Response.Redirect(MainURL); } } } catch (Exception er) { Response.Write(er); } } #endregion }
Passenger_Registration.aspx.cs
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class Passenger_Registration : System.Web.UI.Page { ConnClass connect = new ConnClass(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { fillddlCountry(); fillDay(ddlDOBDay); fillMonth(ddlDOBMonth); fillYear(ddlDOBYear); } lblGuestUser.Text = "Wel-Come-<b>Guest</b>" ; btnRegisterUser.Attributes.Add("onclick" , "return ValtxtUserNm('" +txtUserNm.ClientID+ "')" ); } #region fillDays private void fillDay(DropDownList ddlList) { ddlList.Items.Add(new ListItem( "Day" , "Day" )); ddlList.SelectedIndex = 0; int totalDay = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month); for ( int day = 1; day <= totalDay; day++) { ddlList.Items.Add(new ListItem(day.ToString(),day.ToString())); } } #endregion #region fill Month private void fillMonth(DropDownList ddlList) { ddlList.Items.Add(new ListItem( "Month" , "Month" )); ddlList.SelectedIndex=0; DateTime month=Convert.ToDateTime("1/1/2000" ); for ( int mon = 0; mon < 12; mon++) { DateTime NxtMon = month.AddMonths(mon); ddlList.Items.Add(new ListItem(NxtMon.ToString( "MMMM" ),NxtMon.ToString( "MMMM" ))); } } #endregion #region Fill Year private void fillYear(DropDownList ddlList) { ddlList.Items.Add(new ListItem( "Year" , "Year" )); ddlList.SelectedIndex = 0; int initialYear = 1960; for ( int yr = initialYear; yr <= Convert.ToInt32(DateTime.Now.Year); yr++) { ddlList.Items.Add(new ListItem(yr.ToString(), yr.ToString())); } } #endregion #region fill Country private void fillddlCountry() { string sqlconn = connect.GetConnection(); string Qry = "select * from CountryMaster" ; SqlDataAdapter sda = new SqlDataAdapter(Qry,sqlconn); DataSet ds = new DataSet(); sda.Fill(ds); ddlCountry.DataSource = ds; ddlCountry.DataTextField = "CountryName" ; ddlCountry.DataValueField = "CountryID" ; ddlCountry.DataBind(); ddlCountry.Items.Insert(0, "Select Country" ); } # endregion #region Button Reg Click protected void btnRegisterUser_Click(object sender, EventArgs e) { try { if (lblStatus.Text == "UserName Available" && txtUserNm.Text!= "" && txtPassword.Text!="" && txtPassword.Text.Length>5) { string unm = txtUserNm.Text.ToUpper(); string pwd = txtPassword.Text; string fnm = txtFName.Text.ToUpper(); string lnm = txtLastNm.Text.ToUpper(); DateTime dob = Convert.ToDateTime(ddlDOBDay.SelectedItem.Text + ddlDOBMonth.SelectedItem.Text + ddlDOBYear.SelectedItem.Text); string d = dob.ToString("d" ); string country = Convert.ToString(ddlCountry.SelectedItem); string state = Convert.ToString(ddlState.SelectedItem); string city = Convert.ToString(ddlCity.SelectedItem); string email = txtEmail.Text; string mob = txtMobileNo.Text; int pin = Convert.ToInt32(txtPincode.Text); string sqlconn = connect.GetConnection(); string qry = "Insert Into PassengerInfo values('" + unm + "', '" + pwd + "' , '" + fnm + "' , '" + lnm + "' , '" + d + "' , '" + email + "' , '" + mob + "' , '" + country + "' , '" + state + "' , '" + city + "' , " + pin + " )"; SqlDataAdapter sda = new SqlDataAdapter(qry, sqlconn); DataSet ds = new DataSet(); sda.Fill(ds, "PassengerInfo" ); Response.Write("<script language='javascript' type= 'text/javascript' > alert('Record Inserted Successfully' )</script>"); ClearForm(); Response.Redirect("Default.aspx" ); } else { lblError.Text = "Can Not Blank & Charecter Must be 5 " ; } } catch (Exception) { } } #endregion #region fill state protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { filldllState(); } private void filldllState() { if (ddlCountry.SelectedValue != "Select Country" ) { string sqlconn = connect.GetConnection(); string qry = "select * from StateMaster where CountryID=" +ddlCountry.SelectedValue; SqlDataAdapter sda = new SqlDataAdapter(qry, sqlconn); DataSet ds = new DataSet(); sda.Fill(ds); ddlState.DataSource = ds; ddlState.DataTextField = "StateName" ; ddlState.DataValueField = "StateID" ; ddlState.DataBind(); ddlState.Items.Insert(0, "Select State" ); } } #endregion end state #region fill city protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) { if (ddlCountry.SelectedValue != "Select State" ) { string sqlconn = connect.GetConnection(); string qry = "select * from CityMaster where stateID=" + ddlState.SelectedValue + " and CountryID=" + ddlCountry.SelectedValue; SqlDataAdapter sda = new SqlDataAdapter(qry, sqlconn); DataSet ds = new DataSet(); sda.Fill(ds); ddlCity.DataSource = ds; ddlCity.DataTextField = "CityName" ; ddlCity.DataValueField="CityID" ; ddlCity.DataBind(); ddlCity.Items.Insert(0,"Select City" ); } } #endregion #region Cancel Button Click protected void btnCancel_Click(object sender, EventArgs e) { ClearForm(); } #endregion #region ClearForm Function private void ClearForm() { txtUserNm.Text = "" ; txtPassword.Text = "" ; txtFName.Text = "" ; txtLastNm.Text = "" ; ddlDOBDay.SelectedValue = "Day" ; ddlDOBMonth.SelectedValue = "Month" ; ddlDOBYear.SelectedValue = "Year" ; ddlCountry.SelectedValue = "Select Country" ; ddlState.SelectedValue = "Select State" ; ddlCity.SelectedValue = "Select City" ; txtEmail.Text = "" ; txtMobileNo.Text = "" ; txtPincode.Text = "" ; } #endregion #region UserName Textbox Change Event protected void txtUserNm_TextChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtUserNm.Text)) { string scon = connect.GetConnection(); string nm = txtUserNm.Text; string qry = "select UserName from PassengerInfo where UserName='" + nm + "'" ; SqlConnection conn = new SqlConnection(scon); conn.Open(); SqlCommand cmd = new SqlCommand(qry, conn); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { lblStatus.Text = "UserName Already Taken" ; } else { lblStatus.Text = "UserName Available" ; } conn.Close(); } } #endregion }
Admin.aspx.cs
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class Admin : System.Web.UI.Page { ConnClass connect = new ConnClass(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { showTrainGrid(); showPassengerGrid(); } } #region ShowPassenger Info private DataSet showPassengerGrid() { string scon = connect.GetConnection(); SqlConnection conn = new SqlConnection(scon); conn.Open(); string qry = "select * from PassengerInfo" ; SqlCommand cmd = new SqlCommand(qry, conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.TableMappings.Add("Table" , "PassengerInfo" ); DataSet ds = new DataSet( "PassengerInfo" ); sda.Fill(ds); grdPassengerInfo.DataSource = ds; grdPassengerInfo.DataBind(); if (grdPassengerInfo.Columns.Count > 0) { grdPassengerInfo.Columns[1].Visible = false ; } return ds; } #endregion #region gridTrain rowEditing protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; showTrainGrid(); } #endregion #region show Train Info private DataSet showTrainGrid() { string scon = connect.GetConnection(); SqlConnection conn = new SqlConnection(scon); conn.Open(); string qry = "select * from Train" ; SqlCommand cmd = new SqlCommand(qry, conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.TableMappings.Add("Table" , "Train" ); DataSet ds = new DataSet( "Train" ); sda.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); if (GridView1.Columns.Count > 0) { GridView1.Columns[1].Visible = false ; } return ds; } #endregion #region Gridrow deleting protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { ViewState["TrainID" ] = GridView1.DataKeys[GridView1.SelectedIndex]; string scon = connect.GetConnection(); string query = "select * from TrainBookingDetails" ; SqlDataAdapter sda = new SqlDataAdapter(query, scon); DataSet ds = new DataSet(); sda.Fill(ds); } #endregion #region Grid Updating protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string trainid=(GridView1.DataKeys[e.RowIndex].Value.ToString()); string trainNo=((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text; string trainNm = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text; string source = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text; string destination = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text; string amt = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text; string scon = connect.GetConnection(); SqlConnection conn=new SqlConnection(scon); conn.Open(); string qry="Update Train set TrainNumber=" +trainNo+ " ,TrainName='" +trainNm+"', SourceStationName='"+source+"' ,DestinationStationName= '"+destination+"' ,Amount= "+amt+" where TrainID="+trainid+" "; SqlCommand cmd = new SqlCommand(qry, conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); GridView1.EditIndex = -1; showTrainGrid(); } #endregion #region grid Cancling protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView1.EditIndex = -1; showTrainGrid(); } #endregion #region Add New Train protected void btnAddNew_Click(object sender, EventArgs e) { if (txtTrainNo.Text != "" && txtTrainName.Text != "" && txtSourceStat.Text != "" && txtDestStat.Text != "" && txtAmt.Text != "" ) { int trainNo = Convert.ToInt32(txtTrainNo.Text); string trainNM = txtTrainName.Text; string sourceSta = txtSourceStat.Text; string DestStat = txtDestStat.Text; double amt = Convert.ToDouble(txtAmt.Text); string scon = connect.GetConnection(); string qry = "Insert Into Train (TrainNumber,TrainName, SourceStationName,DestinationStationName,Amount) Values(" + trainNo + " , '" + trainNM + "' , '" + sourceSta + "' , '" + DestStat + "' , " + amt + " )"; SqlDataAdapter sda = new SqlDataAdapter(qry, scon); DataSet ds = new DataSet(); sda.Fill(ds); txtTrainNo.Text = "" ; txtTrainName.Text = "" ; txtSourceStat.Text = "" ; txtDestStat.Text = "" ; txtAmt.Text = "" ; showTrainGrid(); } else { this .ModalPopupExtender1.Show(); } } #endregion #region Popup extender protected void Button1_Click(object sender, EventArgs e) { this .ModalPopupExtender1.Show(); } #endregion #region gridTrain page indexing protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; showTrainGrid(); } #endregion #region grid Passenger Page Indexing protected void grdPassengerInfo_PageIndexChanging(object sender, GridViewPageEventArgs e) { grdPassengerInfo.PageIndex = e.NewPageIndex; showPassengerGrid(); } #endregion protected void LoginStatus1_LoggingOut(object sender, LoginCancelEventArgs e) { LoginStatus n = new LoginStatus(); n.Page.Session.Abandon(); } protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) { string sortExpression = e.SortExpression; if (GridViewSortDirection == SortDirection.Ascending) { GridViewSortDirection = SortDirection.Descending; SortGridTrainView(sortExpression, DESCENDING); } else { GridViewSortDirection = SortDirection.Ascending; SortGridTrainView(sortExpression, ASCENDING); } } private void SortGridTrainView(string sortExpression, string Direction) { DataTable dtable = showTrainGrid().Tables[0]; DataView dv = new DataView(dtable); dv.Sort = sortExpression + Direction; GridView1.DataSource = dv; GridView1.DataBind(); } private const string ASCENDING = " ASC" ; private const string DESCENDING = " DESC" ; protected void grdPassengerInfo_Sorting(object sender, GridViewSortEventArgs e) { string sortExpression = e.SortExpression; if (GridViewSortDirection == SortDirection.Ascending) { GridViewSortDirection = SortDirection.Descending; SortGridView(sortExpression, DESCENDING); } else { GridViewSortDirection = SortDirection.Ascending; SortGridView(sortExpression, ASCENDING); } } private void SortGridView(string sortExpression, string Direction) { DataTable dt = showPassengerGrid().Tables[0]; DataView dv = new DataView(dt); dv.Sort = sortExpression + Direction; grdPassengerInfo.DataSource = dv; grdPassengerInfo.DataBind(); } public SortDirection GridViewSortDirection { get { if (ViewState[ "sortDirection" ] == null ) ViewState["sortDirection" ] = SortDirection.Ascending; return (SortDirection)ViewState[ "sortDirection" ]; } set { ViewState["sortDirection" ] = value; } } } <%@ Page Language="C#" AutoEventWireup= "true" CodeFile= "BookingDetails.aspx.cs" Inherits= "BookingDetails" %> <!DOCTYPE html PUBLIC "- Transitional <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server" > <title>Booking Details</title> <link href="CSS/StyleSheet.css" rel= "stylesheet" type= "text/css" /> <link rel="shortcut icon" href= "Image/Train.ico" /> </head> <body> <form id="form1" runat= "server" > <h1>List of Trains are Booked by <asp:Label ID="lblsession" runat= "server" ForeColor= "RoyalBlue" ></asp:Label>...</h1> <div> <asp:LoginStatus ID="LoginStatus1" runat= "server" LogoutAction="Redirect" LogoutPageUrl= "~/Default.aspx" Style="z-index: 100; left: 883px; position: absolute; top: 32px" LoginText= "Logout" /> <asp:GridView ID="grdPassengerInfo" runat= "server" AutoGenerateColumns="False" AllowPaging= "True" CssClass= "mGrid" PageSize="5" OnPageIndexChanging= "grdPassengerInfo_PageIndexChanging" OnRowDeleting="grdPassengernfo_RowDeleting" AllowSorting= "True" AutoGenerateDeleteButton="True" OnSorting= "grdPassengerInfo_Sorting" > <Columns> <asp:BoundField DataField="TrainBookingID" HeaderText= "TrainBookingID" > <HeaderStyle CssClass="HideGridCol" /> <ItemStyle CssClass="HideGridCol" /> </asp:BoundField > <asp:BoundField DataField="FirstName" HeaderText= "Fist Name" SortExpression= "FirstName" /> <asp:BoundField DataField="LastName" HeaderText= "Last Name" SortExpression= "LastName" /> <asp:BoundField DataField="City" HeaderText= "City" SortExpression= "City" /> <asp:BoundField DataField="MobileNo" HeaderText= "Mobile No." SortExpression= "MobileNo" /> <asp:BoundField DataField="TrainNumber" HeaderText= "Train Number" SortExpression= "TrainNumber" /> <asp:BoundField DataField="TrainName" HeaderText= "Train Name" SortExpression= "TrainName" /> <asp:BoundField DataField="SourceStation" HeaderText= "Source Station" SortExpression= "SourceStation" /> <asp:BoundField DataField="DestinationStation" HeaderText="Destination Station" SortExpression= "DestinationStation" /> <asp:BoundField DataField="PaymentBy" HeaderText= "Payment By" SortExpression= "PaymentBy" /> <asp:BoundField DataField="Amount" HeaderText= "Amount" SortExpression= "Amount" /> </Columns> </asp:GridView> </div> </form> </body> </html>
BookingDetails.aspx.cs
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Diagnostics; using System.Collections.Generic; public partial class BookingDetails : System.Web.UI.Page { ConnClass connect = new ConnClass(); #region Page_Load protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string scon = connect.GetConnection(); string uid = Request.QueryString["PassengerId" ]; string qry = "select * from TrainBookingDetails where status='" + 0 + "' and PassengerID=" + uid; SqlDataAdapter sda = new SqlDataAdapter(qry, scon); DataSet ds = new DataSet(); sda.Fill(ds); grdPassengerInfo.DataSource = ds; grdPassengerInfo.DataBind(); if (grdPassengerInfo.Columns.Count > 0) { grdPassengerInfo.Columns[0].Visible = false ; } } Response.Cache.SetAllowResponseInBrowserHistory(true ); lblsession.Text=Convert.ToString(Session["UserName" ]); } #endregion #region fill grid private DataSet bindGrid() { string scon = connect.GetConnection(); string uid = Request.QueryString["PassengerId" ]; string qry = "select * from TrainBookingDetails where status='" + false + "' and PassengerID=" + uid; SqlDataAdapter sda = new SqlDataAdapter(qry, scon); DataSet ds = new DataSet(); sda.Fill(ds); grdPassengerInfo.DataSource = ds; grdPassengerInfo.DataBind(); if (grdPassengerInfo.Columns.Count > 0) { grdPassengerInfo.Columns[1].Visible = false ; } return ds; } #endregion #region pageIndexing protected void grdPassengerInfo_PageIndexChanging(object sender, GridViewPageEventArgs e) { grdPassengerInfo.PageIndex = e.NewPageIndex; bindGrid(); } #endregion protected void grdPassengerInfo_RowDeleting(object sender, GridViewDeleteEventArgs e) { where TrainBookingID=" + row.Cells[1].Text + " "; where TrainBookingID=" + row.Cells[1].Text + " "; } #region grid row deleting protected void grdPassengernfo_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow row = (GridViewRow)grdPassengerInfo.Rows[e.RowIndex]; string scon = connect.GetConnection(); where TrainBookingID=" + row.Cells[1].Text + " "; string qry = "Update TrainBookingDetails set [Status]='" + true + "' where TrainBookingID=" + row.Cells[1].Text + " "; SqlDataAdapter sda = new SqlDataAdapter(qry, scon); DataSet ds = new DataSet(); sda.Fill(ds); bindGrid(); } #endregion private const string ASCENDING = " ASC" ; private const string DESCENDING = " DESC" ; protected void grdPassengerInfo_Sorting(object sender, GridViewSortEventArgs e) { string sortExpression = e.SortExpression; if (GridViewSortDirection == SortDirection.Ascending) { GridViewSortDirection = SortDirection.Descending; SortGridView(sortExpression, DESCENDING); } else { GridViewSortDirection = SortDirection.Ascending; SortGridView(sortExpression, ASCENDING); } } private void SortGridView(string sortExpression, string direction) { DataTable dt = bindGrid().Tables[0]; DataView dv = new DataView(dt); dv.Sort = sortExpression + direction; grdPassengerInfo.DataSource = dv; grdPassengerInfo.DataBind(); } public SortDirection GridViewSortDirection { get { if (ViewState[ "sortDirection" ] == null ) ViewState["sortDirection" ] = SortDirection.Ascending; return (SortDirection)ViewState[ "sortDirection" ]; } set { ViewState["sortDirection" ] = value; } } } <%@ Page Language="C#" AutoEventWireup= "true" CodeFile= "BookTrains.aspx.cs" Inherits= "PassengerProfile" %> <!DOCTYPE html PUBLIC "- Transitional <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server" > <title>Untitled Page</title> <link rel="shortcut icon" href= "Image/Train.ico" /> </head> <body> <form id="form1" runat= "server" > <div> <asp:Label ID="lblHi" runat= "server" Text= "Hi" style="z-index: 102; left: 662px; position: absolute; top: 18px"></asp:Label> <asp:Label ID="lblName" runat= "server" Text= "" style="z-index: 101; left: 687px; position: absolute; top: 17px"></asp:Label><br /> <asp:LinkButton ID="lnkeditProfile" runat= "server" >Book Train</asp:LinkButton> <table> <tr> <td> <asp:Label ID="lblFName" runat= "server" Text= "First Name" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:TextBox ID="txtFName" runat= "server" ReadOnly= "True" ></asp:TextBox></td> </tr> <tr> <td> <asp:Label ID="lblLName" runat= "server" Text= "Last Name" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:TextBox ID="txtLName" runat= "server" ReadOnly= "True" ></asp:TextBox></td> </tr> <tr> <td> <asp:Label ID="lblCountry" runat= "server" Text= "Country" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:DropDownList ID="ddlCountry" runat= "server" AutoPostBack="True" OnSelectedIndexChanged= "ddlCountry_SelectedIndexChanged" > </asp:DropDownList></td> </tr> <tr> <td> <asp:Label ID="lblState" runat= "server" Text= "State" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:DropDownList ID="ddlState" runat= "server" AutoPostBack= "True" OnSelectedIndexChanged="ddlState_SelectedIndexChanged" > </asp:DropDownList></td> </tr> <tr> <td> <asp:Label ID="lblCity" runat= "server" Text= "City" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:DropDownList ID="ddlCity" runat= "server" AutoPostBack= "True" > </asp:DropDownList></td> </tr> <tr> <td> <asp:Label ID="lblPincode" runat= "server" Text= "PinCode" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:TextBox ID="txtPincode" runat= "server" ReadOnly= "True" ></asp:TextBox></td> </tr> <tr> <td> <asp:Label ID="lblMob" runat= "server" Text= "Mobile Number" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:TextBox ID="txtMobNo" runat= "server" ReadOnly= "True" ></asp:TextBox></td> </tr> <tr> <td> <asp:Label ID="lblEmail" runat= "server" Text= "Email" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:TextBox ID="txtEmail" runat= "server" ReadOnly= "True" ></asp:TextBox></td> </tr> <tr> <td> <asp:Label ID="lblTrainName" runat= "server" Text= "Train Name" Font-Bold="True" ></asp:Label></td> <td style="width: 199px" > <asp:DropDownList ID="ddlTrainName" runat= "server" AutoPostBack= "True" OnSelectedIndexChanged="ddlTrainName_SelectedIndexChanged" > </asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate= "ddlTrainName" ErrorMessage=" Select Train Name" InitialValue="Select Train" ToolTip= "Select Train Name" >*</asp:RequiredFieldValidator></td> </tr> <tr> <td> <asp:Label ID="lblTrainNo" runat= "server" Text= "Train Number" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:TextBox ID="txtTrainNo" runat= "server" ReadOnly= "True" ></asp:TextBox></td> </tr> <tr> <td> <asp:Label ID="lblSourceStation" runat= "server" Text="Source Station" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:DropDownList ID="ddlSourceStation" runat= "server" > </asp:DropDownList></td> </tr> <tr> <td> <asp:Label ID="lblDestinationStation" runat= "server" Text="Destination Station" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:DropDownList ID="ddlDestinationStation" runat= "server" > </asp:DropDownList></td> </tr> <tr> <td> <asp:Label ID="lblPaymentBy" runat= "server" Text= "Payment By" Font-Bold= "True" > </asp:Label></td> <td style="width: 199px" > <asp:DropDownList ID="ddlPaymentBy" runat= "server" > </asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate= "ddlPaymentBy" ErrorMessage=" Select Card Type" InitialValue= "Select Card Type" ToolTip="Select Card Type" >*</asp:RequiredFieldValidator></td> </tr> <tr> <td> <asp:Label ID="lblAmount" runat= "server" Text= "Amount" Font-Bold= "True" ></asp:Label></td> <td style="width: 199px" > <asp:TextBox ID="txtAmount" runat= "server" ReadOnly= "True" ></asp:TextBox></td> </tr> <tr> <td> <asp:Button ID="btnBKTrainTk" runat= "server" Text="Book Train Ticket" OnClick= "btnBKTrainTk_Click" Font-Bold= "True" /></td> <td style="width: 199px" > <asp:LinkButton ID="lnkEdit" runat= "server" OnClick= "lnkEdit_Click" > Edit UserInfo</asp:LinkButton> <asp:LinkButton ID="lnkUpdate" runat= "server" OnClick= "lnkUpdate_Click" > Update UserInfo</asp:LinkButton></td> </tr> </table> </div> <asp:ValidationSummary ID="ValidationSummary1" runat= "server" /> </form> </body> </html>
BookTrains.aspx.cs
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Collections.Specialized; public partial class PassengerProfile : System.Web.UI.Page { ConnClass connect = new ConnClass(); #region Page_Load protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string unm = Convert.ToString(Session["UserName" ]); lblName.Text = unm; lnkEdit.Text = "Edit User Info" ; lnkUpdate.Visible = false ; if (Request.QueryString[ "url1" ] != "" ) { HttpRequest q = Request; NameValueCollection n = q.QueryString; if (n.HasKeys()) { int uid = Convert.ToInt32(n.Get(0)); string sqlCon = connect.GetConnection(); SqlConnection scon = new SqlConnection(sqlCon); string qry = "select * from PassengerInfo where PassengerId=" + uid; SqlCommand cmd = new SqlCommand(qry, scon); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { txtFName.Text = dt.Rows[0]["FirstName" ].ToString(); txtLName.Text = dt.Rows[0]["LastName" ].ToString(); ddlCountry.DataSource = dt; ddlCountry.DataTextField = "Country" ; ddlCountry.DataValueField = "PassengerId" ; ddlCountry.DataBind(); ddlState.DataSource = dt; ddlState.DataTextField = "State" ; ddlState.DataValueField = "PassengerId" ; ddlState.DataBind(); ddlCity.DataSource = dt; ddlCity.DataTextField = "City" ; ddlCity.DataValueField = "PassengerId" ; ddlCity.DataBind(); txtPincode.Text = dt.Rows[0]["Pincode" ].ToString(); txtMobNo.Text = dt.Rows[0]["MobileNo" ].ToString(); txtEmail.Text = dt.Rows[0]["Email" ].ToString(); } } } fillTrainInfo(); ddlPaymentBy.Items.Add("Credit Card" ); ddlPaymentBy.Items.Add("Debit Card" ); ddlPaymentBy.Items.Insert(0, "Select Card Type" ); } } #endregion #region Fill Train Dropdown private void fillTrainInfo() { string sqlCon = connect.GetConnection(); SqlConnection scon = new SqlConnection(sqlCon); string query = "select * from Train" ; SqlCommand cmd = new SqlCommand(query, scon); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { ddlTrainName.DataSource = dt; ddlTrainName.DataTextField = "TrainName" ; ddlTrainName.DataValueField = "TrainID" ; ddlTrainName.DataBind(); ddlTrainName.Items.Insert(0, "Select Train" ); } } #endregion #region Fill All Train Info protected void ddlTrainName_SelectedIndexChanged(object sender, EventArgs e) { if (ddlTrainName.SelectedValue != "Select Train" ) { string sqlconn = connect.GetConnection(); SqlConnection scon = new SqlConnection(sqlconn); string qry = "select * from Train where TrainID=" + ddlTrainName.SelectedValue; ViewState["TRAINID" ] = ddlTrainName.SelectedValue; int trainid = Convert.ToInt32(ViewState[ "TRAINID" ]); SqlCommand cmd = new SqlCommand(qry, scon); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { txtTrainNo.Text = dt.Rows[0]["TrainNumber" ].ToString(); ddlSourceStation.DataSource = dt; ddlSourceStation.DataTextField = "SourceStationName" ; ddlSourceStation.DataValueField = "TrainID" ; ddlSourceStation.DataBind(); ddlDestinationStation.DataSource = dt; ddlDestinationStation.DataTextField = "DestinationStationName" ; ddlDestinationStation.DataValueField = "TrainID" ; ddlDestinationStation.DataBind(); txtAmount.Text = dt.Rows[0]["Amount" ].ToString(); } } } #endregion #region Insert Book Train info protected void btnBKTrainTk_Click(object sender, EventArgs e) { string fnm = txtFName.Text; string lnm = txtLName.Text; string country = Convert.ToString(ddlCountry.SelectedItem); string state = Convert.ToString(ddlState.SelectedItem); string city = Convert.ToString(ddlCity.SelectedItem); int pin = Convert.ToInt32(txtPincode.Text); string mob = txtMobNo.Text; string email = txtEmail.Text; string trainNm = Convert.ToString(ddlTrainName.SelectedItem); int trainNo = Convert.ToInt32(txtTrainNo.Text); string soureceStation= Convert.ToString(ddlSourceStation.SelectedItem); string DestStation= Convert.ToString(ddlDestinationStation.SelectedItem); string payBy = Convert.ToString(ddlPaymentBy.SelectedItem); double amt = Convert.ToDouble (txtAmount.Text); int trainid = Convert.ToInt32(ViewState[ "TRAINID" ]); if (Request.QueryString[ "url1" ] != "" ) { HttpRequest q = Request; NameValueCollection n = q.QueryString; if (n.HasKeys()) { int uid = Convert.ToInt32(n.Get(0)); string scon = connect.GetConnection(); string query = "insert into TrainBookingDetails(FirstName,LastName,Country,State,City, MobileNo,Email,PinCode,TrainNumber,TrainName,SourceStation,DestinationStation,PaymentBy, Amount,TrainID,PassengerID,status)values('" + fnm + "' , '" + lnm + "' , '" + country + "' , '" + state + "' , '" + city + "' , '" + mob + "' , '" + email + "' , " + pin + " , " + trainNo + " , '" + trainNm + "' , '" + soureceStation + "' , '" + DestStation + "' , '" + payBy + "' , " + amt + " , " + trainid + " , " + uid + " , "+0+" )"; SqlDataAdapter sda = new SqlDataAdapter(query, scon); DataSet ds = new DataSet(); sda.Fill(ds); Response.Write("<script language='javascript' type='text/javascript' >alert( 'Train Booked Successfully..' ) </script>"); string url = "BookingDetails.aspx?PassengerId=" + uid; Response.Redirect(url); } } } private void ClaearForm() { txtFName.Text="" ; txtLName.Text="" ; ddlCountry.SelectedIndex = -1; ddlState.SelectedIndex = -1; ddlCity.SelectedIndex = -1; txtPincode.Text = "" ; txtMobNo.Text="" ; txtEmail.Text="" ; ddlTrainName.SelectedValue = "Select Train" ; txtTrainNo.Text = "" ; ddlSourceStation.SelectedIndex = -1; ddlDestinationStation.SelectedIndex = -1; ddlPaymentBy.SelectedValue = "Select Card Type" ; txtAmount.Text="" ; } #endregion #region edit user profile protected void lnkEdit_Click(object sender, EventArgs e) { txtFName.ReadOnly = false ; txtLName.ReadOnly = false ; string sqlconn = connect.GetConnection(); string Qry = "select * from CountryMaster" ; SqlDataAdapter sda = new SqlDataAdapter(Qry, sqlconn); DataSet ds = new DataSet(); sda.Fill(ds); ddlCountry.DataSource = ds; ddlCountry.DataTextField = "CountryName" ; ddlCountry.DataValueField = "CountryID" ; ddlCountry.DataBind(); ddlCountry.Items.Insert(0, "Select Country" ); txtPincode.ReadOnly = false ; txtMobNo.ReadOnly = false ; txtEmail.ReadOnly = false ; btnBKTrainTk.Visible = false ; lnkEdit.Visible = false ; lnkUpdate.Visible = true ; } #endregion #region fill state protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { if (ddlCountry.SelectedValue != "Select Country" ) { string sqlconn = connect.GetConnection(); string qry = "select * from StateMaster where CountryID=" + ddlCountry.SelectedValue; SqlDataAdapter sda = new SqlDataAdapter(qry, sqlconn); DataSet ds = new DataSet(); sda.Fill(ds); ddlState.DataSource = ds; ddlState.DataTextField = "StateName" ; ddlState.DataValueField = "StateID" ; ddlState.DataBind(); ddlState.Items.Insert(0, "Select State" ); } } #endregion #region Fill City protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) { if (ddlCountry.SelectedValue != "Select State" ) { string sqlconn = connect.GetConnection(); string qry = "select * from CityMaster where stateID=" + ddlState.SelectedValue + " and CountryID=" + ddlCountry.SelectedValue; SqlDataAdapter sda = new SqlDataAdapter(qry, sqlconn); DataSet ds = new DataSet(); sda.Fill(ds); ddlCity.DataSource = ds; ddlCity.DataTextField = "CityName" ; ddlCity.DataValueField = "CityID" ; ddlCity.DataBind(); ddlCity.Items.Insert(0, "Select City" ); } } #endregion #region update UserInfo protected void lnkUpdate_Click(object sender, EventArgs e) { if (Request.QueryString[ "url1" ] != "" ) { HttpRequest q = Request; NameValueCollection n = q.QueryString; if (n.HasKeys()) { int uid = Convert.ToInt32(n.Get(0)); string fnm = txtFName.Text; string lnm = txtLName.Text; string country = Convert.ToString(ddlCountry.SelectedItem); string state = Convert.ToString(ddlState.SelectedItem); string city = Convert.ToString(ddlCity.SelectedItem); int pin = Convert.ToInt32(txtPincode.Text); string mob = txtMobNo.Text; string email = txtEmail.Text; string scon = connect.GetConnection(); string qry="Update PassengerInfo Set FirstName='" +fnm+"', LastName='"+lnm+"' , Country='"+country+"' ,State= '"+state+"' ,City= '"+city+"' , Pincode="+pin+" ,MobileNo= '"+mob+"' , Email='"+email+"' where PassengerId= "+uid+" "; SqlDataAdapter sda = new SqlDataAdapter(qry, scon); DataSet ds = new DataSet(); sda.Fill(ds); Response.Write("Updated...." ); } lnkEdit.Visible = true ; btnBKTrainTk.Visible = true ; lnkUpdate.Visible = false ; } } #endregion protected void btnCancel_Click(object sender, EventArgs e) { } }
Join the conversation! Your thoughts help the community grow.