protected void Page_Load(object sender, EventArgs e)
{
advisorVo = (AdvisorVo)Session["advisorVo"];
rmVo = (RMVo)Session[SessionContents.RmVo];
userVo = (UserVo)Session["userVo"];
AdvisorMISBo adviserMISBo = new AdvisorMISBo();
if (Session[SessionContents.ValuationDate] == null)
GetLatestValuationDate();
genDict = (Dictionary<string, DateTime>)Session[SessionContents.ValuationDate];
strValuationDate = genDict[Constants.EQDate.ToString()].ToShortDateString();
lblPickDate.Text = DateTime.Parse(genDict[Constants.EQDate.ToString()].ToString()).ToShortDateString();
if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "admin" || Session[SessionContents.CurrentUserRole].ToString().ToLower() == "ops")
userType = "advisor";
else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "rm")
userType = "rm";
else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "bm")
userType = "bm";
else
userType = Session[SessionContents.CurrentUserRole].ToString().ToLower();
advisorId = advisorVo.advisorId;
int RMId = rmVo.RMId;
rmId = rmVo.RMId;
bmID = rmVo.RMId;
//if (!IsPostBack)
//{
// SetParameters();
// BindEQReturnsGrid();
//}
pnlEqHoldings.Visible = false;
pnlEQReturns.Visible = false;
gvEqHldings.Visible = false;
gvEQReturns.Visible = false;
imgCompany.Visible = false;
imgEQReturns.Visible = false;
}
private void bindgrid(DateTime Valuationdate, int schemeplanid)
{
AdvisorMISBo adviserMISBo = new AdvisorMISBo();
DataSet dsMISReport = null;
double totalAum = 0;
double totalUnits = 0;
int CurrentPage;
int.TryParse(ddlBranch.SelectedValue, out branchId);
int.TryParse(ddlRM.SelectedValue, out rmId);
if (hdnCurrentPage.Value == string.Empty || hdnCurrentPage.Value == "")
{
CurrentPage = 1;
}
else
{
CurrentPage = int.Parse(hdnCurrentPage.Value);
}
//For paging
//if (hdnCurrentPage.Value.ToString() != "")
//{
// mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString());
// hdnCurrentPage.Value = "";
//}
/*
* if(userType == "rm")
* {
* if (AllPageExport == true)
* {
* dsMISReport = adviserMISBo.GetAMCSchemewiseMISForRM(rmid, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString()));
*
* }
* else
* {
* dsMISReport = adviserMISBo.GetAMCSchemewiseMISForRM(rmid, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, 0);
* }
* }
*
* else if (userType == "bm")
* {
* if (AllPageExport == true)
* {
* dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), DateTime.Parse(hdnValuationDate.Value.ToString()), hdnAMCSearchVal.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString()));
* }
* else
* {
* dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), DateTime.Parse(hdnValuationDate.Value.ToString()), hdnAMCSearchVal.Value.ToString(), out Count, 0);
* }
* }
* else if (userType == "advisor")
* {
* if (AllPageExport == true)
* {
* dsMISReport = adviserMISBo.GetAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString()));
*
* }
* else
* {
* dsMISReport = adviserMISBo.GetAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, 0);
* }
*
* }
*
*
*/
if (userType == "rm")
{
if (AllPageExport == true)
{
dsMISReport = adviserMISBo.GetCustomerAMCSchemewiseMISForRM(rmid, Valuationdate, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString()));
}
else
{
dsMISReport = adviserMISBo.GetCustomerAMCSchemewiseMISForRM(rmid, Valuationdate, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), out Count, 0);
}
}
else if (userType == "bm")
{
if (AllPageExport == true)
{
dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), DateTime.Parse(hdnValuationDate.Value.ToString()), 0, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), string.Empty, out Count, int.Parse(hdnRecordCount.Value.ToString()));
}
else
{
dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), DateTime.Parse(hdnValuationDate.Value.ToString()), 0, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), string.Empty, out Count, 0);
}
}
else if (userType == "adviser")
{
if (AllPageExport == true)
{
dsMISReport = adviserMISBo.GetCustomerAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuationdate, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString()));
}
else
{
dsMISReport = adviserMISBo.GetCustomerAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuationdate, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), out Count, 0);
}
}
if (dsMISReport.Tables[0].Rows.Count == 0)
{
trMessage.Visible = true;
gvMFMIS.DataSource = dsMISReport;
gvMFMIS.DataBind();
}
else
{
double no_of_units = 0;
double aum = 0;
//for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++)
//{
// dsMISReport.Tables[0].Rows[i]["MarketPrice"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["MarketPrice"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
// dsMISReport.Tables[0].Rows[i]["AUM"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["AUM"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
// dsMISReport.Tables[0].Rows[i]["Percentage"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["Percentage"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
//}
foreach (DataRow dr in dsMISReport.Tables[0].Rows)
{
no_of_units = Convert.ToDouble(dr["Units"].ToString());
aum = Convert.ToDouble(dr["AUM"].ToString());
totalUnits = totalUnits + no_of_units;
totalAum = totalAum + aum;
}
DataTable dtMISReport = new DataTable();
dtMISReport.Columns.Add("CustomerName");
dtMISReport.Columns.Add("FolioNum");
dtMISReport.Columns.Add("AMC");
dtMISReport.Columns.Add("Scheme");
dtMISReport.Columns.Add("Category");
dtMISReport.Columns.Add("MarketPrice");
dtMISReport.Columns.Add("Units");
dtMISReport.Columns.Add("AUM");
dtMISReport.Columns.Add("Percentage");
DataRow drMISReport;
for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++)
{
drMISReport = dtMISReport.NewRow();
drMISReport[0] = dsMISReport.Tables[0].Rows[i][1].ToString();
drMISReport[1] = dsMISReport.Tables[0].Rows[i][2].ToString();
drMISReport[2] = dsMISReport.Tables[0].Rows[i][4].ToString();
drMISReport[3] = dsMISReport.Tables[0].Rows[i][5].ToString();
drMISReport[4] = dsMISReport.Tables[0].Rows[i][6].ToString();
drMISReport[5] = dsMISReport.Tables[0].Rows[i][9].ToString();
if (GridViewCultureFlag == true)
{
decimal temp = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][8].ToString()), 4);
drMISReport[6] = temp.ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
decimal tempAum = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2);
drMISReport[7] = tempAum.ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
//drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
else
{
drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][8].ToString()), 4).ToString();
decimal tempAum = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2);
drMISReport[7] = tempAum.ToString();
//drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2).ToString();
}
drMISReport[8] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][10].ToString()), 2).ToString();
dtMISReport.Rows.Add(drMISReport);
}
gvMFMIS.DataSource = dtMISReport;
gvMFMIS.DataBind();
if (GridViewCultureFlag == true)
{
gvMFMIS.FooterRow.Cells[8].Text = System.Math.Round(decimal.Parse(totalAum.ToString()), 2).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
gvMFMIS.FooterRow.Cells[7].Text = totalUnits.ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
else
{
decimal tempTotalAum = System.Math.Round(decimal.Parse(totalAum.ToString()), 2);
gvMFMIS.FooterRow.Cells[8].Text = tempTotalAum.ToString();
gvMFMIS.FooterRow.Cells[7].Text = totalUnits.ToString();
}
}
lblTotalRows.Text = hdnRecordCount.Value = Count.ToString();
if (Count > 0)
{
DivPager.Style.Add("display", "visible");
}
else
{
DivPager.Style.Add("display", "none");
lblCurrentPage.Text = "";
lblCurrentPage.Text = "";
}
ViewState["schemeplanid"] = schemeplanid.ToString();
ViewState["Valuationdate"] = Valuationdate.ToString();
TextBox txtamc = new TextBox();
TextBox txtscheme = new TextBox();
TextBox txtCustomer = new TextBox();
TextBox txtFolio = new TextBox();
if (gvMFMIS.HeaderRow != null)
{
txtamc = (TextBox)gvMFMIS.HeaderRow.FindControl("txtAMCSearch");
txtscheme = (TextBox)gvMFMIS.HeaderRow.FindControl("txtSchemeSearch");
txtCustomer = (TextBox)gvMFMIS.HeaderRow.FindControl("txtCustomerSearch");
txtFolio = (TextBox)gvMFMIS.HeaderRow.FindControl("txtFolioSearch");
}
txtamc.Text = hdnAMCSearchVal.Value.ToString();
txtscheme.Text = hdnSchemeSearchVal.Value.ToString();
txtCustomer.Text = hdnCustomerNameVal.Value.ToString();
txtFolio.Text = hdnFolioNumVal.Value.ToString();
this.GetPageCount();
}
//protected void gvMFMIS_RowDataBound(object sender, GridViewRowEventArgs e)
//{
// if (e.Row.RowType == DataControlRowType.Footer)
// {
// e.Row.Cells[5].Text = "Total ";
// if (GridViewCultureFlag == true)
// e.Row.Cells[7].Text = decimal.Parse(totalAmount.ToString()).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
// else
// {
// e.Row.Cells[7].Text = decimal.Parse(totalAmount.ToString()).ToString();
// }
// e.Row.Cells[7].Attributes.Add("align", "Right");
// if (GridViewCultureFlag == true)
// e.Row.Cells[6].Text = decimal.Parse(totalUnits.ToString()).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
// else
// {
// e.Row.Cells[6].Text = decimal.Parse(totalUnits.ToString()).ToString();
// }
// e.Row.Cells[6].Attributes.Add("align", "Right");
// amcCode
// //if (e.Row.RowType == DataControlRowType.Header)
// //{
// // DropDownList ddlStatus = (DropDownList)e.Row.FindControl("ddlCategory");
// // if (hdnCategoryFilter.Value!=null)
// // ddlStatus.SelectedValue = hdnCategoryFilter.Value;
// //}
//}
private void bindgrid(DateTime Valuationdate, int amcCode)
{
AdvisorMISBo adviserMISBo = new AdvisorMISBo();
DataSet dsMISReport = null;
//double totalAum = 0;
//double totalUnits = 0;
int CurrentPage;
int rmId, branchId;
int.TryParse(ddlBranch.SelectedValue, out branchId);
int.TryParse(ddlRM.SelectedValue, out rmId);
// DateTime Valuation_Date = Convert.ToDateTime(txtDate.Text);
DateTime Valuation_Date = Valuationdate;
if (hdnCurrentPage.Value == string.Empty || hdnCurrentPage.Value == "")
{
CurrentPage = 1;
}
else
{
CurrentPage = int.Parse(hdnCurrentPage.Value);
}
if ((Session["BranchFilterForAMC"] != null) || (Session["RMFilterForAMC"] != null))
{
if (Session["PassAMCCode"] != null)
{
amcCode = int.Parse(Session["PassAMCCode"].ToString());
}
else
{
amcCode = 0;
}
}
if (userType == "rm")
{
if (AllPageExport == true)
{
dsMISReport = adviserMISBo.GetAMCSchemewiseMISForRM(rmid, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString()));
}
else
{
dsMISReport = adviserMISBo.GetAMCSchemewiseMISForRM(rmid, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, 0);
}
}
else if (userType == "bm")
{
if (AllPageExport == true)
{
dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), Valuation_Date, amcCode, 0, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), string.Empty, string.Empty, hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString()));
}
else
{
dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), Valuation_Date, amcCode, 0, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), string.Empty, string.Empty, hdnCategoryFilter.Value.ToString(), out Count, 0);
}
}
else if (userType == "adviser")
{
if (AllPageExport == true)
{
dsMISReport = adviserMISBo.GetAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString()));
}
else
{
dsMISReport = adviserMISBo.GetAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, 0);
}
}
if (dsMISReport.Tables[0].Rows.Count == 0)
{
trMessage.Visible = true;
gvMFMIS.DataSource = dsMISReport;
gvMFMIS.DataBind();
imgBtnExport.Visible = false;
}
else
{
DataTable dtMISReport = new DataTable();
dtMISReport.Columns.Add("SchemePlanCode");
dtMISReport.Columns.Add("AMC");
dtMISReport.Columns.Add("Scheme");
dtMISReport.Columns.Add("Category");
dtMISReport.Columns.Add("SubCategory");
dtMISReport.Columns.Add("AUM");
dtMISReport.Columns.Add("Units");
dtMISReport.Columns.Add("MarketPrice");
dtMISReport.Columns.Add("Percentage");
DataRow drMISReport;
for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++)
{
drMISReport = dtMISReport.NewRow();
drMISReport[0] = dsMISReport.Tables[0].Rows[i][1].ToString();
drMISReport[1] = dsMISReport.Tables[0].Rows[i][2].ToString();
drMISReport[2] = dsMISReport.Tables[0].Rows[i][3].ToString();
drMISReport[3] = dsMISReport.Tables[0].Rows[i][4].ToString();
drMISReport[4] = dsMISReport.Tables[0].Rows[i][5].ToString();
//drMISReport[5] = dsMISReport.Tables[0].Rows[i][6].ToString();
//drMISReport[6] = dsMISReport.Tables[0].Rows[i][7].ToString();
//drMISReport[7] = dsMISReport.Tables[0].Rows[i][8].ToString();
if (GridViewCultureFlag == true)
{
decimal temp = decimal.Parse(dsMISReport.Tables[0].Rows[i][6].ToString());
drMISReport[5] = temp.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
drMISReport[6] = decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
//drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
else
{
drMISReport[5] = decimal.Parse(dsMISReport.Tables[0].Rows[i][6].ToString()).ToString();
drMISReport[6] = decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()).ToString();
//drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2).ToString();
}
drMISReport[7] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][8].ToString()), 2).ToString();
drMISReport[8] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][9].ToString()), 2).ToString();
dtMISReport.Rows.Add(drMISReport);
}
gvMFMIS.DataSource = dtMISReport;
gvMFMIS.DataBind();
imgBtnExport.Visible = true;
double no_of_units = 0;
double aum = 0;
foreach (DataRow dr in dsMISReport.Tables[0].Rows)
{
no_of_units = Convert.ToDouble(dr["Units"].ToString());
aum = Convert.ToDouble(dr["AUM"].ToString());
totalUnits = totalUnits + no_of_units;
totalAmount = totalAmount + aum;
}
if (GridViewCultureFlag == true)
{
gvMFMIS.FooterRow.Cells[6].Text = totalUnits.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
gvMFMIS.FooterRow.Cells[7].Text = totalAmount.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
else
{
gvMFMIS.FooterRow.Cells[6].Text = totalUnits.ToString();
gvMFMIS.FooterRow.Cells[7].Text = totalAmount.ToString();
}
}
lblTotalRows.Text = hdnRecordCount.Value = Count.ToString();
if (Count > 0)
{
DivPager.Style.Add("display", "visible");
}
else
{
DivPager.Style.Add("display", "none");
lblCurrentPage.Text = "";
lblCurrentPage.Text = "";
}
ViewState["Valuationdate"] = Valuationdate.ToString();
TextBox txtamc = new TextBox();
TextBox txtscheme = new TextBox();
if (gvMFMIS.HeaderRow != null)
{
txtamc = (TextBox)gvMFMIS.HeaderRow.FindControl("txtAMCSearch");
txtscheme = (TextBox)gvMFMIS.HeaderRow.FindControl("txtSchemeSearch");
}
txtamc.Text = hdnAMCSearchVal.Value.ToString();
txtscheme.Text = hdnSchemeSearchVal.Value.ToString();
if (dsMISReport.Tables[2].Rows.Count > 0)
{
DropDownList ddlcategorylist = GetCategoryDDL();
if (ddlcategorylist != null)
{
ddlcategorylist.DataSource = dsMISReport.Tables[2];
ddlcategorylist.DataTextField = dsMISReport.Tables[2].Columns[0].ToString();
ddlcategorylist.DataValueField = dsMISReport.Tables[2].Columns[0].ToString();
ddlcategorylist.DataBind();
ddlcategorylist.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "Select"));
if (hdnCategoryFilter.Value.ToString() != "")
{
ddlcategorylist.SelectedValue = hdnCategoryFilter.Value.ToString();
}
}
}
this.GetPageCount();
if (GridViewCultureFlag == false)
{
GridViewCultureFlag = true;
}
totalUnits = 0;
totalAmount = 0;
}
private void bindgrid(DateTime Valuationdate)
{
AdvisorMISBo adviserMISBo = new AdvisorMISBo();
DataSet dsMISReport = null;
double totalAum = 0;
double totalUnits = 0;
decimal TotalAumPercentage = 0;
DateTime Valuation_Date = new DateTime();
int.TryParse(ddlBranch.SelectedValue, out branchId);
int.TryParse(ddlRM.SelectedValue, out rmId);
if (Valuationdate != DateTime.MinValue)
{
Valuation_Date = Valuationdate;
if (userType == "rm")
{
dsMISReport = adviserMISBo.GetAMCwiseMISForRM(rmid, Valuation_Date, hdnAMCSearchVal.Value.ToString());
}
else if (userType == "adviser")
{
dsMISReport = adviserMISBo.GetAMCwiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, hdnAMCSearchVal.Value.ToString());
}
else if (userType == "bm")
{
dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), Valuationdate, 0, 0, 1, hdnAMCSearchVal.Value.ToString(), string.Empty, string.Empty, string.Empty, string.Empty, out count, 0);
}
}
if (dsMISReport == null || dsMISReport.Tables[0].Rows.Count == 0)
{
trMessage.Visible = true;
gvMFMIS.DataSource = dsMISReport;
gvMFMIS.DataBind();
imgBtnExport.Visible = false;
}
else
{
double no_of_units = 0;
double aum = 0;
decimal AumPercentage = 0;
for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++)
{
dsMISReport.Tables[0].Rows[i]["AUM"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["AUM"].ToString());
//dsMISReport.Tables[0].Rows[i]["Percentage"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["Percentage"].ToString()).ToString();
//decimal.Parse(dsMISReport.Tables[0].Rows[i]["Percentage"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
foreach (DataRow dr in dsMISReport.Tables[0].Rows)
{
//no_of_units = Convert.ToDouble(dr["Units"].ToString());
aum = Convert.ToDouble(dr["AUM"].ToString());
AumPercentage = decimal.Parse(dr["Percentage"].ToString());
//totalUnits = totalUnits + no_of_units;
totalAum = totalAum + aum;
TotalAumPercentage = TotalAumPercentage + AumPercentage;
}
DataTable dtMISReport = new DataTable();
dtMISReport.Columns.Add("AMC");
dtMISReport.Columns.Add("AMCCode");
dtMISReport.Columns.Add("AUM");
dtMISReport.Columns.Add("Percentage");
DataRow drMISReport;
for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++)
{
drMISReport = dtMISReport.NewRow();
drMISReport[0] = dsMISReport.Tables[0].Rows[i]["AMC"].ToString();
drMISReport[1] = dsMISReport.Tables[0].Rows[i]["AMCCode"].ToString();
drMISReport[2] = dsMISReport.Tables[0].Rows[i]["AUM"].ToString();
if (GridViewCultureFlag == true)
{
decimal tempAum = decimal.Parse(dsMISReport.Tables[0].Rows[i]["AUM"].ToString());
drMISReport[2] = tempAum.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
else
{
//decimal tempAum = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][2].ToString()), 2);
//drMISReport[2] = tempAum.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
drMISReport[2] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["AUM"].ToString());
}
drMISReport[3] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i]["Percentage"].ToString()), 2).ToString();
dtMISReport.Rows.Add(drMISReport);
}
gvMFMIS.DataSource = dtMISReport;
gvMFMIS.DataBind();
imgBtnExport.Visible = true;
if (GridViewCultureFlag == true)
{
decimal tempTotalAum = System.Math.Round(decimal.Parse(totalAum.ToString()), 2);
gvMFMIS.FooterRow.Cells[2].Text = tempTotalAum.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
gvMFMIS.FooterRow.Cells[3].Text = TotalAumPercentage.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
else
{
decimal tempTotalAum = System.Math.Round(decimal.Parse(totalAum.ToString()), 4);
gvMFMIS.FooterRow.Cells[2].Text = tempTotalAum.ToString();
gvMFMIS.FooterRow.Cells[3].Text = TotalAumPercentage.ToString();
}
}
ViewState["Valuationdate"] = Valuationdate.ToString();
TextBox txtamc = new TextBox();
TextBox txtscheme = new TextBox();
if (gvMFMIS.HeaderRow != null)
{
txtamc = (TextBox)gvMFMIS.HeaderRow.FindControl("txtAMCSearch");
}
txtamc.Text = hdnAMCSearchVal.Value.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
advisorVo = (AdvisorVo)Session["advisorVo"];
rmVo = (RMVo)Session[SessionContents.RmVo];
userVo = (UserVo)Session["userVo"];
AdvisorMISBo adviserMISBo = new AdvisorMISBo();
if (Session[SessionContents.ValuationDate] == null)
{
GetLatestValuationDate();
}
genDict = (Dictionary <string, DateTime>)Session[SessionContents.ValuationDate];
strValuationDate = genDict[Constants.MFDate.ToString()].ToShortDateString();
lblPickDate.Text = DateTime.Parse(genDict[Constants.MFDate.ToString()].ToString()).ToShortDateString();
if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "admin" || Session[SessionContents.CurrentUserRole].ToString().ToLower() == "ops")
{
userType = "advisor";
}
else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "rm")
{
userType = "rm";
}
else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "bm")
{
userType = "bm";
}
else
{
userType = Session[SessionContents.CurrentUserRole].ToString().ToLower();
}
if (userType == "associates")
{
ddlTypes.Items[0].Enabled = false;
ddlTypes.Items[2].Enabled = false;
}
advisorId = advisorVo.advisorId;
int RMId = rmVo.RMId;
rmId = rmVo.RMId;
bmID = rmVo.RMId;
pnlMfReturns.Visible = false;
pnlScheme.Visible = false;
gvMfReturns.Visible = false;
gvMfReturnsScheme.Visible = false;
imgScheme.Visible = false;
imgMFReturns.Visible = false;
if (!IsPostBack)
{
if (Request.QueryString["strCustomreId"] != null)
{
ddlType.SelectedValue = "SchemeWise";
SetParameters();
GetLatestValuationDate();
customerid = int.Parse(Request.QueryString["strCustomreId"].ToString());
BindMFSchemeWise();
gvMfReturnsScheme.Visible = true;
//int accountId = int.Parse(Request.QueryString["folionum"].ToString());
//int SchemePlanCode = int.Parse(Request.QueryString["SchemePlanCode"].ToString());
//PasssedFolioValue = accountId;
//BindLastTradeDate();
//string fromdate = "01-01-1990";
//txtFromDate.SelectedDate = DateTime.Parse(fromdate);
//ViewState["SchemePlanCode"] = SchemePlanCode;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
associateuserheirarchyVo = (AssociatesUserHeirarchyVo)Session[SessionContents.AssociatesLogin_AssociatesHierarchy];
advisorVo = (AdvisorVo)Session["advisorVo"];
rmVo = (RMVo)Session[SessionContents.RmVo];
userVo = (UserVo)Session["userVo"];
associatesVo = (AssociatesVO)Session["associatesVo"];
AdvisorMISBo adviserMISBo = new AdvisorMISBo();
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "admin" || Session[SessionContents.CurrentUserRole].ToString().ToLower() == "ops")
{
userType = "advisor";
}
else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "rm")
{
userType = "rm";
}
else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "bm")
{
userType = "bm";
}
else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "associates")
{
userType = "associates";
}
else
{
userType = Session[SessionContents.CurrentUserRole].ToString().ToLower();
}
advisorId = advisorVo.advisorId;
int RMId = rmVo.RMId;
rmId = rmVo.RMId;
bmID = rmVo.RMId;
//if (userType == "associates")
//{
// SetParameters();
// BindMfDashBoard();
//}
if (!IsPostBack)
{
if (userType == "advisor" || userType == "rm")
{
BindBranchDropDown();
BindRMDropDown();
if (userType == "rm")
{
ddlType.Visible = false;
lblType.Visible = false;
ddlBranch.Enabled = false;
ddlRM.SelectedValue = rmVo.RMId.ToString();
ddlRM.Enabled = false;
}
if (Session["NodeType"] != null)
{
if (Session["NodeType"] == "MFDashBoard")
{
SetParameters();
BindMfDashBoard();
UpnlMFDashBoard.Visible = true;
}
}
}
else if (userType == "rm")
{
//BindBranchDropDown();
//BindRMDropDown();
//if (userType == "rm")
//{
// ddlBranch.Enabled = false;
// ddlRM.SelectedValue = rmVo.RMId.ToString();
// ddlRM.Enabled = false;
//}
}
if (userType == "bm")
{
//trBranchRM.Visible = true;
BindBranchForBMDropDown();
BindRMforBranchDropdown(0, bmID);
//BindMfDashBoard();
}
else if (userType == "associates")
{
SetParameters();
BindMfDashBoard();
BindBranchDropDown();
BindRMDropDown();
gvBranch.Visible = true;
Label1.Visible = true;
lnkBranchNavi.Visible = true;
UpnlMFDashBoard.Visible = true;
trBranchRM.Visible = false;
btnGo.Visible = false;
ddlType.Visible = false;
lblType.Visible = false;
}
}
// BindMfDashBoard();
}
protected void Page_Load(object sender, EventArgs e)
{
advisorVo = (AdvisorVo)Session["advisorVo"];
rmVo = (RMVo)Session[SessionContents.RmVo];
userVo = (UserVo)Session["userVo"];
AdvisorMISBo adviserMFMIS = new AdvisorMISBo();
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "admin" || Session[SessionContents.CurrentUserRole].ToString().ToLower() == "ops")
{
userType = "advisor";
}
else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "rm")
{
userType = "rm";
}
else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "bm")
{
userType = "bm";
}
else
{
userType = Session[SessionContents.CurrentUserRole].ToString().ToLower();
}
advisorId = advisorVo.advisorId;
int RMId = rmVo.RMId;
rmId = rmVo.RMId;
bmID = rmVo.RMId;
imgOrgGridExport.Visible = false;
imgProductGridExport.Visible = false;
pnlEQTurnover.Visible = false;
pnlOrgLevel.Visible = false;
gvEQTurnover.Visible = false;
gvOrgLevel.Visible = false;
if (!IsPostBack)
{
trEQProductLevel.Visible = false;
trOrgLevel.Visible = false;
rbtnPickDate.Checked = true;
rbtnPickPeriod.Checked = false;
divDateRange.Visible = true;
divDatePeriod.Visible = false;
if (userType == "advisor")
{
BindBranchDropDown();
BindRMDropDown();
}
else if (userType == "rm")
{
trBranchRmDpRow.Visible = false;
}
if (userType == "bm")
{
BindBranchForBMDropDown();
BindRMforBranchDropdown(0, bmID);
}
LatestValuationdate = adviserMFMIS.GetLatestValuationDateFromHistory(advisorId, "EQ");
txtFromDate.SelectedDate = DateTime.Parse(LatestValuationdate.ToShortDateString());
txtToDate.SelectedDate = DateTime.Parse(LatestValuationdate.ToShortDateString());
}
}
//private void BindGrid(DateTime dtFrom, DateTime dtTo)
//{
// DataSet dsEQMIS = new DataSet();
// DataTable dtAdviserEQMIS = new DataTable();
// int ID = 0;
// if (userType == "advisor")
// ID = advisorVo.advisorId;
// else if (userType == "rm")
// {
// rmVo = (RMVo)Session[SessionContents.RmVo];
// ID = rmVo.RMId;
// }
// else if (userType == "bm")
// {
// rmVo = (RMVo)Session[SessionContents.RmVo];
// ID = rmVo.RMId;
// if (userType == "bm")
// {
// if (hdnall.Value == "0")
// {
// hdnbranchId.Value = ddlBranchForEQ.SelectedValue;
// hdnrmId.Value = ddlRMEQ.SelectedValue;
// dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), 0, 0);
// }
// else if (hdnall.Value == "1")
// {
// hdnbranchId.Value = ddlBranchForEQ.SelectedValue;
// dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, int.Parse(hdnbranchId.Value.ToString()), 0, 1);
// }
// else if (hdnall.Value == "2")
// {
// hdnbranchHeadId.Value = ddlBranchForEQ.SelectedValue;
// dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, 0, int.Parse(hdnbranchHeadId.Value.ToString()), 2);
// }
// else if (hdnall.Value == "3")
// {
// hdnbranchHeadId.Value = ddlBranchForEQ.SelectedValue;
// hdnrmId.Value = ddlRMEQ.SelectedValue;
// dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, int.Parse(hdnrmId.Value.ToString()), 0, int.Parse(hdnbranchHeadId.Value.ToString()), 3);
// }
// //dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo,0, 0, 0, 0);
// }
// }
// try
// {
// if (userType == "advisor")
// {
// if (hdnall.Value == "0")
// {
// dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, 0, int.Parse(hdnbranchHeadId.Value.ToString()), 0);
// }
// else if (hdnall.Value == "1")
// {
// dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, int.Parse(hdnbranchId.Value.ToString()), 0, 1);
// }
// else if (hdnall.Value == "2")
// {
// dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, int.Parse(hdnrmId.Value.ToString()), 0, int.Parse(hdnbranchHeadId.Value.ToString()), 2);
// }
// else if (hdnall.Value == "3")
// {
// dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), 0, 3);
// }
// }
// if (userType == "rm")
// {
// dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, 0, 0, 0);
// }
// if (dsEQMIS.Tables[0].Rows.Count > 0)
// {
// DataRow drAdvEQMIS;
// drAdvEQMIS = dtAdviserEQMIS.NewRow();
// dtAdviserEQMIS.Columns.Add("CName_Industry_Delby");
// dtAdviserEQMIS.Columns.Add("Industry_MValue_DelSell");
// dtAdviserEQMIS.Columns.Add("MValue_Percentage_SpecSell");
// dtAdviserEQMIS.Columns.Add("MValue_Blank_SpecBuy");
// int flag = 0;
// for (int i = 0; i < dsEQMIS.Tables[0].Rows.Count; i++)
// {
// NumberFormatInfo nfi0 = new CultureInfo("en-US", false).NumberFormat;
// NumberFormatInfo nfi1 = new CultureInfo("en-US", false).NumberFormat;
// NumberFormatInfo nfi2 = new CultureInfo("en-US", false).NumberFormat;
// NumberFormatInfo nfi3 = new CultureInfo("en-US", false).NumberFormat;
// nfi0.NumberDecimalSeparator = String.Format("{0:n2}", decimal.Parse(dsEQMIS.Tables[0].Rows[i]["DeliveryBuy"].ToString()).ToString("N", nfi0));
// nfi1.NumberDecimalSeparator = String.Format("{0:n2}", decimal.Parse(dsEQMIS.Tables[0].Rows[i]["DeliverySell"].ToString()).ToString("N", nfi1));
// nfi2.NumberDecimalSeparator = String.Format("{0:n2}", decimal.Parse(dsEQMIS.Tables[0].Rows[i]["SpeculativeSell"].ToString()).ToString("N", nfi2));
// nfi3.NumberDecimalSeparator = String.Format("{0:n2}", decimal.Parse(dsEQMIS.Tables[0].Rows[i]["SpeculativeBuy"].ToString()).ToString("N", nfi3));
// drAdvEQMIS[0] = nfi0.NumberDecimalSeparator;
// drAdvEQMIS[1] = nfi1.NumberDecimalSeparator;
// drAdvEQMIS[2] = nfi2.NumberDecimalSeparator;
// drAdvEQMIS[3] = nfi3.NumberDecimalSeparator;
// dtAdviserEQMIS.Rows.Add(drAdvEQMIS);
// }
// if ((decimal.Parse(dsEQMIS.Tables[0].Rows[0]["DeliveryBuy"].ToString()) != 0) || (decimal.Parse(dsEQMIS.Tables[0].Rows[0]["DeliverySell"].ToString()) != 0) ||
// (decimal.Parse(dsEQMIS.Tables[0].Rows[0]["SpeculativeSell"].ToString()) != 0) || (decimal.Parse(dsEQMIS.Tables[0].Rows[0]["SpeculativeBuy"].ToString()) != 0))
// {
// flag = 1;
// }
// if (flag == 0)
// {
// gvEQMIS.Visible = false;
// ErrorMessage.Visible = true;
// }
// else
// {
// gvEQMIS.Visible = true;
// ErrorMessage.Visible = false;
// gvEQMIS.DataSource = dtAdviserEQMIS;
// gvEQMIS.DataBind();
// gvEQMIS.Columns[0].ItemStyle.HorizontalAlign = HorizontalAlign.Right;
// gvEQMIS.Columns[1].ItemStyle.HorizontalAlign = HorizontalAlign.Right;
// //Assigning Text To Header template
// Label Hlb1 = (Label)gvEQMIS.HeaderRow.FindControl("lblCustIndDelby");
// Hlb1.Text = "Delivery Buy Value";
// Label Hlb2 = (Label)gvEQMIS.HeaderRow.FindControl("lblIndMValueDelSell");
// Hlb2.Text = "Delivery Sell Value";
// Label Hlb3 = (Label)gvEQMIS.HeaderRow.FindControl("lblMValuePerCSpecSell");
// Hlb3.Text = "Speculative Sell Value";
// Label Hlb4 = (Label)gvEQMIS.HeaderRow.FindControl("lblMvalueBlankSpecbuy");
// Hlb4.Text = "Speculative Buy Value";
// Label TotalText = (Label)gvEQMIS.FooterRow.FindControl("lblTotalText");
// TotalText.Text = string.Empty;
// Label TotalMText = (Label)gvEQMIS.FooterRow.FindControl("lblSectorWiseTotalText");
// TotalMText.Text = string.Empty;
// Label TotalMarketValue = (Label)gvEQMIS.FooterRow.FindControl("lblFooterItemMValue");
// TotalMarketValue.Text = string.Empty;
// Label TotalValue = (Label)gvEQMIS.FooterRow.FindControl("lblFooterItemMValue");
// TotalValue.Text = string.Empty;
// }
// }
// }
// catch (BaseApplicationException Ex)
// {
// throw Ex;
// }
// catch (Exception Ex)
// {
// BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
// NameValueCollection FunctionInfo = new NameValueCollection();
// FunctionInfo.Add("Method", "AdviserEQMIS.ascx.cs:BindGrid()");
// object[] objects = new object[2];
// objects[0] = dtFrom;
// objects[1] = dtTo;
// FunctionInfo = exBase.AddObject(FunctionInfo, objects);
// exBase.AdditionalInformation = FunctionInfo;
// ExceptionManager.Publish(exBase);
// throw exBase;
// }
//}
private void BindEQMISgrid(DateTime Valuationdate)
{
AdvisorMISBo adviserMISBo = new AdvisorMISBo();
DataSet dsCompSecEQMIS = new DataSet();
DataTable dtCompSecEQMIS = new DataTable();
int adviserId = 0;
int rmId = 0;
int TotalShares = 0;
adviserId = advisorVo.advisorId;
rmVo = (RMVo)Session[SessionContents.RmVo];
rmId = rmVo.RMId;
hdnPortfolioType.Value = ddlPortfolioGroup.SelectedValue;
hdnbranchHeadId.Value = ddlBranchForEQ.SelectedValue;
hdnbranchId.Value = ddlBranchForEQ.SelectedValue;
hdnrmId.Value = ddlRMEQ.SelectedValue;
hdnEQMISType.Value = ddlMISType.SelectedValue;
if (ddlMISType.SelectedValue == "SectorWise")
{
hdnEQMISType.Value = "1";
}
else if (ddlMISType.SelectedValue == "CompanyWise")
{
hdnEQMISType.Value = "0";
}
DateTime Valuation_Date = Convert.ToDateTime(hdnValuationDate.Value.ToString());
if (userType == "rm")
{
dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, rmId, 0, 0, 0, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString()));
}
if (userType == "advisor")
{
if (hdnall.Value == "0")
{
dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, 0, 0, int.Parse(hdnbranchHeadId.Value.ToString()), 0, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString()));
}
else if (hdnall.Value == "1")
{
dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, 0, int.Parse(hdnbranchId.Value.ToString()), 0, 1, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString()));
}
else if (hdnall.Value == "2")
{
dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, int.Parse(hdnrmId.Value.ToString()), 0, int.Parse(hdnbranchHeadId.Value.ToString()), 2, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString()));
}
else if (hdnall.Value == "3")
{
dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), 0, 3, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString()));
}
}
if (userType == "bm")
{
if (hdnall.Value == "0")
{
dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, 0, 0, int.Parse(hdnbranchHeadId.Value.ToString()), 0, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString()));
}
else if (hdnall.Value == "1")
{
dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, 0, int.Parse(hdnbranchId.Value.ToString()), 0, 1, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString()));
}
else if (hdnall.Value == "2")
{
dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, int.Parse(hdnrmId.Value.ToString()), 0, int.Parse(hdnbranchHeadId.Value.ToString()), 2, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString()));
}
else if (hdnall.Value == "3")
{
dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), 0, 3, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString()));
}
}
if (dsCompSecEQMIS.Tables[0].Rows.Count == 0)
{
gvEQMIS.DataSource = dsCompSecEQMIS;
gvEQMIS.DataBind();
imgEQAllocatio.Visible = false;
}
else
{
dtCompSecEQMIS.Columns.Add("Company");
dtCompSecEQMIS.Columns.Add("Industry");
dtCompSecEQMIS.Columns.Add("NoOfShare", typeof(Decimal));
dtCompSecEQMIS.Columns.Add("MarketValue", typeof(Decimal));
dtCompSecEQMIS.Columns.Add("NetAssets", typeof(Decimal));
DataRow drAdvEQMIS;
for (int i = 0; i < dsCompSecEQMIS.Tables[0].Rows.Count; i++)
{
drAdvEQMIS = dtCompSecEQMIS.NewRow();
if (hdnEQMISType.Value == "0")
{
drAdvEQMIS["Company"] = dsCompSecEQMIS.Tables[0].Rows[i]["CompanyName"].ToString();
}
else
{
drAdvEQMIS["Company"] = string.Empty;
}
drAdvEQMIS["Industry"] = dsCompSecEQMIS.Tables[0].Rows[i]["Industry"].ToString();
drAdvEQMIS["NoOfShare"] = dsCompSecEQMIS.Tables[0].Rows[i]["NoOfShare"].ToString();
drAdvEQMIS["MarketValue"] = dsCompSecEQMIS.Tables[0].Rows[i]["MarketValue"].ToString();
drAdvEQMIS["NetAssets"] = dsCompSecEQMIS.Tables[0].Rows[i]["NetAssetsPercentage"].ToString();
dtCompSecEQMIS.Rows.Add(drAdvEQMIS);
}
GridBoundColumn ghItem = gvEQMIS.MasterTableView.Columns.FindByUniqueName("Company") as GridBoundColumn;
if (ddlMISType.SelectedValue == "CompanyWise")
{
ghItem.Visible = true;
}
else if (ddlMISType.SelectedValue == "SectorWise")
{
ghItem.Visible = false;
}
gvEQMIS.DataSource = dtCompSecEQMIS;
gvEQMIS.DataBind();
gvEQMIS.Visible = true;
imgEQAllocatio.Visible = true;
if (Cache["gvEQMIS" + userVo.UserId + userType] == null)
{
Cache.Insert("gvEQMIS" + userVo.UserId + userType, dtCompSecEQMIS);
}
else
{
Cache.Remove("gvEQMIS" + userVo.UserId + userType);
Cache.Insert("gvEQMIS" + userVo.UserId + userType, dtCompSecEQMIS);
}
//Assigning Text To Header template
}
}
