public add_trip_info ViewTrip(int brt_id)
{
con.Open();
SqlCommand cmd = new SqlCommand("Viewbusdata", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@brt_id", SqlDbType.Int);
p.Value = brt_id;
SqlDataReader read = cmd.ExecuteReader();
add_trip_info info = new add_trip_info();
if (read.Read())
{
info.Day = read["day"].ToString();
info.Regn_no = read["bus_reg_no"].ToString();
info.Trip_no = int.Parse(read["trip_no"].ToString());
info.From = read["from"].ToString();
info.To = read["to"].ToString();
info.Time = read["trip_start_time"].ToString();
info.Category = read["trip_category"].ToString();
info.Towards = read["towards"].ToString();
}
read.Close();
con.Close();
return(info);
}
public void Update(add_trip_info inf)
{
con.Open();
SqlCommand cmd = new SqlCommand("UpdateTrip", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@brt_id", SqlDbType.Int);
p.Value = inf.Brt_id;
p = cmd.Parameters.Add("@day", SqlDbType.VarChar, 50);
p.Value = inf.Day;
p = cmd.Parameters.Add("@bus_reg_no", SqlDbType.VarChar, 50);
p.Value = inf.Regn_no;
p = cmd.Parameters.Add("@tripno", SqlDbType.Int);
p.Value = inf.Trip_no;
p = cmd.Parameters.Add("@from", SqlDbType.VarChar, 50);
p.Value = inf.From;
p = cmd.Parameters.Add("@to", SqlDbType.VarChar, 50);
p.Value = inf.To;
p = cmd.Parameters.Add("@trip_start_time", SqlDbType.VarChar, 50);
p.Value = inf.Time;
p = cmd.Parameters.Add("@towards", SqlDbType.VarChar, 50);
p.Value = inf.Towards;
p = cmd.Parameters.Add("@trip_category", SqlDbType.VarChar, 50);
p.Value = inf.Category;
cmd.ExecuteNonQuery();
con.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
add_trip_info inf = new add_trip_info();
add_trip_sp sp = new add_trip_sp();
inf.Regn_no = txtregno.Text;
inf.From = txtfrom.Text;
inf.To = txtto.Text;
inf.Time = (DD1.SelectedItem.ToString() + ":" + DD2.SelectedItem.ToString() + " " + ddlapm.SelectedItem.ToString());
inf.Trip_no = int.Parse(txttripno.Text);
inf.Category = ddlcategory.SelectedItem.ToString();
inf.Day = ddlday.SelectedItem.ToString();
inf.Towards = TextBox1.Text;
sp.Add(inf);
txtfrom.Text = "";
txtregno.Text = "";
txtto.Text = "";
txttripno.Text = "";
ddlday.ClearSelection();
ddlcategory.ClearSelection();
ddlapm.ClearSelection();
DD2.ClearSelection();
DD1.ClearSelection();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
lbpunchstname.Text = Session["username"].ToString();
lbdate.Text = System.DateTime.Now.Date.ToShortDateString();
lbtime.Text = System.DateTime.Now.ToShortTimeString();
lbday.Text = System.DateTime.Now.DayOfWeek.ToString();
lbarrtime.Text = System.DateTime.Now.ToShortTimeString();
add_trip_info info = new add_trip_info();
add_trip_sp sp = new add_trip_sp();
info = sp.ViewTrip(int.Parse(GridView1.SelectedValue.ToString()));
lbbus_no.Text = info.Regn_no.ToString();
lbtrip_no.Text = info.Trip_no.ToString();
lbfrom.Text = info.From.ToString();
lbto.Text = info.To.ToString();
//ArrayList arr = new ArrayList();
//for (int i = 0; i < busrootview.Count; i++)
//{
//float speed = new speed_tabe_Sp().ViewSpeed_Category(info.Category.ToString()).Speed;
//float distance = float.Parse(Session["distance"].ToString());
//float time = speed / distance;
//double timed = double.Parse(time.ToString());
DateTime dt = DateTime.Parse(info.Time.ToString());
//DateTime n = dt.AddHours(timed);
//DateTime st = DateTime.Now.AddMinutes(10);
//DateTime en = DateTime.Now.AddMinutes(-10);
//TimeSpan stt = st.TimeOfDay;
//TimeSpan ent = en.TimeOfDay;
//TimeSpan nt = n.TimeOfDay;
//int k = stt.CompareTo(nt);
//int j = ent.CompareTo(nt);
//if (k >= 0 && j <= 0)
//{
// add_trip_info add = new add_trip_info();
// add.Brt_id = int.Parse(busrootview[i]["brt_id"].ToString());
// arr.Add(add);
//}
//}
string check = Session["username"].ToString();
Label7.Text = dt.ToShortTimeString();
// arr.
MultiView1.SetActiveView(View2);
TimeSpan lat = (DateTime.Now.TimeOfDay).Subtract(dt.TimeOfDay);
// lat.
Label1.Text = int.Parse(lat.Hours.ToString()) + ":" + lat.Minutes.ToString() + ":" + lat.Seconds.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Redirect("majphome.aspx");
}
if (!IsPostBack)
{
DataView busrootview = new DataView(new add_trip_sp().ViewAllData());
busrootview.RowFilter = "day='" + (System.DateTime.Today.DayOfWeek) + "'";
//starttime+select spped from speedtable where tripcategory=tripcategory/sess["distance"]==currentime;
DataView dv = new DataView();
for (int i = 0; i < busrootview.Count; i++)
{
//float speed = new speed_tabe_Sp().ViewSpeed_Category(busrootview[i]["trip_category"].ToString()).Speed;
//float distance = float.Parse(Session["distance"].ToString());
//float time = speed / distance;
//double timed = double.Parse(time.ToString());
DateTime dt = DateTime.Parse(busrootview[i]["trip_start_time"].ToString());
//DateTime n = dt.AddHours(timed);
DateTime st = DateTime.Now.AddMinutes(5);
DateTime en = DateTime.Now.AddMinutes(-30);
TimeSpan stt = st.TimeOfDay;
TimeSpan ent = en.TimeOfDay;
TimeSpan nt = dt.TimeOfDay;
int k = stt.CompareTo(nt);
int j = ent.CompareTo(nt);
if (k >= 0 && j <= 0)
{
add_trip_info add = new add_trip_info();
add.Brt_id = int.Parse(busrootview[i]["brt_id"].ToString());
add.Category = busrootview[i]["trip_category"].ToString();
add.From = busrootview[i]["from"].ToString();
add.Regn_no = busrootview[i]["bus_reg_no"].ToString();
add.To = busrootview[i]["to"].ToString();
add.Trip_no = int.Parse(busrootview[i]["trip_no"].ToString());
arr.Add(add);
}
}
GridView1.DataSource = arr;
GridView1.DataBind();
MultiView1.SetActiveView(View1);
}
//string check = Session["username"].ToString();
}
