/// <summary>
/// Function to fill the grid to edit the details
/// </summary>
public void SalesQuotationDetailsEditFill()
{
SalesQuotationDetailsSP SpSalesQuotationDetails = new SalesQuotationDetailsSP();
SalesQuotationDetailsInfo infoSalesQuotationDetails = new SalesQuotationDetailsInfo();
ProductSP SpProduct = new ProductSP();
ProductInfo infoproduct = new ProductInfo();
try
{
for (int inI = 0; inI < dgvProduct.Rows.Count - 1; inI++)
{
infoSalesQuotationDetails.QuotationMasterId = decSalesquotationMasterId;
infoSalesQuotationDetails.QuotationDetailsId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQuotationDetailsId"].Value);
infoproduct = SpProduct.ProductViewByCode(dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoSalesQuotationDetails.ProductId = infoproduct.ProductId;
infoSalesQuotationDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
if (Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQuotationDetailsId"].Value) == 0)
{
infoSalesQuotationDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
}
else
{
DGVUnitComboFill();
infoSalesQuotationDetails.UnitId = Convert.ToDecimal((dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString()));
}
decimal unitConversion = SpSalesQuotationDetails.UnitconversionIdViewByUnitIdAndProductId(infoSalesQuotationDetails.UnitId, infoSalesQuotationDetails.ProductId);
infoSalesQuotationDetails.UnitConversionId = unitConversion;
infoSalesQuotationDetails.BatchId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value);
infoSalesQuotationDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value);
infoSalesQuotationDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value);
infoSalesQuotationDetails.Slno = Convert.ToInt32(dgvProduct.Rows[inI].Cells["dgvtxtSlNo"].Value);
infoSalesQuotationDetails.Extra1 = string.Empty;
infoSalesQuotationDetails.Extra2 = string.Empty;
SpSalesQuotationDetails.SalesQuotationDetailsEdit(infoSalesQuotationDetails);
}
}
catch (Exception ex)
{
MessageBox.Show("SQ:20" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to get the Details
/// </summary>
public void DeliveryNoteDetails()
{
try
{
ProductInfo infoProduct = new ProductInfo();
ProductSP spProduct = new ProductSP();
DeliveryNoteDetailsInfo infoDeliveryNoteDetails = new DeliveryNoteDetailsInfo();
StockPostingInfo infoStockPosting = new StockPostingInfo();
StockPostingSP spStockPosting = new StockPostingSP();
DeliveryNoteDetailsSP spDeliveryNoteDetails = new DeliveryNoteDetailsSP();
UnitSP spUnit = new UnitSP();
for (int inI = 0; inI < dgvProduct.Rows.Count - 1; inI++)
{
if (dgvProduct.Rows[inI].Cells["dgvtxtDetailsId"].Value == null)
{
if (cmbDeliveryMode.Text == "Against Order")
{
if (dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value != null)
{
infoDeliveryNoteDetails.OrderDetails1Id = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value == null ? string.Empty : dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value.ToString());
}
else
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
else if (cmbDeliveryMode.Text == "Against Quotation")
{
if (dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value != null)
{
infoDeliveryNoteDetails.QuotationDetails1Id = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value == null ? string.Empty : dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value.ToString());
}
else
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
else if (cmbDeliveryMode.Text == "NA")
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
else
{
if (dgvProduct.Rows[inI].Cells["dgvtxtDetailsId"].Value != null)
{
if (cmbDeliveryMode.Text == "Against Order")
{
infoDeliveryNoteDetails.OrderDetails1Id = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value.ToString());
}
else if (cmbDeliveryMode.Text == "Against Quotation")
{
infoDeliveryNoteDetails.QuotationDetails1Id = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value.ToString());
}
else if (cmbDeliveryMode.Text == "NA")
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
else
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
if (dgvProduct.Rows[inI].Cells["dgvtxtDetailsId"].Value == null || dgvProduct.Rows[inI].Cells["dgvtxtDetailsId"].Value.ToString() == string.Empty || Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtDetailsId"].Value) == 0)
{
infoDeliveryNoteDetails.DeliveryNoteMasterId = decDelivryNoteIdToEdit;
infoProduct = spProduct.ProductViewByCode(dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoDeliveryNoteDetails.ProductId = infoProduct.ProductId;
infoDeliveryNoteDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
infoDeliveryNoteDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value);
infoDeliveryNoteDetails.BatchId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString());
infoDeliveryNoteDetails.GodownId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString());
infoDeliveryNoteDetails.RackId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbRack"].Value.ToString());
infoDeliveryNoteDetails.UnitConversionId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString());
infoDeliveryNoteDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoDeliveryNoteDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoDeliveryNoteDetails.SlNo = Convert.ToInt32(dgvProduct.Rows[inI].Cells["Col"].Value.ToString());
infoDeliveryNoteDetails.Extra1 = string.Empty;
infoDeliveryNoteDetails.Extra2 = string.Empty;
spDeliveryNoteDetails.DeliveryNoteDetailsAdd(infoDeliveryNoteDetails);
}
else
{
infoDeliveryNoteDetails.DeliveryNoteMasterId = decDelivryNoteIdToEdit;
infoDeliveryNoteDetails.DeliveryNoteDetails1Id = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtDetailsId"].Value);
infoProduct = spProduct.ProductViewByCode(dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoDeliveryNoteDetails.ProductId = infoProduct.ProductId;
infoDeliveryNoteDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
if (Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtDetailsId"].Value) == 0)
{
infoDeliveryNoteDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
}
else
{
infoDeliveryNoteDetails.UnitId = Convert.ToDecimal(spUnit.UnitIdByUnitName(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].FormattedValue.ToString()));
}
infoDeliveryNoteDetails.BatchId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString());
infoDeliveryNoteDetails.GodownId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString());
infoDeliveryNoteDetails.RackId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbRack"].Value.ToString());
infoDeliveryNoteDetails.UnitConversionId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString());
infoDeliveryNoteDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoDeliveryNoteDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoDeliveryNoteDetails.SlNo = Convert.ToInt32(dgvProduct.Rows[inI].Cells["Col"].Value.ToString());
spDeliveryNoteDetails.DeliveryNoteDetailsEdit(infoDeliveryNoteDetails);
}
infoStockPosting.Date = Convert.ToDateTime(txtDate.Text);
if (Convert.ToInt32(dgvProduct.Rows[inI].Cells["dgvtxtVoucherTypeId"].Value) != 0)
{
if (cmbDeliveryMode.SelectedItem.ToString() != "NA")
{
if (dgvProduct.Rows[inI].Cells["dgvtxtVoucherTypeId"].Value != null)
{
infoStockPosting.VoucherTypeId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtVoucherTypeId"].Value);
}
else
{
infoStockPosting.VoucherTypeId = 0;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtVoucherNo"].Value != null)
{
infoStockPosting.VoucherNo = dgvProduct.Rows[inI].Cells["dgvtxtVoucherNo"].Value.ToString();
}
else
{
infoStockPosting.VoucherNo = string.Empty;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtInvoiceNo"].Value != null)
{
infoStockPosting.InvoiceNo = dgvProduct.Rows[inI].Cells["dgvtxtInvoiceNo"].Value.ToString();
}
else
{
infoStockPosting.InvoiceNo = string.Empty;
}
if (decDeliveryNoteVoucherTypeId != 0)
{
infoStockPosting.AgainstVoucherTypeId = decDeliveryNoteVoucherTypeId;
}
else
{
infoStockPosting.AgainstVoucherTypeId = 0;
}
if (strVoucherNo != string.Empty)
{
infoStockPosting.AgainstVoucherNo = strVoucherNo;
}
else
{
infoStockPosting.AgainstVoucherNo = string.Empty;
}
if (txtDeliveryNoteNo.Text != string.Empty)
{
infoStockPosting.AgainstInvoiceNo = txtDeliveryNoteNo.Text;
}
else
{
infoStockPosting.AgainstInvoiceNo = string.Empty;
}
}
}
else
{
infoStockPosting.InvoiceNo = txtDeliveryNoteNo.Text;
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.VoucherTypeId = decDeliveryNoteVoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstInvoiceNo = "NA";
}
infoStockPosting.ProductId = infoDeliveryNoteDetails.ProductId;
infoStockPosting.BatchId = infoDeliveryNoteDetails.BatchId;
infoStockPosting.UnitId = infoDeliveryNoteDetails.UnitId;
infoStockPosting.GodownId = infoDeliveryNoteDetails.GodownId;
infoStockPosting.RackId = infoDeliveryNoteDetails.RackId;
infoStockPosting.OutwardQty = infoDeliveryNoteDetails.Qty;
infoStockPosting.Rate = infoDeliveryNoteDetails.Rate;
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
spStockPosting.StockPostingAdd(infoStockPosting);
}
}
catch (Exception ex)
{
MessageBox.Show("DN36:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On cellendedit of dgvProduct
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvProduct_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
ProductSP SpProduct = new ProductSP();
try
{
if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtProductName")
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value.ToString().Trim() != string.Empty)
{
string strProductName = Convert.ToString(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value);
ProductInfo infoProduct = SpProduct.ProductViewByName(strProductName);
if (infoProduct.ProductCode != null && infoProduct.ProductCode != string.Empty)
{
TransactionsGeneralFill transactionGeneralFillObj = new TransactionsGeneralFill();
SalesQuotationMasterSP SpSalesQuotationMaster = new SalesQuotationMasterSP();
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = infoProduct.ProductCode;
dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value = infoProduct.ProductId;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(infoProduct.SalesRate);
DefaultRate = Math.Round(infoProduct.PurchaseRate, PublicVariables._inNoOfDecimalPlaces);
dtblUnitViewAll = transactionGeneralFillObj.UnitViewAllByProductId(dgvProduct, infoProduct.ProductId.ToString(), e.RowIndex);
dtblbatchViewAll = SpSalesQuotationMaster.SalesQuotationMasterBatchFill(dgvProduct, infoProduct.ProductId, e.RowIndex);
BatchSP spBatch = new BatchSP();
decimal decBatchId = spBatch.BatchIdViewByProductId(infoProduct.ProductId);
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = decBatchId;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
if (infoProduct.PartNo != string.Empty)
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = infoProduct.PartNo;
}
else
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
decBatchId = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value);
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = SpProduct.BarcodeViewByBatchId(decBatchId);
}
}
IsDoAfterFill = true;
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
DataTable dtblUnitByProduct = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value.ToString());
if (dtblUnitByProduct.Rows.Count > 0)
{
foreach (DataRow drUnitByProduct in dtblUnitByProduct.Rows)
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[2].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[3].ToString());
if (IsDoAfterFill)
{
decimal decNewConversionRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString());
decimal decNewRate = (decCurrentRate * decCurrentConversionRate) / decNewConversionRate;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(decNewRate,PublicVariables._inNoOfDecimalPlaces);
}
}
}
}
decimal decStandardRate = SpProduct.SalesInvoiceProductRateForSales(infoProduct.ProductId, PublicVariables._dtCurrentDate, decBatchId, Convert.ToDecimal(cmbPricinglevel.SelectedValue), PublicVariables._inNoOfDecimalPlaces);
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString() != string.Empty)
{
if (decStandardRate != 0 && Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value) != 0)
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(decStandardRate / Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value), PublicVariables._inNoOfDecimalPlaces);
}
}
}
else
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value = string.Empty;
}
AmountCalculation("dgvtxtQty", e.RowIndex);
TotalAmountCalculation();
}
else
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
}
}
if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtBarcode")
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value.ToString().Trim() != string.Empty)
{
DataTable dtblProductdDetails = new DataTable();
string strBarcode = (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value.ToString());
dtblProductdDetails = SpProduct.ProductDetailsCoreespondingToBarcode(strBarcode);
if (dtblProductdDetails.Rows.Count > 0)
{
TransactionsGeneralFill transactionGeneralFillObj = new TransactionsGeneralFill();
SalesQuotationMasterSP SpSalesQuotationMaster = new SalesQuotationMasterSP();
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = dtblProductdDetails.Rows[0]["productCode"].ToString();
dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value = dtblProductdDetails.Rows[0]["productId"].ToString();
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = dtblProductdDetails.Rows[0]["productName"].ToString();
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(Convert.ToDecimal(dtblProductdDetails.Rows[0]["SalesRate"].ToString()));
DefaultRate = Math.Round(Convert.ToDecimal(dtblProductdDetails.Rows[0]["purchaseRate"].ToString()), PublicVariables._inNoOfDecimalPlaces);
dtblUnitViewAll = transactionGeneralFillObj.UnitViewAllByProductId(dgvProduct, dtblProductdDetails.Rows[0]["productId"].ToString(), e.RowIndex);
dtblbatchViewAll = SpSalesQuotationMaster.SalesQuotationMasterBatchFill(dgvProduct, Convert.ToDecimal(dtblProductdDetails.Rows[0]["productId"].ToString()), e.RowIndex);
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(dtblProductdDetails.Rows[0]["batchId"].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(dtblProductdDetails.Rows[0]["unitId"].ToString());
IsDoAfterFill = true;
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
DataTable dtblUnitByProduct = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value.ToString());
if (dtblUnitByProduct.Rows.Count > 0)
{
foreach (DataRow drUnitByProduct in dtblUnitByProduct.Rows)
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[2].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[3].ToString());
if (IsDoAfterFill)
{
decimal decNewConversionRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString());
decimal decNewRate = (decCurrentRate * decCurrentConversionRate) / decNewConversionRate;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(decNewRate, PublicVariables._inNoOfDecimalPlaces);
}
}
}
}
decimal decStandardRate = SpProduct.SalesInvoiceProductRateForSales(Convert.ToDecimal(dtblProductdDetails.Rows[0]["productId"].ToString()), PublicVariables._dtCurrentDate, decBatchId, Convert.ToDecimal(cmbPricinglevel.SelectedValue), PublicVariables._inNoOfDecimalPlaces);
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString() != string.Empty)
{
if (decStandardRate != 0 && Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value) != 0)
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(decStandardRate / Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value), PublicVariables._inNoOfDecimalPlaces);
}
}
}
else
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value = string.Empty;
}
AmountCalculation("dgvtxtQty", e.RowIndex);
TotalAmountCalculation();
}
else
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
}
}
else if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtProductCode")
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value.ToString().Trim() != string.Empty)
{
ProductInfo infoProduct = new ProductInfo();
string strProductCode = dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value.ToString();
infoProduct = SpProduct.ProductViewByCode(strProductCode);
if (infoProduct.ProductId != 0)
{
TransactionsGeneralFill transactionGeneralFillObj = new TransactionsGeneralFill();
SalesQuotationMasterSP SpSalesQuotationMaster = new SalesQuotationMasterSP();
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = infoProduct.ProductName;
dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value = infoProduct.ProductId;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(infoProduct.SalesRate, PublicVariables._inNoOfDecimalPlaces);
DefaultRate = Math.Round(infoProduct.PurchaseRate, PublicVariables._inNoOfDecimalPlaces);
dtblUnitViewAll = transactionGeneralFillObj.UnitViewAllByProductId(dgvProduct, infoProduct.ProductId.ToString(), e.RowIndex);
dtblbatchViewAll = SpSalesQuotationMaster.SalesQuotationMasterBatchFill(dgvProduct, infoProduct.ProductId, e.RowIndex);
BatchSP spBatch = new BatchSP();
decimal decBatchId = spBatch.BatchIdViewByProductId(infoProduct.ProductId);
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = decBatchId;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
if (infoProduct.PartNo != string.Empty)
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = infoProduct.PartNo;
}
else
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
decBatchId = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value);
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = SpProduct.BarcodeViewByBatchId(decBatchId);
}
}
IsDoAfterFill = true;
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
DataTable dtblUnitByProduct = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value.ToString());
if (dtblUnitByProduct.Rows.Count > 0)
{
foreach (DataRow drUnitByProduct in dtblUnitByProduct.Rows)
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[2].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[3].ToString());
if (IsDoAfterFill)
{
decimal decNewConversionRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString());
decimal decNewRate = (decCurrentRate * decCurrentConversionRate) / decNewConversionRate;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(decNewRate, PublicVariables._inNoOfDecimalPlaces);
}
}
}
}
decimal decStandardRate = SpProduct.SalesInvoiceProductRateForSales(infoProduct.ProductId, PublicVariables._dtCurrentDate, decBatchId, Convert.ToDecimal(cmbPricinglevel.SelectedValue), PublicVariables._inNoOfDecimalPlaces);
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString() != string.Empty)
{
if (decStandardRate != 0 && Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value) != 0)
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(decStandardRate / Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value), PublicVariables._inNoOfDecimalPlaces);
}
}
}
else
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value = string.Empty;
}
AmountCalculation("dgvtxtQty", e.RowIndex);
TotalAmountCalculation();
}
}
else if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtRate")
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value.ToString() != string.Empty)
{
DefaultRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value);
}
}
CheckInvalidEntriesInDataGridProduct(e);
}
catch (Exception ex)
{
MessageBox.Show("SQ:56" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void dgvProduct_CellLeave(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtQty")
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQuotationDetailsId"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQuotationDetailsId"].Value.ToString() != string.Empty && Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQuotationDetailsId"].Value.ToString()) != 0)
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value.ToString() != string.Empty)
{
SalesQuotationDetailsSP spSalesQuationDetails = new SalesQuotationDetailsSP();
decimal decReferencedQty = Math.Round(spSalesQuationDetails.SalesQuatationReferenceCheck(Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQuotationDetailsId"].Value.ToString())),PublicVariables._inNoOfDecimalPlaces);
decimal decQty = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value.ToString());
if (decQty < decReferencedQty)
{
Messages.InformationMessage("Quantity in row " + (e.RowIndex + 1) + " should be greater than " + decReferencedQty);
IsCellValue = false;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = Math.Round(decReferencedQty,PublicVariables._inNoOfDecimalPlaces);
IsCellValue = true;
}
}
}
AmountCalculation("dgvtxtQty", e.RowIndex);
TotalAmountCalculation();
}
else if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvcmbUnit")
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() != string.Empty)
{
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
DataTable dtblUnitByProduct = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvProduct.Rows[e.RowIndex].Cells["ProductId"].Value.ToString());
if (dtblUnitByProduct.Rows.Count > 0)
{
foreach (DataRow drUnitByProduct in dtblUnitByProduct.Rows)
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[2].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[3].ToString());
if (IsDoAfterFill)
{
decimal decNewConversionRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString());
decimal decNewRate = (decCurrentRate * decCurrentConversionRate) / decNewConversionRate;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(decNewRate, Convert.ToInt32(PublicVariables._inNoOfDecimalPlaces));
}
}
}
AmountCalculation("dgvtxtQty", e.RowIndex);
TotalAmountCalculation();
}
}
}
else if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvcmbBatch")
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
string strProductCode = string.Empty;
ProductInfo infoproduct = new ProductInfo();
ProductSP SpProduct = new ProductSP();
decimal decBatchId = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value);
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = SpProduct.BarcodeViewByBatchId(decBatchId);
strProductCode = dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value.ToString();
infoproduct = SpProduct.ProductViewByCode(strProductCode);
DateTime dtcurrentDate = PublicVariables._dtCurrentDate;
decimal decNodecplaces = PublicVariables._inNoOfDecimalPlaces;
decimal decStandardRate = SpProduct.SalesInvoiceProductRateForSales(infoproduct.ProductId, dtcurrentDate, decBatchId, Convert.ToDecimal(cmbPricinglevel.SelectedValue), decNodecplaces);
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString() != string.Empty)
{
if (decStandardRate != 0 && Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value) != 0)
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(decStandardRate / Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value), PublicVariables._inNoOfDecimalPlaces);
}
AmountCalculation("dgvtxtQty", e.RowIndex);
TotalAmountCalculation();
}
}
}
else if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtExchangeRate" && isAmountcalc)
{
AmountCalculation("dgvtxtExchangeRate", e.RowIndex);
TotalAmountCalculation();
}
//---------------while changing Rate,corresponding change in amount----
else if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtRate" && isAmountcalc)
{
AmountCalculation("dgvtxtRate", e.RowIndex);
TotalAmountCalculation();
}
//----while changing amount ,corresponding chnage in total amount-------
CheckInvalidEntriesInDataGridProduct(e);
}
catch (Exception ex)
{
MessageBox.Show("SQ:76" + 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;
BatchSP spBatch = new BatchSP();
ProductSP spProduct = new ProductSP();
PurchaseDetailsSP SPPurchaseDetails = new PurchaseDetailsSP();
PurchaseReturnDetailsSP SPPurchaseReturnDetails = new PurchaseReturnDetailsSP();
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 = spProduct.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 = spProduct.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 = spProduct.BatchIdByPartNoOrBarcode(strBarcode, strBarcode);
if (decBatchId > 0)
{
DataTable dtblBatchName = new DataTable();
dtblBatchName = spProduct.ProductCodeAndBarcodeByBatchId(decBatchId);
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtproductCode"].Value = dtblBatchName.Rows[0]["productCode"].ToString();
if (dtblBatchName.Rows[0]["barcode"].ToString() != null && dtblBatchName.Rows[0]["barcode"].ToString() != string.Empty)
{
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtbarcode"].Value = dtblBatchName.Rows[0]["barcode"].ToString();
}
decimal batchId = spBatch.BatchViewByBarcode(strBarcode);
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = batchId;
FillProductDetails(dtblBatchName.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
{
DataTable dtbl = SPPurchaseDetails.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(dtbl.Rows[e.RowIndex]["qty"].ToString()))
{
dgvPurchaseReturn.Rows[e.RowIndex].Cells["dgvtxtqty"].Value = Math.Round(Convert.ToDecimal(dtbl.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 = spBatch.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>
/// Function to save the sales quatation
/// </summary>
public void SaveFunction()
{
SalesQuotationDetailsSP SpSalesQuotationDetails = new SalesQuotationDetailsSP();
SalesQuotationMasterSP SpSalesQuotationMaster = new SalesQuotationMasterSP();
SalesQuotationMasterInfo infoSalesQuotationMaster = new SalesQuotationMasterInfo();
SalesQuotationDetailsInfo infoSalesQuotationDetails = new SalesQuotationDetailsInfo();
SettingsSP spSettings = new SettingsSP();
ProductSP spProduct = new ProductSP();
ProductInfo infoproduct = new ProductInfo();
try
{
infoSalesQuotationMaster.Date = Convert.ToDateTime(txtSalesQuotationDate.Text);
infoSalesQuotationMaster.PricinglevelId = Convert.ToDecimal(cmbPricinglevel.SelectedValue.ToString());
infoSalesQuotationMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoSalesQuotationMaster.EmployeeId = Convert.ToDecimal(cmbSalesman.SelectedValue.ToString());
if (isAutomatic)
{
infoSalesQuotationMaster.SuffixPrefixId = decSalesQuotationPreffixSuffixId;
infoSalesQuotationMaster.VoucherNo = strSalesQuotationNo;
}
else
{
infoSalesQuotationMaster.SuffixPrefixId = 0;
infoSalesQuotationMaster.VoucherNo = SpSalesQuotationMaster.VoucherNoMax(decsalesQuotationTypeId);
}
infoSalesQuotationMaster.VoucherTypeId = decsalesQuotationTypeId;
infoSalesQuotationMaster.InvoiceNo = txtQuotationNo.Text;
infoSalesQuotationMaster.EmployeeId = Convert.ToDecimal(cmbSalesman.SelectedValue.ToString());
infoSalesQuotationMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoSalesQuotationMaster.userId = PublicVariables._decCurrentUserId;
infoSalesQuotationMaster.TotalAmount = Convert.ToDecimal(txtTotal.Text);
infoSalesQuotationMaster.Narration = txtNarration.Text.Trim();
infoSalesQuotationMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoSalesQuotationMaster.Extra1 = string.Empty;
infoSalesQuotationMaster.Extra2 = string.Empty;
if (cbxApproved.Checked)
{
infoSalesQuotationMaster.Approved = true;
}
else
{
infoSalesQuotationMaster.Approved = false;
}
decSalesQuotationmasterIdentity = Convert.ToDecimal(SpSalesQuotationMaster.SalesQuotationMasterAdd(infoSalesQuotationMaster));
int inRowcount = dgvProduct.Rows.Count;
for (int inI = 0; inI < inRowcount - 1; inI++)
{
infoSalesQuotationDetails.QuotationMasterId = decSalesQuotationmasterIdentity;
if (dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString() != string.Empty)
{
infoproduct = spProduct.ProductViewByCode(dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoSalesQuotationDetails.ProductId = infoproduct.ProductId;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString() != string.Empty)
{
infoSalesQuotationDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
}
if (dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString() != string.Empty)
{
infoSalesQuotationDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
decimal unitConversion = SpSalesQuotationDetails.UnitconversionIdViewByUnitIdAndProductId(infoSalesQuotationDetails.UnitId, infoSalesQuotationDetails.ProductId);
infoSalesQuotationDetails.UnitConversionId = unitConversion;
}
if (dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
infoSalesQuotationDetails.BatchId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value);
}
else
{
infoSalesQuotationDetails.BatchId = 0;
}
infoSalesQuotationDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoSalesQuotationDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoSalesQuotationDetails.Slno = Convert.ToInt32(dgvProduct.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoSalesQuotationDetails.Extra1 = string.Empty;
infoSalesQuotationDetails.Extra2 = string.Empty;
SpSalesQuotationDetails.SalesQuotationDetailsAdd(infoSalesQuotationDetails);
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (dgvProduct.Rows.Count > 0)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesQuotationmasterIdentity);
}
else
{
Print(decSalesQuotationmasterIdentity);
}
}
else
{
Messages.InformationMessage("No data found");
}
}
Clear();
}
catch (Exception ex)
{
MessageBox.Show("SQ:32" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Adding PhysicalStockDetails when updating
/// </summary>
public void EditPhysicalStockDetails()
{
try
{
ProductInfo infoProduct = new ProductInfo();
ProductSP spProduct = new ProductSP();
PhysicalStockDetailsInfo infoPhysicalStockDetails = new PhysicalStockDetailsInfo();
PhysicalStockDetailsSP spPhysicalStockDetails = new PhysicalStockDetailsSP();
int inRowcount = dgvPhysicalStock.Rows.Count;
for (int inI = 0; inI < inRowcount - 1; inI++)
{
infoPhysicalStockDetails.PhysicalStockMasterId = decMasterId;
infoPhysicalStockDetails.PhysicalStockDetailsId = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvtxtPhysicalStockDetailId"].Value);
if (dgvPhysicalStock.Rows[inI].Cells["dgvtxtProductCode"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString() != string.Empty)
{
infoProduct = spProduct.ProductViewByCode(dgvPhysicalStock.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoPhysicalStockDetails.ProductId = infoProduct.ProductId;
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvcmbGodown"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvcmbGodown"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.GodownId = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvcmbGodown"].Value.ToString());
}
else
{
infoPhysicalStockDetails.GodownId = 0;
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvcmbRack"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvcmbRack"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.RackId = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvcmbRack"].Value.ToString());
}
else
{
infoPhysicalStockDetails.RackId = 0;
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvcmbBatch"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.BatchId = Convert.ToDecimal(Convert.ToString(dgvPhysicalStock.Rows[inI].Cells["dgvcmbBatch"].Value));
}
else
{
infoPhysicalStockDetails.BatchId = 0;
}
if (dgvPhysicalStock.Rows[0].Cells["dgvcmbBatch"].Value == null && dgvPhysicalStock.Rows[0].Cells["dgvcmbBatch"].Value == null)
{
MessageBox.Show("Can't update physical stock without atleast one product with complete details", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvPhysicalStock.ClearSelection();
dgvPhysicalStock.Focus();
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvtxtQty"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvtxtQty"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.Qty = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvcmbUnit"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvcmbUnit"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.UnitId = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
}
infoPhysicalStockDetails.Rate = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoPhysicalStockDetails.Amount = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoPhysicalStockDetails.Slno = Convert.ToInt32(dgvPhysicalStock.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoPhysicalStockDetails.Extra1 = string.Empty;
infoPhysicalStockDetails.Extra2 = string.Empty;
spPhysicalStockDetails.PhysicalStockDetailsAdd(infoPhysicalStockDetails);
decimal decPId = infoPhysicalStockDetails.ProductId;
string strVoucher = infoPhysicalStockMaster.VoucherNo;
AddtoStockPosting(decPId, strVoucher);
}
}
catch (Exception ex)
{
MessageBox.Show("PS:23" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void SaveFunction()
{
try
{
ProductSP spProduct = new ProductSP();
SettingsSP Spsetting = new SettingsSP();
infoRejectionOutMaster.Date = Convert.ToDateTime(txtDate.Text);
infoRejectionOutMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
if (isAutomatic == true)
{
infoRejectionOutMaster.SuffixPrefixId = decRejectionOutSuffixPrefixId;
infoRejectionOutMaster.VoucherNo = strVoucherNo;
}
else
{
infoRejectionOutMaster.SuffixPrefixId = 0;
infoRejectionOutMaster.VoucherNo = txtRejectionOutNo.Text.Trim();
}
if (cmbMaterialReceiptNo.SelectedValue != null)
{
infoRejectionOutMaster.MaterialReceiptMasterId = Convert.ToDecimal(Convert.ToString(cmbMaterialReceiptNo.SelectedValue));
}
else
{
infoRejectionOutMaster.MaterialReceiptMasterId = 0;
}
if (cmbCurrency.SelectedValue != null)
{
infoRejectionOutMaster.ExchangeRateId = Convert.ToDecimal(Convert.ToString(cmbCurrency.SelectedValue));
}
infoRejectionOutMaster.VoucherTypeId = decRejectionOutVoucherTypeId;
infoRejectionOutMaster.InvoiceNo = txtRejectionOutNo.Text.Trim();
infoRejectionOutMaster.UserId = PublicVariables._decCurrentUserId;
infoRejectionOutMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoRejectionOutMaster.Narration = txtNarration.Text.Trim();
infoRejectionOutMaster.LrNo = txtLrNo.Text.Trim();
infoRejectionOutMaster.TransportationCompany = txtTransportationCompany.Text.Trim();
infoRejectionOutMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
infoRejectionOutMaster.Extra1 = string.Empty;
infoRejectionOutMaster.Extra2 = string.Empty;
if (decRejectionOutId == 0)
{
decRejectionOutMasterIdentity = spRejectionOutMaster.RejectionOutMasterAddWithReturnIdentity(infoRejectionOutMaster);
}
else
{
infoRejectionOutMaster.RejectionOutMasterId = decRejectionOutId;
spRejectionOutMaster.RejectionOutMasterEdit(infoRejectionOutMaster);
}
if (decRejectionOutId == 0)
{
infoRejectionOutDetails.RejectionOutMasterId = decRejectionOutMasterIdentity;
}
else
{
spRejectionOutDetails.RejectionOutDetailsDeleteByRejectionOutMasterId(decRejectionOutId);
spStockPosting.DeleteStockPostingByAgnstVouTypeIdAndAgnstVouNo(decRejectionOutVoucherTypeId, strRejectionOutVoucherNo);
infoRejectionOutDetails.RejectionOutMasterId = decRejectionOutId;
}
int inRowcount = dgvProduct.Rows.Count;
for (int inI = 0; inI <= inRowcount - 1; inI++)
{
if (dgvProduct.Rows[inI].Cells["dgvtxtSlNo"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString() != string.Empty)
{
infoRejectionOutDetails.Slno = Convert.ToInt32(dgvProduct.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
}
if (dgvProduct.Rows[inI].Cells["dgvtxtmaterialReceiptDetailsId"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtmaterialReceiptDetailsId"].Value.ToString() != string.Empty)
{
infoRejectionOutDetails.MaterialReceiptDetailsId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtmaterialReceiptDetailsId"].Value.ToString());
}
else
{
infoRejectionOutDetails.MaterialReceiptDetailsId = 0;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString() != string.Empty)
{
infoProduct = spProduct.ProductViewByCode(dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoRejectionOutDetails.ProductId = infoProduct.ProductId;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString() != string.Empty)
{
infoRejectionOutDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
}
if (dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString() != string.Empty)
{
infoRejectionOutDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoRejectionOutDetails.UnitConversionId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtunitConversionId"].Value.ToString());
}
if (dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
infoRejectionOutDetails.BatchId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value);
}
if (dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString() != string.Empty)
{
infoRejectionOutDetails.GodownId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value);
}
if (dgvProduct.Rows[inI].Cells["dgvcmbRack"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbRack"].Value.ToString() != string.Empty)
{
infoRejectionOutDetails.RackId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbRack"].Value);
}
infoRejectionOutDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoRejectionOutDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoRejectionOutDetails.Extra1 = string.Empty;
infoRejectionOutDetails.Extra2 = string.Empty;
decRejectionOutDetailsIdentity = spRejectionOutDetails.RejectionOutDetailsAddWithReturnIdentity(infoRejectionOutDetails);
AddStockPosting();
}
if (decRejectionOutId == 0)
{
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (Spsetting.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decRejectionOutMasterIdentity);
}
else
{
Print(decRejectionOutMasterIdentity);
}
}
clear();
}
else
{
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (Spsetting.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decRejectionOutId);
}
else
{
Print(decRejectionOutId);
}
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("RO33:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Doing the grid calculations other functions in grid CellEndEdit event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvPurchaseOrder_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
StockPostingSP spStockPosting = new StockPostingSP();
ProductSP spProduct = new ProductSP();
ProductInfo infoProduct = new ProductInfo();
try
{
isValueChange = false;
isDoAfterGridFill = false;
if (dgvPurchaseOrder.Columns[e.ColumnIndex].Name == "dgvtxtProductName")
{
string strProductName = string.Empty;
if (dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value != null && dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value.ToString().Trim() != string.Empty)
{
strProductName = dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value.ToString();
}
infoProduct = spProduct.ProductViewByName(strProductName);
if (infoProduct.ProductCode != null && infoProduct.ProductCode != string.Empty)
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = infoProduct.ProductCode;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value = infoProduct.ProductId;
UnitComboFill(infoProduct.ProductId, e.RowIndex, dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].ColumnIndex);
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(infoProduct.PurchaseRate, PublicVariables._inNoOfDecimalPlaces).ToString();
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
dtblunitconversionViewAll = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value.ToString());
foreach (DataRow drUnitByProduct in dtblunitconversionViewAll.Rows)
{
if (dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = drUnitByProduct.ItemArray[2].ToString();
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionRate"].Value = drUnitByProduct.ItemArray[3].ToString();
}
}
decCurrentConversionRate = Convert.ToDecimal(dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionRate"].Value.ToString());
decCurrentRate = Convert.ToDecimal(dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value.ToString());
NewAmountCalculation("dgvtxtQty", e.RowIndex);
CalculateTotalAmount();
}
else
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionRate"].Value = string.Empty;
}
}
else if (dgvPurchaseOrder.Columns[e.ColumnIndex].Name == "dgvtxtProductCode")
{
string strPrdCode = string.Empty;
if (dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value != null && dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value.ToString() != string.Empty)
{
strPrdCode = dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value.ToString();
}
infoProduct = spProduct.ProductViewByCode(strPrdCode);
if (infoProduct.ProductId != 0)
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = infoProduct.ProductName;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value = infoProduct.ProductId;
decimal decproductId = infoProduct.ProductId;
UnitComboFill(infoProduct.ProductId, e.RowIndex, dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].ColumnIndex);
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = infoProduct.UnitId;
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
dtblunitconversionViewAll = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value.ToString());
foreach (DataRow drUnitByProduct in dtblunitconversionViewAll.Rows)
{
if (dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = drUnitByProduct.ItemArray[2].ToString();
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionRate"].Value = drUnitByProduct.ItemArray[3].ToString();
}
}
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(infoProduct.PurchaseRate, PublicVariables._inNoOfDecimalPlaces);
if (infoProduct.PartNo != string.Empty)
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = infoProduct.PartNo;
}
decCurrentConversionRate = Convert.ToDecimal(dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionRate"].Value.ToString());
decCurrentRate = Convert.ToDecimal(dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value.ToString());
NewAmountCalculation("dgvtxtQty", e.RowIndex);
CalculateTotalAmount();
}
else
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionRate"].Value = string.Empty;
}
}
else if (dgvPurchaseOrder.Columns[e.ColumnIndex].Name == "dgvtxtBarcode")
{
string strBCode = string.Empty;
if (dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value != null && dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value.ToString().Trim() != string.Empty)
{
strBCode = dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value.ToString();
}
dtbl = spProduct.ProductDetailsCoreespondingToBarcode(strBCode);
if (dtbl.Rows.Count > 0)
{
foreach (DataRow RowDetails in dtbl.Rows)
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value = RowDetails["productId"].ToString();
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = RowDetails["productCode"].ToString();
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = RowDetails["productName"].ToString();
UnitComboFill(Convert.ToDecimal(RowDetails["productId"].ToString()), e.RowIndex, dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].ColumnIndex);
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(RowDetails["unitId"].ToString());
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
dtblunitconversionViewAll = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value.ToString());
foreach (DataRow drUnitByProduct in dtblunitconversionViewAll.Rows)
{
if (dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = drUnitByProduct.ItemArray[2].ToString();
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionRate"].Value = drUnitByProduct.ItemArray[3].ToString();
}
}
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(Convert.ToDecimal(RowDetails["purchaseRate"].ToString()), PublicVariables._inNoOfDecimalPlaces);
decCurrentConversionRate = Convert.ToDecimal(dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionRate"].Value.ToString());
decCurrentRate = Convert.ToDecimal(dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value.ToString());
NewAmountCalculation("dgvtxtQty", e.RowIndex);
CalculateTotalAmount();
}
}
else
{
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = string.Empty;
dgvPurchaseOrder.Rows[e.RowIndex].Cells["dgvtxtUnitConversionRate"].Value = string.Empty;
}
}
CheckInvalidEntries(e);
isAmountcalc = true;
isValueChange = true;
isDoAfterGridFill = true;
if (txtTotalAmount.Text.ToString().Split('.')[0].Length > 13)
{
MessageBox.Show("Amount exxed than limit");
dgvPurchaseOrder.Rows.RemoveAt(dgvPurchaseOrder.Rows.Count - 2);
CalculateTotalAmount();
}
}
catch (Exception ex)
{
MessageBox.Show("PO48:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save Function
/// </summary>
public void SaveFunction()
{
try
{
ProductInfo infoProduct = new ProductInfo();
ProductSP spProduct = new ProductSP();
PhysicalStockMasterInfo infoPhysicalStockMaster = new PhysicalStockMasterInfo();
PhysicalStockDetailsSP spPhysicalStockDetails = new PhysicalStockDetailsSP();
PhysicalStockMasterSP spPhysicalStockMaster = new PhysicalStockMasterSP();
infoPhysicalStockMaster.VoucherNo = txtVoucherNo.Text.Trim();
infoPhysicalStockMaster.Date = Convert.ToDateTime(txtDate.Text);
infoPhysicalStockMaster.Narration = txtNarration.Text.Trim();
string s = txtTotalAmount.Text;
infoPhysicalStockMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
if (isAutomatic)
{
infoPhysicalStockMaster.SuffixPrefixId = decPhysicalStockSuffixPrefixId;
infoPhysicalStockMaster.VoucherNo = strVoucherNo;
infoPhysicalStockMaster.InvoiceNo = txtVoucherNo.Text;
}
else
{
infoPhysicalStockMaster.SuffixPrefixId = 0;
infoPhysicalStockMaster.VoucherNo = txtVoucherNo.Text;
infoPhysicalStockMaster.InvoiceNo = txtVoucherNo.Text;
}
infoPhysicalStockMaster.VoucherTypeId = decPhysicalStockVoucherTypeId;
infoPhysicalStockMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPhysicalStockMaster.Extra1 = string.Empty;
infoPhysicalStockMaster.Extra2 = string.Empty;
decPhysicalStockMasterIdentity = Convert.ToDecimal(spPhysicalStockMaster.PhysicalStockMasterAdd(infoPhysicalStockMaster));
int inRowcount = dgvPhysicalStock.Rows.Count;
for (int inI = 0; inI < inRowcount - 1; inI++)
{
if (dgvPhysicalStock.Rows[inI].HeaderCell.Value.ToString() != "X")
{
infoPhysicalStockDetails.PhysicalStockMasterId = decPhysicalStockMasterIdentity;
if (dgvPhysicalStock.Rows[inI].Cells["dgvtxtProductCode"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString() != string.Empty)
{
infoProduct = spProduct.ProductViewByCode(dgvPhysicalStock.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoPhysicalStockDetails.ProductId = infoProduct.ProductId;
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvcmbGodown"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvcmbGodown"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.GodownId = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvcmbGodown"].Value.ToString());
}
else
{
infoPhysicalStockDetails.GodownId = 0;
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvcmbRack"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvcmbRack"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.RackId = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvcmbRack"].Value.ToString());
}
else
{
infoPhysicalStockDetails.RackId = 0;
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvcmbBatch"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.BatchId = Convert.ToDecimal(Convert.ToString(dgvPhysicalStock.Rows[inI].Cells["dgvcmbBatch"].Value));
}
else
{
infoPhysicalStockDetails.BatchId = 0;
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvtxtQty"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvtxtQty"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.Qty = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
}
if (dgvPhysicalStock.Rows[inI].Cells["dgvcmbUnit"].Value != null && dgvPhysicalStock.Rows[inI].Cells["dgvcmbUnit"].Value.ToString() != string.Empty)
{
infoPhysicalStockDetails.UnitId = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoPhysicalStockDetails.UnitConversionId = decConversionId;
}
infoPhysicalStockDetails.Rate = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoPhysicalStockDetails.Amount = Convert.ToDecimal(dgvPhysicalStock.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoPhysicalStockDetails.Slno = Convert.ToInt32(dgvPhysicalStock.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoPhysicalStockDetails.Extra1 = string.Empty;
infoPhysicalStockDetails.Extra2 = string.Empty;
spPhysicalStockDetails.PhysicalStockDetailsAdd(infoPhysicalStockDetails);
decimal decPId = infoPhysicalStockDetails.ProductId;
string strVoucher = infoPhysicalStockMaster.VoucherNo;
AddtoStockPosting(decPId, strVoucher);
}
}
Messages.SavedMessage();
if (dgvPhysicalStock.RowCount > 1)
{
if (cbxPrint.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPhysicalStockMasterIdentity);
}
else
{
Print(decPhysicalStockMasterIdentity);
}
}
}
clear();
}
catch (Exception ex)
{
MessageBox.Show("PS:27" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save Function
/// </summary>
public void SaveFunction()
{
try
{
PurchaseOrderMasterInfo infoPurchaseOrderMaster = new PurchaseOrderMasterInfo();
PurchaseOrderDetailsSP spPurchaseOrderDetails = new PurchaseOrderDetailsSP();
PurchaseOrderDetailsInfo infoPurchaseOrderDetails = new PurchaseOrderDetailsInfo();
PurchaseOrderMasterSP spPurchaseOrderMaster = new PurchaseOrderMasterSP();
ProductInfo infoProduct = new ProductInfo();
ProductSP spProduct = new ProductSP();
SettingsSP spSettings = new SettingsSP();
if (cbxCancel.Checked)
{
infoPurchaseOrderMaster.Cancelled = true;
}
else
{
infoPurchaseOrderMaster.Cancelled = false;
}
infoPurchaseOrderMaster.Date = Convert.ToDateTime(txtDate.Text);
infoPurchaseOrderMaster.DueDate = Convert.ToDateTime(txtDueDate.Text);
infoPurchaseOrderMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
if (isAutomatic == true)
{
infoPurchaseOrderMaster.SuffixPrefixId = decPurchaseSuffixPrefixId;
infoPurchaseOrderMaster.VoucherNo = strVoucherNo;
}
else
{
infoPurchaseOrderMaster.SuffixPrefixId = 0;
infoPurchaseOrderMaster.VoucherNo = spPurchaseOrderMaster.VoucherNoMax(decPurchaseOrderTypeId);
}
infoPurchaseOrderMaster.VoucherTypeId = decPurchaseOrderTypeId;
infoPurchaseOrderMaster.InvoiceNo = txtOrderNo.Text;
infoPurchaseOrderMaster.UserId = PublicVariables._decCurrentUserId;
infoPurchaseOrderMaster.EmployeeId = PublicVariables._decCurrentUserId;//by default current userid used as current employeeid
infoPurchaseOrderMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPurchaseOrderMaster.Narration = txtNarration.Text.Trim();
infoPurchaseOrderMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
infoPurchaseOrderMaster.exchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoPurchaseOrderMaster.Extra1 = string.Empty;
infoPurchaseOrderMaster.Extra2 = string.Empty;
decPurchaseOrderMasterIdentity = Convert.ToDecimal(spPurchaseOrderMaster.PurchaseOrderMasterAdd(infoPurchaseOrderMaster));
int inRowcount = dgvPurchaseOrder.Rows.Count;
for (int inI = 0; inI < inRowcount - 1; inI++)
{
infoPurchaseOrderDetails.PurchaseOrderMasterId = decPurchaseOrderMasterIdentity;
if (dgvPurchaseOrder.Rows[inI].Cells["dgvtxtProductCode"].Value != null && dgvPurchaseOrder.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString() != "")
{
infoProduct = spProduct.ProductViewByCode(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoPurchaseOrderDetails.ProductId = infoProduct.ProductId;
}
if (dgvPurchaseOrder.Rows[inI].Cells["dgvtxtQty"].Value != null && dgvPurchaseOrder.Rows[inI].Cells["dgvtxtQty"].Value.ToString() != "")
{
infoPurchaseOrderDetails.Qty = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
}
if (dgvPurchaseOrder.Rows[inI].Cells["dgvcmbUnit"].Value != null && dgvPurchaseOrder.Rows[inI].Cells["dgvcmbUnit"].Value.ToString() != "")
{
infoPurchaseOrderDetails.UnitId = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvcmbUnit"].Value);
infoPurchaseOrderDetails.UnitConversionId = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString());
}
infoPurchaseOrderDetails.Rate = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoPurchaseOrderDetails.Amount = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoPurchaseOrderDetails.SlNo = Convert.ToInt32(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoPurchaseOrderDetails.Extra1 = string.Empty;
infoPurchaseOrderDetails.Extra2 = string.Empty;
spPurchaseOrderDetails.PurchaseOrderDetailsAdd(infoPurchaseOrderDetails);
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPurchaseOrderMasterIdentity);
}
else
{
Print(decPurchaseOrderMasterIdentity);
}
}
Clear();
}
catch (Exception ex)
{
MessageBox.Show("PO35:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// edit function for PurchaseOrderDetails
/// </summary>
public void EditPurchaseOrderDetails()
{
try
{
ProductInfo infoProduct = new ProductInfo();
ProductSP spProduct = new ProductSP();
PurchaseOrderDetailsInfo infoPurchaseOrderDetails = new PurchaseOrderDetailsInfo();
PurchaseOrderDetailsSP spPurchaseOrderDetails = new PurchaseOrderDetailsSP();
for (int inI = 0; inI < dgvPurchaseOrder.Rows.Count - 1; inI++)
{
if (Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value) == 0 || dgvPurchaseOrder.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value.ToString() == null || dgvPurchaseOrder.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value.ToString() == string.Empty)
{
infoPurchaseOrderDetails.PurchaseOrderMasterId = decPurchaseOrderMasterId;
infoProduct = spProduct.ProductViewByCode(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoPurchaseOrderDetails.ProductId = infoProduct.ProductId;
infoPurchaseOrderDetails.Qty = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
infoPurchaseOrderDetails.UnitId = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvcmbUnit"].Value);
infoPurchaseOrderDetails.UnitConversionId = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtUnitConversionId"].Value);
infoPurchaseOrderDetails.Rate = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoPurchaseOrderDetails.Amount = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoPurchaseOrderDetails.SlNo = Convert.ToInt32(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoPurchaseOrderDetails.Extra1 = string.Empty;
infoPurchaseOrderDetails.Extra2 = string.Empty;
spPurchaseOrderDetails.PurchaseOrderDetailsAdd(infoPurchaseOrderDetails);
}
else
{
infoPurchaseOrderDetails.PurchaseOrderMasterId = decPurchaseOrderMasterId;
infoPurchaseOrderDetails.PurchaseOrderDetailsId = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value);
infoProduct = spProduct.ProductViewByCode(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoPurchaseOrderDetails.ProductId = infoProduct.ProductId;
infoPurchaseOrderDetails.Qty = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
infoPurchaseOrderDetails.UnitId = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoPurchaseOrderDetails.UnitConversionId = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtUnitConversionId"].Value);
infoPurchaseOrderDetails.Rate = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoPurchaseOrderDetails.Amount = Convert.ToDecimal(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoPurchaseOrderDetails.SlNo = Convert.ToInt32(dgvPurchaseOrder.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoPurchaseOrderDetails.Extra1 = string.Empty;
infoPurchaseOrderDetails.Extra2 = string.Empty;
spPurchaseOrderDetails.PurchaseOrderDetailsEdit(infoPurchaseOrderDetails);
}
}
}
catch (Exception ex)
{
MessageBox.Show("PO33:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On cellEndEdit of grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvProduct_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
ProductInfo infoProduct = new ProductInfo();
BatchSP spbatch = new BatchSP();
ProductSP spproduct = new ProductSP();
StockPostingSP spStockPosting = new StockPostingSP();
try
{
isDoAfterGridFill = false;
isValueChange = false;
if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtProductName")
{
string strProductName = string.Empty;
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value.ToString() != string.Empty)
{
strProductName = dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value.ToString();
}
infoProduct = spproduct.ProductViewByName(strProductName);
if (infoProduct.ProductCode != null && infoProduct.ProductCode != string.Empty)
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = infoProduct.ProductCode;
decimal decproductId = infoProduct.ProductId;
dgvProduct.Rows[e.RowIndex].Cells["productId"].Value = infoProduct.ProductId;
BatchComboFill(decproductId, e.RowIndex, Convert.ToInt32(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].ColumnIndex));
decimal decBatchId = spStockPosting.BatchViewByProductId(decproductId);
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = decBatchId;
decBatchId = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value);
string strBarcode = spbatch.ProductBatchBarcodeViewByBatchId(decBatchId);
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = strBarcode;
dtbl = spproduct.ProductDetailsCoreespondingToBarcode(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value.ToString());
if (dtbl.Rows.Count > 0)
{
foreach (DataRow RowDetails in dtbl.Rows)
{
isValueChange = false;
dgvProduct.Rows[e.RowIndex].Cells["productId"].Value = RowDetails["productId"].ToString();
decimal decProductId = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["productId"].Value);
BatchComboFill(decProductId, e.RowIndex, Convert.ToInt32(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].ColumnIndex));
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(RowDetails["batchId"].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = RowDetails["productCode"].ToString();
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = RowDetails["productName"].ToString();
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbGodown"].Value = Convert.ToDecimal(RowDetails["godownId"].ToString());
decGodownId = Convert.ToDecimal(dgvProduct.CurrentRow.Cells["dgvcmbGodown"].Value);
RackComboFill(decGodownId, e.RowIndex, dgvProduct.Rows[e.RowIndex].Cells["dgvCmbRack"].ColumnIndex);
dgvProduct.Rows[e.RowIndex].Cells["dgvCmbRack"].Value = Convert.ToDecimal(RowDetails["rackId"].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(Convert.ToDecimal(RowDetails["purchaseRate"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();
UnitComboFill(decProductId, e.RowIndex, dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].ColumnIndex);
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(RowDetails["unitId"].ToString());
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
DataTable dtblUnitByProduct = new DataTable();
dtblUnitByProduct = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvProduct.Rows[e.RowIndex].Cells["productId"].Value.ToString());
foreach (DataRow drUnitByProduct in dtblUnitByProduct.Rows)
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[2].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[3].ToString());
}
}
decCurrentRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value.ToString());
decCurrentConversionRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString());
NewAmountCalculation("dgvtxtQty", e.RowIndex);
CalculateTotalAmount();
}
}
}
else
{
isValueChange = false;
dgvProduct.Rows[e.RowIndex].Cells["productId"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbGodown"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvCmbRack"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
isValueChange = true;
}
}
if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtProductCode")
{
string strPrdCode = string.Empty;
if (dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value.ToString() != string.Empty)
{
strPrdCode = dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value.ToString();
}
isDoAfterGridFill = false;
infoProduct = spproduct.ProductViewByCode(strPrdCode);
if (infoProduct.ProductId != 0)
{
decimal decproductId = infoProduct.ProductId;
dgvProduct.Rows[e.RowIndex].Cells["productId"].Value = infoProduct.ProductId;
BatchComboFill(decproductId, e.RowIndex, Convert.ToInt32(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].ColumnIndex));
decimal decBatchId = spStockPosting.BatchViewByProductId(decproductId);
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = decBatchId;
decBatchId = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value);
string strBarcode = spbatch.ProductBatchBarcodeViewByBatchId(decBatchId);
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = strBarcode;
dtbl = spproduct.ProductDetailsCoreespondingToBarcode(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value.ToString());
if (dtbl.Rows.Count > 0)
{
foreach (DataRow RowDetails in dtbl.Rows)
{
isValueChange = false;
dgvProduct.Rows[e.RowIndex].Cells["productId"].Value = RowDetails["productId"].ToString();
decimal decProductId = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["productId"].Value);
BatchComboFill(decProductId, e.RowIndex, Convert.ToInt32(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].ColumnIndex));
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(RowDetails["batchId"].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = RowDetails["productCode"].ToString();
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = RowDetails["productName"].ToString();
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbGodown"].Value = Convert.ToDecimal(RowDetails["godownId"].ToString());
decGodownId = Convert.ToDecimal(dgvProduct.CurrentRow.Cells["dgvcmbGodown"].Value);
RackComboFill(decGodownId, e.RowIndex, dgvProduct.Rows[e.RowIndex].Cells["dgvCmbRack"].ColumnIndex);
dgvProduct.Rows[e.RowIndex].Cells["dgvCmbRack"].Value = Convert.ToDecimal(RowDetails["rackId"].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(Convert.ToDecimal(RowDetails["purchaseRate"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();
UnitComboFill(decProductId, e.RowIndex, dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].ColumnIndex);
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(RowDetails["unitId"].ToString());
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
DataTable dtblUnitByProduct = new DataTable();
dtblUnitByProduct = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvProduct.Rows[e.RowIndex].Cells["productId"].Value.ToString());
foreach (DataRow drUnitByProduct in dtblUnitByProduct.Rows)
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[2].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[3].ToString());
}
}
decCurrentRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value.ToString());
decCurrentConversionRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString());
NewAmountCalculation("dgvtxtQty", e.RowIndex);
CalculateTotalAmount();
}
}
}
else
{
isValueChange = false;
dgvProduct.Rows[e.RowIndex].Cells["productId"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbGodown"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvCmbRack"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
isValueChange = true;
}
}
if (dgvProduct.Columns[e.ColumnIndex].Name == "dgvtxtBarcode")
{
string strBCode = string.Empty;
DataTable dtbl = new DataTable();
if (!dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].ReadOnly && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value != null && dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value.ToString() != string.Empty)
{
strBCode = dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value.ToString();
}
isDoAfterGridFill = false;
dtbl = spproduct.ProductDetailsCoreespondingToBarcode(strBCode);
if (dtbl.Rows.Count > 0)
{
foreach (DataRow RowDetails in dtbl.Rows)
{
isValueChange = false;
dgvProduct.Rows[e.RowIndex].Cells["productId"].Value = RowDetails["productId"].ToString();
decimal decProductId = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["productId"].Value);
BatchComboFill(decProductId, e.RowIndex, Convert.ToInt32(dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].ColumnIndex));
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(RowDetails["batchId"].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = RowDetails["productCode"].ToString();
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = RowDetails["productName"].ToString();
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbGodown"].Value = Convert.ToDecimal(RowDetails["godownId"].ToString());
decGodownId = Convert.ToDecimal(dgvProduct.CurrentRow.Cells["dgvcmbGodown"].Value);
RackComboFill(decGodownId, e.RowIndex, dgvProduct.Rows[e.RowIndex].Cells["dgvCmbRack"].ColumnIndex);
dgvProduct.Rows[e.RowIndex].Cells["dgvCmbRack"].Value = Convert.ToDecimal(RowDetails["rackId"].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = Math.Round(Convert.ToDecimal(RowDetails["purchaseRate"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();
UnitComboFill(decProductId, e.RowIndex, dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].ColumnIndex);
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(RowDetails["unitId"].ToString());
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
DataTable dtblUnitByProduct = new DataTable();
dtblUnitByProduct = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvProduct.Rows[e.RowIndex].Cells["productId"].Value.ToString());
foreach (DataRow drUnitByProduct in dtblUnitByProduct.Rows)
{
if (dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[2].ToString());
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[3].ToString());
}
}
decCurrentRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value.ToString());
decCurrentConversionRate = Convert.ToDecimal(dgvProduct.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString());
NewAmountCalculation("dgvtxtQty", e.RowIndex);
CalculateTotalAmount();
}
}
else
{
isValueChange = false;
dgvProduct.Rows[e.RowIndex].Cells["productId"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductName"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtRate"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtProductCode"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtQty"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbUnit"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvcmbGodown"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvCmbRack"].Value = string.Empty;
dgvProduct.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
isValueChange = true;
}
}
CheckInvalidEntries(e);
isDoAfterGridFill = true;
isValueChange = true;
}
catch (Exception ex)
{
MessageBox.Show("MR68:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the voucher details for edit
/// </summary>
public void MaterialReceiptDetailsEditFill()
{
ProductInfo infoProduct = new ProductInfo();
MaterialReceiptDetailsInfo infoMaterialReceiptDetails = new MaterialReceiptDetailsInfo();
StockPostingSP spstockposting = new StockPostingSP();
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
MaterialReceiptDetailsSP spMaterialReceiptDetails = new MaterialReceiptDetailsSP();
ProductSP spproduct = new ProductSP();
try
{
for (int inI = 0; inI < dgvProduct.Rows.Count - 1; inI++)
{
decimal decStatus = spMaterialReceiptMaster.MaterialReceiptDetailsReferenceCheck(decMaterialReceiptDetailId);
if (decStatus == 1)
{
dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].ReadOnly = true;
dgvProduct.Rows[inI].Cells["dgvtxtProductName"].ReadOnly = true;
dgvProduct.Rows[inI].Cells["dgvcmbUnit"].ReadOnly = true;
dgvProduct.Rows[inI].Cells["dgvtxtBarcode"].ReadOnly = true;
dgvProduct.Rows[inI].Cells["dgvCmbRack"].ReadOnly = true;
dgvProduct.Rows[inI].Cells["dgvcmbGodown"].ReadOnly = true;
dgvProduct.Rows[inI].Cells["dgvtxtRate"].ReadOnly = true;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtProductName"].Value != null)
{
if (dgvProduct.Rows[inI].Cells["dgvtxtMaterialReceiptdetailsId"].Value == null || dgvProduct.Rows[inI].Cells["dgvtxtMaterialReceiptdetailsId"].Value.ToString() == string.Empty)
{
infoMaterialReceiptDetails.MaterialReceiptMasterId = decMaterialReceiptMasterId;
infoProduct = spproduct.ProductViewByCode(dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoMaterialReceiptDetails.ProductId = infoProduct.ProductId;
if (dgvProduct.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value != null)
{
infoMaterialReceiptDetails.OrderDetailsId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value.ToString());
}
else
infoMaterialReceiptDetails.OrderDetailsId = 0;
infoMaterialReceiptDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
infoMaterialReceiptDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoMaterialReceiptDetails.UnitConversionId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtUnitConversionId"].Value);
if (dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.GodownId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString());
}
else
{
infoMaterialReceiptDetails.GodownId = 1;
}
if (dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value != null && dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.RackId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value.ToString());
}
else
{
infoMaterialReceiptDetails.RackId = 1;
}
if (dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.BatchId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString());
}
else
{
infoMaterialReceiptDetails.BatchId = 1;
}
infoMaterialReceiptDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoMaterialReceiptDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoMaterialReceiptDetails.Slno = Convert.ToInt32(dgvProduct.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoMaterialReceiptDetails.Extra1 = string.Empty;
infoMaterialReceiptDetails.Exta2 = string.Empty;
infoMaterialReceiptDetails.ExtraDate = Convert.ToDateTime(DateTime.Now);
spMaterialReceiptDetails.MaterialReceiptDetailsAdd(infoMaterialReceiptDetails);
}
else
{
infoMaterialReceiptDetails.MaterialReceiptMasterId = decMaterialReceiptMasterId;
infoMaterialReceiptDetails.MaterialReceiptDetailsId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtMaterialReceiptdetailsId"].Value);
infoProduct = spproduct.ProductViewByCode(dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoMaterialReceiptDetails.ProductId = infoProduct.ProductId;
if (dgvProduct.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value != null)
{
infoMaterialReceiptDetails.OrderDetailsId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value.ToString());
}
else
infoMaterialReceiptDetails.OrderDetailsId = 0;
infoMaterialReceiptDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
infoMaterialReceiptDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoMaterialReceiptDetails.UnitConversionId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtUnitConversionId"].Value);
infoMaterialReceiptDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
if (dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.GodownId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString());
}
else
{
infoMaterialReceiptDetails.GodownId = 1;
}
if (dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value != null && dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.RackId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value.ToString());
}
else
{
infoMaterialReceiptDetails.RackId = 1;
}
if (dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.BatchId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString());
}
else
{
infoMaterialReceiptDetails.BatchId = 1;
}
infoMaterialReceiptDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoMaterialReceiptDetails.Slno = Convert.ToInt32(dgvProduct.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoMaterialReceiptDetails.Extra1 = string.Empty;
infoMaterialReceiptDetails.Exta2 = string.Empty;
infoMaterialReceiptDetails.ExtraDate = Convert.ToDateTime(DateTime.Now);
spMaterialReceiptDetails.MaterialReceiptDetailsEdit(infoMaterialReceiptDetails);
}
StockPostingInfo infoStockPosting = new StockPostingInfo();
infoStockPosting.Date = Convert.ToDateTime(txtDate.Text);
infoStockPosting.ProductId = infoMaterialReceiptDetails.ProductId;
infoStockPosting.BatchId = infoMaterialReceiptDetails.BatchId;
infoStockPosting.UnitId = infoMaterialReceiptDetails.UnitId;
infoStockPosting.GodownId = infoMaterialReceiptDetails.GodownId;
infoStockPosting.RackId = infoMaterialReceiptDetails.RackId;
if (cmbOrderNo.SelectedValue != null)
{
if (dgvProduct.Rows[inI].Cells["dgvtxtvoucherNo"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtvoucherNo"].Value.ToString() != string.Empty && dgvProduct.Rows[inI].Cells["dgvtxtvoucherNo"].Value.ToString() != "NA")
{
infoStockPosting.VoucherNo = Convert.ToString(dgvProduct.Rows[inI].Cells["dgvtxtvoucherNo"].Value.ToString());
infoStockPosting.AgainstVoucherNo = strVoucherNo;
}
else
{
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.AgainstVoucherNo = "NA";
}
if (dgvProduct.Rows[inI].Cells["dgvtxtinvoiceNo"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtinvoiceNo"].Value.ToString() != string.Empty && dgvProduct.Rows[inI].Cells["dgvtxtinvoiceNo"].Value.ToString() != "NA")
{
infoStockPosting.InvoiceNo = Convert.ToString(dgvProduct.Rows[inI].Cells["dgvtxtinvoiceNo"].Value.ToString());
infoStockPosting.AgainstInvoiceNo = txtReceiptNo.Text;
}
else
{
infoStockPosting.InvoiceNo = txtReceiptNo.Text;
infoStockPosting.AgainstInvoiceNo = "NA";
}
if (dgvProduct.Rows[inI].Cells["dgvtxtvouchertypeId"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtvouchertypeId"].Value.ToString() != string.Empty && Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtvouchertypeId"].Value.ToString()) != 0)
{
infoStockPosting.VoucherTypeId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtvouchertypeId"].Value.ToString());
infoStockPosting.AgainstVoucherTypeId = decMaterialReceiptVoucherTypeId;
}
else
{
infoStockPosting.VoucherTypeId = decMaterialReceiptVoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = 0;
}
}
else
{
infoStockPosting.InvoiceNo = txtReceiptNo.Text;
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.VoucherTypeId = decMaterialReceiptVoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstInvoiceNo = "NA";
}
spstockposting.StockPostingDeleteByVoucherTypeAndVoucherNo(strVoucherNo, decMaterialReceiptVoucherTypeId);
infoStockPosting.InwardQty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
infoStockPosting.OutwardQty = 0;
infoStockPosting.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
spstockposting.StockPostingAdd(infoStockPosting);
isEdit = true;
}
}
if (isEdit)
{
cmbCashOrParty.Enabled = true;
cmbOrderNo.Enabled = true;
cmbcurrency.Enabled = true;
txtDate.Enabled = true;
cmbVoucherType.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show("MR37:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save the voucher
/// </summary>
public void SaveFunction()
{
MaterialReceiptDetailsInfo infoMaterialReceiptDetails = new MaterialReceiptDetailsInfo();
ProductInfo infoProduct = new ProductInfo();
MaterialReceiptMasterInfo infoMaterialReceiptMaster = new MaterialReceiptMasterInfo();
StockPostingSP spstockposting = new StockPostingSP();
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
MaterialReceiptDetailsSP spMaterialReceiptDetails = new MaterialReceiptDetailsSP();
ProductSP spproduct = new ProductSP();
try
{
infoMaterialReceiptMaster.Date = Convert.ToDateTime(txtDate.Text);
infoMaterialReceiptMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
if (isAutomatic)
{
infoMaterialReceiptMaster.SuffixPrefixId = decMaterialReceiptSuffixPrefixId;
infoMaterialReceiptMaster.VoucherNo = strVoucherNo;
}
else
{
infoMaterialReceiptMaster.SuffixPrefixId = 0;
infoMaterialReceiptMaster.VoucherNo = txtReceiptNo.Text;
}
infoMaterialReceiptMaster.VoucherTypeId = decMaterialReceiptVoucherTypeId;
infoMaterialReceiptMaster.InvoiceNo = txtReceiptNo.Text;
infoMaterialReceiptMaster.UserId = PublicVariables._decCurrentUserId;
infoMaterialReceiptMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoMaterialReceiptMaster.TransportationCompany = txtTransportation.Text.Trim();
infoMaterialReceiptMaster.LrNo = txtLRNo.Text.Trim();
infoMaterialReceiptMaster.Narration = txtNarration.Text.Trim();
if (cmbOrderNo.SelectedValue == null || cmbOrderNo.SelectedValue.ToString() == string.Empty)
{
infoMaterialReceiptMaster.OrderMasterId = 0;
}
else
{
infoMaterialReceiptMaster.OrderMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
}
infoMaterialReceiptMaster.exchangeRateId = Convert.ToDecimal(cmbcurrency.SelectedValue.ToString());//saving corresponding exchangeRateId as currencyId
infoMaterialReceiptMaster.TotalAmount = Convert.ToDecimal(txtTotal.Text);
infoMaterialReceiptMaster.Extra1 = string.Empty;
infoMaterialReceiptMaster.Extra2 = string.Empty;
infoMaterialReceiptMaster.ExtraDate = Convert.ToDateTime(DateTime.Now);
decMaterialReceiptMasterIdentity = Convert.ToDecimal(spMaterialReceiptMaster.MaterialReceiptMasterAdd(infoMaterialReceiptMaster));
int inRowcount = dgvProduct.Rows.Count;
for (int inI = 0; inI < inRowcount - 1; inI++)
{
infoMaterialReceiptDetails.MaterialReceiptMasterId = decMaterialReceiptMasterIdentity;
if (dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString() != string.Empty)
{
infoProduct = spproduct.ProductViewByCode(dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoMaterialReceiptDetails.ProductId = infoProduct.ProductId;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value != null)
{
infoMaterialReceiptDetails.OrderDetailsId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtPurchaseOrderDetailsId"].Value.ToString());
}
else
infoMaterialReceiptDetails.OrderDetailsId = 0;
if (dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.GodownId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString());
}
else
{
infoMaterialReceiptDetails.GodownId = 1;
}
if (dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value != null && dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.RackId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvCmbRack"].Value.ToString());
}
else
{
infoMaterialReceiptDetails.RackId = 1;
}
if (dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.BatchId = Convert.ToDecimal(Convert.ToString(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value));
}
else
{
infoMaterialReceiptDetails.BatchId = 1;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
}
if (dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString() != string.Empty)
{
infoMaterialReceiptDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoMaterialReceiptDetails.UnitConversionId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString());
}
infoMaterialReceiptDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoMaterialReceiptDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoMaterialReceiptDetails.Slno = Convert.ToInt32(dgvProduct.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoMaterialReceiptDetails.Extra1 = string.Empty;
infoMaterialReceiptDetails.Exta2 = string.Empty;
infoMaterialReceiptDetails.ExtraDate = Convert.ToDateTime(DateTime.Now);
spMaterialReceiptDetails.MaterialReceiptDetailsAdd(infoMaterialReceiptDetails);
//-----------------Stockposting---------------------------//
StockPostingInfo infoStockPosting = new StockPostingInfo();
infoStockPosting.Date = infoMaterialReceiptMaster.Date;
infoStockPosting.ProductId = infoMaterialReceiptDetails.ProductId;
infoStockPosting.BatchId = infoMaterialReceiptDetails.BatchId;
infoStockPosting.UnitId = infoMaterialReceiptDetails.UnitId;
infoStockPosting.GodownId = infoMaterialReceiptDetails.GodownId;
infoStockPosting.RackId = infoMaterialReceiptDetails.RackId;
if (cmbOrderNo.SelectedValue != null)
{
if (dgvProduct.Rows[inI].Cells["dgvtxtvoucherNo"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtvoucherNo"].Value.ToString() != string.Empty)
{
infoStockPosting.VoucherNo = Convert.ToString(dgvProduct.Rows[inI].Cells["dgvtxtvoucherNo"].Value.ToString());
infoStockPosting.AgainstVoucherNo = strVoucherNo;
}
else
{
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.AgainstVoucherNo = "NA";
}
if (dgvProduct.Rows[inI].Cells["dgvtxtinvoiceNo"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtinvoiceNo"].Value.ToString() != string.Empty)
{
infoStockPosting.InvoiceNo = Convert.ToString(dgvProduct.Rows[inI].Cells["dgvtxtinvoiceNo"].Value.ToString());
infoStockPosting.AgainstInvoiceNo = txtReceiptNo.Text;
}
else
{
infoStockPosting.InvoiceNo = txtReceiptNo.Text;
infoStockPosting.AgainstInvoiceNo = "NA";
}
if (dgvProduct.Rows[inI].Cells["dgvtxtvouchertypeId"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtvouchertypeId"].Value.ToString() != string.Empty)
{
infoStockPosting.VoucherTypeId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtvouchertypeId"].Value.ToString());
infoStockPosting.AgainstVoucherTypeId = decMaterialReceiptVoucherTypeId;
}
else
{
infoStockPosting.VoucherTypeId = decMaterialReceiptVoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = 0;
}
}
else
{
infoStockPosting.InvoiceNo = txtReceiptNo.Text;
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.VoucherTypeId = decMaterialReceiptVoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstInvoiceNo = "NA";
}
infoStockPosting.InwardQty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString()) / Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtConversionRate"].Value.ToString());
infoStockPosting.OutwardQty = 0;
infoStockPosting.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
spstockposting.StockPostingAdd(infoStockPosting);
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decMaterialReceiptMasterIdentity);
}
else
{
Print(decMaterialReceiptMasterIdentity, infoMaterialReceiptMaster.OrderMasterId);
}
}
Clear();
}
catch (Exception ex)
{
MessageBox.Show("MR35:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}