public void Save() { string sql = @"INSERT INTO Document VALUES( @CompanyGUID, @DocumentGUID, @DocumentName, @DocumentText, @CreatedDateTime, @CreatedBy, @LastModifiedDateTime, @LastModifiedBy, @PrintedDateTime, @DocumentEndDateTime)"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); paramList.Add(new SQLiteParameter("@DocumentGUID", DocumentGUID)); paramList.Add(new SQLiteParameter("@DocumentName", DocumentName)); paramList.Add(new SQLiteParameter("@DocumentText", DocumentText)); paramList.Add(new SQLiteParameter("@CreatedDateTime", CreatedDateTime)); paramList.Add(new SQLiteParameter("@CreatedBy", CreatedBy)); paramList.Add(new SQLiteParameter("@LastModifiedDateTime", LastModifiedDateTime)); paramList.Add(new SQLiteParameter("@LastModifiedBy", LastModifiedBy)); paramList.Add(new SQLiteParameter("@PrintedDateTime", PrintedDateTime)); paramList.Add(new SQLiteParameter("@DocumentEndDateTime", DocumentEndDateTime)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); GlobalVariables.Log("Użytkownik stowrzył nowy dokument: " + DocumentName + " document id: " + DocumentGUID); connector = null; }
public void Update() { string sql = @"UPDATE Document SET DocumentName = @DocumentName ,DocumentText = @DocumentText ,CreatedDateTime = @CreatedDateTime ,CreatedBy = @CreatedBy ,LastModifiedDateTime = @LastModifiedDateTime ,LastModifiedBy = @LastModifiedBy ,PrintedDateTime = @PrintedDateTime ,DocumentEndDateTime = @DocumentEndDateTime WHERE CompanyGUID = @CompanyGUID AND DocumentGUID = @DocumentGUID "; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); paramList.Add(new SQLiteParameter("@DocumentGUID", DocumentGUID)); paramList.Add(new SQLiteParameter("@DocumentName", DocumentName)); paramList.Add(new SQLiteParameter("@DocumentText", DocumentText)); paramList.Add(new SQLiteParameter("@CreatedDateTime", CreatedDateTime)); paramList.Add(new SQLiteParameter("@CreatedBy", CreatedBy)); paramList.Add(new SQLiteParameter("@LastModifiedDateTime", LastModifiedDateTime)); paramList.Add(new SQLiteParameter("@LastModifiedBy", LastModifiedBy)); paramList.Add(new SQLiteParameter("@PrintedDateTime", PrintedDateTime)); paramList.Add(new SQLiteParameter("@DocumentEndDateTime", DocumentEndDateTime)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); GlobalVariables.Log("Użytkownik zaktualizował dokument: " + DocumentName + " document id: " + DocumentGUID); connector = null; }
public void Update() { string sql = @"UPDATE RejestrCzynnosci SET NazwaAdministratoraDanych = @NazwaAdministratoraDanych, WspolAdministratorzy = @WspolAdministratorzy, InsepktorDanychOsobowych = @InsepktorDanychOsobowych, NazwaZbioruDanych = @NazwaZbioruDanych, RodzajCzynnosci = @RodzajCzynnosci, TytulCzynnosci = @TytulCzynnosci, CelPrzetwarzania = @CelPrzetwarzania, OpisKategoriiOsob = @OpisKategoriiOsob, KategorieOdbiorcow = @KategorieOdbiorcow, KategorieDanychOsobowych = @KategorieDanychOsobowych, InformarcjeOPrzekazaniuDoPanstwaTrzeciego = @InformarcjeOPrzekazaniuDoPanstwaTrzeciego, PlanowanyTerminUsuniecia = @PlanowanyTerminUsuniecia, OpisTechniczny = @OpisTechniczny, TypRejestruCzynnosci = @TypRejestruCzynnosci, Uwagi = @Uwagi, CreatedBy = @CreatedBy, CreatedDateTime = @CreatedDateTime, LastModifiedBy = @LastModifiedBy, LastModifiedDateTime = @LastModifiedDateTime WHERE RejestrCzynnosciGUID = @RejestrCzynnosciGUID"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@RejestrCzynnosciGUID", RejestrCzynnosciGUID)); paramList.Add(new SQLiteParameter("@NazwaAdministratoraDanych", NazwaAdministratoraDanych)); paramList.Add(new SQLiteParameter("@WspolAdministratorzy", WspolAdministratorzy)); paramList.Add(new SQLiteParameter("@InsepktorDanychOsobowych", InsepktorDanychOsobowych)); paramList.Add(new SQLiteParameter("@NazwaZbioruDanych", NazwaZbioruDanych)); paramList.Add(new SQLiteParameter("@RodzajCzynnosci", RodzajCzynnosci)); paramList.Add(new SQLiteParameter("@TytulCzynnosci", TytulCzynnosci)); paramList.Add(new SQLiteParameter("@CelPrzetwarzania", CelPrzetwarzania)); paramList.Add(new SQLiteParameter("@OpisKategoriiOsob", OpisKategoriiOsob)); paramList.Add(new SQLiteParameter("@KategorieOdbiorcow", KategorieOdbiorcow)); paramList.Add(new SQLiteParameter("@KategorieDanychOsobowych", KategorieDanychOsobowych)); paramList.Add(new SQLiteParameter("@InformarcjeOPrzekazaniuDoPanstwaTrzeciego", InformarcjeOPrzekazaniuDoPanstwaTrzeciego)); paramList.Add(new SQLiteParameter("@PlanowanyTerminUsuniecia", PlanowanyTerminUsuniecia)); paramList.Add(new SQLiteParameter("@OpisTechniczny", OpisTechniczny)); paramList.Add(new SQLiteParameter("@Uwagi", Uwagi)); paramList.Add(new SQLiteParameter("@TypRejestruCzynnosci", TypRejestruCzynnosci)); paramList.Add(new SQLiteParameter("@CreatedBy", CreatedBy)); paramList.Add(new SQLiteParameter("@CreatedDateTime", CreatedDateTime)); paramList.Add(new SQLiteParameter("@LastModifiedBy", LastModifiedBy)); paramList.Add(new SQLiteParameter("@LastModifiedDateTime", LastModifiedDateTime)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void Save() { string sql = @"INSERT INTO RejestrCzynnosci VALUES( @RejestrCzynnosciGUID, @NazwaAdministratoraDanych, @WspolAdministratorzy, @InsepktorDanychOsobowych, @NazwaZbioruDanych, @RodzajCzynnosci, @TytulCzynnosci, @CelPrzetwarzania, @OpisKategoriiOsob, @KategorieOdbiorcow, @KategorieDanychOsobowych, @InformarcjeOPrzekazaniuDoPanstwaTrzeciego, @PlanowanyTerminUsuniecia, @OpisTechniczny, @Uwagi, @TypRejestruCzynnosci, @CreatedBy, @CreatedDateTime, @LastModifiedBy, @LastModifiedDateTime, @CompanyGUID )"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@RejestrCzynnosciGUID", RejestrCzynnosciGUID)); paramList.Add(new SQLiteParameter("@NazwaAdministratoraDanych", NazwaAdministratoraDanych)); paramList.Add(new SQLiteParameter("@WspolAdministratorzy", WspolAdministratorzy)); paramList.Add(new SQLiteParameter("@InsepktorDanychOsobowych", InsepktorDanychOsobowych)); paramList.Add(new SQLiteParameter("@NazwaZbioruDanych", NazwaZbioruDanych)); paramList.Add(new SQLiteParameter("@RodzajCzynnosci", RodzajCzynnosci)); paramList.Add(new SQLiteParameter("@TytulCzynnosci", TytulCzynnosci)); paramList.Add(new SQLiteParameter("@CelPrzetwarzania", CelPrzetwarzania)); paramList.Add(new SQLiteParameter("@OpisKategoriiOsob", OpisKategoriiOsob)); paramList.Add(new SQLiteParameter("@KategorieOdbiorcow", KategorieOdbiorcow)); paramList.Add(new SQLiteParameter("@KategorieDanychOsobowych", KategorieDanychOsobowych)); paramList.Add(new SQLiteParameter("@InformarcjeOPrzekazaniuDoPanstwaTrzeciego", InformarcjeOPrzekazaniuDoPanstwaTrzeciego)); paramList.Add(new SQLiteParameter("@PlanowanyTerminUsuniecia", PlanowanyTerminUsuniecia)); paramList.Add(new SQLiteParameter("@OpisTechniczny", OpisTechniczny)); paramList.Add(new SQLiteParameter("@TypRejestruCzynnosci", TypRejestruCzynnosci)); paramList.Add(new SQLiteParameter("@Uwagi", Uwagi)); paramList.Add(new SQLiteParameter("@CreatedBy", CreatedBy)); paramList.Add(new SQLiteParameter("@CreatedDateTime", CreatedDateTime)); paramList.Add(new SQLiteParameter("@LastModifiedBy", LastModifiedBy)); paramList.Add(new SQLiteParameter("@LastModifiedDateTime", LastModifiedDateTime)); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void Delete() { List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); NGSConnector connector = new NGSConnector(); string sql = @"DELETE FROM DocumentTemplate WHERE DocumentTemplateGUID In (SELECT DocumentTemplateGUID FROM DocumentTemplateFlowAssignment WHERE DocumentTemplateFlowGUID= @DocumentTemplateFlowGUID)"; paramList.Add(new SQLiteParameter("@DocumentTemplateFlowGUID", DocumentTemplateFlowGUID)); connector.execSQL(sql, paramList); sql = @"DELETE FROM DocumentTemplateFlowAssignment WHERE DocumentTemplateFlowGUID = @DocumentTemplateFlowGUID"; paramList.Add(new SQLiteParameter("@DocumentTemplateFlowGUID", DocumentTemplateFlowGUID)); connector.execSQL(sql, paramList); sql = @"DELETE FROM DocumentTemplateFlow WHERE DocumentTemplateFlowGUID = @DocumentTemplateFlowGUID"; paramList.Add(new SQLiteParameter("@DocumentTemplateFlowGUID", DocumentTemplateFlowGUID)); connector.execSQL(sql, paramList); GlobalVariables.Log("Użytkownik usunął kategorie: " + DocumentTemplateFlowName + " id: " + DocumentTemplateFlowGUID); connector = null; }
public void DeleteSettings() { string sql = @"DELETE FROM Settings WHERE CompanyGUID = @CompanyGUID"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void RemoveAssignCompany(string companyGUID) { string sql = @"DELETE FROM CompanyUser WHERE CompanyGUID = @CompanyGUID AND UserGUID = @UserGUID"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", companyGUID)); paramList.Add(new SQLiteParameter("@UserGUID", UserGUID)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void Save() { string sql = @"INSERT INTO Magazyn VALUES(@KopertaGUID, @NrKoperty, @NrPlomby, @DataOdbioru, @GodzinaOdbioru, @DataKopii, @KopertaNrPro, @Przekazal, @Zwrocil, @NazwaKlienta, @NIP, @AdresKlienta, @KodPocztowy, @Miasto, @KonwojentImie, @KonwojentNazwisko, @DataZwrotu, @CompanyGUID )"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@KopertaGUID", KopertaGUID)); paramList.Add(new SQLiteParameter("@NrKoperty", NrKoperty)); paramList.Add(new SQLiteParameter("@NrPlomby", NrPlomby)); paramList.Add(new SQLiteParameter("@DataOdbioru", DataOdbioru)); paramList.Add(new SQLiteParameter("@GodzinaOdbioru", GodzinaOdbioru)); paramList.Add(new SQLiteParameter("@DataKopii", DataKopii)); paramList.Add(new SQLiteParameter("@KopertaNrPro", KopertaNrPro)); paramList.Add(new SQLiteParameter("@Przekazal", Przekazal)); paramList.Add(new SQLiteParameter("@Zwrocil", Zwrocil)); paramList.Add(new SQLiteParameter("@NazwaKlienta", NazwaKlienta)); paramList.Add(new SQLiteParameter("@NIP", NIP)); paramList.Add(new SQLiteParameter("@AdresKlienta", AdresKlienta)); paramList.Add(new SQLiteParameter("@KodPocztowy", KodPocztowy)); paramList.Add(new SQLiteParameter("@Miasto", Miasto)); paramList.Add(new SQLiteParameter("@KonwojentImie", KonwojentImie)); paramList.Add(new SQLiteParameter("@KonwojentNazwisko", KonwojentNazwisko)); paramList.Add(new SQLiteParameter("@DataZwrotu", DataZwrotu)); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void Delete() { string sql = @"DELETE FROM Magazyn WHERE CompanyGUID = @CompanyGUID"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", GlobalVariables.CurrentCompany.CompanyGUID)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void Update() { string sql = @"UPDATE Company SET CompanyName = @CompanyName WHERE CompanyGUID = @CompanyGUID"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); paramList.Add(new SQLiteParameter("@CompanyName", CompanyName)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void SavePassword(string userGUID, string userPassword) { string sql = @"UPDATE User SET UserPassword = @UserPassword WHERE UserGUID = @UserGUID"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@UserGUID", userGUID)); paramList.Add(new SQLiteParameter("@UserPassword", GlobalVariables.GetMD5(userPassword))); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); }
public void Save() { string sql = @"INSERT INTO Company VALUES( @CompanyGUID, @CompanyName )"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); paramList.Add(new SQLiteParameter("@CompanyName", CompanyName)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void Delete() { string sql = @"DELETE FROM DocumentField WHERE CompanyGUID = @CompanyGUID AND DocumentGUID = @DocumentGUID AND FieldName = @FieldName "; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); paramList.Add(new SQLiteParameter("@DocumentGUID", DocumentGUID)); paramList.Add(new SQLiteParameter("@FieldName", FieldName)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void SaveUser(string userGUID, string userName, string firstName, string lastName) { string sql = @"INSERT INTO User( UserGUID, UserName, FirstName, LastName ) Values( @UserGUID, @UserName, @FirstName, @LastName )"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@UserGUID", userGUID)); paramList.Add(new SQLiteParameter("@UserName", userName)); paramList.Add(new SQLiteParameter("@FirstName", firstName)); paramList.Add(new SQLiteParameter("@LastName", lastName)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); }
public void AssignCompany(string companyGUID) { RemoveAssignCompany(companyGUID); string sql = @"INSERT INTO CompanyUser VALUES( @CompanyUserGUID, @CompanyGUID, @UserGUID)"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", companyGUID)); paramList.Add(new SQLiteParameter("@UserGUID", UserGUID)); paramList.Add(new SQLiteParameter("@CompanyUserGUID", GlobalVariables.GetNewGUID())); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void Delete() { string sql = @"DELETE FROM Document WHERE CompanyGUID = @CompanyGUID AND DocumentGUID = @DocumentGUID"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); paramList.Add(new SQLiteParameter("@DocumentGUID", DocumentGUID)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); GlobalVariables.Log("Użytkownik usunął document id: " + DocumentGUID); connector = null; }
public void UpdateUser(string userGUID, string firstName, string lastName) { string sql = @"UPDATE User SET FirstName = @FirstName, LastName = @LastName WHERE UserGUID = @UserGUID"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@UserGUID", userGUID)); paramList.Add(new SQLiteParameter("@FirstName", firstName)); paramList.Add(new SQLiteParameter("@LastName", lastName)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); }
public void SaveSettings() { string sql = @"INSERT INTO Settings VALUES( @CompanyGUID, @SettingName, @SettingValue)"; NGSConnector connector = new NGSConnector(); foreach (KeyValuePair <String, String> keyPair in SettingList) { List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", CompanyGUID)); paramList.Add(new SQLiteParameter("@SettingName", keyPair.Key)); paramList.Add(new SQLiteParameter("@SettingValue", keyPair.Value)); connector.execSQL(sql, paramList); } connector = null; }
public void Save() { string sql = @"INSERT INTO DocumentTemplateFlow VALUES( @DocumentTemplateFlowGUID, @DocumentTemplateFlowName, @DocumentTemplateFlowType)"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@DocumentTemplateFlowGUID", DocumentTemplateFlowGUID)); paramList.Add(new SQLiteParameter("@DocumentTemplateFlowName", DocumentTemplateFlowName)); paramList.Add(new SQLiteParameter("@DocumentTemplateFlowType", DocumentTemplateFlowType)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); GlobalVariables.Log("Użytkownik stowrzył kategorie: " + DocumentTemplateFlowName + " id: " + DocumentTemplateFlowGUID); connector = null; }
public void SaveLog(string userGUID, string companyGUID, string logMessage, string logType) { string sql = @"INSERT INTO LogTable( LogGUID, LogDateTime, LogType, LogMessage, UserGUID, CompanyGUID ) Values( @LogGUID, @LogDateTime, @LogType, @LogMessage, @UserGUID, @CompanyGUID )"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@LogGUID", GlobalVariables.GetNewGUID())); paramList.Add(new SQLiteParameter("@LogDateTime", DateTime.Now)); paramList.Add(new SQLiteParameter("@LogType", logType)); paramList.Add(new SQLiteParameter("@LogMessage", logMessage)); paramList.Add(new SQLiteParameter("@UserGUID", userGUID)); paramList.Add(new SQLiteParameter("@CompanyGUID", companyGUID)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); }
public void Save() { string sql = @"INSERT INTO DocumentTemplateFlowAssignment VALUES( @DocumentTemplateFlowAssignmentGUID, @DocumentTemplateFlowGUID, @DocumentTemplateGUID, @DocumentPosition)"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@DocumentTemplateFlowAssignmentGUID", DocumentTemplateFlowAssignmentGUID)); paramList.Add(new SQLiteParameter("@DocumentTemplateFlowGUID", DocumentTemplateFlowGUID)); paramList.Add(new SQLiteParameter("@DocumentTemplateGUID", DocumentTemplateGUID)); paramList.Add(new SQLiteParameter("@DocumentPosition", DocumentPosition)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); //GlobalVariables.Log("Użytkownik stowrzył szablon: " + DocumentName + " id: " + DocumentTemplateGUID); connector = null; }