public int SearchUser(BeBooking user) { var connectionString = ConfigurationManager.ConnectionStrings["BusResSysConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand("usp_SearchUser", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@n", user.uid); try { SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { return(1); } else { return(0); } } catch { throw; } finally { con.Close(); con.Dispose(); } }
public DataTable SearchBus(BeBooking bus) { var connectionString = ConfigurationManager.ConnectionStrings["BusResSysConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand("usp_SearchBus", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@start", bus.start); cmd.Parameters.AddWithValue("@destination", bus.destination); cmd.Parameters.AddWithValue("@date", bus.dte); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); try { return(dt); } catch { throw; } finally { con.Close(); con.Dispose(); } }
public void InsertBooking(BeBooking bus) { var connectionString = ConfigurationManager.ConnectionStrings["BusResSysConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand("usp_FetchBusId", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@bus_name", bus.bus_name); SqlParameter bus_id = new SqlParameter("@bus_id", SqlDbType.VarChar, 50); bus_id.Direction = ParameterDirection.Output; cmd.Parameters.Add(bus_id); cmd.ExecuteNonQuery(); bus.bus_id = bus_id.Value.ToString(); SqlCommand cmd1 = new SqlCommand("usp_FetchRouteId", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@from", bus.start); cmd1.Parameters.AddWithValue("@to", bus.destination); SqlParameter route_id = new SqlParameter("@route_id", SqlDbType.VarChar, 50); route_id.Direction = ParameterDirection.Output; cmd1.Parameters.Add(route_id); cmd1.ExecuteNonQuery(); bus.route_id = route_id.Value.ToString(); SqlCommand cmd2 = new SqlCommand("usp_FetchScheduleId", con); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@route_id", bus.route_id); cmd2.Parameters.AddWithValue("@bus_id", bus.bus_id); SqlParameter schedule_id = new SqlParameter("@schedule_id", SqlDbType.VarChar, 50); schedule_id.Direction = ParameterDirection.Output; cmd2.Parameters.Add(schedule_id); cmd2.ExecuteNonQuery(); bus.schedule_id = schedule_id.Value.ToString(); SqlCommand cmd3 = new SqlCommand("usp_InsertBooking", con); cmd3.CommandType = CommandType.StoredProcedure; cmd3.Parameters.AddWithValue("@booking_id", bus.bookingid); cmd3.Parameters.AddWithValue("@schedule_id", bus.schedule_id); cmd3.Parameters.AddWithValue("@user_id", bus.uid); cmd3.Parameters.AddWithValue("@noOfTickets", bus.noOfTickets); cmd3.Parameters.AddWithValue("@doj", Convert.ToDateTime(bus.dte.Date.ToString().Substring(0, 9))); cmd3.ExecuteNonQuery(); con.Close(); con.Dispose(); }
public DataTable SearchBus(BeBooking bus) { try { DalBooking2 dal1 = new DalBooking2(); DataTable dt = dal1.SearchBus(bus); return(dt); } catch { throw; } finally { dal = null; } }
public int SearchUser(BeBooking user) { DalBooking1 dal = new DalBooking1(); try { int val = dal.SearchUser(user); return(val); } catch { throw; } finally { dal = null; } }
protected void btnSubmit_Click(object sender, EventArgs e) { BalBooking1 bal = new BalBooking1(); BeBooking user = new BeBooking(); user.uid = Convert.ToInt32(userid.Text); if (bal.SearchUser(user) == 1) { Session["uid"] = userid.Text; Response.Redirect("BookingRoute.aspx"); } else { string script = "alert('No User Found');"; Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true); userid.Text = ""; } }
public void UpdateTicket(BeBooking bus) { var connectionString = ConfigurationManager.ConnectionStrings["BusResSysConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand("usp_UpdateTicket", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@from", bus.start); cmd.Parameters.AddWithValue("@to", bus.destination); cmd.Parameters.AddWithValue("@date", Convert.ToDateTime(bus.dte.Date.ToString().Substring(0, 9))); cmd.Parameters.AddWithValue("@tickets", bus.tot_tck - bus.noOfTickets); cmd.Parameters.AddWithValue("@busid", bus.bus_id); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { BeBooking bus = (BeBooking)Session["bus"]; BalBooking2 bal = new BalBooking2(); userid.Disabled = true; userid.Value = bus.uid.ToString(); uname.Value = bal.GetUser(bus); date.Value = bus.dte.Date.ToString().Substring(0, 9); cost.Value = bus.cost.ToString() + ".00"; time.Value = bus.time.ToLongTimeString().ToString().Substring(0, 8); bookingid.Value = bus.bookingid.ToString(); from.Value = bus.start; to.Value = bus.destination; busname.Value = bus.bus_name; noOftickets.Value = bus.noOfTickets.ToString(); Session.Clear(); } }
protected void rbSelector_CheckedChanged(object sender, EventArgs e) { foreach (GridViewRow oldrow in GridView1.Rows) { ((RadioButton)oldrow.FindControl("rbBus")).Checked = false; } //Set the new selected row RadioButton rb = (RadioButton)sender; GridViewRow row = (GridViewRow)rb.NamingContainer; ((RadioButton)row.FindControl("rbBus")).Checked = true; //Label1.Text = row.Cells[1].Text; BeBooking bus = (BeBooking)Session["bus"]; bus.bus_id = row.Cells[1].Text; bus.bus_name = row.Cells[2].Text; bus.time = (Convert.ToDateTime(row.Cells[7].Text)); bus.cost = Convert.ToSingle(row.Cells[8].Text); bus.tot_tck = Convert.ToInt32(row.Cells[6].Text); Session["bus"] = bus; }
public string GetUser(BeBooking user) { var connectionString = ConfigurationManager.ConnectionStrings["BusResSysConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand("usp_GetUser", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@uid", user.uid); SqlParameter parm = new SqlParameter("@name", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); cmd.ExecuteNonQuery(); string nam = parm.Value.ToString(); string name = cmd.Parameters["@name"].Value.ToString(); con.Close(); return(name); }
protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetExpires(DateTime.Now.AddSeconds(-1)); Response.Cache.SetNoStore(); if (Session.Count == 0) { Response.Redirect("Home.aspx"); } else { BalBooking2 bal = new BalBooking2(); bus = (BeBooking)Session["bus"]; userid.Value = bus.uid.ToString(); uname.Value = bal.GetUser(bus); start.Value = bus.start; destination.Value = bus.destination; time.Value = bus.time.ToLongTimeString().Substring(0, 8); busname.Value = bus.bus_name; date.Value = bus.dte.Date.ToString().Substring(0, 9); cost = bus.cost; ClientScript.RegisterArrayDeclaration("cost", "'" + cost + "'"); } }
public void UpdateTicket(BeBooking bus) { DalBooking2 dal = new DalBooking2(); dal.UpdateTicket(bus); }
public string GetUser(BeBooking user) { string name = dal.GetUser(user); return(name); }
public void InsertBooking(BeBooking bus) { dal.InsertBooking(bus); }