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;
}
}
