private void btnStats_Click(object sender, EventArgs e)
{
new ViewCollateralsForm(int.Parse(gridDaily.Rows[gridDaily.SelectedCells[0].RowIndex].Cells["LoanID"].Value.ToString())).Show();
return;
var data = (SortableBindingList<DailyPayment>)gridDaily.DataSource;
var resData = new List<DailyStats>();
resData.Add(
new DailyStats()
{
Name = "NextScheduledPaymentInGel",
Sum = data.Sum(x => x.NextScheduledPaymentInGel),
Average = Math.Round(data.Average(x => x.NextScheduledPaymentInGel), 2),
Maximum = data.Max(x => x.NextScheduledPaymentInGel),
Minimum = data.Min(x => x.NextScheduledPaymentInGel)
});
resData.Add(
new DailyStats()
{
Name = "CurrentDebtInGel",
Sum = data.Sum(x => x.CurrentDebtInGel),
Average = Math.Round(data.Average(x => x.CurrentDebtInGel), 2),
Maximum = data.Max(x => x.CurrentDebtInGel),
Minimum = data.Min(x => x.CurrentDebtInGel)
});
resData.Add(
new DailyStats()
{
Name = "TotalDebtInGel",
Sum = data.Sum(x => x.TotalDebtInGel),
Average = Math.Round(data.Average(x => x.TotalDebtInGel), 2),
Maximum = data.Max(x => x.TotalDebtInGel),
Minimum = data.Min(x => x.TotalDebtInGel)
});
resData.Add(
new DailyStats()
{
Name = "Payment",
Sum = data.Sum(x => x.Payment),
Average = Math.Round(data.Average(x => x.Payment), 2),
Maximum = data.Max(x => x.Payment),
Minimum = data.Min(x => x.Payment)
});
resData.Add(
new DailyStats()
{
Name = "CourtAndEnforcementFee",
Sum = data.Sum(x => x.CourtAndEnforcementFee),
Average = Math.Round(data.Average(x => x.CourtAndEnforcementFee), 2),
Maximum = data.Max(x => x.CourtAndEnforcementFee),
Minimum = data.Min(x => x.CourtAndEnforcementFee)
});
resData.Add(
new DailyStats()
{
Name = "InterestPenaltyInGel",
Sum = data.Sum(x => x.InterestPenaltyInGel),
Average = Math.Round(data.Average(x => x.InterestPenaltyInGel), 2),
Maximum = data.Max(x => x.InterestPenaltyInGel),
Minimum = data.Min(x => x.InterestPenaltyInGel)
});
resData.Add(
new DailyStats()
{
Name = "PrincipalPenaltyInGel",
Sum = data.Sum(x => x.PrincipalPenaltyInGel),
Average = Math.Round(data.Average(x => x.PrincipalPenaltyInGel), 2),
Maximum = data.Max(x => x.PrincipalPenaltyInGel),
Minimum = data.Min(x => x.PrincipalPenaltyInGel)
});
resData.Add(
new DailyStats()
{
Name = "OverdueInterestInGel",
Sum = data.Sum(x => x.OverdueInterestInGel),
Average = Math.Round(data.Average(x => x.OverdueInterestInGel), 2),
Maximum = data.Max(x => x.OverdueInterestInGel),
Minimum = data.Min(x => x.OverdueInterestInGel)
});
resData.Add(
new DailyStats()
{
Name = "AccruedInterestInGel",
Sum = data.Sum(x => x.AccruedInterestInGel),
Average = Math.Round(data.Average(x => x.AccruedInterestInGel), 2),
Maximum = data.Max(x => x.AccruedInterestInGel),
Minimum = data.Min(x => x.AccruedInterestInGel)
});
resData.Add(
new DailyStats()
{
Name = "OverduePrincipalInGel",
Sum = data.Sum(x => x.OverduePrincipalInGel),
Average = Math.Round(data.Average(x => x.OverduePrincipalInGel), 2),
Maximum = data.Max(x => x.OverduePrincipalInGel),
Minimum = data.Min(x => x.OverduePrincipalInGel)
});
resData.Add(
new DailyStats()
{
Name = "CurrentPrincipalInGel",
Sum = data.Sum(x => x.CurrentPrincipalInGel),
Average = Math.Round(data.Average(x => x.CurrentPrincipalInGel), 2),
Maximum = data.Max(x => x.CurrentPrincipalInGel),
Minimum = data.Min(x => x.CurrentPrincipalInGel)
});
resData.Add(
new DailyStats()
{
Name = "PrincipalInGel",
Sum = data.Sum(x => x.PrincipalInGel),
Average = Math.Round(data.Average(x => x.PrincipalInGel), 2),
Maximum = data.Max(x => x.PrincipalInGel),
Minimum = data.Min(x => x.PrincipalInGel)
});
resData.Add(
new DailyStats()
{
Name = "LoanAmountInGel",
Sum = data.Sum(x => x.LoanAmountInGel),
Average = Math.Round(data.Average(x => x.LoanAmountInGel), 2),
Maximum = data.Max(x => x.LoanAmountInGel),
Minimum = data.Min(x => x.LoanAmountInGel)
});
var frmStats = new StatsForm(resData);
frmStats.Show();
}
private void pbxStats_Click(object sender, EventArgs e)
{
var data = (SortableBindingList<DailyPayment>)gridData.DataSource;
var resData = new List<DailyStats>();
resData.Add(
new DailyStats()
{
Name = "NextScheduledPaymentInGel",
Sum = data.Sum(x => x.NextScheduledPaymentInGel),
Average = Math.Round(data.Average(x => x.NextScheduledPaymentInGel), 2),
Maximum = data.Max(x => x.NextScheduledPaymentInGel),
Minimum = data.Min(x => x.NextScheduledPaymentInGel)
});
resData.Add(
new DailyStats()
{
Name = "CurrentDebtInGel",
Sum = data.Sum(x => x.CurrentDebtInGel),
Average = Math.Round(data.Average(x => x.CurrentDebtInGel), 2),
Maximum = data.Max(x => x.CurrentDebtInGel),
Minimum = data.Min(x => x.CurrentDebtInGel)
});
resData.Add(
new DailyStats()
{
Name = "TotalDebtInGel",
Sum = data.Sum(x => x.TotalDebtInGel),
Average = Math.Round(data.Average(x => x.TotalDebtInGel), 2),
Maximum = data.Max(x => x.TotalDebtInGel),
Minimum = data.Min(x => x.TotalDebtInGel)
});
resData.Add(
new DailyStats()
{
Name = "Payment",
Sum = data.Sum(x => x.Payment),
Average = Math.Round(data.Average(x => x.Payment), 2),
Maximum = data.Max(x => x.Payment),
Minimum = data.Min(x => x.Payment)
});
resData.Add(
new DailyStats()
{
Name = "CourtAndEnforcementFee",
Sum = data.Sum(x => x.CourtAndEnforcementFee),
Average = Math.Round(data.Average(x => x.CourtAndEnforcementFee), 2),
Maximum = data.Max(x => x.CourtAndEnforcementFee),
Minimum = data.Min(x => x.CourtAndEnforcementFee)
});
resData.Add(
new DailyStats()
{
Name = "InterestPenaltyInGel",
Sum = data.Sum(x => x.InterestPenaltyInGel),
Average = Math.Round(data.Average(x => x.InterestPenaltyInGel), 2),
Maximum = data.Max(x => x.InterestPenaltyInGel),
Minimum = data.Min(x => x.InterestPenaltyInGel)
});
resData.Add(
new DailyStats()
{
Name = "PrincipalPenaltyInGel",
Sum = data.Sum(x => x.PrincipalPenaltyInGel),
Average = Math.Round(data.Average(x => x.PrincipalPenaltyInGel), 2),
Maximum = data.Max(x => x.PrincipalPenaltyInGel),
Minimum = data.Min(x => x.PrincipalPenaltyInGel)
});
resData.Add(
new DailyStats()
{
Name = "OverdueInterestInGel",
Sum = data.Sum(x => x.OverdueInterestInGel),
Average = Math.Round(data.Average(x => x.OverdueInterestInGel), 2),
Maximum = data.Max(x => x.OverdueInterestInGel),
Minimum = data.Min(x => x.OverdueInterestInGel)
});
resData.Add(
new DailyStats()
{
Name = "AccruedInterestInGel",
Sum = data.Sum(x => x.AccruedInterestInGel),
Average = Math.Round(data.Average(x => x.AccruedInterestInGel), 2),
Maximum = data.Max(x => x.AccruedInterestInGel),
Minimum = data.Min(x => x.AccruedInterestInGel)
});
resData.Add(
new DailyStats()
{
Name = "OverduePrincipalInGel",
Sum = data.Sum(x => x.OverduePrincipalInGel),
Average = Math.Round(data.Average(x => x.OverduePrincipalInGel), 2),
Maximum = data.Max(x => x.OverduePrincipalInGel),
Minimum = data.Min(x => x.OverduePrincipalInGel)
});
resData.Add(
new DailyStats()
{
Name = "CurrentPrincipalInGel",
Sum = data.Sum(x => x.CurrentPrincipalInGel),
Average = Math.Round(data.Average(x => x.CurrentPrincipalInGel), 2),
Maximum = data.Max(x => x.CurrentPrincipalInGel),
Minimum = data.Min(x => x.CurrentPrincipalInGel)
});
resData.Add(
new DailyStats()
{
Name = "PrincipalInGel",
Sum = data.Sum(x => x.PrincipalInGel),
Average = Math.Round(data.Average(x => x.PrincipalInGel), 2),
Maximum = data.Max(x => x.PrincipalInGel),
Minimum = data.Min(x => x.PrincipalInGel)
});
resData.Add(
new DailyStats()
{
Name = "LoanAmountInGel",
Sum = data.Sum(x => x.LoanAmountInGel),
Average = Math.Round(data.Average(x => x.LoanAmountInGel), 2),
Maximum = data.Max(x => x.LoanAmountInGel),
Minimum = data.Min(x => x.LoanAmountInGel)
});
var frmStats = new StatsForm(resData);
frmStats.Show();
}