private void BindGrid() { if (Request.QueryString["systematicId"] != null && Request.QueryString["AccountId"] != null && Request.QueryString["schemeplanCode"] != null && Request.QueryString["amount"] != null && Request.QueryString["SIPStartDate"] != null) { mfTransactionList = customerTransactionBo.GetCustomerTransactionsBookSIP(advisorVo.advisorId, customerId, systematicId, IsSourceAA, AccountId, schemeplanCode, amount, SIPStartDate); } else { if (Request.QueryString["strPortfolio"] != null) { string portfolio = Request.QueryString["strPortfolio"].ToString(); if (portfolio != "MyPortfolio") { ddlPortfolioGroup.SelectedItem.Value = "0"; ddlPortfolioGroup.SelectedItem.Text = "UnManaged"; } else { ddlPortfolioGroup.SelectedItem.Value = "1"; ddlPortfolioGroup.SelectedItem.Text = "Managed"; } } DataSet ds = new DataSet(); if (txtFrom.SelectedDate != null) { fromDate = DateTime.Parse(txtFrom.SelectedDate.ToString()); } if (txtTo.SelectedDate != null) { toDate = DateTime.Parse(txtTo.SelectedDate.ToString()); } schemePlanCode = Convert.ToInt32(ViewState["SchemePlanCode"]); mfTransactionList = customerTransactionBo.GetCustomerTransactionsBook(advisorVo.advisorId, customerId, fromDate, toDate, int.Parse(ddlPortfolioGroup.SelectedItem.Value.ToString()), int.Parse(hdnAmc.Value), AccountId, schemePlanCode); } if (mfTransactionList.Count != 0) { DataTable dtMFTransactions = new DataTable(); dtMFTransactions.Columns.Add("TransactionId"); dtMFTransactions.Columns.Add("Customer Name"); dtMFTransactions.Columns.Add("Folio Number"); dtMFTransactions.Columns.Add("Scheme Name"); dtMFTransactions.Columns.Add("Transaction Type"); dtMFTransactions.Columns.Add("Transaction Date", typeof(DateTime)); dtMFTransactions.Columns.Add("Price", typeof(double)); dtMFTransactions.Columns.Add("Units", typeof(double)); dtMFTransactions.Columns.Add("Amount", typeof(double)); dtMFTransactions.Columns.Add("STT", typeof(double)); dtMFTransactions.Columns.Add("Portfolio Name"); dtMFTransactions.Columns.Add("TransactionStatus"); dtMFTransactions.Columns.Add("Category"); dtMFTransactions.Columns.Add("AMC"); dtMFTransactions.Columns.Add("ADUL_ProcessId"); dtMFTransactions.Columns.Add("CMFT_SubBrokerCode"); dtMFTransactions.Columns.Add("PAISC_AssetInstrumentSubCategoryName"); dtMFTransactions.Columns.Add("CreatedOn"); dtMFTransactions.Columns.Add("CMFT_ExternalBrokerageAmount", typeof(double)); dtMFTransactions.Columns.Add("CMFT_Area"); dtMFTransactions.Columns.Add("CMFT_EUIN"); dtMFTransactions.Columns.Add("CurrentNAV"); dtMFTransactions.Columns.Add("DivReinvestment"); dtMFTransactions.Columns.Add("DivFrequency"); dtMFTransactions.Columns.Add("Channel"); dtMFTransactions.Columns.Add("OrderNo"); //dtMFTransactions.Columns.Add("TransactionNumber"); dtMFTransactions.Columns.Add("CO_OrderDate"); dtMFTransactions.Columns.Add("ELSSMaturityDate", typeof(DateTime)); DataRow drMFTransaction; for (int i = 0; i < mfTransactionList.Count; i++) { drMFTransaction = dtMFTransactions.NewRow(); mfTransactionVo = new MFTransactionVo(); mfTransactionVo = mfTransactionList[i]; drMFTransaction[0] = mfTransactionVo.TransactionId.ToString(); drMFTransaction[1] = mfTransactionVo.CustomerName.ToString(); drMFTransaction[2] = mfTransactionVo.Folio.ToString(); drMFTransaction[3] = mfTransactionVo.SchemePlan.ToString(); drMFTransaction[4] = mfTransactionVo.TransactionType.ToString(); drMFTransaction[5] = mfTransactionVo.TransactionDate.ToShortDateString().ToString(); drMFTransaction[6] = decimal.Parse(mfTransactionVo.Price.ToString()).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); drMFTransaction[7] = mfTransactionVo.Units.ToString("f4"); totalUnits = totalUnits + mfTransactionVo.Units; drMFTransaction[8] = decimal.Parse(mfTransactionVo.Amount.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); totalAmount = totalAmount + mfTransactionVo.Amount; drMFTransaction[9] = decimal.Parse(mfTransactionVo.STT.ToString()).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); drMFTransaction[10] = mfTransactionVo.PortfolioName.ToString(); drMFTransaction[11] = mfTransactionVo.TransactionStatus.ToString(); drMFTransaction[12] = mfTransactionVo.Category; drMFTransaction[13] = mfTransactionVo.AMCName; if (mfTransactionVo.ProcessId == 0) { drMFTransaction[14] = "N/A"; } else { drMFTransaction[14] = int.Parse(mfTransactionVo.ProcessId.ToString()); } drMFTransaction[15] = mfTransactionVo.SubBrokerCode; drMFTransaction[16] = mfTransactionVo.SubCategoryName; drMFTransaction[17] = mfTransactionVo.CreatedOn; drMFTransaction[18] = decimal.Parse(mfTransactionVo.BrokerageAmount.ToString()); drMFTransaction["CMFT_Area"] = mfTransactionVo.Area.ToString(); drMFTransaction["CMFT_EUIN"] = mfTransactionVo.EUIN.ToString(); drMFTransaction["DivReinvestment"] = mfTransactionVo.DivReinvestmen.ToString();; drMFTransaction["DivFrequency"] = mfTransactionVo.Divfrequency.ToString();; drMFTransaction["Channel"] = mfTransactionVo.channel.ToString(); drMFTransaction["OrderNo"] = mfTransactionVo.orderNo; drMFTransaction["CurrentNav"] = mfTransactionVo.latestNav; //drMFTransaction["TransactionNumber"] = mfTransactionVo.TrxnNo.ToString(); if (!string.IsNullOrEmpty(mfTransactionVo.OrdDate.ToString()) && (mfTransactionVo.OrdDate) != DateTime.MinValue) { drMFTransaction["CO_OrderDate"] = mfTransactionVo.OrdDate; } else { drMFTransaction["CO_OrderDate"] = ""; } if (!string.IsNullOrEmpty(mfTransactionVo.ELSSMaturityDate.ToString()) && (mfTransactionVo.ELSSMaturityDate) != DateTime.MinValue) { drMFTransaction["ELSSMaturityDate"] = mfTransactionVo.ELSSMaturityDate; } //else //{ // drMFTransaction["ELSSMaturityDate"] = DateTime.MinValue; //} dtMFTransactions.Rows.Add(drMFTransaction); } if (Cache["ViewTransaction" + userVo.UserId] == null) { Cache.Insert("ViewTransaction" + userVo.UserId, dtMFTransactions); } else { Cache.Remove("ViewTransaction" + userVo.UserId); Cache.Insert("ViewTransaction" + userVo.UserId, dtMFTransactions); } gvTransationBookMIS.CurrentPageIndex = 0; gvTransationBookMIS.DataSource = dtMFTransactions; Session["gvMFTransactions"] = dtMFTransactions; gvTransationBookMIS.DataBind(); pnlTransactionBook.Visible = true; //ErrorMessage.Visible = false; gvTransationBookMIS.Visible = true; btnExport.Visible = true; trNoRecords.Visible = false; } else { gvTransationBookMIS.DataSource = dtMFTransactions; gvTransationBookMIS.DataBind(); //hdnRecordCount.Value = "0"; //ErrorMessage.Visible = true; trNoRecords.Visible = true; pnlTransactionBook.Visible = true; btnExport.Visible = false; } }