public static void CreateTables()
        {
            NGSConnector connector = new NGSConnector();
            connector.execSQL(UserTable);
            connector.execSQL(CompanyTable);
            connector.execSQL(UserCompanyTable);
            connector.execSQL(InsertAdminUser);
            connector.execSQL(CreateSettingsTbl);

            connector = null;
        }
        public static void InsertTemplates()
        {
            NGSConnector connector = new NGSConnector();

            connector.Connect();

            connector.execSQL(insertDocumentFlow);

            connector.execSQL(insertDocumentFlowAssignment1);
            connector.execSQL(insertDocumentFlowAssignment2);
            connector.execSQL(insertDocumentFlowAssignment3);
            connector.execSQL(insertDocumentFlowAssignment4);
            connector.execSQL(insertDocumentFlowAssignment5);
            connector.execSQL(insertDocumentFlowAssignment6);
            connector.execSQL(insertDocumentFlowAssignment7);
            connector.execSQL(insertDocumentFlowAssignment8);
            connector.execSQL(insertDocumentFlowAssignment9);
            connector.execSQL(insertDocumentFlowAssignment10);
            connector.execSQL(insertDocumentFlowAssignment11);


            List<System.Data.SQLite.SQLiteParameter> paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/Oswiadczenie_IZIS.htm")));
            connector.execSQL(insertDocument1, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/Oswiadczenie_odpowiedzialnosc_za_wyposazenie.htm")));
            connector.execSQL(insertDocument2, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/Oswiadczenie_Polityka_Bezpieczenstwa.htm")));
            connector.execSQL(insertDocument3, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/Oswiadczenie_Polityka_i_IZIS.htm")));
            connector.execSQL(insertDocument4, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/Oswiadczenie_procedury.htm")));
            connector.execSQL(insertDocument5, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/Oswiadczenie_zachowanie_tajemnicy_DO_i_informacji_o_zabezpieczeniu.htm")));
            connector.execSQL(insertDocument6, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/Powierzenie_komputer.htm")));
            connector.execSQL(insertDocument7, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/Protokol_szyfrowana_pamiec.htm")));
            connector.execSQL(insertDocument8, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/Protokol_telefon.htm")));
            connector.execSQL(insertDocument9, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/zgoda_dziecko.htm")));
            connector.execSQL(insertDocument10, paramList);

            paramList = new List<System.Data.SQLite.SQLiteParameter>();
            paramList.Add(new System.Data.SQLite.SQLiteParameter("@DocumentText", GetDocumentString(@"C:/Pfizer/NGS_Document/Dokuemnty/Word/NewHtml/zgoda_na_wizerunek.htm")));
            connector.execSQL(insertDocument11, paramList);
        }