/// <summary>
/// On print button click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
DataSet dsfree = new DataSet();
try
{
//SalesMasterSP spSalesMaster = new SalesMasterSP();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
DateTime fromDate, toDate;
fromDate = Convert.ToDateTime(txtFromDate.Text);
toDate = Convert.ToDateTime(txtToDate.Text);
string voucherNo = txtVoucherNo.Text.ToString();
decimal voucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
decimal groupId = Convert.ToDecimal(cmbProductGroup.SelectedValue.ToString());
decimal companyId = 1;
decimal ledgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
decimal employeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
string productCode = cmbProductCode.Text.ToString();
dsfree = BllSalesInvoice.FreeSaleReportPrint(fromDate, toDate, voucherNo, voucherTypeId, groupId, productCode, ledgerId, employeeId, companyId);
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
if (dgvFreeSalesReport.Rows.Count > 0)
{
frmReport.freeSaleReport(dsfree);
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("FSR :17" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the grid
/// </summary>
public void GridFill()
{
try
{
List <DataTable> listObj = new List <DataTable>();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
DataTable dtbl = new DataTable();
DateTime fromDate, toDate;
fromDate = Convert.ToDateTime(txtFromDate.Text);
toDate = Convert.ToDateTime(txtToDate.Text);
string voucherNo = txtVoucherNo.Text.ToString();
decimal voucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
decimal groupId = Convert.ToDecimal(cmbProductGroup.SelectedValue.ToString());
decimal ledgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
decimal employeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
string productCode = cmbProductCode.Text.ToString();
listObj = BllSalesInvoice.FreeSaleReportGridFill(fromDate, toDate, voucherNo, voucherTypeId, groupId, productCode, ledgerId, employeeId);
dgvFreeSalesReport.DataSource = listObj[0];
}
catch (Exception ex)
{
MessageBox.Show("FSR :01" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// When doubleclicking on the grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvVatreturn_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvVatreturn.Rows.Count > 1)
{
if (dgvVatreturn.CurrentRow.Cells["dgvtxtsalesmasterid"].Value != null)
{
//SalesMasterSP spSale = new SalesMasterSP();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
strVoucherName = dgvVatreturn.CurrentRow.Cells["dgvtxtvoucherName"].Value.ToString();
dcSalesId = Convert.ToDecimal(dgvVatreturn.CurrentRow.Cells["dgvtxtsalesmasterid"].Value.ToString());
if (dgvVatreturn.CurrentRow.Cells["dgvtxtvoucherName"].Value != null)
{
string strpos = BllSalesInvoice.SaleMasterGetPos(dcSalesId, strVoucherName);
if (strpos == "0")
{
frmSalesInvoice objfrmsaleInvoice;
objfrmsaleInvoice = Application.OpenForms["frmSalesInvoice"] as frmSalesInvoice;
if (objfrmsaleInvoice == null)
{
objfrmsaleInvoice = new frmSalesInvoice();
objfrmsaleInvoice.MdiParent = formMDI.MDIObj;
objfrmsaleInvoice.callFromVatReturnReport(this, dcSalesId);
}
else
{
objfrmsaleInvoice.callFromVatReturnReport(this, dcSalesId);
}
}
if (strpos == "1")
{
frmPOS objfrmpos;
objfrmpos = Application.OpenForms["frmPOS"] as frmPOS;
if (objfrmpos == null)
{
objfrmpos = new frmPOS();
objfrmpos.MdiParent = formMDI.MDIObj;
objfrmpos.callFromVatReturnReport(this, dcSalesId);
}
else
{
objfrmpos.callFromVatReturnReport(this, dcSalesId);
}
}
if (strpos == "a")
{
frmPurchaseInvoice objfrmPurchaseInvoice;
objfrmPurchaseInvoice = Application.OpenForms["frmPurchaseInvoice"] as frmPurchaseInvoice;
if (objfrmPurchaseInvoice == null)
{
objfrmPurchaseInvoice = new frmPurchaseInvoice();
objfrmPurchaseInvoice.MdiParent = formMDI.MDIObj;
objfrmPurchaseInvoice.CallFromVatReturnReport(this, dcSalesId);
}
else
{
objfrmPurchaseInvoice.CallFromVatReturnReport(this, dcSalesId);
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("VRR:15" + 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);
}
}
/// <summary>
/// Cell double click in grid to view the curresponding item in that form and open the form
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvVoucherwiseProductSearch_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
int inI = dgvVoucherwiseProductSearch.CurrentCell.RowIndex;
foreach (DataGridViewRow dgv in dgvVoucherwiseProductSearch.Rows)
{
decMasterId = decimal.Parse(dgv.Cells["dgvtxtmasterId"].Value.ToString());
strVoucherType = dgv.Cells["dgvtxtTypeOfVoucher"].Value.ToString();
decVoucherTypeId = Convert.ToDecimal(dgv.Cells["dgvtxtvoucherTypeId"].Value.ToString());
if (dgv.Index == inI)
{
break;
}
}
if (decMasterId != 0 && strVoucherType == "Material Receipt")
{
frmMaterialReceipt objReceipt = new frmMaterialReceipt();
objReceipt.WindowState = FormWindowState.Normal;
objReceipt.MdiParent = formMDI.MDIObj;
objReceipt.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Physical Stock")
{
frmPhysicalStock objPhysical = new frmPhysicalStock();
objPhysical.WindowState = FormWindowState.Normal;
objPhysical.MdiParent = formMDI.MDIObj;
objPhysical.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Purchase Invoice")
{
frmPurchaseInvoice objpurchase = new frmPurchaseInvoice();
objpurchase.WindowState = FormWindowState.Normal;
objpurchase.MdiParent = formMDI.MDIObj;
objpurchase.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Rejection Out")
{
frmRejectionOut objRejection = new frmRejectionOut();
objRejection.WindowState = FormWindowState.Normal;
objRejection.MdiParent = formMDI.MDIObj;
objRejection.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Rejection In")
{
frmRejectionIn objRejection = new frmRejectionIn();
objRejection.WindowState = FormWindowState.Normal;
objRejection.MdiParent = formMDI.MDIObj;
objRejection.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Purchase Return")
{
frmPurchaseReturn objPurchase = new frmPurchaseReturn();
objPurchase.WindowState = FormWindowState.Normal;
objPurchase.MdiParent = formMDI.MDIObj;
objPurchase.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Sales Return")
{
frmSalesReturn frmObj = new frmSalesReturn();
frmObj.WindowState = FormWindowState.Normal;
frmObj.MdiParent = formMDI.MDIObj;
frmObj.CallFromVoucherWiseProductSearch(this, decMasterId, true);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Delivery Note")
{
frmDeliveryNote objDeliveryReport = new frmDeliveryNote();
objDeliveryReport.WindowState = FormWindowState.Normal;
objDeliveryReport.MdiParent = formMDI.MDIObj;
objDeliveryReport.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Sales Order")
{
frmSalesOrder dbjfrmSalesorder = new frmSalesOrder();
dbjfrmSalesorder.WindowState = FormWindowState.Normal;
dbjfrmSalesorder.MdiParent = formMDI.MDIObj;
dbjfrmSalesorder.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Purchase Order")
{
frmPurchaseOrder objfrmPurchaseorder = new frmPurchaseOrder();
objfrmPurchaseorder.WindowState = FormWindowState.Normal;
objfrmPurchaseorder.MdiParent = formMDI.MDIObj;
objfrmPurchaseorder.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Sales Quotation")
{
frmSalesQuotation objfrmSalesquotation = new frmSalesQuotation();
objfrmSalesquotation.WindowState = FormWindowState.Normal;
objfrmSalesquotation.MdiParent = formMDI.MDIObj;
objfrmSalesquotation.CallFromVoucherWiseProductSearch(this, decMasterId);
this.Enabled = false;
}
else if (decMasterId != 0 && strVoucherType == "Sales Invoice")
{
frmSalesInvoice objSalesReport = new frmSalesInvoice();
//SalesMasterSP spSalesMaster = new SalesMasterSP();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
objSalesReport.WindowState = FormWindowState.Normal;
objSalesReport.MdiParent = formMDI.MDIObj;
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.callFromVoucherWiseProductSearch(this, decMasterId);
}
}
else
{
frmSalesInvoice = Application.OpenForms["frmSalesInvoice"] as frmSalesInvoice;
if (frmSalesInvoice == null)
{
frmSalesInvoice = new frmSalesInvoice();
frmSalesInvoice.MdiParent = formMDI.MDIObj;
objSalesReport.CallFromVoucherWiseProductSearch(this, decMasterId);
}
}
this.Enabled = false;
}
}
}
catch (Exception ex)
{
MessageBox.Show("VPS :11" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}