/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DataTable dtblMaterialReceiptRegister = new DataTable();
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
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;
dtblMaterialReceiptRegister = spMaterialReceiptMaster.MaterialReceiptMasterViewAll(strInvoiceNo, decLedgerId, FromDate, ToDate);
dgvMaterialReceiptRegister.DataSource = dtblMaterialReceiptRegister;
}
catch (Exception ex)
{
MessageBox.Show("MRREG1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill MaterialReceipt combobox
/// </summary>
public void MaterialReceiptComboFill()
{
try
{
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
cmbMaterialReceiptNo.DataSource = spMaterialReceiptMaster.MaterialReceiptNoCorrespondingToLedgerForReport(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()));
cmbMaterialReceiptNo.DisplayMember = "invoiceNo";
cmbMaterialReceiptNo.ValueMember = "materialReceiptMasterId";
cmbMaterialReceiptNo.SelectedIndex = -1;
}
catch (Exception ex)
{
MessageBox.Show("ROREP06:" + 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)
{
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
DataSet dsMaterialReceiptReport = spMaterialReceiptMaster.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
{
DataTable dtbl = new DataTable();
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
dtbl = spMaterialReceiptMaster.GetOrderNoCorrespondingtoLedgerForMaterialReceiptRpt(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()));
DataRow drow = dtbl.NewRow();
drow["invoiceNo"] = "All";
drow["purchaseOrderMasterId"] = -1;
dtbl.Rows.InsertAt(drow, 0);
if (dtbl != null)
{
cmbOrderNo.DataSource = dtbl;
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
{
DataTable dtblMaterialReceiptRegister = new DataTable();
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
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;
dtblMaterialReceiptRegister = spMaterialReceiptMaster.MaterialReceiptReportViewAll(decOrderId, strInvoiceNo, decLedgerId, decVoucherTypeId, strproductCode, FromDate, ToDate, strStatus);
dgvMaterialReceiptReport.DataSource = dtblMaterialReceiptRegister;
}
catch (Exception ex)
{
MessageBox.Show("MRR5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}