/// <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);
}
}
