/// <summary>
    /// date selected index changed
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void rdtp_strtdate_SelectedDateChanged(object sender, Telerik.Web.UI.Calendar.SelectedDateChangedEventArgs e)
    {
        try
        {
            if (rdtp_strtdate.SelectedDate != null)
            {
                DataTable dt = new DataTable();
                Rcmb_Trg.DataSource = dt;
                Rcmb_Trg.DataBind();
                rtp_starttime.SelectedDate = null;
                rtp_endtime.SelectedDate   = null;
                lbl_starttime.Visible      = true;
                rtp_starttime.Visible      = true;
                nogradeid.Visible          = false;
                lbl_endtime.Visible        = true;
                rtp_endtime.Visible        = true;
                Lbl_Trg.Visible            = true;
                Rcmb_Trg.Visible           = true;
                lbl_Employee.Visible       = false;
                Rcm_Employee.Visible       = false;
                expertise_id.Visible       = false;
                Rg_SaveTrgFeedback.Visible = false;

                Rcmb_Trg.SelectedIndex = -1;
                CHGEXPERTID.Visible    = false;
                SMHR_TRAINEE _obj_Smhr_TrnEE = new SMHR_TRAINEE();
                _obj_Smhr_TrnEE.Mode           = 14;
                _obj_Smhr_TrnEE.TRAINEE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
                _obj_Smhr_TrnEE.TRAINEE_EMPID  = Convert.ToInt32(Session["EMP_ID"]);
                DataTable             dtemp15 = BLL.get_TRAINEE(_obj_Smhr_TrnEE);
                SMHR_TRAININGSCHEDULE _obj_Smhr_TRAININGSCHEDULE = new SMHR_TRAININGSCHEDULE();
                SMHR_TRAININGREQUEST  _obj_Smhr_TrgRqst          = new SMHR_TRAININGREQUEST();
                _obj_Smhr_TrgRqst.Mode      = 21;
                _obj_Smhr_TrgRqst.TR_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
                DataTable DT455 = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
                _obj_Smhr_TRAININGSCHEDULE.Mode = 9;//YYY
                for (int i = 0; i < DT455.Rows.Count; i++)
                {
                    if ((Convert.ToInt32(DT455.Rows[i]["login_emp_id"]) == Convert.ToInt32(Session["EMP_ID"])))
                    {
                        _obj_Smhr_TRAININGSCHEDULE.TS_PARAM1 = 0;
                        break;
                    }
                    else
                    {
                        _obj_Smhr_TRAININGSCHEDULE.TS_PARAM1 = Convert.ToInt32(Session["EMP_ID"]);
                    }
                }

                _obj_Smhr_TRAININGSCHEDULE.TS_LASTMDFDATE = Convert.ToDateTime(rdtp_strtdate.SelectedDate);
                _obj_Smhr_TRAININGSCHEDULE.TS_ORG_ID      = Convert.ToInt32(Session["ORG_ID"]);
                DataTable dttime = BLL.get_TRAININGSCHEDULE(_obj_Smhr_TRAININGSCHEDULE);

                if (dttime.Rows.Count != 0)
                {
                    //here based on date i am getting training,starttime,endtime
                    rtp_starttime.SelectedDate = Convert.ToDateTime(dttime.Rows[0]["SESSION_STARTTIME"]);

                    rtp_endtime.SelectedDate = Convert.ToDateTime(dttime.Rows[0]["SESSION_ENDTIME"]);
                    Rcmb_Trg.DataSource      = dttime;
                    Rcmb_Trg.DataValueField  = "TR_ID";
                    Rcmb_Trg.DataTextField   = "TR_TITLE";
                    Rcmb_Trg.DataBind();
                    Rcmb_Trg.Items.Insert(0, new RadComboBoxItem("Select"));
                }

                else
                {
                    BLL.ShowMessage(this, "No Training Exists On This Date");
                }
            }
            else
            {
                BLL.ShowMessage(this, "Please Select Date");

                lbl_starttime.Visible = false;
                rtp_starttime.Visible = false;

                lbl_endtime.Visible = false;
                rtp_endtime.Visible = false;
                Lbl_Trg.Visible     = false;
                Rcmb_Trg.Visible    = false;

                lbl_Employee.Visible       = false;
                Rcm_Employee.Visible       = false;
                expertise_id.Visible       = false;
                Rg_SaveTrgFeedback.Visible = false;
                CHGEXPERTID.Visible        = false;
            }
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_SaveTrgfeedbackquestion", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }
    protected void LoadGrid()
    {
        try
        {
            SMHR_TRAININGSCHEDULE _obj_Smhr_TRAININGSCHEDULE = new SMHR_TRAININGSCHEDULE();


            _obj_Smhr_TRAININGSCHEDULE.Mode = 4;
            DataTable dt = BLL.get_TRAININGSCHEDULE(_obj_Smhr_TRAININGSCHEDULE);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string b = Convert.ToString(dt.Rows[i]["SESSION_ID"].ToString());
                string a = Convert.ToString(dt.Rows[i]["employeename"].ToString());
                string k = Convert.ToString(dt.Rows[i]["TR_TITLE"].ToString());

                DateTime M = Convert.ToDateTime(dt.Rows[i]["SESSION_STARTTIME"]);
                string   Y = M.TimeOfDay.ToString();

                DateTime N = Convert.ToDateTime(dt.Rows[i]["SESSION_ENDTIME"]);
                string   O = N.TimeOfDay.ToString();

                string Q = a + " " + k + " " + Y + " To " + O;



                // string c = Convert.ToString(dt.Rows[i]["Tr_TrainerName"].ToString());
                RadScheduler1.InsertAppointment(new Appointment(b, Convert.ToDateTime(dt.Rows[i]["SESSION_DATE"].ToString()), Convert.ToDateTime(dt.Rows[i]["SESSION_DATE"].ToString()), Q));
                //Convert.ToDateTime(dt.Rows[i]["Tr_Date"].ToString()), Convert.ToDateTime(dt.Rows[i]["Tr_Time"].ToString()),c, b));
                //TextBox t = new TextBox();
                //RadScheduler1.ToolTip = Q;
                //RadScheduler1.ToolTip = "<table width='250' border='0'> " +
                //                        "<tr> " +
                //                        "<td> <h4> Training Details </h4> </td>" +
                //                        "</tr> " +

                //                        "<tr> " +
                //                        "<td> <br/>" +
                //                        "</td> " +
                //                        "</tr> " +
                //                        "<tr> " +
                //                        "<td> Training Title :" + Convert.ToString(dt.Rows[0]["Tr_Name"]) + " </td> " +
                //                        "</tr> " +
                //                        "<tr> " +
                //                        "<td> From : " + Convert.ToString(dt.Rows[0]["Tr_Date"]) + "</td> " +
                //                        "</tr> " +
                //                        "<tr> " +
                //                        "<td> To :  " + Convert.ToString(dt.Rows[0]["Tr_End"]) + "</td> " +
                //                        "</tr> " +
                //                         "</tr> " +
                //                        "<tr> " +
                //                        "<td> Time :  " + Convert.ToString(dt.Rows[0]["Tr_Time"]) + "</td> " +
                //                        "</tr> " +
                //                          "<tr> " +
                //                        "<td> Trainer :  " + Convert.ToString(dt.Rows[0]["Tr_TrainerName"]) + "</td> " +
                //                        "</tr> " +
                //                        "</table><br/>";

                //Appointment a = new Appointment();
                //int a = Convert.ToInt32(dt.Rows[i]["Tr_Id"].ToString());
                //string b = Convert.ToString(dt.Rows[i]["Tr_Name"].ToString());
                ////string c = Convert.ToString(dt.Rows[i]["COURSESHD_AMOUNT"].ToString());
                //RadScheduler1.InsertAppointment(new Appointment(a));
            }
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingSchedule", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }