/// <summary>
/// Function to fill VoucherType combobox
/// </summary>
public void VoucherTypeCombofill()
{
try
{
MaterialReceiptDetailsSP spMaterialReceiptDetails = new MaterialReceiptDetailsSP();
dtbl = spMaterialReceiptDetails.VoucherTypeCombofillforMaterialReceipt();
cmbVoucherType.DataSource = dtbl;
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("MRR2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill VoucherType combobox
/// </summary>
public void VoucherTypeCombofill()
{
try
{
MaterialReceiptDetailsSP spMaterialReceiptDetails = new MaterialReceiptDetailsSP();
dtbl = spMaterialReceiptDetails.VoucherTypeCombofillforMaterialReceipt();
cmbVoucherType.DataSource = dtbl;
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("MRR2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill VoucherType combobox
/// </summary>
public void VoucherTypeCombofill()
{
try
{
MaterialReceiptDetailsSP spMaterialReceiptDetails = new MaterialReceiptDetailsSP();
dtbl = spMaterialReceiptDetails.VoucherTypeCombofillforMaterialReceipt();
cmbVoucherType.DataSource = dtbl;
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.SelectedIndex = 0;
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "MRREP2:" + ex.Message;
}
}
/// <summary>
/// Function to fill material receipt details
/// </summary>
public void MaterialReceiptDetailsFill()
{
DataTable dtblMaster = new DataTable();
DataTable dtblDetails = new DataTable();
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
MaterialReceiptDetailsSP spMaterialReceiptDetails = new MaterialReceiptDetailsSP();
decimal decMaterialReceiptMasterId = 0;
decimal decBatchId = 0;
try
{
if (!isEditFill)
{
if (cmbCashOrParty.SelectedValue != null)
{
if (cmbCashOrParty.SelectedValue.ToString() != "System.Data.DataRowView" && cmbCashOrParty.Text != "System.Data.DataRowView")
{
GridComboFill();
decMaterialReceiptMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
dtblMaster = spMaterialReceiptMaster.MaterialReceiptMasterViewByReceiptMasterId(decMaterialReceiptMasterId);
if (dtblMaster.Rows.Count > 0)
{
cmbCurrency.SelectedValue = dtblMaster.Rows[0].ItemArray[7];
}
dtblDetails = spMaterialReceiptDetails.MaterialReceiptDetailsViewByMaterialReceiptMasterIdWithRemainingByNotInCurrPI
(decMaterialReceiptMasterId, decPurchaseMasterId, decPurchaseInvoiceVoucherTypeId);
if (dtblDetails.Rows.Count > 0)
{
//dgvProductDetails.DataSource = dtblDetails;
int i = 0;
foreach (DataRow dr in dtblDetails.Rows)
{
dgvProductDetails.Rows.Add();
dgvProductDetails.Rows[i].Cells["dgvtxtPurchaseDetailsId"].Value = dr["purchaseDetailsId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtPurchaseOrderDetailsId"].Value = dr["purchaseOrderDetailsId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtMaterialReceiptDetailsId"].Value = dr["materialReceiptDetailsId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtProductId"].Value = dr["productId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtBarcode"].Value = dr["barcode"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtProductCode"].Value = dr["productCode"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtProductName"].Value = dr["productName"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtQuantity"].Value = dr["qty"].ToString();
UnitComboFill(Convert.ToDecimal(dr["productId"].ToString()), i, dgvProductDetails.Rows[i].Cells["dgvcmbUnit"].ColumnIndex);
dgvProductDetails.Rows[i].Cells["dgvtxtUnitConversionId"].Value = dr["unitConversionId"].ToString();
dgvProductDetails.Rows[i].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(dr["unitId"].ToString());
dgvProductDetails.Rows[i].Cells["dgvcmbGodown"].Value = Convert.ToDecimal(dr["godownId"].ToString()); ;
dgvProductDetails.Rows[i].Cells["dgvcmbRack"].Value = Convert.ToDecimal(dr["rackId"].ToString()); ;
BatchComboFill(Convert.ToDecimal(dr["productId"].ToString()), i, dgvProductDetails.Rows[i].Cells["dgvcmbBatch"].ColumnIndex);
dgvProductDetails.Rows[i].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(dr["batchId"].ToString());
dgvProductDetails.Rows[i].Cells["dgvtxtRate"].Value = dr["rate"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtGrossValue"].Value = dr["grossValue"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtDiscountPercent"].Value = dr["discountPercent"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtDiscount"].Value = dr["discount"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtNetValue"].Value = dr["netvalue"].ToString();
dgvProductDetails.Rows[i].Cells["dgvcmbTax"].Value = Convert.ToDecimal(dr["taxId"].ToString());
dgvProductDetails.Rows[i].Cells["dgvtxtTaxAmount"].Value = dr["taxAmount"].ToString();
dgvProductDetails.Rows[i].Cells["dgvtxtAmount"].Value = dr["Amount"].ToString();
dgvProductDetails.Rows[i].Cells["dgvcmbUnit"].ReadOnly = true;
i++;
}
dgvProductDetails.AllowUserToAddRows = false;
}
else
{
if (dgvProductDetails.DataSource == null)
{
dgvProductDetails.Rows.Clear();
}
else
{
((DataTable)dgvProductDetails.DataSource).Rows.Clear();
}
}
SerialNo();
GridviewReadOnlySettings("Against MaterialReceipt");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PI20:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On leave from each cell of dgvProductDetails
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvProductDetails_CellLeave(object sender, DataGridViewCellEventArgs e)
{
string strBarcode = string.Empty;
decimal decDiscountPercent = 0;
decimal decDiscount = 0;
decimal decGrossValue = 0;
try
{
BatchSP spBatch = new BatchSP();
if (e.ColumnIndex > -1 && e.RowIndex > -1)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value != null)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value.ToString() != string.Empty && dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value.ToString() != "0")
{
if (e.ColumnIndex == dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtQuantity"].ColumnIndex)
{
if (dgvProductDetails.RowCount > 1)
{
try
{
MaterialReceiptDetailsSP spMaterialReceiptDetails = new MaterialReceiptDetailsSP();
decimal decMaterialReceiptMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
dtblMeterialReceiptQty = spMaterialReceiptDetails.MaterialReceiptDetailsViewByMaterialReceiptMasterIdWithRemainingByNotInCurrPI
(decMaterialReceiptMasterId, decPurchaseMasterId, decPurchaseInvoiceVoucherTypeId);
if (dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtMaterialReceiptDetailsId"].Value != null)
{
if (decimal.Parse(dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtMaterialReceiptDetailsId"].Value.ToString()) > 0)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtQuantity"].Value != null)
{
if (decimal.Parse(dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtQuantity"].Value.ToString()) > decimal.Parse(dtblMeterialReceiptQty.Rows[e.RowIndex]["qty"].ToString()))
{
dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtQuantity"].Value = dtblMeterialReceiptQty.Rows[e.RowIndex]["qty"].ToString();
if (decMeterialReceiptQty < decimal.Parse(dtblMeterialReceiptQty.Rows[e.RowIndex]["qty"].ToString()))
{
dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtQuantity"].Value = decMeterialReceiptQty;
decMeterialReceiptQty = 0;
}
}
}
}
}
}
catch (Exception)
{
}
}
}
else if (e.ColumnIndex == dgvProductDetails.Columns["dgvcmbBatch"].Index)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value != null && dgvProductDetails.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
decimal decBatchId = Convert.ToDecimal(dgvProductDetails.Rows[e.RowIndex].Cells["dgvcmbBatch"].Value);
strBarcode = spBatch.ProductBatchBarcodeViewByBatchId(decBatchId);
dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = strBarcode;
}
}
else if (e.ColumnIndex == dgvProductDetails.Columns["dgvtxtGrossValue"].Index)
{
dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtDiscountPercent"].Value = 0;
dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtDiscount"].Value = 0;
}
else if (e.ColumnIndex == dgvProductDetails.Columns["dgvtxtDiscountPercent"].Index)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() != string.Empty)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtGrossValue"].Value != null)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtGrossValue"].Value.ToString() != string.Empty)
{
decDiscountPercent = Convert.ToDecimal(dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtDiscountPercent"].Value.ToString());
decGrossValue = Convert.ToDecimal(dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtGrossValue"].Value.ToString());
if (decGrossValue > 0)
{
decDiscount = decGrossValue * decDiscountPercent / 100;
}
dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtDiscount"].Value = Math.Round(decDiscount, PublicVariables._inNoOfDecimalPlaces);
}
}
}
}
}
else if (e.ColumnIndex == dgvProductDetails.Columns["dgvtxtDiscount"].Index)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() != string.Empty)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtGrossValue"].Value != null)
{
if (dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtGrossValue"].Value.ToString() != string.Empty)
{
decDiscount = Convert.ToDecimal(dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtDiscount"].Value.ToString());
decGrossValue = Convert.ToDecimal(dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtGrossValue"].Value.ToString());
if (decGrossValue > 0)
{
decDiscountPercent = decDiscount * 100 / decGrossValue;
}
dgvProductDetails.Rows[e.RowIndex].Cells["dgvtxtDiscountPercent"].Value = Math.Round(decDiscountPercent, PublicVariables._inNoOfDecimalPlaces);
}
}
}
}
}
}
}
SerialNo();
}
CheckInvalidEntries(e);
}
catch (Exception ex)
{
MessageBox.Show("PI85:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the fields for edit or delete
/// </summary>
public void FillRegisterOrReport()
{
MaterialReceiptMasterInfo infoMaterialReceiptMaster = new MaterialReceiptMasterInfo();
MaterialReceiptDetailsInfo infoMaterialReceiptDetails = new MaterialReceiptDetailsInfo();
VoucherTypeSP spVoucherType = new VoucherTypeSP();
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
MaterialReceiptDetailsSP spMaterialReceiptDetails = new MaterialReceiptDetailsSP();
PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP();
try
{
PurchaseOrderMasterSP spPurchaseOrder = new PurchaseOrderMasterSP();
PurchaseOrderMasterInfo infoPurchaseOrder = new PurchaseOrderMasterInfo();
decimal decTotal = 0;
decimal decStatus = spMaterialReceiptMaster.MaterialReceiptMasterReferenceCheck(decMaterialReceiptMasterId);
if (decStatus == 0)
{
cmbCashOrParty.Enabled = false;
cmbOrderNo.Enabled = false;
cmbcurrency.Enabled = false;
txtDate.Enabled = false;
cmbVoucherType.Enabled = false;
}
btnSave.Text = "Update";
btnDelete.Enabled = true;
txtReceiptNo.ReadOnly = true;
infoMaterialReceiptMaster = spMaterialReceiptMaster.MaterialReceiptMasterView(decMaterialReceiptMasterId);
txtReceiptNo.Text = infoMaterialReceiptMaster.InvoiceNo;
strVoucherNo = infoMaterialReceiptMaster.VoucherNo.ToString();
decMaterialReceiptSuffixPrefixId = Convert.ToDecimal(infoMaterialReceiptMaster.SuffixPrefixId);
decMaterialReceiptVoucherTypeId = Convert.ToDecimal(infoMaterialReceiptMaster.VoucherTypeId);
isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(decMaterialReceiptVoucherTypeId);
decMaterialReceiptTypeId = decMaterialReceiptVoucherTypeId;
txtDate.Text = infoMaterialReceiptMaster.Date.ToString("dd-MMM-yyyy");
cmbCashOrParty.SelectedValue = infoMaterialReceiptMaster.LedgerId;
if (infoMaterialReceiptMaster.OrderMasterId != 0)
{
infoPurchaseOrder = SPPurchaseOrderMaster.PurchaseOrderMasterView(Convert.ToDecimal(infoMaterialReceiptMaster.OrderMasterId.ToString()));
decPurchaseOrderVoucherTypeId = infoPurchaseOrder.VoucherTypeId;
cmbVoucherType.SelectedValue = decPurchaseOrderVoucherTypeId;
cmbOrderNo.SelectedValue = infoMaterialReceiptMaster.OrderMasterId.ToString();
decOrderNoWhileEditMode = infoMaterialReceiptMaster.OrderMasterId;
}
else
{
cmbVoucherType.SelectedValue = 0;
}
txtTransportation.Text = infoMaterialReceiptMaster.TransportationCompany;
txtNarration.Text = infoMaterialReceiptMaster.Narration;
txtLRNo.Text = infoMaterialReceiptMaster.LrNo;
CurrencyComboFill();
cmbcurrency.SelectedValue = infoMaterialReceiptMaster.exchangeRateId;
decTotal = Convert.ToDecimal(infoMaterialReceiptMaster.TotalAmount.ToString());
decTotal = Math.Round(decTotal, PublicVariables._inNoOfDecimalPlaces);
txtTotal.Text = Convert.ToString(decTotal);
DataTable dtbl = new DataTable();
dtbl = spMaterialReceiptDetails.MaterialReceiptDetailsViewByMasterId(decMaterialReceiptMasterId);
dgvProduct.Rows.Clear();
for (int i = 0; i < dtbl.Rows.Count; i++)
{
isAmountcalc = false;
isValueChange = false;
dgvProduct.Rows.Add();
dgvProduct.Rows[i].Cells["dgvtxtMaterialReceiptdetailsId"].Value = Convert.ToDecimal(dtbl.Rows[i]["materialReceiptDetailsId"].ToString());
decMaterialReceiptDetailId = Convert.ToDecimal(dtbl.Rows[i]["materialReceiptDetailsId"].ToString());
dgvProduct.Rows[i].Cells["dgvtxtSlNo"].Value = dtbl.Rows[i]["slno"].ToString();
dgvProduct.Rows[i].Cells["dgvtxtProductCode"].Value = dtbl.Rows[i]["productCode"].ToString();
dgvProduct.Rows[i].Cells["dgvtxtProductName"].Value = dtbl.Rows[i]["productName"].ToString();
dgvProduct.Rows[i].Cells["dgvtxtQty"].Value = dtbl.Rows[i]["qty"].ToString();
dgvProduct.Rows[i].Cells["productId"].Value = dtbl.Rows[i]["productId"].ToString();
decimal decProductId = Convert.ToDecimal(dtbl.Rows[i]["productId"].ToString());
UnitComboFill(decProductId, i, dgvProduct.Rows[i].Cells["dgvcmbUnit"].ColumnIndex);
dgvProduct.Rows[i].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(dtbl.Rows[i]["unitId"].ToString());
DGVGodownComboFill();
dgvProduct.Rows[i].Cells["dgvcmbGodown"].Value = Convert.ToDecimal(dtbl.Rows[i]["godownId"].ToString());
decGodownId = Convert.ToDecimal(dgvProduct.Rows[i].Cells["dgvcmbGodown"].Value);
RackComboFill(decGodownId, i, dgvProduct.Rows[i].Cells["dgvCmbRack"].ColumnIndex);
if (Convert.ToDecimal(dtbl.Rows[i]["orderDetailsId"].ToString()) == 0)
{
dgvProduct.Rows[i].Cells["dgvtxtPurchaseOrderDetailsId"].Value = 0;
}
else
{
dgvProduct.Rows[i].Cells["dgvtxtPurchaseOrderDetailsId"].Value = Convert.ToDecimal(dtbl.Rows[i]["orderDetailsId"].ToString());
}
dgvProduct.Rows[i].Cells["dgvCmbRack"].Value = Convert.ToDecimal(dtbl.Rows[i]["rackId"].ToString());
BatchComboFill(decProductId, i, Convert.ToInt32(dgvProduct.Rows[i].Cells["dgvcmbBatch"].ColumnIndex));
dgvProduct.Rows[i].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(dtbl.Rows[i]["batchId"].ToString());
dgvProduct.Rows[i].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(dtbl.Rows[i]["unitConversionId"].ToString());
dgvProduct.Rows[i].Cells["dgvtxtBarcode"].Value = dtbl.Rows[i]["barcode"].ToString();
dgvProduct.Rows[i].Cells["dgvtxtRate"].Value = dtbl.Rows[i]["rate"].ToString();
dgvProduct.Rows[i].Cells["dgvtxtAmount"].Value = dtbl.Rows[i]["amount"].ToString();
dgvProduct.Rows[i].Cells["dgvtxtvouchertypeId"].Value = Convert.ToDecimal(dtbl.Rows[i]["voucherTypeId"].ToString());
dgvProduct.Rows[i].Cells["dgvtxtvoucherNo"].Value = dtbl.Rows[i]["voucherNo"].ToString();
dgvProduct.Rows[i].Cells["dgvtxtinvoiceNo"].Value = dtbl.Rows[i]["invoiceNo"].ToString();
decAgainstVoucherTypeId = Convert.ToDecimal(dgvProduct.Rows[i].Cells["dgvtxtvouchertypeId"].Value.ToString());
strAgainstVoucherNo = dgvProduct.Rows[i].Cells["dgvtxtvoucherNo"].Value.ToString();
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
DataTable dtblUnitByProduct = new DataTable();
dtblUnitByProduct = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(decProductId.ToString());
foreach (DataRow drUnitByProduct in dtblUnitByProduct.Rows)
{
if (dgvProduct.Rows[i].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvProduct.Rows[i].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[2].ToString());
dgvProduct.Rows[i].Cells["dgvtxtConversionRate"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[3].ToString());
}
}
decCurrentRate = Convert.ToDecimal(dgvProduct.Rows[i].Cells["dgvtxtRate"].Value.ToString());
decCurrentConversionRate = Convert.ToDecimal(dgvProduct.Rows[i].Cells["dgvtxtConversionRate"].Value.ToString());
decimal decReference = spMaterialReceiptMaster.MaterialReceiptDetailsReferenceCheck(decMaterialReceiptDetailId);
if (decReference == 1 || Convert.ToDecimal(dgvProduct.Rows[i].Cells["dgvtxtPurchaseOrderDetailsId"].Value.ToString())!=0)
{
dgvProduct.Rows[i].Cells["dgvtxtProductCode"].ReadOnly = true;
dgvProduct.Rows[i].Cells["dgvtxtProductName"].ReadOnly = true;
dgvProduct.Rows[i].Cells["dgvcmbUnit"].ReadOnly = true;
dgvProduct.Rows[i].Cells["dgvtxtBarcode"].ReadOnly = true;
dgvProduct.Rows[i].Cells["dgvCmbRack"].ReadOnly = true;
dgvProduct.Rows[i].Cells["dgvcmbGodown"].ReadOnly = true;
dgvProduct.Rows[i].Cells["dgvtxtRate"].ReadOnly = true;
dgvProduct.Rows[i].Cells["dgvcmbBatch"].ReadOnly = true;
}
if (cmbVoucherType.Text != "NA")
{
dgvProduct.Rows[i].Cells["dgvcmbUnit"].ReadOnly = true;
}
}
isAmountcalc = true;
isValueChange = true;
isDoAfterGridFill = true;
}
catch (Exception ex)
{
MessageBox.Show("MR16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to remove material receipt details of removed row
/// </summary>
public void removeMaterialReceiptDetails()
{
MaterialReceiptDetailsSP spmaterialReceiptDetails = new MaterialReceiptDetailsSP();
try
{
foreach (var strId in lstArrOfRemove)
{
decimal decDeleteId = Convert.ToDecimal(strId);
spmaterialReceiptDetails.MaterialReceiptDetailsDelete(decDeleteId);
}
}
catch (Exception ex)
{
MessageBox.Show("MR12: " + 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);
}
}
