public Client(SQLServerConnector sqlServerConnector, SQLiteConnector sqLiteConnector, Enum connectivityState) { if ((ConnectivityState)connectivityState == ConnectivityState.Offline) { _isOnline = false; } else { _isOnline = true; } //bool? firstTimeClient = sqLiteConnector.IsNotEmpty(tableName: "Client"); bool firstTimeClient = false; if (_isOnline) { if (firstTimeClient == true) { _clientID = sqlServerConnector.GetNewClientId(); _clientName = System.Security.Principal.WindowsIdentity.GetCurrent().Name; //BUG _clientPublicIP = "publicIP"; _clientPrivateIP = "privateIP"; //write to sqlite all data singleton _cronExpression = sqlServerConnector.GetValidCronExpr(); sqlServerConnector.ExecuteInsertQuery("INSERT INTO ...."); sqLiteConnector.ExecuteInsertQuery("INSERT INTO ...."); } else if (firstTimeClient == false) { //laaater : update IPs if they're different write them to sqlite and server? SetClientFromSqlite(sqLiteConnector); } IsSet = true; } else { if (firstTimeClient == true) { IsSet = false; _clientID = -1; //BUG _clientPrivateIP = _clientPublicIP = "Not Connected"; //... // } else { //instantiante from sqlite SetClientFromSqlite(sqLiteConnector); IsSet = true; } } }
public DatabaseDirectory(int clientID) { _clientID = clientID; SqlServerConnector = new SQLServerConnector(@"Data Source=DESKTOP-DJONOS6\SQLEXPRESS;Initial Catalog=PFE;Integrated Security=True;Connection Timeout = 5"); SqlLiteConnector = new SQLiteConnector(@"Data source = ..\..\localSqlite\localDatabase.db;Version=3;"); }
private void InstantiateSQLServerConnection() { try { _sqlServerConnector = new SQLServerConnector(_sqlServerConnString); } catch (Exception e) { Debug.WriteLine("SyncEngine::InstantiateSQLServer() -> " + e.Message); _sqlServerConnector = null; throw e; } }
public static void SetConnectors(SQLServerConnector sqlServerConnector = null, SQLiteConnector sqlLiteConnector = null) { DatabaseDirectory.SqlServerConnector = sqlServerConnector; DatabaseDirectory.SqlLiteConnector = sqlLiteConnector; }