Esempio n. 1
0
 public void AddInvoiceProducts(InvoiceProduct invoiceProduct)
 {
     Db.ExecuteNonQuery("usp_Invoice_InsertInvoiceProducts", CommandType.StoredProcedure,
         new DbParameter[] {
                        Db.CreateParameter("InvoiceId", invoiceProduct.InvoiceId),
                        Db.CreateParameter("ProductId", invoiceProduct.ProductId),
                        Db.CreateParameter("ProductName", invoiceProduct.ProductName),
                        Db.CreateParameter("Description", invoiceProduct.Description),
                        Db.CreateParameter("Quantity", invoiceProduct.Quantity),
                        Db.CreateParameter("UnitPrice", invoiceProduct.UnitPrice),
                        Db.CreateParameter("TotalPrice", invoiceProduct.TotalPrice),
                        Db.CreateParameter("TaxId", invoiceProduct.TaxId),
                        Db.CreateParameter("TaxValue", invoiceProduct.TaxValue)
          });
 }
Esempio n. 2
0
 public void UpdateInvoiceProducts(InvoiceProduct invoiceProduct)
 {
     this.invoiceDBObj.UpdateInvoiceProducts(invoiceProduct);
 }
Esempio n. 3
0
        private void btnSaveInvoice_Click(object sender, EventArgs e)
        {
            try
            {
                int invoiceId = string.IsNullOrEmpty(txtInvoiceNumber.Text) ? 0 : Convert.ToInt32(txtInvoiceNumber.Text);
                var invoiceDetails = invoiceService.GetInvoice(invoiceId);
                var comapnyDetails = (from company in companyService.GetAllCompany()
                                     .Where(v => v.Status == true)
                                      select company).SingleOrDefault();

                Invoice invoice = new Invoice();
                invoice.InvoiceId = invoiceId;
                invoice.CompanyId = comapnyDetails.CompanyId;
                invoice.ClientId = ClientId;
                invoice.IssueDate = dtpIssueDate.Value.Date;
                invoice.PurchaseOrderNo = string.IsNullOrEmpty(txtPONumber.Text) ? String.Empty : txtPONumber.Text;
                invoice.PaymentTermId = Convert.ToInt32(cmbPaymentTerms.SelectedValue);
                invoice.DueDate = dtpDueDate.Value.Date;
                invoice.Discount = string.IsNullOrEmpty(txtDiscount.Text) ? decimal.Zero : Convert.ToDecimal(txtDiscount.Text);
                invoice.RoundOffTotal = chkRoundOff.Checked;
                invoice.MarkInvoicePaid = chkMarkInvoicePaid.Checked;

                if (chkMarkInvoicePaid.Checked)
                {
                    invoice.PaymentTypeId = Convert.ToInt32(cmbPaymentType.SelectedValue);
                    invoice.AmountPaid = string.IsNullOrEmpty(txtAmountPaid.Text) ? decimal.Zero : Convert.ToDecimal(txtAmountPaid.Text);

                    if (invoiceDetails == null || invoiceDetails.InvoiceId == 0)
                    {
                        invoice.PaymentDate = DateTime.Now.Date;
                    }
                    else
                    {
                        if (invoiceDetails.AmountPaid > 0)
                        {
                            if (invoiceDetails.AmountPaid == invoice.AmountPaid)
                            {
                                invoice.PaymentDate = invoiceDetails.PaymentDate;
                            }
                            else
                            {
                                invoice.PaymentDate = DateTime.Now.Date;
                            }
                        }
                    }
                    string paymentStatus = String.Empty;

                    if (invoice.AmountPaid == 0)
                    {
                        paymentStatus = ePaymentStatus.Unpaid.ToString();
                    }
                    else if (invoice.AmountPaid > 0)
                    {
                        if (invoice.AmountPaid < TotalValue)
                        {
                            paymentStatus = ePaymentStatus.Partial.ToString();
                        }
                        else if (invoice.AmountPaid == TotalValue)
                        {
                            paymentStatus = ePaymentStatus.Paid.ToString();
                        }
                        else
                        {
                            paymentStatus = ePaymentStatus.Paid.ToString();
                        }
                    }

                    if (invoice.PaymentDate.Date > invoice.DueDate.Date)
                    {
                        if (String.IsNullOrEmpty(paymentStatus))
                        {
                            paymentStatus = String.Concat(paymentStatus, ",", ePaymentStatus.Overdue.ToString());
                        }
                        else
                        {
                            paymentStatus = ePaymentStatus.Overdue.ToString();
                        }
                    }

                    invoice.PaymentStatus = paymentStatus;
                }
                else
                {
                    invoice.PaymentTypeId = 0;
                    invoice.AmountPaid = decimal.Zero;
                }

                invoice.Notes = string.IsNullOrEmpty(txtNotes.Text) ? String.Empty : txtNotes.Text;
                invoice.TotalAmount = TotalValue;
                invoice.NotesForClient = string.IsNullOrEmpty(txtNoteForClient.Text) ? String.Empty : txtNoteForClient.Text;
                invoice.PrivateNotes = string.IsNullOrEmpty(txtprivateNotes.Text) ? String.Empty : txtprivateNotes.Text;
                invoice.Status = true;

                if (invoiceDetails == null || invoiceDetails.InvoiceId == 0)
                {
                    using (TransactionScope scope = new TransactionScope())
                    {
                        invoiceService.AddInvoice(invoice);
                        lstInvoiceProduct = lstInvoiceProduct.OrderBy(s => s.InvoiceProductId).ToList<InvoiceProduct>();

                        for (int i = 0; i < lstInvoiceProduct.Count; i++)
                        {
                            InvoiceProduct invoiceProduct = new InvoiceProduct();
                            invoiceProduct.InvoiceId = lstInvoiceProduct[i].InvoiceId;
                            invoiceProduct.ProductId = lstInvoiceProduct[i].ProductId;
                            invoiceProduct.ProductName = lstInvoiceProduct[i].ProductName;
                            invoiceProduct.Description = lstInvoiceProduct[i].Description;
                            invoiceProduct.Quantity = lstInvoiceProduct[i].Quantity;
                            invoiceProduct.TaxId = lstInvoiceProduct[i].TaxId;
                            invoiceProduct.TaxValue = lstInvoiceProduct[i].TaxValue;
                            invoiceProduct.UnitPrice = lstInvoiceProduct[i].UnitPrice;
                            invoiceProduct.TotalPrice = lstInvoiceProduct[i].TotalPrice;
                            invoiceService.AddInvoiceProducts(invoiceProduct);
                        }

                        scope.Complete();
                    }
                }
                else
                {
                    using (TransactionScope scope = new TransactionScope())
                    {
                        invoiceService.UpdateInvoice(invoice);

                        for (int i = 0; i < lstInvoiceProduct.Count; i++)
                        {
                            InvoiceProduct invoiceProduct = new InvoiceProduct();
                            invoiceProduct.InvoiceId = lstInvoiceProduct[i].InvoiceId;
                            invoiceProduct.ProductId = lstInvoiceProduct[i].ProductId;
                            invoiceProduct.ProductName = lstInvoiceProduct[i].ProductName;
                            invoiceProduct.Description = lstInvoiceProduct[i].Description;
                            invoiceProduct.Quantity = lstInvoiceProduct[i].Quantity;
                            invoiceProduct.TaxId = lstInvoiceProduct[i].TaxId;
                            invoiceProduct.TaxValue = lstInvoiceProduct[i].TaxValue;
                            invoiceProduct.UnitPrice = lstInvoiceProduct[i].UnitPrice;
                            invoiceProduct.TotalPrice = lstInvoiceProduct[i].TotalPrice;
                            invoiceService.UpdateInvoiceProducts(invoiceProduct);
                        }

                        scope.Complete();
                    }
                }

                CustomMessageBox.Show(string.Format(Constants.SUCCESSFULL_ADD_INVOICE_MESSAGE, invoice.InvoiceId),
                                                              Constants.CONSTANT_INFORMATION,
                                                              Sleek_Bill.Controls.CustomMessageBox.eDialogButtons.OK,
                                                              CustomImages.GetDialogImage(Sleek_Bill.Controls.CustomImages.eCustomDialogImages.Success));
                this.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Saving invoice: " + ex.Message);
            }
        }
Esempio n. 4
0
 public void AddInvoiceProducts(InvoiceProduct invoiceProduct)
 {
     this.invoiceDBObj.AddInvoiceProducts(invoiceProduct);
 }
Esempio n. 5
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            List<Tax> lstTax = masterService.GetAllTaxes();
            invoiceProduct = new InvoiceProduct();
            invoiceProduct.InvoiceProductId = lstInvoiceProduct.Count;
            invoiceProduct.InvoiceId = String.IsNullOrEmpty(txtInvoiceNumber.Text) ? 0 : Convert.ToInt32(txtInvoiceNumber.Text);
            invoiceProduct.ProductId = Convert.ToInt32(cmbProduct.SelectedValue);
            invoiceProduct.ProductName = cmbProduct.Text.Trim();
            invoiceProduct.Description = txtDescription.Text.Trim();
            invoiceProduct.Quantity = String.IsNullOrEmpty(txtQuantity.Text) ? 0 : Convert.ToInt32(txtQuantity.Text);
            invoiceProduct.UnitPrice = String.IsNullOrEmpty(txtUnitPrice.Text) ? decimal.Zero : Math.Round(Convert.ToDecimal(txtUnitPrice.Text), 2);
            invoiceProduct.TotalPrice = Math.Round(invoiceProduct.Quantity * invoiceProduct.UnitPrice, 2);
            invoiceProduct.TaxId = Convert.ToInt32(cmbTax.SelectedValue);
            var objTax = (from tax in lstTax
                      .Where(v => v.TaxId == invoiceProduct.TaxId)
                          select tax).SingleOrDefault();

            invoiceProduct.TaxValue = Math.Round((invoiceProduct.Quantity * invoiceProduct.UnitPrice) * objTax.TaxPercentage * (decimal)0.01, 2);
            lstInvoiceProduct.Add(invoiceProduct);
            BindInvoiceProductGrid();
            ClearProductControls();
            CalculateInvoice();
        }