/// <summary>
/// Function to fill additional cost combo box
/// </summary>
/// <param name="inRowIndex"></param>
public void AdditionalCostComboFill(int inRowIndex)
{
List<DataTable> ListObj = new List<DataTable>();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
ListObj = BllPurchaseInvoice.AccountLedgerViewForAdditionalCost();
DataRow drow = ListObj[0].NewRow();
drow["ledgerName"] = string.Empty;
drow["ledgerId"] = 0;
ListObj[0].Rows.InsertAt(drow, 0);
if (dgvAdditionalCost.RowCount > 1)
{
foreach (DataGridViewRow dgvrow in dgvAdditionalCost.Rows)
{
foreach (DataRow drow1 in ListObj[0].Rows)
{
if (dgvrow.Index != inRowIndex)
{
if (dgvrow.Cells["dgvcmbLedger"].Value != null)
{
if (drow1["ledgerId"].ToString() == dgvrow.Cells["dgvcmbLedger"].Value.ToString())
{
ListObj[0].Rows.RemoveAt(ListObj[0].Rows.IndexOf(drow1));
break;
}
}
}
}
}
}
DataGridViewComboBoxCell dgvcmbLedgerCell = (DataGridViewComboBoxCell)dgvAdditionalCost.Rows[inRowIndex].Cells[dgvAdditionalCost.Columns["dgvcmbLedger"].Index];
dgvcmbLedgerCell.DataSource = ListObj[0];
dgvcmbLedgerCell.DisplayMember = "ledgerName";
dgvcmbLedgerCell.ValueMember = "ledgerId";
}
catch (Exception ex)
{
MessageBox.Show("PI25:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Grid CellEndEdit for product details fill to curresponding row in grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvPurchaseReturn_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
try
{
string strBarcode2 = string.Empty;
decimal decBatchId2 = 0;
BatchBll BllBatch = new BatchBll();
RackBll BllRack = new RackBll();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
PurchaseReturnBll BllPurchaseReturn = new PurchaseReturnBll();
ProductCreationBll BllProductCreation = new ProductCreationBll();
if (dgvPurchaseReturn.Columns[e.ColumnIndex].Name == "dgvtxtproductName")
{
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductName"].Value != null && dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductName"].Value.ToString().Trim() != string.Empty)
{
ProductInfo infoProduct = BllProductCreation.ProductViewByName(dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductName"].Value.ToString());
if (infoProduct.ProductCode != null && infoProduct.ProductCode != string.Empty)
{
FillProductDetails(infoProduct.ProductCode.ToString(), e.RowIndex);
}
else
{
StringEmptyDetailsInGrid();
}
}
else
{
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductName"].Value = string.Empty;
}
}
else if (dgvPurchaseReturn.Columns[e.ColumnIndex].Name == "dgvtxtproductCode")
{
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductCode"].Value != null && dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductCode"].Value.ToString().Trim() != string.Empty)
{
ProductInfo infoProduct = BllProductCreation.ProductViewByCode(dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductCode"].Value.ToString());
if (infoProduct.ProductName != null && infoProduct.ProductCode != string.Empty)
{
FillProductDetails(infoProduct.ProductCode.ToString(), e.RowIndex);
}
else
{
StringEmptyDetailsInGrid();
}
}
else
{
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductCode"].Value = string.Empty;
}
}
else if (dgvPurchaseReturn.Columns[e.ColumnIndex].Name == "dgvtxtbarcode")
{
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtbarcode"].Value != null && dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtbarcode"].Value.ToString().Trim() != string.Empty)
{
string strBarcode = dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtbarcode"].Value.ToString();
decBatchId = BllProductCreation.BatchIdByPartNoOrBarcode(strBarcode, strBarcode);
if (decBatchId > 0)
{
List<DataTable> listObjBatchName = new List<DataTable>();
listObjBatchName = BllProductCreation.ProductCodeAndBarcodeByBatchId(decBatchId);
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductCode"].Value = listObjBatchName[0].Rows[0]["productCode"].ToString();
if (listObjBatchName[0].Rows[0]["barcode"].ToString() != null && listObjBatchName[0].Rows[0]["barcode"].ToString() != string.Empty)
{
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtbarcode"].Value = listObjBatchName[0].Rows[0]["barcode"].ToString();
}
decimal batchId = BllBatch.BatchViewByBarcode(strBarcode);
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = batchId;
FillProductDetails(listObjBatchName[0].Rows[0]["productCode"].ToString(), e.RowIndex);
}
else
{
StringEmptyDetailsInGrid();
}
}
else
{
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtbarcode"].Value = string.Empty;
}
}
if (e.ColumnIndex == dgvPurchaseReturn.Columns["dgvcmbUnit"].Index)
{
if (dgvPurchaseReturn.Columns[e.ColumnIndex].Name == "dgvcmbUnit")
{
if ((dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value != null) && (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() != string.Empty))
{
UnitConversionCalc(e.RowIndex);
AmountCalculation("dgvtxtqty", e.RowIndex);
}
}
}
if (dgvPurchaseReturn.Columns[e.ColumnIndex].Name == "dgvtxtqty" && isAmountcalc)
{
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value != null && dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value.ToString() != string.Empty && Convert.ToDecimal(dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value.ToString()) != 0)
{
if (cmbInvoiceNo.SelectedValue == null || cmbInvoiceNo.SelectedValue.ToString() == string.Empty)
{
AmountCalculation("dgvtxtqty", e.RowIndex);
}
else
{
List<DataTable> ListObj= BllPurchaseInvoice.PurchaseDetailsViewByPurchaseMasterIdWithRemaining(Convert.ToDecimal(cmbInvoiceNo.SelectedValue.ToString()), decPurchaseReturnMasterId, decPurchaseReturnVoucherTypeId);
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtPurchaseDetailsId"].Value != null)
{
if (Convert.ToDecimal(dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtPurchaseDetailsId"].Value.ToString()) > 0)
{
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value != null)
{
if (Convert.ToDecimal(dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value.ToString()) > Convert.ToDecimal(ListObj[0].Rows[e.RowIndex]["qty"].ToString()))
{
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value = Math.Round(Convert.ToDecimal(ListObj[0].Rows[e.RowIndex]["qty"].ToString()), PublicVariables._inNoOfDecimalPlaces);
}
}
}
}
AmountCalculation("dgvtxtqty", e.RowIndex);
}
}
}
else if (dgvPurchaseReturn.Columns[e.ColumnIndex].Name == "dgvtxtrate" && isAmountcalc)
{
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value != null && dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value.ToString() != string.Empty && Convert.ToDecimal(dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value.ToString()) != 0)
{
AmountCalculation("dgvtxtrate", e.RowIndex);
}
}
else if (dgvPurchaseReturn.Columns[e.ColumnIndex].Name == "dgvtxtdiscount")
{
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtdiscount"].Value != null && dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtdiscount"].Value.ToString().Trim() != string.Empty && dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtDiscount"].Value.ToString().Trim() != "0")
{
AmountCalculation("dgvtxtrate", e.RowIndex);
}
}
else if (dgvPurchaseReturn.Columns[e.ColumnIndex].Name == "dgvcmbTax" && isAmountcalc)
{
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvcmbTax"].Value != null && dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvcmbTax"].Value.ToString() != string.Empty)
{
AmountCalculation("dgvtxtrate", e.RowIndex);
}
}
else if (dgvPurchaseReturn.Columns[e.ColumnIndex].Name == "dgvcmbBatch")
{
if (dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value != null && dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
decBatchId2 = Convert.ToDecimal(dgvPurchaseReturn.CurrentRow.Cells["dgvcmbBatch"].Value);
strBarcode2 = BllBatch.ProductBatchBarcodeViewByBatchId(decBatchId2);
dgvPurchaseReturn.CurrentRow.Cells["dgvtxtbarcode"].Value = strBarcode2;
}
}
CheckInvalidEntries(e);
}
catch (Exception ex)
{
MessageBox.Show("PR:80" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Product Details fill in the grid here
/// </summary>
/// <param name="strProduct"></param>
/// <param name="inRowIndex"></param>
/// <param name="strFillMode"></param>
public void ProductDetailsFill(string strProduct, int inRowIndex, string strFillMode)
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
List<DataTable> listObj = new List<DataTable>();
try
{
gridCombofill();
if (strFillMode == "ProductCode")
{
listObj = BllSalesInvoice.SalesInvoiceDetailsViewByProductCodeForSI(DecSalesInvoiceVoucherTypeId, strProduct);
}
else if (strFillMode == "ProductName")
{
listObj = BllSalesInvoice.SalesInvoiceDetailsViewByProductNameForSI(DecSalesInvoiceVoucherTypeId, strProduct);
}
else if (strFillMode == "Barcode")
{
listObj = BllSalesInvoice.SalesInvoiceDetailsViewByBarcodeForSI(DecSalesInvoiceVoucherTypeId, strProduct);
}
if (listObj[0].Rows.Count != 0)
{
IsSetGridValueChange = false;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceSalesDetailsId"].Value = listObj[0].Rows[0]["salseDetailsId"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSISalesOrderDetailsId"].Value = listObj[0].Rows[0]["salesOrderDetailsId"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceDeliveryNoteDetailsId"].Value = listObj[0].Rows[0]["deliveryNoteDetailsId"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceQuotationDetailsId"].Value = listObj[0].Rows[0]["salesQuotationDetailsId"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceProductId"].Value = listObj[0].Rows[0]["productId"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceBrand"].Value = listObj[0].Rows[0]["brandName"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoicePurchaseRate"].Value = listObj[0].Rows[0]["purchaseRate"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceSalesRate"].Value = listObj[0].Rows[0]["salesRate"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceMrp"].Value = listObj[0].Rows[0]["Mrp"];
decimal decProductId = Convert.ToDecimal(dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceProductId"].Value.ToString());
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceBarcode"].Value = listObj[0].Rows[0]["barcode"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceProductCode"].Value = listObj[0].Rows[0]["productCode"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceProductName"].Value = listObj[0].Rows[0]["productName"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoicembUnitName"].Value = Convert.ToDecimal(listObj[0].Rows[0]["unitId"].ToString());
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceUnitConversionId"].Value = listObj[0].Rows[0]["unitConversionId"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvcmbSalesInvoiceBatch"].Value = Convert.ToDecimal(listObj[0].Rows[0]["batchId"].ToString());
decimal decBatchId = Convert.ToDecimal(dgvSalesInvoice.Rows[inRowIndex].Cells["dgvcmbSalesInvoiceBatch"].Value.ToString());
getProductRate(inRowIndex, decProductId, decBatchId);
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvcmbSalesInvoiceGodown"].Value = Convert.ToDecimal(listObj[0].Rows[0]["godownId"].ToString());
RackComboFill(Convert.ToDecimal(dgvSalesInvoice.Rows[inRowIndex].Cells["dgvcmbSalesInvoiceGodown"].Value.ToString()), inRowIndex, dgvSalesInvoice.Rows[inRowIndex].Cells["dgvcmbSalesInvoiceRack"].ColumnIndex);
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvcmbSalesInvoiceRack"].Value = Convert.ToDecimal(listObj[0].Rows[0]["rackId"].ToString());
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceDiscountPercentage"].Value = listObj[0].Rows[0]["discountPercent"].ToString();
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceDiscountAmount"].Value = listObj[0].Rows[0]["discount"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceNetAmount"].Value = listObj[0].Rows[0]["netvalue"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvcmbSalesInvoiceTaxName"].Value = listObj[0].Rows[0]["taxId"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceTaxAmount"].Value = listObj[0].Rows[0]["taxAmount"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceAmount"].Value = listObj[0].Rows[0]["amount"];
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceConversionRate"].Value = listObj[0].Rows[0]["conversionRate"];
GrossValueCalculation(inRowIndex);
DiscountCalculation(inRowIndex, 22);
DiscountCalculation(inRowIndex, 23);
taxAndGridTotalAmountCalculation(inRowIndex);
decCurrentRate = Convert.ToDecimal(dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceRate"].Value.ToString());
decCurrentConversionRate = Convert.ToDecimal(listObj[0].Rows[0]["conversionRate"].ToString());
UnitConversionCalc(inRowIndex);
SiGridTotalAmountCalculation();
IsSetGridValueChange = true;
}
//else
//{
//if (strProductCode != string.Empty)
//{
// ProductDetailsFill(strProduct, inRowIndex, "ProductCode");
//}
else
{
if (dgvSalesInvoice.CurrentRow.Index < dgvSalesInvoice.RowCount - 1)
{
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSISalesOrderDetailsId"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceDeliveryNoteDetailsId"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceQuotationDetailsId"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceProductId"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceBarcode"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceProductCode"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceProductName"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceBrand"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceQty"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceUnitConversionId"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoicePurchaseRate"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceSalesRate"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceMrp"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceDiscountAmount"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceNetAmount"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceBrand"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceTaxAmount"].Value = string.Empty;
dgvSalesInvoice.Rows[inRowIndex].Cells["dgvtxtSalesInvoiceAmount"].Value = string.Empty;
SerialNoforSalesInvoice();
}
}
//}
}
catch (Exception ex)
{
MessageBox.Show("SI: 60" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Purchase Account combobox
/// </summary>
public void PurchaseAccountComboFill()
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
List<DataTable> ListObj = new List<DataTable>();
ListObj = BllPurchaseInvoice.PurchaseInvoicePurchaseAccountFill();
cmbPurchaseAccount.DataSource = ListObj[0];
cmbPurchaseAccount.DisplayMember = "ledgerName";
cmbPurchaseAccount.ValueMember = "ledgerId";
if (ListObj[0].Rows.Count > 0)
{
cmbPurchaseAccount.SelectedIndex = 0;
cmbPurchaseAccount.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("PR:03" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Function for Save and Edit
/// </summary>
public void SaveOrEdit()
{
try
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
PurchaseReturnBll BllPurchaseReturn = new PurchaseReturnBll();
PurchaseReturnDetailsInfo infoPurchaseReturnDetails = new PurchaseReturnDetailsInfo();
StockPostingInfo infoStockPosting = new StockPostingInfo();
//StockPostingSP spStockPosting = new StockPostingSP();
StockPostingBll BllStockPosting = new StockPostingBll();
UnitConvertionBll BllUnitConvertion = new UnitConvertionBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
PurchaseReturnBilltaxInfo infoPurchaseReturnBillTax = new PurchaseReturnBilltaxInfo();
SettingsBll BllSettings = new SettingsBll();
UnitBll bllUnit = new UnitBll();
List<DataTable> ListObj = new List<DataTable>();
string strAgainstVoucherNo = string.Empty;
string strAgainstInvoiceNo = string.Empty;
decimal decPurchaseReturnMasterIds = 0;
decimal decPurchaseMasterId = 0;
decimal decDiscount = 0;
decimal decExchangeRate = 0;
decimal decDis = 0;
if (isAutomatic)
{
if (strVoucherNo != string.Empty)
{
infoPurchaseReturnMaster.VoucherNo = strVoucherNo;
}
if (txtReturnNo.Text != string.Empty)
{
infoPurchaseReturnMaster.InvoiceNo = txtReturnNo.Text;
}
}
else
{
infoPurchaseReturnMaster.VoucherNo = strVoucherNo;
infoPurchaseReturnMaster.InvoiceNo = txtReturnNo.Text;
}
if (decPurchaseReturnVoucherTypeId != 0)
{
infoPurchaseReturnMaster.VoucherTypeId = decPurchaseReturnVoucherTypeId;
}
infoPurchaseReturnMaster.SuffixPrefixId = (decPurchaseReturnSuffixPrefixId != 0) ? decPurchaseReturnSuffixPrefixId : 0;
infoPurchaseReturnMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoPurchaseReturnMaster.PurchaseAccount = Convert.ToDecimal(cmbPurchaseAccount.SelectedValue.ToString());
if (cmbInvoiceNo.SelectedValue != null && cmbInvoiceNo.Visible == true)
{
infoPurchaseReturnMaster.PurchaseMasterId = Convert.ToDecimal((cmbInvoiceNo.SelectedValue.ToString()));
decPurchaseMasterId = Convert.ToDecimal((cmbInvoiceNo.SelectedValue.ToString()));
}
else
{
infoPurchaseReturnMaster.PurchaseMasterId = 0;
}
infoPurchaseReturnMaster.ExchangeRateId = (cmbCurrency.SelectedValue != null) ? Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()) : 0;
infoPurchaseReturnMaster.Narration = txtNarration.Text.Trim();
infoPurchaseReturnMaster.UserId = PublicVariables._decCurrentUserId;
infoPurchaseReturnMaster.LrNo = txtLrlNo.Text.Trim();
infoPurchaseReturnMaster.TransportationCompany = txtTransportationCompany.Text.Trim();
infoPurchaseReturnMaster.Date = Convert.ToDateTime(txtDate.Text);
infoPurchaseReturnMaster.TotalAmount = (txtTotalAmount.Text != string.Empty) ? Convert.ToDecimal(txtTotalAmount.Text) : 0;
infoPurchaseReturnMaster.TotalTax = (lblTaxAmount.Text != string.Empty) ? Convert.ToDecimal(lblTaxAmount.Text) : 0;
infoPurchaseReturnMaster.Discount = (txtBillDiscount.Text != string.Empty) ? Convert.ToDecimal(txtBillDiscount.Text) : 0;
infoPurchaseReturnMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPurchaseReturnMaster.Extra1 = string.Empty;
infoPurchaseReturnMaster.Extra2 = string.Empty;
infoPurchaseReturnMaster.ExtraDate = DateTime.Now;
infoPurchaseReturnMaster.GrandTotal = (txtGrandTotal.Text != string.Empty) ? Convert.ToDecimal(txtGrandTotal.Text) : 0;
if (btnSave.Text == "Save")
{
decPurchaseReturnMasterIds = BllPurchaseReturn.PurchaseReturnMasterAddWithReturnIdentity(infoPurchaseReturnMaster);
}
else
{
infoPurchaseReturnMaster.PurchaseReturnMasterId = decPurchaseReturnMasterId;
decExchangeRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(infoPurchaseReturnMaster.ExchangeRateId);
BllPurchaseReturn.PurchaseReturnMasterEdit(infoPurchaseReturnMaster);
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
BllLedgerPosting.LedgerPostDelete(strVoucherNo, decPurchaseReturnVoucherTypeId);
bllAccountLedger.PartyBalanceDeleteByVoucherTypeVoucherNoAndReferenceType(strVoucherNo, decPurchaseReturnVoucherTypeId);
}
infoLedgerPosting.Date = infoPurchaseReturnMaster.Date;
infoLedgerPosting.VoucherTypeId = infoPurchaseReturnMaster.VoucherTypeId;
infoLedgerPosting.VoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.InvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.LedgerId = infoPurchaseReturnMaster.PurchaseAccount;
infoLedgerPosting.Debit = 0;
if (btnSave.Text == "Save")
{
infoLedgerPosting.Credit = TotalNetAmountCalculation() * BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.ExtraDate = DateTime.Now;
}
else
{
infoLedgerPosting.Credit = TotalNetAmountCalculation();
}
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
infoLedgerPosting.LedgerId = infoPurchaseReturnMaster.LedgerId;
if (btnSave.Text == "Save")
{
infoLedgerPosting.Debit = Convert.ToDecimal(txtGrandTotal.Text) * BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.ExtraDate = DateTime.Now;
}
else
{
infoLedgerPosting.Debit = Convert.ToDecimal(txtGrandTotal.Text);
}
infoLedgerPosting.Credit = 0;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
foreach (DataGridViewRow dgvrow in dgvPurchaseReturnTax.Rows)
{
if (dgvrow.Cells["dgvtxtTaxId"].Value != null && dgvrow.Cells["dgvtxtTaxId"].Value.ToString() != string.Empty)
{
infoLedgerPosting.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvtxtledgerId"].Value.ToString());
infoLedgerPosting.Credit = (dgvrow.Cells["dgvtxtAmounts"].Value == null) ? 0 : Convert.ToDecimal(dgvrow.Cells["dgvtxtAmounts"].Value.ToString());
infoLedgerPosting.Debit = 0;
infoLedgerPosting.ExtraDate = DateTime.Now;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
if (txtBillDiscount.Text.Trim() != string.Empty)
{
decDis = Convert.ToDecimal(txtBillDiscount.Text);
}
if (decDis >= 0)
{
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = decDis;
infoLedgerPosting.LedgerId = 9;
infoLedgerPosting.ExtraDate = DateTime.Now;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
if (btnSave.Text == "Update")
{
infoPurchaseReturnMaster = BllPurchaseReturn.PurchaseReturnMasterView(decPurchaseReturnMasterId);
if (infoPurchaseReturnMaster.PurchaseMasterId == 0)
{
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(0, "NA", infoPurchaseReturnMaster.VoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
if (infoPurchaseReturnMaster.PurchaseMasterId != 0)
{
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(infoPurchaseMaster.VoucherTypeId, strInvoiceNo, strVoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
}
foreach (DataGridViewRow dgvrow in dgvPurchaseReturn.Rows)
{
if (dgvrow.Cells["dgvtxtProductId"].Value != null && dgvrow.Cells["dgvtxtProductId"].Value.ToString() != string.Empty)
{
infoPurchaseReturnDetails.ExtraDate = DateTime.Now;
infoPurchaseReturnDetails.Extra1 = string.Empty;
infoPurchaseReturnDetails.Extra2 = string.Empty;
infoPurchaseReturnDetails.PurchaseReturnMasterId = (btnSave.Text == "Save") ? decPurchaseReturnMasterIds : decPurchaseReturnMasterId;
infoPurchaseReturnDetails.ProductId = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtproductId"].Value));
infoPurchaseReturnDetails.Qty = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtqty"].Value));
infoPurchaseReturnDetails.Rate = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtrate"].Value));
if (btnSave.Text == "Save")
{
infoPurchaseReturnDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
infoPurchaseReturnDetails.UnitConversionId = BllUnitConvertion.UnitconversionIdViewByUnitIdAndProductId(infoPurchaseReturnDetails.UnitId, infoPurchaseReturnDetails.ProductId);
}
else
{
if (Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value) == 0)
{
try
{
infoPurchaseReturnDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
}
catch
{
infoPurchaseReturnDetails.UnitId = bllUnit.UnitIdByUnitName(Convert.ToString(dgvrow.Cells["dgvcmbUnit"].Value.ToString()));
}
infoPurchaseReturnDetails.UnitConversionId = BllUnitConvertion.UnitconversionIdViewByUnitIdAndProductId(infoPurchaseReturnDetails.UnitId, infoPurchaseReturnDetails.ProductId);
}
else
{
try
{
infoPurchaseReturnDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
}
catch
{
infoPurchaseReturnDetails.UnitId = bllUnit.UnitIdByUnitName(Convert.ToString(dgvrow.Cells["dgvcmbUnit"].Value.ToString()));
}
}
infoPurchaseReturnDetails.UnitConversionId = Convert.ToDecimal(dgvrow.Cells["dgvtxtUnitConversionId"].Value);
}
infoPurchaseReturnDetails.Discount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtdiscount"].Value));
if (dgvrow.Cells["dgvcmbTax"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbTax"].Value) != string.Empty && dgvrow.Cells["dgvcmbTax"].Value as string != "NA")
{
infoPurchaseReturnDetails.TaxId = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvcmbTax"].Value));
if (strTaxComboFill != string.Empty)
{
infoPurchaseReturnDetails.TaxAmount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtTaxAmount"].Value));
}
}
else
{
infoPurchaseReturnDetails.TaxId = 0;
}
if (dgvrow.Cells["dgvcmbBatch"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbBatch"].Value) != string.Empty)
{
infoPurchaseReturnDetails.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value);
}
else
{
infoPurchaseReturnDetails.GodownId = 0;
}
if (dgvrow.Cells["dgvcmbGodown"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbGodown"].Value) != string.Empty)
{
infoPurchaseReturnDetails.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value);
}
else
{
infoPurchaseReturnDetails.RackId = 0;
}
if (dgvrow.Cells["dgvcmbRack"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbRack"].Value) != string.Empty)
{
infoPurchaseReturnDetails.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value);
}
infoPurchaseReturnDetails.GrossAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtgrossValue"].Value.ToString());
infoPurchaseReturnDetails.NetAmount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtNetAmount"].Value));
infoPurchaseReturnDetails.Amount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtAmount"].Value));
infoPurchaseReturnDetails.SlNo = Convert.ToInt32(Convert.ToString(dgvrow.Cells["dgvtxtSlNo"].Value));
infoPurchaseReturnDetails.PurchaseDetailsId = (dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value != null) ? Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value)) : 0;
if (dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value != null)
{
if (dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value.ToString() == "0" || dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value.ToString() == string.Empty)
{
BllPurchaseReturn.PurchaseReturnDetailsAddWithReturnIdentity(infoPurchaseReturnDetails);
}
else
{
infoPurchaseReturnDetails.PurchaseReturnDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value.ToString());
BllPurchaseReturn.PurchaseReturnDetailsEdit(infoPurchaseReturnDetails);
}
}
else
{
BllPurchaseReturn.PurchaseReturnDetailsAddWithReturnIdentity(infoPurchaseReturnDetails);
}
if (btnSave.Text == "Save")
{
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
}
infoStockPosting.Date = infoPurchaseReturnMaster.Date;
infoStockPosting.ProductId = infoPurchaseReturnDetails.ProductId;
infoStockPosting.BatchId = infoPurchaseReturnDetails.BatchId;
infoStockPosting.UnitId = infoPurchaseReturnDetails.UnitId;
infoStockPosting.GodownId = infoPurchaseReturnDetails.GodownId;
infoStockPosting.RackId = infoPurchaseReturnDetails.RackId;
decimal decConversionId = BllUnitConvertion.UnitConversionRateByUnitConversionId(infoPurchaseReturnDetails.UnitConversionId);
//infoStockPosting.OutwardQty = infoPurchaseReturnDetails.Qty / (decConversionId == 0 ? 1 : decConversionId);
infoStockPosting.OutwardQty = infoPurchaseReturnDetails.Qty;
infoStockPosting.InwardQty = 0;
infoStockPosting.Rate = infoPurchaseReturnDetails.Rate;
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
if (infoPurchaseReturnDetails.PurchaseDetailsId != 0)
{
infoStockPosting.AgainstVoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.AgainstVoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.AgainstInvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.InvoiceNo = txtReturnNo.Text.Trim();
infoStockPosting.VoucherTypeId = decPurchaseReturnVoucherTypeId;
decAgainstVoucherTypeId = infoStockPosting.VoucherTypeId;
}
else
{
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.VoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoStockPosting.InvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoStockPosting.VoucherTypeId = decPurchaseReturnVoucherTypeId;
decAgainstVoucherTypeId = 0;
}
BllStockPosting.StockPostingAdd(infoStockPosting);
}
}
if (btnSave.Text == "Update")
{
removePurchaseReturnDetails();
}
infoAccountLedger = bllAccountLedger.AccountLedgerView(infoPurchaseReturnMaster.LedgerId);
if (infoAccountLedger.BillByBill == true)
{
infoPartyBalance.Date = infoPurchaseReturnMaster.Date;
infoPartyBalance.LedgerId = infoPurchaseReturnMaster.LedgerId;
if (decAgainstVoucherTypeId != 0)
{
infoPartyBalance.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoPartyBalance.VoucherNo = infoPurchaseMaster.VoucherNo;
infoPartyBalance.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = infoPurchaseReturnMaster.VoucherTypeId;
infoPartyBalance.AgainstVoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoPartyBalance.AgainstInvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoPartyBalance.ReferenceType = "Against";
}
else
{
infoPartyBalance.VoucherTypeId = infoPurchaseReturnMaster.VoucherTypeId;
infoPartyBalance.VoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoPartyBalance.InvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = 0;
infoPartyBalance.AgainstVoucherNo = "NA";
infoPartyBalance.AgainstInvoiceNo = "NA";
infoPartyBalance.ReferenceType = "New";
}
infoPartyBalance.Debit = infoPurchaseReturnMaster.TotalAmount;
infoPartyBalance.Credit = 0;
infoPartyBalance.CreditPeriod = 0;
infoPartyBalance.ExchangeRateId = infoPurchaseReturnMaster.ExchangeRateId;
infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPartyBalance.Extra1 = string.Empty;
infoPartyBalance.Extra2 = string.Empty;
BllPartyBalance.PartyBalanceAdd(infoPartyBalance);
}
foreach (DataGridViewRow item in dgvPurchaseReturnTax.Rows)
{
if (item.Cells["dgvtxtTaxId"].Value != null)
{
if (Convert.ToDecimal(item.Cells["dgvtxtAmounts"].Value.ToString()) > 0)
{
infoPurchaseReturnBillTax.PurchaseReturnMasterId = (btnSave.Text == "Save") ? decPurchaseReturnMasterIds : decPurchaseReturnMasterIds;
infoPurchaseReturnBillTax.TaxId = Convert.ToDecimal(item.Cells["dgvtxtTaxId"].Value.ToString());
infoPurchaseReturnBillTax.TaxAmount = (item.Cells["dgvtxtAmounts"].Value == null) ? 0 : Convert.ToDecimal(item.Cells["dgvtxtAmounts"].Value.ToString());
infoPurchaseReturnBillTax.Extra1 = string.Empty;
infoPurchaseReturnBillTax.Extra2 = string.Empty;
BllPurchaseReturn.PurchaseReturnBilltaxAdd(infoPurchaseReturnBillTax);
}
}
}
if (btnSave.Text == "Save")
{
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPurchaseReturnMasterIds);
}
else
{
Print(decPurchaseReturnMasterIds);
}
}
Clear();
}
else
{
decDiscount = Convert.ToDecimal(txtBillDiscount.Text);
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPurchaseReturnMasterId);
}
else
{
Print(decPurchaseReturnMasterId);
}
}
if (frmPurchaseReturnRegisterObj != null)
{
frmPurchaseReturnRegisterObj.GridFill();
frmPurchaseReturnRegisterObj.Enabled = true;
}
if (ObjPurchaseReturnReport != null)
{
ObjPurchaseReturnReport.PurchaseReturnReportGridFill();
ObjPurchaseReturnReport.Enabled = true;
}
if (frmLedgerDetailsObj != null)
{
frmLedgerDetailsObj.LedgerDetailsView();
frmLedgerDetailsObj.Enabled = true;
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("PR:49" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Call the print in butten print click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
string strColumn = string.Empty;
GridFill();
if (dgvPurchaseReport.RowCount > 0)
{
if (rbtnInvoiceDate.Checked)
{
strColumn = rbtnInvoiceDate.Text;
}
else
{
strColumn = rbtnVoucherDate.Text;
}
DataSet dsPurchaseReport = BllPurchaseInvoice.PurchaseInvoiceReportPrinting(1, strColumn, dtpFromDate.Value, dtpToDate.Value,
Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), cmbStatus.Text, cmbPurchaseMode.Text,
Convert.ToDecimal(cmbAgainstVoucherType.SelectedValue.ToString()), txtOrderNo.Text,
Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()), txtVoucherNo.Text, txtProductCode.Text, txtProductName.Text);
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
frmReport.PurchaseReportPrinting(dsPurchaseReport, txtTotalAmount.Text);
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("PIREP15:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Product details fill in grid corresponding to invoice number
/// </summary>
public void InvoiceDetailsFill()
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
if (!isEditFill)
{
inMaxCount = 0;
string strTaxRate1 = string.Empty;
string strproductId = string.Empty;
decimal decTaxAmount = 0;
decimal decAmount = 0;
decimal decNetAmount = 0;
decimal decTaxRate = 0;
decimal decDiscountAmount = 0;
decimal decGrossAmount = 0;
int inRowIndex = 0;
UnitConvertionBll bllUnitConversion = new UnitConvertionBll();
PurchaseReturnBll BllPurchaseReturn = new PurchaseReturnBll();
List<DataTable> ListObjDetails = BllPurchaseInvoice.PurchaseDetailsViewByPurchaseMasterIdWithRemaining(Convert.ToDecimal(cmbInvoiceNo.SelectedValue.ToString()), decPurchaseReturnMasterId, decPurchaseReturnVoucherTypeId);
dgvPurchaseReturn.Rows.Clear();
foreach (DataRow drowDetails in ListObjDetails[0].Rows)
{
dgvPurchaseReturn.Rows.Add();
DGVUnitComboFill();
DGVBatchComboFill();
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtPurchaseDetailsId"].Value = drowDetails.ItemArray[0].ToString();
strproductId = drowDetails.ItemArray[2].ToString();
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtproductId"].Value = Convert.ToString(drowDetails.ItemArray[2]);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtproductName"].Value = Convert.ToString(drowDetails.ItemArray[5]);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtproductCode"].Value = Convert.ToString(drowDetails.ItemArray[6]);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtVoucherTypeId"].Value = Convert.ToString(drowDetails.ItemArray[21]);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtVoucherNo"].Value = Convert.ToString(drowDetails.ItemArray[23]);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtInvoiceNo"].Value = Convert.ToString(drowDetails.ItemArray[22]);
decQty = Math.Round(Convert.ToDecimal(Convert.ToString(drowDetails.ItemArray[10])), PublicVariables._inNoOfDecimalPlaces);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtqty"].Value = decQty;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtrate"].Value = Convert.ToString(drowDetails.ItemArray[11]);
decRate = Math.Round(Convert.ToDecimal(Convert.ToString(drowDetails.ItemArray[11])), PublicVariables._inNoOfDecimalPlaces);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtbarcode"].Value = Convert.ToString(drowDetails.ItemArray[8]);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtConversionRate"].Value = bllUnitConversion.UnitConversionRateByUnitConversionId(Convert.ToDecimal(drowDetails.ItemArray[9].ToString()));
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drowDetails.ItemArray[9].ToString());
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvcmbGodown"].Value = (Convert.ToString(drowDetails.ItemArray[17]) != null) ? Convert.ToDecimal(drowDetails.ItemArray[17].ToString()) : 0;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvcmbRack"].Value = (drowDetails.ItemArray[18].ToString() != null) ? Convert.ToDecimal(drowDetails.ItemArray[18].ToString()) : 0;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvcmbBatch"].Value = (drowDetails.ItemArray[19].ToString() != null) ? Convert.ToDecimal(drowDetails.ItemArray[19].ToString()) : 0;
decGrossAmount = decQty * decRate;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(drowDetails.ItemArray[12].ToString());
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvcmbUnit"].ReadOnly = true;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drowDetails.ItemArray[9]);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtgrossValue"].Value = Math.Round(decGrossAmount, PublicVariables._inNoOfDecimalPlaces);
if (Convert.ToString(drowDetails.ItemArray[7]) != string.Empty)
{
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtdiscount"].Value = Convert.ToString(drowDetails.ItemArray[7]);
decDiscountAmount = Math.Round(Convert.ToDecimal(Convert.ToString(drowDetails.ItemArray[7])), PublicVariables._inNoOfDecimalPlaces);
}
else
{
decDiscountAmount = 0;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtdiscount"].Value = 0;
}
decNetAmount = decGrossAmount - decDiscountAmount;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtNetAmount"].Value = (decNetAmount != 0) ? Math.Round(decNetAmount, PublicVariables._inNoOfDecimalPlaces) : 0;
if (strTaxComboFill != string.Empty)
{
if (drowDetails.ItemArray[13].ToString() != string.Empty && Convert.ToDecimal(drowDetails.ItemArray[13].ToString()) != 0)
{
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvcmbTax"].Value = Convert.ToDecimal(drowDetails.ItemArray[13].ToString());
strTaxRate1 = BllPurchaseReturn.TaxRateFromPurchaseDetails(Convert.ToDecimal(Convert.ToString(drowDetails.ItemArray[13])));
}
else
{
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvcmbTax"].Value = "NA";
strTaxRate1 = string.Empty;
}
if (strTaxRate1 != string.Empty)
{
decTaxRate = Convert.ToDecimal(strTaxRate1);
decTaxAmount = ((decNetAmount * decTaxRate) / 100);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxttaxAmount"].Value = Math.Round(decTaxAmount, PublicVariables._inNoOfDecimalPlaces);
}
else
{
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxttaxAmount"].Value = 0;
}
}
else
{
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxttaxAmount"].Value = 0;
}
decAmount = decNetAmount + decTaxAmount;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtAmount"].Value = Math.Round(decAmount, PublicVariables._inNoOfDecimalPlaces);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtproductCode"].ReadOnly = true;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtproductName"].ReadOnly = true;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtbarcode"].ReadOnly = true;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvcmbBatch"].ReadOnly = true;
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 2].Cells["dgvtxtInRowIndex"].Value = Convert.ToString(drowDetails["extra1"]);
dgvPurchaseReturn.Rows[dgvPurchaseReturn.Rows.Count - 1].ReadOnly = true;
int intIndex = 0;
int.TryParse(Convert.ToString(drowDetails["extra1"]), out intIndex);
if (inMaxCount < intIndex)
inMaxCount = intIndex;
inRowIndex++;
}
for (int i = inRowIndex; i < dgvPurchaseReturn.Rows.Count; ++i)
dgvPurchaseReturn["dgvtxtInRowIndex", i].Value = Convert.ToString(GetNextinRowIndex());
CalculateTotalAmount();
}
}
catch (Exception ex)
{
MessageBox.Show("PR:42" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill purchase details
/// </summary>
public void PurchaseDetailsFill()
{
List<DataTable> ListObj = new List<DataTable>();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
GridComboFill();
ListObj = BllPurchaseInvoice.PurchaseDetailsViewByPurchaseMasterId(decPurchaseMasterId);
int i = 0;
foreach (DataRow dr in ListObj[0].Rows)
{
dgvProductDetails.Rows.Add();
dgvProductDetails.Rows[i].Cells["dgvtxtPurchaseDetailsId"].Value = dr["purchaseDetailsId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtPurchaseOrderDetailsId"].Value = dr["purchaseOrderDetailsId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtMaterialReceiptDetailsId"].Value = dr["materialReceiptDetailsId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtProductId"].Value = dr["productId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtBarcode"].Value = dr["barcode"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtProductCode"].Value = dr["productCode"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtProductName"].Value = dr["productName"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtQuantity"].Value = dr["qty"].ToString();
UnitComboFill(Convert.ToDecimal(dr["productId"].ToString()), i, dgvProductDetails.Rows[i].Cells["dgvcmbUnit"].ColumnIndex);
dgvProductDetails.Rows[i].Cells["dgvtxtUnitConversionId"].Value = dr["unitConversionId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(dr["unitId"].ToString());
dgvProductDetails.Rows[i].Cells["dgvcmbGodown"].Value = 1m;
dgvProductDetails.Rows[i].Cells["dgvcmbRack"].Value = 1m;
BatchComboFill(Convert.ToDecimal(dr["productId"].ToString()), i, dgvProductDetails.Rows[i].Cells["dgvcmbBatch"].ColumnIndex);
dgvProductDetails.Rows[i].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(dr["batchId"].ToString());
dgvProductDetails.Rows[i].Cells["dgvtxtRate"].Value = dr["rate"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtGrossValue"].Value = dr["grossValue"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtDiscountPercent"].Value = dr["discountPercent"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtDiscount"].Value = dr["discount"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtNetValue"].Value = dr["netvalue"].ToString();
dgvProductDetails.Rows[i].Cells["dgvcmbTax"].Value = Convert.ToDecimal(dr["taxId"].ToString());
dgvProductDetails.Rows[i].Cells["dgvtxtTaxAmount"].Value = dr["taxAmount"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtAmount"].Value = dr["Amount"].ToString();
int inRef = BllPurchaseInvoice.PurchaseMasterReferenceCheck(decPurchaseMasterId, Convert.ToDecimal(dr["purchaseDetailsId"].ToString()));
if (Convert.ToDecimal(dr["purchaseOrderDetailsId"].ToString()) != 0 || Convert.ToDecimal(dr["materialReceiptDetailsId"].ToString()) != 0 || inRef == 1)
{
dgvProductDetails.Rows[i].Cells["dgvcmbUnit"].ReadOnly = true;
}
i++;
}
if (cmbPurchaseMode.SelectedIndex > 1)
{
dgvProductDetails.AllowUserToAddRows = false;
}
SerialNo();
}
catch (Exception ex)
{
MessageBox.Show("PI56:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to check quantity with reference
/// </summary>
/// <returns></returns>
public int QuantityCheckWithReference()
{
decimal decQtyPurchaseInvoice = 0;
decimal decQtyPurchaseReturn = 0;
int inRef = 0;
int inF1 = 1;
decimal decPurchaseDetailsId = 0;
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
PurchaseReturnBll BllPurchaseReturn = new PurchaseReturnBll();
try
{
foreach (DataGridViewRow dgvrow in dgvProductDetails.Rows)
{
if (dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value != null)
{
if (dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value.ToString() != "0" || dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value.ToString() != string.Empty)
{
decPurchaseDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value.ToString());
inRef = BllPurchaseInvoice.PurchaseMasterReferenceCheck(decPurchaseMasterId, decPurchaseDetailsId);
if (inRef == 1)
{
if (inF1 == 1)
{
if (dgvrow.Cells["dgvtxtQuantity"].Value != null)
{
if (dgvrow.Cells["dgvtxtQuantity"].Value.ToString() != "0" && dgvrow.Cells["dgvtxtQuantity"].Value.ToString() != string.Empty)
{
decQtyPurchaseInvoice = Convert.ToDecimal(dgvrow.Cells["dgvtxtQuantity"].Value.ToString());
decQtyPurchaseReturn = Math.Round(BllPurchaseReturn.PurchaseReturnDetailsQtyViewByPurchaseDetailsId(decPurchaseDetailsId), PublicVariables._inNoOfDecimalPlaces);
if (decQtyPurchaseInvoice >= decQtyPurchaseReturn)
{
inF1 = 1;
}
else
{
inF1 = 0;
Messages.InformationMessage("Quantity in row " + (dgvrow.Index + 1) + " should be greater than " + decQtyPurchaseReturn);
}
}
else
{
inF1 = 0;
Messages.InformationMessage("Quantity in row " + (dgvrow.Index + 1) + " should be greater than " + decQtyPurchaseReturn);
}
}
else
{
inF1 = 0;
Messages.InformationMessage("Quantity in row " + (dgvrow.Index + 1) + " should be greater than " + decQtyPurchaseReturn);
}
}
}
else
{
inF1 = 1;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PI35:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return inF1;
}
/// <summary>
/// Function to print purchase invoice
/// </summary>
/// <param name="decMasterId"></param>
public void Print(decimal decMasterId)
{
try
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
decimal decPurchaseOrderMasterId = 0;
decimal decMaterialReceiptMasterId = 0;
if (cmbPurchaseMode.Text == "Against PurchaseOrder")
{
decPurchaseOrderMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
}
else if (cmbPurchaseMode.Text == "Against MaterialReceipt")
{
decMaterialReceiptMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
}
DataSet dsPurchaseInvoice = BllPurchaseInvoice.PurchaseInvoicePrinting(1, decPurchaseOrderMasterId, decMaterialReceiptMasterId, decMasterId);
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
frmReport.PurchaseInvoicePrinting(dsPurchaseInvoice);
}
catch (Exception ex)
{
MessageBox.Show("PI57:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the product details
/// </summary>
/// <param name="strProduct"></param>
/// <param name="inRowIndex"></param>
/// <param name="strFillMode"></param>
public void ProductDetailsFill(string strProduct, int inRowIndex, string strFillMode)
{
decimal decProductId = 0;
decimal decGodownId = 0;
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
List<DataTable> ListObj = new List<DataTable>();
try
{
if (strFillMode == "ProductCode")
{
ListObj = BllPurchaseInvoice.PurchaseDetailsViewByProductCodeForPI(decPurchaseInvoiceVoucherTypeId, strProduct);
}
else if (strFillMode == "ProductName")
{
ListObj = BllPurchaseInvoice.PurchaseDetailsViewByProductNameForPI(decPurchaseInvoiceVoucherTypeId, strProduct);
}
else if (strFillMode == "Barcode")
{
ListObj = BllPurchaseInvoice.PurchaseDetailsViewByBarcodeForPI(decPurchaseInvoiceVoucherTypeId, strProduct);
}
if (ListObj[0].Rows.Count >= 1)
{
decProductId = Convert.ToDecimal(ListObj[0].Rows[0]["productId"]);
decGodownId = Convert.ToDecimal(ListObj[0].Rows[0]["godownId"]);
UnitComboFill(decProductId, inRowIndex, dgvProductDetails.Columns["dgvcmbUnit"].Index);
GodownComboFill();
RackComboFill(decGodownId, inRowIndex, dgvProductDetails.Columns["dgvcmbRack"].Index);
BatchComboFill(decProductId, inRowIndex, dgvProductDetails.Columns["dgvcmbBatch"].Index);
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtPurchaseDetailsId"].Value = ListObj[0].Rows[0]["purchaseDetailsId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtPurchaseOrderDetailsId"].Value = ListObj[0].Rows[0]["purchaseOrderDetailsId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtMaterialReceiptDetailsId"].Value = ListObj[0].Rows[0]["materialReceiptDetailsId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtProductId"].Value = ListObj[0].Rows[0]["productId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtBarcode"].Value = ListObj[0].Rows[0]["barcode"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtProductCode"].Value = ListObj[0].Rows[0]["productCode"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtProductName"].Value = ListObj[0].Rows[0]["productName"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtUnitConversionId"].Value = ListObj[0].Rows[0]["unitConversionId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbUnit"].Value = ListObj[0].Rows[0]["unitId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbGodown"].Value = ListObj[0].Rows[0]["godownId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbRack"].Value = ListObj[0].Rows[0]["rackId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbBatch"].Value = ListObj[0].Rows[0]["batchId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtRate"].Value = ListObj[0].Rows[0]["rate"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtGrossValue"].Value = ListObj[0].Rows[0]["grossValue"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtDiscountPercent"].Value = ListObj[0].Rows[0]["discountPercent"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtDiscount"].Value = ListObj[0].Rows[0]["discount"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtNetValue"].Value = ListObj[0].Rows[0]["netvalue"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbTax"].Value = ListObj[0].Rows[0]["taxId"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtTaxAmount"].Value = ListObj[0].Rows[0]["taxAmount"];
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtAmount"].Value = ListObj[0].Rows[0]["amount"];
dgvProductDetails.Rows[inRowIndex].HeaderCell.Value = "X";
dgvProductDetails.Rows[inRowIndex].HeaderCell.Style.ForeColor = Color.Red;
}
else
{
if (strProductCode != string.Empty)
{
ProductDetailsFill(strProductCode, inRowIndex, "ProductCode");
}
else
{
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtPurchaseDetailsId"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtPurchaseOrderDetailsId"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtMaterialReceiptDetailsId"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtProductId"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtQuantity"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtUnitConversionId"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbUnit"].Value = Convert.ToDecimal("0");
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbGodown"].Value = Convert.ToDecimal("0");
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbRack"].Value = Convert.ToDecimal("0");
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbBatch"].Value = Convert.ToDecimal("0");
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtRate"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtGrossValue"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtDiscountPercent"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtDiscount"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtNetValue"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvcmbTax"].Value = Convert.ToDecimal("0");
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtTaxAmount"].Value = 0;
dgvProductDetails.Rows[inRowIndex].Cells["dgvtxtAmount"].Value = 0;
dgvProductDetails.Rows[inRowIndex].HeaderCell.Value = "X";
dgvProductDetails.Rows[inRowIndex].HeaderCell.Style.ForeColor = Color.Red;
}
}
}
catch (Exception ex)
{
MessageBox.Show("PI49:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for orderNo combobox
/// </summary>
public void OrderComboFill()
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
List<DataTable> ListObj = new List<DataTable>();
try
{
if (cmbVoucherType.SelectedValue != null)
{
if (cmbVoucherType.SelectedValue.ToString() != "System.Data.DataRowView" && cmbVoucherType.Text != "System.Data.DataRowView")
{
if (cmbCashOrParty.SelectedValue != null)
{
if (cmbCashOrParty.SelectedValue.ToString() != string.Empty && cmbCashOrParty.Text != string.Empty)
{
if (cmbPurchaseMode.Text == "Against PurchaseOrder")
{
ListObj = BllPurchaseInvoice.GetOrderNoCorrespondingtoLedgerByNotInCurrPI(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), decPurchaseMasterId,
Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()));
DataRow drow = ListObj[0].NewRow();
drow["purchaseOrderMasterId"] = 0;
drow["invoiceNo"] = string.Empty;
ListObj[0].Rows.InsertAt(drow, 0);
cmbOrderNo.DataSource = ListObj[0];
cmbOrderNo.ValueMember = "purchaseOrderMasterId";
cmbOrderNo.DisplayMember = "invoiceNo";
}
else if (cmbPurchaseMode.Text == "Against MaterialReceipt")
{
ListObj = BllPurchaseInvoice.GetMaterialReceiptNoCorrespondingtoLedgerByNotInCurrPI(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), decPurchaseMasterId,
Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()));
DataRow drow = ListObj[0].NewRow();
drow["materialReceiptMasterId"] = 0;
drow["invoiceNo"] = string.Empty;
ListObj[0].Rows.InsertAt(drow, 0);
cmbOrderNo.DataSource = ListObj[0];
cmbOrderNo.ValueMember = "materialReceiptMasterId";
cmbOrderNo.DisplayMember = "invoiceNo";
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PI9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill additional cost grid
/// </summary>
public void AdditionalCostGridFill()
{
List<DataTable> ListObjforaccountLedger = new List<DataTable>();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
AditionalCostBll bllAdditionalCost = new AditionalCostBll();
try
{
ListObjforaccountLedger = BllPurchaseInvoice.AccountLedgerViewForAdditionalCost();
DataRow dr = ListObjforaccountLedger[0].NewRow();
dr["ledgerName"] = string.Empty;
dr["ledgerId"] = 0;
ListObjforaccountLedger[0].Rows.InsertAt(dr, 0);
dgvcmbLedger.DataSource = ListObjforaccountLedger[0];
dgvcmbLedger.DisplayMember = "ledgerName";
dgvcmbLedger.ValueMember = "ledgerId";
if (decPurchaseMasterId == 0)
{
AdditionalCostComboFill(0);
}
else
{
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllAdditionalCost.AdditionalCostViewAllByVoucherTypeIdAndVoucherNo(decPurchaseInvoiceVoucherTypeId, strVoucherNo);
dgvAdditionalCost.DataSource = ListObj[0];
}
AdditionalCostSerialNo();
}
catch (Exception ex)
{
MessageBox.Show("PI26:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the details while calling from register or report
/// </summary>
public void FillRegisterOrReport()
{
PurchaseMasterInfo infoPurchaseMaster = new PurchaseMasterInfo();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
PurchaseOrderMasterInfo infoPurchaseOrderMaster = new PurchaseOrderMasterInfo();
PurchaseOrderBll BllPurchaseOrder = new PurchaseOrderBll();
MaterialReceiptMasterInfo infoMaterialReceiptMaster = new MaterialReceiptMasterInfo();
MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
VoucherTypeInfo infoVoucherType = new VoucherTypeInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
bool isPartyBalanceRef = false;
try
{
isEditFill = true;
btnSave.Text = "Update";
btnDelete.Enabled = true;
txtVoucherNo.ReadOnly = true;
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(decPurchaseMasterId);
strVoucherNo = infoPurchaseMaster.VoucherNo;
decPurchaseInvoiceVoucherTypeId = infoPurchaseMaster.VoucherTypeId;
decPurchaseInvoiceSuffixPrefixId = infoPurchaseMaster.SuffixPrefixId;
isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(decPurchaseInvoiceVoucherTypeId);
infoVoucherType = BllVoucherType.VoucherTypeView(decPurchaseInvoiceVoucherTypeId);
this.Text = infoVoucherType.VoucherTypeName;
if (isAutomatic)
{
txtVoucherDate.Focus();
}
else
{
txtVoucherNo.Focus();
}
txtVoucherNo.Text = infoPurchaseMaster.InvoiceNo;
txtVendorInvoiceNo.Text = infoPurchaseMaster.VendorInvoiceNo;
dtpVoucherDate.Value = infoPurchaseMaster.Date;
dtpInvoiceDate.Value = infoPurchaseMaster.VendorInvoiceDate;
cmbCashOrParty.SelectedValue = infoPurchaseMaster.LedgerId;
if (infoPurchaseMaster.PurchaseOrderMasterId == 0 && infoPurchaseMaster.MaterialReceiptMasterId == 0)
{
cmbPurchaseMode.SelectedItem = "NA";
}
else if (infoPurchaseMaster.PurchaseOrderMasterId != 0 && infoPurchaseMaster.MaterialReceiptMasterId == 0)
{
cmbPurchaseMode.SelectedItem = "Against PurchaseOrder";
infoPurchaseOrderMaster = BllPurchaseOrder.PurchaseOrderMasterView(infoPurchaseMaster.PurchaseOrderMasterId);
cmbVoucherType.SelectedValue = infoPurchaseOrderMaster.VoucherTypeId;
OrderComboFill();
cmbOrderNo.SelectedValue = infoPurchaseMaster.PurchaseOrderMasterId;
}
else if (infoPurchaseMaster.PurchaseOrderMasterId == 0 && infoPurchaseMaster.MaterialReceiptMasterId != 0)
{
cmbPurchaseMode.SelectedItem = "Against MaterialReceipt";
infoMaterialReceiptMaster = bllMaterialReceiptMaster.MaterialReceiptMasterView(infoPurchaseMaster.MaterialReceiptMasterId);
cmbVoucherType.SelectedValue = infoMaterialReceiptMaster.VoucherTypeId;
OrderComboFill();
cmbOrderNo.SelectedValue = infoPurchaseMaster.MaterialReceiptMasterId;
}
cmbPurchaseAccount.SelectedValue = infoPurchaseMaster.PurchaseAccount;
txtCreditPeriod.Text = infoPurchaseMaster.CreditPeriod;
cmbCurrency.SelectedValue = infoPurchaseMaster.ExchangeRateId;
txtNarration.Text = infoPurchaseMaster.Narration;
lblAdditionalCostAmount.Text = Math.Round(infoPurchaseMaster.AdditionalCost, PublicVariables._inNoOfDecimalPlaces).ToString();
lblTaxAmount.Text = Math.Round(infoPurchaseMaster.TotalTax, PublicVariables._inNoOfDecimalPlaces).ToString();
txtTotalAmount.Text = Math.Round(infoPurchaseMaster.TotalAmount, PublicVariables._inNoOfDecimalPlaces).ToString();
txtBillDiscount.Text = Math.Round(infoPurchaseMaster.BillDiscount, PublicVariables._inNoOfDecimalPlaces).ToString();
txtLRNo.Text = infoPurchaseMaster.LrNo;
txtTransportationCompany.Text = infoPurchaseMaster.TransportationCompany;
txtGrandTotal.Text = Math.Round(infoPurchaseMaster.GrandTotal, PublicVariables._inNoOfDecimalPlaces).ToString();
PurchaseDetailsFill();
TaxGridFill();
AdditionalCostGridFill();
isPartyBalanceRef = bllAccountLedger.PartyBalanceAgainstReferenceCheck(strVoucherNo, decPurchaseInvoiceVoucherTypeId);
if (isPartyBalanceRef)
{
cmbCashOrParty.Enabled = false;
}
else
{
cmbCashOrParty.Enabled = true;
}
isEditFill = false;
}
catch (Exception ex)
{
MessageBox.Show("PI55:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Funtion to check remaining quantity with refernce to purchaseinvoice and rejectionout
/// </summary>
/// <returns></returns>
public int QuantityCheckWithReference()
{
decimal decQtyRejectionOutAndPurchaseInvoice = 0;
decimal decQtyMaterialReceipt = 0;
decimal inRef = 0;
int inF1 = 1;
decimal decMaterialReceiptDetailsId = 0;
MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
RejectionOutBll bllRejectionOut = new RejectionOutBll();
try
{
foreach (DataGridViewRow dgvrow in dgvProduct.Rows)
{
if (dgvrow.Cells["dgvtxtmaterialReceiptDetailsId"].Value != null)
{
if (dgvrow.Cells["dgvtxtmaterialReceiptDetailsId"].Value.ToString() != "0" || dgvrow.Cells["dgvtxtmaterialReceiptDetailsId"].Value.ToString() != string.Empty)
{
decMaterialReceiptDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtmaterialReceiptDetailsId"].Value.ToString());
inRef = bllMaterialReceiptMaster.MaterialReceiptDetailsReferenceCheck(decMaterialReceiptDetailsId);
if (inRef == 1)
{
if (inF1 == 1)
{
if (dgvrow.Cells["dgvtxtQty"].Value != null)
{
if (dgvrow.Cells["dgvtxtQty"].Value.ToString() != "0" || dgvrow.Cells["dgvtxtQty"].Value.ToString() != string.Empty)
{
decQtyMaterialReceipt = Convert.ToDecimal(dgvrow.Cells["dgvtxtQty"].Value.ToString());
decQtyRejectionOutAndPurchaseInvoice = Math.Round(bllMaterialReceiptMaster.MaterialReceiptQuantityDetailsAgainstPurcahseInvoiceAndRejectionOut(decMaterialReceiptDetailsId), PublicVariables._inNoOfDecimalPlaces);
if (decQtyMaterialReceipt >= decQtyRejectionOutAndPurchaseInvoice)
{
inF1 = 1;
}
else
{
inF1 = 0;
Messages.InformationMessage("Quantity in row " + (dgvrow.Index + 1) + " should be greater than " + decQtyRejectionOutAndPurchaseInvoice);
}
}
else
{
inF1 = 0;
Messages.InformationMessage("Quantity in row " + (dgvrow.Index + 1) + " should be greater than " + decQtyRejectionOutAndPurchaseInvoice);
}
}
else
{
inF1 = 0;
Messages.InformationMessage("Quantity in row " + (dgvrow.Index + 1) + " should be greater than " + decQtyRejectionOutAndPurchaseInvoice);
}
}
}
else
{
inF1 = 1;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("MR11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return inF1;
}
/// <summary>
/// deleting the rows from tbl_PurchaseDetails removed by user from the grid while updating after reference check
/// </summary>
public void RemoveDelete()
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
AditionalCostBll bllAdditionalCost = new AditionalCostBll();
decimal decPurchaseDetailsId = 0;
decimal decAdditionalCostId = 0;
int inRef = 0;
try
{
foreach (var item in arrlstRemove)
{
decPurchaseDetailsId = Convert.ToDecimal(item);
inRef = BllPurchaseInvoice.PurchaseMasterReferenceCheck(decPurchaseMasterId, decPurchaseDetailsId);
if (inRef == 0)
{
BllPurchaseInvoice.PurchaseDetailsDelete(decPurchaseDetailsId);
}
}
foreach (var item1 in arrlstRemoveAdditionalCost)
{
decAdditionalCostId = Convert.ToDecimal(item1);
bllAdditionalCost.AdditionalCostDelete(decAdditionalCostId);
}
}
catch (Exception ex)
{
MessageBox.Show("PI40:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the grid based on condition
/// </summary>
public void GridFill()
{
decimal decTotalAmount = 0;
string strColumn = string.Empty;
List<DataTable> ListObj = new List<DataTable>();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
if (rbtnInvoiceDate.Checked)
{
strColumn = rbtnInvoiceDate.Text;
}
else
{
strColumn = rbtnVoucherDate.Text;
}
ListObj = BllPurchaseInvoice.PurchaseInvoiceReportFill(1, strColumn, dtpFromDate.Value, dtpToDate.Value,
Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), cmbStatus.Text, cmbPurchaseMode.Text,
Convert.ToDecimal(cmbAgainstVoucherType.SelectedValue.ToString()), txtOrderNo.Text,
Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()), txtVoucherNo.Text, txtProductCode.Text, txtProductName.Text);
dgvPurchaseReport.DataSource = ListObj[0];
foreach (DataGridViewRow dgvrow in dgvPurchaseReport.Rows)
{
if (dgvrow.Cells["dgvtxtBillAmount"].Value != null)
{
if (dgvrow.Cells["dgvtxtBillAmount"].Value.ToString() != string.Empty)
{
decTotalAmount = decTotalAmount + Convert.ToDecimal(dgvrow.Cells["dgvtxtBillAmount"].Value.ToString());
}
}
}
txtTotalAmount.Text = Math.Round(decTotalAmount, PublicVariables._inNoOfDecimalPlaces).ToString();
}
catch (Exception ex)
{
MessageBox.Show("PIREP5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Account ledger combobox while return from Account ledger creation when creating new ledger
/// </summary>
/// <param name="decLedgerId"></param>
public void ReturnFromAccountLedgerForm(decimal decLedgerId)
{
AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
DataTable dtbl = new DataTable();
try
{
this.Enabled = true;
this.Activate();
CashOrPartyComboFill();
PurchaseAccountComboFill();
cmbPurchaseAccount.SelectedValue = decLedgerId;
cmbCashOrParty.SelectedValue = decLedgerId;
if (cmbCashOrParty.Text == string.Empty)
{
cmbCashOrParty.SelectedValue = strCashOrParty;
}
if (cmbPurchaseAccount.Text == string.Empty)
{
cmbPurchaseAccount.SelectedValue = strPurchaseAccount;
}
}
catch (Exception ex)
{
MessageBox.Show("PI6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Call Corresponding Voucher to View details for updation in edit mode
/// </summary>
public void GotoPurchaseInvoice()
{
try
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
PurchaseMasterInfo purchasemasterinfo = new PurchaseMasterInfo();
purchasemasterinfo = BllPurchaseInvoice.PurchaseMasterView(Convert.ToDecimal(dgvVoucherSearch.CurrentRow.Cells["Id"].Value.ToString()));
if (purchasemasterinfo.PurchaseMasterId != 0)
{
frmPurchaseInvoice objfrmPurchaseInvoice = new frmPurchaseInvoice();
frmPurchaseInvoice open = Application.OpenForms["frmPurchaseInvoice"] as frmPurchaseInvoice;
if (open == null)
{
objfrmPurchaseInvoice.WindowState = FormWindowState.Normal;
objfrmPurchaseInvoice.MdiParent = formMDI.MDIObj;
objfrmPurchaseInvoice.Show();
objfrmPurchaseInvoice.CallFromVoucherSerach(this, Convert.ToDecimal(dgvVoucherSearch.CurrentRow.Cells["Id"].Value.ToString()));
}
else
{
open.MdiParent = formMDI.MDIObj;
if (open.WindowState == FormWindowState.Minimized)
{
open.WindowState = FormWindowState.Normal;
}
else
{
open.Activate();
}
open.CallFromVoucherSerach(this, Convert.ToDecimal(dgvVoucherSearch.CurrentRow.Cells["Id"].Value.ToString()));
open.BringToFront();
}
}
}
catch (Exception ex)
{
MessageBox.Show("VS23:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save purchase invoice
/// </summary>
public void Save()
{
decimal decPurchaseMasterId = 0;
PurchaseMasterInfo infoPurchaseMaster = new PurchaseMasterInfo();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
PurchaseDetailsInfo infoPurchaseDetails = new PurchaseDetailsInfo();
MaterialReceiptMasterInfo infoMaterialReceiptMaster = new MaterialReceiptMasterInfo();
MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll();
PurchaseOrderMasterInfo infoPurchaseOrderMaster = new PurchaseOrderMasterInfo();
PurchaseOrderBll BllPurchaseOrder = new PurchaseOrderBll();
StockPostingInfo infoStockPosting = new StockPostingInfo();
StockPostingBll BllStockPosting = new StockPostingBll();
//StockPostingSP spStockPosting = new StockPostingSP();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
//PartyBalanceSP spPartyBalance = new PartyBalanceSP();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
AdditionalCostInfo infoAdditionalCost = new AdditionalCostInfo();
AditionalCostBll bllAdditionalCost = new AditionalCostBll();
PurchaseBillTaxInfo infoPurchaseBillTax = new PurchaseBillTaxInfo();
AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
UnitConvertionBll bllUnitConvertion = new UnitConvertionBll();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
try
{
/*-----------------------------------------Purchase Master Add----------------------------------------------------*/
infoPurchaseMaster.AdditionalCost = Convert.ToDecimal(lblAdditionalCostAmount.Text);
infoPurchaseMaster.BillDiscount = Convert.ToDecimal(txtBillDiscount.Text);
infoPurchaseMaster.CreditPeriod = txtCreditPeriod.Text;
infoPurchaseMaster.Date = Convert.ToDateTime(txtVoucherDate.Text);
infoPurchaseMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoPurchaseMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPurchaseMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text);
infoPurchaseMaster.InvoiceNo = txtVoucherNo.Text.Trim();
if (isAutomatic)
{
infoPurchaseMaster.SuffixPrefixId = decPurchaseInvoiceSuffixPrefixId;
infoPurchaseMaster.VoucherNo = strVoucherNo;
}
else
{
infoPurchaseMaster.SuffixPrefixId = 0;
infoPurchaseMaster.VoucherNo = strVoucherNo;
}
infoPurchaseMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoPurchaseMaster.LrNo = txtLRNo.Text;
if (cmbPurchaseMode.Text == "Against MaterialReceipt")
{
infoPurchaseMaster.MaterialReceiptMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
}
else
{
infoPurchaseMaster.MaterialReceiptMasterId = 0;
}
infoPurchaseMaster.Narration = txtNarration.Text;
infoPurchaseMaster.PurchaseAccount = Convert.ToDecimal(cmbPurchaseAccount.SelectedValue.ToString());
if (cmbPurchaseMode.Text == "Against PurchaseOrder")
{
infoPurchaseMaster.PurchaseOrderMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
}
else
{
infoPurchaseMaster.PurchaseOrderMasterId = 0;
}
infoPurchaseMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
infoPurchaseMaster.TotalTax = Convert.ToDecimal(lblTaxAmount.Text);
infoPurchaseMaster.TransportationCompany = txtTransportationCompany.Text;
infoPurchaseMaster.UserId = PublicVariables._decCurrentUserId;
infoPurchaseMaster.VendorInvoiceDate = Convert.ToDateTime(txtInvoiceDate.Text);
infoPurchaseMaster.VendorInvoiceNo = txtVendorInvoiceNo.Text;
infoPurchaseMaster.VoucherTypeId = decPurchaseInvoiceVoucherTypeId;
infoPurchaseMaster.Extra1 = string.Empty;
infoPurchaseMaster.Extra2 = string.Empty;
infoPurchaseMaster.ExtraDate = Convert.ToDateTime(DateTime.Now);
decPurchaseMasterId = BllPurchaseInvoice.PurchaseMasterAdd(infoPurchaseMaster);
infoPurchaseOrderMaster = BllPurchaseOrder.PurchaseOrderMasterView(infoPurchaseMaster.PurchaseOrderMasterId);
infoMaterialReceiptMaster = bllMaterialReceiptMaster.MaterialReceiptMasterView(infoPurchaseMaster.MaterialReceiptMasterId);
foreach (DataGridViewRow dgvrow in dgvProductDetails.Rows)
{
if (dgvrow.Cells["dgvtxtProductId"].Value != null)
{
if (dgvrow.Cells["dgvtxtProductId"].Value.ToString() != string.Empty)
{
/*-----------------------------------------Purchase Details Add----------------------------------------------------*/
infoPurchaseDetails.Amount = Convert.ToDecimal(dgvrow.Cells["dgvtxtAmount"].Value.ToString());
infoPurchaseDetails.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value.ToString());
infoPurchaseDetails.Discount = Convert.ToDecimal(dgvrow.Cells["dgvtxtDiscount"].Value.ToString());
infoPurchaseDetails.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value.ToString());
infoPurchaseDetails.GrossAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtGrossValue"].Value.ToString());
infoPurchaseDetails.NetAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtNetValue"].Value.ToString());
infoPurchaseDetails.OrderDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseOrderDetailsId"].Value.ToString());
infoPurchaseDetails.ProductId = Convert.ToDecimal(dgvrow.Cells["dgvtxtProductId"].Value.ToString());
infoPurchaseDetails.PurchaseMasterId = decPurchaseMasterId;
infoPurchaseDetails.Qty = Convert.ToDecimal(dgvrow.Cells["dgvtxtQuantity"].Value.ToString());
infoPurchaseDetails.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value.ToString());
infoPurchaseDetails.Rate = Convert.ToDecimal(dgvrow.Cells["dgvtxtRate"].Value.ToString());
infoPurchaseDetails.ReceiptDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtMaterialReceiptDetailsId"].Value.ToString());
infoPurchaseDetails.SlNo = Convert.ToInt32(dgvrow.Cells["dgvtxtSlNo"].Value.ToString());
infoPurchaseDetails.TaxAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtTaxAmount"].Value.ToString());
infoPurchaseDetails.TaxId = Convert.ToDecimal(dgvrow.Cells["dgvcmbTax"].Value.ToString());
infoPurchaseDetails.UnitConversionId = Convert.ToDecimal(dgvrow.Cells["dgvtxtUnitConversionId"].Value.ToString());
infoPurchaseDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
infoPurchaseDetails.Extra1 = string.Empty;
infoPurchaseDetails.Extra2 = string.Empty;
infoPurchaseDetails.ExtraDate = Convert.ToDateTime(DateTime.Today);
BllPurchaseInvoice.PurchaseDetailsAdd(infoPurchaseDetails);
/*-----------------------------------------Stock Posting----------------------------------------------------*/
infoStockPosting.BatchId = infoPurchaseDetails.BatchId;
infoStockPosting.Date = infoPurchaseMaster.Date;
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.GodownId = infoPurchaseDetails.GodownId;
infoStockPosting.InwardQty = infoPurchaseDetails.Qty; /// spUnitConvertion.UnitConversionRateByUnitConversionId(infoPurchaseDetails.UnitConversionId);
infoStockPosting.OutwardQty = 0;
infoStockPosting.ProductId = infoPurchaseDetails.ProductId;
infoStockPosting.RackId = infoPurchaseDetails.RackId;
infoStockPosting.Rate = infoPurchaseDetails.Rate;
infoStockPosting.UnitId = infoPurchaseDetails.UnitId;
if (infoPurchaseDetails.OrderDetailsId != 0)
{
infoStockPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstVoucherTypeId = 0;
}
else if (infoPurchaseDetails.ReceiptDetailsId != 0)
{
infoStockPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstVoucherTypeId = 0;
}
else if (infoPurchaseDetails.OrderDetailsId == 0 && infoPurchaseDetails.ReceiptDetailsId == 0)
{
infoStockPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstVoucherTypeId = 0;
}
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
infoStockPosting.ExtraDate = Convert.ToDateTime(DateTime.Today);
BllStockPosting.StockPostingAdd(infoStockPosting);
if (infoPurchaseDetails.ReceiptDetailsId != 0)
{
infoStockPosting.InvoiceNo = infoMaterialReceiptMaster.InvoiceNo;
infoStockPosting.VoucherNo = infoMaterialReceiptMaster.VoucherNo;
infoStockPosting.VoucherTypeId = infoMaterialReceiptMaster.VoucherTypeId;
infoStockPosting.AgainstInvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.AgainstVoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.AgainstVoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.InwardQty = 0;
infoStockPosting.OutwardQty = infoPurchaseDetails.Qty;/// spUnitConvertion.UnitConversionRateByUnitConversionId(infoPurchaseDetails.UnitConversionId);
BllStockPosting.StockPostingAdd(infoStockPosting);
}
}
}
}
/*-----------------------------------------Ledger Posting----------------------------------------------------*/
infoLedgerPosting.Credit = Convert.ToDecimal(txtGrandTotal.Text) * BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = infoPurchaseMaster.LedgerId;
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
decimal decBilldiscount = Convert.ToDecimal(txtBillDiscount.Text.ToString());
if (decBilldiscount > 0)
{
infoLedgerPosting.Credit = decBilldiscount * BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = 9;//ledger id of discount received
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Debit = TotalNetAmount(); //* spExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = infoPurchaseMaster.PurchaseAccount;//ledger posting of purchase account
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
foreach (DataGridViewRow dgvrow in dgvAdditionalCost.Rows)
{
if (dgvrow.Cells["dgvcmbLedger"].Value != null)
{
if (dgvrow.Cells["dgvcmbLedger"].Value.ToString() != string.Empty)
{
if (dgvrow.Cells["dgvtxtAdditionalCostAmount"].Value != null)
{
if (dgvrow.Cells["dgvtxtAdditionalCostAmount"].Value.ToString() != string.Empty)
{
/*-----------------------------------------Additional Cost Add----------------------------------------------------*/
infoAdditionalCost.Credit = 0;
infoAdditionalCost.Debit = Convert.ToDecimal(dgvrow.Cells["dgvtxtAdditionalCostAmount"].Value.ToString());
infoAdditionalCost.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvcmbLedger"].Value.ToString());
infoAdditionalCost.VoucherNo = infoPurchaseMaster.VoucherNo;
infoAdditionalCost.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoAdditionalCost.Extra1 = string.Empty;
infoAdditionalCost.Extra2 = string.Empty;
infoAdditionalCost.ExtraDate = DateTime.Now;
bllAdditionalCost.AdditionalCostAdd(infoAdditionalCost);
/*-----------------------------------------Additional Cost Ledger Posting----------------------------------------------------*/
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Debit = infoAdditionalCost.Debit * BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = infoAdditionalCost.LedgerId;
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
}
}
}
if (dgvTax.Visible)
{
foreach (DataGridViewRow dgvrow in dgvTax.Rows)
{
if (dgvrow.Cells["dgvtxtTaxId"].Value != null)
{
if (dgvrow.Cells["dgvtxtTaxId"].Value.ToString() != string.Empty)
{
/*-----------------------------------------PurchaseBillTax Add----------------------------------------------------*/
infoPurchaseBillTax.PurchaseMasterId = decPurchaseMasterId;
infoPurchaseBillTax.TaxAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtTotalTax"].Value.ToString());
infoPurchaseBillTax.TaxId = Convert.ToDecimal(dgvrow.Cells["dgvtxtTaxId"].Value.ToString());
infoPurchaseBillTax.Extra1 = string.Empty;
infoPurchaseBillTax.Extra2 = string.Empty;
infoPurchaseBillTax.ExtraDate = DateTime.Now;
BllPurchaseInvoice.PurchaseBillTaxAdd(infoPurchaseBillTax);
/*-----------------------------------------Tax Ledger Posting----------------------------------------------------*/
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Debit = infoPurchaseBillTax.TaxAmount * BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvtxtLedgerId"].Value.ToString());
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
}
}
/*-----------------------------------------PartyBalance Posting----------------------------------------------------*/
infoAccountLedger = bllAccountLedger.AccountLedgerView(infoPurchaseMaster.LedgerId);
if (infoAccountLedger.BillByBill == true)
{
infoPartyBalance.Credit = Convert.ToDecimal(txtGrandTotal.Text);
infoPartyBalance.Debit = 0;
if (txtCreditPeriod.Text != string.Empty)
{
infoPartyBalance.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text);
}
infoPartyBalance.Date = Convert.ToDateTime(txtVoucherDate.Text);
infoPartyBalance.ExchangeRateId = infoPurchaseMaster.ExchangeRateId;
infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPartyBalance.LedgerId = infoPurchaseMaster.LedgerId;
infoPartyBalance.ReferenceType = "NEW";
infoPartyBalance.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoPartyBalance.VoucherNo = infoPurchaseMaster.VoucherNo;
infoPartyBalance.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoPartyBalance.AgainstInvoiceNo = "NA";
infoPartyBalance.AgainstVoucherNo = "NA";
infoPartyBalance.AgainstVoucherTypeId = 0;
infoPartyBalance.Extra1 = string.Empty;
infoPartyBalance.Extra2 = string.Empty;
infoPartyBalance.ExtraDate = DateTime.Now;
BllPartyBalance.PartyBalanceAdd(infoPartyBalance);
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPurchaseMasterId);
}
else
{
Print(decPurchaseMasterId);
}
}
Clear();
}
catch (Exception ex)
{
MessageBox.Show("PI38:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for getting InvoiceNo Corresponding to Ledger In Register
/// </summary>
public void InvoiceNoComboFillInRegister()
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
isInvoiceFil = true;
List<DataTable> ListObj = new List<DataTable>();
ListObj = BllPurchaseInvoice.GetInvoiceNoCorrespondingtoLedgerInRegister();
cmbInvoiceNo.DataSource = ListObj[0];
if (cmbInvoiceNo.DataSource != null)
{
cmbInvoiceNo.DisplayMember = "invoiceNo";
cmbInvoiceNo.ValueMember = "purchaseMasterId";
cmbInvoiceNo.SelectedIndex = -1;
}
isInvoiceFil = false;
}
catch (Exception ex)
{
MessageBox.Show("PR:53" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for saveoredit
/// </summary>
public void SaveOrEdit()
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
int inRowCount = dgvProductDetails.RowCount;
dgvProductDetails.ClearSelection();
if (txtVoucherNo.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Enter voucher number");
txtVoucherNo.Focus();
}
else if (BllPurchaseInvoice.PurchaseInvoiceVoucherNoCheckExistance(txtVoucherNo.Text.Trim(), strVoucherNo, decPurchaseInvoiceVoucherTypeId, decPurchaseMasterId) == 1)
{
Messages.InformationMessage("Voucher number already exist");
txtVoucherNo.Focus();
}
else if (txtVoucherDate.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Select a date in between financial year");
txtVoucherDate.Focus();
}
else if (txtInvoiceDate.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Select a date in between financial year");
txtInvoiceDate.Focus();
}
else if (cmbCashOrParty.SelectedValue == null)
{
Messages.InformationMessage("Select Cash/Party");
cmbCashOrParty.Focus();
}
else if (cmbPurchaseAccount.SelectedValue == null)
{
Messages.InformationMessage("Select PurchaseAccount");
cmbPurchaseAccount.Focus();
}
else if (cmbCurrency.SelectedValue == null)
{
Messages.InformationMessage("Select Currency");
cmbCurrency.Focus();
}
else if (cmbCurrency.SelectedValue.ToString() == "0")
{
Messages.InformationMessage("Select Currency");
cmbCurrency.Focus();
}
else if (cmbPurchaseMode.Text == "Against PurchaseOrder" && cmbOrderNo.Text == string.Empty)
{
Messages.InformationMessage("Select OrderNo");
cmbOrderNo.Focus();
}
else if (cmbPurchaseMode.Text == "Against MaterialReceipt" && cmbOrderNo.Text == string.Empty)
{
Messages.InformationMessage("Select ReceiptNo");
cmbOrderNo.Focus();
}
else
{
if (RemoveIncompleteRowsFromGrid())
{
if (dgvProductDetails.Rows.Count != 0)
{
if (dgvProductDetails.Rows[0].Cells["dgvtxtProductName"].Value == null && dgvProductDetails.Rows[0].Cells["dgvtxtProductCode"].Value == null)
{
MessageBox.Show("Can't save purchase invoice without atleast one product with complete details", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvProductDetails.ClearSelection();
dgvProductDetails.Focus();
}
else
{
if (btnSave.Text == "Save")
{
if (dgvProductDetails.Rows[0].Cells["dgvtxtProductName"].Value == null)
{
MessageBox.Show("Can't save purchase order without atleast one product with complete details", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvProductDetails.ClearSelection();
dgvProductDetails.Focus();
}
else
{
if (PublicVariables.isMessageAdd)
{
if (Messages.SaveMessage())
{
Save();
}
}
else
{
Save();
}
}
}
if (btnSave.Text == "Update")
{
if (QuantityCheckWithReference() == 1 && PartyBalanceCheckWithReference() == 1)
{
if (dgvProductDetails.Rows[0].Cells["dgvtxtProductName"].Value == null)
{
MessageBox.Show("Can't Edit purchase invoice without atleast one product with complete details", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvProductDetails.ClearSelection();
dgvProductDetails.Focus();
}
else
{
if (PublicVariables.isMessageEdit)
{
if (Messages.UpdateMessage())
{
Edit();
}
}
else
{
Edit();
}
}
}
}
}
}
else
{
Messages.InformationMessage("Can't save purchase invoice without atleast one product with complete details");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PI37:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Remove incomplete Rows from grid
/// </summary>
public bool RemoveIncompleteRowsFromGrid()
{
bool isOk = true;
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
SettingsBll BllSettings = new SettingsBll();
try
{
string strMessage = "Rows";
int inC = 0, inForFirst = 0;
int inRowcount = dgvPurchaseReturn.RowCount;
int inLastRow = 1;
if (inRowcount <= 2)
{
if (dgvPurchaseReturn.Rows[0].Cells["dgvtxtproductName"].Value == null || dgvPurchaseReturn.Rows[0].Cells["dgvtxtproductName"].Value.ToString() == string.Empty ||
dgvPurchaseReturn.Rows[0].Cells["dgvtxtproductCode"].Value == null || dgvPurchaseReturn.Rows[0].Cells["dgvtxtproductCode"].Value.ToString() == string.Empty ||
dgvPurchaseReturn.Rows[0].Cells["dgvtxtrate"].Value == null || dgvPurchaseReturn.Rows[0].Cells["dgvtxtrate"].Value.ToString().Trim() == string.Empty ||
dgvPurchaseReturn.Rows[0].Cells["dgvtxtqty"].Value == null || dgvPurchaseReturn.Rows[0].Cells["dgvtxtqty"].Value.ToString().Trim() == string.Empty ||
Convert.ToDecimal(dgvPurchaseReturn.Rows[0].Cells["dgvtxtqty"].Value.ToString()) == 0 ||
(BllSettings.SettingsStatusCheck("AllowZeroValueEntry") == "No" && Convert.ToDecimal(dgvPurchaseReturn.Rows[0].Cells["dgvtxtrate"].Value) == 0))
{
Messages.InformationMessage("Can't save purchase return without atleast one product with complete details");
dgvPurchaseReturn.ClearSelection();
dgvPurchaseReturn.Focus();
isOk = false;
}
}
else
{
foreach (DataGridViewRow dgvrowCur in dgvPurchaseReturn.Rows)
{
if (inLastRow < inRowcount && dgvrowCur.HeaderCell.Value != null)
{
if (dgvrowCur.HeaderCell.Value.ToString() == "X" || dgvrowCur.Cells["dgvtxtproductName"].Value == null)
{
isOk = false;
if (inC == 0)
{
strMessage = strMessage + Convert.ToString(dgvrowCur.Index + 1);
inForFirst = dgvrowCur.Index;
inC++;
}
else
{
strMessage = strMessage + ", " + Convert.ToString(dgvrowCur.Index + 1);
}
}
}
inLastRow++;
}
inLastRow = 1;
if (!isOk)
{
strMessage = strMessage + " contains invalid entries. Do you want to continue?";
if (MessageBox.Show(strMessage, "OpenMiracle", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
isOk = true;
for (int inK = 0; inK < dgvPurchaseReturn.Rows.Count; inK++)
{
if (dgvPurchaseReturn.Rows[inK].HeaderCell.Value != null && dgvPurchaseReturn.Rows[inK].HeaderCell.Value.ToString() == "X" && !dgvPurchaseReturn.Rows[inK].IsNewRow)
{
dgvPurchaseReturn.Rows.RemoveAt(inK);
inK--;
SerialNo();
}
}
}
else
{
isOk = false;
dgvPurchaseReturn.Rows[inForFirst].Cells["dgvtxtproductName"].Selected = true;
dgvPurchaseReturn.CurrentCell = dgvPurchaseReturn.Rows[inForFirst].Cells["dgvtxtproductName"];
dgvPurchaseReturn.Focus();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PR:47" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return isOk;
}
/// <summary>
/// Function to fill Tax grid
/// </summary>
public void TaxGridFill()
{
try
{
List<DataTable> ListObj = new List<DataTable>();
TaxBll bllTax = new TaxBll();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
if (decPurchaseMasterId == 0)
{
ListObj = bllTax.TaxViewAllByVoucherTypeIdForPurchaseInvoice(decPurchaseInvoiceVoucherTypeId);
}
else
{
ListObj = BllPurchaseInvoice.PurchaseBillTaxViewAllByPurchaseMasterId(decPurchaseMasterId);
}
dgvTax.DataSource = ListObj[0];
TaxSerialNo();
}
catch (Exception ex)
{
MessageBox.Show("PI24:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Voucher Type combobox
/// </summary>
public void VoucherTypeCombofill()
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
List<DataTable> ListObj = new List<DataTable>();
ListObj = BllPurchaseInvoice.VoucherTypeComboFillForPurchaseInvoice();
cmbVoucherType.DataSource = ListObj[0];
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("PR:04" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for voucher number generation
/// </summary>
public void VoucherNumberGeneration()
{
try
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decPurchaseInvoiceVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, strTableName);
if (Convert.ToDecimal(strVoucherNo) != (BllPurchaseInvoice.PurchaseMasterVoucherMax(decPurchaseInvoiceVoucherTypeId)))
{
strVoucherNo = BllPurchaseInvoice.PurchaseMasterVoucherMax(decPurchaseInvoiceVoucherTypeId).ToString();
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decPurchaseInvoiceVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, strTableName);
if (BllPurchaseInvoice.PurchaseMasterVoucherMax(decPurchaseInvoiceVoucherTypeId) == 0)
{
strVoucherNo = "0";
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decPurchaseInvoiceVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, strTableName);
}
}
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decPurchaseInvoiceVoucherTypeId, dtpVoucherDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
decPurchaseInvoiceSuffixPrefixId = infoSuffixPrefix.SuffixprefixId;
txtVoucherNo.Text = strPrefix + strVoucherNo + strSuffix;
txtVoucherNo.ReadOnly = true;
}
}
catch (Exception ex)
{
MessageBox.Show("PI8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Delete
/// </summary>
public void Delete()
{
try
{
StockPostingBll BllStockPosting=new StockPostingBll();
// StockPostingSP spStockPosting = new StockPostingSP();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
PurchaseReturnBll BllPurchaseReturn = new PurchaseReturnBll();
PurchaseMasterInfo infoPurchaseMaster = new PurchaseMasterInfo();
PurchaseReturnMasterInfo infoPurchaseReturnMaster = new PurchaseReturnMasterInfo();
infoPurchaseReturnMaster = BllPurchaseReturn.PurchaseReturnMasterView(decPurchaseReturnMasterId);
if (infoPurchaseReturnMaster.PurchaseMasterId == 0)
{
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(0, "NA", infoPurchaseReturnMaster.VoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
if (infoPurchaseReturnMaster.PurchaseMasterId != 0)
{
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(infoPurchaseMaster.VoucherTypeId, infoPurchaseMaster.VoucherNo, strVoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
BllLedgerPosting.LedgerPostingAndPartyBalanceDeleteByVoucherTypeIdAndLedgerIdAndVoucherNo(decPurchaseReturnVoucherTypeId, strVoucherNo, txtReturnNo.Text);
BllPurchaseReturn.PurchaseReturnMasterAndDetailsDelete(decPurchaseReturnMasterId);
Messages.DeletedMessage();
if (frmPurchaseReturnRegisterObj != null)
{
this.Close();
frmPurchaseReturnRegisterObj.GridFill();
}
if (ObjPurchaseReturnReport != null)
{
this.Close();
ObjPurchaseReturnReport.PurchaseReturnReportGridFill();
}
if (frmLedgerDetailsObj != null)
{
this.Close();
frmLedgerDetailsObj.LedgerDetailsView();
}
if (objVoucherSearch != null)
{
this.Close();
objVoucherSearch.GridFill();
}
if (frmDayBookObj != null)
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("PR:50 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the order number combo box
/// </summary>
/// <param name="decLedger"></param>
/// <param name="decvoucherTypeId"></param>
public void OrderNoComboFill(decimal decLedger, decimal decvoucherTypeId)
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
isOrderFil = true;
List<DataTable> ListObj = new List<DataTable>();
ListObj = BllPurchaseInvoice.GetOrderNoCorrespondingtoLedger(decLedger, decMaterialReceiptMasterId, decvoucherTypeId);
cmbOrderNo.DataSource = ListObj[0];
if (cmbOrderNo.DataSource != null)
{
cmbOrderNo.DisplayMember = "invoiceNo";
cmbOrderNo.ValueMember = "purchaseOrderMasterId";
cmbOrderNo.SelectedIndex = -1;
}
isOrderFil = false;
}
catch (Exception ex)
{
MessageBox.Show("MR29:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// When doubleclicking on the grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvReport_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
decimal decVouchertypeId = 0;
string strVoucherNo = string.Empty;
try
{
if (dgvReport.CurrentRow.Index == e.RowIndex)
{
if ((dgvReport.CurrentRow.Cells["voucherTypeId"].Value != null && dgvReport.CurrentRow.Cells["voucherTypeId"].Value.ToString() != string.Empty))
{
int inI = dgvReport.CurrentCell.RowIndex;
foreach (DataGridViewRow dgv in dgvReport.Rows)
{
if (dgv.Cells["VoucherNo"].Value != null && dgv.Cells["VoucherNo"].Value.ToString() != string.Empty &&
dgv.Cells["voucherTypeId"].Value != null && dgv.Cells["voucherTypeId"].Value.ToString() != string.Empty)
{
strVoucherType = dgv.Cells["VoucherType"].Value.ToString();
decVouchertypeId = Convert.ToDecimal(dgv.Cells["voucherTypeId"].Value.ToString());
strVoucherNo = dgv.Cells["VoucherNo"].Value.ToString();
}
else
{
if (dgv.Cells["ledgerId"].Value.ToString() != string.Empty)
{
decledgerId = decimal.Parse(dgv.Cells["ledgerId"].Value.ToString());
strVoucherType = dgv.Cells["Account Ledger"].Value.ToString();
frmLedgerDetails frmLedger = new frmLedgerDetails();
frmLedger = Application.OpenForms["frmLedgerDetails"] as frmLedgerDetails;
if (frmLedger == null)
{
frmLedger = new frmLedgerDetails();
frmLedger.MdiParent = formMDI.MDIObj;
frmLedger.callFromAgeing(this, decledgerId);
this.Enabled = false;
}
}
}
if (dgv.Index == inI)
{
break;
}
}
if (strVoucherType == "Payment Voucher")
{
PaymentVoucherBll BllPaymentVoucher = new PaymentVoucherBll();
decMasterId = BllPaymentVoucher.paymentMasterIdView(decVouchertypeId, strVoucherNo);
frmPaymentVoucher frmPaymentVoucher = new frmPaymentVoucher();
frmPaymentVoucher = Application.OpenForms["frmPaymentVoucher"] as frmPaymentVoucher;
if (frmPaymentVoucher == null)
{
frmPaymentVoucher = new frmPaymentVoucher();
frmPaymentVoucher.MdiParent = formMDI.MDIObj;
frmPaymentVoucher.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "Receipt Voucher")
{
RecieptVoucherBll bllRecieptVoucher = new RecieptVoucherBll();
//ReceiptMasterSP spRecieptMaster = new ReceiptMasterSP();
decMasterId = bllRecieptVoucher.ReceiptMasterIdView(decVouchertypeId, strVoucherNo);
frmReceiptVoucher frmReceiptVoucher = new frmReceiptVoucher();
frmReceiptVoucher = Application.OpenForms["frmReceiptVoucher"] as frmReceiptVoucher;
if (frmReceiptVoucher == null)
{
frmReceiptVoucher = new frmReceiptVoucher();
frmReceiptVoucher.MdiParent = formMDI.MDIObj;
frmReceiptVoucher.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "Journal Voucher")
{
JournalVoucherBll bllJournalMaster = new JournalVoucherBll();
decMasterId = bllJournalMaster.JournalMasterIdView(decVouchertypeId, strVoucherNo);
frmJournalVoucher frmJournalVoucher = new frmJournalVoucher();
frmJournalVoucher = Application.OpenForms["frmJournalVoucher"] as frmJournalVoucher;
if (frmJournalVoucher == null)
{
frmJournalVoucher = new frmJournalVoucher();
frmJournalVoucher.MdiParent = formMDI.MDIObj;
frmJournalVoucher.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "PDC Receivable")
{
PDCRecivebleBll BllPDCReciveble = new PDCRecivebleBll();
decMasterId = BllPDCReciveble.PdcReceivableMasterIdView(decVouchertypeId, strVoucherNo);
frmPdcReceivable frmPdcReceivable = new frmPdcReceivable();
frmPdcReceivable = Application.OpenForms["frmPdcReceivable"] as frmPdcReceivable;
if (frmPdcReceivable == null)
{
frmPdcReceivable = new frmPdcReceivable();
frmPdcReceivable.MdiParent = formMDI.MDIObj;
frmPdcReceivable.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "PDC Payable")
{
PDCPayableBll BllPDCPayable = new PDCPayableBll();
decMasterId = BllPDCPayable.PdcPayableMasterIdView(decVouchertypeId, strVoucherNo);
frmPdcPayable frmPdcPayable = new frmPdcPayable();
frmPdcPayable = Application.OpenForms["frmPdcPayable"] as frmPdcPayable;
if (frmPdcPayable == null)
{
frmPdcPayable = new frmPdcPayable();
frmPdcPayable.MdiParent = formMDI.MDIObj;
frmPdcPayable.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "Sales Invoice")
{
//SalesMasterSP spMaster = new SalesMasterSP();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
decMasterId = BllSalesInvoice.SalesMasterIdViewByvoucherNoAndVoucherType(decVouchertypeId, strVoucherNo);
//SalesMasterSP spSalesMaster = new SalesMasterSP();
bool blPOS = BllSalesInvoice.DayBookSalesInvoiceOrPOS(decMasterId, decVouchertypeId);
frmSalesInvoice frmSalesInvoice = new frmSalesInvoice();
frmPOS frmPOS = new frmPOS();
if (blPOS == true)
{
frmPOS = Application.OpenForms["frmPOS"] as frmPOS;
if (frmPOS == null)
{
frmPOS = new frmPOS();
frmPOS.MdiParent = formMDI.MDIObj;
frmPOS.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else
{
frmSalesInvoice = Application.OpenForms["frmSalesInvoice"] as frmSalesInvoice;
if (frmSalesInvoice == null)
{
frmSalesInvoice = new frmSalesInvoice();
frmSalesInvoice.MdiParent = formMDI.MDIObj;
frmSalesInvoice.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
}
else if (strVoucherType == "Purchase Invoice")
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
decMasterId = BllPurchaseInvoice.PurchaseMasterIdViewByvoucherNoAndVoucherType(decVouchertypeId, strVoucherNo);
frmPurchaseInvoice objpurchase = new frmPurchaseInvoice();
objpurchase.WindowState = FormWindowState.Normal;
objpurchase.MdiParent = formMDI.MDIObj;
objpurchase.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
else if (strVoucherType == "Credit Note")
{
CreditNoteBll BllCreditNoteMaster = new CreditNoteBll();
decMasterId = BllCreditNoteMaster.CreditNoteMasterIdView(decVouchertypeId, strVoucherNo);
frmCreditNote objpurchase = new frmCreditNote();
objpurchase.WindowState = FormWindowState.Normal;
objpurchase.MdiParent = formMDI.MDIObj;
objpurchase.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
else if (strVoucherType == "Debit Note")
{
//DebitNoteMasterSP spDebitNote = new DebitNoteMasterSP();
DebitNoteBll bllDebitNote = new DebitNoteBll();
decMasterId = bllDebitNote.DebitNoteMasterIdView(decVouchertypeId, strVoucherNo);
frmDebitNote objpurchase = new frmDebitNote();
objpurchase.WindowState = FormWindowState.Normal;
objpurchase.MdiParent = formMDI.MDIObj;
objpurchase.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("AR17:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void Delete()
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
AditionalCostBll bllAdditionalCost = new AditionalCostBll();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
StockPostingBll BllStockPosting = new StockPostingBll();
// StockPostingSP spStockPosting = new StockPostingSP();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
PurchaseOrderBll BllPurchaseOrder = new PurchaseOrderBll();
MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll();
PurchaseOrderMasterInfo infoPurchaseOrderMaster = new PurchaseOrderMasterInfo();
MaterialReceiptMasterInfo infoMaterialReceiptMaster = new MaterialReceiptMasterInfo();
PurchaseMasterInfo infoPurchaseMaster = new PurchaseMasterInfo();
/*---------------------------------Deleting previous stock posting, Ledger posting, partybalanceposting---------------------------------------*/
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(decPurchaseMasterId);
if (infoPurchaseMaster.MaterialReceiptMasterId != 0)
{
infoMaterialReceiptMaster = bllMaterialReceiptMaster.MaterialReceiptMasterView(infoPurchaseMaster.MaterialReceiptMasterId);
BllStockPosting.StockPostingDeleteForSalesInvoiceAgainstDeliveryNote
(infoPurchaseMaster.VoucherTypeId, infoPurchaseMaster.VoucherNo,
infoMaterialReceiptMaster.VoucherNo, infoMaterialReceiptMaster.VoucherTypeId);
}
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType
(0, "NA", infoPurchaseMaster.VoucherNo, infoPurchaseMaster.VoucherTypeId);
//-------------------------------------------------
decimal decPurchaseDetailsId = 0;
decimal decPurchaseOrderMasterId = 0;
decimal decMaterialReceiptMasterId = 0;
decimal decAdditionalCostId = 0;
decimal decPurchaseBillTaxId = 0;
int inRef = 0;
bool isRef = false;
try
{
foreach (DataGridViewRow dgvrow in dgvProductDetails.Rows)
{
if (dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value != null)
{
if (dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value.ToString() != string.Empty && dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value.ToString() != "0")
{
decPurchaseDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value.ToString());
inRef = BllPurchaseInvoice.PurchaseMasterReferenceCheck(decPurchaseMasterId, decPurchaseDetailsId);
if (inRef > 0 && !isRef)
{
isRef = true;
}
}
}
}
if (!isRef)
{
isRef = bllAccountLedger.PartyBalanceAgainstReferenceCheck(strVoucherNo, decPurchaseInvoiceVoucherTypeId);
if (!isRef)
{
BllPurchaseInvoice.PurchaseMasterDelete(decPurchaseMasterId);
BllPurchaseInvoice.PurchaseDetailsDeleteByPurchaseMasterId(decPurchaseMasterId);
foreach (DataGridViewRow dgvrow in dgvAdditionalCost.Rows)
{
if (dgvrow.Cells["dgvtxtAdditionalCostId"].Value != null)
{
if (dgvrow.Cells["dgvtxtAdditionalCostId"].Value.ToString() != string.Empty &&
dgvrow.Cells["dgvtxtAdditionalCostId"].Value.ToString() != "0")
{
decAdditionalCostId = Convert.ToDecimal(dgvrow.Cells["dgvtxtAdditionalCostId"].Value.ToString());
bllAdditionalCost.AdditionalCostDelete(decAdditionalCostId);
}
}
}
if (dgvTax.Visible)
{
foreach (DataGridViewRow dgvrow in dgvTax.Rows)
{
if (dgvrow.Cells["dgvtxtPurchaseBillTaxId"].Value != null)
{
if (dgvrow.Cells["dgvtxtPurchaseBillTaxId"].Value.ToString() != string.Empty &&
dgvrow.Cells["dgvtxtPurchaseBillTaxId"].Value.ToString() != "0")
{
decPurchaseBillTaxId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseBillTaxId"].Value.ToString());
BllPurchaseInvoice.PurchaseBillTaxDelete(decPurchaseBillTaxId);
}
}
}
}
if (cmbPurchaseMode.Text == "Against PurchaseOrder")
{
decPurchaseOrderMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
infoPurchaseOrderMaster = BllPurchaseOrder.PurchaseOrderMasterView(decPurchaseOrderMasterId);
}
else if (cmbPurchaseMode.Text == "Against MaterialReceipt")
{
decMaterialReceiptMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
infoMaterialReceiptMaster = bllMaterialReceiptMaster.MaterialReceiptMasterView(decMaterialReceiptMasterId);
}
BllLedgerPosting.LedgerPostDelete(strVoucherNo, decPurchaseInvoiceVoucherTypeId);
if (infoPurchaseOrderMaster.PurchaseOrderMasterId != 0)
{
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType
(decPurchaseInvoiceVoucherTypeId, strVoucherNo,
infoPurchaseOrderMaster.VoucherNo, infoPurchaseOrderMaster.VoucherTypeId);
}
else if (infoMaterialReceiptMaster.MaterialReceiptMasterId != 0)
{
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType
(decPurchaseInvoiceVoucherTypeId, strVoucherNo,
infoMaterialReceiptMaster.VoucherNo, infoMaterialReceiptMaster.VoucherTypeId);
}
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType
(0, "NA", strVoucherNo, decPurchaseInvoiceVoucherTypeId);
bllAccountLedger.PartyBalanceDeleteByVoucherTypeVoucherNoAndReferenceType(strVoucherNo, decPurchaseInvoiceVoucherTypeId);
Messages.DeletedMessage();
Clear();
this.Close();
}
else
{
Messages.InformationMessage("Cannot delete purchase invoice because there is a payment voucher against this invoice");
}
}
else
{
Messages.InformationMessage("Cannot delete purchase invoice because reference exists");
}
}
catch (Exception ex)
{
MessageBox.Show("PI41:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}