private void LoadPopupControl() { int assessmentNo = int.Parse(ASPxTextAssessmentNo.Text); var incomedata = from income in _context.IAssessmentIncomes.Where(a => a.AssessmentId == assessmentNo && a.Amount > 0) select new { income.TaxIncome.IncomeDescription, income.Amount }; ASPxgvIncome.DataSource = incomedata.ToList(); ASPxgvIncome.DataBind(); var exemptdata = from exempt in _context.IAssessmentExclusions.Where(a => a.AssessmentId == assessmentNo && a.Amount > 0) select new { exempt.TaxExclusion.ExclusionName, exempt.Amount }; ASPxgvExempt.DataSource = exemptdata.ToList(); ASPxgvExempt.DataBind(); int year = int.Parse(ASPxComboBoxAssessmentYear.SelectedItem.Value.ToString()); decimal?AccessableIncome = _context.IAssessments.Single(n => n.AssessmentId == assessmentNo).AssessableIncome; ASPxLabelAssesableIncome.Text = String.Format("Assesable Income (a-b): {0:#,##0.00}", AccessableIncome); var data = _context.PITComputationDetails(AccessableIncome, year); ASPxgvTaxDetails.DataSource = data; ASPxgvTaxDetails.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { year = int.Parse(Request.QueryString["Year"]); AccessibleIncome = decimal.Parse(Request.QueryString["Income"]); var data = context.PITComputationDetails(AccessibleIncome, year); ASPxgvTaxDetails.DataSource = data; ASPxgvTaxDetails.DataBind(); }