/// <summary>
/// Function to use the TaxComboFill
/// </summary>
public void DGVTaxComboFill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TaxViewAll();
dgvCmbTax.DataSource = ListObj;
dgvCmbTax.ValueMember = "taxId";
dgvCmbTax.DisplayMember = "taxName";
}
catch (Exception ex)
{
MessageBox.Show("SR63:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the Tax Combo Fill
/// </summary>
public void ComboTaxFill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TaxViewByProductIdApplicableForProduct(decProductId);
cmbTax.DataSource = ListObj[0];
cmbTax.ValueMember = "taxId";
cmbTax.DisplayMember = "taxName";
}
catch (Exception ex)
{
MessageBox.Show("POS:18" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On print button click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (rbtnInput.Checked)
{
isInput = true;
}
else
{
isInput = false;
}
if (rbtnBillwise.Checked)
{
isBillwise = true;
}
else
{
isBillwise = false;
}
TaxBll bllTax = new TaxBll();
DataSet dsTaxReport = new DataSet();
DateTime dtFromDate = DateTime.Parse(txtFromDate.Text);
DateTime dtToDate = DateTime.Parse(txtToDate.Text);
decimal dectaxId = Convert.ToDecimal(cmbTax.SelectedValue.ToString());
decimal decvoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
if (isBillwise)
{
dsTaxReport = bllTax.TaxCrystalReportGridFillByBillWise(1, dtFromDate, dtToDate, dectaxId, decvoucherTypeId, isInput);
}
else
{
dsTaxReport = bllTax.TaxCrystalReportGridFillByProductwise(1, dtFromDate, dtToDate, dectaxId, decvoucherTypeId, isInput);
}
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
if (dgvTaxReport.Rows.Count > 0)
{
frmReport.TaxCrystalReportPrint(dsTaxReport, isBillwise);
}
else
{
Messages.InformationMessage("No Data Found");
}
}
catch (Exception ex)
{
MessageBox.Show("TR:16" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Tax Amount Calculation
/// </summary>
public void TaxAmountCalculation()
{
decimal dcVatAmount = 0;
decimal dTaxAmt = 0;
decimal dcTotal = 0;
decimal dcNetAmount = 0;
dcNetAmount = Convert.ToDecimal(txtNetAmount.Text.Trim());
TaxBll bllTax = new TaxBll();
try
{
if (dcNetAmount != 0 && cmbTax.Visible && cmbTax.SelectedValue != null)
{
TaxInfo InfoTaxMaster = bllTax.TaxView(Convert.ToDecimal(cmbTax.SelectedValue.ToString()));
dcVatAmount = dTaxAmt = Math.Round(((dcNetAmount * InfoTaxMaster.Rate) / (100)), PublicVariables._inNoOfDecimalPlaces);
txtTaxAmount.Text = dTaxAmt.ToString();
}
else
{
dTaxAmt = 0;
txtTaxAmount.Text = "0";
}
dcTotal = dcNetAmount + dTaxAmt;
txtAmount.Text = dcTotal.ToString();
}
catch (Exception ex)
{
MessageBox.Show("POS:29" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the Tax grid
/// </summary>
public void taxGridFill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
ListObj = bllTax.TaxViewAllByVoucherTypeId(DecPOSVoucherTypeId);
dgvPOSTax.DataSource = ListObj[0];
this.dgvPOSTax.Columns["dgvtxtTaxAmt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopRight;
}
catch (Exception ex)
{
MessageBox.Show("POS:20" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Grid fill function Againest SalseOrderDetails
/// </summary>
public void gridFillAgainestSalseOrderDetails()
{
BrandBll BllBrand = new BrandBll();
//SalesOrderBll bllSalesOrder = new SalesOrderBll();
SalesOrderBll bllSalesOrder = new SalesOrderBll();
ProductInfo infoproduct = new ProductInfo();
//SalesMasterSP spSalesMaster = new SalesMasterSP();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
BrandInfo InfoBrand = new BrandInfo();
TaxInfo infoTax = new TaxInfo();
TaxBll bllTax = new TaxBll();
try
{
if (cmbSalesModeOrderNo.SelectedIndex > 0)
{
inMaxCount = 0;
isValueChange = false;
for (int i = 0; i < dgvSalesInvoice.RowCount - 1; i++)
{
if (dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceSalesDetailsId"].Value != null && dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceSalesDetailsId"].Value.ToString() != string.Empty)
{
lstArrOfRemove.Add(dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceSalesDetailsId"].Value.ToString());
}
}
dgvSalesInvoice.Rows.Clear();
isValueChange = true;
List<DataTable> ListObj= bllSalesOrder.SalesInvoiceGridfillAgainestSalesOrder(Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString()));
cmbPricingLevel.SelectedValue = Convert.ToDecimal(ListObj[0].Rows[0]["pricingLevelId"].ToString());
cmbCurrency.SelectedValue = Convert.ToDecimal(ListObj[0].Rows[0]["exchangeRateId"].ToString());
if (ListObj[0].Rows[0]["employeeId"].ToString() != string.Empty)
{
strSalesManId = ListObj[0].Rows[0]["employeeId"].ToString();
cmbSalesMan.SelectedValue = strSalesManId;
if (cmbSalesMan.SelectedValue == null)
{
salesManComboFill();
cmbSalesMan.SelectedValue = ListObj[0].Rows[0]["employeeId"].ToString();
}
}
cmbPricingLevel.Enabled = false;
btnNewPricingLevel.Enabled = false;
cmbCurrency.Enabled = false;
ListObj = bllSalesOrder.SalesInvoiceGridfillAgainestSalesOrderUsingSalesDetails(Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString()), Convert.ToDecimal(decSalesInvoiceIdToEdit), DecSalesInvoiceVoucherTypeId);
int inRowIndex = 0;
foreach (DataRow drowDetails in ListObj[0].Rows)
{
dgvSalesInvoice.Rows.Add();
isValueChange = false;
IsSetGridValueChange = false;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSISalesOrderDetailsId"].Value = drowDetails["salesOrderDetailsId"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductCode"].Value = drowDetails["productCode"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceBarcode"].Value = drowDetails["barcode"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvcmbSalesInvoiceBatch"].Value = Convert.ToDecimal(drowDetails["batchId"].ToString());
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceVoucherNo"].Value = drowDetails["voucherNo"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceInvoiceNo"].Value = drowDetails["invoiceNo"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceVoucherTypeId"].Value = drowDetails["voucherTypeId"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceDiscountPercentage"].Value = "0";
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceInRowIndex"].Value = drowDetails["salesOrderDetailsId"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductId"].Value = drowDetails.ItemArray[2].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceUnitConversionId"].Value = drowDetails["unitConversionId"].ToString();
infoproduct = BllSalesInvoice.ProductViewByProductIdforSalesInvoice(Convert.ToDecimal(dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductId"].Value).ToString());
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductName"].Value = infoproduct.ProductName;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceMrp"].Value = infoproduct.Mrp;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoicePurchaseRate"].Value = infoproduct.PurchaseRate;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceSalesRate"].Value = infoproduct.SalesRate;
InfoBrand = BllBrand.BrandView(infoproduct.BrandId);
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceBrand"].Value = InfoBrand.BrandName;
infoTax = bllTax.TaxViewByProductId(Convert.ToDecimal(dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductId"].Value).ToString());
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvcmbSalesInvoiceTaxName"].Value = infoTax.TaxId;
isValueChange = false;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoicembUnitName"].Value = Convert.ToDecimal(drowDetails["unitId"].ToString());
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoicembUnitName"].ReadOnly = true;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceQty"].Value = drowDetails["Qty"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceRate"].Value = drowDetails["rate"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceAmount"].Value = drowDetails["amount"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceConversionRate"].Value = drowDetails["conversionRate"].ToString();
isFromAgainest = true;
gridColumnMakeEnables();
int intIndex = 0;
intIndex = Convert.ToInt32(drowDetails["salesOrderDetailsId"].ToString());
if (inMaxCount < intIndex)
inMaxCount = intIndex;
inRowIndex++;
isValueChange = true;
isFromAgainest = false;
GrossValueCalculation(dgvSalesInvoice.Rows.Count - 2);
discountCalculation(dgvSalesInvoice.Rows.Count - 2);
taxAndGridTotalAmountCalculation(dgvSalesInvoice.Rows.Count - 2);
}
IsSetGridValueChange = true;
for (int i = inRowIndex; i < dgvSalesInvoice.Rows.Count; ++i)
dgvSalesInvoice["dgvtxtSalesInvoiceInRowIndex", i].Value = GetNextinRowIndex().ToString();
SerialNoforSalesInvoice();
strVoucherNoTostockPost = dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceVoucherNo"].Value.ToString();
strInvoiceNoTostockPost = dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceInvoiceNo"].Value.ToString();
decVouchertypeIdTostockPost = Convert.ToDecimal(dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceVoucherTypeId"].Value);
}
else
{
SiGridTotalAmountCalculation();
ClearGridAgainest();
}
SiGridTotalAmountCalculation();
}
catch (Exception ex)
{
MessageBox.Show("SI: 51" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Grid row total amount calculation( Including Tax)
/// </summary>
/// <param name="inIndexOfRow"></param>
public void taxAndGridTotalAmountCalculation(int inIndexOfRow)
{
TaxBll bllTax = new TaxBll();
try
{
decimal dTaxAmt = 0;
decimal dcTotal = 0;
decimal dcNetValue = 0;
if (dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvtxtSalesInvoiceQty"].Value != null && dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvtxtSalesInvoiceQty"].Value.ToString() != string.Empty)
{
dcNetValue = Convert.ToDecimal(dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvtxtSalesInvoiceNetAmount"].Value.ToString());
if (dcNetValue != 0 && dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible && (dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvcmbSalesInvoiceTaxName"].Value == null ? "" : dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvcmbSalesInvoiceTaxName"].Value.ToString()) != "")
{
TaxInfo InfoTaxMaster = bllTax.TaxView(Convert.ToDecimal(dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvcmbSalesInvoiceTaxName"].Value.ToString()));
dTaxAmt = Math.Round(((dcNetValue * InfoTaxMaster.Rate) / (100)), PublicVariables._inNoOfDecimalPlaces);
dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvtxtSalesInvoiceTaxAmount"].Value = dTaxAmt.ToString();
}
else
{
dTaxAmt = 0;
dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvtxtSalesInvoiceTaxAmount"].Value = "0.00";
}
}
else
{
dTaxAmt = 0;
dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvtxtSalesInvoiceTaxAmount"].Value = "0.00";
}
dcTotal = dcNetValue + dTaxAmt;
dgvSalesInvoice.Rows[inIndexOfRow].Cells["dgvtxtSalesInvoiceAmount"].Value = dcTotal.ToString();
}
catch (Exception ex)
{
MessageBox.Show("SI: 44 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Amount Calculations for Gross value, Net amount, Tax amount and Total amount
/// </summary>
/// <param name="columnName"></param>
/// <param name="inIndexOfRow"></param>
public void AmountCalculation(string columnName, int inIndexOfRow)
{
try
{
string strTaxRate = string.Empty;
decimal decTaxAmt = 0;
decimal decTotalAmnt = 0;
decimal decdgvtxtgrossValue = 0, decDiscountCalc = 0, decNetAmount = 0;
decimal decTaxPercent = 0;
decimal decTaxId = 0;
DataGridViewRow dgrow = dgvPurchaseReturn.Rows[inIndexOfRow];
ProductInfo infoProduct = new ProductInfo();
RackBll BllRack = new RackBll();
TaxInfo infotax = new TaxInfo();
TaxBll bllTax = new TaxBll();
if (dgrow.Cells["dgvtxtqty"].Value != null && dgrow.Cells["dgvtxtqty"].Value.ToString() != string.Empty)
{
decQty = Convert.ToDecimal(dgrow.Cells["dgvtxtqty"].Value.ToString());
}
if (dgrow.Cells["dgvtxtrate"].Value != null && dgrow.Cells["dgvtxtrate"].Value.ToString() != string.Empty)
{
decRate = Convert.ToDecimal(dgrow.Cells["dgvtxtrate"].Value.ToString());
decdgvtxtgrossValue = decQty * decRate;
dgrow.Cells["dgvtxtgrossValue"].Value = Math.Round(decdgvtxtgrossValue, PublicVariables._inNoOfDecimalPlaces);
}
if (dgrow.Cells["dgvtxtgrossValue"].Value != null && dgrow.Cells["dgvtxtgrossValue"].Value.ToString() != string.Empty)
{
dgrow.Cells["dgvtxtgrossValue"].Value = Math.Round(decdgvtxtgrossValue, PublicVariables._inNoOfDecimalPlaces);
if (dgrow.Cells["dgvtxtdiscount"].Value != null && dgrow.Cells["dgvtxtdiscount"].Value.ToString() != string.Empty)
{
decDiscountCalc = Convert.ToDecimal(dgrow.Cells["dgvtxtdiscount"].Value.ToString());
if (decdgvtxtgrossValue >= decDiscountCalc)
{
decNetAmount = Math.Round((decdgvtxtgrossValue - decDiscountCalc), PublicVariables._inNoOfDecimalPlaces);
dgrow.Cells["dgvtxtNetAmount"].Value = Math.Round(decNetAmount, PublicVariables._inNoOfDecimalPlaces);
}
else
{
dgrow.Cells["dgvtxtdiscount"].Value = 0;
}
}
else
{
dgrow.Cells["dgvtxtdiscount"].Value = 0;
dgrow.Cells["dgvtxtNetAmount"].Value = Math.Round(decNetAmount, PublicVariables._inNoOfDecimalPlaces);
}
}
if (dgrow.Cells["dgvtxtNetAmount"].Value != null && dgrow.Cells["dgvtxtNetAmount"].Value.ToString() != string.Empty)
{
decNetAmount = Math.Round(decdgvtxtgrossValue - decDiscountCalc, PublicVariables._inNoOfDecimalPlaces);
decNetAmount = Convert.ToDecimal(dgrow.Cells["dgvtxtNetAmount"].Value.ToString());
dgrow.Cells["dgvtxtNetAmount"].Value = Math.Round(decNetAmount, PublicVariables._inNoOfDecimalPlaces);
}
if (dgvcmbTax.Visible)
{
if (dgrow.Cells["dgvtxtproductId"].Value != null && dgrow.Cells["dgvtxtproductId"].Value.ToString() != string.Empty)
{
if (dgrow.Cells["dgvcmbTax"].Value != null && dgrow.Cells["dgvcmbTax"].Value.ToString() != string.Empty && dgrow.Cells["dgvcmbTax"].Value.ToString() != "NA")
{
decTaxId = Convert.ToDecimal(dgrow.Cells["dgvcmbTax"].Value.ToString());
infotax = bllTax.TaxView(decTaxId);
decTaxPercent = infotax.Rate;
if (decTaxPercent != 0)
{
if (strTaxComboFill != string.Empty)
{
decTaxAmt = ((decNetAmount * decTaxPercent) / 100);
}
else
{
dgrow.Cells["dgvtxttaxAmount"].Value = "0";
}
decTotalAmnt = Math.Round((decNetAmount + decTaxAmt), PublicVariables._inNoOfDecimalPlaces);
dgrow.Cells["dgvtxttaxAmount"].Value = Math.Round(decTaxAmt, PublicVariables._inNoOfDecimalPlaces);
decTaxAmt = Convert.ToDecimal(dgrow.Cells["dgvtxttaxAmount"].Value.ToString());
dgrow.Cells["dgvtxtAmount"].Value = Math.Round(decTotalAmnt, PublicVariables._inNoOfDecimalPlaces);
}
else
{
dgrow.Cells["dgvtxttaxAmount"].Value = "0";
dgrow.Cells["dgvtxtAmount"].Value = Math.Round(decNetAmount, PublicVariables._inNoOfDecimalPlaces);
}
}
else
{
decTaxPercent = 0;
dgrow.Cells["dgvtxttaxAmount"].Value = "0";
dgrow.Cells["dgvtxtAmount"].Value = Math.Round(decNetAmount, PublicVariables._inNoOfDecimalPlaces);
}
}
Calculate();
}
}
catch (Exception ex)
{
MessageBox.Show("PR:34 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill DataGridView PurcahseReturnTax
/// </summary>
public void DGVPurchaseReturnTaxFill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TaxViewAllByVoucherTypeId(decPurchaseReturnVoucherTypeId);
dgvPurchaseReturnTax.DataSource = ListObj[0];
}
catch (Exception ex)
{
MessageBox.Show("PR:15" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the cess and tax amount calculation
/// </summary>
public void CessTaxamountCalculation()
{
try
{
List<DataTable> ListObj = new List<DataTable>();
TaxBll bllTax = new TaxBll();
decTotalCessTaxamount = 0;
decimal decCessamount = 0;
foreach (DataGridViewRow drowDetails in dgvSalesReturn2.Rows)
{
if (drowDetails.Cells["dgvTextTaxId"].Value != null)
{
ListObj = bllTax.TaxIdCorrespondingToCessTaxId(Convert.ToDecimal(drowDetails.Cells["dgvTextTaxId"].Value.ToString()));
foreach (DataRow item in ListObj[0].Rows)
{
if (item["selectedTaxId"].ToString() != String.Empty)
{
foreach (DataGridViewRow drowDetails1 in dgvSalesReturn2.Rows)
{
if (drowDetails1.Cells["dgvTextTaxId"].Value != null)
{
if (drowDetails1.Cells["dgvTextTaxId"].Value.ToString() == item["selectedTaxId"].ToString())
{
drowDetails.Cells["dgvTextAmount"].Value = Math.Round((Convert.ToDecimal(drowDetails1.Cells["dgvTextAmount"].Value.ToString()) * Convert.ToDecimal(drowDetails.Cells["dgvRate"].Value.ToString())) / 100, PublicVariables._inNoOfDecimalPlaces);
decCessamount = Convert.ToDecimal(drowDetails.Cells["dgvTextAmount"].Value.ToString());
decTotalCessTaxamount = Math.Round(decTotalCessTaxamount + decCessamount, PublicVariables._inNoOfDecimalPlaces);
drowDetails.Cells["dgvTextAmount"].Value = decTotalCessTaxamount;
}
}
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("SR66:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//-------------------------------------------------------------TaxComboFill---------------------------
public void TaxComboFill()
{
try
{
List<DataTable> Listobj = new List<DataTable>();
TaxBll bllTax = new TaxBll();
Listobj = bllTax.TaxViewAllForProduct();
cmbTax.DataSource = Listobj[0];
cmbTax.DisplayMember = "taxName";
cmbTax.ValueMember = "taxId";
}
catch (Exception ex)
{
MessageBox.Show("PC:47" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Total amount calculation
/// </summary>
public void TotalBillTaxCalculation()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TotalBillTaxCalculationBtapplicableOn();
foreach (DataRow drowItem in ListObj[0].Rows)
{
if (drowItem != null)
{
foreach (DataGridViewRow dgvrItem in dgvSalesReturn2.Rows)
{
if (dgvrItem.Cells["dgvTextTaxId"].Value != null)
{
if (dgvrItem.Cells["dgvTextTaxId"].Value.ToString() == drowItem["taxId"].ToString())
{
if (txtTotalAmount.Text != string.Empty)
{
dgvrItem.Cells["dgvTextAmount"].Value = Math.Round((Convert.ToDecimal(drowItem["rate"].ToString()) * Convert.ToDecimal(txtTotalAmount.Text)) / 100, PublicVariables._inNoOfDecimalPlaces);
decTotalBillTaxAmount = Math.Round(Convert.ToDecimal(dgvrItem.Cells["dgvTextAmount"].Value.ToString()), PublicVariables._inNoOfDecimalPlaces);
}
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("SR19:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the Tax gridfill
/// </summary>
public void TaxGridFill()
{
string strTaxName = string.Empty;
try
{
List<DataTable> ListObj = new List<DataTable>();
TaxBll bllTax = new TaxBll();
string strTaxApplicableOn = "Product";
ListObj = bllTax.TaxViewAllByVoucherTypeId1(decSalesReturnVoucherTypeId, strTaxApplicableOn);
dgvCmbTax.DataSource = ListObj[0];
foreach (DataRow item in ListObj[0].Rows)
{
strTaxName = item["taxName"].ToString();
if (strTaxName != "NA")
{
DataRow dr = ListObj[0].NewRow();
dr["taxName"] = "NA";
dr["taxId"] = 1;
ListObj[0].Rows.InsertAt(dr, 0);
}
break;
}
dgvCmbTax.ValueMember = "taxId";
dgvCmbTax.DisplayMember = "taxName";
}
catch (Exception ex)
{
MessageBox.Show("SR64:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// TaxAmountCalculation
/// </summary>
/// <param name="inRowIndex"></param>
public void TaxAmountCalculation(int inRowIndex)
{
decimal dcTotal = 0;
decimal dcVatAmount = 0;
decimal dcNetAmount = 0;
dcNetAmount = Convert.ToDecimal(dgvSalesReturn.Rows[inRowIndex].Cells["dgvTextNetValue"].Value.ToString());
TaxBll bllTax = new TaxBll();
try
{
if (dcNetAmount != 0 && dgvCmbTax.Visible && dgvSalesReturn.Rows[inRowIndex].Cells["dgvCmbTax"].Value != null)
{
TaxInfo InfoTaxMaster = bllTax.TaxView(Convert.ToDecimal(dgvSalesReturn.Rows[inRowIndex].Cells["dgvCmbTax"].Value.ToString()));
dcVatAmount = Math.Round(((dcNetAmount * InfoTaxMaster.Rate) / (100)), PublicVariables._inNoOfDecimalPlaces);
dgvSalesReturn.Rows[inRowIndex].Cells["dgvTextTaxAmount"].Value = dcVatAmount;
}
else
{
dgvSalesReturn.Rows[inRowIndex].Cells["dgvTextTaxAmount"].Value = "0";
}
dcTotal = dcVatAmount + dcNetAmount;
dgvSalesReturn.Rows[inRowIndex].Cells["dgvTextAmount1"].Value = dcTotal;
}
catch (Exception ex)
{
MessageBox.Show("SR49:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// tax Selection grid fill function
/// </summary>
public void TaxSelectionGridFill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TaxViewAllForTaxSelection();
dgvTaxSelection.DataSource = ListObj[0];
}
catch (Exception ex)
{
MessageBox.Show("TC8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill DataGridView Tax combobox
/// </summary>
public void DGVTaxCombofill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TaxViewAllByVoucherTypeIdApplicaleForProduct(decPurchaseReturnVoucherTypeId);
strTaxComboFill = (ListObj[0].Rows.Count > 0) ? ListObj[0].Rows[0]["taxId"].ToString() : string.Empty;
dgvcmbTax.DataSource = ListObj[0];
dgvcmbTax.DisplayMember = "taxName";
dgvcmbTax.ValueMember = "taxId";
}
catch (Exception ex)
{
MessageBox.Show("PR:11" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Tax combofill in the grid under the vouchertype id
/// </summary>
public void dgvSalesInvoiceTaxComboFill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TaxViewAllByVoucherTypeIdApplicaleForProduct(DecSalesInvoiceVoucherTypeId);
DataRow drow = ListObj[0].NewRow();
drow["taxName"] = string.Empty;
drow["taxId"] = 0;
ListObj[0].Rows.InsertAt(drow, 0);
dgvcmbSalesInvoiceTaxName.DataSource = ListObj[0];
dgvcmbSalesInvoiceTaxName.ValueMember = "taxId";
dgvcmbSalesInvoiceTaxName.DisplayMember = "taxName";
}
catch (Exception ex)
{
MessageBox.Show("SI: 31" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// tax grid fill function
/// </summary>
public void TaxGridFill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> Listobj = new List<DataTable>();
Listobj = bllTax.TaxViewAllForVoucherType();
dgvApplicableTaxes.DataSource = Listobj[0];
}
catch (Exception ex)
{
MessageBox.Show("VT08:" + 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;
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<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());
ListObj = bllTax.TaxDetailsViewallByTaxId(decTaxId);
foreach (DataGridViewRow dgvRow2 in dgvSalesInvoiceTax.Rows)
{
foreach (DataRow drow in ListObj[0].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>
/// delete function
/// </summary>
public void Delete()
{
try
{
if (PublicVariables.isMessageDelete)
{
if (Messages.DeleteMessage())
{
TaxInfo infoTax = new TaxInfo();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxBll bllTax = new TaxBll();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
bool isExist = bllTax.TaxReferenceCheck(decTaxId);
if (!isExist)
{
if ((bllTax.TaxReferenceDelete(decTaxId,decLedgerId)) == -1)
{
Messages.ReferenceExistsMessage();
}
else
{
bllTax.TaxDetailsDeleteWithTaxId(decTaxId);
bllAccountLedger.AccountLedgerDelete(decLedgerId);
Messages.DeletedMessage();
TaxSearchGridFill();
TaxSelectionGridFill();
Clear();
SearchClear();
}
}
else
{
Messages.ReferenceExistsMessage();
}
}
}
else
{
TaxInfo infoTax = new TaxInfo();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxBll bllTax = new TaxBll();
bool isExist = bllTax.TaxReferenceCheck(decTaxId);
if (!isExist)
{
if ((bllTax.TaxReferenceDelete(decTaxId,decLedgerId)) == -1)
{
Messages.ReferenceExistsMessage();
}
else
{
bllTax.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>
/// Tax gridfill function
/// </summary>
public void taxGridFill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TaxViewAllByVoucherTypeId(DecSalesInvoiceVoucherTypeId);
dgvSalesInvoiceTax.DataSource = ListObj[0];
}
catch (Exception ex)
{
MessageBox.Show("SI: 11" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// update function
/// </summary>
public void EditFunction()
{
try
{
TaxInfo infoTax = new TaxInfo();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxBll bllTax = new TaxBll();
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 (bllTax.TaxCheckExistence(decTaxIdForEdit, txtTaxName.Text.Trim()) == false)
{
infoTax.TaxId = decTaxId;
bllTax.TaxEdit(infoTax);
//-- Delete And Add Tax details --//
bllTax.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;
bllTax.TaxDetailsAddWithoutId(infoTaxDetails);
}
}
}
LedgerEdit();
Messages.UpdatedMessage();
Clear();
}
else
{
Messages.InformationMessage(" Tax or ledger already exist");
txtTaxName.Focus();
}
}
else
{
infoTax.TaxId = decTaxId;
bllTax.TaxEdit(infoTax);
bllTax.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;
bllTax.TaxDetailsAddWithoutId(infoTaxDetails);
}
}
}
LedgerEdit();
Messages.UpdatedMessage();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("TC5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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());
List<DataTable> ListObj = new List<DataTable>();
TaxBll bllTax = new TaxBll();
ListObj = bllTax.TaxDetailsViewallByTaxId(decTaxId);
foreach (DataGridViewRow dgvRow2 in dgvPOSTax.Rows)
{
foreach (DataRow drow in ListObj[0].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);
}
}
/// <summary>
/// save function
/// </summary>
public void SaveFunction()
{
try
{
TaxInfo infoTax = new TaxInfo();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxBll bllTax = new TaxBll();
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 (bllTax.TaxCheckExistence(0, txtTaxName.Text.Trim()) == false)
{
decTaxId = bllTax.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;
bllTax.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>
/// Function to use the Tax Combo Fill
/// </summary>
public void cmbTaxComboFill()
{
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TaxViewAllByVoucherTypeIdApplicaleForProduct(DecPOSVoucherTypeId);
DataRow dr = ListObj[0].NewRow();
dr[1] = "NA";
ListObj[0].Rows.InsertAt(dr, 0);
cmbTax.DataSource = ListObj[0];
cmbTax.ValueMember = "taxId";
cmbTax.DisplayMember = "taxName";
}
catch (Exception ex)
{
MessageBox.Show("POS:16" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// tax search grid fill
/// </summary>
public void TaxSearchGridFill()
{
string strCmbActiveSearchText = string.Empty;
try
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
if (cmbActiveSearch.Text == "Yes")
{
strCmbActiveSearchText = "True";
}
else if (cmbActiveSearch.Text == "No")
{
strCmbActiveSearchText = "False";
}
else
{
strCmbActiveSearchText = "All";
}
ListObj = bllTax.TaxSearch(txtTaxNameSearch.Text.Trim(), cmbApplicableForSearch.Text, cmbCalculationModeSearch.Text, strCmbActiveSearchText);
dgvTaxSearch.DataSource = ListObj[0];
int inRowCount = dgvTaxSearch.RowCount;
for (int i = 0; i <= inRowCount - 1; i++)
{
if (dgvTaxSearch.Rows[i].Cells["dgvtxtActive"].Value != null && dgvTaxSearch.Rows[i].Cells["dgvtxtActive"].Value.ToString()!=string.Empty)
{
if (dgvTaxSearch.Rows[i].Cells["dgvtxtActive"].Value.ToString() == "1")
{
dgvTaxSearch.Rows[i].Cells["dgvtxtActive"].Value = "Yes";
}
if (dgvTaxSearch.Rows[i].Cells["dgvtxtActive"].Value.ToString() == "0")
{
dgvTaxSearch.Rows[i].Cells["dgvtxtActive"].Value = "No";
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("TC9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// To fill the tax combobox
/// </summary>
public void TaxComboFill()
{
try
{
List<DataTable> ListObj = new List<DataTable>();
TaxBll bllTax = new TaxBll();
ListObj = bllTax.TaxViewAll();
DataRow dr = ListObj[0].NewRow();
dr["taxName"] = "All";
dr["taxId"] = 0;
ListObj[0].Rows.InsertAt(dr, 0);
cmbTax.DataSource = ListObj[0];
cmbTax.DisplayMember = "taxName";
cmbTax.ValueMember = "taxId";
}
catch (Exception ex)
{
MessageBox.Show("TR:2" + 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();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxBll bllTax = new TaxBll();
infoTax = bllTax.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;
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllTax.TaxIdForTaxSelectionUpdate(decTaxId);
foreach (DataRow dr in ListObj[0].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;
}
}
}
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
decLedgerId = bllAccountLedger.AccountLedgerIdGetByName(txtTaxName.Text);
}
catch (Exception ex)
{
MessageBox.Show("TC10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// To fill the grid
/// </summary>
public void GridFill()
{
try
{
if (cmbTax.SelectedValue != null && cmbVoucherType.SelectedItem != null)
{
TaxBll bllTax = new TaxBll();
List<DataTable> ListObj = new List<DataTable>();
DateTime dtFromDate = DateTime.Parse(txtFromDate.Text);
DateTime dtToDate = DateTime.Parse(txtToDate.Text);
decimal dectaxId = Convert.ToDecimal(cmbTax.SelectedValue.ToString());
decimal decvoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
string strTypeofVoucher = Convert.ToString(cmbTypeOfVoucher.Text);
if (isBillwise)
{
ListObj = bllTax.TaxReportGridFillByBillWise(dtFromDate, dtToDate, dectaxId, decvoucherTypeId, strTypeofVoucher, isInput);
if (ListObj[0].Rows.Count > 0)
{
for (int i = 0; i < ListObj[0].Rows.Count; i++)
{
dgvTaxReport.Rows.Add();
dgvTaxReport.Rows[i].Cells["dgvtxtSlNo"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["SlNo"]);
dgvTaxReport.Rows[i].Cells["dgvtxtDate"].Value = ListObj[0].Rows[i]["Date"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtVoucherType"].Value = ListObj[0].Rows[i]["TypeofVoucher"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtVoucherNo"].Value = ListObj[0].Rows[i]["Voucher No"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtCashParty"].Value = ListObj[0].Rows[i]["Cash/Party"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtTIN"].Value = ListObj[0].Rows[i]["TIN"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtCST"].Value = ListObj[0].Rows[i]["CST"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtBillAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["Bill Amount"]);
dgvTaxReport.Rows[i].Cells["dgvtxtCessAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["Cess Amount"]);
dgvTaxReport.Rows[i].Cells["dgvtxtTaxAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["Tax Amount"]);
}
}
}
else
{
ListObj = bllTax.TaxReportGridFillByProductwise(dtFromDate, dtToDate, dectaxId, decvoucherTypeId, strTypeofVoucher, isInput);
if (ListObj[0].Rows.Count > 0)
{
for (int i = 0; i < ListObj[0].Rows.Count; i++)
{
dgvTaxReport.Rows.Add();
dgvTaxReport.Rows[i].Cells["dgvtxtSlNo"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["SlNo"]);
dgvTaxReport.Rows[i].Cells["dgvtxtDate"].Value = ListObj[0].Rows[i]["Date"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtVoucherType"].Value = ListObj[0].Rows[i]["Voucher Type"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtBillNo"].Value = ListObj[0].Rows[i]["Bill No"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtItem"].Value = ListObj[0].Rows[i]["Item"].ToString();
dgvTaxReport.Rows[i].Cells["dgvtxtBillAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["Bill Amount"]);
dgvTaxReport.Rows[i].Cells["dgvtxtTax"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["Tax %"]);
dgvTaxReport.Rows[i].Cells["dgvtxtTaxAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["Tax Amount"]);
dgvTaxReport.Rows[i].Cells["dgvtxtTotalAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["Total Amount"]);
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("TR:3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the tax gridfill
/// </summary>
public void DGVSalesReturn2Fill()
{
try
{
List<DataTable> ListObj = new List<DataTable>();
TaxBll bllTax = new TaxBll();
ListObj = bllTax.TaxViewAllByVoucherTypeIdWithCess(decSalesReturnVoucherTypeId);
dgvSalesReturn2.Rows.Clear();
foreach (DataRow drowDetails in ListObj[0].Rows)
{
dgvSalesReturn2.Rows.Add();
dgvSalesReturn2.Rows[dgvSalesReturn2.Rows.Count - 2].Cells["dgvTextTaxName"].Value = drowDetails["taxName"].ToString();
dgvSalesReturn2.Rows[dgvSalesReturn2.Rows.Count - 2].Cells["dgvTextTaxId"].Value = drowDetails["taxId"].ToString();
dgvSalesReturn2.Rows[dgvSalesReturn2.Rows.Count - 2].Cells["dgvTextAmount"].Value = 0.00;
dgvSalesReturn2.Rows[dgvSalesReturn2.Rows.Count - 2].Cells["dgvRate"].Value = drowDetails["rate"].ToString();
}
SerialNo2();
}
catch (Exception ex)
{
MessageBox.Show("SR65:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
