/// <summary>
/// Function to call frmProductSearchPopup form to select and view Product created
/// </summary>
/// <param name="frmProductSearchPopup"></param>
/// <param name="decproductId"></param>
/// <param name="decCurrentRowIndex"></param>
public void CallFromProductSearchPopup(frmProductSearchPopup frmProductSearchPopup, decimal decproductId, decimal decCurrentRowIndex)
{
try
{
base.Show();
this.frmProductSearchPopupObj = frmProductSearchPopup;
List<DataTable> list = new List<DataTable>();
UnitConvertionBll bllUnitConvertion = new UnitConvertionBll();
ProductInfo infoProduct = new ProductInfo();
BatchBll BllBatch = new BatchBll();
infoProduct = new ProductCreationBll().ProductView(decproductId);
dgvProduct.Rows.Add();
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvtxtProductCode"].Value = infoProduct.ProductCode;
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvtxtProductId"].Value = decproductId.ToString();
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvtxtProductName"].Value = infoProduct.ProductName;
UnitComboFill1(decproductId, dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Index, dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvcmbUnit"].ColumnIndex);
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
GridGodownComboFill(decproductId, dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Index, dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvcmbGodown"].ColumnIndex);
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvcmbGodown"].Value = infoProduct.GodownId;
RackComboFill1(infoProduct.GodownId, dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Index, dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvcmbRack"].ColumnIndex);
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvcmbRack"].Value = infoProduct.RackId;
BatchComboFill(decproductId, dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Index, dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvcmbBatch"].ColumnIndex);
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvcmbBatch"].Value = BllBatch.BatchIdViewByProductId(decproductId);
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvtxtBarcode"].Value = BllBatch.ProductBatchBarcodeViewByBatchId(Convert.ToDecimal(dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvcmbBatch"].Value.ToString()));
list = bllUnitConvertion.DGVUnitConvertionRateByUnitId(infoProduct.UnitId, infoProduct.ProductName);
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvtxtUnitConversionId"].Value = list[0].Rows[0]["unitconversionId"].ToString();
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvtxtConversionRate"].Value = list[0].Rows[0]["conversionRate"].ToString();
decCurrentConversionRate = Convert.ToDecimal(dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvtxtConversionRate"].Value.ToString());
AmountCalculation("dgvtxtQty", dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Index);
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].Cells["dgvtxtRate"].Value = infoProduct.SalesRate.ToString();
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].HeaderCell.Value = "X";
dgvProduct.Rows[Convert.ToInt32(decCurrentRowIndex.ToString())].HeaderCell.Style.ForeColor = Color.Red;
TotalAmountCalculation();
frmProductSearchPopupObj.Close();
frmProductSearchPopupObj = null;
}
catch (Exception ex)
{
MessageBox.Show("DN12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Fill Product Details in grid
/// </summary>
/// <param name="strProductCode"></param>
/// <param name="rowIndex"></param>
private void FillProductDetails(string strProductCode, int rowIndex)
{
try
{
ProductInfo infoProductFill = new ProductInfo();
infoProductFill = new ProductCreationBll().ProductViewByCode(strProductCode);
UnitConvertionBll bllUnitConvertion = new UnitConvertionBll();
BatchBll BllBatch = new BatchBll();
ProductCreationBll BllProductCreation = new ProductCreationBll();
StockPostingBll BllStockPosting = new StockPostingBll();
List<DataTable> list = new List<DataTable>();
decimal decCurrentConversionRate = 0;
if (infoProductFill.ProductId != 0)
{
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtproductId"].Value = infoProductFill.ProductId;
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtproductCode"].Value = infoProductFill.ProductCode;
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtproductName"].Value = infoProductFill.ProductName;
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvcmbGodown"].Value = infoProductFill.GodownId;
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvcmbRack"].Value = infoProductFill.RackId;
UnitComboFill(infoProductFill.ProductId, rowIndex, dgvPurchaseReturn.CurrentRow.Cells["dgvcmbUnit"].ColumnIndex);
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvcmbUnit"].Value = infoProductFill.UnitId;
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtrate"].Value = Math.Round(infoProductFill.PurchaseRate, PublicVariables._inNoOfDecimalPlaces);
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(new UnitConvertionBll().UnitconversionIdViewByUnitIdAndProductId(infoProductFill.UnitId, infoProductFill.ProductId));
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtConversionRate"].Value = bllUnitConvertion.UnitConversionRateByUnitConversionId(Convert.ToDecimal(dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtUnitConversionId"].Value.ToString()));
BatchComboFill(infoProductFill.ProductId, rowIndex, dgvPurchaseReturn.CurrentRow.Cells["dgvcmbBatch"].ColumnIndex);
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvcmbBatch"].Value = BllStockPosting.BatchViewByProductId(Convert.ToDecimal(dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtproductId"].Value));
list = bllUnitConvertion.DGVUnitConvertionRateByUnitId(infoProductFill.UnitId, infoProductFill.ProductName);
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtUnitConversionId"].Value = list[0].Rows[0]["unitconversionId"].ToString();
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtConversionRate"].Value = list[0].Rows[0]["conversionRate"].ToString();
decCurrentConversionRate = Convert.ToDecimal(dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtConversionRate"].Value.ToString());
//dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtqty"].Value = 0;
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvcmbTax"].Value = infoProductFill.TaxId;
AmountCalculation("dgvtxtqty", rowIndex);
decimal decProdtId = infoProductFill.ProductId;
decBatchId = BllStockPosting.BatchViewByProductId(decProdtId);
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvcmbBatch"].Value = decBatchId;
string strBarcode = Convert.ToString(BllProductCreation.BarcodeViewByBatchId(decBatchId));
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtbarcode"].Value = strBarcode;
if (dgvPurchaseReturn.Rows[rowIndex + 1].Cells["dgvtxtproductCode"].Selected == true)
{
dgvPurchaseReturn.Rows[rowIndex].Cells["dgvtxtqty"].Selected = true;
dgvPurchaseReturn.Rows[rowIndex + 1].Selected = false;
dgvPurchaseReturn.Rows[rowIndex].HeaderCell.Value = "X";
dgvPurchaseReturn.Rows[rowIndex].HeaderCell.Style.ForeColor = Color.Red;
}
}
}
catch (Exception ex)
{
MessageBox.Show("PR:22" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
///Function for ReturnFromProductCreationPopup
/// </summary>
public void ReturnFromProductCreation(decimal decProductId)
{
ProductInfo infoProduct = new ProductInfo();
ProductCreationBll BllProductCreation = new ProductCreationBll();
BatchBll BllBatch = new BatchBll();
List<DataTable> list = new List<DataTable>();
UnitConvertionBll bllUnitConvertion = new UnitConvertionBll();
try
{
this.Enabled = true;
this.BringToFront();
int inI = dgvProduct.CurrentRow.Index;
if (inI == dgvProduct.Rows.Count - 1)
{
dgvProduct.Rows.Add();
}
if (decProductId != 0)
{
infoProduct = BllProductCreation.ProductView(decProductId);
dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value = infoProduct.ProductCode.ToString();
dgvProduct.Rows[inI].Cells["dgvtxtProductId"].Value = decProductId.ToString();
dgvProduct.Rows[inI].Cells["dgvtxtProductName"].Value = infoProduct.ProductName;
dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value = infoProduct.SalesRate.ToString();
UnitComboFill1(decProductId, inI, dgvProduct.Rows[inI].Cells["dgvcmbUnit"].ColumnIndex);
dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
BatchComboFill(decProductId, inI, dgvProduct.Rows[inI].Cells["dgvcmbBatch"].ColumnIndex);
dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value = BllBatch.BatchIdViewByProductId(decProductId);
dgvProduct.Rows[inI].Cells["dgvtxtBarcode"].Value = BllBatch.ProductBatchBarcodeViewByBatchId(Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString()));
GridGodownComboFill(decProductId, dgvProduct.CurrentRow.Index, dgvProduct.Rows[inI].Cells["dgvcmbGodown"].ColumnIndex);
dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value = infoProduct.GodownId;
RackComboFill1(infoProduct.GodownId, inI, dgvProduct.Rows[inI].Cells["dgvcmbRack"].ColumnIndex);
dgvProduct.Rows[inI].Cells["dgvcmbRack"].Value = infoProduct.RackId;
list = bllUnitConvertion.DGVUnitConvertionRateByUnitId(infoProduct.UnitId, infoProduct.ProductName);
dgvProduct.Rows[inI].Cells["dgvtxtUnitConversionId"].Value = list[0].Rows[0]["unitconversionId"].ToString();
dgvProduct.Rows[inI].Cells["dgvtxtConversionRate"].Value = list[0].Rows[0]["conversionRate"].ToString();
decCurrentConversionRate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtConversionRate"].Value.ToString());
decCurrentRate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
AmountCalculation("dgvtxtQty", dgvProduct.CurrentRow.Index);
dgvProduct.Rows[inI].HeaderCell.Value = "X";
dgvProduct.Rows[inI].HeaderCell.Style.ForeColor = Color.Red;
TotalAmountCalculation();
}
}
catch (Exception ex)
{
MessageBox.Show("DN25:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the product details in dataGridView from productCreationPopup
/// </summary>
/// <param name="productcreation"></param>
/// <param name="decproductId"></param>
/// <param name="decCurrentRowIndex"></param>
public void productDetailsFillFromProductCreation(frmProductCreation productcreation, decimal decproductId, decimal decCurrentRowIndex)
{
try
{
decimal decCurrentConversionRate = 0;
UnitConvertionBll bllUnitConvertion = new UnitConvertionBll();
List<DataTable> list = new List<DataTable>();
BatchBll BllBatch = new BatchBll();
ProductInfo infoProductFill = new ProductInfo();
ProductCreationBll BllProductCreation = new ProductCreationBll();
ProductInfo infoProduct = new ProductInfo();
int inI = dgvPurchaseReturn.CurrentRow.Index;
if (inI == dgvPurchaseReturn.Rows.Count - 1)
{
dgvPurchaseReturn.Rows.Add();
}
if (decproductId != 0)
{
infoProduct = BllProductCreation.ProductView(decproductId);
SerialNo();
dgvPurchaseReturn.Rows[inI].Cells["dgvtxtproductCode"].Value = infoProduct.ProductCode;
dgvPurchaseReturn.Rows[inI].Cells["dgvtxtproductId"].Value = decproductId.ToString();
dgvPurchaseReturn.Rows[inI].Cells["dgvtxtproductName"].Value = infoProduct.ProductName;
dgvPurchaseReturn.Rows[inI].Cells["dgvcmbGodown"].Value = infoProduct.GodownId;
dgvPurchaseReturn.Rows[inI].Cells["dgvcmbRack"].Value = infoProduct.RackId;
UnitComboFill(infoProduct.ProductId, dgvPurchaseReturn.CurrentRow.Index, dgvPurchaseReturn.CurrentRow.Cells["dgvcmbUnit"].ColumnIndex);
dgvPurchaseReturn.Rows[inI].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
dgvPurchaseReturn.Rows[inI].Cells["dgvtxtrate"].Value = Math.Round(infoProduct.PurchaseRate, PublicVariables._inNoOfDecimalPlaces);
dgvPurchaseReturn.Rows[inI].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(new UnitConvertionBll().UnitconversionIdViewByUnitIdAndProductId(infoProduct.UnitId, infoProduct.ProductId));
dgvPurchaseReturn.CurrentRow.Cells["dgvtxtConversionRate"].Value = bllUnitConvertion.UnitConversionRateByUnitConversionId(Convert.ToDecimal(dgvPurchaseReturn.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString()));
BatchComboFill(decproductId, inI, dgvPurchaseReturn.Rows[inI].Cells["dgvcmbBatch"].ColumnIndex);
dgvPurchaseReturn.Rows[inI].Cells["dgvcmbBatch"].Value = BllBatch.BatchIdViewByProductId(decproductId);
RackComboFill(infoProduct.GodownId, inI, dgvPurchaseReturn.Rows[inI].Cells["dgvcmbRack"].ColumnIndex);
dgvPurchaseReturn.Rows[inI].Cells["dgvtxtqty"].Value = "0";
dgvPurchaseReturn.Rows[inI].Cells["dgvtxtbarcode"].Value = BllBatch.ProductBatchBarcodeViewByBatchId(Convert.ToDecimal(dgvPurchaseReturn.Rows[inI].Cells["dgvcmbBatch"].Value.ToString()));
list = bllUnitConvertion.DGVUnitConvertionRateByUnitId(infoProduct.UnitId, infoProduct.ProductName);
dgvPurchaseReturn.Rows[inI].Cells["dgvtxtConversionRate"].Value = list[0].Rows[0]["conversionRate"].ToString();
decCurrentConversionRate = Convert.ToDecimal(dgvPurchaseReturn.CurrentRow.Cells["dgvtxtConversionRate"].Value.ToString());
AmountCalculation("dgvtxtqty", inI);
dgvPurchaseReturn.Rows[inI].Cells["dgvtxtqty"].Selected = true;
dgvPurchaseReturn.Rows[inI + 1].Selected = false;
}
dgvPurchaseReturn.Rows[inI].HeaderCell.Value = "X";
dgvPurchaseReturn.Rows[inI].HeaderCell.Style.ForeColor = Color.Red;
}
catch (Exception ex)
{
MessageBox.Show("PR:24" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save an item into table
/// </summary>
public void Save()
{
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
SalesReturnBll bllSalesReturn = new SalesReturnBll();
StockPostingBll BllStockPosting = new StockPostingBll();
StockPostingBll BllStockPostingf = new StockPostingBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
UnitConvertionBll bllUnitConvertion = new UnitConvertionBll();
UnitBll bllUnit = new UnitBll();
try
{
if (txtReturnNo.Text.Trim() == string.Empty)
{
MessageBox.Show("Enter return no", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtReturnNo.Focus();
}
else if (bllSalesReturn.SalesReturnNumberCheckExistence(txtReturnNo.Text.Trim(), 0, decSalesReturnVoucherTypeId) == true && btnSave.Text == "Save")
{
Messages.InformationMessage("Return number already exist");
txtReturnNo.Focus();
}
else if (txtDate.Text == "")
{
MessageBox.Show("Select a date in between financial year", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtDate.Focus();
}
else if (cmbCashOrParty.SelectedValue == null)
{
MessageBox.Show("Select cash/party", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbCashOrParty.Focus();
}
else if (cmbSalesAccount.SelectedValue == null)
{
MessageBox.Show("Select sales account", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbSalesAccount.Focus();
}
else if (cmbCurrency.SelectedValue == null)
{
MessageBox.Show("Select currency", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbCurrency.Focus();
}
else
{
if (isAutomatic)
{
if (strVoucherNo != string.Empty)
{
infoSalesReturnMaster.VoucherNo = strVoucherNo;
}
if (txtReturnNo.Text != string.Empty)
{
infoSalesReturnMaster.InvoiceNo = txtReturnNo.Text;
}
}
else
{
infoSalesReturnMaster.VoucherNo = txtReturnNo.Text;
infoSalesReturnMaster.InvoiceNo = txtReturnNo.Text;
}
if (decSalesReturnVoucherTypeId != 0)
{
infoSalesReturnMaster.VoucherTypeId = decSalesReturnVoucherTypeId;
}
if (decSalesReturnSuffixPrefixId != 0)
{
infoSalesReturnMaster.SuffixPrefixId = decSalesReturnSuffixPrefixId;
}
if (cmbCashOrParty.SelectedValue != null)
{
infoSalesReturnMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
}
if (cmbInvoiceNo.SelectedValue != null)
{
infoSalesReturnMaster.SalesMasterId = Convert.ToDecimal(cmbInvoiceNo.SelectedValue.ToString());
}
else
{
infoSalesReturnMaster.SalesMasterId = 0;
}
if (cmbSalesAccount.SelectedValue != null)
{
infoSalesReturnMaster.SalesAccount = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
}
if (cmbPricingLevel.SelectedValue != null)
{
infoSalesReturnMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
}
else
{
infoSalesReturnMaster.PricinglevelId = 0;
}
if (cmbSalesMan.SelectedValue != null)
{
infoSalesReturnMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
else
{
infoSalesReturnMaster.EmployeeId = 0;
}
if (cmbCurrency.SelectedValue != null)
{
infoSalesReturnMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
decExchangeRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(infoSalesReturnMaster.ExchangeRateId);
}
infoSalesReturnMaster.Narration = txtNarration.Text.Trim();
infoSalesReturnMaster.UserId = PublicVariables._decCurrentUserId;
infoSalesReturnMaster.LrNo = txtLRNo.Text.Trim();
infoSalesReturnMaster.TransportationCompany = txtTransportationComp.Text.Trim();
infoSalesReturnMaster.Date = Convert.ToDateTime(txtDate.Text);
if (txtTotalAmount.Text != string.Empty)
{
infoSalesReturnMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
}
if (txtGrandTotal.Text != string.Empty)
{
infoSalesReturnMaster.grandTotal = Convert.ToDecimal(txtGrandTotal.Text);
}
if (lblTaxAmount.Text != string.Empty)
{
infoSalesReturnMaster.TaxAmount = Convert.ToDecimal(lblTaxAmount.Text);
}
infoSalesReturnMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoSalesReturnMaster.Extra1 = string.Empty;
infoSalesReturnMaster.Extra2 = string.Empty;
if (txtBillDiscount.Text != string.Empty)
{
infoSalesReturnMaster.Discount = Convert.ToDecimal(txtBillDiscount.Text);
}
else
{
infoSalesReturnMaster.Discount = 0;
}
decimal decNetTotal = 0;
decimal decGrandTotal = 0;
string strQuantities = string.Empty;
if (btnSave.Text == "Update")
{
infoSalesReturnMaster.SalesReturnMasterId = decSalesReturnMasterId;
bllSalesReturn.SalesReturnMasterEdit(infoSalesReturnMaster);
BllLedgerPosting.LedgerPostingAndPartyBalanceDeleteByVoucherTypeIdAndLedgerIdAndVoucherNo(decSalesReturnVoucherTypeId, strVoucherNo, txtReturnNo.Text);
BllLedgerPosting.LedgerPostingAndPartyBalanceDeleteByVoucherTypeIdAndLedgerIdAndVoucherNo(decSalesReturnVoucherTypeId, strVoucherNo, txtReturnNo.Text);
BllStockPosting.StockPostingDeleteByVoucherTypeAndVoucherNo(strVoucherNo, decSalesReturnVoucherTypeId);
bllSalesReturnBill.SalesReturnBillTaxDeleteBySalesReturnMasterId(decSalesReturnMasterId);
}
else
{
decSalesReturnMasterId = bllSalesReturn.SalesReturnMasterAdd(infoSalesReturnMaster);
}
SalesReturnDetailsInfo infoSalesReturnDetailsInfo = new SalesReturnDetailsInfo();
infoSalesReturnDetailsInfo.Extra1 = string.Empty;
infoSalesReturnDetailsInfo.Extra2 = string.Empty;
if (btnSave.Text == "Update")
{
foreach (var strId in lstArrOfRemove)
{
decimal decDeleteId = Convert.ToDecimal(strId);
bllSalesReturn.SalesReturnDetailsDelete(decDeleteId);
}
}
foreach (DataGridViewRow DGVSalesReturn in dgvSalesReturn.Rows)
{
if (DGVSalesReturn.Cells["productId"].Value != null && DGVSalesReturn.Cells["productId"].Value.ToString() != string.Empty)
{
infoSalesReturnDetailsInfo.SalesReturnMasterId = decSalesReturnMasterId;
infoSalesReturnDetailsInfo.ProductId = Convert.ToDecimal(DGVSalesReturn.Cells["productId"].Value.ToString());
if (DGVSalesReturn.Cells["dgvTextQty"].Value != null)
{
infoSalesReturnDetailsInfo.Qty = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextQty"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextRate"].Value != null)
{
infoSalesReturnDetailsInfo.Rate = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextRate"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvCmbUnit"].Value != null)
{
infoSalesReturnDetailsInfo.UnitId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbUnit"].Value.ToString());
}
if (DGVSalesReturn.Cells["unitConversionId"].Value != null)
{
infoSalesReturnDetailsInfo.UnitConversionId = Convert.ToDecimal(DGVSalesReturn.Cells["unitConversionId"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextDiscountAmount"].Value != null)
{
infoSalesReturnDetailsInfo.Discount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextDiscountAmount"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvCmbTax"].Value != null)
{
infoSalesReturnDetailsInfo.TaxId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbTax"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.TaxId = 0;
}
if (DGVSalesReturn.Cells["dgvCmbBatch"].Value != null)
{
infoSalesReturnDetailsInfo.BatchId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbBatch"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.BatchId = 0;
}
if (DGVSalesReturn.Cells["dgvCmbBatch"].Value != null)
{
infoSalesReturnDetailsInfo.BatchId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbBatch"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.BatchId = 0;
}
if (DGVSalesReturn.Cells["dgvCmbGodown"].Value != null)
{
infoSalesReturnDetailsInfo.GodownId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbGodown"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.GodownId = 0;
}
if (DGVSalesReturn.Cells["dgvCmbRack"].Value != null)
{
infoSalesReturnDetailsInfo.RackId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbRack"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.RackId = 0;
}
if (DGVSalesReturn.Cells["dgvTextTaxAmount"].Value != null)
{
infoSalesReturnDetailsInfo.TaxAmount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextTaxAmount"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextGrossValue"].Value != null)
{
infoSalesReturnDetailsInfo.GrossAmount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextGrossValue"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextNetValue"].Value != null)
{
infoSalesReturnDetailsInfo.NetAmount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextNetValue"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextAmount1"].Value != null)
{
infoSalesReturnDetailsInfo.Amount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextAmount1"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvSNo"].Value != null)
{
infoSalesReturnDetailsInfo.SlNo = Convert.ToInt32(DGVSalesReturn.Cells["dgvSNo"].Value.ToString());
}
if (DGVSalesReturn.Cells["salesDetailsId"].Value != null && cmbInvoiceNo.SelectedValue != null)
{
infoSalesReturnDetailsInfo.SalesDetailsId = Convert.ToDecimal(DGVSalesReturn.Cells["salesDetailsId"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.SalesDetailsId = 0;
}
if (DGVSalesReturn.Cells["salesReturnDetailsId"].Value != null)
{
infoSalesReturnDetailsInfo.SalesReturnDetailsId = Convert.ToDecimal(DGVSalesReturn.Cells["salesReturnDetailsId"].Value.ToString());
bllSalesReturn.SalesReturnDetailsEdit(infoSalesReturnDetailsInfo);
}
else
{
decSalesReturnDetailId = bllSalesReturn.SalesReturnDetailsAdd(infoSalesReturnDetailsInfo);
}
StockPostingInfo infoStockPosting = new StockPostingInfo();
infoStockPosting.Date = infoSalesReturnMaster.Date;
if (DGVSalesReturn.Cells["voucherTypeId"].Value != null)
{
infoStockPosting.VoucherTypeId = Convert.ToDecimal(DGVSalesReturn.Cells["voucherTypeId"].Value.ToString());
decAgainstVoucherTypeId = infoStockPosting.VoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = decSalesReturnVoucherTypeId;
}
else
{
infoStockPosting.VoucherTypeId = decSalesReturnVoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = 0;
}
if (DGVSalesReturn.Cells["voucherNo"].Value != null)
{
infoStockPosting.VoucherNo = DGVSalesReturn.Cells["voucherNo"].Value.ToString();
strAgainstVoucherNo = infoStockPosting.VoucherNo;
infoStockPosting.AgainstVoucherNo = strVoucherNo;
}
else
{
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.AgainstVoucherNo = "NA";
}
if (DGVSalesReturn.Cells["invoiceNo"].Value != null)
{
infoStockPosting.InvoiceNo = DGVSalesReturn.Cells["invoiceNo"].Value.ToString();
strAgainstInvoiceNo = infoStockPosting.InvoiceNo;
infoStockPosting.AgainstInvoiceNo = txtReturnNo.Text.Trim();
}
else
{
infoStockPosting.InvoiceNo = txtReturnNo.Text;
infoStockPosting.AgainstInvoiceNo = "NA";
}
infoStockPosting.ProductId = infoSalesReturnDetailsInfo.ProductId;
infoStockPosting.BatchId = infoSalesReturnDetailsInfo.BatchId;
infoStockPosting.UnitId = infoSalesReturnDetailsInfo.UnitId;
infoStockPosting.GodownId = infoSalesReturnDetailsInfo.GodownId;
infoStockPosting.RackId = infoSalesReturnDetailsInfo.RackId;
if (infoSalesReturnDetailsInfo.ProductId != 0 && infoSalesReturnDetailsInfo.UnitId != 0)
{
decimal decUnitConvertionRate = 0;
infoProduct = BllProductCreation.ProductView(infoSalesReturnDetailsInfo.ProductId);
List< DataTable> list = bllUnitConvertion.DGVUnitConvertionRateByUnitId(infoSalesReturnDetailsInfo.UnitId, infoProduct.ProductName);
foreach (DataRow drowDetails in list[0].Rows)
{
decUnitConvertionRate = Convert.ToDecimal(drowDetails["conversionRate"].ToString());
}
strQuantities = bllUnit.UnitConversionCheck(infoSalesReturnDetailsInfo.UnitId, infoSalesReturnDetailsInfo.ProductId);
if (strQuantities != string.Empty)
{
infoStockPosting.InwardQty = infoSalesReturnDetailsInfo.Qty / decUnitConvertionRate;
}
else
{
infoStockPosting.InwardQty = infoSalesReturnDetailsInfo.Qty;
}
}
infoStockPosting.OutwardQty = 0;
infoStockPosting.Rate = infoSalesReturnDetailsInfo.Rate;
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
BllStockPosting.StockPostingAdd(infoStockPosting);
}
}
decGrandTotal = Convert.ToDecimal(txtGrandTotal.Text);
decNetTotal = TotalNetAmountForLedgerPosting();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
infoLedgerPosting.Date = infoSalesReturnMaster.Date;
infoLedgerPosting.ChequeDate = infoSalesReturnMaster.Date;
infoLedgerPosting.ChequeNo = String.Empty;
infoLedgerPosting.VoucherTypeId = infoSalesReturnMaster.VoucherTypeId;
infoLedgerPosting.VoucherNo = infoSalesReturnMaster.VoucherNo;
infoLedgerPosting.LedgerId = infoSalesReturnMaster.LedgerId;
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = (decGrandTotal * decExchangeRate);
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.InvoiceNo = infoSalesReturnMaster.InvoiceNo;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
infoLedgerPosting.LedgerId = infoSalesReturnMaster.SalesAccount;
infoLedgerPosting.Debit = (decNetTotal * decExchangeRate);
infoLedgerPosting.Credit = 0;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
if (Convert.ToDecimal(txtBillDiscount.Text == string.Empty ? "0" : txtBillDiscount.Text) > 0)
{
infoLedgerPosting.LedgerId = 8;
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = (Convert.ToDecimal(txtBillDiscount.Text) * decExchangeRate);
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
LedegrPostingForTax();
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
infoPartyBalance.Date = infoSalesReturnMaster.Date;
infoPartyBalance.LedgerId = infoSalesReturnMaster.LedgerId;
if (decAgainstVoucherTypeId != 0)
{
infoPartyBalance.VoucherTypeId = decAgainstVoucherTypeId;
infoPartyBalance.VoucherNo = strAgainstVoucherNo;
infoPartyBalance.InvoiceNo = strAgainstInvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = infoSalesReturnMaster.VoucherTypeId;
infoPartyBalance.AgainstVoucherNo = infoSalesReturnMaster.VoucherNo;
infoPartyBalance.AgainstInvoiceNo = infoSalesReturnMaster.InvoiceNo;
infoPartyBalance.ReferenceType = "Against";
}
else
{
infoPartyBalance.VoucherTypeId = infoSalesReturnMaster.VoucherTypeId;
infoPartyBalance.VoucherNo = infoSalesReturnMaster.VoucherNo;
infoPartyBalance.InvoiceNo = infoSalesReturnMaster.InvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = 0;
infoPartyBalance.AgainstVoucherNo = "NA";
infoPartyBalance.AgainstInvoiceNo = "NA";
infoPartyBalance.ReferenceType = "New";
}
infoPartyBalance.Credit = infoSalesReturnMaster.TotalAmount;
infoPartyBalance.Debit = 0;
infoPartyBalance.CreditPeriod = 0;
infoPartyBalance.ExchangeRateId = infoSalesReturnMaster.ExchangeRateId;
infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPartyBalance.Extra1 = string.Empty;
infoPartyBalance.Extra2 = string.Empty;
BllPartyBalance.PartyBalanceAdd(infoPartyBalance);
SalesReturnBillTaxInfo infoSalesReturnBillTax = new SalesReturnBillTaxInfo();
foreach (DataGridViewRow item in dgvSalesReturn2.Rows)
{
if (item.Cells["dgvTextTaxId"].Value != null)
{
infoSalesReturnBillTax.SalesReturnMasterId = decSalesReturnMasterId;
infoSalesReturnBillTax.TaxId = Convert.ToDecimal(item.Cells["dgvTextTaxId"].Value.ToString());
infoSalesReturnBillTax.TaxAmount = Convert.ToDecimal(item.Cells["dgvTextAmount"].Value.ToString());
infoSalesReturnBillTax.Extra1 = string.Empty;
infoSalesReturnBillTax.Extra2 = string.Empty;
bllSalesReturnBill.SalesReturnBillTaxAdd(infoSalesReturnBillTax);
}
}
if (btnSave.Text == "Save")
{
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked == true)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesReturnMasterId);
}
else
{
Print(decSalesReturnMasterId);
}
}
clear();
}
else
{
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked == true)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesReturnMasterId);
}
else
{
Print(decSalesReturnMasterId);
}
}
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("SR36:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// To select the product from ProductSearchPopup
/// </summary>
/// <param name="frmProductSearchPopup"></param>
/// <param name="decproductId"></param>
/// <param name="decCurrentRowIndex"></param>
public void CallFromProductSearchPopup(frmProductSearchPopup frmProductSearchPopup, decimal decproductId, decimal decCurrentRowIndex)
{
ProductInfo infoProduct = new ProductInfo();
ProductCreationBll BllProductCreation = new ProductCreationBll();
UnitConvertionBll bllUnitConvertion = new UnitConvertionBll();
BatchBll BllBatch = new BatchBll();
try
{
base.Show();
this.frmProductSearchPopupObj = frmProductSearchPopup;
infoProduct = BllProductCreation.ProductView(decproductId);
int inRowcount = dgvProduct.Rows.Count;
for (int i = 0; i < inRowcount; i++)
{
if (i == inRowcount - 1)
{
dgvProduct.Rows.Add();
}
if (i == decCurrentRowIndex)
{
SerialNo();
dgvProduct.Rows[i].Cells["dgvtxtproductCode"].Value = infoProduct.ProductCode;
dgvProduct.Rows[i].Cells["productId"].Value = decproductId.ToString();
dgvProduct.Rows[i].Cells["dgvtxtProductName"].Value = infoProduct.ProductName;
dgvProduct.Rows[i].Cells["dgvcmbGodown"].Value = infoProduct.GodownId;
dgvProduct.Rows[i].Cells["dgvCmbRack"].Value = infoProduct.RackId;
UnitComboFill(decproductId, i, dgvProduct.Rows[i].Cells["dgvcmbUnit"].ColumnIndex);
dgvProduct.Rows[i].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
List<DataTable> list = new List<DataTable>();
list = bllUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvProduct.Rows[i].Cells["productId"].Value.ToString());
dgvProduct.Rows[i].Cells["dgvtxtRate"].Value = Math.Round(infoProduct.PurchaseRate, PublicVariables._inNoOfDecimalPlaces);
dgvProduct.Rows[i].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(new UnitConvertionBll().UnitconversionIdViewByUnitIdAndProductId(infoProduct.UnitId, infoProduct.ProductId));
dgvProduct.CurrentRow.Cells["dgvtxtConversionRate"].Value = bllUnitConvertion.UnitConversionRateByUnitConversionId(Convert.ToDecimal(dgvProduct.Rows[i].Cells["dgvtxtUnitConversionId"].Value.ToString()));
BatchComboFill(decproductId, i, dgvProduct.Rows[i].Cells["dgvcmbBatch"].ColumnIndex);
dgvProduct.Rows[i].Cells["dgvcmbBatch"].Value = BllBatch.BatchIdViewByProductId(decproductId);
RackComboFill(infoProduct.GodownId, i, dgvProduct.Rows[i].Cells["dgvCmbRack"].ColumnIndex);
dgvProduct.Rows[i].Cells["dgvtxtBarcode"].Value = BllBatch.ProductBatchBarcodeViewByBatchId(Convert.ToDecimal(dgvProduct.Rows[i].Cells["dgvcmbBatch"].Value.ToString()));
list= bllUnitConvertion.DGVUnitConvertionRateByUnitId(infoProduct.UnitId, infoProduct.ProductName);
dgvProduct.Rows[i].Cells["dgvtxtConversionRate"].Value = list[0].Rows[0]["conversionRate"].ToString();
decCurrentConversionRate = Convert.ToDecimal(dgvProduct.CurrentRow.Cells["dgvtxtConversionRate"].Value.ToString());
NewAmountCalculation("dgvtxtQty", i);
CalculateTotalAmount();
}
}
frmProductSearchPopupObj.Close();
frmProductSearchPopupObj = null;
}
catch (Exception ex)
{
MessageBox.Show("MR4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the product details in dataGridView from productCreationPopup
/// </summary>
/// <param name="productcreation"></param>
/// <param name="decproductId"></param>
/// <param name="decCurrentRowIndex"></param>
public void productDetailsFillFromProductCreation(frmProductCreation productcreation, decimal decproductId, decimal decCurrentRowIndex)
{
try
{
decimal decCurrentConversionRate = 0;
DataTable dtbl = new DataTable();
UnitConvertionBll bllUnitConvertion = new UnitConvertionBll();
BatchBll BllBatch = new BatchBll();
ProductInfo infoProductFill = new ProductInfo();
ProductCreationBll BllProductCreation = new ProductCreationBll();
ProductInfo infoProduct = new ProductInfo();
int inI = dgvProduct.CurrentRow.Index;
if (inI == dgvProduct.Rows.Count - 1)
{
dgvProduct.Rows.Add();
}
if (decproductId != 0)
{
infoProduct = BllProductCreation.ProductView(decproductId);
SerialNo();
dgvProduct.Rows[inI].Cells["dgvtxtproductCode"].Value = infoProduct.ProductCode;
dgvProduct.Rows[inI].Cells["productId"].Value = decproductId.ToString();
dgvProduct.Rows[inI].Cells["dgvtxtProductName"].Value = infoProduct.ProductName;
dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value = infoProduct.GodownId;
dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value = infoProduct.RackId;
UnitComboFill(decproductId, inI, dgvProduct.Rows[inI].Cells["dgvcmbUnit"].ColumnIndex);
dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
List<DataTable> list = new List<DataTable>();
list = bllUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvProduct.Rows[inI].Cells["productId"].Value.ToString());
//UnitComboFill(infoProduct.ProductId, dgvProduct.CurrentRow.Index, dgvProduct.CurrentRow.Cells["dgvcmbUnit"].ColumnIndex);
//dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value = Math.Round(infoProduct.PurchaseRate, PublicVariables._inNoOfDecimalPlaces);
dgvProduct.Rows[inI].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(new UnitConvertionBll().UnitconversionIdViewByUnitIdAndProductId(infoProduct.UnitId, infoProduct.ProductId));
dgvProduct.CurrentRow.Cells["dgvtxtConversionRate"].Value = bllUnitConvertion.UnitConversionRateByUnitConversionId(Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString()));
BatchComboFill(decproductId, inI, dgvProduct.Rows[inI].Cells["dgvcmbBatch"].ColumnIndex);
dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value = BllBatch.BatchIdViewByProductId(decproductId);
RackComboFill(infoProduct.GodownId, inI, dgvProduct.Rows[inI].Cells["dgvCmbRack"].ColumnIndex);
dgvProduct.Rows[inI].Cells["dgvtxtBarcode"].Value = BllBatch.ProductBatchBarcodeViewByBatchId(Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString()));
list = bllUnitConvertion.DGVUnitConvertionRateByUnitId(infoProduct.UnitId, infoProduct.ProductName);
dgvProduct.Rows[inI].Cells["dgvtxtConversionRate"].Value = dtbl.Rows[0]["conversionRate"].ToString();
decCurrentConversionRate = Convert.ToDecimal(dgvProduct.CurrentRow.Cells["dgvtxtConversionRate"].Value.ToString());
NewAmountCalculation("dgvtxtQty", inI);
CalculateTotalAmount();
}
}
catch (Exception ex)
{
MessageBox.Show("MR6:new" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to call frmProductSearchPopup form to select and view Product
/// </summary>
/// <param name="frmProductSearchPopup"></param>
/// <param name="decproductId"></param>
/// <param name="decCurrentRowIndex"></param>
public void CallFromProductSearchPopup(frmProductSearchPopup frmProductSearchPopup, decimal decproductId, decimal decCurrentRowIndex)
{
UnitConvertionBll bllUnitConversion = new UnitConvertionBll();
try
{
this.frmProductSearchPopupObj = frmProductSearchPopup;
List<DataTable> list = new List<DataTable>();
BatchBll BllBatch = new BatchBll();
ProductCreationBll BllProductCreation = new ProductCreationBll();
if (decproductId != 0)
{
infoProduct = BllProductCreation.ProductView(decproductId);
dgvSalesOrder.CurrentRow.Cells["dgvtxtProductCode"].Value = infoProduct.ProductCode.ToString();
dgvSalesOrder.CurrentRow.Cells["dgvtxtProductId"].Value = decproductId.ToString();
dgvSalesOrder.CurrentRow.Cells["dgvtxtProductName"].Value = infoProduct.ProductName;
dgvSalesOrder.CurrentRow.Cells["dgvtxtRate"].Value = infoProduct.SalesRate.ToString();
UnitComboFill(decproductId, dgvSalesOrder.CurrentRow.Index, dgvSalesOrder.CurrentRow.Cells["dgvcmbUnit"].ColumnIndex);
dgvSalesOrder.CurrentRow.Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
BatchComboFill(decproductId, dgvSalesOrder.CurrentRow.Index, dgvSalesOrder.CurrentRow.Cells["dgvcmbBatch"].ColumnIndex);
dgvSalesOrder.CurrentRow.Cells["dgvcmbBatch"].Value = BllBatch.BatchIdViewByProductId(decproductId);
dgvSalesOrder.CurrentRow.Cells["dgvtxtBarcode"].Value = BllBatch.ProductBatchBarcodeViewByBatchId(Convert.ToDecimal(dgvSalesOrder.CurrentRow.Cells["dgvcmbBatch"].Value.ToString()));
list = bllUnitConversion.DGVUnitConvertionRateByUnitId(infoProduct.UnitId, infoProduct.ProductName);
dgvSalesOrder.CurrentRow.Cells["dgvtxtUnitConversionId"].Value = list[0].Rows[0]["unitconversionId"].ToString();
dgvSalesOrder.CurrentRow.Cells["dgvtxtConversionRate"].Value = list[0].Rows[0]["conversionRate"].ToString();
decCurrentConversionRate = Convert.ToDecimal(dgvSalesOrder.CurrentRow.Cells["dgvtxtConversionRate"].Value.ToString());
decCurrentRate = Convert.ToDecimal(dgvSalesOrder.CurrentRow.Cells["dgvtxtRate"].Value.ToString());
AmountCalculation("dgvtxtQty", dgvSalesOrder.CurrentRow.Index);
TotalAmountCalculation();
}
frmProductSearchPopupObj.Close();
frmProductSearchPopupObj = null;
this.Enabled = true;
this.BringToFront();
}
catch (Exception ex)
{
MessageBox.Show("S10:" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
