protected void btnProbableDelete_Click(object sender, EventArgs e)
{
bool result = true;
bool blResult = true;
string gvStagingIds = "";
rejectedRecordsBo = new RejectedRecordsBo();
foreach (GridDataItem gvRow in gvWERPTrans.MasterTableView.Items)
//foreach (GridViewRow gvRow in gvWERPTrans.Rows)
{
CheckBox ChkBxItem = (CheckBox)gvRow.FindControl("chkId");
if (ChkBxItem.Checked)
{
gvStagingIds += gvWERPTrans.MasterTableView.DataKeyValues[gvRow.RowIndex]["CMFTSId"].ToString() + ",";
}
}
result = rejectedRecordsBo.DeleteProbableDuplicatesRejectedTransaction(gvStagingIds);
if (result)
{
// Success Message
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Records Deleted Successfully');", true);
}
else
{
// Failure Message
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please Select Probable Duplicate Records');", true);
}
BindEquityTransactionGrid(ProcessId);
}
public void BindddlRejectReason()
{
Dictionary <string, string> genDictIsRejected = new Dictionary <string, string>();
processlogVo = new UploadProcessLogVo();
rejectedRecordsBo = new RejectedRecordsBo();
DataSet ds = rejectedRecordsBo.GetRejectReasonEquityList(1);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
genDictIsRejected.Add(dr["WRR_RejectReasonDescription"].ToString(), dr["WRR_RejectReasonCode"].ToString());
}
if (ddlRejectReason != null)
{
ddlRejectReason.DataSource = genDictIsRejected;
ddlRejectReason.DataTextField = "Key";
ddlRejectReason.DataValueField = "Value";
ddlRejectReason.DataBind();
}
}
ddlRejectReason.Items.Insert(0, new System.Web.UI.WebControls.ListItem("All", "0"));
}
protected void btnEditSelectedWerp_Click(object sender, EventArgs e)
{
string newPan = string.Empty;
string newBroker = string.Empty;
bool blResult = false;
rejectedRecordsBo = new RejectedRecordsBo();
// Gets the footer row directly Cool right!
GridViewRow footerRow = gvWERPProfileReject.FooterRow;
string pan = ((TextBox)footerRow.FindControl("txtPanMultiple")).Text;
string broker = ((TextBox)footerRow.FindControl("txtBrokerMultiple")).Text;
foreach (GridViewRow dr in gvWERPProfileReject.Rows)
{
CheckBox checkBox = (CheckBox)dr.FindControl("chkBxWerp");
if (checkBox.Checked)
{
if (pan != "" || broker != "")
{
newPan = pan;
newBroker = broker;
}
else
{
newPan = ((TextBox)dr.FindControl("txtPanWerp")).Text;
newBroker = ((TextBox)dr.FindControl("txtBroker")).Text;
}
int WERPStagingId = Convert.ToInt32(gvWERPProfileReject.DataKeys[dr.RowIndex].Value);
blResult = rejectedRecordsBo.UpdateWERPProfileStaging(WERPStagingId, newPan, newBroker);
}
}
if (blResult)
{
// Success Message
}
else
{
// Failure Message
}
// BindGrid
if (Request.QueryString["processId"] != null)
{
ProcessId = Int32.Parse(Request.QueryString["processId"].ToString());
}
if (Request.QueryString["filetypeid"] != null)
{
filetypeId = Int32.Parse(Request.QueryString["filetypeid"].ToString());
}
BindWerpProfileGrid(ProcessId);
}
protected void BindFixedIncomeGrid(int ProcessId)
{
if (ProcessId == null || ProcessId == 0)
{
if (txtFromFI.SelectedDate != null)
{
fromDate = DateTime.Parse(txtFromFI.SelectedDate.ToString());
}
if (txtToFI.SelectedDate != null)
{
toDate = DateTime.Parse(txtToFI.SelectedDate.ToString());
}
rejectReasonCode = int.Parse(ddlRejectReason.SelectedValue);
}
//Dictionary<string, string> genDictIsRejected = new Dictionary<string, string>();
//Dictionary<string, string> genDictRejectReason = new Dictionary<string, string>();
rejectedRecordsBo = new RejectedRecordsBo();
dsRejectedRecords = rejectedRecordsBo.GetRejectedFixedIncomeStaging(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["RejectedFixedIncomeDetails" + adviserVo.advisorId.ToString()] == null)
{
Cache.Insert("RejectedFixedIncomeDetails" + adviserVo.advisorId.ToString(), dsRejectedRecords);
}
else
{
Cache.Remove("RejectedFixedIncomeDetails" + adviserVo.advisorId.ToString());
Cache.Insert("RejectedFixedIncomeDetails" + adviserVo.advisorId.ToString(), dsRejectedRecords);
}
gvWERPFI.CurrentPageIndex = 0;
gvWERPFI.DataSource = dsRejectedRecords.Tables[0];
gvWERPFI.DataBind();
gvWERPFI.Visible = true;
Panel2.Visible = true;
msgDelete.Visible = false;
btnExport.Visible = true;
}
else
{
gvWERPFI.DataSource = null;
gvWERPFI.DataBind();
Msgerror.Visible = true;
//trMessage.Visible = true;
DivAction.Visible = false;
gvWERPFI.Visible = false;
Panel2.Visible = false;
trReprocess.Visible = false;
btnExport.Visible = false;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
trErrorMessage.Visible = false;
string newPan = string.Empty;
string newFolio = string.Empty;
bool blResult = false;
rejectedRecordsBo = new RejectedRecordsBo();
// Gets the footer row directly Cool right!
GridViewRow footerRow = gvCAMSProfileReject.FooterRow;
foreach (GridViewRow dr in gvCAMSProfileReject.Rows)
{
if (((TextBox)footerRow.FindControl("txtPanMultiple")).Text.Trim() == "" && ((TextBox)footerRow.FindControl("txtFolioMultiple")).Text.Trim() == "")
{
newPan = ((TextBox)dr.FindControl("txtPan")).Text;
newFolio = ((TextBox)dr.FindControl("txtFolio")).Text;
}
else
{
newPan = ((TextBox)footerRow.FindControl("txtPanMultiple")).Text;
newFolio = ((TextBox)footerRow.FindControl("txtFolioMultiple")).Text;
}
CheckBox checkBox = (CheckBox)dr.FindControl("chkBx");
if (checkBox.Checked)
{
int StagingId = Convert.ToInt32(gvCAMSProfileReject.DataKeys[dr.RowIndex].Values["MFFolioStagingId"].ToString());
int MainStagingId = Convert.ToInt32(gvCAMSProfileReject.DataKeys[dr.RowIndex].Values["MainStagingId"].ToString());
blResult = rejectedRecordsBo.UpdateMFFolioStaging(StagingId, MainStagingId, newPan, newFolio);
}
}
if (blResult)
{
// Success Message
}
else
{
// Failure Message
}
// BindGrid
if (Request.QueryString["processId"] != null)
{
ProcessId = Int32.Parse(Request.QueryString["processId"].ToString());
}
if (Request.QueryString["filetypeid"] != null)
{
filetypeId = Int32.Parse(Request.QueryString["filetypeid"].ToString());
}
BindGrid(ProcessId);
}
private void CustomerTransactionDelete()
{
foreach (GridViewRow gvr in this.gvWERPProfileReject.Rows)
{
if (((CheckBox)gvr.FindControl("chkBxWerp")).Checked == true)
{
rejectedRecordsBo = new RejectedRecordsBo();
int StagingID = int.Parse(gvWERPProfileReject.DataKeys[gvr.RowIndex].Values["WERPProfileStagingId"].ToString());
rejectedRecordsBo.DeleteWERPRejectedProfile(StagingID);
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "loadcontrol('RejectedWERPProfile','login');", true);
}
}
}
protected void btnEditSelectedWPTrans_Click(object sender, EventArgs e)
{
string newTradeAccountNum = string.Empty;
string newPanNum = string.Empty;
bool blResult = false;
rejectedRecordsBo = new RejectedRecordsBo();
// Gets the footer row directly Cool right!
GridViewRow footerRow = gvWERPTrans.FooterRow;
string tradeAccountNum = ((TextBox)footerRow.FindControl("txtTradeAccountNumberMultiple")).Text;
string panNum = ((TextBox)footerRow.FindControl("txtPanNumberMultiple")).Text;
foreach (GridViewRow dr in gvWERPTrans.Rows)
{
CheckBox checkBox = (CheckBox)dr.FindControl("chkBxWPTrans");
if (checkBox.Checked)
{
if (tradeAccountNum != "" || panNum != "")
{
newTradeAccountNum = tradeAccountNum;
newPanNum = panNum;
}
else
{
newTradeAccountNum = ((TextBox)dr.FindControl("txtTradeAccountNumber")).Text;
newPanNum = ((TextBox)dr.FindControl("txtPanNumber")).Text;
}
int Id = Convert.ToInt32(gvWERPTrans.DataKeys[dr.RowIndex].Value);
blResult = rejectedRecordsBo.UpdateRejectedTradeAccountStaging(Id, newTradeAccountNum, newPanNum);
}
}
if (blResult)
{
// Success Message
}
else
{
// Failure Message
}
// BindGrid
if (Request.QueryString["processId"] != null)
{
ProcessId = Int32.Parse(Request.QueryString["processId"].ToString());
}
BindRejectedUploadsGrid(ProcessId);
}
private void CustomerTransactionDelete()
{
string StagingID = string.Empty;
foreach (GridDataItem gvr in this.gvWERPTrans.Items)
{
if (((CheckBox)gvr.FindControl("chkId")).Checked == true)
{
rejectedRecordsBo = new RejectedRecordsBo();
StagingID += Convert.ToString(gvWERPTrans.MasterTableView.DataKeyValues[gvr.ItemIndex]["CMFTSId"]) + "~";
}
}
rejectedRecordsBo.DeleteMFTransactionStaging(StagingID);
BindEquityTransactionGrid(ProcessId);
}
private void CustomerFIDelete()
{
// string StagingID = string.Empty;
foreach (GridDataItem gvr in this.gvWERPFI.Items)
{
if (((CheckBox)gvr.FindControl("chkBxWPTrans")).Checked == true)
{
rejectedRecordsBo = new RejectedRecordsBo();
int StagingID = int.Parse(gvWERPFI.MasterTableView.DataKeyValues[gvr.ItemIndex]["CUS_Id"].ToString());
rejectedRecordsBo.DeleteWERPRejectedFixedIncome(StagingID);
}
}
BindFixedIncomeGrid(ProcessId);
}
private void BindEquityTransactionGrid(int ProcessId)
{
Dictionary <string, string> genDictIsRejected = new Dictionary <string, string>();
Dictionary <string, string> genDictRejectReason = new Dictionary <string, string>();
rejectedRecordsBo = new RejectedRecordsBo();
dsRejectedRecords = rejectedRecordsBo.GetRejectedMFTransactionStaging(adviserId, int.Parse(hdnProcessIdFilter.Value));
if (dsRejectedRecords.Tables[0].Rows.Count > 0)
{ // If Records found, then bind them to grid
trMessage.Visible = false;
trReprocess.Visible = true;
trGridView.Visible = true;
//gvWERPTrans_Sort.DataSource = dsRejectedRecords.Tables[0];
if (Cache["MFTransactionDetails" + adviserId.ToString()] == null)
{
Cache.Insert("MFTransactionDetails" + adviserId.ToString(), dsRejectedRecords);
}
else
{
Cache.Remove("MFTransactionDetails" + adviserId.ToString());
Cache.Insert("MFTransactionDetails" + adviserId.ToString(), dsRejectedRecords);
}
gvWERPTrans.DataSource = dsRejectedRecords;
gvWERPTrans.DataBind();
Panel2.ScrollBars = ScrollBars.Horizontal;
trGridView.Visible = true;
imgBtnrgHoldings.Visible = true;
}
else
{
//hdnRecordCount.Value = "0";
Panel2.ScrollBars = ScrollBars.None;
trGridView.Visible = false;
gvWERPTrans.DataSource = null;
gvWERPTrans.DataBind();
trMessage.Visible = true;
trReprocess.Visible = false;
imgBtnrgHoldings.Visible = false;
}
//this.GetPageCount();
}
private void CustomerTransactionDelete()
{
string StagingID = string.Empty;
foreach (GridDataItem gvr in this.gvWERPTrans.Items)
{
if (((CheckBox)gvr.FindControl("chkBxWPTrans")).Checked == true)
{
rejectedRecordsBo = new RejectedRecordsBo();
StagingID += Convert.ToString(gvWERPTrans.MasterTableView.DataKeyValues[gvr.ItemIndex]["WERPTransactionId"]) + "~";
//ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "loadcontrol('RejectedEquityTransactionStaging','login');", true);
}
}
rejectedRecordsBo.DeleteRejectsEquityTransactionsStaging(StagingID);
BindEquityTransactionGrid(ProcessId);
}
/*************To delete the selected records ****************/
protected void btnDelete_Click(object sender, EventArgs e)
//{
// int i = 0;
// foreach (GridViewRow gvr in this.gvCAMSProfileReject.Rows)
// {
// if (((CheckBox)gvr.FindControl("chkBx")).Checked == true)
// i = i + 1;
// }
// if (i == 0)
// ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please select record to delete!');", true);
// else
// CustomerTransactionDelete();
//}
{
int i = 0;
string StagingID = string.Empty;
foreach (GridViewRow gvr in this.gvCAMSProfileReject.Rows)
{
if (((CheckBox)gvr.FindControl("chkBx")).Checked == true)
{
i = i + 1;
StagingID += Convert.ToString(gvCAMSProfileReject.DataKeys[gvr.RowIndex].Value) + "~";
}
}
if (i == 0)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please select record to delete!');", true);
}
else
{
rejectedRecordsBo = new RejectedRecordsBo();
rejectedRecordsBo.DeleteMFRejectedFolios(StagingID);
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "loadcontrol('RejectedMFFolio','login');", true);
}
}
private void BindWerpProfileGrid(int ProcessId)
{
//Dictionary<string, string> genDictIsRejected = new Dictionary<string, string>();
Dictionary <string, string> genDictRejectReason = new Dictionary <string, string>();
// Dictionary<string, string> genDictIsCustomerExisting = new Dictionary<string, string>();
if (hdnCurrentPage.Value.ToString() != "")
{
mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString());
hdnCurrentPage.Value = "";
}
int Count;
rejectedRecordsBo = new RejectedRecordsBo();
if (ProcessId == 0)
{ // Bind All Processes
dsRejectedRecords = rejectedRecordsBo.getSuperAdminWERPRejectedProfile(ProcessId, mypager.CurrentPage, out Count, hdnSort.Value, hdnPANFilter.Value, hdnRejectReasonFilter.Value, hdnBrokerCodeFilter.Value, hdnCustomerNameFilter.Value, hdnAdviserFilter.Value);
// PANFilter, RejectReasonFilter, BrokerFilter, CustomerNameFilter);
}
else
{ // Bind Grid for the specific Process Id
dsRejectedRecords = rejectedRecordsBo.getSuperAdminWERPRejectedProfile(ProcessId, mypager.CurrentPage, out Count, hdnSort.Value, hdnPANFilter.Value, hdnRejectReasonFilter.Value, hdnBrokerCodeFilter.Value, hdnCustomerNameFilter.Value, hdnAdviserFilter.Value);
}
lblTotalRows.Text = hdnRecordCount.Value = 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
trMessage.Visible = false;
trReprocess.Visible = true;
gvWERPProfileReject.DataSource = dsRejectedRecords.Tables[0];
gvWERPProfileReject.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", "Select"));
}
if (hdnRejectReasonFilter.Value != "")
{
ddlRejectReason.SelectedValue = hdnRejectReasonFilter.Value.ToString().Trim();
}
}
BindPanNumber(dsRejectedRecords.Tables[3]);
BindProcessId(dsRejectedRecords.Tables[4]);
BindAdviser(dsRejectedRecords.Tables[5]);
}
else
{
hdnRecordCount.Value = "0";
gvWERPProfileReject.DataSource = null;
gvWERPProfileReject.DataBind();
trMessage.Visible = true;
trReprocess.Visible = false;
}
this.GetPageCount();
}
protected void btnEditSelectedWPTrans_Click(object sender, EventArgs e)
{
//int Id = 0;
string panNumber = string.Empty;
string tradeAccountNumber = string.Empty;
string scripCode = string.Empty;
string newScripCode = string.Empty;
string exchange = string.Empty;
string price = string.Empty;
string newPrice = string.Empty;
string transactionType = string.Empty;
string newTransactionType = string.Empty;
bool blResult = false;
rejectedRecordsBo = new RejectedRecordsBo();
// Gets the footer row directly Cool right!
GridViewRow footerRow = gvWERPTrans.FooterRow;
string newPanNumber = ((TextBox)footerRow.FindControl("txtPanNumberMultiple")).Text;
if (((TextBox)footerRow.FindControl("txtScripCodeMultiple")).Text != string.Empty)
{
newScripCode = ((TextBox)footerRow.FindControl("txtScripCodeMultiple")).Text;
}
string newExchange = ((TextBox)footerRow.FindControl("txtExchangeMultiple")).Text;
if (((DropDownList)footerRow.FindControl("ddlTransactionType")).SelectedValue != "-1")
{
newTransactionType = ((DropDownList)footerRow.FindControl("ddlTransactionType")).SelectedValue;
}
if (((TextBox)footerRow.FindControl("txtPriceMultiple")).Text != string.Empty)
{
newPrice = ((TextBox)footerRow.FindControl("txtPriceMultiple")).Text;
}
foreach (GridViewRow dr in gvWERPTrans.Rows)
{
CheckBox checkBox = (CheckBox)dr.FindControl("chkBxWPTrans");
if (checkBox.Checked)
{
if (newPanNumber != "" || newScripCode != "" || newExchange != "" || newPrice != "" || newTransactionType != "") //Change this logic
{
panNumber = newPanNumber;
scripCode = newScripCode;
exchange = newExchange;
transactionType = newTransactionType;
price = newPrice;
}
else
{
panNumber = ((TextBox)dr.FindControl("txtPanNumber")).Text;
if (((TextBox)dr.FindControl("txtScripCode")).Text != string.Empty)
{
scripCode = ((TextBox)dr.FindControl("txtScripCode")).Text;
}
exchange = ((TextBox)dr.FindControl("txtExchange")).Text;
transactionType = ((DropDownList)dr.FindControl("ddlTransactionType")).SelectedValue;
// price = Convert.ToDouble(((TextBox)dr.FindControl("txtPrice")).Text);
price = ((TextBox)dr.FindControl("txtPrice")).Text;
}
int id = Convert.ToInt32(gvWERPTrans.DataKeys[dr.RowIndex].Value);
blResult = rejectedRecordsBo.UpdateRejectedEquityTransactionStaging(id, panNumber, scripCode, exchange, price.ToString(), transactionType);
}
}
if (blResult)
{
// Success Message
}
else
{
// Failure Message
}
// BindGrid
if (Request.QueryString["processId"] != null)
{
ProcessId = Int32.Parse(Request.QueryString["processId"].ToString());
}
BindEquityTransactionGrid(ProcessId);
}
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 BindRejectedUploadsGrid(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();
if (ProcessId == 0) //TODO : This IF ELSE can be removed.
{ // Bind All Processes
dsRejectedRecords = rejectedRecordsBo.GetRejectedTradeAccountStaging(ProcessId, mypager.CurrentPage, out Count, hdnSort.Value, hdnTradeAccountNumFilter.Value, hdnRejectReasonFilter.Value, hdnPanFilter.Value);
}
else
{ // Bind Grid for the specific Process Id
dsRejectedRecords = rejectedRecordsBo.GetRejectedTradeAccountStaging(ProcessId, mypager.CurrentPage, out Count, hdnSort.Value, hdnTradeAccountNumFilter.Value, hdnRejectReasonFilter.Value, hdnPanFilter.Value);
}
lblTotalRows.Text = hdnRecordCount.Value = 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
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", "Select"));
}
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();
}
protected void btnProbableInsert_Click(object sender, EventArgs e)
{
bool result = true;
bool blResult = true;
string gvStagingIds = "";
uploadsCommonBo = new UploadCommonBo();
processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId);
int fileTypeId = processlogVo.FileTypeId;
rejectedRecordsBo = new RejectedRecordsBo();
foreach (GridDataItem gvRow in gvWERPTrans.MasterTableView.Items)
//foreach (GridViewRow gvRow in gvWERPTrans.Rows)
{
CheckBox ChkBxItem = (CheckBox)gvRow.FindControl("chkId");
if (ChkBxItem.Checked)
{
gvStagingIds += gvWERPTrans.MasterTableView.DataKeyValues[gvRow.RowIndex]["CMFTSId"].ToString() + ",";
}
}
result = rejectedRecordsBo.InsertProbableDuplicatesRejectedTransaction(gvStagingIds);
if (result)
{
// Success Message
processlogVo.IsInsertionToWERPComplete = 1;
processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetTransUploadCount(ProcessId, "WPMF");
processlogVo.EndTime = DateTime.Now;
if (fileTypeId == 1)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeCAMS);
}
else if (fileTypeId == 3)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeKarvy);
}
else if (fileTypeId == 15)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeTemp);
}
else if (fileTypeId == 17)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeDeutsche);
}
else if (filetypeId == 25)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, "SU");
}
blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo);
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Records Inserted Successfully');", true);
}
else
{
// Failure Message
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please Select Probable Duplicate Records');", true);
}
BindEquityTransactionGrid(ProcessId);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string newScheme = string.Empty;
string PanNum = string.Empty;
string TransactionType = string.Empty;
string FolioNumber = string.Empty;
double Price = 0;
double Units = 0;
double Amount = 0;
int UserTransactionNo = 0;
int CMFTSId = 0;
bool blResult = false;
rejectedRecordsBo = new RejectedRecordsBo();
GridFooterItem footerRow = (GridFooterItem)gvWERPTrans.MasterTableView.GetItems(GridItemType.Footer)[0];
foreach (GridDataItem dr in gvWERPTrans.Items)
{
if (((TextBox)footerRow.FindControl("txtSchemeFooter")).Text.Trim() == "")
{
newScheme = ((TextBox)dr.FindControl("txtScheme")).Text;
}
else
{
newScheme = ((TextBox)footerRow.FindControl("txtSchemeFooter")).Text;
}
if (((TextBox)footerRow.FindControl("txtPanFooter")).Text.Trim() == "")
{
PanNum = ((TextBox)dr.FindControl("txtPanNum")).Text;
}
else
{
PanNum = ((TextBox)footerRow.FindControl("txtPanFooter")).Text;
}
if (((TextBox)footerRow.FindControl("txtTransactionFooter")).Text.Trim() == "")
{
TransactionType = ((TextBox)dr.FindControl("txtTransaction")).Text;
}
else
{
TransactionType = ((TextBox)footerRow.FindControl("txtTransactionFooter")).Text;
}
if (((TextBox)footerRow.FindControl("txtFolioNumberFooter")).Text.Trim() == "")
{
FolioNumber = ((TextBox)dr.FindControl("txtFolioNumber")).Text;
}
else
{
FolioNumber = ((TextBox)footerRow.FindControl("txtFolioNumberFooter")).Text;
}
if (((TextBox)footerRow.FindControl("txtPriceFooter")).Text.Trim() == "")
{
Price = Convert.ToDouble(((TextBox)dr.FindControl("txtPrice")).Text);
}
else
{
Price = Convert.ToDouble(((TextBox)footerRow.FindControl("txtPriceFooter")).Text);
}
if (((TextBox)footerRow.FindControl("txtUnitsFooter")).Text.Trim() == "")
{
Units = Convert.ToDouble(((TextBox)dr.FindControl("txtUnits")).Text);
}
else
{
Units = Convert.ToDouble(((TextBox)footerRow.FindControl("txtUnitsFooter")).Text);
}
if (((TextBox)footerRow.FindControl("txtAmountFooter")).Text.Trim() == "")
{
Amount = Convert.ToDouble(((TextBox)dr.FindControl("txtAmount")).Text);
}
else
{
Amount = Convert.ToDouble(((TextBox)footerRow.FindControl("txtAmountFooter")).Text);
}
if (((TextBox)footerRow.FindControl("txtUsertransactionFooter")).Text.Trim() == "")
{
UserTransactionNo = Convert.ToInt32(((TextBox)dr.FindControl("txtUsertransaction")).Text);
}
else
{
UserTransactionNo = Convert.ToInt32(((TextBox)footerRow.FindControl("txtUsertransactionFooter")).Text);
}
CheckBox checkBox = (CheckBox)dr.FindControl("chkId");
if (checkBox.Checked)
{
int selectedRow = 0;
GridDataItem gdi;
gdi = (GridDataItem)checkBox.NamingContainer;
selectedRow = gdi.ItemIndex + 1;
CMFTSId = int.Parse((gvWERPTrans.MasterTableView.DataKeyValues[selectedRow - 1]["CMFTSId"].ToString()));
blResult = rejectedRecordsBo.UpdateMFTrasactionStaging(CMFTSId, PanNum, newScheme, TransactionType, FolioNumber, Price, Units, Amount, UserTransactionNo);
}
}
if (blResult)
{
// Success Message
}
else
{
// Failure Message
}
// BindGrid
if (Request.QueryString["processId"] != null)
{
ProcessId = Int32.Parse(Request.QueryString["processId"].ToString());
}
if (Request.QueryString["filetypeid"] != null)
{
filetypeId = Int32.Parse(Request.QueryString["filetypeid"].ToString());
}
//BindGrid(ProcessId);
BindEquityTransactionGrid(ProcessId);
}
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;
}
}
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.GetRejectedMFTransactionStaging(adviserVo.advisorId, mypager.CurrentPage, out Count, hdnSort.Value, int.Parse(hdnProcessIdFilter.Value), hdnRejectReasonFilter.Value, hdnFileNameFilter.Value, hdnFolioFilter.Value, hdnTransactionTypeFilter.Value, hdnInvNameFilter.Value, hdnSourceTypeFilter.Value, hdnSchemeNameFilter.Value);
lblTotalRows.Text = hdnRecordCount.Value = 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
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)
{
if (dr["RejectReasonCode"].ToString() != "7")
{
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", "Select"));
}
if (hdnRejectReasonFilter.Value != "")
{
ddlRejectReason.SelectedValue = hdnRejectReasonFilter.Value.ToString().Trim();
}
}
BindProcessId(dsRejectedRecords.Tables[3]);
BindInvName(dsRejectedRecords.Tables[6]);
BindFileName(dsRejectedRecords.Tables[4]);
BindSourceType(dsRejectedRecords.Tables[5]);
BindFolioNumber(dsRejectedRecords.Tables[7]);
BindSchemeName(dsRejectedRecords.Tables[8]);
BindTransactionType(dsRejectedRecords.Tables[9]);
}
else
{
hdnRecordCount.Value = "0";
gvWERPTrans.DataSource = null;
gvWERPTrans.DataBind();
trMessage.Visible = true;
trReprocess.Visible = false;
}
this.GetPageCount();
}
private void BindGrid(int ProcessId)
{
Dictionary <string, string> genDictIsRejected = new Dictionary <string, string>();
Dictionary <string, string> genDictRejectReason = new Dictionary <string, string>();
Dictionary <string, string> genDictIsCustomerExisting = new Dictionary <string, string>();
try
{
if (hdnCurrentPage.Value.ToString() != "")
{
mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString());
hdnCurrentPage.Value = "";
}
int Count;
rejectedRecordsBo = new RejectedRecordsBo();
if (ProcessId == 0)
{ // Bind All Processes
dsRejectedRecords = rejectedRecordsBo.getMFRejectedFolios(ProcessId, mypager.CurrentPage, out Count, hdnSortProcessID.Value, hdnIsRejectedFilter.Value, hdnPANFilter.Value.Trim(), hdnRejectReasonFilter.Value, hdnNameFilter.Value.Trim(), hdnFolioFilter.Value.Trim(), hdnIsCustomerExistingFilter.Value);
}
else
{ // Bind Grid for the specific Process Id
dsRejectedRecords = rejectedRecordsBo.getMFRejectedFolios(ProcessId, mypager.CurrentPage, out Count, hdnSortProcessID.Value, hdnIsRejectedFilter.Value, hdnPANFilter.Value.Trim(), hdnRejectReasonFilter.Value, hdnNameFilter.Value.Trim(), hdnFolioFilter.Value.Trim(), hdnIsCustomerExistingFilter.Value);
}
lblTotalRows.Text = hdnRecordCount.Value = 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
trProfileMessage.Visible = false;
trReprocess.Visible = true;
gvCAMSProfileReject.DataSource = dsRejectedRecords.Tables[0];
gvCAMSProfileReject.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["WRR_RejectReasonDescription"].ToString(), dr["WRR_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();
}
}
if (dsRejectedRecords.Tables[3].Rows.Count > 0)
{
// Get Is Reject Flags Available into Generic Dictionary
foreach (DataRow dr in dsRejectedRecords.Tables[3].Rows)
{
genDictIsRejected.Add(dr["IsRejected"].ToString(), dr["IsRejected"].ToString());
}
DropDownList ddlReject = GetIsRejectedDDL();
if (ddlReject != null)
{
ddlReject.DataSource = genDictIsRejected;
ddlReject.DataTextField = "Key";
ddlReject.DataValueField = "Value";
ddlReject.DataBind();
ddlReject.Items.Insert(0, new ListItem("Select Is Reject Flag", "Select Is Reject Flag"));
}
if (hdnIsRejectedFilter.Value != "")
{
ddlReject.SelectedValue = hdnIsRejectedFilter.Value.ToString().Trim();
}
}
if (dsRejectedRecords.Tables[4].Rows.Count > 0)
{
// Get Is Customer Exist Flag into Generic Dictionary
foreach (DataRow dr in dsRejectedRecords.Tables[4].Rows)
{
genDictIsCustomerExisting.Add(dr["CustomerExists"].ToString(), dr["CustomerExists"].ToString());
}
DropDownList ddlCustExists = GetCustExistsDDL();
if (ddlCustExists != null)
{
ddlCustExists.DataSource = genDictIsCustomerExisting;
ddlCustExists.DataTextField = "Key";
ddlCustExists.DataValueField = "Value";
ddlCustExists.DataBind();
ddlCustExists.Items.Insert(0, new ListItem("Select a Flag", "Select a Flag"));
}
if (hdnIsCustomerExistingFilter.Value != "")
{
ddlCustExists.SelectedValue = hdnIsCustomerExistingFilter.Value.ToString().Trim();
}
}
TextBox txtName = GetNameTextBox();
TextBox txtFolio = GetFolioTextBox();
TextBox txtPan = GetPanTextBox();
if (txtName != null && txtFolio != null && txtPan != null)
{
if (hdnNameFilter.Value != "")
{
txtName.Text = hdnNameFilter.Value.ToString().Trim();
}
if (hdnFolioFilter.Value != "")
{
txtFolio.Text = hdnFolioFilter.Value.ToString().Trim();
}
if (hdnPANFilter.Value != "")
{
txtPan.Text = hdnPANFilter.Value.ToString().Trim();
}
}
}
else
{
hdnRecordCount.Value = "0";
gvCAMSProfileReject.DataSource = null;
gvCAMSProfileReject.DataBind();
trProfileMessage.Visible = true;
trReprocess.Visible = false;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedCAMSProfile.ascx:BindGrid()");
object[] objects = new object[1];
objects[0] = ProcessId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
this.GetPageCount();
}