public bool AddEquityTransaction(EQTransactionVo eqTransactionVo, int userId) { bool bResult = false; try { EQSpeculativeDao eqSpeculativeDao = new EQSpeculativeDao(); bResult = eqSpeculativeDao.AddEquityTransaction(eqTransactionVo, userId); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "EQSpeculativeDao.cs:AddEquityTransaction()"); object[] objects = new object[2]; objects[0] = eqTransactionVo; objects[1] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }
public bool UpdateSpeculativeTrades(EQTransactionVo eqTransactionVo) { bool bResult = false; Database db; DbCommand updateSpeculativeTradesCmd; try { db = DatabaseFactory.CreateDatabase("wealtherp"); updateSpeculativeTradesCmd = db.GetStoredProcCommand("SP_UpdateEquitySpeculativeTrades"); db.AddInParameter(updateSpeculativeTradesCmd, "@CET_EqTransId", DbType.Int32, eqTransactionVo.TransactionId); db.AddInParameter(updateSpeculativeTradesCmd, "@CET_IsSpeculative", DbType.Int16, eqTransactionVo.IsSpeculative); db.AddInParameter(updateSpeculativeTradesCmd, "@CET_Quantity", DbType.Decimal, eqTransactionVo.Quantity); db.AddInParameter(updateSpeculativeTradesCmd, "@CET_IsSplit", DbType.Int16, eqTransactionVo.IsSplit); db.AddInParameter(updateSpeculativeTradesCmd, "@CET_SplitCustEqTransId", DbType.Int32, eqTransactionVo.SplitTransactionId); db.ExecuteNonQuery(updateSpeculativeTradesCmd); bResult = true; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "EQSpeculativeDao.cs:UpdateSpeculativeTrades(EQTransactionVo eqTransactionVo)"); object[] objects = new object[2]; objects[0] = eqTransactionVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }
protected void Page_Load(object sender, EventArgs e) { try { SessionBo.CheckSession(); System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB"); eqTransactionVo = (EQTransactionVo)Session["EquityTransactionVo"]; customerVo = (CustomerVo)Session["CustomerVo"]; userVo = (UserVo)Session["userVo"]; portfolioId = int.Parse(Session[SessionContents.PortfolioId].ToString()); path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString()); if (!IsPostBack) { LoadViewField(); } btnCancel.Visible = false; } catch (BaseApplicationException ex) { throw ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewEquityTransaction.ascx:Page_Load()"); object[] objects = new object[5]; objects[0] = portfolioId; objects[1] = customerVo; objects[2] = eqTransactionVo; objects[3] = userVo; objects[4] = path; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
public void PerformSpeculativeFlagging(List <EQSpeculativeVo> eqSpeculativeVoList) { EQSpeculativeVo eqSpeculativeVo = new EQSpeculativeVo(); EQTransactionVo eqTransactionVo = new EQTransactionVo(); List <EQTransactionVo> eqTransactionVoList = new List <EQTransactionVo>(); int speculativeGroupCount = eqSpeculativeVoList.Count; int speculativeTransactionCount = 0; float buyQuantity = 0; float sellQuantity = 0; float cummBuyQuantity = 0; float cummSellQuantity = 0; int i = 0; int j = 0; for (i = 0; i < speculativeGroupCount; i++) { eqTransactionVoList = new List <EQTransactionVo>(); speculativeTransactionCount = eqSpeculativeVoList[i].EQTransactionVoList.Count; for (j = 0; j < speculativeTransactionCount; j++) { if (eqSpeculativeVoList[i].EQTransactionVoList[j].BuySell == "B") { buyQuantity = buyQuantity + eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity; } else { sellQuantity = sellQuantity + eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity; } } if (buyQuantity == sellQuantity) { for (j = 0; j < speculativeTransactionCount; j++) { eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 1; } } else if ((buyQuantity > 0 && sellQuantity == 0) || (sellQuantity > 0 && buyQuantity == 0)) { for (j = 0; j < speculativeTransactionCount; j++) { eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 0; } } else if (buyQuantity > sellQuantity) { cummSellQuantity = sellQuantity; cummBuyQuantity = 0; for (j = 0; j < speculativeTransactionCount; j++) { if (eqSpeculativeVoList[i].EQTransactionVoList[j].BuySell == "S") { eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 1; } else { cummBuyQuantity = cummBuyQuantity + eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity; if (cummBuyQuantity <= sellQuantity) { eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 1; cummSellQuantity = cummSellQuantity - eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity; } else if (cummBuyQuantity > sellQuantity && cummSellQuantity > 0) { eqTransactionVo = new EQTransactionVo(); eqTransactionVo = (eqSpeculativeVoList[i].EQTransactionVoList[j]).Clone(); eqTransactionVo.IsSpeculative = 1; eqTransactionVo.IsSplit = 1; eqTransactionVo.Quantity = cummSellQuantity; eqTransactionVo.SplitTransactionId = eqTransactionVo.TransactionId; eqTransactionVoList.Add(eqTransactionVo); eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 0; eqSpeculativeVoList[i].EQTransactionVoList[j].IsSplit = 1; eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity = eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity - cummSellQuantity; cummSellQuantity = 0; } else { eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 0; } } } } else { cummBuyQuantity = buyQuantity; cummSellQuantity = 0; for (j = 0; j < speculativeTransactionCount; j++) { if (eqSpeculativeVoList[i].EQTransactionVoList[j].BuySell == "B") { eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 1; } else { cummSellQuantity = cummSellQuantity + eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity; if (cummSellQuantity <= buyQuantity) { eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 1; cummBuyQuantity = cummBuyQuantity - eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity; } else if (cummSellQuantity > buyQuantity && cummBuyQuantity > 0) { eqTransactionVo = new EQTransactionVo(); eqTransactionVo = (eqSpeculativeVoList[i].EQTransactionVoList[j]).Clone(); eqTransactionVo.IsSpeculative = 1; eqTransactionVo.IsSplit = 1; eqTransactionVo.Quantity = cummBuyQuantity; eqTransactionVo.SplitTransactionId = eqTransactionVo.TransactionId; eqTransactionVoList.Add(eqTransactionVo); eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 0; eqSpeculativeVoList[i].EQTransactionVoList[j].IsSplit = 1; eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity = eqSpeculativeVoList[i].EQTransactionVoList[j].Quantity - cummBuyQuantity; cummBuyQuantity = 0; } else { eqSpeculativeVoList[i].EQTransactionVoList[j].IsSpeculative = 0; } } } } UpdateSpeculativeTrades(eqSpeculativeVoList[i].EQTransactionVoList); AddEquityTransaction(eqTransactionVoList, 1665); } }
protected void btnSubmit_Click(object sender, EventArgs e) { EQTransactionVo newEqTransactionVo = new EQTransactionVo(); decimal temp = 0; try { newEqTransactionVo.TransactionId = eqTransactionVo.TransactionId; newEqTransactionVo.IsSourceManual = eqTransactionVo.IsSourceManual; DataTable dt = productEqutiyBo.GetBrokerCode(portfolioId, ddlTradeAcc.SelectedItem.Text.ToString()); if (txtBrokerage.Text != "") { newEqTransactionVo.Brokerage = float.Parse(txtBrokerage.Text); } newEqTransactionVo.BrokerCode = dt.Rows[0]["XB_BrokerCode"].ToString(); if (ddlTranType.SelectedItem.Text.ToString() == "Purchase") { newEqTransactionVo.BuySell = "B"; newEqTransactionVo.TransactionCode = 1; } if (ddlTranType.SelectedItem.Text.ToString() == "Sell") { newEqTransactionVo.BuySell = "S"; newEqTransactionVo.TransactionCode = 2; } if (ddlTranType.SelectedItem.Text.ToString() == "Holdings") { newEqTransactionVo.BuySell = "B"; newEqTransactionVo.TransactionCode = 13; } newEqTransactionVo.CustomerId = customerVo.CustomerId; newEqTransactionVo.IsCorpAction = 0; newEqTransactionVo.EducationCess = (float)tempEducation; DataSet ds = productEqutiyBo.GetScripCode(txtScrip.Text.ToString()); txtTicker.Text = ds.Tables[0].Rows[0]["PEM_Ticker"].ToString(); scripCode = int.Parse(ds.Tables[0].Rows[0]["PEM_ScripCode"].ToString()); newEqTransactionVo.TradeAccountNum = ""; //long.Parse(ddlTradeAcc.SelectedItem.Text.ToString()); newEqTransactionVo.AccountId = int.Parse(ddlTradeAcc.SelectedValue.ToString()); newEqTransactionVo.ScripCode = scripCode; if (ddlExchange.SelectedItem.Value != "Select an Exchange") { newEqTransactionVo.Exchange = ddlExchange.SelectedItem.Value.ToString(); } else { newEqTransactionVo.Exchange = "NSE"; } if (txtOtherCharge.Text != "") { newEqTransactionVo.OtherCharges = float.Parse(txtOtherCharge.Text); } newEqTransactionVo.Quantity = float.Parse(txtNumShares.Text); newEqTransactionVo.IsSpeculative = 0; newEqTransactionVo.TradeType = "D"; newEqTransactionVo.AccountId = int.Parse(ddlTradeAcc.SelectedItem.Value.ToString()); newEqTransactionVo.Rate = float.Parse(txtRate.Text); newEqTransactionVo.RateInclBrokerage = float.Parse(txtRateIncBrokerage.Text); temp = decimal.Round(Convert.ToDecimal(tempService), 3); if (txtTax.Text != "") { newEqTransactionVo.ServiceTax = float.Parse(txtTax.Text); } if (txtSTT.Text != "") { newEqTransactionVo.STT = float.Parse(txtSTT.Text); } newEqTransactionVo.TradeDate = DateTime.Parse(txtTradeDate.Text); newEqTransactionVo.TradeTotal = float.Parse(txtTotal.Text); customerTransactionBo.UpdateEquityTransaction(newEqTransactionVo, userVo.UserId); btnSubmit.Enabled = false; ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "leftpane", "loadcontrol('EquityTransactionsView','none');", true); //Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('EquityTransactionsView','none');", true); } catch (BaseApplicationException ex) { throw ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewEquityTransaction.ascx:btnSubmit_Click()"); object[] objects = new object[2]; objects[0] = newEqTransactionVo; objects[1] = userVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
protected void btnSubmit_1_Click(object sender, EventArgs e) { customerVo = (CustomerVo)Session["CustomerVo"]; decimal temp; float res; float serviceTax = float.Parse(Session["serviceTax"].ToString()); float stt = float.Parse(Session["STT"].ToString()); ds.Tables.Add(tempDt); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { float brokerage = float.Parse(ds.Tables[0].Rows[i]["Brokerage"].ToString()); res = ((totalProrate) * (brokerage)) / totalBrokerage; ds.Tables[0].Rows[i]["Other Charges"] = res.ToString(); } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { eqTransactionVo = new EQTransactionVo(); eqTransactionVo.AccountId = 1001; // eqTransactionVo.Brokerage = decimal.Round((decimal)(ds.Tables[0].Rows[i]["Brokerage"].ToString()), 4); eqTransactionVo.Brokerage = float.Parse(ds.Tables[0].Rows[i]["Brokerage"].ToString()); eqTransactionVo.Brokerage = (float)decimal.Round(Convert.ToDecimal(eqTransactionVo.Brokerage), 4); eqTransactionVo.BrokerCode = ds.Tables[0].Rows[i]["Broker"].ToString(); if (ds.Tables[0].Rows[i]["Transaction Type"].ToString() == "Buy") { eqTransactionVo.BuySell = "B"; } else { eqTransactionVo.BuySell = "S"; } eqTransactionVo.CustomerId = int.Parse(customerVo.CustomerId.ToString()); if (ds.Tables[0].Rows[i]["Transaction Mode"].ToString() == "Delivery Trade") { eqTransactionVo.TradeType = "D"; } else { eqTransactionVo.TradeType = "S"; } eqTransactionVo.ServiceTax = serviceTax; eqTransactionVo.EducationCess = (float)((3 / 100) * serviceTax); eqTransactionVo.EducationCess = (float)decimal.Round(Convert.ToDecimal(eqTransactionVo.EducationCess), 4); eqTransactionVo.ScripCode = 100000; eqTransactionVo.Exchange = ds.Tables[0].Rows[i]["Exchange Type"].ToString(); eqTransactionVo.OtherCharges = float.Parse(ds.Tables[0].Rows[i]["Other Charges"].ToString()); eqTransactionVo.OtherCharges = (float)decimal.Round(Convert.ToDecimal(eqTransactionVo.OtherCharges), 4); eqTransactionVo.Quantity = float.Parse(ds.Tables[0].Rows[i]["No Of Shares"].ToString()); eqTransactionVo.Rate = float.Parse(ds.Tables[0].Rows[i]["Rate"].ToString()); eqTransactionVo.Rate = (float)decimal.Round(Convert.ToDecimal(eqTransactionVo.Rate), 4); eqTransactionVo.STT = stt; if (eqTransactionVo.BuySell == "B") { eqTransactionVo.RateInclBrokerage = eqTransactionVo.Rate + eqTransactionVo.Brokerage + eqTransactionVo.ServiceTax + eqTransactionVo.EducationCess + eqTransactionVo.STT + eqTransactionVo.OtherCharges; eqTransactionVo.RateInclBrokerage = (float)decimal.Round(Convert.ToDecimal(eqTransactionVo.RateInclBrokerage), 4); eqTransactionVo.TransactionCode = 1; } else { eqTransactionVo.RateInclBrokerage = eqTransactionVo.Rate - eqTransactionVo.Brokerage - (eqTransactionVo.ServiceTax + eqTransactionVo.EducationCess) - eqTransactionVo.STT - eqTransactionVo.OtherCharges; eqTransactionVo.RateInclBrokerage = (float)decimal.Round(Convert.ToDecimal(eqTransactionVo.RateInclBrokerage), 4); eqTransactionVo.TransactionCode = 2; } //eqTransactionVo.Source = "M"; //eqTransactionVo.SourceDetail = "WERP"; eqTransactionVo.TradeDate = DateTime.Parse(ds.Tables[0].Rows[i]["Trade Date"].ToString()); eqTransactionVo.TradeTotal = eqTransactionVo.RateInclBrokerage * eqTransactionVo.Quantity; eqTransactionVo.TradeTotal = (float)decimal.Round(Convert.ToDecimal(eqTransactionVo.TradeTotal), 4); eqTransactionVo.IsCorpAction = 0; // eqTransactionVo.TransactionId = customerTransactionBo.getId(); customerTransactionBo.AddEquityTransaction(eqTransactionVo, customerVo.UserId); } //foreach (GridViewRow gvr in GridView1.Rows) //{ // //TextBox txtBrokerage1 = (TextBox)gvr.FindControl("Brokerage"); // //float brokerage = float.Parse(txtBrokerage1.Text.ToString()); // // float brokerage = float.Parse(gvr.FindControl("Brokerage").ToString()); // string txt = ((TextBox)gvr.FindControl("Brokerage")).Text.ToString(); // float brokerage = float.Parse(txt); // res = ((totalProrate) * (brokerage)) / totalBrokerage; // TextBox other = (TextBox)gvr.FindControl("Other Charges"); // other.Text = res.ToString(); //} GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); GridView1.Visible = true; }
private bool SaveEquityTransaction() { EQTransactionVo eqTransactionVo = new EQTransactionVo(); CustomerTransactionBo customerTransactionBo = new CustomerTransactionBo(); try { // dt = productEquityBo.GetBrokerCode(portfolioId, ddlTradeAcc.SelectedItem.Text.ToString()); eqTransactionVo.IsSourceManual = 1; eqTransactionVo.Brokerage = float.Parse(txtBrokerage.Text); //eqTransactionVo.BrokerCode = dt.Rows[0]["XB_BrokerCode"].ToString(); if (ddlTransactionType.SelectedItem.Text.ToString() == "Purchase") { eqTransactionVo.BuySell = "B"; eqTransactionVo.TransactionCode = 1; } if (ddlTransactionType.SelectedItem.Text.ToString() == "Sell") { eqTransactionVo.BuySell = "S"; eqTransactionVo.TransactionCode = 2; } if (ddlTransactionType.SelectedItem.Text.ToString() == "Holdings") { eqTransactionVo.BuySell = "B"; eqTransactionVo.TransactionCode = 13; } if (txtParentCustomerId.Value != string.Empty) { eqTransactionVo.CustomerId = Convert.ToInt32(txtParentCustomerId.Value); //customerVo.CustomerId; } eqTransactionVo.IsCorpAction = 0; if (rdoDelivery.Checked) { eqTransactionVo.IsSpeculative = 0; } else if (rdoSpeculative.Checked) { eqTransactionVo.IsSpeculative = 1; } //eqTransactionVo.EducationCess = (float)tempEducation; eqTransactionVo.ScripCode = Convert.ToInt32(hidScrip.Value); //eqTransactionVo.Exchange = ddlExchange.SelectedItem.Value.ToString(); if (txtOtherCharges.Text != string.Empty) { eqTransactionVo.OtherCharges = float.Parse(txtOtherCharges.Text); } if (txtQuantity.Text != string.Empty) { eqTransactionVo.Quantity = float.Parse(txtQuantity.Text); } //eqTransactionVo.IsSpeculative = 0; eqTransactionVo.TradeType = "D"; // eqTransactionVo.AccountId = ; if (txtRate.Text != string.Empty) { eqTransactionVo.Rate = float.Parse(txtRate.Text); } //eqTransactionVo.RateInclBrokerage = float.Parse(txtRateIncBrokerage.Text); //temp = decimal.Round(Convert.ToDecimal(tempService), 3); //eqTransactionVo.ServiceTax = (float)temp; if (txtSTT.Text != string.Empty) { eqTransactionVo.STT = float.Parse(txtSTT.Text); } eqTransactionVo.TradeDate = Convert.ToDateTime(txtTransactionDate.Text.Trim());// DateTime.Parse(txtTradeDate.Text);//ddlDay.SelectedItem.Text.ToString() + "/" + ddlMonth.SelectedItem.Value.ToString() + "/" + ddlYear.SelectedItem.Value.ToString() //eqTransactionVo.TradeTotal = float.Parse(txtTotal.Text); if (ddlTradeAccountNos.SelectedValue != "-1") { eqTransactionVo.AccountId = int.Parse(ddlTradeAccountNos.SelectedValue); } //long.Parse(ddlTradeAcc.SelectedItem.Text.ToString()); if (customerTransactionBo.AddEquityTransaction(eqTransactionVo, eqTransactionVo.CustomerId)) { CustomerPortfolioBo customerPortfolioBo = new CustomerPortfolioBo(); AdvisorVo advisorVo = new AdvisorVo(); advisorVo = (AdvisorVo)Session["advisorVo"]; customerPortfolioBo.UpdateAdviserDailyEODLogRevaluateForTransaction(advisorVo.advisorId, "EQ", eqTransactionVo.TradeDate); } //btnSubmit.Enabled = false; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "EquityManualSingleTransaction.ascx:btnSubmit_Click()"); object[] objects = new object[3]; //objects[0] = portfolioId; ; //objects[1] = eqTransactionVo; //objects[2] = customerVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(false); }
public List <EQTransactionVo> GetEquityTransactionsForSpeculativeFlagging(int customerId, int accountId, int scripCode, string brokerCode, string tradeDate, string exchangeCode) { List <EQTransactionVo> eqTransactionVoList = new List <EQTransactionVo>(); EQTransactionVo eqTransactionVo = new EQTransactionVo(); Database db; DbCommand getEquitySpeculativeTransactionsCmd; DataSet dsEquitySpeculativeTransactions; DataTable dtEquitySpeculativeTransactions; try { db = DatabaseFactory.CreateDatabase("wealtherp"); getEquitySpeculativeTransactionsCmd = db.GetStoredProcCommand("SP_GetEquityDailyTransactions"); db.AddInParameter(getEquitySpeculativeTransactionsCmd, "@C_CustomerId", DbType.Int32, customerId); db.AddInParameter(getEquitySpeculativeTransactionsCmd, "@CETA_AccountId", DbType.Int32, accountId); db.AddInParameter(getEquitySpeculativeTransactionsCmd, "@XB_BrokerCode", DbType.String, brokerCode); db.AddInParameter(getEquitySpeculativeTransactionsCmd, "@CET_TradeDate", DbType.String, tradeDate); db.AddInParameter(getEquitySpeculativeTransactionsCmd, "@PEM_ScripCode", DbType.Int32, scripCode); db.AddInParameter(getEquitySpeculativeTransactionsCmd, "@XE_ExchangeCode", DbType.String, exchangeCode); dsEquitySpeculativeTransactions = db.ExecuteDataSet(getEquitySpeculativeTransactionsCmd); dtEquitySpeculativeTransactions = dsEquitySpeculativeTransactions.Tables[0]; eqTransactionVoList = new List <EQTransactionVo>(); foreach (DataRow dr in dtEquitySpeculativeTransactions.Rows) { eqTransactionVo = new EQTransactionVo(); eqTransactionVo.TransactionId = int.Parse(dr["CET_EqTransId"].ToString()); eqTransactionVo.CustomerId = int.Parse(dr["C_CustomerId"].ToString()); eqTransactionVo.AccountId = int.Parse(dr["CETA_AccountId"].ToString()); eqTransactionVo.ScripCode = int.Parse(dr["PEM_ScripCode"].ToString()); eqTransactionVo.ScripName = dr["PEM_CompanyName"].ToString(); if (dr["CETA_TradeAccountNum"].ToString() != null && dr["CETA_TradeAccountNum"].ToString() != string.Empty) { eqTransactionVo.TradeAccountNum = (dr["CETA_TradeAccountNum"].ToString()); } if (dr["CET_OrderNum"].ToString() != null && dr["CET_OrderNum"].ToString() != string.Empty) { eqTransactionVo.OrderNum = Int64.Parse(dr["CET_OrderNum"].ToString()); } if (dr["CET_BuySell"].ToString() != null && dr["CET_BuySell"].ToString() != string.Empty) { eqTransactionVo.BuySell = dr["CET_BuySell"].ToString(); } if (dr["CET_IsSpeculative"].ToString() != null && dr["CET_IsSpeculative"].ToString() != string.Empty) { eqTransactionVo.IsSpeculative = int.Parse(dr["CET_IsSpeculative"].ToString()); } if (dr["XE_ExchangeCode"].ToString() != null && dr["XE_ExchangeCode"].ToString() != string.Empty) { eqTransactionVo.Exchange = dr["XE_ExchangeCode"].ToString(); } if (dr["CET_TradeDate"].ToString() != null && dr["CET_TradeDate"].ToString() != string.Empty) { eqTransactionVo.TradeDate = DateTime.Parse(dr["CET_TradeDate"].ToString()); } if (dr["CET_Rate"].ToString() != null && dr["CET_Rate"].ToString() != string.Empty) { eqTransactionVo.Rate = float.Parse(dr["CET_Rate"].ToString()); } if (dr["CET_Quantity"].ToString() != null && dr["CET_Quantity"].ToString() != string.Empty) { eqTransactionVo.Quantity = float.Parse(dr["CET_Quantity"].ToString()); } if (dr["CET_Brokerage"].ToString() != null && dr["CET_Brokerage"].ToString() != string.Empty) { eqTransactionVo.Brokerage = float.Parse(dr["CET_Brokerage"].ToString()); } if (dr["CET_ServiceTax"].ToString() != null && dr["CET_ServiceTax"].ToString() != string.Empty) { eqTransactionVo.ServiceTax = float.Parse(dr["CET_ServiceTax"].ToString()); } if (dr["CET_EducationCess"].ToString() != null && dr["CET_EducationCess"].ToString() != string.Empty) { eqTransactionVo.EducationCess = float.Parse(dr["CET_EducationCess"].ToString()); } if (dr["CET_STT"].ToString() != null && dr["CET_STT"].ToString() != string.Empty) { eqTransactionVo.STT = float.Parse(dr["CET_STT"].ToString()); } if (dr["CET_OtherCharges"].ToString() != null && dr["CET_OtherCharges"].ToString() != string.Empty) { eqTransactionVo.OtherCharges = float.Parse(dr["CET_OtherCharges"].ToString()); } if (dr["CET_RateInclBrokerage"].ToString() != null && dr["CET_RateInclBrokerage"].ToString() != string.Empty) { eqTransactionVo.RateInclBrokerage = float.Parse(dr["CET_RateInclBrokerage"].ToString()); } if (dr["CET_TradeTotal"].ToString() != null && dr["CET_TradeTotal"].ToString() != string.Empty) { eqTransactionVo.TradeTotal = float.Parse(dr["CET_TradeTotal"].ToString()); } if (dr["XB_BrokerCode"].ToString() != null && dr["XB_BrokerCode"].ToString() != string.Empty) { eqTransactionVo.BrokerCode = dr["XB_BrokerCode"].ToString(); } if (dr["CET_IsSplit"].ToString() != null && dr["CET_IsSplit"].ToString() != string.Empty) { eqTransactionVo.IsSplit = int.Parse(dr["CET_IsSplit"].ToString()); } if (dr["CET_SplitCustEqTransId"].ToString() != null && dr["CET_SplitCustEqTransId"].ToString() != string.Empty) { eqTransactionVo.SplitTransactionId = int.Parse(dr["CET_SplitCustEqTransId"].ToString()); } if (dr["XES_SourceCode"].ToString() != null && dr["XES_SourceCode"].ToString() != string.Empty) { eqTransactionVo.SourceCode = dr["XES_SourceCode"].ToString(); } if (dr["WETT_TransactionCode"].ToString() != null && dr["WETT_TransactionCode"].ToString() != string.Empty) { eqTransactionVo.TransactionCode = int.Parse(dr["WETT_TransactionCode"].ToString()); } if (dr["WETT_TransactionTypeName"].ToString() != null && dr["WETT_TransactionTypeName"].ToString() != string.Empty) { eqTransactionVo.TransactionType = dr["WETT_TransactionTypeName"].ToString(); } if (dr["CET_IsSourceManual"].ToString() != null && dr["CET_IsSourceManual"].ToString() != string.Empty) { eqTransactionVo.IsSourceManual = int.Parse(dr["CET_IsSourceManual"].ToString()); } eqTransactionVoList.Add(eqTransactionVo); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "EQSpeculativeDao.cs:GetEquityTransactionsForSpeculativeFlagging(int customerId, int accountId, string brokerCode, string tradeDate)"); object[] objects = new object[2]; objects[0] = eqTransactionVoList; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(eqTransactionVoList); }
public bool AddEquityTransaction(EQTransactionVo eqTransactionVo, int userId) { bool bResult = false; Database db; DbCommand createEquityTransactionCmd; try { db = DatabaseFactory.CreateDatabase("wealtherp"); createEquityTransactionCmd = db.GetStoredProcCommand("SP_AddEquityTransaction"); db.AddInParameter(createEquityTransactionCmd, "@CETA_AccountId", DbType.Int32, eqTransactionVo.AccountId); db.AddInParameter(createEquityTransactionCmd, "@PEM_ScripCode", DbType.String, eqTransactionVo.ScripCode); db.AddInParameter(createEquityTransactionCmd, "@CETA_TradeAccountNum", DbType.Int64, eqTransactionVo.TradeAccountNum); db.AddInParameter(createEquityTransactionCmd, "@CET_OrderNum", DbType.Int64, eqTransactionVo.OrderNum); db.AddInParameter(createEquityTransactionCmd, "@CET_BuySell", DbType.String, eqTransactionVo.BuySell); db.AddInParameter(createEquityTransactionCmd, "@CET_IsSpeculative", DbType.Int16, eqTransactionVo.IsSpeculative); if (eqTransactionVo.Exchange == "") { db.AddInParameter(createEquityTransactionCmd, "@XE_ExchangeCode", DbType.String, DBNull.Value); } else { db.AddInParameter(createEquityTransactionCmd, "@XE_ExchangeCode", DbType.String, eqTransactionVo.Exchange); } db.AddInParameter(createEquityTransactionCmd, "@CET_TradeDate", DbType.DateTime, eqTransactionVo.TradeDate); db.AddInParameter(createEquityTransactionCmd, "@CET_Rate", DbType.Decimal, eqTransactionVo.Rate); db.AddInParameter(createEquityTransactionCmd, "@CET_Quantity", DbType.Decimal, eqTransactionVo.Quantity); db.AddInParameter(createEquityTransactionCmd, "@CET_Brokerage", DbType.Decimal, eqTransactionVo.Brokerage); db.AddInParameter(createEquityTransactionCmd, "@CET_ServiceTax", DbType.Decimal, eqTransactionVo.ServiceTax); db.AddInParameter(createEquityTransactionCmd, "@CET_EducationCess", DbType.Decimal, eqTransactionVo.EducationCess); db.AddInParameter(createEquityTransactionCmd, "@CET_STT", DbType.Decimal, eqTransactionVo.STT); db.AddInParameter(createEquityTransactionCmd, "@CET_OtherCharges", DbType.Decimal, eqTransactionVo.OtherCharges); db.AddInParameter(createEquityTransactionCmd, "@CET_RateInclBrokerage", DbType.Decimal, eqTransactionVo.RateInclBrokerage); db.AddInParameter(createEquityTransactionCmd, "@CET_TradeTotal", DbType.Decimal, eqTransactionVo.TradeTotal); if (eqTransactionVo.BrokerCode == "") { db.AddInParameter(createEquityTransactionCmd, "@XB_BrokerCode", DbType.String, DBNull.Value); } else { db.AddInParameter(createEquityTransactionCmd, "@XB_BrokerCode", DbType.String, eqTransactionVo.BrokerCode); } db.AddInParameter(createEquityTransactionCmd, "@CET_IsSplit", DbType.Int16, eqTransactionVo.IsSplit); db.AddInParameter(createEquityTransactionCmd, "@CET_SplitCustEqTransId", DbType.Int32, eqTransactionVo.SplitTransactionId); if (eqTransactionVo.SourceCode == "") { db.AddInParameter(createEquityTransactionCmd, "@XES_SourceCode", DbType.String, DBNull.Value); } else { db.AddInParameter(createEquityTransactionCmd, "@XES_SourceCode", DbType.String, eqTransactionVo.SourceCode); } db.AddInParameter(createEquityTransactionCmd, "@WETT_TransactionCode", DbType.Int16, eqTransactionVo.TransactionCode); db.AddInParameter(createEquityTransactionCmd, "@CET_IsSourceManual", DbType.Int16, eqTransactionVo.IsSourceManual); db.AddInParameter(createEquityTransactionCmd, "@CET_ModifiedBy", DbType.String, userId); db.AddInParameter(createEquityTransactionCmd, "@CET_CreatedBy", DbType.String, userId); db.AddOutParameter(createEquityTransactionCmd, "@CET_EqTransId", DbType.Int32, 5000); db.ExecuteNonQuery(createEquityTransactionCmd); bResult = true; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "EQSpeculativeDao.cs:AddEquityTransaction()"); object[] objects = new object[2]; objects[0] = eqTransactionVo; objects[1] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }
private void BindGridView(int customerId, DateTime from, DateTime to) { string type, mode; RadComboBox radComboBoxTradeDate = new RadComboBox(); DataSet dsExange = new DataSet();; DataTable dtEquityTransactions = new DataTable(); DataTable dtTradeDate = new DataTable(); Dictionary <string, string> genDictTranType = new Dictionary <string, string>(); Dictionary <string, string> genDictExchange = new Dictionary <string, string>(); Dictionary <string, string> genDictTradeDate = new Dictionary <string, string>(); int Visible = 0; try { if (Request.QueryString["From"] != null && Request.QueryString["To"] != null) { equityTransactionList = customerTransactionBo.GetEquityTransactions(customerId, int.Parse(Request.QueryString["PortfolioId"].ToString()), int.Parse(Request.QueryString["ScripCode"].ToString()), from, to, Request.QueryString["Currency"].ToString()); Visible = 1; } else { equityTransactionList = customerTransactionBo.GetEquityTransactions(customerId, portfolioId, 0, from, to, (ddl_type.SelectedValue)); } if (equityTransactionList != null) { ErrorMessage.Visible = false; gvEquityTransactions.Visible = true; dtEquityTransactions.Columns.Add("TransactionId"); dtEquityTransactions.Columns.Add("InvestorName"); dtEquityTransactions.Columns.Add("PanNo"); dtEquityTransactions.Columns.Add("ManagerName"); dtEquityTransactions.Columns.Add("BrokerName"); dtEquityTransactions.Columns.Add("TradeAccountNum"); dtEquityTransactions.Columns.Add("DematAccountNo"); dtEquityTransactions.Columns.Add("SettlementNo"); dtEquityTransactions.Columns.Add("BillNo"); dtEquityTransactions.Columns.Add("Scheme Name"); dtEquityTransactions.Columns.Add("Scripcode"); dtEquityTransactions.Columns.Add("Transaction Type"); dtEquityTransactions.Columns.Add("Transaction Code"); dtEquityTransactions.Columns.Add("Dividend Status"); dtEquityTransactions.Columns.Add("Exchange"); dtEquityTransactions.Columns.Add("TradeDate", typeof(DateTime)); dtEquityTransactions.Columns.Add("Quantity", typeof(double)); dtEquityTransactions.Columns.Add("Rate", typeof(double)); dtEquityTransactions.Columns.Add("FORExRate"); dtEquityTransactions.Columns.Add("FORExDate", typeof(DateTime)); dtEquityTransactions.Columns.Add("Gross Trade Consideration", typeof(double)); dtEquityTransactions.Columns.Add("Brokerage", typeof(double)); dtEquityTransactions.Columns.Add("Net Rate With Brokerage", typeof(double)); dtEquityTransactions.Columns.Add("Net Trade Consideration With Brokerage", typeof(double)); dtEquityTransactions.Columns.Add("SebiTurnOverFee", typeof(double)); dtEquityTransactions.Columns.Add("TransactionCharges", typeof(double)); dtEquityTransactions.Columns.Add("StampCharges", typeof(double)); dtEquityTransactions.Columns.Add("STT", typeof(double)); dtEquityTransactions.Columns.Add("ServiceTax", typeof(double)); dtEquityTransactions.Columns.Add("OtherCharges", typeof(double)); dtEquityTransactions.Columns.Add("Difference In Amount", typeof(double)); dtEquityTransactions.Columns.Add("Net Rate With All Charges", typeof(double)); dtEquityTransactions.Columns.Add("TradeTotal", typeof(double)); dtEquityTransactions.Columns.Add("TransactionStatus"); dtEquityTransactions.Columns.Add("Purpose"); dtEquityTransactions.Columns.Add("Demat Charge", typeof(double)); dtEquityTransactions.Columns.Add("FXCurencyRate"); dtEquityTransactions.Columns.Add("MktClosingForexRate"); dtEquityTransactions.Columns.Add("CET_CreatedOn", typeof(DateTime)); DataRow drEquityTransaction; DataRow drTradedate; for (int i = 0; i < equityTransactionList.Count; i++) { drEquityTransaction = dtEquityTransactions.NewRow(); drTradedate = dtTradeDate.NewRow(); equityTransactionVo = new EQTransactionVo(); equityTransactionVo = equityTransactionList[i]; drEquityTransaction["TransactionId"] = equityTransactionVo.TransactionId.ToString(); drEquityTransaction["TradeAccountNum"] = equityTransactionVo.TradeAccountNum.ToString(); drEquityTransaction["Scheme Name"] = equityTransactionVo.ScripName.ToString(); if (equityTransactionVo.TradeType.ToString() == "D") { mode = "Delivery"; } else { mode = "Speculation"; } if (equityTransactionVo.TransactionCode == 1 || equityTransactionVo.TransactionCode == 2) { drEquityTransaction["Transaction Type"] = equityTransactionVo.TransactionType + "/" + mode; } else { drEquityTransaction["Transaction Type"] = equityTransactionVo.TransactionType; } drEquityTransaction["Transaction Code"] = equityTransactionVo.TransactionCode.ToString(); drEquityTransaction["Exchange"] = equityTransactionVo.Exchange.ToString(); drEquityTransaction["TradeDate"] = DateTime.Parse(equityTransactionVo.TradeDate.ToString()); drEquityTransaction["Rate"] = decimal.Parse(equityTransactionVo.Rate.ToString()).ToString(); drEquityTransaction["Quantity"] = equityTransactionVo.Quantity.ToString("f0"); drEquityTransaction["Brokerage"] = decimal.Parse(equityTransactionVo.Brokerage.ToString()); drEquityTransaction["TradeTotal"] = decimal.Parse(equityTransactionVo.TradeTotal.ToString()).ToString(); drEquityTransaction["TransactionStatus"] = equityTransactionVo.TransactionStatus.ToString(); drEquityTransaction["ManagerName"] = equityTransactionVo.ManagerName.ToString(); drEquityTransaction["BrokerName"] = equityTransactionVo.BrokerName.ToString(); drEquityTransaction["DematAccountNo"] = equityTransactionVo.DpclientId.ToString(); drEquityTransaction["Purpose"] = equityTransactionVo.Purpose.ToString(); drEquityTransaction["InvestorName"] = equityTransactionVo.InvestorName.ToString(); drEquityTransaction["PanNo"] = equityTransactionVo.PanNo.ToString(); drEquityTransaction["Scripcode"] = equityTransactionVo.Scripcode.ToString(); drEquityTransaction["SettlementNo"] = equityTransactionVo.SettlementNo.ToString(); drEquityTransaction["BillNo"] = equityTransactionVo.BillNo.ToString(); drEquityTransaction["SebiTurnOverFee"] = equityTransactionVo.SebiTurnOverFee.ToString(); drEquityTransaction["TransactionCharges"] = equityTransactionVo.TransactionCharges.ToString(); drEquityTransaction["StampCharges"] = equityTransactionVo.StampCharges.ToString(); drEquityTransaction["STT"] = equityTransactionVo.STT.ToString(); drEquityTransaction["ServiceTax"] = equityTransactionVo.ServiceTax.ToString(); drEquityTransaction["Difference In Amount"] = equityTransactionVo.DifferenceInBrokerage.ToString(); drEquityTransaction["OtherCharges"] = equityTransactionVo.OtherCharges.ToString(); drEquityTransaction["Gross Trade Consideration"] = equityTransactionVo.GrossConsideration.ToString(); drEquityTransaction["Net Rate With Brokerage"] = equityTransactionVo.RateInclBrokerage.ToString(); drEquityTransaction["Net Trade Consideration With Brokerage"] = equityTransactionVo.TradeTotalIncBrokerage.ToString(); drEquityTransaction["Net Rate With All Charges"] = equityTransactionVo.RateIncBrokerageAllCharges.ToString(); if (equityTransactionVo.DividendRecieved == true) { drEquityTransaction["Dividend Status"] = "Received"; } else if (equityTransactionVo.DividendRecieved == false) { drEquityTransaction["Dividend Status"] = "Receivable"; } drEquityTransaction["Demat Charge"] = equityTransactionVo.DematCharge; drEquityTransaction["FORExRate"] = equityTransactionVo.ForExRate; drEquityTransaction["FORExRate"] = equityTransactionVo.ForExRate; if (equityTransactionVo.ForExRateDate != DateTime.MinValue) { drEquityTransaction["FORExDate"] = equityTransactionVo.ForExRateDate; } drEquityTransaction["FXCurencyRate"] = equityTransactionVo.FXCurencyRate; drEquityTransaction["MktClosingForexRate"] = equityTransactionVo.MktClosingForexRate; drEquityTransaction["CET_CreatedOn"] = DateTime.Parse(equityTransactionVo.CreatedOn.ToString()); dtEquityTransactions.Rows.Add(drEquityTransaction); } gvEquityTransactions.DataSource = dtEquityTransactions; ViewState["asd"] = dtEquityTransactions; gvEquityTransactions.DataBind(); gvEquityTransactions.Visible = true; if (Visible == 1) { gvEquityTransactions.MasterTableView.GetColumn("action").Visible = false; } Panel1.Visible = true; trSelectAction.Visible = true; ddlAction.SelectedIndex = 0; if (!advisorVo.A_IsFamilyOffice) { gvEquityTransactions.MasterTableView.GetColumn("ManagerName").Visible = false; ddlAction.Items[2].Enabled = false; ddlAction.Items[3].Enabled = false; ddlAction.Items[4].Enabled = false; } if (Cache["EquityTransactionsDetails" + customerPortfolioVo.CustomerId.ToString()] == null) { Cache.Insert("EquityTransactionsDetails" + customerPortfolioVo.CustomerId.ToString(), dtEquityTransactions); } else { Cache.Remove("EquityTransactionsDetails" + customerPortfolioVo.CustomerId.ToString()); Cache.Insert("EquityTransactionsDetails" + customerPortfolioVo.CustomerId.ToString(), dtEquityTransactions); } imgBtnExport.Visible = true; } else { imgBtnExport.Visible = false; ErrorMessage.Visible = true; gvEquityTransactions.DataSource = null; Panel1.Visible = false; gvEquityTransactions.Visible = false; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "EquityTransactionsView.ascx:BindGridView()"); object[] objects = new object[2]; objects[0] = customerId; objects[1] = equityTransactionList; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }