Beispiel #1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            PurRemainBL objPur = new PurRemainBL()
            {
                CompanyID  = Convert.ToInt32(txtComID.Text),
                Date       = Convert.ToDateTime(txtDate.Text),
                ReturnCash = Convert.ToDecimal(txtReturnCash.Text)
            };

            objPur.Save();

            PurchaseLedgerBL objLedger = new PurchaseLedgerBL();

            if (string.IsNullOrEmpty(txtDescription.Text))
            {
                objLedger.PRemainID   = Convert.ToInt32(txtRemainID.Text);
                objLedger.CompanyID   = Convert.ToInt32(txtComID.Text);
                objLedger.Credit      = 0;
                objLedger.Debit       = Convert.ToDecimal(txtReturnCash.Text);
                objLedger.Date        = Convert.ToDateTime(txtDate.Text);
                objLedger.Balance     = Convert.ToDecimal(txtNewBalance.Text);
                objLedger.Description = "Credit";
            }
            else
            {
                objLedger.PRemainID   = Convert.ToInt32(txtRemainID.Text);
                objLedger.CompanyID   = Convert.ToInt32(txtComID.Text);
                objLedger.Credit      = 0;
                objLedger.Debit       = Convert.ToDecimal(txtReturnCash.Text);
                objLedger.Date        = Convert.ToDateTime(txtDate.Text);
                objLedger.Balance     = Convert.ToDecimal(txtNewBalance.Text);
                objLedger.Description = txtDescription.Text;
            }
            objLedger.save();
            (new PurchaseLedgerBL()).UpdateBalance(objLedger.Balance, objLedger.CompanyID);

            MessageBox.Show("Payment Paid " + txtReturnCash.Text);

            PurRemainIDReport objrpt = new PurRemainIDReport();

            objrpt.SetParameterValue("@RemainID", txtRemainID.Text);
            rptViewer objView = new rptViewer();

            objView.crptViewer.ReportSource = objrpt;
            objView.WindowState             = FormWindowState.Normal;
            objView.ShowDialog();

            ClearGroup();
        }
 private void btnSave_Click(object sender, EventArgs e)
 {
     try
     {
         decimal preBal = Convert.ToDecimal(txtPreBal.Text);
         if (FormValidate() == true)
         {
             CompanyBL objCom = new CompanyBL()
             {
                 CompanyName = txtComName.Text,
                 Email       = txtEmail.Text,
                 Contact     = txtContact.Text,
                 Address     = txtAddress.Text,
                 DuePayment  = Convert.ToDecimal(txtPreBal.Text)
             };
             if (preBal > 0)
             {
                 PurchaseLedgerBL objBl = new PurchaseLedgerBL()
                 {
                     CompanyID   = Convert.ToInt32(txtComID.Text),
                     Debit       = Convert.ToDecimal(txtPreBal.Text),
                     Credit      = 0,
                     Date        = Convert.ToDateTime(DateTime.Now.ToShortDateString()),
                     Balance     = Convert.ToDecimal(txtPreBal.Text),
                     Description = "Opening Balance"
                 };
                 objBl.save();
             }
             objCom.Save();
             MessageBox.Show("Record Saved Successfull");
             LoadData();
             btnAddnew.Enabled = true;
             ClearGroup();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message.ToString());
     }
 }
        private void btnSave_Click(object sender, EventArgs e)
        {
            PurchaseInvoiceBL objpur = new PurchaseInvoiceBL();

            for (int i = 0; i < dgvProduct.Rows.Count; i++)
            {
                objpur.ProductID = Convert.ToInt32(dgvProduct.Rows[i].Cells[1].Value.ToString());
                objpur.Quantity  = Convert.ToInt32(dgvProduct.Rows[i].Cells[4].Value.ToString());
                objpur.ProdUpdate();
            }
            PurchaseInvoiceBL objCtn = new PurchaseInvoiceBL();

            for (int i = 0; i < dgvProduct.Rows.Count; i++)
            {
                objCtn.ProductID = Convert.ToInt32(dgvProduct.Rows[i].Cells[1].Value.ToString());
                objCtn.Ctn       = Convert.ToInt32(dgvProduct.Rows[i].Cells[7].Value.ToString());
                objCtn.CtnUpdate();
            }



            PurchaseInvoiceBL objmas = new PurchaseInvoiceBL()
            {
                PInvoice     = Convert.ToInt32(txtInvoiceID.Text),
                companyID    = Convert.ToInt32(txtComID.Text),
                Discount     = Convert.ToDecimal(txtBillDiscount.Text),
                PurchaseDate = DateTime.Parse(txtPurInvoiceDate.Text),
                TotalAmount  = Convert.ToDecimal(txttotalAmount.Text),
                Payment      = Convert.ToDecimal(txtTotalPay.Text),
                DuePayment   = Convert.ToDecimal(txtPayDue.Text),
                furDiscount  = Convert.ToDecimal(txtfurDiscount.Text),
                GrandTotal   = Convert.ToDecimal(txtGrandTotal.Text)
            };

            PurchaseInvoiceBL objDet = new PurchaseInvoiceBL();

            for (int i = 0; i < dgvProduct.Rows.Count; i++)
            {
                objDet.PInvoice  = Convert.ToInt32(txtInvoiceID.Text);
                objDet.ProductID = Convert.ToInt32(dgvProduct.Rows[i].Cells[1].Value.ToString());
                objDet.TP        = Convert.ToDecimal(dgvProduct.Rows[i].Cells[3].Value.ToString());
                objDet.Quantity  = Convert.ToInt32(dgvProduct.Rows[i].Cells[4].Value.ToString());
                objDet.frieght   = Convert.ToDecimal(dgvProduct.Rows[i].Cells[6].Value.ToString());
                objDet.Ctn       = Convert.ToDecimal(dgvProduct.Rows[i].Cells[7].Value.ToString());
                objDet.Amount    = Convert.ToDecimal(dgvProduct.Rows[i].Cells[8].Value.ToString());
                objDet.SaveDetail();
            }
            objmas.SaveMaster();
            PurchaseLedgerBL objLedger = new PurchaseLedgerBL();

            objLedger.PInvoice    = Convert.ToInt32(txtInvoiceID.Text);
            objLedger.CompanyID   = Convert.ToInt32(txtComID.Text);
            objLedger.Credit      = Convert.ToDecimal(txtPayDue.Text);
            objLedger.Debit       = 0;
            objLedger.Date        = Convert.ToDateTime(txtPurInvoiceDate.Text);
            objLedger.Balance     = Convert.ToDecimal(txtnewBalance.Text);
            objLedger.Description = "Debit";
            objLedger.save();
            (new PurchaseLedgerBL()).UpdateBalance(objLedger.Balance, objLedger.CompanyID);

            PurchaseInvoiceReport objretp = new PurchaseInvoiceReport();
            rptViewer             objView = new rptViewer();

            objretp.SetParameterValue("@PInvoice", txtInvoiceID.Text);
            PurchaseInvoiceBL objBl = new PurchaseInvoiceBL()
            {
                PInvoice = Convert.ToInt32(txtInvoiceID.Text)
            };
            var dt = objBl.Search();

            if (dt != null)
            {
                objretp.SetDataSource(dt);
                objView.crptViewer.ReportSource = objretp;
                objView.WindowState             = FormWindowState.Maximized;
                objView.ShowDialog();
            }
            ClearForm();
            ChkFrieghtOrder.Checked = false;
            btnNew.Enabled          = true;
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            PurchaseReturnBL objUpdate = new PurchaseReturnBL();
            {
                for (int i = 0; i < dgvReturnItem.Rows.Count; i++)
                {
                    objUpdate.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[1].Value.ToString());
                    objUpdate.Quantity  = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[5].Value.ToString());
                    objUpdate.ProdUpdate();
                }
            }
            PurchaseReturnBL objCtn = new PurchaseReturnBL();
            {
                for (int i = 0; i < dgvReturnItem.Rows.Count; i++)
                {
                    objCtn.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[1].Value.ToString());
                    objCtn.Ctn       = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[4].Value.ToString());
                    objCtn.CtnUpdate();
                }
            }

            PurchaseReturnBL objDetail = new PurchaseReturnBL();

            {
                for (int i = 0; i < dgvReturnItem.Rows.Count; i++)
                {
                    objDetail.PReturnID = Convert.ToInt32(txtReturnID.Text);
                    objDetail.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[1].Value.ToString());
                    objDetail.TP        = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[3].Value.ToString());
                    objDetail.Ctn       = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[4].Value.ToString());
                    objDetail.Quantity  = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[5].Value.ToString());
                    objDetail.Amount    = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[6].Value.ToString());
                    objDetail.SaveDetail();
                }
            }


            if (txtBalance.Text != "0.00")
            {
                PurRemainBL objPurc = new PurRemainBL()
                {
                    CompanyID  = Convert.ToInt32(txtComID.Text),
                    ReturnCash = Convert.ToDecimal(txtBalance.Text),
                    Date       = Convert.ToDateTime(txtReturnDate.Text),
                    PReturnID  = Convert.ToInt32(txtReturnID.Text)
                };
                objPurc.Save();
            }
            PurchaseReturnBL objMas = new PurchaseReturnBL()
            {
                PInvoice    = Convert.ToInt32(txtInvoiceID.Text),
                CompanyID   = Convert.ToInt32(txtComID.Text),
                Discount    = Convert.ToDecimal(txtBillDiscount.Text),
                ReturnDate  = DateTime.Parse(txtReturnDate.Text),
                TotalAmount = Convert.ToDecimal(txtGrandTotal.Text),
                ReturnCash  = Convert.ToDecimal(txtReturnCash.Text),
                DuePayment  = Convert.ToDecimal(txtBalance.Text),
                furDiscount = Convert.ToDecimal(txtfurDiscount.Text),
                GrandTotal  = Convert.ToDecimal(txtGrandTotal.Text)
            };

            objMas.SaveMaster();
            PurchaseLedgerBL objLedger = new PurchaseLedgerBL();

            objLedger.PReturnID   = Convert.ToInt32(txtReturnID.Text);
            objLedger.CompanyID   = Convert.ToInt32(txtComID.Text);
            objLedger.Credit      = 0;
            objLedger.Debit       = Convert.ToDecimal(txtBalance.Text);
            objLedger.Date        = Convert.ToDateTime(txtReturnDate.Text);
            objLedger.Balance     = Convert.ToDecimal(txtNewBalance.Text);
            objLedger.Description = "Credit";
            objLedger.save();
            (new PurchaseLedgerBL()).UpdateBalance(objLedger.Balance, objLedger.CompanyID);
            ClearForm();
            btnNew.Enabled = true;
            //  DesignClear(this);
        }