private bool UploadIncomeDetails(IncomeTaxDetailModel incomeModel) { bool isInserted = false; using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); StringBuilder commandText = new StringBuilder(); commandText.AppendFormat(string.Format("Insert into IncomeDetail(PANno, IncomeFromSalary, IncomeFromOtherSource, AssessmentYear, [80C]) Values ('{0}', '{1}', '{2}', '{3}', '{4}')", personModel.PANno, incomeModel.IncomeFromSalary, incomeModel.IncomeFromOtherSource, incomeModel.AssessmentYear, incomeModel._80C)); SqlCommand command = new SqlCommand(commandText.ToString(), con); command.ExecuteNonQuery(); isInserted = true; } return(isInserted); }
protected void ButtonGetIncomeDeduction_Click(object sender, EventArgs e) { string panno = TextBoxPANno.Text; string assessmentYear = TextBoxAssessmentYear.Text; IncomeTaxDetailModel incomeDetail = GetIncomeDetail(panno, assessmentYear); LabelTotalIncome.Text = Math.Round((Convert.ToDecimal(incomeDetail.IncomeFromSalary) + Convert.ToDecimal(incomeDetail.IncomeFromOtherSource)), 0).ToString(); LabelDeduction.Text = Math.Round(Convert.ToDecimal(incomeDetail._80C), 0).ToString(); LabelTaxableIncome.Text = Math.Round((Convert.ToDecimal(LabelTotalIncome.Text) - Convert.ToDecimal(LabelDeduction.Text)), 0).ToString(); long taxableIncome = Convert.ToInt64(Math.Round(Convert.ToDecimal(LabelTaxableIncome.Text), 0)); if (taxableIncome <= 200000) { LabelIncomeTax.Text = taxableIncome.ToString(); LabelEducationCess.Text = 0.ToString(); } else if (taxableIncome > 200000 && taxableIncome <= 500000) { long taxable = taxableIncome - 200000; LabelIncomeTax.Text = (taxable * 0.1).ToString(); LabelEducationCess.Text = (taxable * 0.02).ToString(); LabelTotalTaxPayment.Text = (Convert.ToInt64(LabelIncomeTax.Text) + Convert.ToInt64(LabelEducationCess.Text)).ToString(); } else if (taxableIncome > 500000 && taxableIncome <= 1000000) { long taxable = taxableIncome - 200000; LabelIncomeTax.Text = (taxable * 0.2).ToString(); LabelEducationCess.Text = (taxable * 0.02).ToString(); LabelTotalTaxPayment.Text = (Convert.ToInt64(LabelIncomeTax.Text) + Convert.ToInt64(LabelEducationCess.Text)).ToString(); } else { long taxable = taxableIncome - 200000; LabelIncomeTax.Text = (taxable * 0.3).ToString(); LabelEducationCess.Text = (taxable * 0.02).ToString(); LabelTotalTaxPayment.Text = (Convert.ToInt64(LabelIncomeTax.Text) + Convert.ToInt64(LabelEducationCess.Text)).ToString(); } }