/// <summary> /// Function to fill the grid based on conditions /// </summary> public void GridFill() { try { //RejectionOutMasterSP spRejectionOutMaster = new RejectionOutMasterSP(); RejectionOutBll bllRejectionOut = new RejectionOutBll(); if (txtVoucherNo.Text.Trim() == string.Empty) { strVoucherNo = string.Empty; } else { strVoucherNo = txtVoucherNo.Text; } if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1) { decLedgerId = 0; } else { decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()); } if (cmbVoucherType.SelectedIndex == 0 || cmbVoucherType.SelectedIndex == -1) { decVoucherTypeId = 0; } else { decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()); } if (cmbMaterialReceiptNo.SelectedIndex == 0 || cmbMaterialReceiptNo.SelectedIndex == -1) { decReceiptMasterId = 0; } else { decReceiptMasterId = Convert.ToDecimal(cmbMaterialReceiptNo.SelectedValue.ToString()); } if (txtProductCode.Text.Trim() == string.Empty) { strProductCode = string.Empty; } else { strProductCode = txtProductCode.Text; } if (txtProductName.Text.Trim() == string.Empty) { strProductName = string.Empty; } else { strProductName = txtProductName.Text; } DateTime FromDate = this.dtpFromDate.Value; DateTime ToDate = this.dtpToDate.Value; List<DataTable>list = bllRejectionOut.RejectionOutReportFill(strinvoiceNo, strProductCode, strProductName, decLedgerId, FromDate, ToDate, decReceiptMasterId, decVoucherTypeId); dgvRejectionOutReport.DataSource = list[0]; } catch (Exception ex) { MessageBox.Show("ROREP07:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill VoucherType combobox /// </summary> public void VoucherTypeComboFill() { try { RejectionOutBll bllRejectionOut = new RejectionOutBll(); List<DataTable> list = new List<DataTable>(); list = bllRejectionOut.VoucherTypeComboFillForRejectionOutReport(); cmbVoucherType.DataSource = list[0]; cmbVoucherType.ValueMember = "voucherTypeId"; cmbVoucherType.DisplayMember = "voucherTypeName"; cmbVoucherType.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show("ROREP05:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Funtion to check remaining quantity with refernce to purchaseinvoice and rejectionout /// </summary> /// <returns></returns> public int QuantityCheckWithReference() { decimal decQtyRejectionOutAndPurchaseInvoice = 0; decimal decQtyMaterialReceipt = 0; decimal inRef = 0; int inF1 = 1; decimal decMaterialReceiptDetailsId = 0; MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll(); PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll(); RejectionOutBll bllRejectionOut = new RejectionOutBll(); try { foreach (DataGridViewRow dgvrow in dgvProduct.Rows) { if (dgvrow.Cells["dgvtxtmaterialReceiptDetailsId"].Value != null) { if (dgvrow.Cells["dgvtxtmaterialReceiptDetailsId"].Value.ToString() != "0" || dgvrow.Cells["dgvtxtmaterialReceiptDetailsId"].Value.ToString() != string.Empty) { decMaterialReceiptDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtmaterialReceiptDetailsId"].Value.ToString()); inRef = bllMaterialReceiptMaster.MaterialReceiptDetailsReferenceCheck(decMaterialReceiptDetailsId); if (inRef == 1) { if (inF1 == 1) { if (dgvrow.Cells["dgvtxtQty"].Value != null) { if (dgvrow.Cells["dgvtxtQty"].Value.ToString() != "0" || dgvrow.Cells["dgvtxtQty"].Value.ToString() != string.Empty) { decQtyMaterialReceipt = Convert.ToDecimal(dgvrow.Cells["dgvtxtQty"].Value.ToString()); decQtyRejectionOutAndPurchaseInvoice = Math.Round(bllMaterialReceiptMaster.MaterialReceiptQuantityDetailsAgainstPurcahseInvoiceAndRejectionOut(decMaterialReceiptDetailsId), PublicVariables._inNoOfDecimalPlaces); if (decQtyMaterialReceipt >= decQtyRejectionOutAndPurchaseInvoice) { inF1 = 1; } else { inF1 = 0; Messages.InformationMessage("Quantity in row " + (dgvrow.Index + 1) + " should be greater than " + decQtyRejectionOutAndPurchaseInvoice); } } else { inF1 = 0; Messages.InformationMessage("Quantity in row " + (dgvrow.Index + 1) + " should be greater than " + decQtyRejectionOutAndPurchaseInvoice); } } else { inF1 = 0; Messages.InformationMessage("Quantity in row " + (dgvrow.Index + 1) + " should be greater than " + decQtyRejectionOutAndPurchaseInvoice); } } } else { inF1 = 1; } } } } } catch (Exception ex) { MessageBox.Show("MR11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return inF1; }
/// <summary> /// Function toprint /// </summary> public void ReportPrint() { try { RejectionOutBll bllRejectionOut = new RejectionOutBll(); decimal decMaterialReceiptNo = 0; if (cmbMaterialReceiptNo.SelectedIndex != -1) { decMaterialReceiptNo = Convert.ToDecimal(cmbMaterialReceiptNo.SelectedValue.ToString()); } strVoucherNo = txtVoucherNo.Text; strProductCode = txtProductCode.Text; DataSet dsRejectionOut = bllRejectionOut.RejectionOutReportPrinting(decmaterialReceiptMasterId, 1, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()), strVoucherNo, Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), strProductCode, strProductName); frmReport frmReport = new frmReport(); frmReport.MdiParent = formMDI.MDIObj; frmReport.RejectionOutReportPrinting(dsRejectionOut); } catch (Exception ex) { MessageBox.Show("RORP03:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// For VoucherNumberGeneration /// </summary> public void VoucherNumberGeneration() { try { TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll(); RejectionOutBll bllRejectionOut = new RejectionOutBll(); strVoucherNo = "0"; if (strVoucherNo == string.Empty) { strVoucherNo = "0"; } strVoucherNo = obj.VoucherNumberAutomaicGeneration(decRejectionOutVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName); if (Convert.ToDecimal(strVoucherNo) != bllRejectionOut.RejectionOutMasterGetMaxPlusOne(decRejectionOutVoucherTypeId)) { strVoucherNo = bllRejectionOut.RejectionOutMasterGetMax(decRejectionOutVoucherTypeId).ToString(); strVoucherNo = obj.VoucherNumberAutomaicGeneration(decRejectionOutVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName); if (bllRejectionOut.RejectionOutMasterGetMax(decRejectionOutVoucherTypeId) == "0") { strVoucherNo = "0"; strVoucherNo = obj.VoucherNumberAutomaicGeneration(decRejectionOutVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName); } } if (isAutomatic) { SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll(); //SuffixPrefixSP spSuffisprefix = new SuffixPrefixSP(); SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo(); infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decRejectionOutVoucherTypeId, dtpDate.Value); strPrefix = infoSuffixPrefix.Prefix; strSuffix = infoSuffixPrefix.Suffix; decRejectionOutSuffixPrefixId = infoSuffixPrefix.SuffixprefixId; strRejectionOutNo = strPrefix + strVoucherNo + strSuffix; txtRejectionOutNo.Text = strRejectionOutNo; txtRejectionOutNo.ReadOnly = true; } } catch (Exception ex) { MessageBox.Show("RO02:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }