/// <summary>
        /// Insert the report BO data into a file template of a report for suppliers.
        /// Вставка данных в шаблон.
        /// </summary>
        /// <param name="report">report BO to insert</param>
        /// <param name="service">file template of report for supplier</param>
        /// <returns>resulting file template with data</returns>
        private static WordService InsertIntoSupplierReport(Report report, WordService service)
        {
            switch (report.Id.ToLower())
            {
            case "altk":
                report.BrokerName = "ТОО Альта и К";
                break;

            case "kord":
                report.BrokerName = "ТОО Корунд-777";
                break;

            case "alta":
                report.BrokerName = "ТОО Альтаир-Нур";
                break;

            case "akal":
                report.BrokerName = "ТОО Ак Алтын Ко";
                break;

            default:
                report.BrokerName = "";
                break;
            }

            service.FindReplace("[firmBroker]", report.BrokerName);
            service.FindReplace("[number]", report.Number);

            var cName        = report.ClientName;
            var lotInfo      = DataBaseClient.GetLotByCode(report.Code);
            var supplierInfo = DataBaseClient.GetSupplierByBroker_Auction(cName.Substring(cName.Length - 4), lotInfo == null ? 0 : lotInfo.auctionid, lotInfo == null ? 0 : lotInfo.id);

            if (supplierInfo != null)
            {
                cName = supplierInfo[1];

                // Change statuses of supplier orders to lose
                ChangeStatusesToSO(lotInfo.auctionid, Convert.ToInt32(supplierInfo[4]));
            }

            service.FindReplace("[supplierName]", cName);
            service.FindReplace("[auctionDate]", report.DateTo);
            service.FindReplace("[dealRegDate]", report.Moment);
            service.FindReplace("[productName]", report.ProductName);

            decimal startPrice = DataBaseClient.GetPriceFromLot(report.Code);
            string  sPrice     = $"{startPrice:C}";

            sPrice = sPrice.Substring(0, sPrice.Length - 2);

            service.FindReplace("[startPrice]", startPrice == 0 ? "Введите стартовую цену" : sPrice + " тенге, с учетом НДС");
            service.FindReplace("[lotCode]", report.Code);
            service.FindReplace("[qty]", report.Qty);

            try {
                service.SetCell(1, 11, 2, lotInfo.auction.customer.company.name);
            } catch { }

            service.FindReplace("[lastPrice]", report.Price);
            service.FindReplace("[amountSum]", report.Amt);
            service.FindReplace("[clientBrokerCode]", report.ContrCode);
            service.FindReplace("[directorName]", report.Director);

            // Make record in final report table
            try {
                if (lotInfo != null && supplierInfo != null)
                {
                    var     finalReport = DataBaseClient.ReadFinalReport(lotInfo.auctionid, lotInfo.id);
                    decimal lastPrice   = Convert.ToDecimal(report.Amt.Substring(0, report.Amt.IndexOf(" т") - 2).Replace(" ", ""));

                    if (finalReport != null)
                    {
                        DataBaseClient.DeleteFinalReport(finalReport);
                    }

                    FinalReportEF finalReportItem = new FinalReportEF()
                    {
                        auctionId       = lotInfo.auctionid,
                        dealNumber      = report.Number,
                        supplierId      = Convert.ToInt32(supplierInfo[2]),
                        lotId           = lotInfo.id,
                        finalPriceOffer = lastPrice,
                        brokerId        = Convert.ToInt32(supplierInfo[3])
                    };

                    DataBaseClient.CreateFinalReport(finalReportItem);

                    // Change procuratory
                    try {
                        DataBaseClient.UpdateProcuratory(Convert.ToInt32(supplierInfo[2]), lotInfo.id, lastPrice);
                    } catch (Exception) { }

                    DataBaseClient.SetAuctionStatus(lotInfo.auctionid, 2);
                }
            } catch (Exception) { }

            return(service);
        }
        /// <summary>
        /// Insert the report BO data into a file template of a report for customers.
        /// Вставка данных в шаблон отчета для заказчиков.
        /// </summary>
        /// <param name="report">report BO to insert</param>
        /// <param name="service">file template of report for customer</param>
        /// <returns>resulting file template with data</returns>
        private static WordService InsertIntoClientReport(Report report, WordService service)
        {
            var lotInfo = DataBaseClient.GetLotByCode(report.Code);

            try {
                service.FindReplace("[orderNumber]", lotInfo == null ? "Номер аукциона" : lotInfo.auction.number);
                service.FindReplace("[dealNumber]", report.Number);

                try {
                    service.SetCell(1, 6, 2, lotInfo.auction.customer.company.name);
                    var customerCode = DataBaseClient.GetSupplierCodeByCompany(lotInfo.auction.customer.company.id);

                    if (customerCode != null)
                    {
                        service.SetCell(1, 7, 2, customerCode);
                    }
                } catch { }

                service.FindReplace("[auctionDate]", report.Moment.Substring(0, report.Moment.IndexOf(" ", StringComparison.Ordinal)));
                service.FindReplace("[dealRegDate]", report.Moment);
                service.FindReplace("[lotCode]", report.Code);
                service.FindReplace("[productName]", report.ProductName);
            } catch (Exception) { }

            string lotSum = lotInfo != null ? $"{lotInfo.sum:C}" : "0,00";

            lotSum = lotSum.Substring(0, lotSum.Length - 2);

            service.FindReplace("[startPrice]", lotInfo == null ? "Введите стартовую цену" : lotSum + " тенге, с учетом НДС");
            service.FindReplace("[amountSum]", report.Amt);

            var supplierInfo = DataBaseClient.GetSupplierByBroker_Auction(report.ContrCode, lotInfo == null ? 0 : lotInfo.auctionid, lotInfo == null ? 0 : lotInfo.id);

            service.FindReplace("[supplierCode]", supplierInfo == null ? "Код поставщика" : supplierInfo[0]);
            service.FindReplace("[supplierName]", supplierInfo == null ? "Наименование поставщика" : supplierInfo[1]);
            service.FindReplace("[brokerCode]", report.ContrCode);

            switch (report.ContrCode.ToLower())
            {
            case "altk":
                report.BrokerName = "ТОО Альта и К";
                break;

            case "kord":
                report.BrokerName = "ТОО Корунд-777";
                break;

            case "alta":
                report.BrokerName = "ТОО Альтаир Нур";
                break;

            case "akal":
                report.BrokerName = "ТОО Ак Алтын Ко";
                break;

            default:
                report.BrokerName = "";
                break;
            }

            service.FindReplace("[brokerName]", report.BrokerName);

            // Change auction status
            try {
                if (lotInfo != null)
                {
                    DataBaseClient.SetAuctionStatus(lotInfo.auctionid, 2);
                }
            } catch (Exception) { }

            return(service);
        }