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);
}
