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