public WDBSQLite(string Path, string UI, WDBTraceLog.TraceLog WDBTraceLogObj)
{
SQLFile = Path;
WDBTraceLogObj.WriteToLog(ThreadName, ObjectName, GetCurrentMethod(), "Start Call: WDBSQLite()");
this.TraceLogObj = WDBTraceLogObj;
if (!File.Exists(Path))
{
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "Start of Create SQLite DB. " + Path);
if (UI.ToLower() == "client")
{
this.conn = CreateClientDB(Path);
}
else if (UI.ToLower() == "uploader")
{
this.conn = CreateUploadDB(Path);
}
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "End of Create SQLite DB." + Path);
}
else
{
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "SQLite data source=" + Path);
conn = new SQLiteConnection("data source=" + Path);
conn.Open();
}
TraceLogObj.WriteToLog(ThreadName, ObjectName, GetCurrentMethod(), "End Call: WDBSQLite()");
}
public WDBSQLite(string Path, string UI, WDBTraceLog.TraceLog WDBTraceLogObj)
{
SQLFile = Path;
WDBTraceLogObj.WriteToLog(ThreadName, ObjectName, GetCurrentMethod(), "Start Call: WDBSQLite()");
this.TraceLogObj = WDBTraceLogObj;
if (!File.Exists(Path))
{
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "Start of Create SQLite DB. " + Path);
if (UI.ToLower() == "client")
{
this.conn = CreateClientDB(Path);
}
else if (UI.ToLower() == "uploader")
{
this.conn = CreateUploadDB(Path);
}
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "End of Create SQLite DB." + Path);
}
else
{
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "SQLite data source=" + Path);
conn = new SQLiteConnection("data source=" + Path);
conn.Open();
}
TraceLogObj.WriteToLog(ThreadName, ObjectName, GetCurrentMethod(), "End Call: WDBSQLite()");
}
public WDBCommon(WDBSQLite.WDBSQLite ArgWDBSQliteObj, WDBAPI.WDBAPI WDBAPIObj, WDBTraceLog.TraceLog WDBTraceLogObj)
{
WDBTraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "Start Call: WDBCommon()");
this.WDBAPIObj = WDBAPIObj;
TraceLogObj = WDBTraceLogObj;
WDBSQLiteObj = ArgWDBSQliteObj;
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "Start Call: WDBCommon()");
}
public WDBCommon(WDBSQLite.WDBSQLite ArgWDBSQliteObj, WDBAPI.WDBAPI WDBAPIObj, WDBTraceLog.TraceLog WDBTraceLogObj)
{
WDBTraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "Start Call: WDBCommon()");
this.WDBAPIObj = WDBAPIObj;
TraceLogObj = WDBTraceLogObj;
WDBSQLiteObj = ArgWDBSQliteObj;
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "Start Call: WDBCommon()");
}
private SQLiteConnection CreateDB(string DbFile)
{
TraceLogObj.WriteToLog(ThreadName, ObjectName, GetCurrentMethod(), "Start Call: CreateDB");
try
{
SQLiteConnection.CreateFile(DbFile);
}
catch (Exception e)
{
string DbPath = Path.GetDirectoryName(DbFile);
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "Failed to Create SQLite DB: " + e.Message.ToString());
Directory.CreateDirectory(DbPath);
SQLiteConnection.CreateFile(DbFile);
}
Debug.Write("Created Database: " + DbFile);
conn = new SQLiteConnection("data source=" + DbFile);
conn.Open();
TraceLogObj.WriteToLog(ThreadName, ObjectName, GetCurrentMethod(), "End Call: CreateDB");
return(conn);
}
public void initApi()
{
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "Start Function Call: Init API.");
WDBAPIObj.ApiCompiledPath = ApiCompiledPath;
//Debug.WriteLine(_ThreadName);
WDBSQLiteObj.ThreadName = _ThreadName;
WDBAPIObj.ThreadName = _ThreadName;
WDBAPIObj.ApiKey = ApiKey;
WDBAPIObj.Username = Username;
WDBAPIObj.DefaultImportTitle = DefaultImportTitle;
WDBAPIObj.DefaultImportNotes = DefaultImportNotes;
WDBAPIObj.UseDefaultImportValues = UseDefaultImportValues;
WDBAPIObj.LogPath = LogPath;
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), "End Function Call: Init API.");
}
public string ApiGetWaitingImports()
{
TraceLogObj.WriteToLog(ThreadName, ObjectName, GetCurrentMethod(), "Start Call: ApiGetWaitingImports");
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), ApiCompiledPath + "schedule.php ---- Get Waiting");
string response;
//Console.WriteLine("Upload FIle: " + UploadFile);
using (WebClient client = new WebClient())
{
NameValueCollection parameters = InitParameters();
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), parameters.Get("username"));
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), parameters.Get("apikey"));
parameters.Add("func", "waiting");
try
{
var responseBytes = client.UploadValues(ApiCompiledPath + "schedule.php", "POST", parameters);
response = Encoding.ASCII.GetString(responseBytes);
}catch (Exception e)
{
response = "Error";
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), e.Message);
}
TraceLogObj.WriteToLog(_ThreadName, ObjectName, GetCurrentMethod(), response);
}
TraceLogObj.WriteToLog(ThreadName, ObjectName, GetCurrentMethod(), "End Call: ApiGetWaitingImports");
return(response);
}