private void GetRequests()
{
try
{
DateTime todate = DateTime.MinValue;
DateTime Fromdate = DateTime.MinValue;
int reqId = 0;
if (DropDownList1.SelectedValue == "1")
{
reqId = Convert.ToInt32(txtreqId.Text);
}
else if (DropDownList1.SelectedValue == "2")
{
todate = Convert.ToDateTime(rdpToDate.SelectedDate);
Fromdate = Convert.ToDateTime(txtReqDate.SelectedDate);
}
DataTable dtType = new DataTable();
DataSet dsType = new DataSet();
dsType = uploadCommonBo.GetCMLData(Convert.ToInt32(ddlType.SelectedValue), Fromdate, advisorVo.advisorId, (ddlProduct.SelectedValue != "IP") ? ddlCategory.SelectedValue : "IP", todate, reqId);
if (dsType.Tables.Count == 0)
{
return;
}
if (dsType != null)
{
dtType = dsType.Tables[0];
}
if (ddlType.SelectedValue != "11")
{
radGridOrderDetails.Visible = false;
rgRequests.Visible = true;
rgRequests.CurrentPageIndex = 0;
rgBondsGrid.Visible = false;
rgRequests.DataSource = dtType;
rgRequests.DataBind();
}
if (Cache[userVo.UserId.ToString() + "Requests"] != null)
{
Cache.Remove(userVo.UserId.ToString() + "Requests");
}
Cache.Insert(userVo.UserId.ToString() + "Requests", dtType);
if (ddlType.SelectedValue == "8")
{
rgRequests.MasterTableView.GetColumn("Cutomercreated").Visible = true;
rgRequests.MasterTableView.GetColumn("FolioCreated").Visible = true;
rgRequests.MasterTableView.GetColumn("TransactionCreated").Visible = false;
rgRequests.MasterTableView.GetColumn("RejectReseaon").Visible = true;
rgRequests.MasterTableView.GetColumn("IsOnl").Visible = true;
rgRequests.MasterTableView.GetColumn("RTA").Visible = true;
rgRequests.MasterTableView.GetColumn("StagingRejects").Visible = true;
rgRequests.MasterTableView.GetColumn("Staging").Visible = true;
}
else
if (ddlType.SelectedValue == "9" || ddlType.SelectedValue == "13")
{
rgRequests.MasterTableView.GetColumn("Cutomercreated").Visible = true;
rgRequests.MasterTableView.GetColumn("FolioCreated").Visible = true;
rgRequests.MasterTableView.GetColumn("TransactionCreated").Visible = true;
rgRequests.MasterTableView.GetColumn("RejectReseaon").Visible = true;
rgRequests.MasterTableView.GetColumn("IsOnl").Visible = true;
rgRequests.MasterTableView.GetColumn("RTA").Visible = true;
rgRequests.MasterTableView.GetColumn("StagingRejects").Visible = true;
rgRequests.MasterTableView.GetColumn("Staging").Visible = true;
if (ddlType.SelectedValue == "13")
{
rgRequests.MasterTableView.GetColumn("TransactionCreated").Visible = false;
}
}
else
if (ddlType.SelectedValue == "10")
{
rgRequests.MasterTableView.GetColumn("IsOnl").Visible = false;
rgRequests.MasterTableView.GetColumn("RTA").Visible = false;
rgRequests.MasterTableView.GetColumn("StagingRejects").Visible = false;
rgRequests.MasterTableView.GetColumn("Staging").Visible = false;
rgRequests.MasterTableView.GetColumn("RejectReseaon").Visible = false;
rgRequests.MasterTableView.GetColumn("Cutomercreated").Visible = false;
rgRequests.MasterTableView.GetColumn("FolioCreated").Visible = false;
rgRequests.MasterTableView.GetColumn("TransactionCreated").Visible = false;
}
else
if (ddlType.SelectedValue == "3" || ddlType.SelectedValue == "4")
{
rgRequests.MasterTableView.GetColumn("IsOnl").Visible = false;
rgRequests.MasterTableView.GetColumn("RTA").Visible = false;
rgRequests.MasterTableView.GetColumn("StagingRejects").Visible = true;
rgRequests.MasterTableView.GetColumn("Staging").Visible = true;
rgRequests.MasterTableView.GetColumn("RejectReseaon").Visible = false;
rgRequests.MasterTableView.GetColumn("Cutomercreated").Visible = false;
rgRequests.MasterTableView.GetColumn("FolioCreated").Visible = false;
rgRequests.MasterTableView.GetColumn("TransactionCreated").Visible = false;
}
else if (ddlType.SelectedValue == "5")
{
rgRequests.MasterTableView.GetColumn("RTA").Visible = true;
rgRequests.MasterTableView.GetColumn("TotalNoOfRecords").Visible = true;
rgRequests.MasterTableView.GetColumn("InputRejects").Visible = false;
rgRequests.MasterTableView.GetColumn("StagingRejects").Visible = false;
rgRequests.MasterTableView.GetColumn("Staging").Visible = false;
rgRequests.MasterTableView.GetColumn("Cutomercreated").Visible = false;
rgRequests.MasterTableView.GetColumn("FolioCreated").Visible = false;
rgRequests.MasterTableView.GetColumn("TransactionCreated").Visible = false;
rgRequests.MasterTableView.GetColumn("IsOnl").Visible = false;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
}