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