/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { List <DataTable> ListObj = new List <DataTable>(); MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll(); if (txtMaterialReceiptNo.Text.Trim() == string.Empty) { strInvoiceNo = string.Empty; } else { strInvoiceNo = txtMaterialReceiptNo.Text; } if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1) { decLedgerId = -1; } else { decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()); } DateTime FromDate = this.dtpFromDate.Value; DateTime ToDate = this.dtpToDate.Value; ListObj = bllMaterialReceiptMaster.MaterialReceiptMasterViewAll(strInvoiceNo, decLedgerId, FromDate, ToDate); dgvMaterialReceiptRegister.DataSource = ListObj[0]; } catch (Exception ex) { MessageBox.Show("MRREG1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill MaterialReceipt combobox /// </summary> public void MaterialReceiptComboFill() { try { MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll(); List <DataTable> listobj = new List <DataTable>(); listobj = bllMaterialReceiptMaster.MaterialReceiptNoCorrespondingToLedgerForReport(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString())); cmbMaterialReceiptNo.DataSource = listobj[0]; cmbMaterialReceiptNo.DisplayMember = "invoiceNo"; cmbMaterialReceiptNo.ValueMember = "materialReceiptMasterId"; cmbMaterialReceiptNo.SelectedIndex = -1; } catch (Exception ex) { MessageBox.Show("ROREP06:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill VoucherType combobox /// </summary> public void VoucherTypeCombofill() { try { MaterialReceiptBll bllMaterialReceiptDetails = new MaterialReceiptBll(); List <DataTable> ListObj = new List <DataTable>(); ListObj = bllMaterialReceiptDetails.VoucherTypeCombofillforMaterialReceipt(); cmbVoucherType.DataSource = ListObj[0]; cmbVoucherType.ValueMember = "voucherTypeId"; cmbVoucherType.DisplayMember = "voucherTypeName"; cmbVoucherType.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show("MRR2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Print button click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPrint_Click(object sender, EventArgs e) { try { if (dgvMaterialReceiptReport.RowCount > 0) { MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll(); DataSet dsMaterialReceiptReport = bllMaterialReceiptMaster.MaterialReceiptReportPrinting(1, strInvoiceNo, strStatus, decLedgerId, strproductCode, decVoucherTypeId, this.dtpFromDate.Value, this.dtpToDate.Value, decOrderId); frmReport frmReport = new frmReport(); frmReport.MdiParent = formMDI.MDIObj; frmReport.MaterialReceiptReportPrinting(dsMaterialReceiptReport); } else { Messages.InformationMessage("No data found"); } } catch (Exception ex) { MessageBox.Show("MRR15:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill OrderNo combobox /// </summary> /// <param name="decLedger"></param> public void OrderNoComboFill(decimal decLedger) { try { List <DataTable> ListObj = new List <DataTable>(); MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll(); ListObj = bllMaterialReceiptMaster.GetOrderNoCorrespondingtoLedgerForMaterialReceiptRpt(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString())); DataRow drow = ListObj[0].NewRow(); drow["invoiceNo"] = "All"; drow["purchaseOrderMasterId"] = -1; dtbl.Rows.InsertAt(drow, 0); if (dtbl != null) { cmbOrderNo.DataSource = ListObj[0]; cmbOrderNo.DisplayMember = "invoiceNo"; cmbOrderNo.ValueMember = "purchaseOrderMasterId"; } } catch (Exception ex) { MessageBox.Show("MRR4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill the grid based on the search condition /// </summary> public void GridFill() { try { List <DataTable> Listobj = new List <DataTable>(); MaterialReceiptBll spMaterialReceiptMaster = new MaterialReceiptBll(); if (cmbOrderNo.SelectedIndex == 0 || cmbOrderNo.SelectedIndex == -1) { decOrderId = -1; } else { decOrderId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString()); } if (txtVoucherNo.Text.Trim() == string.Empty) { strInvoiceNo = string.Empty; } else { strInvoiceNo = txtVoucherNo.Text; } if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1) { decLedgerId = -1; } else { decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()); } if (cmbVoucherType.SelectedIndex == 0 || cmbVoucherType.SelectedIndex == -1) { decVoucherTypeId = -1; } else { decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()); } if (txtProductCode.Text.Trim() == string.Empty) { strproductCode = string.Empty; } else { strproductCode = txtProductCode.Text; } if (cmbStatus.SelectedIndex == 0 || cmbStatus.SelectedIndex == -1) { strStatus = "All"; } else { strStatus = cmbStatus.SelectedItem.ToString(); } DateTime FromDate = this.dtpFromDate.Value; DateTime ToDate = this.dtpToDate.Value; Listobj = spMaterialReceiptMaster.MaterialReceiptReportViewAll(decOrderId, strInvoiceNo, decLedgerId, decVoucherTypeId, strproductCode, FromDate, ToDate, strStatus); dgvMaterialReceiptReport.DataSource = Listobj[0]; } catch (Exception ex) { MessageBox.Show("MRR5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }