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