private void BindRejectedSIPGrid()
        {
            if (txtFromSIP.SelectedDate != null)
            {
                fromDate = DateTime.Parse(txtFromSIP.SelectedDate.ToString());
            }
            if (txtToSIP.SelectedDate != null)
            {
                toDate = DateTime.Parse(txtToSIP.SelectedDate.ToString());
            }

            DataSet dsRejectedSIP = new DataSet();
            Dictionary <string, string> genDictIsRejected   = new Dictionary <string, string>();
            Dictionary <string, string> genDictRejectReason = new Dictionary <string, string>();

            dsRejectedSIP = uploadsCommonBo.GetRejectedAutoSIPRecords(adviserVo.advisorId, fromDate, toDate);

            //if (dsRejectedSIP.Tables[0].Rows.Count > 0)
            //{
            if (Cache["RejectedAutoSIPDetails" + adviserVo.advisorId.ToString()] == null)
            {
                Cache.Insert("RejectedAutoSIPDetails" + adviserVo.advisorId.ToString(), dsRejectedSIP);
            }
            else
            {
                Cache.Remove("RejectedAutoSIPDetails" + adviserVo.advisorId.ToString());
                Cache.Insert("RejectedAutoSIPDetails" + adviserVo.advisorId.ToString(), dsRejectedSIP);
            }
            gvAutoSIPReject.CurrentPageIndex = 0;
            gvAutoSIPReject.DataSource       = dsRejectedSIP.Tables[0];
            gvAutoSIPReject.DataBind();
            gvAutoSIPReject.Visible = true;
            if (dsRejectedSIP.Tables[0].Rows.Count > 0)
            {
                btnExport.Visible  = true;
                pnlAutoSIP.Visible = true;
            }

            //}
            //else
            //{
            //    gvAutoSIPReject.CurrentPageIndex = 0;
            //    gvAutoSIPReject.DataSource = null;
            //    gvAutoSIPReject.DataBind();
            //    //gvAutoSIPReject.Visible = false;

            //}
        }