//private bool _isAggregated=false;
        internal Hierarchy(Dimension dim)
        {
            _dimension=dim;
            _dataMembers=new DataMembers(this);
            _dataMembers.SetCollectionType(typeof(DataMember), false); // allowed only DataMembers , not even inherited

            _calcMembers=new CalculatedMembers(this);
            _schemaMembers=new SchemaMembers(this, null);

            _dataMembers.BeforeAdd+=new ObjectEventHandler(_dataMembers_BeforeAdd);
            _dataMembers.BeforeRemove+=new ObjectEventHandler(_dataMembers_BeforeRemove);
            _dataMembers.BeforeChangeItem+=new ObjectEventHandler(_dataMembers_BeforeChange);

            _calcMembers.BeforeAdd+=new ObjectEventHandler(_calcMembers_BeforeAdd);
            _calcMembers.BeforeRemove+=new ObjectEventHandler(_calcMembers_BeforeRemove);
            _calcMembers.BeforeChangeItem+=new ObjectEventHandler(_calcMembers_BeforeChange);
        }
Example #2
0
        public void CreateGDT()
        {
            new Comment(this, "BEGIN - Create GDT");
            var xGDT = new List <byte>();

            // Null Segment - Selector 0x00
            // Not used, but required by many emulators.
            xGDT.AddRange(new byte[8]
            {
                0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00
            });

            // Code Segment
            mGdCode = (byte)xGDT.Count;
            xGDT.AddRange(GdtDescriptor(0x00000000, 0xFFFFFFFF, true));

            // Data Segment - Selector
            mGdData = (byte)xGDT.Count;
            xGDT.AddRange(GdtDescriptor(0x00000000, 0xFFFFFFFF, false));
            DataMembers.Add(new DataMember("_NATIVE_GDT_Contents", xGDT.ToArray()));

            new Comment("Tell CPU about GDT");
            var xGdtPtr = new UInt16[3];

            // Size of GDT Table - 1
            xGdtPtr[0] = (UInt16)(xGDT.Count - 1);
            DataMembers.Add(new DataMember("_NATIVE_GDT_Pointer", xGdtPtr));
            new Mov
            {
                DestinationRef          = Cosmos.Assembler.ElementReference.New("_NATIVE_GDT_Pointer"),
                DestinationIsIndirect   = true,
                DestinationDisplacement = 2,
                SourceRef = Cosmos.Assembler.ElementReference.New("_NATIVE_GDT_Contents")
            };
            new Mov
            {
                DestinationReg = Registers.EAX, SourceRef = Cosmos.Assembler.ElementReference.New("_NATIVE_GDT_Pointer")
            };
            new Lgdt
            {
                DestinationReg = Registers.EAX, DestinationIsIndirect = true
            };

            new Comment("Set data segments");
            new Mov
            {
                DestinationReg = Registers.EAX, SourceValue = mGdData
            };
            XS.Set(XSRegisters.OldToNewRegister(Registers.DS), XSRegisters.OldToNewRegister(Registers.EAX));
            XS.Set(XSRegisters.OldToNewRegister(Registers.ES), XSRegisters.OldToNewRegister(Registers.EAX));
            XS.Set(XSRegisters.OldToNewRegister(Registers.FS), XSRegisters.OldToNewRegister(Registers.EAX));
            XS.Set(XSRegisters.OldToNewRegister(Registers.GS), XSRegisters.OldToNewRegister(Registers.EAX));
            XS.Set(XSRegisters.OldToNewRegister(Registers.SS), XSRegisters.OldToNewRegister(Registers.EAX));

            new Comment("Force reload of code segment");
            new JumpToSegment
            {
                Segment = mGdCode, DestinationLabel = "Boot_FlushCsGDT"
            };
            new Label("Boot_FlushCsGDT");
            new Cosmos.Assembler.Comment(this, "END - Create GDT");
        }
Example #3
0
 protected override void OnBeforeFlush()
 {
     DataMembers.AddRange(new DataMember[] { new DataMember("_end_data", new byte[0]) });
 }
Example #4
0
        public void CreateGDT()
        {
            new Comment(this, "BEGIN - Create GDT");
            var xGDT = new List <byte>();

            // Null Segment - Selector 0x00
            // Not used, but required by many emulators.
            xGDT.AddRange(new byte[8]
            {
                0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00
            });

            // Code Segment
            mGdCode = (byte)xGDT.Count;
            xGDT.AddRange(GdtDescriptor(0x00000000, 0xFFFFFFFF, 0x9A));

            // Data Segment - Selector
            mGdData = (byte)xGDT.Count;
            xGDT.AddRange(GdtDescriptor(0x00000000, 0xFFFFFFFF, 0x92));

            // user process stuff
            xGDT.AddRange(new byte[8]
            {
                0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00
            });
            xGDT.AddRange(new byte[8]
            {
                0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00
            });
            xGDT.AddRange(GdtDescriptor(0x00000000, 104, 0x89));

            DataMembers.Add(new DataMember("_NATIVE_GDT_Contents", xGDT.ToArray()));
            DataMembers.Add(new DataMember("_NATIVE_TSS_Contents", new byte[104]));
            DataMembers.Add(new DataMember("_NATIVE_FPU_Contents", new byte[512]));

            XS.Comment("Tell CPU about GDT");
            var xGdtPtr = new UInt16[3];

            // Size of GDT Table - 1
            xGdtPtr[0] = (UInt16)(xGDT.Count - 1);
            DataMembers.Add(new DataMember("_NATIVE_GDT_Pointer", xGdtPtr));
            new Mov
            {
                DestinationRef          = ElementReference.New("_NATIVE_GDT_Pointer"),
                DestinationIsIndirect   = true,
                DestinationDisplacement = 2,
                SourceRef = ElementReference.New("_NATIVE_GDT_Contents")
            };
            XS.Set(XSRegisters.EAX, "_NATIVE_GDT_Pointer");
            XS.LoadGdt(XSRegisters.EAX, isIndirect: true);

            XS.Comment("Set data segments");
            XS.Set(XSRegisters.EAX, mGdData);
            XS.Set(XSRegisters.DS, XSRegisters.AX);
            XS.Set(XSRegisters.ES, XSRegisters.AX);
            XS.Set(XSRegisters.FS, XSRegisters.AX);
            XS.Set(XSRegisters.GS, XSRegisters.AX);
            XS.Set(XSRegisters.SS, XSRegisters.AX);

            XS.Comment("Force reload of code segment");
            new JumpToSegment
            {
                Segment = mGdCode, DestinationLabel = "Boot_FlushCsGDT"
            };
            XS.Label("Boot_FlushCsGDT");
            new Comment(this, "END - Create GDT");
        }
Example #5
0
        public void Initialize()
        {
            uint xSig = 0x1BADB002;

            DataMembers.Add(new DataIfNotDefined("ELF_COMPILATION"));
            DataMembers.Add(new DataMember("MultibootSignature", new uint[]
            {
                xSig
            }));
            uint xFlags = 0x10003;

            DataMembers.Add(new DataMember("MultibootFlags", xFlags));
            DataMembers.Add(new DataMember("MultibootChecksum", (int)(0 - (xFlags + xSig))));
            DataMembers.Add(new DataMember("MultibootHeaderAddr", Cosmos.Assembler.ElementReference.New("MultibootSignature")));
            DataMembers.Add(new DataMember("MultibootLoadAddr", Cosmos.Assembler.ElementReference.New("MultibootSignature")));
            DataMembers.Add(new DataMember("MultibootLoadEndAddr", Cosmos.Assembler.ElementReference.New("_end_code")));
            DataMembers.Add(new DataMember("MultibootBSSEndAddr", Cosmos.Assembler.ElementReference.New("_end_code")));
            DataMembers.Add(new DataMember("MultibootEntryAddr", Cosmos.Assembler.ElementReference.New("Kernel_Start")));
            DataMembers.Add(new DataEndIfDefined());

            DataMembers.Add(new DataIfDefined("ELF_COMPILATION"));
            xFlags = 0x00003;
            DataMembers.Add(new DataMember("MultibootSignature", new uint[]
            {
                xSig
            }));
            DataMembers.Add(new DataMember("MultibootFlags", xFlags));
            DataMembers.Add(new DataMember("MultibootChecksum", (int)(0 - (xFlags + xSig))));
            DataMembers.Add(new DataEndIfDefined());

            // graphics info fields
            DataMembers.Add(new DataMember("MultibootGraphicsRuntime_VbeModeInfoAddr", Int32.MaxValue));
            DataMembers.Add(new DataMember("MultibootGraphicsRuntime_VbeControlInfoAddr", Int32.MaxValue));
            DataMembers.Add(new DataMember("MultibootGraphicsRuntime_VbeMode", Int32.MaxValue));

            // memory
            DataMembers.Add(new DataMember("MultiBootInfo_Memory_High", 0));
            DataMembers.Add(new DataMember("MultiBootInfo_Memory_Low", 0));
            DataMembers.Add(new DataMember("Before_Kernel_Stack", new byte[0x50000]));
            DataMembers.Add(new DataMember("Kernel_Stack", new byte[0]));
            DataMembers.Add(new DataMember("MultiBootInfo_Structure", new uint[1]));

            if (mComPort > 0)
            {
                new Define("DEBUGSTUB");
            }

            // This is our first entry point. Multiboot uses this as Cosmos entry point.
            new Label("Kernel_Start", isGlobal: true);
            new Mov
            {
                DestinationReg = Registers.ESP,
                SourceRef      = Cosmos.Assembler.ElementReference.New("Kernel_Stack")
            };

            // Displays "Cosmos" in top left. Used to make sure Cosmos is booted in case of hang.
            // ie bootloader debugging. This must be the FIRST code, even before setup so we know
            // we are being called properly by the bootloader and that if there are problems its
            // somwhere in our code, not the bootloader.
            WriteDebugVideo("Cosmos pre boot");

            // For when using Bochs, causes a break ASAP on entry after initial Cosmos display.
            new LiteralAssemblerCode("xchg bx, bx");

            // CLI ASAP
            WriteDebugVideo("Clearing interrupts.");
            new ClearInterruptFlag();


            WriteDebugVideo("Begin multiboot info.");
            new LiteralAssemblerCode("%ifndef EXCLUDE_MULTIBOOT_MAGIC");
            new Comment(this, "MultiBoot compliant loader provides info in registers: ");
            new Comment(this, "EBX=multiboot_info ");
            new Comment(this, "EAX=0x2BADB002 - check if it's really Multiboot-compliant loader ");
            new Comment(this, "                ;- copy mb info - some stuff for you  ");
            new Comment(this, "BEGIN - Multiboot Info");
            new Mov
            {
                DestinationRef = Cosmos.Assembler.ElementReference.New("MultiBootInfo_Structure"), DestinationIsIndirect = true, SourceReg = Registers.EBX
            };
            new Add
            {
                DestinationReg = Registers.EBX, SourceValue = 4
            };
            new Mov
            {
                DestinationReg = Registers.EAX, SourceReg = Registers.EBX, SourceIsIndirect = true
            };
            new Mov
            {
                DestinationRef = Cosmos.Assembler.ElementReference.New("MultiBootInfo_Memory_Low"), DestinationIsIndirect = true, SourceReg = Registers.EAX
            };
            new Add
            {
                DestinationReg = Registers.EBX, SourceValue = 4
            };
            new Mov
            {
                DestinationReg   = Registers.EAX,
                SourceReg        = Registers.EBX,
                SourceIsIndirect = true
            };
            new Mov
            {
                DestinationRef = Cosmos.Assembler.ElementReference.New("MultiBootInfo_Memory_High"), DestinationIsIndirect = true, SourceReg = Registers.EAX
            };
            new Comment(this, "END - Multiboot Info");
            new LiteralAssemblerCode("%endif");
            WriteDebugVideo("Creating GDT.");
            CreateGDT();

            WriteDebugVideo("Configuring PIC");
            ConfigurePIC();

            WriteDebugVideo("Creating IDT.");
            CreateIDT();
#if LFB_1024_8
            new Comment("Set graphics fields");
            new Move {
                DestinationReg = Registers.EBX, SourceRef = Cosmos.Assembler.ElementReference.New("MultiBootInfo_Structure"), SourceIsIndirect = true
            };
            new Move {
                DestinationReg = Registers.EAX, SourceReg = Registers.EBX, SourceIsIndirect = true, SourceDisplacement = 72
            };
            new Move {
                DestinationRef = Cosmos.Assembler.ElementReference.New("MultibootGraphicsRuntime_VbeControlInfoAddr"), DestinationIsIndirect = true, SourceReg = Registers.EAX
            };
            new Move {
                DestinationReg = Registers.EAX, SourceReg = Registers.EBX, SourceIsIndirect = true, SourceDisplacement = 76
            };
            new Move {
                DestinationRef = Cosmos.Assembler.ElementReference.New("MultibootGraphicsRuntime_VbeModeInfoAddr"), DestinationIsIndirect = true, SourceReg = Registers.EAX
            };
            new Move {
                DestinationReg = Registers.EAX, SourceReg = Registers.EBX, SourceIsIndirect = true, SourceDisplacement = 80
            };
            new Move {
                DestinationRef = Cosmos.Assembler.ElementReference.New("MultibootGraphicsRuntime_VbeMode"), DestinationIsIndirect = true, SourceReg = Registers.EAX
            };
#endif

            //WriteDebugVideo("Initializing SSE.");
            //new Comment(this, "BEGIN - SSE Init");
            //// CR4[bit 9]=1, CR4[bit 10]=1, CR0[bit 2]=0, CR0[bit 1]=1
            //new Mov { DestinationReg = Registers.EAX, SourceReg = Registers.CR4 };
            //new Or { DestinationReg = Registers.EAX, SourceValue = 0x100 };
            //new Mov { DestinationReg = Registers.CR4, SourceReg = Registers.EAX };
            //new Mov { DestinationReg = Registers.EAX, SourceReg = Registers.CR4 };
            //new Or { DestinationReg = Registers.EAX, SourceValue = 0x200 };
            //new Mov { DestinationReg = Registers.CR4, SourceReg = Registers.EAX };
            //new Mov { DestinationReg = Registers.EAX, SourceReg = Registers.CR0 };

            //new And { DestinationReg = Registers.EAX, SourceValue = 0xfffffffd };
            //new Mov { DestinationReg = Registers.CR0, SourceReg = Registers.EAX };
            //new Mov { DestinationReg = Registers.EAX, SourceReg = Registers.CR0 };

            //new And { DestinationReg = Registers.EAX, SourceValue = 1 };
            //new Mov { DestinationReg = Registers.CR0, SourceReg = Registers.EAX };
            //new Comment(this, "END - SSE Init");

            if (mComPort > 0)
            {
                WriteDebugVideo("Initializing DebugStub.");
                new Call
                {
                    DestinationLabel = "DebugStub_Init"
                };
            }

            // Jump to Kernel entry point
            WriteDebugVideo("Jumping to kernel.");
            new Call
            {
                DestinationLabel = EntryPointName
            };

            new Comment(this, "Kernel done - loop till next IRQ");
            new Label(".loop");
            new ClearInterruptFlag();
            new Halt();
            new Jump
            {
                DestinationLabel = ".loop"
            };

            if (mComPort > 0)
            {
                var xGen = new XSharp.Compiler.AsmGenerator();

                var xGenerateAssembler =
                    new Action <object>(i =>
                {
                    if (i is StreamReader)
                    {
                        var xAsm = xGen.Generate((StreamReader)i);
                        CurrentInstance.Instructions.AddRange(xAsm.Instructions);
                        CurrentInstance.DataMembers.AddRange(xAsm.DataMembers);
                    }
                    else if (i is string)
                    {
                        var xAsm = xGen.Generate((string)i);
                        CurrentInstance.Instructions.AddRange(xAsm.Instructions);
                        CurrentInstance.DataMembers.AddRange(xAsm.DataMembers);
                    }
                    else
                    {
                        throw new Exception("Object type '" + i.ToString() + "' not supported!");
                    }
                });
                if (ReadDebugStubFromDisk)
                {
                    foreach (var xFile in Directory.GetFiles(Cosmos.Build.Common.CosmosPaths.DebugStubSrc, "*.xs"))
                    {
                        xGenerateAssembler(xFile);
                    }
                }
                else
                {
                    foreach (var xManifestName in typeof(ReferenceHelper).Assembly.GetManifestResourceNames())
                    {
                        if (!xManifestName.EndsWith(".xs", StringComparison.OrdinalIgnoreCase))
                        {
                            continue;
                        }
                        using (var xStream = typeof(ReferenceHelper).Assembly.GetManifestResourceStream(xManifestName))
                        {
                            using (var xReader = new StreamReader(xStream))
                            {
                                xGenerateAssembler(xReader);
                            }
                        }
                    }
                }
                OnAfterEmitDebugStub();
            }
            else
            {
                new Label("DebugStub_Step");
                new Return();
            }

            // Start emitting assembly labels
            Cosmos.Assembler.Assembler.CurrentInstance.EmitAsmLabels = true;
        }
Example #6
0
 protected override void OnBeforeFlush()
 {
     DataMembers.AddRange(new DataMember[] { new DataMember("_end_data", Array.Empty <byte>()) });
 }
Example #7
0
 // Allows to emit footers to the code and datamember sections
 protected void OnBeforeFlush()
 {
     DataMembers.AddRange(new DataMember[] { new DataMember("_end_data", new byte[0]) });
     new Label("_end_code");
 }
Example #8
0
        public void Initialize(bool enableVBE, string VBEResolution)
        {
            uint xSig = 0xe85250d6;

            //Multiboot header
            DataMembers.Add(new DataMember("align", "8", true));
            DataMembers.Add(new DataMember("MultibootHeader", Array.Empty <byte>()));
            DataMembers.Add(new DataMember("MultibootSignature", new uint[] { xSig }));
            DataMembers.Add(new DataMember("MultibootArchitecture", 0));
            DataMembers.Add(new DataMember("MultibootLenght", "MultibootHeaderEnd - MultibootHeader", typeof(uint)));
            DataMembers.Add(new DataMember("MultibootChecksum", "0x100000000 - (0xe85250d6 + 0 + (MultibootHeaderEnd - MultibootHeader))", typeof(uint)));

            if (enableVBE)
            {
                try
                {
                    string[] res = VBEResolution.Split('x');

                    //Framebuffer Tag
                    DataMembers.Add(new DataMember("align", "8", true));
                    DataMembers.Add(new DataMember("MultibootFramebufferTag", Array.Empty <byte>()));
                    DataMembers.Add(new DataMember("MultibootFramebufferType", (ushort)5));
                    DataMembers.Add(new DataMember("MultibootFramebufferOptional", (ushort)1));
                    DataMembers.Add(new DataMember("MultibootFramebufferLenght", "MultibootFramebufferTagEnd - MultibootFramebufferTag", typeof(uint)));
                    DataMembers.Add(new DataMember("", int.Parse(res[0])));
                    DataMembers.Add(new DataMember("", int.Parse(res[1])));
                    DataMembers.Add(new DataMember("", int.Parse(res[2])));

                    DataMembers.Add(new DataMember("MultibootFramebufferTagEnd", Array.Empty <byte>()));
                }
                catch
                {
                    Console.WriteLine("VBE Resolution must be this format: 1920x1080x32");
                }
            }

            // memory
            DataMembers.Add(new DataMember("align", "8", true));
            DataMembers.Add(new DataMember("MultibootMemoryTag", Array.Empty <byte>()));
            DataMembers.Add(new DataMember("MultibootMemoryTagType", (ushort)2));
            DataMembers.Add(new DataMember("MultibootMemoryTagOptional", (ushort)1));
            DataMembers.Add(new DataMember("MultibootMemoryTagLenght", "MultibootMemoryTagEnd - MultibootMemoryTag", typeof(uint)));
            DataMembers.Add(new DataMember("MultibootHeaderAddr", ElementReference.New("MultibootSignature")));
            DataMembers.Add(new DataMember("MultibootLoadAddr", ElementReference.New("MultibootSignature")));
            DataMembers.Add(new DataMember("MultibootLoadEndAddr", ElementReference.New("_end_code")));
            DataMembers.Add(new DataMember("MultibootBSSEndAddr", ElementReference.New("_end_code")));
            DataMembers.Add(new DataMember("MultibootMemoryTagEnd", Array.Empty <byte>()));

            //Entry Address
            DataMembers.Add(new DataMember("align", "8", true));
            DataMembers.Add(new DataMember("MultibootEntryTag", Array.Empty <byte>()));
            DataMembers.Add(new DataMember("MultibootEntryTagType", (ushort)3));
            DataMembers.Add(new DataMember("MultibootEntryTagOptional", (ushort)1));
            DataMembers.Add(new DataMember("MultibootEntryTagLenght", "MultibootEntryTagEnd - MultibootEntryTag", typeof(uint)));
            DataMembers.Add(new DataMember("MultibootEntryAddr", ElementReference.New("Kernel_Start")));
            DataMembers.Add(new DataMember("MultibootEntryTagEnd", Array.Empty <byte>()));

            //End Tag
            DataMembers.Add(new DataMember("align", "8", true));
            DataMembers.Add(new DataMember("MultibootEndTag", Array.Empty <byte>()));
            DataMembers.Add(new DataMember("MultibootEndTagType", (ushort)0));
            DataMembers.Add(new DataMember("MultibootEndTagOptional", (ushort)0));
            DataMembers.Add(new DataMember("MultibootEndTagEnd", Array.Empty <byte>()));

            DataMembers.Add(new DataMember("MultibootHeaderEnd", Array.Empty <byte>()));

            //memory
            DataMembers.Add(new DataMember("align", "16", true));
            DataMembers.Add(new DataMember("Before_Kernel_Stack", new byte[0x50000]));
            DataMembers.Add(new DataMember("align", "16", true));
            DataMembers.Add(new DataMember("Kernel_Stack", Array.Empty <byte>()));
            DataMembers.Add(new DataMember("MultiBootInfo_Structure", new uint[1]));

            // constants
            DataMembers.Add(new DataMember("align", "16", true));
            DataMembers.Add(new DataMember(@"__uint2double_const", new byte[] { 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0xf0, 0x41 }));
            DataMembers.Add(new DataMember("align", "16", true));
            DataMembers.Add(new DataMember(@"__ulong2double_const", 0x5F800000));
            DataMembers.Add(new DataMember("align", "16", true));
            DataMembers.Add(new DataMember(@"__doublesignbit", 0x8000000000000000));
            DataMembers.Add(new DataMember("align", "16", true));
            DataMembers.Add(new DataMember(@"__floatsignbit", 0x80000000));

            if (mComPort > 0)
            {
                new Define("DEBUGSTUB");
            }

            // This is our first entry point. Multiboot uses this as Cosmos entry point.
            new Label("Kernel_Start", isGlobal: true);
            XS.Set(ESP, "Kernel_Stack");

            // Displays "Cosmos" in top left. Used to make sure Cosmos is booted in case of hang.
            // ie bootloader debugging. This must be the FIRST code, even before setup so we know
            // we are being called properly by the bootloader and that if there are problems its
            // somwhere in our code, not the bootloader.
            WriteDebugVideo("Cosmos pre boot");

            // For when using Bochs, causes a break ASAP on entry after initial Cosmos display.
            //new LiteralAssemblerCode("xchg bx, bx");

            // CLI ASAP
            WriteDebugVideo("Clearing interrupts.");
            XS.ClearInterruptFlag();


            WriteDebugVideo("Begin multiboot info.");
            new LiteralAssemblerCode("%ifndef EXCLUDE_MULTIBOOT_MAGIC");
            new Comment(this, "MultiBoot compliant loader provides info in registers: ");
            new Comment(this, "EBX=multiboot_info ");
            new Comment(this, "EAX=0x36d76289 - check if it's really Multiboot2-compliant loader ");
            new Comment(this, "                ;- copy mb info - some stuff for you  ");
            new Comment(this, "BEGIN - Multiboot Info");
            new Mov
            {
                DestinationRef        = ElementReference.New("MultiBootInfo_Structure"),
                DestinationIsIndirect = true,
                SourceReg             = RegistersEnum.EBX
            };

            XS.Call("SystemVoidCosmosCoreMultiboot2Init");

            new Comment(this, "END - Multiboot Info");
            new LiteralAssemblerCode("%endif");
            WriteDebugVideo("Creating GDT.");
            CreateGDT();

            WriteDebugVideo("Configuring PIC");
            ConfigurePIC();

            WriteDebugVideo("Creating IDT.");
            CreateIDT();

            //WriteDebugVideo("Initializing SSE.");
            //new Comment(this, "BEGIN - SSE Init");
            //// CR4[bit 9]=1, CR4[bit 10]=1, CR0[bit 2]=0, CR0[bit 1]=1
            //XS.Mov(XSRegisters.EAX, XSRegisters.Registers.CR4);
            //XS.Or(XSRegisters.EAX, 0x100);
            //XS.Mov(XSRegisters.CR4, XSRegisters.Registers.EAX);
            //XS.Mov(XSRegisters.EAX, XSRegisters.Registers.CR4);
            //XS.Or(XSRegisters.EAX, 0x200);
            //XS.Mov(XSRegisters.CR4, XSRegisters.Registers.EAX);
            //XS.Mov(XSRegisters.EAX, XSRegisters.Registers.CR0);

            //XS.And(XSRegisters.EAX, 0xfffffffd);
            //XS.Mov(XSRegisters.CR0, XSRegisters.Registers.EAX);
            //XS.Mov(XSRegisters.EAX, XSRegisters.Registers.CR0);

            //XS.And(XSRegisters.EAX, 1);
            //XS.Mov(XSRegisters.CR0, XSRegisters.Registers.EAX);
            //new Comment(this, "END - SSE Init");

            if (mComPort > 0)
            {
                WriteDebugVideo("Initializing DebugStub.");
                XS.Call(AsmMarker.Labels[AsmMarker.Type.DebugStub_Init]);
            }

            //Initiate Memory
            WriteDebugVideo("Initiating Memory");
            XS.Call(LabelName.Get(GCImplementationRefs.InitRef));

            // Jump to Kernel entry point
            WriteDebugVideo("Jumping to kernel.");
            XS.Call(EntryPointName);

            new Comment(this, "Kernel done - loop till next IRQ");
            XS.Label(".loop");
            XS.ClearInterruptFlag();
            XS.Halt();
            XS.Jump(".loop");

            if (mComPort > 0)
            {
                var xGen = new AsmGenerator();

                void GenerateAssembler(Assembler assembler)
                {
                    CurrentInstance.Instructions.AddRange(assembler.Instructions);
                    CurrentInstance.DataMembers.AddRange(assembler.DataMembers);
                }

                if (ReadDebugStubFromDisk)
                {
                    foreach (var xFile in Directory.GetFiles(CosmosPaths.DebugStubSrc, "*.xs"))
                    {
                        GenerateAssembler(xGen.Generate(xFile));
                    }
                }
                else
                {
                    foreach (var xManifestName in typeof(ReferenceHelper).Assembly.GetManifestResourceNames())
                    {
                        if (!xManifestName.EndsWith(".xs", StringComparison.OrdinalIgnoreCase))
                        {
                            continue;
                        }
                        using (var xStream = typeof(ReferenceHelper).Assembly.GetManifestResourceStream(xManifestName))
                        {
                            using (var xReader = new StreamReader(xStream))
                            {
                                GenerateAssembler(xGen.Generate(xReader));
                            }
                        }
                    }
                }
                OnAfterEmitDebugStub();
            }
            else
            {
                XS.Label(AsmMarker.Labels[AsmMarker.Type.DebugStub_Step]);
                XS.Return();
            }

            // Start emitting assembly labels
            CurrentInstance.EmitAsmLabels = true;
        }
Example #9
0
        public void Initialize()
        {
            uint xSig = 0x1BADB002;

            DataMembers.Add(new DataIfNotDefined("ELF_COMPILATION"));
            DataMembers.Add(new DataMember("MultibootSignature", new uint[] { xSig }));
            uint xFlags = 0x10007;

            DataMembers.Add(new DataMember("MultibootFlags", xFlags));
            DataMembers.Add(new DataMember("MultibootChecksum", (int)(0 - (xFlags + xSig))));
            DataMembers.Add(new DataMember("MultibootHeaderAddr", ElementReference.New("MultibootSignature")));
            DataMembers.Add(new DataMember("MultibootLoadAddr", ElementReference.New("MultibootSignature")));
            DataMembers.Add(new DataMember("MultibootLoadEndAddr", ElementReference.New("_end_code")));
            DataMembers.Add(new DataMember("MultibootBSSEndAddr", ElementReference.New("_end_code")));
            DataMembers.Add(new DataMember("MultibootEntryAddr", ElementReference.New("Kernel_Start")));
            DataMembers.Add(new DataMember("", 0));
            DataMembers.Add(new DataMember("", 800, 600, 32));
            DataMembers.Add(new DataEndIfDefined());

            DataMembers.Add(new DataIfDefined("ELF_COMPILATION"));
            xFlags = 0x00007;
            DataMembers.Add(new DataMember("MultibootSignature", new uint[] { xSig }));
            DataMembers.Add(new DataMember("MultibootFlags", xFlags));
            DataMembers.Add(new DataMember("MultibootChecksum", (int)(0 - (xFlags + xSig))));
            DataMembers.Add(new DataMember("", 0, 0, 0, 0, 0));
            DataMembers.Add(new DataMember("", 0));
            DataMembers.Add(new DataMember("", 800, 600, 32));
            DataMembers.Add(new DataEndIfDefined());

            // graphics info fields
            DataMembers.Add(new DataMember("MultibootGraphicsRuntime_VbeModeInfoAddr", 1 << 2));
            DataMembers.Add(new DataMember("MultibootGraphicsRuntime_VbeControlInfoAddr", 1 << 0));
            DataMembers.Add(new DataMember("MultibootGraphicsRuntime_VbeMode", 0));

            // memory
            DataMembers.Add(new DataMember("MultiBootInfo_Memory_High", 0));
            DataMembers.Add(new DataMember("MultiBootInfo_Memory_Low", 0));
            DataMembers.Add(new DataMember("Before_Kernel_Stack", new byte[0x50000]));
            DataMembers.Add(new DataMember("Kernel_Stack", Array.Empty <byte>()));
            DataMembers.Add(new DataMember("MultiBootInfo_Structure", new uint[1]));

            // constants
            DataMembers.Add(new DataMember(@"__uint2double_const", new byte[] { 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0xf0, 0x41 }));
            DataMembers.Add(new DataMember(@"__ulong2double_const", 0x5F800000));
            DataMembers.Add(new DataMember(@"__doublesignbit", 0x8000000000000000));
            DataMembers.Add(new DataMember(@"__floatsignbit", 0x80000000));

            if (mComPort > 0)
            {
                new Define("DEBUGSTUB");
            }

            // This is our first entry point. Multiboot uses this as Cosmos entry point.
            new Label("Kernel_Start", isGlobal: true);
            XS.Set(ESP, "Kernel_Stack");

            // Displays "Cosmos" in top left. Used to make sure Cosmos is booted in case of hang.
            // ie bootloader debugging. This must be the FIRST code, even before setup so we know
            // we are being called properly by the bootloader and that if there are problems its
            // somwhere in our code, not the bootloader.
            WriteDebugVideo("Cosmos pre boot");

            // For when using Bochs, causes a break ASAP on entry after initial Cosmos display.
            //new LiteralAssemblerCode("xchg bx, bx");

            // CLI ASAP
            WriteDebugVideo("Clearing interrupts.");
            XS.ClearInterruptFlag();


            WriteDebugVideo("Begin multiboot info.");
            new LiteralAssemblerCode("%ifndef EXCLUDE_MULTIBOOT_MAGIC");
            new Comment(this, "MultiBoot compliant loader provides info in registers: ");
            new Comment(this, "EBX=multiboot_info ");
            new Comment(this, "EAX=0x2BADB002 - check if it's really Multiboot-compliant loader ");
            new Comment(this, "                ;- copy mb info - some stuff for you  ");
            new Comment(this, "BEGIN - Multiboot Info");
            new Mov
            {
                DestinationRef        = ElementReference.New("MultiBootInfo_Structure"),
                DestinationIsIndirect = true,
                SourceReg             = RegistersEnum.EBX
            };
            XS.Add(EBX, 4);
            XS.Set(EAX, EBX, sourceIsIndirect: true);
            new Mov
            {
                DestinationRef        = ElementReference.New("MultiBootInfo_Memory_Low"),
                DestinationIsIndirect = true,
                SourceReg             = RegistersEnum.EAX
            };
            XS.Add(EBX, 4);
            XS.Set(EAX, EBX, sourceIsIndirect: true);
            new Mov
            {
                DestinationRef        = ElementReference.New("MultiBootInfo_Memory_High"),
                DestinationIsIndirect = true,
                SourceReg             = RegistersEnum.EAX
            };
            new Comment(this, "END - Multiboot Info");
            new LiteralAssemblerCode("%endif");
            WriteDebugVideo("Creating GDT.");
            CreateGDT();

            WriteDebugVideo("Configuring PIC");
            ConfigurePIC();

            WriteDebugVideo("Creating IDT.");
            CreateIDT();

            new Comment("Set graphics fields");
            new Mov {
                DestinationReg = XSRegisters.EBX, SourceRef = ElementReference.New("MultiBootInfo_Structure"), SourceIsIndirect = true
            };
            new Mov {
                DestinationReg = XSRegisters.EAX, SourceReg = XSRegisters.EBX, SourceIsIndirect = true, SourceDisplacement = 72
            };
            new Mov {
                DestinationRef = ElementReference.New("MultibootGraphicsRuntime_VbeControlInfoAddr"), DestinationIsIndirect = true, SourceReg = XSRegisters.EAX
            };
            new Mov {
                DestinationReg = XSRegisters.EAX, SourceReg = XSRegisters.EBX, SourceIsIndirect = true, SourceDisplacement = 76
            };
            new Mov {
                DestinationRef = ElementReference.New("MultibootGraphicsRuntime_VbeModeInfoAddr"), DestinationIsIndirect = true, SourceReg = XSRegisters.EAX
            };
            new Mov {
                DestinationReg = XSRegisters.EAX, SourceReg = XSRegisters.EBX, SourceIsIndirect = true, SourceDisplacement = 80
            };
            new Mov {
                DestinationRef = ElementReference.New("MultibootGraphicsRuntime_VbeMode"), DestinationIsIndirect = true, SourceReg = XSRegisters.EAX
            };

            //WriteDebugVideo("Initializing SSE.");
            //new Comment(this, "BEGIN - SSE Init");
            //// CR4[bit 9]=1, CR4[bit 10]=1, CR0[bit 2]=0, CR0[bit 1]=1
            //XS.Mov(XSRegisters.EAX, XSRegisters.Registers.CR4);
            //XS.Or(XSRegisters.EAX, 0x100);
            //XS.Mov(XSRegisters.CR4, XSRegisters.Registers.EAX);
            //XS.Mov(XSRegisters.EAX, XSRegisters.Registers.CR4);
            //XS.Or(XSRegisters.EAX, 0x200);
            //XS.Mov(XSRegisters.CR4, XSRegisters.Registers.EAX);
            //XS.Mov(XSRegisters.EAX, XSRegisters.Registers.CR0);

            //XS.And(XSRegisters.EAX, 0xfffffffd);
            //XS.Mov(XSRegisters.CR0, XSRegisters.Registers.EAX);
            //XS.Mov(XSRegisters.EAX, XSRegisters.Registers.CR0);

            //XS.And(XSRegisters.EAX, 1);
            //XS.Mov(XSRegisters.CR0, XSRegisters.Registers.EAX);
            //new Comment(this, "END - SSE Init");

            if (mComPort > 0)
            {
                WriteDebugVideo("Initializing DebugStub.");
                XS.Call(AsmMarker.Labels[AsmMarker.Type.DebugStub_Init]);
            }

            // Jump to Kernel entry point
            WriteDebugVideo("Jumping to kernel.");
            XS.Call(EntryPointName);

            new Comment(this, "Kernel done - loop till next IRQ");
            XS.Label(".loop");
            XS.ClearInterruptFlag();
            XS.Halt();
            XS.Jump(".loop");

            if (mComPort > 0)
            {
                var xGen = new AsmGenerator();

                void GenerateAssembler(Assembler assembler)
                {
                    CurrentInstance.Instructions.AddRange(assembler.Instructions);
                    CurrentInstance.DataMembers.AddRange(assembler.DataMembers);
                }

                if (ReadDebugStubFromDisk)
                {
                    foreach (var xFile in Directory.GetFiles(CosmosPaths.DebugStubSrc, "*.xs"))
                    {
                        GenerateAssembler(xGen.Generate(xFile));
                    }
                }
                else
                {
                    foreach (var xManifestName in typeof(ReferenceHelper).Assembly.GetManifestResourceNames())
                    {
                        if (!xManifestName.EndsWith(".xs", StringComparison.OrdinalIgnoreCase))
                        {
                            continue;
                        }
                        using (var xStream = typeof(ReferenceHelper).Assembly.GetManifestResourceStream(xManifestName))
                        {
                            using (var xReader = new StreamReader(xStream))
                            {
                                GenerateAssembler(xGen.Generate(xReader));
                            }
                        }
                    }
                }
                OnAfterEmitDebugStub();
            }
            else
            {
                XS.Label(AsmMarker.Labels[AsmMarker.Type.DebugStub_Step]);
                XS.Return();
            }

            // Start emitting assembly labels
            CurrentInstance.EmitAsmLabels = true;
        }
Example #10
0
        private string UsingOleDb(string inFilePath, UploadViewModel model)
        {
            string companyId   = HttpContext.Session.GetString("CompanyId");
            string companyCode = HttpContext.Session.GetString("CompanyCode");

            List <DataMembers> dataMembers = baseRepository.ExecuteCommand(conn =>
                                                                           conn.Query <DataMembers>(@"SELECT [DI].[" + model.ColumnsType + @"] AS [ColumnValue], [DI].[Name] AS [ColumnName], [DI].[Title]" +
                                                                                                    @", [DM].[Id], [DM].[DataSetId], [DM].[DataItemId], [DM].[RegularExperssion], [DM].[Description]" +
                                                                                                    @" FROM [TavanirStage].[Stage].[DataMembers] AS [DM]" +
                                                                                                    @" INNER JOIN [TavanirStage].[Basic].[DataItems] AS [DI] ON [DM].[DataItemId] = [DI].[Id]" +
                                                                                                    @" AND [DI].[Enabled] = '1'" +
                                                                                                    @" WHERE [DM].[Enabled] = '1' AND [DI].[DataCategoryID] = @DataCategoryID",
                                                                                                    new { @DataCategoryID = model.DataCategoryID }).ToList());

            if ((dataMembers?.Any() ?? false) == false)
            {
                return("فیلد فعالی موجود نمی‌باشد.");
            }

            List <TimeSeries>       timeSeries       = null;
            List <HistoricalValues> historicalValues = null;

            PersianCalendar pc           = new PersianCalendar();
            int             default_year = pc.GetYear(DateTime.Now);

            int year; byte?month; byte?dayOfMonth; string timeOfDay = string.Empty;

            int         i      = 0;
            int         i_save = 0;
            DataMembers item   = null;

            DateTime receiption = DateTime.Now;

            //"HDR=Yes;" indicates that the first row contains column names, not data.
            var connectionString = $@"
            Provider=Microsoft.ACE.OLEDB.12.0;
            Data Source={inFilePath};
            Extended Properties=""Excel 12.0 Xml;HDR=YES""";

            using (var conn = new OleDbConnection(connectionString))
            {
                conn.Open();
                var cmd = conn.CreateCommand();
                cmd.CommandText = $@"SELECT * FROM [{model.SheetName}$]";
                using (var dr = cmd.ExecuteReader())
                {
                    if (dr.FieldCount == 0)
                    {
                        return("داده‌ای در فایل اکسل یافت نشد.");
                    }


                    timeSeries       = new List <TimeSeries>();
                    historicalValues = new List <HistoricalValues>(dr.FieldCount);
                    bool has_data_in_row;
                    while (dr.Read())
                    {
                        i++;
                        i_save++;

                        has_data_in_row = false;

                        year       = default_year;
                        month      = null;
                        dayOfMonth = null;
                        timeOfDay  = null;
                        for (int j = 0; j < dr.FieldCount; j++)
                        {
                            string val = dr.GetValue(j).ToString();
                            switch (dr.GetName(j))
                            {
                            case "Token":
                            case "RowIndex":
                            case "توکن":
                            case "شماره سطر": break;

                            case "Year":
                            case "سال":
                                if (!string.IsNullOrEmpty(val))
                                {
                                    if (!int.TryParse(val, out year))
                                    {
                                        if (!byte.TryParse(val, out byte month2))
                                        {
                                            return(string.Concat("مقدار سال وارد شده (", val, ") در سطر ", i, " معتبر نمی‌باشد."));
                                        }
                                        //year = default_year;
                                    }
                                }
                                break;

                            case "Month":
                            case "ماه":
                                if (!string.IsNullOrEmpty(val))
                                {
                                    if (!byte.TryParse(val, out byte month2))
                                    {
                                        return(string.Concat("مقدار ماه وارد شده (", val, ") در سطر ", i, " معتبر نمی‌باشد."));
                                    }
                                    if (!(month2 >= 1 && month2 <= 12))
                                    {
                                        return($"مقدار ماه وارد شده ({month2}) در سطر {i} در بازه مجاز نمی‌باشد!");
                                    }
                                    month = month2;
                                }
                                break;

                            case "Day":
                            case "روز":
                                if (!string.IsNullOrEmpty(val))
                                {
                                    if (!byte.TryParse(val, out byte dayOfMonth2))
                                    {
                                        return(string.Concat("مقدار روز (", val, ") از ماه وارد شده در سطر ", i, " معتبر نمی‌باشد."));
                                    }
                                    dayOfMonth = dayOfMonth2;
                                }
                                break;

                            case "Hour":
                            case "ساعت":
                                if (!string.IsNullOrEmpty(val))
                                {
                                    if (val.IndexOf(":") == -1 || !DateTime.TryParse(val, out DateTime timeOfDay2))
                                    {
                                        return(string.Concat("مقدار زمان (", val, ") وارد شده در سطر ", i, " معتبر نمی‌باشد. فرمت صحیح HH:mm:ss"));
                                    }
                                    timeOfDay = timeOfDay2.ToString("HH:mm:ss");
                                }
                                break;

                            default:
                                item = dataMembers.Where(c => c.ColumnValue == dr.GetName(j))?.FirstOrDefault();

                                if (item != null && item.DataSetId != null && !Equals(item.DataSetId, Guid.Empty))
                                {
                                    if (item.ColumnName == "COMP" && string.IsNullOrEmpty(val) && !string.IsNullOrEmpty(companyCode))
                                    {
                                        val = companyCode;
                                    }

                                    if (!string.IsNullOrEmpty(item.RegularExperssion))
                                    {
                                        Regex rgx = new Regex(item.RegularExperssion);
                                        if (!rgx.IsMatch(val))
                                        {
                                            return(string.Concat("مقدار «", val,
                                                                 "»، برای «", item.ColumnName,
                                                                 " ::: ", item.Title, "» در سطر ", i,
                                                                 " معتبر نمی‌باشد. : ", item.Description));
                                        }
                                    }

                                    historicalValues.Add(new HistoricalValues()
                                    {
                                        Id           = Guid.NewGuid(),
                                        TimeSeriesId = Guid.Empty,
                                        RowIndex     = i_save,
                                        Receiption   = receiption,
                                        RecivedValue = val,
                                        DataMemberId = item.Id,
                                        Approved     = "1"
                                    });

                                    has_data_in_row = true;
                                }
                                else
                                {
                                    if (!string.IsNullOrEmpty(val))
                                    {
                                        return($"ستون «{dr.GetName(j)}» تعریف نشده و یا فعال نمی‌باشد.");
                                    }
                                }
                                break;
                            }
                        }

                        if (has_data_in_row == true)
                        {
                            // بررسی مقادیر سال، ماه و روز:
                            if (!(year >= 1300 && year <= 9999))
                            {
                                return($"سال وارد شده ({year}) در سطر {i} در بازه مجاز نمی‌باشد.");
                            }
                            if (dayOfMonth.HasValue)
                            {
                                if (!month.HasValue)
                                {
                                    return($"برای سطر {i}: مقدار روز ({dayOfMonth.Value}) وارد شده، درصورتی که مقدار ماه ای وارد نشده است.");
                                }
                                if (!((month.Value < 7 && (dayOfMonth.Value >= 1 && dayOfMonth.Value <= 31)) || (month.Value > 6 && (dayOfMonth.Value >= 1 && dayOfMonth.Value <= 30))))
                                {
                                    return($"مقدار روز وارد شده ({dayOfMonth.Value}) برای ماه ({month.Value}) در سطر {i} معتبر نمی‌باشد.");
                                }
                            }

                            // بررسی مقادیر ضروری که ستون‌هایشان در فایل اکسل آپلودی موجود نیستند:
                            for (int k = 0; k < dataMembers.Count; k++)
                            {
                                if (!string.IsNullOrEmpty(item.RegularExperssion))
                                {
                                    Regex            rgx     = new Regex(item.RegularExperssion);
                                    HistoricalValues item_ck = historicalValues.Where(c => c.DataMemberId == dataMembers[k].Id).FirstOrDefault();
                                    if (item_ck == null || item_ck.Id == null || Equals(item_ck.Id, Guid.Empty))
                                    {
                                        if (item.ColumnName == "COMP" && !string.IsNullOrEmpty(companyCode))
                                        {
                                            historicalValues.Add(new HistoricalValues()
                                            {
                                                Id           = Guid.NewGuid(),
                                                TimeSeriesId = Guid.Empty,
                                                RowIndex     = i_save,
                                                Receiption   = receiption,
                                                RecivedValue = companyCode,
                                                DataMemberId = item.Id,
                                                Approved     = "1"
                                            });
                                        }
                                        else if (!rgx.IsMatch(string.Empty))
                                        {
                                            return(string.Concat("مقدار ای برای «", item.ColumnName,
                                                                 " ::: ", item.Title, "» تعیین نشده است. : ", item.Description));
                                        }
                                    }
                                }
                            }


                            Guid timeSeries_Id = Guid.Empty;

                            if (month.HasValue)
                            {
                                if (dayOfMonth.HasValue)
                                {
                                    timeSeries_Id = timeSeries.Where(c => c.Year == year && c.Month.HasValue && c.Month.Value == month.Value && c.DayOfMonth.HasValue && c.DayOfMonth.Value == dayOfMonth.Value && Equals(c.TimeOfDay, timeOfDay))
                                                    .Select(c => c.Id).FirstOrDefault();
                                }
                                else
                                {
                                    timeSeries_Id = timeSeries.Where(c => c.Year == year && c.Month.HasValue && c.Month.Value == month.Value && !c.DayOfMonth.HasValue && Equals(c.TimeOfDay, timeOfDay))
                                                    .Select(c => c.Id).FirstOrDefault();
                                }
                            }
                            else
                            {
                                timeSeries_Id = timeSeries.Where(c => c.Year == year && !c.Month.HasValue && !c.DayOfMonth.HasValue && Equals(c.TimeOfDay, timeOfDay))
                                                .Select(c => c.Id).FirstOrDefault();
                            }

                            if (Equals(timeSeries_Id, Guid.Empty))
                            {
                                timeSeries_Id = Guid.NewGuid();
                                timeSeries.Add(new TimeSeries()
                                {
                                    Id        = timeSeries_Id,
                                    Year      = year,
                                    TimeOfDay = timeOfDay,
                                    Enabled   = "1"
                                });
                                if (month.HasValue)
                                {
                                    timeSeries[timeSeries.Count - 1].Month = month.Value;
                                }
                                if (dayOfMonth.HasValue)
                                {
                                    timeSeries[timeSeries.Count - 1].DayOfMonth = dayOfMonth.Value;
                                }
                            }


                            for (int k = 0; k < historicalValues.Count; k++)
                            {
                                if (Equals(historicalValues[k].TimeSeriesId, Guid.Empty))
                                {
                                    historicalValues[k].TimeSeriesId = timeSeries_Id;
                                }
                            }
                        }
                        else
                        {
                            i_save--;
                        }
                    }
                }
            }

            if (i == 0)
            {
                return("سطری یافت نشد.");
            }

            Guid token = Guid.NewGuid();

            StringBuilder queryBuilder_TimeSeries = new StringBuilder(2048);

            queryBuilder_TimeSeries.Append("INSERT INTO [TavanirStage].[Basic].[TimeSeries]([Id],[Token],[Year],[Month],[DayOfMonth],[TimeOfDay],[Enabled])VALUES");
            for (int j = 0; j < timeSeries.Count; j++)
            {
                if (j > 0)
                {
                    queryBuilder_TimeSeries.Append(",");
                }
                queryBuilder_TimeSeries.Append("('");
                queryBuilder_TimeSeries.Append(timeSeries[j].Id.ToString());
                queryBuilder_TimeSeries.Append("','");
                queryBuilder_TimeSeries.Append(token.ToString());
                queryBuilder_TimeSeries.Append("','");
                queryBuilder_TimeSeries.Append(timeSeries[j].Year);
                queryBuilder_TimeSeries.Append("',");
                if (timeSeries[j].Month.HasValue)
                {
                    queryBuilder_TimeSeries.Append(timeSeries[j].Month.Value);
                }
                else
                {
                    queryBuilder_TimeSeries.Append("NULL");
                }
                queryBuilder_TimeSeries.Append(",");
                if (timeSeries[j].DayOfMonth.HasValue)
                {
                    queryBuilder_TimeSeries.Append(timeSeries[j].Month.Value);
                }
                else
                {
                    queryBuilder_TimeSeries.Append("NULL");
                }
                queryBuilder_TimeSeries.Append(",");
                if (!string.IsNullOrEmpty(timeSeries[j].TimeOfDay))
                {
                    queryBuilder_TimeSeries.Append("'");
                    queryBuilder_TimeSeries.Append(timeSeries[j].TimeOfDay);
                    queryBuilder_TimeSeries.Append("'");
                }
                else
                {
                    queryBuilder_TimeSeries.Append("NULL");
                }
                queryBuilder_TimeSeries.Append(",'");
                queryBuilder_TimeSeries.Append(timeSeries[j].Enabled);
                queryBuilder_TimeSeries.Append("')");
            }

            StringBuilder queryBuilder_HistoricalValues = new StringBuilder(4096);

            queryBuilder_HistoricalValues.Append("INSERT [TavanirStage].[Stage].[HistoricalValues]([Id],[TimeSeriesId],[RowIndex],[RecivedValue],[Approved],[Receiption],[DataMemberId])VALUES");
            for (int j = 0; j < historicalValues.Count; j++)
            {
                if (j > 0)
                {
                    queryBuilder_HistoricalValues.Append(",");
                }
                queryBuilder_HistoricalValues.Append("('");
                queryBuilder_HistoricalValues.Append(historicalValues[j].Id.ToString());
                queryBuilder_HistoricalValues.Append("','");
                queryBuilder_HistoricalValues.Append(historicalValues[j].TimeSeriesId.ToString());
                queryBuilder_HistoricalValues.Append("','");
                queryBuilder_HistoricalValues.Append(historicalValues[j].RowIndex);
                queryBuilder_HistoricalValues.Append("',");
                if (!string.IsNullOrEmpty(historicalValues[j].RecivedValue))
                {
                    queryBuilder_HistoricalValues.Append("N'");
                    queryBuilder_HistoricalValues.Append(historicalValues[j].RecivedValue);
                    queryBuilder_HistoricalValues.Append("'");
                }
                else
                {
                    queryBuilder_HistoricalValues.Append("NULL");
                }
                queryBuilder_HistoricalValues.Append(",'");
                queryBuilder_HistoricalValues.Append(historicalValues[j].Approved);
                queryBuilder_HistoricalValues.Append("','");
                queryBuilder_HistoricalValues.Append(historicalValues[j].Receiption);
                queryBuilder_HistoricalValues.Append("','");
                queryBuilder_HistoricalValues.Append(historicalValues[j].DataMemberId);
                queryBuilder_HistoricalValues.Append("')");
            }


            bool   is_valid_code            = false;
            string authorizationTokens_Code = null;

            while (is_valid_code == false)
            {
                authorizationTokens_Code = RandomString(10);

                string ck_code = baseRepository.ExecuteCommand(conn =>
                                                               conn.Query <string>("SELECT [Code] FROM [TavanirStage].[Stage].[AuthorizationTokens] WHERE [Code] = @Code",
                                                                                   new { @Code = authorizationTokens_Code }).FirstOrDefault());
                if (string.IsNullOrEmpty(ck_code))
                {
                    is_valid_code = true;
                }
            }

            baseRepository.ExecuteCommand(conn =>
            {
                using (var transaction = conn.BeginTransaction())
                {
                    conn.Execute("INSERT INTO [TavanirStage].[Stage].[AuthorizationTokens] ([Token], [CreatedDate], [CompanyId], [Code]) VALUES (@Token, @CreatedDate, @CompanyId, @Code)",
                                 new { @Token = token, @CompanyId = Guid.Parse(companyId), @CreatedDate = receiption, @Code = authorizationTokens_Code }, transaction);

                    conn.Execute(queryBuilder_TimeSeries.ToString(), null, transaction);

                    conn.Execute(queryBuilder_HistoricalValues.ToString(), null, transaction);

                    transaction.Commit();
                }
            });

            HttpContext.Session.SetString("Code", authorizationTokens_Code);

            return(string.Empty);
        }