/// <summary> /// Get Order Book MIS /// </summary> protected void BindOrderBook() { DataSet dsOrderBookMIS = new DataSet(); DataTable dtOrderBookMIS = new DataTable(); if (txtOrderFrom.SelectedDate != null) { fromDate = DateTime.Parse(txtOrderFrom.SelectedDate.ToString()); } if (txtOrderTo.SelectedDate != null) { toDate = DateTime.Parse(txtOrderTo.SelectedDate.ToString()); } dsOrderBookMIS = OnlineMFOrderBo.GetOrderBookMIS(customerId, int.Parse(hdnAmc.Value), hdnOrderStatus.Value, fromDate, toDate, ddlOrderType.SelectedValue); dtOrderBookMIS = dsOrderBookMIS.Tables[0]; if (dtOrderBookMIS.Rows.Count > 0) { gvOrderBookMIS.DataSource = dtOrderBookMIS; gvOrderBookMIS.DataBind(); gvOrderBookMIS.Visible = true; pnlOrderBook.Visible = true; btnExport.Visible = true; trNoRecords.Visible = false; if (Cache["OrderList" + advisorVo.advisorId] == null) { Cache.Insert("OrderList" + advisorVo.advisorId, dtOrderBookMIS); } else { Cache.Remove("OrderList" + advisorVo.advisorId); Cache.Insert("OrderList" + advisorVo.advisorId, dtOrderBookMIS); } } else { gvOrderBookMIS.DataSource = dtOrderBookMIS; gvOrderBookMIS.DataBind(); //gvOrderBookMIS.Visible = false; pnlOrderBook.Visible = true; trNoRecords.Visible = true; btnExport.Visible = false; } }