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