public void GetOutOperationDetailsbyVechileId(int routeid, int Vehicleid)
        {
            transportdata       = new TransportData();
            DS                  = transportdata.GetOutOperationDetailsbyVechileId(routeid, Vehicleid);
            lblShowMessage.Text = string.Empty;
            lblDispatchId.Text  = string.Empty;

            if (!Comman.Comman.IsDataSetEmpty(DS))
            {
                lblDispatchId.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DispatchId"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DispatchId"].ToString();

                dpDriver.ClearSelection();
                if (dpDriver.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["FirstDriver"]).ToString()) != null)
                {
                    dpDriver.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["FirstDriver"]).ToString()).Selected = true;
                }
                dpDriver2.ClearSelection();
                if (dpDriver2.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["SecondDriver"]).ToString()) != null)
                {
                    dpDriver2.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["SecondDriver"]).ToString()).Selected = true;
                }
                dpSalesman.ClearSelection();
                if (dpSalesman.Items.FindByValue(DS.Tables[0].Rows[0]["SalesmanId"].ToString()) != null)
                {
                    dpSalesman.Items.FindByValue(DS.Tables[0].Rows[0]["SalesmanId"].ToString()).Selected = true;
                }
                dpSecondSalesmanId.ClearSelection();
                if (dpSecondSalesmanId.Items.FindByValue(DS.Tables[0].Rows[0]["SecondSalesman"].ToString()) != null)
                {
                    dpSecondSalesmanId.Items.FindByValue(DS.Tables[0].Rows[0]["SecondSalesman"].ToString()).Selected = true;
                }
                if (DS.Tables[0].Rows[0]["DispatchDate"].ToString() == "")
                {
                    txtDispatchDate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DispatchDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DispatchDate"].ToString();
                }
                else
                {
                    string startdate = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DispatchDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DispatchDate"].ToString();
                    //sky
                    DateTime date2 = Convert.ToDateTime(startdate, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
                    txtDispatchDate.Text = (Convert.ToDateTime(date2).ToString("yyyy-MM-dd"));
                }
                txtDispatchTime.Text    = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DispatchTime"].ToString()) ? string.Empty : (Convert.ToDateTime(DS.Tables[0].Rows[0]["DispatchTime"]).ToString("hh:mm"));
                txtSchedueOutTime.Text  = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ScheduleOutTime"].ToString()) ? string.Empty : (Convert.ToDateTime(DS.Tables[0].Rows[0]["ScheduleOutTime"]).ToString("hh:mm"));
                txtScheduleEndTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ScheduleInTime"].ToString()) ? string.Empty : (Convert.ToDateTime(DS.Tables[0].Rows[0]["ScheduleInTime"]).ToString("hh:mm"));
            }
            if (Comman.Comman.IsDataSetEmpty(DS))
            {
                lblShowMessage.Text = "Vehicle is not in Product Supply Operation";
            }
        }