using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Text.RegularExpressions;
using Comindware.Data.Entity;
using Comindware.TeamNetwork.Api.Data.UserCommands;
using System.IO;
using System.Data;

class Script
{
    public static UserCommandResult Main(UserCommandContext userCommandContext, Comindware.Entities entities)
    {
        var CurrentObjectid = userCommandContext.ObjectIds[0];
        var CurrentObjectData = Api.TeamNetwork.ObjectService.Get(CurrentObjectid);
        var ObrazecId = CurrentObjectData["op.114"].ToString();
        var ObrazecData = Api.TeamNetwork.ObjectService.Get(ObrazecId);
        var ObrazecCollectionArray = ObrazecData["op.126"] as object[];
        var Nomerzayavki12Id = ObrazecData["op.123"].ToString();
        var Nomerzayavki12Data = Api.TeamNetwork.ObjectService.Get(Nomerzayavki12Id);

        var stringOutputList = new List<Obrazetsispytanie>();

       //коллекция
        foreach (var collectionElement in ObrazecCollectionArray)
        {
            var collectionElementId = collectionElement.ToString();
            var collectionElementData = Api.TeamNetwork.ObjectService.Get(collectionElementId);
            var EquipmentId = collectionElementData["op.153"].ToString();
            var EquipmentData = Api.TeamNetwork.ObjectService.Get(EquipmentId);
            var NaimenovanieId = collectionElementData["op.186"].ToString();
            var NaimenovanieData = Api.TeamNetwork.ObjectService.Get(NaimenovanieId);

            var temp = new Obrazetsispytanie
            {
                Naimenovaniepokazatelya3 = NaimenovanieData["op.187"].ToString(),
                Fakticheskoeznachenie = collectionElementData["op.58"].ToString(),
                Oborudovanie1 = EquipmentData["op.149"].ToString(),
            };

            stringOutputList.Add(temp);
        }


        var NaimenovanieZakazchikaId = Nomerzayavki12Data["op.28"].ToString();
        var NaimenovanieZakazchikaData = Api.TeamNetwork.ObjectService.Get(NaimenovanieZakazchikaId);
        var Vidsoprovoddokumenta1Id = Nomerzayavki12Data["op.145"].ToString();
        var Vidsoprovoddokumenta1Data = Api.TeamNetwork.ObjectService.Get(Vidsoprovoddokumenta1Id);
        var OtborproizvedenvsootvetstviisId = Nomerzayavki12Data["op.48"].ToString();
        var OtborproizvedenvsootvetstviisData = Api.TeamNetwork.ObjectService.Get(OtborproizvedenvsootvetstviisId);

        var Nomerzayavki12ToAdd = new Nomerzayavki12
        {
            name = NaimenovanieZakazchikaData["op.65"].ToString(),
            Otborproizvedenvsootvetstviis = OtborproizvedenvsootvetstviisData["op.110"].ToString(),
            Usloviyatransportirovki = Nomerzayavki12Data["op.50"].ToString(),
            Vidsoprovoddokumenta1 = Vidsoprovoddokumenta1Data["op.144"].ToString(),
            soprovoditelnyydokumentnomer = Nomerzayavki12Data["op.46"].ToString(),
            Soprovoditelnyydokumentdata = Nomerzayavki12Data["op.47"].ToString(),
        };


        var ObrazecToAdd = new Obrazec
        {
            Nomerobraztsa = ObrazecData["op.176"].ToString(),
            Naimenovanieobraztsa = ObrazecData["op.39"].ToString(),
            Dataotbora = ObrazecData["op.45"].ToString(),
            Nomerzayavki12Positions = Nomerzayavki12ToAdd,
            ObrazetsispytaniePositions = stringOutputList,
        };

        var OtvetstvennyyId = CurrentObjectData["op.79"].ToString();
        var OtvetstvennyyData = Api.TeamNetwork.ObjectService.Get(OtvetstvennyyId);

        var dataToExport = new Nomer
        {
            Nomerprotokola = CurrentObjectData["op.175"].ToString(),
            Dataprotokola = CurrentObjectData["op.76"].ToString(),
            Datanachalaprovedeniyaissledovaniy = CurrentObjectData["op.77"].ToString(),
            Dataokonchaniyaprovedeniyaissledovaniy = CurrentObjectData["op.78"].ToString(),
            Otvetstvennyy = OtvetstvennyyData["op.192"].ToString(),
            ObrazecPositions = ObrazecToAdd
        };

        var res=Api.TeamNetwork.ObjectAppExportService.ExecuteWordExportTemplate(userCommandContext.DocumentTemplateId,dataToExport,true);

        var result = new UserCommandResult
        {
            Success = true,
            Commited = true,
            File=new UserCommandFileResult(){
                Content=res,
                Name = userCommandContext.ExportAsPdf ?userCommandContext.FileName + ".pdf" : userCommandContext.FileName + ".docx",
                Type = userCommandContext.ExportAsPdf ? "PDF" : "Word"
            },
            ResultType = UserCommandResultType.Notificate,
            Messages = new[]
            {
                new UserCommandMessage
                {
                    Severity = SeverityLevel.Normal,
                    Text = "Документ успешно выгружен"
                }
            }
        };

        return result;
    }

}

//Модель данных
public class Nomer
{
        public string Nomerprotokola {get; set;}
        public string Dataprotokola { get; set; }
        public string Datanachalaprovedeniyaissledovaniy { get; set; }
        public string Dataokonchaniyaprovedeniyaissledovaniy { get; set; }
        public string Otvetstvennyy { get; set; }
        public Obrazec ObrazecPositions { get; set; }
    }


    public class Obrazec
    {
        public string Nomerobraztsa { get; set; }
        public string Naimenovanieobraztsa { get; set; }
        public string Dataotbora { get; set; }
        public Nomerzayavki12 Nomerzayavki12Positions { get; set; }
        public List<Obrazetsispytanie> ObrazetsispytaniePositions { get; set; }
    }

    public class Nomerzayavki12
    {
        public string name { get; set; }
        public string Otborproizvedenvsootvetstviis { get; set; }
        public string Usloviyatransportirovki { get; set; }
        public string Vidsoprovoddokumenta1 { get; set; }
        public string soprovoditelnyydokumentnomer { get; set; }
        public string Soprovoditelnyydokumentdata { get; set; }
    }

    public class Obrazetsispytanie
    {
        public string Naimenovaniepokazatelya3 { get; set; }
        public string Fakticheskoeznachenie { get; set; }
        public string Oborudovanie1 { get; set; }
    }