protected void btnClick_btnAddSchedule(object sender, EventArgs e)
        {
            transportdata             = new TransportData();
            transport                 = new Transports();
            transport.ID              = 0;
            transport.RouteID         = Convert.ToInt32(dpRoute.SelectedItem.Value);
            transport.scheduleOuttime = txtScheduleOutTime.Text;
            transport.scheduleIntime  = txtScheduleInTime.Text;

            transport.CreatedBy   = GlobalInfo.Userid;
            transport.IsActive    = true;
            transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");

            transport.flag = "Insert";
            int Result = 0;

            Result = transportdata.AddTransportScheduleInfo(transport);
            if (Result > 0)
            {
                divDanger.Visible   = false;
                divwarning.Visible  = false;
                divSusccess.Visible = true;
                lblSuccess.Text     = "Schedule  Added  Successfully";

                ClearTextBox();
                GetScheduleInfo();
                pnlError.Update();
                upMain.Update();
                uprouteList.Update();
            }
            else
            {
                divDanger.Visible   = false;
                divwarning.Visible  = true;
                divSusccess.Visible = false;
                if (Result == -2627)
                {
                    lblwarning.Text = "Data Already Exists";
                }
                else
                {
                    lblwarning.Text = "Please Contact to Site Admin";
                }
                pnlError.Update();
            }
        }
        public void DeleteScheduleByID(int ID)
        {
            transportdata             = new TransportData();
            transport                 = new Transports();
            transport.ID              = Convert.ToInt32(ID);
            transport.RouteID         = 0;
            transport.scheduleOuttime = string.Empty;
            transport.scheduleIntime  = string.Empty;

            transport.CreatedBy   = GlobalInfo.Userid;
            transport.IsActive    = true;
            transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");

            transport.flag = "Delete";
            int Result = 0;

            Result = transportdata.AddTransportScheduleInfo(transport);
            if (Result > 0)
            {
                divDanger.Visible   = false;
                divwarning.Visible  = false;
                divSusccess.Visible = true;
                lblSuccess.Text     = "Schedule Deleted  Successfully";

                ClearTextBox();
                GetScheduleInfo();
                pnlError.Update();
                upMain.Update();
                uprouteList.Update();
            }
            else
            {
                divDanger.Visible   = false;
                divwarning.Visible  = true;
                divSusccess.Visible = false;
                lblwarning.Text     = "Please Contact to Site Admin";
                pnlError.Update();
            }
        }