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