/// <summary> /// Function toprint /// </summary> public void ReportPrint() { try { RejectionOutMasterSP spRejectionOutMaster = new RejectionOutMasterSP(); decimal decMaterialReceiptNo = 0; if (cmbMaterialReceiptNo.SelectedIndex != -1) { decMaterialReceiptNo = Convert.ToDecimal(cmbMaterialReceiptNo.SelectedValue.ToString()); } strVoucherNo = txtVoucherNo.Text; strProductCode = txtProductCode.Text; DataSet dsRejectionOut = spRejectionOutMaster.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 { TransactionsGeneralFill obj = new TransactionsGeneralFill(); RejectionOutMasterSP spRejectionOut = new RejectionOutMasterSP(); strVoucherNo = "0"; if (strVoucherNo == string.Empty) { strVoucherNo = "0"; } strVoucherNo = obj.VoucherNumberAutomaicGeneration(decRejectionOutVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName); if (Convert.ToDecimal(strVoucherNo) != spRejectionOut.RejectionOutMasterGetMaxPlusOne(decRejectionOutVoucherTypeId)) { strVoucherNo = spRejectionOut.RejectionOutMasterGetMax(decRejectionOutVoucherTypeId).ToString(); strVoucherNo = obj.VoucherNumberAutomaicGeneration(decRejectionOutVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName); if (spRejectionOut.RejectionOutMasterGetMax(decRejectionOutVoucherTypeId) == "0") { strVoucherNo = "0"; strVoucherNo = obj.VoucherNumberAutomaicGeneration(decRejectionOutVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName); } } if (isAutomatic) { SuffixPrefixSP spSuffisprefix = new SuffixPrefixSP(); SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo(); infoSuffixPrefix = spSuffisprefix.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); } }
/// <summary> /// Function to fill the grid based on conditions /// </summary> public void GridFill() { try { RejectionOutMasterSP spRejectionOutMaster = new RejectionOutMasterSP(); 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; DataTable dtbl = spRejectionOutMaster.RejectionOutReportFill(strinvoiceNo, strProductCode, strProductName, decLedgerId, FromDate, ToDate, decReceiptMasterId, decVoucherTypeId); dgvRejectionOutReport.DataSource = dtbl; } catch (Exception ex) { MessageBox.Show("ROREP07:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }