コード例 #1
0
        /// <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);
            }
        }
コード例 #2
0
 /// <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);
     }
 }
コード例 #3
0
 /// <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);
     }
 }
コード例 #4
0
        /// <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);
            }
        }
コード例 #5
0
        /// <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);
            }
        }