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