private void LoadDgvFees()
{
DataTable dataTable = new DataTable();
/// Set the datatable based on the SelectedIndex of <see cref="cboInvestmentViews"/>.
switch (cboFeeViews.SelectedIndex)
{
case 0:
dataTable = PlanAdvisorFee.GetAssociatedActive(CurrentPlanAdvisor);
break;
case 1:
dataTable = PlanAdvisorFee.GetAssociatedActive(CurrentPlanAdvisor);
break;
default:
return;
}
dgvFees.DataSource = dataTable;
// Display/order the columns.
dgvFees.Columns["PlanAdvisorFeeId"].Visible = false;
dgvFees.Columns["PlanId"].Visible = false;
dgvFees.Columns["AdvisorId"].Visible = false;
dgvFees.Columns["CreatedBy"].Visible = false;
dgvFees.Columns["ModifiedBy"].Visible = false;
dgvFees.Columns["StateCode"].Visible = false;
dgvFees.Columns["Fee"].DisplayIndex = 0;
dgvFees.Columns["BenchmarkFee"].DisplayIndex = 1;
dgvFees.Columns["AsOfDate"].DisplayIndex = 2;
dgvFees.Columns["ModifiedOn"].DisplayIndex = 3;
}
private void dgvFees_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
int index = dgvFees.CurrentRow.Index;
Guid planAdvFeeId = new Guid(dgvFees.Rows[index].Cells["PlanAdvisorFeeId"].Value.ToString());
PlanAdvisorFee planAdvFee = new PlanAdvisorFee(planAdvFeeId);
frmPlanAdvisorFee frmPlanAdvisorFee = new frmPlanAdvisorFee(frmMain_Parent, planAdvFee);
frmPlanAdvisorFee.FormClosed += frmPlanAdvisorFee_FormClosed;
}
private void btnDeleteFee_Click(object sender, EventArgs e)
{
int index = dgvFees.CurrentRow.Index;
Guid planAdvFeeId = new Guid(dgvFees.Rows[index].Cells["PlanAdvisorFeeId"].Value.ToString());
PlanAdvisorFee planAdvFee = new PlanAdvisorFee(planAdvFeeId);
DialogResult result = MessageBox.Show("Are you sure you wish to delete the selected plan advisor fee?", "Attention", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
planAdvFee.DeleteRecordFromDatabase();
LoadDgvFees();
}
}
/// <summary>
///
/// </summary>
/// <param name="mf"></param>
/// <param name="planAdvisor"></param>
/// <param name="Close"></param>
public frmPlanAdvisorFee(frmMain mf, VSP.Business.Entities.PlanAdvisor planAdvisor, FormClosedEventHandler Close = null)
{
frmSplashScreen ss = new frmSplashScreen();
ss.Show();
Application.DoEvents();
InitializeComponent();
frmMain_Parent = mf;
this.MaximumSize = Screen.PrimaryScreen.WorkingArea.Size;
Application.AddMessageFilter(this);
controlsToMove.Add(this.pnlSummaryTabHeader);
controlsToMove.Add(this.panel16);
controlsToMove.Add(this.label1);
controlsToMove.Add(this.label23);
FormClosed += Close;
Plan plan = new Plan(planAdvisor.PlanId);
Advisor advisor = new Advisor(planAdvisor.AdvisorId);
DataIntegrationHub.Business.Entities.PlanAdvisor plAd = new DataIntegrationHub.Business.Entities.PlanAdvisor(planAdvisor.AdvisorId);
txtAdvisor.Text = plAd.Name;
CurrentPlanAdvisorFee = new PlanAdvisorFee();
CurrentPlanAdvisorFee.PlanAdvisorId = planAdvisor.Id;
txtPlan.Text = plan.Name;
CurrentTabLabel = label46; // Summary tab label
highlightSelectedTabLabel(CurrentTabLabel);
ss.Close();
this.Show();
}
/// <summary>
///
/// </summary>
/// <param name="mf"></param>
/// <param name="planAdvisorFee"></param>
/// <param name="Close"></param>
public frmPlanAdvisorFee(frmMain mf, PlanAdvisorFee planAdvisorFee, FormClosedEventHandler Close = null)
{
frmSplashScreen ss = new frmSplashScreen();
ss.Show();
Application.DoEvents();
InitializeComponent();
frmMain_Parent = mf;
this.MaximumSize = Screen.PrimaryScreen.WorkingArea.Size;
Application.AddMessageFilter(this);
controlsToMove.Add(this.pnlSummaryTabHeader);
controlsToMove.Add(this.panel16);
controlsToMove.Add(this.label1);
controlsToMove.Add(this.label23);
FormClosed += Close;
Business.Entities.PlanAdvisor planAdvisor = new Business.Entities.PlanAdvisor(planAdvisorFee.PlanAdvisorId);
Plan plan = new Plan(planAdvisor.PlanId);
Advisor advisor = new Advisor(planAdvisor.AdvisorId);
DataIntegrationHub.Business.Entities.PlanAdvisor dihPlanAdvisor = new DataIntegrationHub.Business.Entities.PlanAdvisor(advisor.Id);
CurrentPlanAdvisorFee = planAdvisorFee;
txtPlan.Text = plan.Name;
txtAdvisor.Text = dihPlanAdvisor.Name;
txtNotes.Text = CurrentPlanAdvisorFee.Notes;
txtName.Text = CurrentPlanAdvisorFee.Name;
txtNotes.Focus();
if (CurrentPlanAdvisorFee.Fee != null)
{
txtFee.Text = ((decimal)CurrentPlanAdvisorFee.Fee).ToString("#,##");
}
if (CurrentPlanAdvisorFee.Benchmark25Fee != null)
{
txtBenchmark25Fee.Text = ((decimal)CurrentPlanAdvisorFee.Benchmark25Fee).ToString("#,##");
}
if (CurrentPlanAdvisorFee.Benchmark50Fee != null)
{
txtBenchmark50Fee.Text = ((decimal)CurrentPlanAdvisorFee.Benchmark50Fee).ToString("#,##");
}
if (CurrentPlanAdvisorFee.Benchmark75Fee != null)
{
txtBenchmark75Fee.Text = ((decimal)CurrentPlanAdvisorFee.Benchmark75Fee).ToString("#,##");
}
if (CurrentPlanAdvisorFee.AsOfDate != null)
{
dateAsOfDate.Value = (DateTime)CurrentPlanAdvisorFee.AsOfDate;
dateAsOfDate.Checked = true;
}
else
{
dateAsOfDate.Checked = false;
}
chbxRevenueSharingPaid.Checked = CurrentPlanAdvisorFee.RevenueSharingPaid;
chbxForfeituresPaid.Checked = CurrentPlanAdvisorFee.ForfeituresPaid;
chbxParticipantsPaid.Checked = CurrentPlanAdvisorFee.ParticipantsPaid;
chbxPlanSponsorPaid.Checked = CurrentPlanAdvisorFee.PlanSponsorPaid;
CurrentTabLabel = label46; // Summary tab label
highlightSelectedTabLabel(CurrentTabLabel);
ss.Close();
this.Show();
}
private void LoadDgvFees()
{
int currentCellRow = 0;
int currentCellCol = 0;
if (dgvFees.CurrentCell != null)
{
currentCellRow = dgvFees.CurrentCell.RowIndex;
currentCellCol = dgvFees.CurrentCell.ColumnIndex;
}
DataTable dataTable = new DataTable();
/// Set the datatable based on the SelectedIndex of <see cref="cboInvestmentViews"/>.
switch (cboFeeViews.SelectedIndex)
{
case 0:
dataTable = PlanAdvisorFee.GetAssociatedActive(CurrentPlanAdvisor);
break;
case 1:
dataTable = PlanAdvisorFee.GetAssociatedActive(CurrentPlanAdvisor);
break;
default:
return;
}
dgvFees.DataSource = dataTable;
// Display/order the columns.
dgvFees.Columns["PlanAdvisorFeeId"].Visible = false;
dgvFees.Columns["PlanAdvisorId"].Visible = false;
dgvFees.Columns["CreatedBy"].Visible = false;
dgvFees.Columns["ModifiedBy"].Visible = false;
dgvFees.Columns["StateCode"].Visible = false;
// Display/order the columns.
dgvFees.Columns["Notes"].Visible = false;
dgvFees.Columns["Name"].DisplayIndex = 0;
dgvFees.Columns["Fee"].DisplayIndex = 1;
dgvFees.Columns["Benchmark25Fee"].DisplayIndex = 2;
dgvFees.Columns["Benchmark25Fee"].HeaderText = "25% Benchmark";
dgvFees.Columns["Benchmark50Fee"].DisplayIndex = 3;
dgvFees.Columns["Benchmark50Fee"].HeaderText = "50% Benchmark";
dgvFees.Columns["Benchmark75Fee"].DisplayIndex = 4;
dgvFees.Columns["Benchmark75Fee"].HeaderText = "75% Benchmark";
dgvFees.Columns["RevenueSharingPaid"].DisplayIndex = 5;
dgvFees.Columns["RevenueSharingPaid"].HeaderText = "Revenue Sharing Paid";
dgvFees.Columns["ForfeituresPaid"].DisplayIndex = 6;
dgvFees.Columns["ForfeituresPaid"].HeaderText = "Forfeitures Paid";
dgvFees.Columns["ParticipantsPaid"].DisplayIndex = 7;
dgvFees.Columns["ParticipantsPaid"].HeaderText = "Participants Paid";
dgvFees.Columns["PlanSponsorPaid"].DisplayIndex = 8;
dgvFees.Columns["PlanSponsorPaid"].HeaderText = "Plan Sponsor Paid";
dgvFees.Columns["AsOfDate"].DisplayIndex = 9;
dgvFees.Columns["ModifiedOn"].DisplayIndex = 10;
dgvFees.Columns["CreatedOn"].DisplayIndex = 11;
if (dgvFees.RowCount > 0 && dgvFees.ColumnCount > 0)
{
DataGridViewCell selectedCell = dgvFees.Rows[currentCellRow].Cells[currentCellCol];
if (selectedCell != null && selectedCell.Visible)
{
dgvFees.CurrentCell = selectedCell;
}
else
{
dgvFees.CurrentCell = dgvFees.FirstDisplayedCell;
}
}
}
