/// <summary>
/// Get the total tax amount applicable on bill calculation( to get Final total amount)
/// </summary>
/// <returns></returns>
public decimal TaxAmountApplicableOnBill()
{
decimal decTaxId = 0;
decimal decTaxRate = 0;
decimal decTaxOnBill = 0;
decimal decTotalTaxOnBill = 0;
decimal decTaxOnTax = 0;
decimal decTotalTaxOnTax = 0;
decimal decTotalAmount = 0;
decimal decTotalTax = 0;
TaxDetailsSP spTaxDetails = new TaxDetailsSP();
DataTable dtbl = new DataTable();
try
{
TaxAmountForTaxType();
if (txtTotalAmount.Text != string.Empty)
{
decTotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
}
foreach (DataGridViewRow dgvRow in dgvSalesInvoiceTax.Rows)
{
if (dgvRow.Cells["dgvtxtTtaxId"].Value != null)
{
if (dgvRow.Cells["dgvtxtTApplicableOn"].Value != null && dgvRow.Cells["dgvtxtTCalculatingMode"].Value != null)
{
if (dgvRow.Cells["dgvtxtTApplicableOn"].Value.ToString() == "Bill" && dgvRow.Cells["dgvtxtTCalculatingMode"].Value.ToString() == "Bill Amount")
{
decTaxRate = Convert.ToDecimal(dgvRow.Cells["dgvtxtTTaxRate"].Value.ToString());
decTaxOnBill = (decTotalAmount * decTaxRate / 100);
dgvRow.Cells["dgvtxtTtaxAmount"].Value = Math.Round(decTaxOnBill, PublicVariables._inNoOfDecimalPlaces);
decTotalTaxOnBill = decTotalTaxOnBill + decTaxOnBill;
}
}
}
}
foreach (DataGridViewRow dgvRow1 in dgvSalesInvoiceTax.Rows)
{
if (dgvRow1.Cells["dgvtxtTtaxId"].Value != null)
{
if (dgvRow1.Cells["dgvtxtTApplicableOn"].Value != null && dgvRow1.Cells["dgvtxtTCalculatingMode"].Value != null)
{
if (dgvRow1.Cells["dgvtxtTApplicableOn"].Value.ToString() == "Bill" && dgvRow1.Cells["dgvtxtTCalculatingMode"].Value.ToString() == "Tax Amount")
{
decTaxId = Convert.ToDecimal(dgvRow1.Cells["dgvtxtTtaxId"].Value.ToString());
dtbl = spTaxDetails.TaxDetailsViewallByTaxId(decTaxId);
foreach (DataGridViewRow dgvRow2 in dgvSalesInvoiceTax.Rows)
{
foreach (DataRow drow in dtbl.Rows)
{
if (dgvRow2.Cells["dgvtxtTtaxId"].Value != null)
{
if (dgvRow2.Cells["dgvtxtTtaxId"].Value.ToString() == drow.ItemArray[0].ToString())
{
decTaxRate = Convert.ToDecimal(dgvRow1.Cells["dgvtxtTTaxRate"].Value.ToString());
decTotalAmount = Convert.ToDecimal(dgvRow2.Cells["dgvtxtTtaxAmount"].Value.ToString());
decTaxOnTax = (decTotalAmount * decTaxRate / 100);
dgvRow1.Cells["dgvtxtTtaxAmount"].Value = Math.Round(decTaxOnTax, PublicVariables._inNoOfDecimalPlaces);
decTotalTaxOnTax = decTotalTaxOnTax + decTaxOnTax;
}
}
}
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("SI: 45" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
decTotalTax = decTotalTaxOnBill + decTotalTaxOnTax;
return decTotalTax;
}
/// <summary>
/// Function to get tax grid total amount calculation
/// </summary>
public void TaxGridAmountCalculation()
{
decimal dTotal = 0;
decimal decTaxId = 0;
decimal decTaxRate = 0;
decimal dcTCessTotal = 0;
decimal decTaxTotal;
try
{
TaxAmountForTaxType();
foreach (DataGridViewRow dgvrow in dgvPointOfSales.Rows)
{
if (dgvrow.Cells["dgvtxtTotalAmount"].Value != null && dgvrow.Cells["dgvtxtTotalAmount"].Value.ToString() != string.Empty)
{
dTotal = dTotal + Convert.ToDecimal(dgvrow.Cells["dgvtxtTotalAmount"].Value.ToString());
}
}
foreach (DataGridViewRow dgvrowTax in dgvPOSTax.Rows)
{
if (dgvrowTax.Cells["dgvtxttax"].Value != null)
{
if (dgvrowTax.Cells["dgvtxtTaxApplicableOn"].Value != null && dgvrowTax.Cells["dgvtxttaxCalculateMode"].Value != null)
{
if (dgvrowTax.Cells["dgvtxtTaxApplicableOn"].Value.ToString() == "Bill" && dgvrowTax.Cells["dgvtxttaxCalculateMode"].Value.ToString() == "Bill Amount")
{
decTaxRate = Convert.ToDecimal(dgvrowTax.Cells["dgvtxttaxrate"].Value.ToString());
decTaxTotal = (dTotal * decTaxRate / 100);
dgvrowTax.Cells["dgvtxtTaxAmt"].Value = Math.Round(decTaxTotal, PublicVariables._inNoOfDecimalPlaces);
}
}
}
}
foreach (DataGridViewRow dgvRow1 in dgvPOSTax.Rows)
{
if (dgvRow1.Cells["dgvtxttax"].Value != null)
{
if (dgvRow1.Cells["dgvtxtTaxApplicableOn"].Value != null && dgvRow1.Cells["dgvtxttaxCalculateMode"].Value != null)
{
if (dgvRow1.Cells["dgvtxtTaxApplicableOn"].Value.ToString() == "Bill" && dgvRow1.Cells["dgvtxttaxCalculateMode"].Value.ToString() == "Tax Amount")
{
decTaxId = Convert.ToDecimal(dgvRow1.Cells["dgvtxttax"].Value.ToString());
DataTable dtbl = new DataTable();
TaxDetailsSP spTaxDetails = new TaxDetailsSP();
dtbl = spTaxDetails.TaxDetailsViewallByTaxId(decTaxId);
foreach (DataGridViewRow dgvRow2 in dgvPOSTax.Rows)
{
foreach (DataRow drow in dtbl.Rows)
{
if (dgvRow2.Cells["dgvtxtTaxAmt"].Value != null)
{
decimal deca = 0;
deca = Convert.ToDecimal(dgvRow2.Cells["dgvtxtTaxAmt"].Value.ToString());
if (dgvRow2.Cells["dgvtxttax"].Value != null && deca != 0)
{
if (dgvRow2.Cells["dgvtxttax"].Value.ToString() == drow.ItemArray[0].ToString())
{
decTaxRate = Convert.ToDecimal(dgvRow1.Cells["dgvtxttaxrate"].Value.ToString());
dTotal = Convert.ToDecimal(dgvRow2.Cells["dgvtxtTaxAmt"].Value.ToString());
dcTCessTotal = (dTotal * decTaxRate / 100);
dgvRow1.Cells["temp"].Value = Math.Round(dcTCessTotal, PublicVariables._inNoOfDecimalPlaces);
if (dgvRow1.Cells["dgvtxttax"].Value.ToString() == decTaxId.ToString())
{
dgvRow1.Cells["dgvtxtTaxAmt"].Value = dgvRow1.Cells["temp"].Value;
}
}
}
}
else
{
dgvRow1.Cells["dgvtxtTaxAmt"].Value = 0;
}
}
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("POS:38" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}