Ejemplo n.º 1
0
    bool deleteSalesDetail(int SalesDetailID)
    {
        // objSalesDetail.BeginTransaction();
        // objSalesDetail = objSalesDetail.Single(p => p.SalesDetailID == SalesDetailID);


        //// double Totalproductprice = objSalesDetail.Price * objSalesDetail.Quantity;

        // // update balance
        // objCustomer = objCustomer.Single(p => p.CustomerID == Convert.ToInt32(ddlCustomer.SelectedValue));
        //// objCustomer.Balance =(objCustomer.Balance)- (Totalproductprice);
        // objCustomer.Update(p => p.CustomerID == objCustomer.CustomerID);

        // //update qty
        // SalesManager.UpdateproductQTY(QTYOperation.Increment, objSalesDetail.ProductID, objSalesDetail.Quantity);
        // // delete row
        // bool status = objSalesDetail.Delete(p => p.SalesDetailID == SalesDetailID);
        // objSalesDetail.EndTransaction();
        // return status;

        objSalesDetail.BeginTransaction();
        objSalesDetail = objSalesDetail.Single(p => p.SalesDetailID == SalesDetailID);
        //var payment = objPurchasesDetail.PurchasesMaster.PaymentsForSupplier;
        //payment.Delete(p => p.SupplierPaymentID == payment.SupplierPaymentID);

        objSalesMaster             = objSalesDetail.SalesMaster;
        objSalesMaster.TotalSales -= objSalesDetail.TotalPrice;
        objSalesMaster.Rest       -= objSalesDetail.TotalPrice;

        objSalesMaster.Update(p => p.SalesID == objSalesMaster.SalesID);
        hfOldRest.Value = objSalesMaster.Rest.ToString();
        // update balance
        if (ddlCustomer.SelectedIndex > 0)
        {
            objCustomer         = objCustomer.Single(p => p.CustomerID == objSalesDetail.SalesMaster.CustomerID);
            objCustomer.Balance = (objCustomer.Balance) - (objSalesDetail.TotalPrice);
            objCustomer.Update(p => p.CustomerID == objCustomer.CustomerID);
        }

        //update qty
        SalesManager.UpdateproductQTY(QTYOperation.Increment, objSalesDetail.ProductID, objSalesDetail.Quantity);

        bool status = objSalesDetail.Delete(p => p.SalesDetailID == SalesDetailID);

        objSalesDetail.EndTransaction();
        return(status);
    }
Ejemplo n.º 2
0
    bool Update()
    {
        objSalesMaster = new SalesMaster();
        objSalesMaster = objSalesMaster.Single(p => p.SalesID == Convert.ToInt32(txtID.Text.Trim()));

        objSalesMaster.CustomerName = txtCustomerName.Text;

        objSalesMaster.EmployeeID = (ddlEmployee.SelectedIndex > 0) ? (Nullable <int>) int.Parse(ddlEmployee.SelectedValue) : null;

        //objSalesMaster.CustomerID  = int.Parse(ddlCustomer .SelectedValue);//?
        objSalesMaster.Notes = txtNotes.Text.Trim();

        objSalesMaster.SalesDateM = Convert.ToDateTime(txtSalesDateM.Text.Trim(), culture);

        objSalesMaster.SalesDateH = txtSalesDateH.Text.Trim();

        objSalesMaster.IsCash = cboxIsCash.Checked;

        double oldrest = objSalesMaster.Rest;

        bool oldPaymentType = objSalesMaster.IsCash;
        int? paymentid      = objSalesMaster.CustomerPaymentID;

        objSalesMaster.TotalSales = Convert.ToDouble(lblTotalSalesPrice.Text);
        objSalesMaster.Rest       = Convert.ToDouble(lblRest.Text);

        double Payments = Convert.ToDouble(!string.IsNullOrEmpty(txtPayment.Text) ? txtPayment.Text : "0.0");

        objSalesMaster.Payments = Payments;



        objSalesMaster.BeginTransaction();


        CustomersPayment CustomersPayment = new CustomersPayment();

        if (paymentid == null)
        {
            if (Payments > 0)
            {
                CustomersPayment.CustomerID        = objSalesMaster.CustomerID;;
                CustomersPayment.PaymentDateM      = Convert.ToDateTime(txtSalesDateM.Text.Trim(), culture);
                CustomersPayment.PaymentDateH      = txtSalesDateH.Text.Trim();
                CustomersPayment.Payment           = Payments;
                CustomersPayment.CustomerPaymentID = Convert.ToInt32(CustomersPayment.Insert());
            }
        }
        else if (paymentid != null)
        {
            CustomersPayment = objSalesMaster.CustomersPayment;
            CustomersPayment.PaymentDateM = Convert.ToDateTime(txtSalesDateM.Text.Trim(), culture);
            CustomersPayment.PaymentDateH = txtSalesDateH.Text.Trim();
            CustomersPayment.Payment      = Payments;
            CustomersPayment.Update(p => p.CustomerPaymentID == CustomersPayment.CustomerPaymentID);
        }

        objSalesMaster.Update(p => p.SalesID == objSalesMaster.SalesID);

        //var q=objPurchasesDetail.Filter(p => p.PurchaseID == objPurchasesMaster.PurchaseID).Select(p => (p.TotalPrice ));
        //double oldTotalPurchasePrice =(q!=null )?q.Sum():0.0;


        List <SalesDetail> SalesList = CurrentgvProducts(gvProducts);

        SalesList.ForEach(p =>
        {
            p.Quantity    = SalesManager.UnitConvert(p.UnitID, p.SQTY);
            p.UnitPrice   = SalesManager.UnitPriceConvert(p.UnitID, p.SUnitPrice);
            p.BasicUnitID = SalesManager.getBasicUnitID;
        });

        //double TotalPurchasePrice = Purchaseslist.Sum(p => p.TotalPrice );
        List <SalesDetail> newSalesList    = SalesList.Where(p => p.SalesDetailID == 0).ToList();
        List <SalesDetail> updateSalesList = SalesList.Where(p => p.SalesDetailID > 0).ToList();



        if (newSalesList.Count > 0)
        {
            newSalesList.ForEach(p => p.SalesID = objSalesMaster.SalesID);
            newSalesList.InsertAll();

            // update qty product in store(table product)
            newSalesList.ForEach(p => SalesManager.UpdateproductQTY(QTYOperation.Decrement, p.ProductID, p.Quantity));
        }
        if (updateSalesList.Count > 0)
        {
            updateSalesList.ForEach(p =>
            {
                p.Update(z => z.SalesDetailID == p.SalesDetailID);
                SalesManager.UpdateproductQTY(QTYOperation.Decrement, p.ProductID, (p.Quantity - p.oldQty));
            });
        }



        //========= composite calcualtion balance --- compare between old value and new  value
        if (oldPaymentType != true)// not cash
        {
            if (ddlCustomer.SelectedIndex > 0)
            {
                // any way( - balance) form old supplier if user change supplier
                objCustomer          = objCustomer.Single(p => p.CustomerID == objSalesMaster.CustomerID);
                objCustomer.Balance -= oldrest;
                // objSupplier.Update(p => p.SupplierID == objSupplier.SupplierID);

                if (cboxIsCash.Checked != true)// if (not cash) add new price to balance
                {
                    //objSupplier = objSupplier.Single(p => p.SupplierID == int.Parse(ddlSupplier.SelectedValue));
                    objCustomer.Balance += objSalesMaster.Rest;
                }
                objCustomer.Update(p => p.CustomerID == objCustomer.CustomerID);
            }
        }
        else if (oldPaymentType == true)    //  cash
        {
            if (cboxIsCash.Checked != true) // if user change to (not cash) will add new price to supplier balance
            {
                if (ddlCustomer.SelectedIndex > 0)
                {
                    objCustomer          = objCustomer.Single(p => p.CustomerID == objSalesMaster.CustomerID);
                    objCustomer.Balance += objSalesMaster.Rest;
                    objCustomer.Update(p => p.CustomerID == objCustomer.CustomerID);
                }
            }
        }

        objSalesMaster.EndTransaction();

        return(true);
    }