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);
}