/// <summary>
/// Call the print in butten print click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
string strColumn = string.Empty;
GridFill();
if (dgvPurchaseReport.RowCount > 0)
{
if (rbtnInvoiceDate.Checked)
{
strColumn = rbtnInvoiceDate.Text;
}
else
{
strColumn = rbtnVoucherDate.Text;
}
DataSet dsPurchaseReport = BllPurchaseInvoice.PurchaseInvoiceReportPrinting(1, strColumn, dtpFromDate.Value, dtpToDate.Value,
Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), cmbStatus.Text, cmbPurchaseMode.Text,
Convert.ToDecimal(cmbAgainstVoucherType.SelectedValue.ToString()), txtOrderNo.Text,
Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()), txtVoucherNo.Text, txtProductCode.Text, txtProductName.Text);
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
frmReport.PurchaseReportPrinting(dsPurchaseReport, txtTotalAmount.Text);
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("PIREP15:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the grid based on condition
/// </summary>
public void GridFill()
{
decimal decTotalAmount = 0;
string strColumn = string.Empty;
List <DataTable> ListObj = new List <DataTable>();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
try
{
if (rbtnInvoiceDate.Checked)
{
strColumn = rbtnInvoiceDate.Text;
}
else
{
strColumn = rbtnVoucherDate.Text;
}
ListObj = BllPurchaseInvoice.PurchaseInvoiceReportFill(1, strColumn, dtpFromDate.Value, dtpToDate.Value,
Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), cmbStatus.Text, cmbPurchaseMode.Text,
Convert.ToDecimal(cmbAgainstVoucherType.SelectedValue.ToString()), txtOrderNo.Text,
Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()), txtVoucherNo.Text, txtProductCode.Text, txtProductName.Text);
dgvPurchaseReport.DataSource = ListObj[0];
foreach (DataGridViewRow dgvrow in dgvPurchaseReport.Rows)
{
if (dgvrow.Cells["dgvtxtBillAmount"].Value != null)
{
if (dgvrow.Cells["dgvtxtBillAmount"].Value.ToString() != string.Empty)
{
decTotalAmount = decTotalAmount + Convert.ToDecimal(dgvrow.Cells["dgvtxtBillAmount"].Value.ToString());
}
}
}
txtTotalAmount.Text = Math.Round(decTotalAmount, PublicVariables._inNoOfDecimalPlaces).ToString();
}
catch (Exception ex)
{
MessageBox.Show("PIREP5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// When doubleclicking on the grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvReport_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
decimal decVouchertypeId = 0;
string strVoucherNo = string.Empty;
try
{
if (dgvReport.CurrentRow.Index == e.RowIndex)
{
if ((dgvReport.CurrentRow.Cells["voucherTypeId"].Value != null && dgvReport.CurrentRow.Cells["voucherTypeId"].Value.ToString() != string.Empty))
{
int inI = dgvReport.CurrentCell.RowIndex;
foreach (DataGridViewRow dgv in dgvReport.Rows)
{
if (dgv.Cells["VoucherNo"].Value != null && dgv.Cells["VoucherNo"].Value.ToString() != string.Empty &&
dgv.Cells["voucherTypeId"].Value != null && dgv.Cells["voucherTypeId"].Value.ToString() != string.Empty)
{
strVoucherType = dgv.Cells["VoucherType"].Value.ToString();
decVouchertypeId = Convert.ToDecimal(dgv.Cells["voucherTypeId"].Value.ToString());
strVoucherNo = dgv.Cells["VoucherNo"].Value.ToString();
}
else
{
if (dgv.Cells["ledgerId"].Value.ToString() != string.Empty)
{
decledgerId = decimal.Parse(dgv.Cells["ledgerId"].Value.ToString());
strVoucherType = dgv.Cells["Account Ledger"].Value.ToString();
frmLedgerDetails frmLedger = new frmLedgerDetails();
frmLedger = Application.OpenForms["frmLedgerDetails"] as frmLedgerDetails;
if (frmLedger == null)
{
frmLedger = new frmLedgerDetails();
frmLedger.MdiParent = formMDI.MDIObj;
frmLedger.callFromAgeing(this, decledgerId);
this.Enabled = false;
}
}
}
if (dgv.Index == inI)
{
break;
}
}
if (strVoucherType == "Payment Voucher")
{
PaymentVoucherBll BllPaymentVoucher = new PaymentVoucherBll();
decMasterId = BllPaymentVoucher.paymentMasterIdView(decVouchertypeId, strVoucherNo);
frmPaymentVoucher frmPaymentVoucher = new frmPaymentVoucher();
frmPaymentVoucher = Application.OpenForms["frmPaymentVoucher"] as frmPaymentVoucher;
if (frmPaymentVoucher == null)
{
frmPaymentVoucher = new frmPaymentVoucher();
frmPaymentVoucher.MdiParent = formMDI.MDIObj;
frmPaymentVoucher.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "Receipt Voucher")
{
RecieptVoucherBll bllRecieptVoucher = new RecieptVoucherBll();
//ReceiptMasterSP spRecieptMaster = new ReceiptMasterSP();
decMasterId = bllRecieptVoucher.ReceiptMasterIdView(decVouchertypeId, strVoucherNo);
frmReceiptVoucher frmReceiptVoucher = new frmReceiptVoucher();
frmReceiptVoucher = Application.OpenForms["frmReceiptVoucher"] as frmReceiptVoucher;
if (frmReceiptVoucher == null)
{
frmReceiptVoucher = new frmReceiptVoucher();
frmReceiptVoucher.MdiParent = formMDI.MDIObj;
frmReceiptVoucher.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "Journal Voucher")
{
JournalVoucherBll bllJournalMaster = new JournalVoucherBll();
decMasterId = bllJournalMaster.JournalMasterIdView(decVouchertypeId, strVoucherNo);
frmJournalVoucher frmJournalVoucher = new frmJournalVoucher();
frmJournalVoucher = Application.OpenForms["frmJournalVoucher"] as frmJournalVoucher;
if (frmJournalVoucher == null)
{
frmJournalVoucher = new frmJournalVoucher();
frmJournalVoucher.MdiParent = formMDI.MDIObj;
frmJournalVoucher.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "PDC Receivable")
{
PDCRecivebleBll BllPDCReciveble = new PDCRecivebleBll();
decMasterId = BllPDCReciveble.PdcReceivableMasterIdView(decVouchertypeId, strVoucherNo);
frmPdcReceivable frmPdcReceivable = new frmPdcReceivable();
frmPdcReceivable = Application.OpenForms["frmPdcReceivable"] as frmPdcReceivable;
if (frmPdcReceivable == null)
{
frmPdcReceivable = new frmPdcReceivable();
frmPdcReceivable.MdiParent = formMDI.MDIObj;
frmPdcReceivable.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "PDC Payable")
{
PDCPayableBll BllPDCPayable = new PDCPayableBll();
decMasterId = BllPDCPayable.PdcPayableMasterIdView(decVouchertypeId, strVoucherNo);
frmPdcPayable frmPdcPayable = new frmPdcPayable();
frmPdcPayable = Application.OpenForms["frmPdcPayable"] as frmPdcPayable;
if (frmPdcPayable == null)
{
frmPdcPayable = new frmPdcPayable();
frmPdcPayable.MdiParent = formMDI.MDIObj;
frmPdcPayable.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else if (strVoucherType == "Sales Invoice")
{
//SalesMasterSP spMaster = new SalesMasterSP();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
decMasterId = BllSalesInvoice.SalesMasterIdViewByvoucherNoAndVoucherType(decVouchertypeId, strVoucherNo);
//SalesMasterSP spSalesMaster = new SalesMasterSP();
bool blPOS = BllSalesInvoice.DayBookSalesInvoiceOrPOS(decMasterId, decVouchertypeId);
frmSalesInvoice frmSalesInvoice = new frmSalesInvoice();
frmPOS frmPOS = new frmPOS();
if (blPOS == true)
{
frmPOS = Application.OpenForms["frmPOS"] as frmPOS;
if (frmPOS == null)
{
frmPOS = new frmPOS();
frmPOS.MdiParent = formMDI.MDIObj;
frmPOS.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
else
{
frmSalesInvoice = Application.OpenForms["frmSalesInvoice"] as frmSalesInvoice;
if (frmSalesInvoice == null)
{
frmSalesInvoice = new frmSalesInvoice();
frmSalesInvoice.MdiParent = formMDI.MDIObj;
frmSalesInvoice.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
}
else if (strVoucherType == "Purchase Invoice")
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
decMasterId = BllPurchaseInvoice.PurchaseMasterIdViewByvoucherNoAndVoucherType(decVouchertypeId, strVoucherNo);
frmPurchaseInvoice objpurchase = new frmPurchaseInvoice();
objpurchase.WindowState = FormWindowState.Normal;
objpurchase.MdiParent = formMDI.MDIObj;
objpurchase.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
else if (strVoucherType == "Credit Note")
{
CreditNoteBll BllCreditNoteMaster = new CreditNoteBll();
decMasterId = BllCreditNoteMaster.CreditNoteMasterIdView(decVouchertypeId, strVoucherNo);
frmCreditNote objpurchase = new frmCreditNote();
objpurchase.WindowState = FormWindowState.Normal;
objpurchase.MdiParent = formMDI.MDIObj;
objpurchase.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
else if (strVoucherType == "Debit Note")
{
//DebitNoteMasterSP spDebitNote = new DebitNoteMasterSP();
DebitNoteBll bllDebitNote = new DebitNoteBll();
decMasterId = bllDebitNote.DebitNoteMasterIdView(decVouchertypeId, strVoucherNo);
frmDebitNote objpurchase = new frmDebitNote();
objpurchase.WindowState = FormWindowState.Normal;
objpurchase.MdiParent = formMDI.MDIObj;
objpurchase.callFromAgeing(this, decMasterId);
this.Enabled = false;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("AR17:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
