public PersonalVo GetPersonalAsset(int personalPortfolioId)
{
PersonalDao personalDao = new PersonalDao();
PersonalVo personalVo = new PersonalVo();
try
{
personalVo = personalDao.GetPersonalAsset(personalPortfolioId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PersonalBo.cs:GetPersonalAsset()");
object[] objects = new object[1];
objects[0] = personalPortfolioId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(personalVo);
}
//protected void btnSubmit_Click(object sender, EventArgs e)
//{
// try
// {
// personalVo = (PersonalVo)Session["personalVo"];
// personalVo.AssetGroupCode = "PI";
// personalVo.Name = txtName.Text.ToString();
// personalVo.AssetCategoryCode = ddlCategory.SelectedItem.Value.ToString();
// personalVo.AssetSubCategoryCode = ddlSubCategory.SelectedItem.Value.ToString();
// personalVo.Quantity = int.Parse(txtQuantity.Text.ToString());
// personalVo.PurchaseDate = DateTime.Parse(txtPurchaseDate.Text.ToString());
// personalVo.PurchasePrice = int.Parse(txtPurchasePrice.Text.ToString());
// personalVo.PurchaseValue = int.Parse(txtPurchaseValue.Text.ToString());
// personalVo.CurrentPrice = int.Parse(txtCurrentPrice.Text.ToString());
// personalVo.CurrentValue = int.Parse(txtCurrentValue.Text.ToString());
// if (personalBo.UpdatePersonalPortfolio(personalVo, userVo.UserId))
// {
// // Do a RegisterClientScript here to redirect to the View Page
// Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "leftpane", "loadcontrol('PortfolioPersonal','none');", true);
// }
// else
// {
// // Show some error and display same page
// }
// }
// catch (BaseApplicationException Ex)
// {
// throw Ex;
// }
// catch (Exception Ex)
// {
// BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
// NameValueCollection FunctionInfo = new NameValueCollection();
// FunctionInfo.Add("Method", "PortfolioPersonalEntry.ascx:btnSubmit_Click()");
// object[] objects = new object[2];
// objects[0] = personalVo;
// objects[1] = userVo;
// FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
// exBase.AdditionalInformation = FunctionInfo;
// ExceptionManager.Publish(exBase);
// throw exBase;
// }
//}
protected void lnkEdit_Click(object sender, EventArgs e)
{
try
{
personalVo = (PersonalVo)Session["personalVo"];
SetControls("edit", personalVo);
btnUpdate.Visible = true;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PortfolioPersonalEntry.ascx:lnkEdit_Click()");
object[] objects = new object[1];
objects[0] = personalVo;
FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public int CreatePersonalPortfolio(PersonalVo personalVo, int userId)
{
PersonalDao personalDao = new PersonalDao();
int personalId = 0;
try
{
personalId = personalDao.CreatePersonalNetPosition(personalVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PersonalBo.cs:CreatePersonalPortfolio()");
object[] objects = new object[2];
objects[0] = personalVo;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(personalId);
}
public bool UpdatePersonalNetPosition(PersonalVo personalVo, int userId)
{
bool bResult = false;
Database db;
DbCommand updatePersonalNetPosition;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
updatePersonalNetPosition = db.GetStoredProcCommand("SP_UpdatePersonalNetPosition");
db.AddInParameter(updatePersonalNetPosition, "@CP_PortfolioId", DbType.Int32, personalVo.PortfolioId);
db.AddInParameter(updatePersonalNetPosition, "@CPNP_PersonalNPId", DbType.Int32, personalVo.PersonalPortfolioId);
db.AddInParameter(updatePersonalNetPosition, "@PAIC_AssetInstrumentCategoryCode", DbType.String, personalVo.AssetCategoryCode);
db.AddInParameter(updatePersonalNetPosition, "@PAISC_AssetInstrumentSubCategoryCode", DbType.String, personalVo.AssetSubCategoryCode);
db.AddInParameter(updatePersonalNetPosition, "@PAG_AssetGroupCode", DbType.String, personalVo.AssetGroupCode);
db.AddInParameter(updatePersonalNetPosition, "@CPNP_Name", DbType.String, personalVo.Name);
if (personalVo.PurchaseDate != DateTime.MinValue)
{
db.AddInParameter(updatePersonalNetPosition, "@CPNP_PurchaseDate", DbType.DateTime, personalVo.PurchaseDate);
}
else
{
db.AddInParameter(updatePersonalNetPosition, "@CPNP_PurchaseDate", DbType.DateTime, DBNull.Value);
}
db.AddInParameter(updatePersonalNetPosition, "@CPNP_PurchasePrice", DbType.Decimal, personalVo.PurchasePrice);
db.AddInParameter(updatePersonalNetPosition, "@CPNP_Quantity", DbType.Decimal, personalVo.Quantity);
db.AddInParameter(updatePersonalNetPosition, "@CPNP_PurchaseValue", DbType.Decimal, personalVo.PurchaseValue);
db.AddInParameter(updatePersonalNetPosition, "@CPNP_CurrentPrice", DbType.Decimal, personalVo.CurrentPrice);
db.AddInParameter(updatePersonalNetPosition, "@CPNP_CurrentValue", DbType.Decimal, personalVo.CurrentValue);
db.AddInParameter(updatePersonalNetPosition, "@CPNP_ModifiedBy", DbType.Int32, userId);
if (db.ExecuteNonQuery(updatePersonalNetPosition) != 0)
{
bResult = true;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PersonalDao.cs:UpdatePersonalNetPosition()");
object[] objects = new object[2];
objects[0] = personalVo;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
personalVo = (PersonalVo)Session["personalVo"];
personalVo.AssetGroupCode = "PI";
personalVo.Name = txtName.Text.ToString();
personalVo.AssetCategoryCode = ddlCategory.SelectedItem.Value.ToString();
personalVo.AssetSubCategoryCode = ddlSubCategory.SelectedItem.Value.ToString();
personalVo.Quantity = float.Parse(txtQuantity.Text.ToString());
if (txtPurchaseDate.Text.ToString() != string.Empty)
{
personalVo.PurchaseDate = DateTime.Parse(txtPurchaseDate.Text.ToString());
}
else
{
personalVo.PurchaseDate = DateTime.MinValue;
}
personalVo.PurchasePrice = double.Parse(txtPurchasePrice.Text.ToString());
personalVo.PurchaseValue = double.Parse(txtPurchaseValue.Text.ToString());
personalVo.CurrentPrice = double.Parse(txtCurrentPrice.Text.ToString());
personalVo.CurrentValue = double.Parse(txtCurrentValue.Text.ToString());
if (personalBo.UpdatePersonalPortfolio(personalVo, userVo.UserId))
{
Session.Remove("personalVo");
// Do a RegisterClientScript here to redirect to the View Page
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "leftpane", "loadcontrol('PortfolioPersonal','none');", true);
}
else
{
// Show some error and display same page
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PortfolioPersonalEntry.ascx:btnSubmit_Click()");
object[] objects = new object[2];
objects[0] = personalVo;
objects[1] = userVo;
FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void BindDropDowns(PersonalVo personalVo)
{
try
{
// Bind the Asset Categories
ddlCategory.Items.Clear();
dsAssetCategories = assetBo.GetAssetInstrumentCategory("PI");
ddlCategory.DataSource = dsAssetCategories.Tables[0];
ddlCategory.DataTextField = "PAIC_AssetInstrumentCategoryName".Trim();
ddlCategory.DataValueField = "PAIC_AssetInstrumentCategoryCode".Trim();
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, new ListItem("Select a Category", "Select a Category"));
ddlCategory.SelectedValue = personalVo.AssetCategoryCode.ToString().Trim();
// Bind the Asset Sub-Categories based on the selected Categories
ddlSubCategory.Items.Clear();
dsAssetSubCategories = assetBo.GetAssetInstrumentSubCategory("PI", ddlCategory.SelectedValue.ToString()); //Change to the respective GroupCode
ddlSubCategory.DataSource = dsAssetSubCategories.Tables[0];
ddlSubCategory.DataTextField = "PAISC_AssetInstrumentSubCategoryName";
ddlSubCategory.DataValueField = "PAISC_AssetInstrumentSubCategoryCode";
ddlSubCategory.DataBind();
ddlSubCategory.Items.Insert(0, new ListItem("Select a Sub-Category", "Select a Sub-Category"));
ddlSubCategory.SelectedValue = personalVo.AssetSubCategoryCode.ToString().Trim();
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PortfolioPersonalEntry.ascx:BindDropDowns()");
object[] objects = new object[1];
objects[0] = personalVo;
FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public void LoadPersonalGrid()
{
List <PersonalVo> personalList = new List <PersonalVo>();
try
{
int count;
personalList = personalBo.GetPersonalPortfolio(portfolioId, mypager.CurrentPage, hdnSort.Value, out count);
if (count > 0)
{
lblTotalRows.Text = hdnRecordCount.Value = count.ToString();
mypager.Visible = true;
}
if (personalList != null)
{
lblMsg.Visible = false;
mypager.Visible = true;
DataTable dtPersonal = new DataTable();
dtPersonal.Columns.Add("SI.No");
dtPersonal.Columns.Add("PersonalId");
dtPersonal.Columns.Add("Name");
dtPersonal.Columns.Add("Category");
dtPersonal.Columns.Add("Quantity");
dtPersonal.Columns.Add("Current Value");
dtPersonal.Columns.Add("Purchase Value");
dtPersonal.Columns.Add("Purchase Date");
DataRow drPersonal;
for (int i = 0; i < personalList.Count; i++)
{
drPersonal = dtPersonal.NewRow();
personalVo = new PersonalVo();
personalVo = personalList[i];
drPersonal[0] = (i + 1).ToString();
drPersonal[1] = personalVo.PersonalPortfolioId.ToString();
drPersonal[2] = personalVo.Name.ToString();
drPersonal[3] = personalVo.AssetSubCategoryName.ToString();
drPersonal[4] = personalVo.Quantity.ToString("f0");
if (Convert.ToDecimal(personalVo.CurrentValue.ToString()) == 0)
{
drPersonal[5] = "0";
}
else
{
drPersonal[5] = decimal.Parse(personalVo.CurrentValue.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
// drPersonal[5] = String.Format("{0:n2}", decimal.Parse(personalVo.CurrentValue.ToString("f2")));
if (Convert.ToDecimal(personalVo.PurchaseValue.ToString()) == 0)
{
drPersonal[6] = "0";
}
else
{
drPersonal[6] = decimal.Parse(personalVo.PurchaseValue.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
// drPersonal[6] = String.Format("{0:n2}", decimal.Parse(personalVo.PurchaseValue.ToString("f2")));
if (personalVo.PurchaseDate != DateTime.MinValue)
{
drPersonal[7] = personalVo.PurchaseDate.ToShortDateString();
}
else
{
drPersonal[7] = "";
}
dtPersonal.Rows.Add(drPersonal);
}
gvrPersonal.DataSource = dtPersonal;
gvrPersonal.DataBind();
this.GetPageCount();
}
else
{
lblMsg.Visible = true;
gvrPersonal.DataSource = null;
gvrPersonal.DataBind();
mypager.Visible = false;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PortfolioPersonal.ascx.cs:LoadPersonalGrid()");
object[] objects = new object[2];
objects[0] = personalList;
objects[1] = portfolioId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
SessionBo.CheckSession();
this.Page.Culture = "en-GB";
userVo = (UserVo)Session["userVo"];
customerVo = (CustomerVo)Session["CustomerVo"];
if (!IsPostBack)
{
portfolioId = int.Parse(Session[SessionContents.PortfolioId].ToString());
BindPortfolioDropDown();
trSubCategory.Visible = false;
dsAssetCategories = assetBo.GetAssetInstrumentCategory("PI"); //Change to the respective GroupCode
ddlCategory.DataSource = dsAssetCategories.Tables[0];
ddlCategory.DataTextField = "PAIC_AssetInstrumentCategoryName";
ddlCategory.DataValueField = "PAIC_AssetInstrumentCategoryCode";
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, new ListItem("Select a Category", "Select a Category"));
personalVo = (PersonalVo)Session["personalVo"];
if (Request.QueryString["action"] != null)
{
Manage = Request.QueryString["action"].ToString();
}
if (personalVo != null)
{
if (Manage == "edit")
{
SetControls("edit", personalVo);
}
else if (Manage == "view")
{
SetControls("view", personalVo);
}
}
else
{
SetControls("entry", personalVo);
}
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PortfolioPersonalEntry.ascx:Page_Load()");
object[] objects = new object[4];
objects[0] = customerVo;
objects[1] = portfolioId;
objects[2] = userVo;
objects[3] = personalVo;
FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void SetControls(string action, PersonalVo personalVo)
{
try
{
if (action == "entry")
{
// Clear all controls here
txtName.Text = "";
txtQuantity.Text = "";
txtPurchasePrice.Text = "";
txtPurchaseValue.Text = "";
txtCurrentPrice.Text = "";
txtCurrentValue.Text = "";
txtPurchaseDate.Text = "";
btnSubmit.Visible = true;
btnUpdate.Visible = false;
trEditLink.Visible = false;
lnkBack.Visible = false;
lblHeader.Visible = true;
Label1.Visible = false;
Label2.Visible = false;
}
else
{
// Bind the Asset Details to respective controls
lnkBack.Visible = true;
btnSubmit.Visible = false;
btnUpdate.Visible = true;
txtName.Text = personalVo.Name;
txtQuantity.Text = personalVo.Quantity.ToString();
txtPurchasePrice.Text = personalVo.PurchasePrice.ToString();
txtPurchaseValue.Text = personalVo.PurchaseValue.ToString();
txtCurrentPrice.Text = personalVo.CurrentPrice.ToString();
txtCurrentValue.Text = personalVo.CurrentValue.ToString();
if (personalVo.PurchaseDate != DateTime.MinValue)
{
txtPurchaseDate.Text = personalVo.PurchaseDate.ToShortDateString();
}
else
{
txtPurchaseDate.Text = "";
}
BindDropDowns(personalVo);
if (action == "view")
{
// Set Enable = false for each control
trSubCategory.Visible = true;
txtName.Enabled = false;
ddlCategory.Enabled = false;
ddlSubCategory.Enabled = false;
txtQuantity.Enabled = false;
txtPurchasePrice.Enabled = false;
txtPurchaseValue.Enabled = false;
txtCurrentPrice.Enabled = false;
txtCurrentValue.Enabled = false;
txtPurchaseDate.Enabled = false;
trEditLink.Visible = true;
btnUpdate.Visible = false;
lblHeader.Visible = false;
Label1.Visible = true;
Label2.Visible = false;
}
else if (action == "edit")
{
// Set Enable = true for each control
trSubCategory.Visible = true;
trEditLink.Visible = false;
txtName.Enabled = true;
ddlCategory.Enabled = true;
ddlSubCategory.Enabled = true;
txtQuantity.Enabled = true;
txtPurchasePrice.Enabled = true;
txtPurchaseValue.Enabled = true;
txtCurrentPrice.Enabled = true;
txtCurrentValue.Enabled = true;
txtPurchaseDate.Enabled = true;
btnUpdate.Visible = true;
lblHeader.Visible = false;
Label1.Visible = false;
Label2.Visible = true;
}
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PortfolioPersonalEntry.ascx:SetControls()");
object[] objects = new object[2];
objects[0] = personalVo;
objects[1] = action;
FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public List <PersonalVo> GetPersonalNetPosition(int portfolioId, int CurrentPage, string sortOrder, out int count)
{
List <PersonalVo> personalList = null;
PersonalVo personalVo;
Database db;
DbCommand getPersonalNetPositionCmd;
DataSet dsGetPersonalNetPosition;
DataTable dtGetPersonalNetPosition;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
getPersonalNetPositionCmd = db.GetStoredProcCommand("SP_GetPersonalNetPoition");
db.AddInParameter(getPersonalNetPositionCmd, "@CP_PortfolioId", DbType.Int32, portfolioId);
db.AddInParameter(getPersonalNetPositionCmd, "@CurrentPage", DbType.Int32, CurrentPage);
db.AddInParameter(getPersonalNetPositionCmd, "@SortOrder", DbType.String, sortOrder);
dsGetPersonalNetPosition = db.ExecuteDataSet(getPersonalNetPositionCmd);
dtGetPersonalNetPosition = dsGetPersonalNetPosition.Tables[0];
if (dsGetPersonalNetPosition.Tables[0] != null && dsGetPersonalNetPosition.Tables[1].Rows.Count > 0)
{
count = Int32.Parse(dsGetPersonalNetPosition.Tables[1].Rows[0][0].ToString());
}
else
{
count = 0;
}
if (dsGetPersonalNetPosition.Tables[0].Rows.Count > 0)
{
personalList = new List <PersonalVo>();
foreach (DataRow dr in dtGetPersonalNetPosition.Rows)
{
personalVo = new PersonalVo();
personalVo.PortfolioId = int.Parse(dr["CP_PortfolioId"].ToString());
personalVo.PersonalPortfolioId = int.Parse(dr["CPNP_PersonalNPId"].ToString());
personalVo.AssetCategoryCode = dr["PAIC_AssetInstrumentCategoryCode"].ToString();
personalVo.AssetSubCategoryCode = dr["PAISC_AssetInstrumentSubCategoryCode"].ToString();
personalVo.AssetCategoryName = dr["PAIC_AssetInstrumentCategoryName"].ToString();
personalVo.AssetSubCategoryName = dr["PAISC_AssetInstrumentSubCategoryName"].ToString();
personalVo.AssetGroupCode = dr["PAG_AssetGroupCode"].ToString();
personalVo.Name = dr["CPNP_Name"].ToString();
if (dr["CPNP_PurchaseDate"].ToString() != string.Empty)
{
personalVo.PurchaseDate = DateTime.Parse(dr["CPNP_PurchaseDate"].ToString());
}
else
{
personalVo.PurchaseDate = DateTime.MinValue;
}
personalVo.PurchasePrice = float.Parse(dr["CPNP_PurchasePrice"].ToString());
personalVo.Quantity = float.Parse(dr["CPNP_Quantity"].ToString());
personalVo.PurchaseValue = float.Parse(dr["CPNP_PurchaseValue"].ToString());
personalVo.CurrentPrice = float.Parse(dr["CPNP_CurrentPrice"].ToString());
personalVo.CurrentValue = float.Parse(dr["CPNP_CurrentValue"].ToString());
personalList.Add(personalVo);
}
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PersonalDao.cs:GetPersonalNetPosition()");
object[] objects = new object[1];
objects[0] = portfolioId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(personalList);
}
public PersonalVo GetPersonalAsset(int PersonalNetPositionId)
{
PersonalVo personalVo = null;
Database db;
DbCommand getPersonalNetPositionCmd;
DataSet dsGetPersonalNetPosition;
DataRow dr;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
getPersonalNetPositionCmd = db.GetStoredProcCommand("SP_GetPersonalNetPositionFromID");
db.AddInParameter(getPersonalNetPositionCmd, "@CPNP_PersonalNPId", DbType.Int32, PersonalNetPositionId);
dsGetPersonalNetPosition = db.ExecuteDataSet(getPersonalNetPositionCmd);
if (dsGetPersonalNetPosition.Tables[0].Rows.Count > 0)
{
dr = dsGetPersonalNetPosition.Tables[0].Rows[0];
personalVo = new PersonalVo();
personalVo.PortfolioId = int.Parse(dr["CP_PortfolioId"].ToString());
personalVo.PersonalPortfolioId = int.Parse(dr["CPNP_PersonalNPId"].ToString());
personalVo.AssetCategoryCode = dr["PAIC_AssetInstrumentCategoryCode"].ToString();
personalVo.AssetSubCategoryCode = dr["PAISC_AssetInstrumentSubCategoryCode"].ToString();
personalVo.AssetGroupCode = dr["PAG_AssetGroupCode"].ToString();
personalVo.Name = dr["CPNP_Name"].ToString();
if (dr["CPNP_PurchaseDate"].ToString() != string.Empty)
{
personalVo.PurchaseDate = DateTime.Parse(dr["CPNP_PurchaseDate"].ToString());
}
else
{
personalVo.PurchaseDate = DateTime.MinValue;
}
personalVo.PurchasePrice = float.Parse(dr["CPNP_PurchasePrice"].ToString());
personalVo.Quantity = float.Parse(dr["CPNP_Quantity"].ToString());
personalVo.PurchaseValue = float.Parse(dr["CPNP_PurchaseValue"].ToString());
personalVo.CurrentPrice = float.Parse(dr["CPNP_CurrentPrice"].ToString());
personalVo.CurrentValue = float.Parse(dr["CPNP_CurrentValue"].ToString());
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PersonalDao.cs:GetPersonalAsset()");
object[] objects = new object[1];
objects[0] = PersonalNetPositionId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(personalVo);
}
