protected void Page_Load(object sender, EventArgs e)
{
SessionBo.CheckSession();
userVo = (UserVo)Session["UserVo"];
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
advisorVo = (AdvisorVo)Session[SessionContents.AdvisorVo];
rmVo = (RMVo)Session[SessionContents.RmVo];
txtCustomer_autoCompleteExtender.ContextKey = rmVo.RMId.ToString();
BindPortfolioTypeDropDown();
if (!IsPostBack)
{
if (Request.QueryString["action"] == "EditCustomerPortfolio")
{
btnSave.Visible = false;
portfolioId = int.Parse(Session["PortfolioId"].ToString());
dsPortfolioType = portfolioBo.GetCustomerPortfolioDetails(portfolioId);
dtPortfolioType = dsPortfolioType.Tables[0];
txtCustomer.Text = dtPortfolioType.Rows[0]["C_FirstName"].ToString();
txtCustomerId.Value = dtPortfolioType.Rows[0]["C_CustomerId"].ToString();
txtPanCustomer.Text = dtPortfolioType.Rows[0]["C_PANNum"].ToString();
txtAddressCustomer.Text = dtPortfolioType.Rows[0]["C_Adr1Line1"].ToString();
txtPortfolioName.Text = dtPortfolioType.Rows[0]["CP_PortfolioName"].ToString();
txtPMSIdentifier.Text = dtPortfolioType.Rows[0]["CP_PMSIdentifier"].ToString();
ddlPortfolioType.SelectedValue = dtPortfolioType.Rows[0]["XPT_PortfolioTypeCode"].ToString();
btnSubmit.Text = "Update";
}
}
}
/// <summary>
/// Creating Data Table For "ELIGIBLE CAPITAL GAIN DETAILS & SUMMARY" Report : "Author:Pramod"
/// </summary>
/// <param name="reports">"reports" is a object of "MFReportVo" Contails report parameters </param>
/// <returns> DataTable</returns>
public DataTable GetEligibleCapitalGainDetailsReport(MFReportVo reports)
{
DataTable dtEligibleCapitalGainDetails = new DataTable();
dtEligibleCapitalGainDetails.Columns.Add("CustomerName");
dtEligibleCapitalGainDetails.Columns.Add("CustomerId");
dtEligibleCapitalGainDetails.Columns.Add("PortfolioName");
dtEligibleCapitalGainDetails.Columns.Add("PortfolioId");
dtEligibleCapitalGainDetails.Columns.Add("GainOrLoss", System.Type.GetType("System.Double"));
dtEligibleCapitalGainDetails.Columns.Add("Units", System.Type.GetType("System.Double"));
dtEligibleCapitalGainDetails.Columns.Add("RedDate");
dtEligibleCapitalGainDetails.Columns.Add("RedAmount", System.Type.GetType("System.Double"));
dtEligibleCapitalGainDetails.Columns.Add("DaysInvestedFor");
dtEligibleCapitalGainDetails.Columns.Add("PurchaseDate");
dtEligibleCapitalGainDetails.Columns.Add("PurchaseAmount", System.Type.GetType("System.Double"));
dtEligibleCapitalGainDetails.Columns.Add("FolioNum");
dtEligibleCapitalGainDetails.Columns.Add("SchemePlanCode");
dtEligibleCapitalGainDetails.Columns.Add("SchemePlanName");
dtEligibleCapitalGainDetails.Columns.Add("STCGTax", System.Type.GetType("System.Double"));
dtEligibleCapitalGainDetails.Columns.Add("LTCGTax", System.Type.GetType("System.Double"));
dtEligibleCapitalGainDetails.Columns.Add("Category");
dtEligibleCapitalGainDetails.Columns.Add("CurrNAV", System.Type.GetType("System.Double"));
dtEligibleCapitalGainDetails.Columns.Add("CurrVALUE", System.Type.GetType("System.Double"));
PortfolioBo portfolioBo = new PortfolioBo();
CustomerPortfolioBo customerPortfolioBo = new CustomerPortfolioBo();
DataSet dsReturnsTransactions = new DataSet();
List <MFPortfolioVo> mfPortfolioVoList = new List <MFPortfolioVo>();
try
{
String[] portfolioIds = reports.PortfolioIds.Split(',');
foreach (string strPortfoliioId in portfolioIds)
{
mfPortfolioVoList = new List <MFPortfolioVo>();
Int32 portfoliioId = Convert.ToInt32(strPortfoliioId);
DataSet dsPortfolioCustomer = portfolioBo.GetCustomerPortfolioDetails(portfoliioId);
DataRow drPortfolioCustomer = dsPortfolioCustomer.Tables[0].Rows[0];
mfPortfolioVoList = customerPortfolioBo.GetCustomerMFPortfolio(int.Parse(drPortfolioCustomer["C_CustomerId"].ToString()), portfoliioId, reports.ToDate, "", "", "");
if (mfPortfolioVoList != null && mfPortfolioVoList.Count > 0)
{
foreach (MFPortfolioVo mFPortfolioVo in mfPortfolioVoList)
{
foreach (MFPortfolioTransactionVo mFPortfolioTransaction in mFPortfolioVo.MFPortfolioTransactionVoList)
{
if (mFPortfolioTransaction.Closed == false && mFPortfolioTransaction.BuyDate < reports.ToDate)
{
DataRow drEligibleCapitalGainDetails = dtEligibleCapitalGainDetails.NewRow();
drEligibleCapitalGainDetails["CustomerName"] = drPortfolioCustomer["C_FirstName"].ToString();
drEligibleCapitalGainDetails["CustomerId"] = mFPortfolioVo.CustomerId;
if (drPortfolioCustomer["CP_PortfolioName"] != null)
{
drEligibleCapitalGainDetails["PortfolioName"] = drPortfolioCustomer["CP_PortfolioName"].ToString();
}
drEligibleCapitalGainDetails["PortfolioId"] = portfoliioId;
//drEligibleCapitalGainDetails["GainOrLoss"] = mFPortfolioTransaction.RealizedProfitLoss;
drEligibleCapitalGainDetails["GainOrLoss"] = mFPortfolioTransaction.STCGTax + mFPortfolioTransaction.LTCGTax;
drEligibleCapitalGainDetails["Units"] = mFPortfolioTransaction.BuyQuantity;
drEligibleCapitalGainDetails["RedDate"] = mFPortfolioTransaction.SellDate.ToShortDateString();
drEligibleCapitalGainDetails["RedAmount"] = mFPortfolioTransaction.NetSalesProceed;
drEligibleCapitalGainDetails["DaysInvestedFor"] = mFPortfolioTransaction.AgeOfInvestment;
drEligibleCapitalGainDetails["PurchaseDate"] = mFPortfolioTransaction.BuyDate.ToShortDateString();
drEligibleCapitalGainDetails["PurchaseAmount"] = mFPortfolioTransaction.CostOfAcquisition;
drEligibleCapitalGainDetails["FolioNum"] = mFPortfolioVo.Folio;
drEligibleCapitalGainDetails["SchemePlanCode"] = mFPortfolioVo.MFCode;
drEligibleCapitalGainDetails["SchemePlanName"] = mFPortfolioVo.SchemePlan;
drEligibleCapitalGainDetails["STCGTax"] = mFPortfolioTransaction.STCGTax;
drEligibleCapitalGainDetails["LTCGTax"] = mFPortfolioTransaction.LTCGTax;
drEligibleCapitalGainDetails["Category"] = mFPortfolioVo.Category;
drEligibleCapitalGainDetails["CurrNAV"] = mFPortfolioTransaction.CurrentNAV;
drEligibleCapitalGainDetails["CurrVALUE"] = mFPortfolioTransaction.CurrentValue;
dtEligibleCapitalGainDetails.Rows.Add(drEligibleCapitalGainDetails);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(dtEligibleCapitalGainDetails);
}
public DataTable GetCapitalGainSummaryReport(MFReportVo reports)
{
DataTable dtCapitalGainSummary = new DataTable();
dtCapitalGainSummary.Columns.Add("CustomerName");
dtCapitalGainSummary.Columns.Add("CustomerId");
dtCapitalGainSummary.Columns.Add("PortfolioName");
dtCapitalGainSummary.Columns.Add("PortfolioId");
dtCapitalGainSummary.Columns.Add("GainOrLoss", System.Type.GetType("System.Double"));
dtCapitalGainSummary.Columns.Add("FolioNum");
dtCapitalGainSummary.Columns.Add("PASP_SchemePlanCode");
dtCapitalGainSummary.Columns.Add("PASP_SchemePlanName");
dtCapitalGainSummary.Columns.Add("STCGAmount", System.Type.GetType("System.Double"));
dtCapitalGainSummary.Columns.Add("LTCGAmount", System.Type.GetType("System.Double"));
dtCapitalGainSummary.Columns.Add("Category");
DataRow dtRow = dtCapitalGainSummary.NewRow();
PortfolioBo portfolioBo = new PortfolioBo();
CustomerPortfolioBo customerPortfolioBo = new CustomerPortfolioBo();
DataSet dsReturnsTransactions = new DataSet();
List <MFPortfolioVo> mfPortfolioVoList = new List <MFPortfolioVo>();
try
{
String[] portfolioIds = reports.PortfolioIds.Split(',');
foreach (string strPortfoliioId in portfolioIds)
{
mfPortfolioVoList = new List <MFPortfolioVo>();
Int32 portfoliioId = Convert.ToInt32(strPortfoliioId);
DataSet dsPortfolioCustomer = portfolioBo.GetCustomerPortfolioDetails(portfoliioId);
DataRow drPortfolioCustomer = dsPortfolioCustomer.Tables[0].Rows[0];
mfPortfolioVoList = customerPortfolioBo.GetCustomerMFPortfolio(int.Parse(drPortfolioCustomer["C_CustomerId"].ToString()), portfoliioId, reports.ToDate, "", "", "");
if (mfPortfolioVoList != null && mfPortfolioVoList.Count > 0)
{
foreach (MFPortfolioVo mFPortfolioVo in mfPortfolioVoList)
{
foreach (MFPortfolioTransactionVo mFPortfolioTransaction in mFPortfolioVo.MFPortfolioTransactionVoList)
{
if (mFPortfolioTransaction.Closed == true && mFPortfolioTransaction.SellDate > reports.FromDate && mFPortfolioTransaction.SellDate < reports.ToDate)
{
DataRow drCapitalGainDetails = dtCapitalGainSummary.NewRow();
drCapitalGainDetails["CustomerName"] = drPortfolioCustomer["C_FirstName"].ToString();
drCapitalGainDetails["CustomerId"] = mFPortfolioVo.CustomerId;
if (drPortfolioCustomer["CP_PortfolioName"] != null)
{
drCapitalGainDetails["PortfolioName"] = drPortfolioCustomer["CP_PortfolioName"].ToString();
}
drCapitalGainDetails["PortfolioId"] = portfoliioId;
//drCapitalGainDetails["GainOrLoss"] = mFPortfolioTransaction.RealizedProfitLoss;
drCapitalGainDetails["GainOrLoss"] = mFPortfolioTransaction.STCGTax + mFPortfolioTransaction.LTCGTax;
drCapitalGainDetails["FolioNum"] = mFPortfolioVo.Folio;
drCapitalGainDetails["PASP_SchemePlanCode"] = mFPortfolioVo.MFCode;
drCapitalGainDetails["PASP_SchemePlanName"] = mFPortfolioVo.SchemePlan;
drCapitalGainDetails["STCGAmount"] = mFPortfolioTransaction.STCGTax;
drCapitalGainDetails["LTCGAmount"] = mFPortfolioTransaction.LTCGTax;
drCapitalGainDetails["Category"] = mFPortfolioVo.Category;
dtCapitalGainSummary.Rows.Add(drCapitalGainDetails);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(dtCapitalGainSummary);
}
public DataTable GetReturnTransactionSummaryReport(MFReportVo reports)
{
DataTable dtReturnTransaction = new DataTable();
PortfolioBo portfolioBo = new PortfolioBo();
CustomerPortfolioBo customerPortfolioBo = new CustomerPortfolioBo();
DataSet dsReturnsTransactions = new DataSet();
List <MFPortfolioVo> mfPortfolioVoList = new List <MFPortfolioVo>();
dtReturnTransaction.Columns.Add("TransactionType");
dtReturnTransaction.Columns.Add("Units", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("PurchaseDate", System.Type.GetType("System.DateTime"));
dtReturnTransaction.Columns.Add("PurchasePrice", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("PurchaseCost", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("SellDate", System.Type.GetType("System.DateTime"));
dtReturnTransaction.Columns.Add("SellPrice", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("SaleProceed", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("AsonDateNAV", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("AsOnDateValue", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("AgeOfInvestment", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("ActualPL", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("NotionalPL", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("TotalPL", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("AbsoluteReturn", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("AnnualReturn", System.Type.GetType("System.Double"));
dtReturnTransaction.Columns.Add("SchemePlanCode");
dtReturnTransaction.Columns.Add("SchemePlanName");
dtReturnTransaction.Columns.Add("FolioNum");
dtReturnTransaction.Columns.Add("CustomerName");
dtReturnTransaction.Columns.Add("CustomerId");
dtReturnTransaction.Columns.Add("PortfolioName");
dtReturnTransaction.Columns.Add("PortfolioId");
try
{
String[] portfolioIds = reports.PortfolioIds.Split(',');
foreach (string strPortfoliioId in portfolioIds)
{
mfPortfolioVoList = new List <MFPortfolioVo>();
Int32 portfoliioId = 0;
portfoliioId = Convert.ToInt32(strPortfoliioId);
DataSet dsPortfolioCustomer = portfolioBo.GetCustomerPortfolioDetails(portfoliioId);
DataRow drPortfolioCustomer = dsPortfolioCustomer.Tables[0].Rows[0];
mfPortfolioVoList = customerPortfolioBo.GetCustomerMFPortfolio(int.Parse(drPortfolioCustomer["C_CustomerId"].ToString()), portfoliioId, reports.FromDate, "", "", "");
if (mfPortfolioVoList != null && mfPortfolioVoList.Count > 0)
{
foreach (MFPortfolioVo mFPortfolioVo in mfPortfolioVoList)
{
foreach (MFPortfolioTransactionVo mFPortfolioTransaction in mFPortfolioVo.MFPortfolioTransactionVoList)
{
DataRow drReturnTransaction = dtReturnTransaction.NewRow();
drReturnTransaction["TransactionType"] = mFPortfolioTransaction.TransactionType;
drReturnTransaction["Units"] = mFPortfolioTransaction.BuyQuantity; //
drReturnTransaction["PurchaseDate"] = mFPortfolioTransaction.BuyDate;
drReturnTransaction["PurchasePrice"] = mFPortfolioTransaction.BuyPrice;
drReturnTransaction["PurchaseCost"] = mFPortfolioTransaction.CostOfAcquisition; //
drReturnTransaction["SellDate"] = mFPortfolioTransaction.SellDate;
drReturnTransaction["SellPrice"] = mFPortfolioTransaction.SellPrice;
drReturnTransaction["SaleProceed"] = mFPortfolioTransaction.RealizedSalesValue;
drReturnTransaction["AsonDateNAV"] = mFPortfolioTransaction.CurrentNAV;//
drReturnTransaction["AsOnDateValue"] = mFPortfolioTransaction.CurrentValue;
drReturnTransaction["AgeOfInvestment"] = mFPortfolioTransaction.AgeOfInvestment;
drReturnTransaction["ActualPL"] = mFPortfolioTransaction.RealizedProfitLoss;
drReturnTransaction["NotionalPL"] = mFPortfolioTransaction.NotionalProfitLoss;
drReturnTransaction["TotalPL"] = mFPortfolioTransaction.TotalProfitLoss;
drReturnTransaction["AbsoluteReturn"] = mFPortfolioTransaction.AbsoluteReturns;
drReturnTransaction["AnnualReturn"] = mFPortfolioTransaction.AnnualReturns;
drReturnTransaction["SchemePlanCode"] = mFPortfolioVo.MFCode;
drReturnTransaction["SchemePlanName"] = mFPortfolioVo.SchemePlan;
drReturnTransaction["FolioNum"] = mFPortfolioVo.Folio;
drReturnTransaction["CustomerName"] = drPortfolioCustomer["C_FirstName"].ToString();
drReturnTransaction["CustomerId"] = mFPortfolioVo.CustomerId;
if (drPortfolioCustomer["CP_PortfolioName"] != null)
{
drReturnTransaction["PortfolioName"] = drPortfolioCustomer["CP_PortfolioName"].ToString();
}
drReturnTransaction["PortfolioId"] = portfoliioId;
dtReturnTransaction.Rows.Add(drReturnTransaction);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(dtReturnTransaction);
}