private void BindEquityTransactionGrid(int ProcessId)
{
Dictionary <string, string> genDictIsRejected = new Dictionary <string, string>();
Dictionary <string, string> genDictRejectReason = new Dictionary <string, string>();
if (hdnCurrentPage.Value.ToString() != "")
{
mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString());
hdnCurrentPage.Value = "";
}
int Count;
rejectedRecordsBo = new RejectedRecordsBo();
dsRejectedRecords = rejectedRecordsBo.GetRejectedEquityTransactionsStaging(ProcessId, mypager.CurrentPage, out Count, hdnSort.Value, hdnRejectReasonFilter.Value, hdnPanNumberFilter.Value, hdnScripFilter.Value, hdnExchangeFilter.Value, hdnTransactionTypeFilter.Value);
lblTotalRows.Text = hdnRecordCount.Value = Count.ToString();
//lblTotalRows.Text = (Count.ToString());
if (Count > 0)
{
DivPager.Style.Add("display", "visible");
}
if (dsRejectedRecords.Tables[0].Rows.Count > 0)
{ // If Records found, then bind them to grid
dtTransactionTypes = dsRejectedRecords.Tables[4]; //All transaction types
dtFilterTransactionTypes = dsRejectedRecords.Tables[5]; //Transaction types for filter
trMessage.Visible = false;
trReprocess.Visible = true;
gvWERPTrans.DataSource = dsRejectedRecords.Tables[0];
gvWERPTrans.DataBind();
if (dsRejectedRecords.Tables[2].Rows.Count > 0)
{
// Get the Reject Reason Codes Available into Generic Dictionary
foreach (DataRow dr in dsRejectedRecords.Tables[2].Rows)
{
genDictRejectReason.Add(dr["RejectReason"].ToString(), dr["RejectReasonCode"].ToString());
}
DropDownList ddlRejectReason = GetRejectReasonDDL();
if (ddlRejectReason != null)
{
ddlRejectReason.DataSource = genDictRejectReason;
ddlRejectReason.DataTextField = "Key";
ddlRejectReason.DataValueField = "Value";
ddlRejectReason.DataBind();
ddlRejectReason.Items.Insert(0, new ListItem("Select Reject Reason", "Select Reject Reason"));
}
if (hdnRejectReasonFilter.Value != "")
{
ddlRejectReason.SelectedValue = hdnRejectReasonFilter.Value.ToString().Trim();
}
}
BindPanNumber(dsRejectedRecords.Tables[3]);
}
else
{
hdnRecordCount.Value = "0";
gvWERPTrans.DataSource = null;
gvWERPTrans.DataBind();
trMessage.Visible = true;
trReprocess.Visible = false;
}
this.GetPageCount();
}
private void BindEquityTransactionGrid(int ProcessId)
{
if (ProcessId == null || ProcessId == 0)
{
if (txtFromTran.SelectedDate != null)
{
fromDate = DateTime.Parse(txtFromTran.SelectedDate.ToString());
}
if (txtToTran.SelectedDate != null)
{
toDate = DateTime.Parse(txtToTran.SelectedDate.ToString());
}
rejectReasonCode = int.Parse(ddlRejectReason.SelectedValue);
}
Dictionary <string, string> genDictIsRejected = new Dictionary <string, string>();
Dictionary <string, string> genDictRejectReason = new Dictionary <string, string>();
//if (hdnCurrentPage.Value.ToString() != "")
//{
// mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString());
// hdnCurrentPage.Value = "";
//}
rejectedRecordsBo = new RejectedRecordsBo();
dsRejectedRecords = rejectedRecordsBo.GetRejectedEquityTransactionsStaging(adviserVo.advisorId, ProcessId, fromDate, toDate, rejectReasonCode);
if (dsRejectedRecords.Tables[0].Rows.Count > 0)
{
//trMessage.Visible = false;
trReprocess.Visible = true;
DivAction.Visible = true;
// msgDelete.Visible = false;
if (Cache["RejectedEquityDetails" + adviserVo.advisorId.ToString()] == null)
{
Cache.Insert("RejectedEquityDetails" + adviserVo.advisorId.ToString(), dsRejectedRecords);
}
else
{
Cache.Remove("RejectedEquityDetails" + adviserVo.advisorId.ToString());
Cache.Insert("RejectedEquityDetails" + adviserVo.advisorId.ToString(), dsRejectedRecords);
}
gvWERPTrans.CurrentPageIndex = 0;
gvWERPTrans.DataSource = dsRejectedRecords.Tables[0];
gvWERPTrans.DataBind();
gvWERPTrans.Visible = true;
Panel2.Visible = true;
msgDelete.Visible = false;
btnExport.Visible = true;
}
else
{
hdnRecordCount.Value = "0";
gvWERPTrans.DataSource = null;
gvWERPTrans.DataBind();
Msgerror.Visible = true;
//trMessage.Visible = true;
DivAction.Visible = false;
gvWERPTrans.Visible = false;
Panel2.Visible = false;
trReprocess.Visible = false;
btnExport.Visible = false;
}
}
