/// <summary>
/// Clear old folders
/// </summary>
void CleanOldTempFolders()
{
var folders = Directory.GetDirectories(m_tempFolder);
Int64 pv = 0;
Int64.TryParse(GetPOSVersion(), out pv);
foreach (var folder in folders)
{
Int64 vf = 0;
string f = folder.Substring(m_tempFolder.Length);
f = f.Replace("\\", "");
Int64.TryParse(f, out vf);
if (vf < pv)
{
try
{
Directory.Delete(folder, true);
}
catch (Exception ex)
{
POSFtpClient.LogMessage(ex);
}
}
}
}
/// <summary>
/// Run all sql files in a folder
/// </summary>
/// <param name="folder"></param>
void RunPatchSql(string folder, string dbFile)
{
string[] sqlFiles = Directory.GetFiles(folder, "*.sql");
foreach (var filePath in sqlFiles)
{
string sqlCommand = File.ReadAllText(filePath);
try
{
string connString = string.Format(CONN_STRING, dbFile);
using (SQLiteConnection conn = new SQLiteConnection(connString))
{
using (var cmd = new SQLiteCommand(sqlCommand, conn))
{
cmd.CommandType = CommandType.Text;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
POSFtpClient.LogMessage(ex);
}
}
}