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 Button1_Click(object sender, EventArgs e)
{
string day = DropDownList1.SelectedItem.ToString();
string to = ddlto.SelectedItem.ToString();
add_trip_sp sp = new add_trip_sp();
DataTable tb = sp.ViewAllBusOfGivenRoot(to, day);
GridView1.DataSource = tb;
GridView1.DataBind();
MultiView1.SetActiveView(View2);
}
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();
}
