Exemplo n.º 1
0
 /// <summary>
 /// Calling this method automatically opened the indicated form as a Mdi child form in the main form tabs.
 /// Exposes a way to open the Catalogue Form from a Project outside of CDS.Client.Desktop.Catalogue
 /// </summary>
 /// <param name="form">The form control to be displayed in the tabs.</param>
 /// <remarks>Created: Theo Crous 14/11/2011</remarks>
 public void ShowCatalogueForm(DB.VW_Company entity, CDS.Client.BusinessLayer.ORG.ORG_Type type, CDS.Client.Desktop.Essential.BaseForm form)
 {
     CDS.Client.Desktop.Catalogue.CAT.CatalogueForm childForm = new Catalogue.CAT.CatalogueForm();
     childForm.Entity = entity;
     childForm.Type   = type;
     childForm.Tag    = form;
     ShowForm(childForm);
 }
Exemplo n.º 2
0
        /// <summary>
        /// This method is called to show a form in the MainForm as a MDIChildform
        /// http://www.codeproject.com/Articles/9162/Invoking-methods-Runtime-on-method-name
        /// </summary>
        /// <remarks>Created: Werner Scheffer 06/11/2014</remarks>
        /// <param name="form">DevExpress Form to show</param>
        public void ShowCatalogueForm(DB.VW_Company entity, CDS.Client.BusinessLayer.ORG.ORG_Type type, BaseForm form)
        {
            var        mainform    = Application.OpenForms["MainForm"];
            Type       typExternal = mainform.GetType();
            MethodInfo methodInf   = typExternal.GetMethod("ShowCatalogueForm");

            methodInf.Invoke(mainform, new object[] { entity, type, form });
        }
Exemplo n.º 3
0
        protected override void Archive()
        {
            base.Archive();
            DB.SYS_Entity sysEntity = (DB.SYS_Entity)BindingSourceORGEntitySYSEntity.DataSource;

            if (sysEntity.Archived)
            {
                sysEntity.Archived = !sysEntity.Archived;
            }
            else
            {
                DB.VW_Company vwCompany = DataContext.ReadonlyContext.VW_Company.FirstOrDefault(n => n.EntityId == sysEntity.Id);
                if (DataContext.EntityAccountingContext.GLX_History.Any(n => n.EntityId == sysEntity.Id && n.Amount != 0))
                {
                    Essential.BaseAlert.ShowAlert("Archive",
                                                  "This company can not be archive." + Environment.NewLine +
                                                  "\t• Account has outstanding balances.", Essential.BaseAlert.Buttons.Ok, Essential.BaseAlert.Icons.Information);
                }
            }
            btnArchive.Caption = sysEntity.Archived ? "Un-Archive" : "Archive";
            try
            {
                using (TransactionScope transaction = DataContext.GetTransactionScope())
                {
                    DataContext.SaveChangesEntitySystemContext();
                    DataContext.CompleteTransaction(transaction);
                }
                DataContext.EntitySystemContext.AcceptAllChanges();
            }
            catch (Exception ex)
            {
                DataContext.EntitySystemContext.RejectChanges();
                HasErrors = true;
                if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex))
                {
                    throw ex;
                }
            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// Creates Quote from Job
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        public static DB.SYS_DOC_Header CreateSalesOrderFromJob(DB.SYS_DOC_Header entity, DataContext dataContext)
        {
            DB.SYS_DOC_Header docHeader = CopyDocument(entity, dataContext);
            docHeader.TypeId         = (byte)SYS.SYS_DOC_Type.SalesOrder;
            docHeader.ORG_TRX_Header = ORG.ORG_TRX_Header.New;

            docHeader.ORG_TRX_Header.CompanyId            = docHeader.JOB_Header.CompanyId;
            docHeader.ORG_TRX_Header.Telephone            = docHeader.JOB_Header.Telephone;
            docHeader.ORG_TRX_Header.ContactPerson        = docHeader.JOB_Header.ContactPerson;
            docHeader.ORG_TRX_Header.ContactTelephone     = docHeader.JOB_Header.ContactTelephone;
            docHeader.ORG_TRX_Header.ReferenceShort1      = docHeader.JOB_Header.ReferenceShort1;
            docHeader.ORG_TRX_Header.ReferenceShort2      = docHeader.JOB_Header.ReferenceShort2;
            docHeader.ORG_TRX_Header.ReferenceShort3      = docHeader.JOB_Header.ReferenceShort3;
            docHeader.ORG_TRX_Header.ReferenceShort4      = docHeader.JOB_Header.ReferenceShort4;
            docHeader.ORG_TRX_Header.ReferenceShort5      = docHeader.JOB_Header.ReferenceShort5;
            docHeader.ORG_TRX_Header.ReferenceLong1       = docHeader.JOB_Header.ReferenceLong1;
            docHeader.ORG_TRX_Header.ReferenceLong2       = docHeader.JOB_Header.ReferenceLong2;
            docHeader.ORG_TRX_Header.ReferenceLong3       = docHeader.JOB_Header.ReferenceLong3;
            docHeader.ORG_TRX_Header.ReferenceLong4       = docHeader.JOB_Header.ReferenceLong4;
            docHeader.ORG_TRX_Header.ReferenceLong5       = docHeader.JOB_Header.ReferenceLong5;
            docHeader.ORG_TRX_Header.ShippingAddressLine1 = docHeader.JOB_Header.ShippingAddressLine1;
            docHeader.ORG_TRX_Header.ShippingAddressLine2 = docHeader.JOB_Header.ShippingAddressLine2;
            docHeader.ORG_TRX_Header.ShippingAddressLine3 = docHeader.JOB_Header.ShippingAddressLine3;
            docHeader.ORG_TRX_Header.ShippingAddressLine4 = docHeader.JOB_Header.ShippingAddressLine4;
            docHeader.ORG_TRX_Header.ShippingAddressCode  = docHeader.JOB_Header.ShippingAddressCode;
            docHeader.ORG_TRX_Header.BillingAddressLine1  = docHeader.JOB_Header.BillingAddressLine1;
            docHeader.ORG_TRX_Header.BillingAddressLine2  = docHeader.JOB_Header.BillingAddressLine2;
            docHeader.ORG_TRX_Header.BillingAddressLine3  = docHeader.JOB_Header.BillingAddressLine3;
            docHeader.ORG_TRX_Header.BillingAddressLine4  = docHeader.JOB_Header.BillingAddressLine4;
            docHeader.ORG_TRX_Header.BillingAddressCode   = docHeader.JOB_Header.BillingAddressCode;

            DB.VW_Company company = dataContext.ReadonlyContext.VW_Company.FirstOrDefault(n => n.Id == docHeader.ORG_TRX_Header.CompanyId);

            foreach (DB.SYS_DOC_Line line in docHeader.SYS_DOC_Line)
            {
                decimal sellPrice = 0, discountPrice = 0, discountPercentage = 0;

                if ((new byte[] { (byte)SYS.SYS_Type.Inventory, (byte)SYS.SYS_Type.BuyOut }).Contains(line.LineItem.TypeId))
                {
                    ORG.ORG_TRX_PriceHelper.GetSellPrice(line, company, line.Quantity, true, out sellPrice, out discountPrice, out discountPercentage, dataContext);

                    line.Amount             = discountPrice;
                    line.DiscountPercentage = discountPercentage;
                }
                line.Total = Math.Round(line.Amount * (line.LineItem.TypeId == (byte)SYS.SYS_Type.Account ? 1 : line.Quantity), 2, MidpointRounding.AwayFromZero);

                //line.ProfitPercentage = (line.Amount > 0) ? (line.Amount - line.UnitAverage) / line.Amount : 0M;

                switch (company.CostCategoryId)
                {
                case (byte)ORG.ORG_CostCategory.SellingPriceIncludingSalesTax:
                    line.TotalTax = line.Total * ApplicationDataContext.Instance.CompanySite.VatPercentage / 100;
                    break;

                case (byte)ORG.ORG_CostCategory.SellingPriceExcludingSalesTax:
                    line.TotalTax = 0;
                    break;

                case (byte)ORG.ORG_CostCategory.CostIncludingSalesTax:
                    line.TotalTax = line.Total * ApplicationDataContext.Instance.CompanySite.VatPercentage / 100;
                    break;

                case (byte)ORG.ORG_CostCategory.CostExcludingSalesTax:
                    line.TotalTax = 0;
                    break;

                case (byte)ORG.ORG_CostCategory.AverageCostExcludingSalesTax:
                    line.TotalTax = 0;
                    break;
                }

                line.TotalTax = Math.Round(line.TotalTax, 2, MidpointRounding.AwayFromZero);
                line.FromJob  = true;
            }
            docHeader.Generated = true;
            return(docHeader);
        }
Exemplo n.º 5
0
        public static void GetSellPrice(DB.SYS_DOC_Line line, DB.VW_Company entity, decimal amount, bool useWarehouseDiscount, out decimal sellPrice, out decimal discountPrice, out decimal discountPercentage, DataContext dataContext)
        {
            if (line == null || line.LineItem == null || (line.LineItem as DB.VW_LineItem).InventoryId == null)
            {
                sellPrice          = line.Amount;
                discountPrice      = line.Amount;
                discountPercentage = 0M;
                return;
            }

            sellPrice          = line.Amount;
            discountPrice      = 0M;
            discountPercentage = 0M;
            if ((entity == null))
            {
                // NO entity SELECTED
                //sellPrice = inventoryItem.UnitPrice;
                return;
            }

            DB.VW_LineItem inventory = line.LineItem as DB.VW_LineItem;
            var            discounts = dataContext.ReadonlyContext.VW_Discount.Where(n => (n.CompanyDiscountCode == entity.DiscountCode || n.EntityId == entity.OrgEntityId) && (n.InventoryDiscountCode == inventory.DiscountCode || n.InventoryId == inventory.InventoryId)).ToList();


            //If any of the discounts are fixed price discounts
            if (discounts.Any(n => n.DiscountAmountTypeId == (byte)BL.ITM.ITM_DIS_AmountType.FixedPriceDiscount))
            {
                if (!useWarehouseDiscount)
                {
                    sellPrice = discounts.Min(n => n.CompanyDiscount).Value;
                }
                else
                {
                    sellPrice = discounts.Min(n => n.WorkshopDiscount).Value;
                }
                discountPrice      = sellPrice;
                discountPercentage = 0;
                return;
            }
            else
            {
                //Henko: I am pretty sure if anything this should be MIN not MAX? But either way this is really badly done...
                if (!useWarehouseDiscount)
                {
                    discountPercentage = discounts.Count() > 0 ? discounts.Max(n => n.CompanyDiscount).Value : 0;
                }
                else
                {
                    discountPercentage = discounts.Count() > 0 ? discounts.Max(n => n.WorkshopDiscount).Value : 0;
                }
            }

            if ((entity.CostCategoryId == (byte)BL.ORG.ORG_CostCategory.CostExcludingSalesTax) || (entity.CostCategoryId == (byte)BL.ORG.ORG_CostCategory.CostIncludingSalesTax))
            {
                // COST INCLUDING or COST EXCLUDING
                if (discountPercentage < 0)
                {
                    discountPrice = inventory.UnitCost - (inventory.UnitCost * discountPercentage / 100);
                    sellPrice     = inventory.UnitCost;
                }
                else
                {
                    discountPrice = (inventory.UnitCost * (100 - discountPercentage)) / 100;
                    sellPrice     = inventory.UnitCost;
                }
                //sellPrice = line.UnitCost;
                return;
            }
            else if (entity.CostCategoryId == (byte)BL.ORG.ORG_CostCategory.AverageCostExcludingSalesTax)
            {
                // AVG COST EXCLUDING
                if (discountPercentage < 0)
                {
                    discountPrice = inventory.UnitAverage - (line.UnitAverage * discountPercentage / 100);
                    sellPrice     = inventory.UnitAverage;
                }
                else
                {
                    discountPrice = (inventory.UnitAverage * (100 - discountPercentage)) / 100;
                    sellPrice     = inventory.UnitAverage;
                }
                //sellPrice = line.UnitAverage;
                return;
            }
            else if ((entity.CostCategoryId == (byte)BL.ORG.ORG_CostCategory.SellingPriceExcludingSalesTax) || (entity.CostCategoryId == (byte)BL.ORG.ORG_CostCategory.SellingPriceIncludingSalesTax))
            {
                // SELLING PRICE INCLUDING or SELLING PRICE EXCLUDING
                if (discountPercentage < 0)
                {
                    discountPrice = inventory.UnitPrice - (inventory.UnitPrice * discountPercentage / 100);
                    sellPrice     = inventory.UnitPrice;
                }
                else
                {
                    discountPrice = (inventory.UnitPrice * (100 - discountPercentage)) / 100;
                    sellPrice     = inventory.UnitPrice;
                }
                //sellPrice = line.UnitAverage;
                return;
            }
        }