/// <summary> /// delete function /// </summary> public void Delete() { try { if (PublicVariables.isMessageDelete) { if (Messages.DeleteMessage()) { TaxInfo infoTax = new TaxInfo(); TaxSP spTax = new TaxSP(); TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo(); TaxDetailsSP spTaxDetails = new TaxDetailsSP(); AccountLedgerSP spAccountLedger = new AccountLedgerSP(); bool isExist = spTax.TaxReferenceCheck(decTaxId); if (!isExist) { if ((spTax.TaxReferenceDelete(decTaxId,decLedgerId)) == -1) { Messages.ReferenceExistsMessage(); } else { spTaxDetails.TaxDetailsDeleteWithTaxId(decTaxId); spAccountLedger.AccountLedgerDelete(decLedgerId); Messages.DeletedMessage(); TaxSearchGridFill(); TaxSelectionGridFill(); Clear(); SearchClear(); } } else { Messages.ReferenceExistsMessage(); } } } else { TaxInfo infoTax = new TaxInfo(); TaxSP spTax = new TaxSP(); TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo(); TaxDetailsSP spTaxDetails = new TaxDetailsSP(); bool isExist = spTax.TaxReferenceCheck(decTaxId); if (!isExist) { if ((spTax.TaxReferenceDelete(decTaxId,decLedgerId)) == -1) { Messages.ReferenceExistsMessage(); } else { spTaxDetails.TaxDetailsDeleteWithTaxId(decTaxId); Messages.DeletedMessage(); TaxSearchGridFill(); TaxSelectionGridFill(); Clear(); SearchClear(); } } else { Messages.ReferenceExistsMessage(); } } } catch (Exception ex) { MessageBox.Show("TC11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// fill the curresponding details for update /// </summary> public void TaxSelectionFillForUpdate() { try { int inRowCount = dgvTaxSelection.RowCount; for (int i = 0; i < inRowCount; i++) { dgvTaxSelection.Rows[i].Cells["dgvcbxSelect"].Value = false; } decTaxId = Convert.ToDecimal(dgvTaxSearch.CurrentRow.Cells["dgvtxtTaxIdSearch"].Value.ToString()); TaxInfo infoTax = new TaxInfo(); TaxSP spTax = new TaxSP(); TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo(); TaxDetailsSP spTaxDetails = new TaxDetailsSP(); infoTax = spTax.TaxView(decTaxId); txtTaxName.Text = infoTax.TaxName; txtRate.Text = infoTax.Rate.ToString(); cmbApplicableFor.Text = infoTax.ApplicableOn; cmbCalculationMode.Text = infoTax.CalculatingMode; txtNarration.Text = infoTax.Narration; if (infoTax.IsActive.ToString() == "True") { cbxActive.Checked = true; } else { cbxActive.Checked = false; } strTaxName = infoTax.TaxName; decTaxIdForEdit = infoTax.TaxId; btnSave.Text = "Update"; btnDelete.Enabled = true; DataTable dtbl = new DataTable(); dtbl = spTax.TaxIdForTaxSelectionUpdate(decTaxId); foreach (DataRow dr in dtbl.Rows) { string strTaxId = dr["selectedtaxId"].ToString(); for (int i = 0; i < inRowCount; i++) { if (dgvTaxSelection.Rows[i].Cells["dgvtxtTaxId"].Value.ToString() == strTaxId) { dgvTaxSelection.Rows[i].Cells["dgvcbxSelect"].Value = true; } } } AccountLedgerSP spAccountLedger = new AccountLedgerSP(); decLedgerId = spAccountLedger.AccountLedgerIdGetByName(txtTaxName.Text); } catch (Exception ex) { MessageBox.Show("TC10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// update function /// </summary> public void EditFunction() { try { TaxInfo infoTax = new TaxInfo(); TaxSP spTax = new TaxSP(); TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo(); TaxDetailsSP spTaxDetails = new TaxDetailsSP(); infoTax.TaxName = txtTaxName.Text.Trim(); infoTax.Rate = Convert.ToDecimal(txtRate.Text.ToString()); infoTax.ApplicableOn = cmbApplicableFor.SelectedItem.ToString(); if (cmbCalculationMode.Enabled != true) { infoTax.CalculatingMode = string.Empty; } else { infoTax.CalculatingMode = cmbCalculationMode.SelectedItem.ToString(); } infoTax.Narration = txtNarration.Text.Trim(); if (cbxActive.Checked) { infoTax.IsActive = true; } else { infoTax.IsActive = false; } infoTax.Extra1 = string.Empty; infoTax.Extra2 = string.Empty; if (txtTaxName.Text.ToString() != strTaxName) { if (spTax.TaxCheckExistence(decTaxIdForEdit, txtTaxName.Text.Trim()) == false) { infoTax.TaxId = decTaxId; spTax.TaxEdit(infoTax); //-- Delete And Add Tax details --// spTaxDetails.TaxDetailsDeleteWithTaxId(decTaxId); if (dgvTaxSelection.RowCount > 0) { bool isOk = false; foreach (DataGridViewRow dgvRow in dgvTaxSelection.Rows) { isOk = Convert.ToBoolean(dgvRow.Cells["dgvcbxSelect"].Value); if (isOk) { infoTaxDetails.TaxId = decTaxId; infoTaxDetails.SelectedtaxId = Convert.ToDecimal(dgvRow.Cells["dgvtxtTaxId"].Value.ToString());//dgvRow.Cells[0].Value.ToString(); infoTaxDetails.ExtraDate = DateTime.Now; infoTaxDetails.Extra1 = string.Empty; infoTaxDetails.Extra2 = string.Empty; spTaxDetails.TaxDetailsAddWithoutId(infoTaxDetails); } } } LedgerEdit(); Messages.UpdatedMessage(); Clear(); } else { Messages.InformationMessage(" Tax or ledger already exist"); txtTaxName.Focus(); } } else { infoTax.TaxId = decTaxId; spTax.TaxEdit(infoTax); spTaxDetails.TaxDetailsDeleteWithTaxId(decTaxId); if (dgvTaxSelection.RowCount > 0) { bool isOk = false; foreach (DataGridViewRow dgvRow in dgvTaxSelection.Rows) { isOk = Convert.ToBoolean(dgvRow.Cells["dgvcbxSelect"].Value); if (isOk) { infoTaxDetails.TaxId = decTaxId; infoTaxDetails.SelectedtaxId = Convert.ToDecimal(dgvRow.Cells["dgvtxtTaxId"].Value.ToString());//dgvRow.Cells[0].Value.ToString(); infoTaxDetails.ExtraDate = DateTime.Now; infoTaxDetails.Extra1 = string.Empty; infoTaxDetails.Extra2 = string.Empty; spTaxDetails.TaxDetailsAddWithoutId(infoTaxDetails); } } } LedgerEdit(); Messages.UpdatedMessage(); Clear(); } } catch (Exception ex) { MessageBox.Show("TC5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// save function /// </summary> public void SaveFunction() { try { TaxInfo infoTax = new TaxInfo(); TaxSP spTax = new TaxSP(); TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo(); TaxDetailsSP spTaxDetails = new TaxDetailsSP(); infoTax.TaxName = txtTaxName.Text.Trim(); infoTax.Rate = Convert.ToDecimal(txtRate.Text.ToString()); infoTax.ApplicableOn = cmbApplicableFor.SelectedItem.ToString(); if (cmbCalculationMode.Enabled != true) { infoTax.CalculatingMode = string.Empty; } else { infoTax.CalculatingMode = cmbCalculationMode.SelectedItem.ToString(); } infoTax.Narration = txtNarration.Text.Trim(); if (cbxActive.Checked) { infoTax.IsActive = true; } else { infoTax.IsActive = false; } infoTax.Extra1 = string.Empty; infoTax.Extra2 = string.Empty; if (spTax.TaxCheckExistence(0, txtTaxName.Text.Trim()) == false) { decTaxId = spTax.TaxAddWithIdentity(infoTax); decIdForOtherForms = decTaxId; if (dgvTaxSelection.RowCount > 0) { bool isOk = false; foreach (DataGridViewRow dgvRow in dgvTaxSelection.Rows) { isOk = Convert.ToBoolean(dgvRow.Cells["dgvcbxSelect"].Value); if (isOk) { infoTaxDetails.TaxId = decTaxId; infoTaxDetails.SelectedtaxId = Convert.ToDecimal(dgvRow.Cells["dgvtxtTaxId"].Value.ToString());//dgvRow.Cells[0].Value.ToString(); infoTaxDetails.ExtraDate = DateTime.Now; infoTaxDetails.Extra1 = string.Empty; infoTaxDetails.Extra2 = string.Empty; spTaxDetails.TaxDetailsAddWithoutId(infoTaxDetails); } } } CreateLedger(); Messages.SavedMessage(); Clear(); SearchClear(); } else { Messages.InformationMessage(" Tax or ledger already exist"); txtTaxName.Focus(); } if (frmProductCreationObj != null) { this.Close(); } } catch (Exception ex) { MessageBox.Show("TC4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <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); } }