Пример #1
0
        protected void Load(IObjectSpace os, crmContractDeal deal_sale, LineKey key, IDictionary <TrwBudgetKey, IList <TrwBudgetValue> > keys)
        {
            crmDealVersion deal_version = deal_sale.Current;

            foreach (crmStage stage in deal_version.StageStructure.Stages)
            {
                Load(os, deal_version, stage, key, keys);
            }
        }
Пример #2
0
        protected void Load(IObjectSpace os, crmDealVersion deal_version, crmStage stage, LineKey key, IDictionary <TrwBudgetKey, IList <TrwBudgetValue> > keys)
        {
            foreach (crmDeliveryUnit unit in stage.DeliveryPlan.DeliveryUnits)
            {
                foreach (crmDeliveryItem item in unit.DeliveryItems)
                {
//                    TrwBudgetPeriodValue period_value = TrwBudgetMaster.TrwPeriod.ValueGet(unit.DatePlane);
                    TrwBudgetValue budget_value = null;
                    TrwBudgetKey   budget_key   = keys.Keys.FirstOrDefault(
                        x => x.DealSale == key.Deal &&
                        x.Subject == key.Subject &&
                        x.Order == item.Order &&
                        x.Party == key.Party &&
                        x.ObligationValuta == item.Valuta &&
                        x.TrwContractSale == key.TrwContract &&
                        x.TrwOrderSale == key.TrwOrder &&
                        x.TrwSaleNomenclature == item.TrwSaleNomenclature
                        );
                    if (budget_key == null)
                    {
                        budget_key = os.CreateObject <TrwBudgetKey>();
                        BudgetMaster.BudgetKeys.Add(budget_key);
                        // budget_key.SubjectBudget = this;
                        // budget_key.BudgetBase = this;
                        budget_key.DealSale            = key.Deal;
                        budget_key.Party               = key.Party;
                        budget_key.Subject             = key.Subject;
                        budget_key.Order               = item.Order;
                        budget_key.ObligationValuta    = item.Valuta;
                        budget_key.TrwContractSale     = key.TrwContract;
                        budget_key.TrwOrderSale        = key.TrwOrder;
                        budget_key.TrwSaleNomenclature = item.TrwSaleNomenclature;
                        keys[budget_key]               = new List <TrwBudgetValue>();
                        foreach (TrwBudgetPeriodValue period_value in BudgetMaster.BudgetPeriod.PeriodValues)
                        {
                            budget_value = os.CreateObject <TrwBudgetValue>();
                            budget_key.TrwBudgetValues.Add(budget_value);
                            BudgetValues.Add(budget_value);
                            BudgetMaster.BudgetValues.Add(budget_value);
                            if (period_value.Month < 0 && period_value.Month < 13)
                            {
                                budget_value.Date = new DateTime(BudgetMaster.BudgetPeriod.Year, period_value.Month, 1);
                                budget_value.Date.AddMonths(1);
                                budget_value.Date.AddDays(-1);
                            }
                            else
                            {
                                if (period_value.Month == 0)
                                {
                                    budget_value.Date = new DateTime(BudgetMaster.BudgetPeriod.Year - 1, 12, 31);
                                }
                                else
                                {
                                    budget_value.Date = new DateTime(BudgetMaster.BudgetPeriod.Year + 1, 01, 01);
                                }
                            }
                            BudgetMaster.BudgetPeriod.ValueGet(budget_value.Date).BudgetValues.Add(budget_value);
                            if (BudgetMaster.BudgetPeriod.Valuta == budget_key.ObligationValuta)
                            {
                                budget_value.ObligationRate = 1;
                            }
                            else
                            {
                                budget_value.ObligationRate = BudgetMaster.BudgetPeriod.CurrencyExchanges.FirstOrDefault(x => x.Valuta == budget_key.ObligationValuta).Rate;
                            }
                            keys[budget_key].Add(budget_value);
                        }
                    }
                    budget_value = keys[budget_key].FirstOrDefault(
                        x => x.Date == unit.DatePlane &&
                        x.ObligationValuta == item.Valuta
                        );
                    if (budget_value == null)
                    {
                        budget_value = os.CreateObject <TrwBudgetValue>();
                        budget_key.TrwBudgetValues.Add(budget_value);
                        BudgetValues.Add(budget_value);
                        BudgetMaster.BudgetValues.Add(budget_value);
                        budget_value.Date = unit.DatePlane;
                        BudgetMaster.BudgetPeriod.ValueGet(budget_value.Date).BudgetValues.Add(budget_value);
                        keys[budget_key].Add(budget_value);
                    }
                    budget_value.SummCost += item.SummCost;
                    budget_value.SummVat  += item.SummNDS;
                    budget_value.SummAll   = budget_value.SummCost + budget_value.SummVat;
                }
            }
        }
        protected void FillDatabaseForAnalysis(Session ssn)
        {
            IObjectSpace objectSpace = new ObjectSpace((UnitOfWork)ssn);

            int  RecordCountGenerated = 10000; // Максимальное количество генерируемых записей в журнале регистрации crmCashFlowRegister
            Guid token = Guid.NewGuid();

            // Делаем три валюты
            IList <csValuta> valutaList = new List <csValuta>();

            csValuta valutaRUR = objectSpace.CreateObject <csValuta>();

            valutaRUR.Code      = "RUR";
            valutaRUR.NameShort = "Руб.";
            valutaRUR.NameFull  = "Рубль";
            valutaList.Add(valutaRUR);

            csValuta valutaUSD = objectSpace.CreateObject <csValuta>();

            valutaUSD.Code      = "USD";
            valutaUSD.NameShort = "bak";
            valutaUSD.NameFull  = "Dollar";
            valutaList.Add(valutaUSD);

            csValuta valutaEUR = objectSpace.CreateObject <csValuta>();

            valutaEUR.Code      = "EUR";
            valutaEUR.NameShort = "euro";
            valutaEUR.NameFull  = "Euro";
            valutaList.Add(valutaEUR);

            objectSpace.CommitChanges();


            //// Создаём maxContractDocumentCount документов
            //int maxContractDocumentCount = 300;
            //IList<fmSubject> ContractDocumentList = new List<fmSubject>();

            //for (int i = 0; i < maxContractDocumentCount; i++) {
            //    fmSubject сontractDocument = objectSpace.CreateObject<fmSubject>();
            //    сontractDocument.Code = "S" + i.ToString();
            //    сontractDocument.Name = "Subj" + i.ToString();
            //    сontractDocument.DateBegin = DateTime.Now;
            //    сontractDocument.DateEnd = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 30));
            //    ContractDocumentList.Add(subject);
            //}

            //objectSpace.CommitChanges();


            // Создаём maxSubjectCount тем
            int maxSubjectCount = 120;
            IList <fmCSubjectExt> subjectList = new List <fmCSubjectExt>();

            for (int i = 0; i < maxSubjectCount; i++)
            {
                fmCSubjectExt subject = objectSpace.CreateObject <fmCSubjectExt>();
                subject.Code      = "S" + i.ToString();
                subject.Name      = "Subj" + i.ToString();
                subject.DateBegin = DateTime.Now;
                subject.DateEnd   = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 30));
                subjectList.Add(subject);
            }

            objectSpace.CommitChanges();

            // Создаём maxCostItemCount
            int maxCostItemCount            = 10;
            IList <fmCostItem> costItemList = new List <fmCostItem>();

            for (int i = 0; i < maxCostItemCount; i++)
            {
                fmCostItem costItem = objectSpace.CreateObject <fmCostItem>();
                costItem.Code = "CI" + i.ToString();
                costItem.Name = "CostItem" + i.ToString();
                costItemList.Add(costItem);
            }

            objectSpace.CommitChanges();


            // Заготавливаем maxCostModelCount
            int maxCostModelCount = 5;
            IList <crmCostModel> CostModelList = new List <crmCostModel>();

            for (int i = 0; i < maxCostModelCount; i++)
            {
                crmCostModel costModel = objectSpace.CreateObject <crmCostModel>();

                costModel.Code        = "CM: " + i.ToString();
                costModel.Description = "CostModel: " + i.ToString();
                costModel.Name        = "CostModel " + i.ToString();

                CostModelList.Add(costModel);

                //objectSpace.CommitChanges();
            }

            objectSpace.CommitChanges();

            /*
             * // Заготавливаем maxContragentPartyRuCount штук контрагентов
             * int maxContragentPartyRuCount = 120;
             * IList<crmPartyRu> ContragentPartyRuList = new List<crmPartyRu>();
             *
             * for (int i = 0; i < maxContragentPartyRuCount; i++) {
             *  crmPartyRu partyRu = objectSpace.CreateObject<crmPartyRu>();
             *
             *  partyRu.Code = "cF";
             *  partyRu.Description = "ContragentParty " + i.ToString();
             *
             *  //crmPhysicalPerson person = objectSpace.CreateObject<crmPhysicalPerson>();
             *  //person.INN = "CP INN" + i;
             *  //person.FirstName = "Гадя " + i;
             *  //person.MiddleName = "Петрович " + i;
             *  //person.MiddleName = "Хренова " + i;
             *
             *  crmCPerson person = objectSpace.CreateObject<crmCPerson>();
             *  person.INN = "CP INN" + i;
             *  //person.FirstName = "Гадя " + i;
             *  //person.MiddleName = "Петрович " + i;
             *  //person.MiddleName = "Хренова " + i;
             *
             *  partyRu.Person = person;
             *  person.Partys.Add(partyRu);
             *
             *  ContragentPartyRuList.Add(partyRu);
             *
             *  //objectSpace.CommitChanges();
             * }
             *
             * objectSpace.CommitChanges();
             */


            // Заготавливаем maxContragentcLegalPersonCount штук контрагентов
            int maxCLegalPersonCount = 120;
            IList <crmCLegalPerson> CLegalPersonList = new List <crmCLegalPerson>();

            for (int i = 0; i < maxCLegalPersonCount; i++)
            {
                crmCLegalPerson cLegalPerson = objectSpace.CreateObject <crmCLegalPerson>();
                cLegalPerson.Name        = "ИнтекоАГ" + i;
                cLegalPerson.NameFull    = "ИнтекоАГ" + i;
                cLegalPerson.INN         = "ИНН 1111111111";
                cLegalPerson.Code        = "LP" + i;
                cLegalPerson.Description = "LegalPerson Description" + i;
                cLegalPerson.KPP         = "КПП 222222222";
                cLegalPerson.RegCode     = "RC";
                //cLegalPerson.Person.Address = address;
                //cLegalPerson.Party.AddressFact = address;
                //cLegalPerson.Party.AddressPost = address;
                cLegalPerson.Party.Person = cLegalPerson.Person;

                CLegalPersonList.Add(cLegalPerson);
            }

            objectSpace.CommitChanges();

            // Заготавливаем maxContractPartyCount штук участников договоров
            int maxContractPartyCount = 50;
            IList <crmContractParty> ContractPartyList = new List <crmContractParty>();

            for (int i = 0; i < maxContractPartyCount; i++)
            {
                crmContractParty contractParty = objectSpace.CreateObject <crmContractParty>();

                contractParty.INN       = "INN: " + i.ToString();
                contractParty.KPP       = "KPP: " + i.ToString();
                contractParty.Name      = "ContractParty " + i.ToString();
                contractParty.Party     = CLegalPersonList[GetRandomIntegerFromInterval(1, CLegalPersonList.Count) - 1].Party;
                contractParty.RegNumber = "RegNumber " + i.ToString();

                ContractPartyList.Add(contractParty);

                //objectSpace.CommitChanges();
            }

            objectSpace.CommitChanges();

            // SHU 2011-12-26 Order не вводится, т.к. имеет срабатывает правило Validation Required для какого-то поля
            // Заготавливаем maxOrderCount штук заказов
            int maxOrderCount             = 30;
            IList <fmCOrderExt> OrderList = new List <fmCOrderExt>();

            for (int i = 0; i < maxOrderCount; i++)
            {
                fmCOrderExt order = objectSpace.CreateObject <fmCOrderExt>();

                //order.Code = "Ord: " + i.ToString();
                order.Description = "Order: " + i.ToString();
                //order.Name = "Order " + i.ToString();
                //order.DateBegin = DateTime.Now;
                //order.DateEnd = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 30));
                order.Subject = subjectList[GetRandomIntegerFromInterval(1, subjectList.Count) - 1];

                OrderList.Add(order);

                //objectSpace.CommitChanges();
            }

            objectSpace.CommitChanges();

            // Заготавливаем maxNDSRateCount штук формул расчёта НДС
            int maxNDSRateCount           = 1;
            IList <csNDSRate> NDSRateList = new List <csNDSRate>();

            for (int i = 0; i < maxNDSRateCount; i++)
            {
                csNDSRate ndsRate = objectSpace.CreateObject <csNDSRate>();

                ndsRate.Code        = "20/120"; // + i.ToString();
                ndsRate.Numerator   = 20;       // + i.ToString();
                ndsRate.Denominator = 120;      // + i.ToString();
                ndsRate.Name        = "20/120";
                //ndsRate.RateOfNDS = 120/100;

                NDSRateList.Add(ndsRate);

                //objectSpace.CommitChanges();
            }

            objectSpace.CommitChanges();


            // Создаём maxStageCount этапов
            int maxStageCount          = 20;
            IList <crmStage> stageList = new List <crmStage>();

            for (int i = 0; i < maxStageCount; i++)
            {
                crmDeliveryPlan deliveryPlan = objectSpace.CreateObject <crmDeliveryPlan>();
                deliveryPlan.DateBegin      = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 5));
                deliveryPlan.DateEnd        = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 15));
                deliveryPlan.CostItem       = costItemList[GetRandomIntegerFromInterval(1, costItemList.Count) - 1];
                deliveryPlan.CostModel      = CostModelList[GetRandomIntegerFromInterval(1, CostModelList.Count) - 1];
                deliveryPlan.DeliveryMethod = DeliveryMethod.UNIT_AT_THE_END;
                deliveryPlan.NDSRate        = NDSRateList[GetRandomIntegerFromInterval(1, NDSRateList.Count) - 1];
                deliveryPlan.Valuta         = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];

                crmPaymentPlan paymentPlan = objectSpace.CreateObject <crmPaymentPlan>();
                paymentPlan.DateBegin = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 5));
                paymentPlan.DateEnd   = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 15));
                paymentPlan.CostItem  = costItemList[GetRandomIntegerFromInterval(1, costItemList.Count) - 1];
                paymentPlan.CostModel = CostModelList[GetRandomIntegerFromInterval(1, CostModelList.Count) - 1];
                paymentPlan.NDSRate   = NDSRateList[GetRandomIntegerFromInterval(1, NDSRateList.Count) - 1];
                paymentPlan.Valuta    = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];

                crmStage stage = objectSpace.CreateObject <crmStage>();
                deliveryPlan.Stage = stage;
                stage.Code         = "S" + i.ToString();
                //stage.DeliveryDate = null; // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 20));
                ////stage.CurrentCost = "Stg" + i.ToString();
                ////stage.CurrentPayment = "Stg" + i.ToString();
                //stage.Customer = null; // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                ////stage.DeliveryItem = "Stg" + i.ToString();
                ////stage.DeliveryItems = "Stg" + i.ToString();
                // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! stage.DeliveryMethod = DeliveryMethod.UNIT_AT_THE_END;
                ////stage.DeliveryUnits = "Stg" + i.ToString();
                stage.DescriptionLong  = "Stage" + i.ToString();
                stage.DescriptionShort = "Stg" + i.ToString();
                //stage.FullCode = "Stg" + i.ToString();
                // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! stage.Order = OrderList[GetRandomIntegerFromInterval(1, OrderList.Count) - 1];
                // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! stage.PaymentMethod = PaymentMethod.ADVANCE;
                stage.DeliveryPlan = deliveryPlan; // ДОРАБОТАТЬ!!! "Stg" + i.ToString();
                stage.PaymentPlan  = paymentPlan;  // ДОРАБОТАТЬ!!! "Stg" + i.ToString();
                stage.CostItem     = costItemList[GetRandomIntegerFromInterval(1, costItemList.Count) - 1];
                stage.CostModel    = CostModelList[GetRandomIntegerFromInterval(1, CostModelList.Count) - 1];

                //stage.PaymentUnits = "Stg" + i.ToString();
                // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! stage.PaymentValuta = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];
                //stage.Settlement = "Stg" + i.ToString();
                stage.SettlementDate = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 50));
                stage.StageStructure = null;  // ДОРАБОТАТЬ!!! "Stg" + i.ToString();
                //stage.StageMain = "Stg" + i.ToString();
                // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! stage.StageType = StageType.FINANCE;
                //stage.Supplier = null; // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! stage.Valuta = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];

                stage.DateFinish = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 40));
                // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! stage.DateBegin = DateTime.Now;
                // ОТВАЛИВАЕТСЯ, ПОКА НЕТ ВРЕМЕНИ РАЗБИРАТЬСЯ !!! stage.DateEnd = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 30));

                stageList.Add(stage);
            }

            objectSpace.CommitChanges();

            // Создаём maxContractCategoryCount Категорий контрактов
            int maxContractCategoryCount = 10;
            IList <crmContractCategory> сontractCategoryList = new List <crmContractCategory>();

            for (int i = 0; i < maxContractCategoryCount; i++)
            {
                crmContractCategory contractCategory = objectSpace.CreateObject <crmContractCategory>();
                contractCategory.Code = "CC" + i.ToString();
                contractCategory.Name = "ContractCategory " + i.ToString();
                сontractCategoryList.Add(contractCategory);
            }

            objectSpace.CommitChanges();

            // Создаём maxDepartmentCount подразделений
            int maxDepartmentCount = 20;
            IList <hrmDepartment> departmentList = new List <hrmDepartment>();

            for (int i = 0; i < maxDepartmentCount; i++)
            {
                hrmDepartment department = objectSpace.CreateObject <hrmDepartment>();
                department.Code = "Dep" + i.ToString();
                department.Name = "Department " + i.ToString();
                departmentList.Add(department);
            }

            objectSpace.CommitChanges();

            // Создаём maxStaffCount сотрудников
            int maxStaffCount = 30;
            IList <hrmStaff>          staffList          = new List <hrmStaff>();
            IList <crmPhysicalPerson> physicalPersonList = new List <crmPhysicalPerson>();

            for (int i = 0; i < maxStaffCount; i++)
            {
                crmPhysicalPerson physicalPerson = objectSpace.CreateObject <crmPhysicalPerson>();
                physicalPerson.FirstName  = "Иван " + i.ToString();
                physicalPerson.MiddleName = "Иванович " + i.ToString();
                physicalPerson.LastName   = "Иванов " + i.ToString();
                physicalPerson.INN        = "ИНН " + i.ToString();

                hrmStaff staff = objectSpace.CreateObject <hrmStaff>();
                staff.PhysicalPerson = physicalPerson;
                staff.Department     = departmentList[GetRandomIntegerFromInterval(1, departmentList.Count) - 1];
                staffList.Add(staff);
            }

            // Создаём maxDocumentCategoryCount видов категорий документов
            int maxDocumentCategoryCount = 10;
            IList <crmContractDocumentType> contractDocumentTypeList = new List <crmContractDocumentType>();

            for (int i = 0; i < maxDocumentCategoryCount; i++)
            {
                crmContractDocumentType contractDocumentType = objectSpace.CreateObject <crmContractDocumentType>();
                contractDocumentType.Code = "CD " + i.ToString();
                contractDocumentType.Name = "Contract Document Type " + i.ToString();
                contractDocumentTypeList.Add(contractDocumentType);
            }

            objectSpace.CommitChanges();

            // Создаём maxPaymentItemCount
            int maxPaymentItemCount = 10;
            IList <crmPaymentMoney> paymentItemList = new List <crmPaymentMoney>();

            for (int i = 0; i < maxPaymentItemCount; i++)
            {
                crmPaymentMoney paymentItem = objectSpace.CreateObject <crmPaymentMoney>();
                paymentItem.AccountSumma  = GetRandomIntegerFromInterval(1, 100);
                paymentItem.AccountValuta = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];
                //paymentItem.CostItem;
                //paymentItem.CostModel;
                //paymentItem.CurrentCost;
                paymentItem.Date        = DateTime.Now;
                paymentItem.Description = "PaymentItem " + i.ToString();
                paymentItemList.Add(paymentItem);
            }

            objectSpace.CommitChanges();


            // Создаём maxObligationUnitCount обязательств
            int maxObligationUnitCount = 20;
            IList <crmObligationUnit> obligationUnitList = new List <crmObligationUnit>();

            for (int i = 0; i < maxObligationUnitCount; i++)
            {
                crmPaymentUnit obligationUnit = objectSpace.CreateObject <crmPaymentUnit>();
                obligationUnit.Code      = "PU" + i.ToString();
                obligationUnit.Name      = "PaymentUnit" + i.ToString();
                obligationUnit.CostItem  = costItemList[GetRandomIntegerFromInterval(1, costItemList.Count) - 1];
                obligationUnit.CostModel = CostModelList[GetRandomIntegerFromInterval(1, CostModelList.Count) - 1];
                ////obligationUnit.Creditor = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                //obligationUnit.CurrentCost = "Subj" + i.ToString();
                ////obligationUnit.Debitor = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                obligationUnit.NDSRate  = NDSRateList[GetRandomIntegerFromInterval(1, NDSRateList.Count) - 1];
                obligationUnit.Order    = OrderList[GetRandomIntegerFromInterval(1, OrderList.Count) - 1];
                obligationUnit.Receiver = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                obligationUnit.Sender   = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                ////obligationUnit.Stage = stageList[GetRandomIntegerFromInterval(1, stageList.Count) - 1];
                ////obligationUnit.SummCost = GetRandomIntegerFromInterval(1, 100);
                ////obligationUnit.SummNDS = GetRandomIntegerFromInterval(1, 100);
                obligationUnit.SummFull  = GetRandomIntegerFromInterval(1, 100);
                obligationUnit.Valuta    = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];
                obligationUnit.DatePlane = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 40));
                obligationUnit.DateBegin = DateTime.Now;
                obligationUnit.DateEnd   = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 30));

                obligationUnitList.Add(obligationUnit);
            }

            objectSpace.CommitChanges();

            //const int maxObligationUnitCount = 30;
            //IList<crmObligationUnit> obligationUnitList = new List<crmObligationUnit>();

            for (int i = 0; i < maxObligationUnitCount; i++)
            {
                crmDeliveryUnit obligationUnit = objectSpace.CreateObject <crmDeliveryUnit>();
                obligationUnit.Code      = "DU" + i.ToString();
                obligationUnit.Name      = "DeliveryUnit" + i.ToString();
                obligationUnit.CostItem  = costItemList[GetRandomIntegerFromInterval(1, costItemList.Count) - 1];
                obligationUnit.CostModel = CostModelList[GetRandomIntegerFromInterval(1, CostModelList.Count) - 1];
                ////obligationUnit.Creditor = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                //obligationUnit.CurrentCost = "Subj" + i.ToString();
                ////obligationUnit.Debitor = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                obligationUnit.NDSRate = NDSRateList[GetRandomIntegerFromInterval(1, NDSRateList.Count) - 1];
                if (OrderList.Count > 0)
                {
                    obligationUnit.Order = OrderList[GetRandomIntegerFromInterval(1, OrderList.Count) - 1];
                }
                obligationUnit.Receiver = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                obligationUnit.Sender   = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1];
                ////obligationUnit.Stage = stageList[GetRandomIntegerFromInterval(1, stageList.Count) - 1];
                ////obligationUnit.SummCost = GetRandomIntegerFromInterval(1, 100);
                ////obligationUnit.SummNDS = GetRandomIntegerFromInterval(1, 100);
                obligationUnit.SummFull  = GetRandomIntegerFromInterval(1, 100);
                obligationUnit.Valuta    = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];
                obligationUnit.DatePlane = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 40));
                obligationUnit.DateBegin = DateTime.Now;
                obligationUnit.DateEnd   = DateTime.Now.AddDays(GetRandomIntegerFromInterval(1, 30));

                obligationUnitList.Add(obligationUnit);
            }

            objectSpace.CommitChanges();

            /*
             * // Заготавливаем maxPrimaryPartyRuCount штук первичных участников договоров
             * int maxPrimaryPartyRuCount = 7;
             * IList<crmPartyRu> primaryPartyRuList = new List<crmPartyRu>();
             *
             * for (int i = 0; i < maxPrimaryPartyRuCount; i++) {
             *  crmPartyRu partyRu = objectSpace.CreateObject<crmPartyRu>();
             *
             *  partyRu.Code = "pF";
             *  partyRu.Description = "PrimaryParty " + i.ToString();
             *
             *  //crmPhysicalPerson person = objectSpace.CreateObject<crmPhysicalPerson>();
             *  //person.INN = "PP INN" + i;
             *  //person.FirstName = "Ганс " + i;
             *  //person.MiddleName = "Христиан " + i;
             *  //person.MiddleName = "Андерсен " + i;
             *
             *  crmCPerson person = objectSpace.CreateObject<crmCPerson>();
             *  person.INN = "PP INN" + i;
             *  //person.FirstName = "Ганс " + i;
             *  //person.MiddleName = "Христиан " + i;
             *  //person.MiddleName = "Андерсен " + i;
             *
             *  partyRu.Person = person;
             *  person.Partys.Add(partyRu);
             *
             *  primaryPartyRuList.Add(partyRu);
             * }
             *
             * objectSpace.CommitChanges();
             */


            // Заготавливаем maxContragentcLegalPersonCount штук контрагентов
            int maxPrimaryCLegalPersonCount = 120;
            IList <crmCLegalPerson> PrimaryCLegalPersonList = new List <crmCLegalPerson>();

            for (int i = 0; i < maxPrimaryCLegalPersonCount; i++)
            {
                crmCLegalPerson cLegalPerson = objectSpace.CreateObject <crmCLegalPerson>();
                cLegalPerson.Name        = "Кремль" + i;
                cLegalPerson.NameFull    = "Кремль" + i;
                cLegalPerson.INN         = "ИНН ААААААААА";
                cLegalPerson.Code        = "LPK" + i;
                cLegalPerson.Description = "LegalPerson Кремль Description" + i;
                cLegalPerson.KPP         = "КПП ББББББББ";
                cLegalPerson.RegCode     = "RCK";
                //cLegalPerson.Person.Address = address;
                //cLegalPerson.Party.AddressFact = address;
                //cLegalPerson.Party.AddressPost = address;
                cLegalPerson.Party.Person = cLegalPerson.Person;

                PrimaryCLegalPersonList.Add(cLegalPerson);
            }

            objectSpace.CommitChanges();


            // Создаём maxContractCount контрактов
            int maxContractCount             = 300;
            IList <crmContract> contractList = new List <crmContract>();

            for (int i = 0; i < maxContractCount; i++)
            {
                crmContractDocument contractDocument = objectSpace.CreateObject <crmContractDocument>();
                contractDocument.Date             = DateTime.Now;
                contractDocument.DocumentCategory = contractDocumentTypeList[GetRandomIntegerFromInterval(1, contractDocumentTypeList.Count) - 1];
                contractDocument.Number           = "Doc № " + i.ToString();


                crmContractDeal contractDeal = objectSpace.CreateObject <crmContractDeal>();
                contractDeal.Category          = сontractCategoryList[GetRandomIntegerFromInterval(1, сontractCategoryList.Count) - 1];
                contractDeal.ContractKind      = ContractKind.CONTRACT;
                contractDeal.CuratorDepartment = departmentList[GetRandomIntegerFromInterval(1, departmentList.Count) - 1];
                //contractDeal.Customer = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1].Party;
                contractDeal.DateRegistration = DateTime.Now;
                //contractDeal.Supplier = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1].Party;
                contractDeal.UserRegistrator       = staffList[GetRandomIntegerFromInterval(1, staffList.Count) - 1];
                contractDeal.DepartmentRegistrator = contractDeal.UserRegistrator.Department;

                //contractDeal.Customer = ContragentPartyRuList[GetRandomIntegerFromInterval(1, ContragentPartyRuList.Count) - 1];
                //contractDeal.DealVersions
                //contractDeal.Project = ;
                //contractDeal.State
                //contractDeal.Supplier = ContragentPartyRuList[GetRandomIntegerFromInterval(1, ContragentPartyRuList.Count) - 1];


                //---
                crmDealVersion dealVersion = objectSpace.CreateObject <crmDealVersion>();
                //dealVersion.Category = сontractCategoryList[GetRandomIntegerFromInterval(1, сontractCategoryList.Count) - 1];
                //dealVersion.ContractDeal = contractDeal;
                //dealVersion.ContractDocument = contractDocument;
                //dealVersion.ContractDocuments.Add(contractDocument);
                //dealVersion.Customer = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1].Party;
                dealVersion.CostItem = costItemList[GetRandomIntegerFromInterval(1, costItemList.Count) - 1];
                //dealVersion.Supplier = ContractPartyList[GetRandomIntegerFromInterval(1, ContractPartyList.Count) - 1].Party;
                dealVersion.CostModel = CostModelList[GetRandomIntegerFromInterval(1, CostModelList.Count) - 1];
                //dealVersion.Curator = contractDeal.CuratorDepartment;
                dealVersion.DateBegin  = DateTime.Now;
                dealVersion.DateEnd    = DateTime.Now.AddDays(10);
                dealVersion.DateFinish = DateTime.Now.AddDays(20);
                dealVersion.DealCode   = "DC " + i.ToString();
                //dealVersion.DealDocument = contractDocument;
                //dealVersion.DealNomenclatures.Add(
                if (dealVersion != null)
                {
                    dealVersion.DescriptionLong  = "Полное описание для " + dealVersion.DealCode;
                    dealVersion.DescriptionShort = "Краткое описание для " + dealVersion.DealCode;
                }
                dealVersion.NDSRate = NDSRateList[GetRandomIntegerFromInterval(1, NDSRateList.Count) - 1];
                if (OrderList.Count > 0)
                {
                    dealVersion.Order = OrderList[GetRandomIntegerFromInterval(1, OrderList.Count) - 1];
                }
                dealVersion.PaymentValuta = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];
                //dealVersion.Registrator = contractDeal.DepartmentRegistrator;
                dealVersion.Valuta = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];
                //dealVersion.StageStructure
                //---


                contractDeal.Current = dealVersion;
                contractDeal.DealVersions.Add(dealVersion);

                crmContract contract = objectSpace.CreateObject <crmContract>();
                contract.ContractCategory = сontractCategoryList[GetRandomIntegerFromInterval(1, сontractCategoryList.Count) - 1];

                contractDeal.Contract         = contract;
                contractDeal.ContractDocument = contractDocument;
                contractDeal.ContractDocuments.Add(contractDocument);
                contractDocument.Contract = contract;
                contract.ContractDeals.Add(contractDeal);
                contract.ContractDocuments.Add(contractDocument);

                //contract.ContractDocument = DateTime.Now;
                //contract.Delo = "Delo " + i.ToString();
                contract.Description           = "Описание документа " + i.ToString();
                contract.UserRegistrator       = contractDeal.UserRegistrator;
                contract.DepartmentRegistrator = contract.UserRegistrator.Department;
                contractList.Add(contract);

                //this.ObjectSpace.CommitChanges();
                if ((i % 100) == 0)
                {
                    objectSpace.CommitChanges();
                }
            }

            objectSpace.CommitChanges();



            // Создаём записи регистра crmDebtorCreditorDebtRegister
            for (int i = 0; i < RecordCountGenerated; i++)
            {
                //try {
                // crmDebtorCreditorDebtRegister
                crmDebtorCreditorDebtRegister debtorCreditorDebtRegister = objectSpace.CreateObject <crmDebtorCreditorDebtRegister>();

                debtorCreditorDebtRegister.Token = token;

                debtorCreditorDebtRegister.ContragentParty = CLegalPersonList[GetRandomIntegerFromInterval(1, CLegalPersonList.Count) - 1].Party;
                debtorCreditorDebtRegister.PrimaryParty    = PrimaryCLegalPersonList[GetRandomIntegerFromInterval(1, PrimaryCLegalPersonList.Count) - 1].Party;

                debtorCreditorDebtRegister.Contract     = contractList[GetRandomIntegerFromInterval(1, contractList.Count) - 1];
                debtorCreditorDebtRegister.ContractDeal = debtorCreditorDebtRegister.Contract.ContractDeals[0];

                debtorCreditorDebtRegister.CreditValuta    = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];
                debtorCreditorDebtRegister.CreditCost      = GetRandomIntegerFromInterval(1, 100);
                debtorCreditorDebtRegister.CreditCostInRUR = GetRandomIntegerFromInterval(1, 100);

                debtorCreditorDebtRegister.DebitValuta    = debtorCreditorDebtRegister.CreditValuta;
                debtorCreditorDebtRegister.DebitCost      = GetRandomIntegerFromInterval(1, 100);
                debtorCreditorDebtRegister.DebitCostInRUR = GetRandomIntegerFromInterval(1, 100);

                debtorCreditorDebtRegister.CostItem = costItemList[GetRandomIntegerFromInterval(1, costItemList.Count) - 1];
                if (OrderList.Count > 0)
                {
                    debtorCreditorDebtRegister.fmOrder = OrderList[GetRandomIntegerFromInterval(1, OrderList.Count) - 1];
                }
                debtorCreditorDebtRegister.ObligationUnit         = obligationUnitList[GetRandomIntegerFromInterval(1, obligationUnitList.Count) - 1];
                debtorCreditorDebtRegister.ObligationUnitDateTime = DateTime.Now;
                debtorCreditorDebtRegister.PlaneFact = ((i % 2) == 0) ? PlaneFact.PLAN : PlaneFact.FACT;
                debtorCreditorDebtRegister.Stage     = stageList[GetRandomIntegerFromInterval(1, stageList.Count) - 1];
                //debtorCreditorDebtRegister.StageTech = ;
                if (subjectList.Count > 0)
                {
                    debtorCreditorDebtRegister.Subject = subjectList[GetRandomIntegerFromInterval(1, subjectList.Count) - 1];
                }

                //cashFlowRegister.Save();
                //objectSpace.CommitChanges();
                //} catch {
                //}
                if ((i % 1000) == 0)
                {
                    objectSpace.CommitChanges();
                }
            }

            objectSpace.CommitChanges();


            // Создаём записи регистра crmCashFlowRegister
            for (int i = 0; i < RecordCountGenerated; i++)
            {
                //try {
                // crmCashFlowRegister
                crmCashFlowRegister cashFlowRegister = objectSpace.CreateObject <crmCashFlowRegister>();

                cashFlowRegister.Token = token;

                cashFlowRegister.ContragentParty = CLegalPersonList[GetRandomIntegerFromInterval(1, CLegalPersonList.Count) - 1].Party;
                cashFlowRegister.PrimaryParty    = PrimaryCLegalPersonList[GetRandomIntegerFromInterval(1, PrimaryCLegalPersonList.Count) - 1].Party;

                cashFlowRegister.Contract     = contractList[GetRandomIntegerFromInterval(1, contractList.Count) - 1];
                cashFlowRegister.ContractDeal = cashFlowRegister.Contract.ContractDeals[0];       //cashFlowRegister.Contract.ContractDeals[0];
                cashFlowRegister.Cost         = GetRandomIntegerFromInterval(1, 100);
                //cashFlowRegister.CostInRUR = GetRandomIntegerFromInterval(1, 100);
                cashFlowRegister.SumIn    = GetRandomIntegerFromInterval(1, 100);
                cashFlowRegister.CostItem = costItemList[GetRandomIntegerFromInterval(1, costItemList.Count) - 1];
                if (OrderList.Count > 0)
                {
                    cashFlowRegister.fmOrder = OrderList[GetRandomIntegerFromInterval(1, OrderList.Count) - 1];
                }
                if (obligationUnitList.Count > 0)
                {
                    cashFlowRegister.ObligationUnit = obligationUnitList[GetRandomIntegerFromInterval(1, obligationUnitList.Count) - 1];
                }
                cashFlowRegister.ObligationUnitDateTime = DateTime.Now;
                cashFlowRegister.PaymentCost            = GetRandomIntegerFromInterval(1, 100);
                cashFlowRegister.PaymentItem            = paymentItemList[GetRandomIntegerFromInterval(1, paymentItemList.Count) - 1];
                cashFlowRegister.PaymentValuta          = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];
                //cashFlowRegister.PlaneFact = ((i % 2) == 0) ? PlaneFact.PLAN : PlaneFact.FACT;
                cashFlowRegister.Section = CashFlowRegisterSection.CONTRACT_PLAN;       // Исправить на нормальное назначение
                //cashFlowRegister.Stage = stageList[GetRandomIntegerFromInterval(1, stageList.Count) - 1];
                //cashFlowRegister.StageTech = ;
                if (subjectList.Count > 0)
                {
                    cashFlowRegister.Subject = subjectList[GetRandomIntegerFromInterval(1, subjectList.Count) - 1];
                }
                cashFlowRegister.Valuta = valutaList[GetRandomIntegerFromInterval(1, valutaList.Count) - 1];

                //cashFlowRegister.FinancialDeal


                //cashFlowRegister.Save();
                //objectSpace.CommitChanges();
                //} catch {
                //}
                if ((i % 1000) == 0)
                {
                    objectSpace.CommitChanges();
                }
            }

            objectSpace.CommitChanges();
        }