public bool CSQL_AddDevice(CDevice device)
{
string sql = "INSERT INTO devices VALUES ('" +
device.DeviceID + "', '" +
device.DeviceDescription + "', '" +
device.DeviceLocation + "', '" +
device.DeviceServer + "', '" +
device.DeviceServerSubDir + "');";
SqliteCommand dbhCmd;
int num_recs = 0;
if (CSQL_Connected ()) {
dbhCmd = new SqliteCommand (sql, dbh);
num_recs = dbhCmd.ExecuteNonQuery ();
if (num_recs > 0) {
CSQL_AddDeviceLogFileDescription (device, dbhCmd.Connection);
}
}
return false;
}
public bool CSQL_AddDevice(CDevice device)
{
string sql = "INSERT INTO devices VALUES ('" +
device.DeviceID + "', '" +
device.DeviceDescription + "', '" +
device.DeviceLocation + "', '" +
device.DeviceServer + "', '" +
device.DeviceServerSubDir + "');";
SqliteCommand dbhCmd;
int num_recs = 0;
if (CSQL_Connected())
{
dbhCmd = new SqliteCommand(sql, dbh);
num_recs = dbhCmd.ExecuteNonQuery();
if (num_recs > 0)
{
CSQL_AddDeviceLogFileDescription(device, dbhCmd.Connection);
}
}
return(false);
}
private bool CSQL_AddDeviceLogFileDescription(CDevice device, SqliteConnection hconn)
{
string sql = null;
SqliteCommand dbhCmd = null;
int num_recs = 0;
for (int i = 0; i < device.DeviceFileDescription.Count; i++)
{
CDeviceFileDescription descr = (CDeviceFileDescription)device.DeviceFileDescription [i];
sql = "INSERT INTO device_logfile_descr VALUES ('" +
descr.DeviceCodeType + "', '" +
descr.DeviceCodeDescription + "', '" +
descr.DeviceCode + "', " +
i + ", '" +
device.DeviceID + "');";
dbhCmd = new SqliteCommand(sql, hconn);
num_recs = dbhCmd.ExecuteNonQuery();
if (num_recs == 0)
{
return(false);
}
}
return(true);
}
public int CLogFile_Get_Y_Axis_Code_Index(CDevice device)
{
CDeviceFileDescription _descr = null;
for (int i = 0; i < device.DeviceFileDescription.Count; i++)
{
// Find the log time and return the index.
_descr = (CDeviceFileDescription)device.DeviceFileDescription [i];
if (_descr.DeviceCode == "CURTEMP")
{
_logTimeIndex = i;
return(i);
}
}
return(-1);
}
public bool CSQL_UpdateDevice(CDevice device)
{
string sql_update_device = "UPDATE devices " +
"SET device_id = '" + device.DeviceID + "', " +
"device_descr = '" + device.DeviceDescription + "', " +
"device_location = '" + device.DeviceLocation + "', " +
"device_server = '" + device.DeviceServer + "', " +
"device_server_subdir = '" + device.DeviceServerSubDir + "' " +
"WHERE device_id like '" + device.OldDeviceID + "';";
string sql_remove_logfile_descr = "DELETE FROM device_logfile_descr " +
"WHERE device_id like '" + device.OldDeviceID + "';";
SqliteCommand dbhCmd = null;
SqliteTransaction Tr = null;
Console.WriteLine("SQL -> " + sql_update_device);
if (CSQL_Connected())
{
/*
* UPDATE DEVICE SETTINGS
*/
dbhCmd = new SqliteCommand(sql_update_device, dbh);
Tr = dbh.BeginTransaction();
dbhCmd.ExecuteNonQuery();
/*
* UPDATE logfile description by first removing all and
* then replacing them with the new description.
*/
dbhCmd = new SqliteCommand(sql_remove_logfile_descr, dbh);
dbhCmd.ExecuteNonQuery();
CSQL_AddDeviceLogFileDescription(device, Tr.Connection);
Tr.Commit();
}
return(true);
}
public CDevice CSQL_GetDevice(string device_id)
{
//TODO: Finish CSQL_GetDevice implementation.
string sql_device = "SELECT * FROM devices " +
"WHERE devices.device_id = '" + device_id + "';";
string sql_device_descr = "SELECT * FROM device_logfile_descr " +
"WHERE device_logfile_descr.device_id = '" + device_id + "' " +
"ORDER BY device_logfile_descr.device_logfile_order;";
CDevice _device = null;
ArrayList _ar_device_logfile_descr;
CDeviceFileDescription _device_file_descr = null;
SqliteCommand dbhCmd = null;
SqliteDataReader dbhReader = null;
if (CSQL_Connected())
{
dbhCmd = new SqliteCommand(sql_device, dbh);
dbhReader = dbhCmd.ExecuteReader();
if (dbhReader.HasRows)
{
dbhReader.Read();
_device = new CDevice(dbhReader.GetString((int)tbl_devices.DEVICE_ID),
dbhReader.GetString((int)tbl_devices.DEVICE_DESCR),
dbhReader.GetString((int)tbl_devices.DEVICE_LOCATION),
dbhReader.GetString((int)tbl_devices.DEVICE_SERVER),
dbhReader.GetString((int)tbl_devices.DEVICE_SERVER_SUBDIR));
//Get device log file description.
dbhCmd = new SqliteCommand(sql_device_descr, dbh);
dbhReader = dbhCmd.ExecuteReader();
if (dbhReader.HasRows)
{
_ar_device_logfile_descr = new ArrayList();
while (dbhReader.Read())
{
_device_file_descr = new CDeviceFileDescription
(
dbhReader.GetString((int)tbl_device_logfile_descr.DEVICE_SENSOR_CODE),
dbhReader.GetString((int)tbl_device_logfile_descr.DEVICE_SENSOR_VALUE_DESCR),
dbhReader.GetString((int)tbl_device_logfile_descr.DEVICE_SENSOR_VALUE_TYPES)
);
_ar_device_logfile_descr.Add(_device_file_descr);
}
_device.DeviceFileDescription = _ar_device_logfile_descr;
}
else
{
cleanup();
return(_device);
}
}
else
{
cleanup();
return(null);
}
}
else
{
cleanup();
return(null);
}
return(_device);
}
public int CLogFile_Get_Y_Axis_Code_Index( CDevice device )
{
CDeviceFileDescription _descr = null;
for (int i = 0; i < device.DeviceFileDescription.Count; i++) {
// Find the log time and return the index.
_descr = (CDeviceFileDescription)device.DeviceFileDescription [i];
if (_descr.DeviceCode == "CURTEMP") {
_logTimeIndex = i;
return i;
}
}
return -1;
}
private void populate_device_settings( CDevice device )
{
//TODO: Fix broken bits for device settings population <- cboServers.
entDeviceID.Text = device.DeviceID;
entDeviceDescription.Text = device.DeviceDescription;
entDeviceLocation.Text = device.DeviceLocation;
entDeviceServerSubDir.Text = device.DeviceServerSubDir;
// Do cboDeviceSever
populate_server_combo ();
TreeIter iter;
cboDeviceServer.Model.GetIterFirst (out iter);
string server = null;
while ( (server = (string)cboDeviceServer.Model.GetValue (iter, 0)) != null) {
string[] server_split = server.Split ('\t');
if ( server_split[0] == device.DeviceServer || server_split[1] == device.DeviceServer )
break;
cboDeviceServer.Model.IterNext (ref iter);
}
cboDeviceServer.SetActiveIter (iter);
}
private void populate_device_file_descr( CDevice device )
{
ar_file_description = device.DeviceFileDescription;
populate_log_file_columns ();
}
public bool CSQL_UpdateDevice( CDevice device )
{
string sql_update_device = "UPDATE devices " +
"SET device_id = '" + device.DeviceID + "', " +
"device_descr = '" + device.DeviceDescription + "', " +
"device_location = '" + device.DeviceLocation + "', " +
"device_server = '" + device.DeviceServer + "', " +
"device_server_subdir = '" + device.DeviceServerSubDir + "' " +
"WHERE device_id like '" + device.OldDeviceID + "';";
string sql_remove_logfile_descr = "DELETE FROM device_logfile_descr " +
"WHERE device_id like '" + device.OldDeviceID + "';";
SqliteCommand dbhCmd = null;
SqliteTransaction Tr = null;
Console.WriteLine ("SQL -> " + sql_update_device);
if (CSQL_Connected ()) {
/*
* UPDATE DEVICE SETTINGS
*/
dbhCmd = new SqliteCommand (sql_update_device, dbh);
Tr = dbh.BeginTransaction ();
dbhCmd.ExecuteNonQuery ();
/*
* UPDATE logfile description by first removing all and
* then replacing them with the new description.
*/
dbhCmd = new SqliteCommand (sql_remove_logfile_descr, dbh);
dbhCmd.ExecuteNonQuery ();
CSQL_AddDeviceLogFileDescription (device, Tr.Connection);
Tr.Commit ();
}
return true;
}
private void build_popups()
{
/** ====================
* DO SERVER MENU
* ====================
*/
mnu_add_server.ButtonReleaseEvent += delegate(object o, ButtonReleaseEventArgs args) {
clear_server_settings();
c_current_server = new CServer();
c_current_server.Update = false;
nbFrames.CurrentPage = (int)nb_Notebook_Pages.SERVER_SETTINGS;
};
mnu_del_server.ButtonReleaseEvent += delegate(object o, ButtonReleaseEventArgs args) {
mnu_server.Popdown();
MessageDialog dlg = new MessageDialog(this,DialogFlags.DestroyWithParent, MessageType.Question, ButtonsType.YesNo,
"Are you sure you want to delete the Server \n" +
"and all it's data?", 0);
ResponseType res = (ResponseType)dlg.Run();
dlg.Destroy();
if (res == ResponseType.Yes) {
ListStore store = (ListStore) ivServerBrowser.Model;
TreePath[] path = ivServerBrowser.SelectedItems;
TreeIter iter;
store.GetIter (out iter, path[0]);
if (curTreePathItem.value != null) {
csql.CSQL_DeleteServer (curTreePathItem.value);
store.Remove(ref iter);
}
}
};
mnu_edit_server.ButtonReleaseEvent += delegate(object o, ButtonReleaseEventArgs args) {
populate_server_settings();
};
mnu_server.Add (mnu_server_menu_title);
mnu_server.Add (new SeparatorMenuItem());
mnu_server.Add (mnu_add_server);
mnu_server.Add (mnu_del_server);
mnu_server.Add (mnu_edit_server);
mnu_server.ShowAll ();
mnu_del_server.Visible = false;
mnu_edit_server.Visible = false;
/*
* ==============
* DO DEVICE MENU
* ==============
*/
mnu_add_device.ButtonReleaseEvent += delegate(object o, ButtonReleaseEventArgs args) {
clear_device_settings();
populate_server_combo();
populate_log_file_columns();
c_current_device = new CDevice();
c_current_device.Update = false;
nbFrames.CurrentPage = (int)nb_Notebook_Pages.DEVICE_SETTINGS;
};
mnu_del_device.ButtonReleaseEvent += delegate(object o, ButtonReleaseEventArgs args) {
mnu_device.Popdown();
MessageDialog dlg = new MessageDialog (this, DialogFlags.DestroyWithParent, MessageType.Question,
ButtonsType.YesNo, "Are you woud like to delete the device and all it's records?", 0);
ResponseType res = (ResponseType)dlg.Run();
if (res == ResponseType.Yes) {
ListStore store = (ListStore)ivDeviceBrowser.Model;
TreePath[] path = ivDeviceBrowser.SelectedItems;
TreeIter iter;
store.GetIter (out iter, path[0]);
if (curTreePathItem.value != null) {
if (csql.CSQL_DeleteDevice (curTreePathItem.value))
store.Remove (ref iter);
}
}
dlg.Destroy();
};
mnu_edit_device.ButtonReleaseEvent += delegate(object o, ButtonReleaseEventArgs args) {
edit_device();
};
mnu_device_menu_title.CanDefault = false;
mnu_device_menu_title.CanFocus = false;
mnu_device.Add (mnu_device_menu_title);
mnu_device.Add (new SeparatorMenuItem ());
mnu_device.Add (mnu_add_device);
mnu_device.Add (mnu_del_device);
mnu_device.Add (mnu_edit_device);
mnu_device.ShowAll ();
mnu_del_device.Visible = false;
mnu_edit_device.Visible = false;
/*
* ====================
* DO LOGFILE MENU
* ==================
*/
}
protected void OnIvDeviceBrowserItemActivated(object o, ItemActivatedArgs args)
{
//TODO: Implement device browser item activated for Ftp.
/**
* - Get item activated from browser model
* - Get item activated from sqlite
* - Get Server for selected Device
* - Get File list
* - Build file list model for ftp browser.
*/
// Get device details from model and sqlite.
TreePath[] path = ivDeviceBrowser.SelectedItems;
TreeIter iter;
string _device_key = null;
ArrayList ftp_file_list = new ArrayList();
ivDeviceBrowser.Model.GetIter (out iter, path [0]);
_device_key = (string)ivDeviceBrowser.Model.GetValue (iter, 0);
c_current_device = csql.CSQL_GetDevice (_device_key);
c_current_server = csql.CSQL_GetServer (c_current_device.DeviceServer);
c_current_ftp_session = new CFTP (c_current_server, c_current_device);
if (c_current_server.ServerProtocol == "file://") {
string __dir_to_list = c_current_device.DeviceServerSubDir;
foreach (string s_file in Directory.EnumerateFiles (__dir_to_list)) {
string c_file = s_file;
if (c_current_platform == PlatformID.Win32NT)
c_file = s_file.Substring (2);
string[] file_name = c_file.Split (System.IO.Path.DirectorySeparatorChar);
ftp_file_list.Add (file_name[(file_name.Length - 1)]);
}
} else {
try {
ftp_file_list = c_current_ftp_session.CFTP_GetFileList ();
} catch (WebException e) {
if (e.Status == WebExceptionStatus.ProtocolError) {
string msg = "Please check you Server and Device directory settings.";
new Gtk.MessageDialog (null, Gtk.DialogFlags.Modal, Gtk.MessageType.Error,
Gtk.ButtonsType.Ok, e.Message + "\n" + msg, 0).Run ();
} else {
Console.WriteLine (e.Status + "\n" + e.Message + "\n" + e.Source);
}
return;
}
}
if (ftp_file_list != null) {
populate_FtpFileBrowser (ftp_file_list);
}
}
public CFTP( CServer server, CDevice device )
{
_server = server;
_device = device;
}
private bool CSQL_AddDeviceLogFileDescription(CDevice device, SqliteConnection hconn)
{
string sql = null;
SqliteCommand dbhCmd = null;
int num_recs = 0;
for (int i = 0; i < device.DeviceFileDescription.Count; i++) {
CDeviceFileDescription descr = (CDeviceFileDescription)device.DeviceFileDescription [i];
sql = "INSERT INTO device_logfile_descr VALUES ('" +
descr.DeviceCodeType + "', '" +
descr.DeviceCodeDescription + "', '" +
descr.DeviceCode + "', " +
i + ", '" +
device.DeviceID + "');";
dbhCmd = new SqliteCommand (sql, hconn);
num_recs = dbhCmd.ExecuteNonQuery ();
if (num_recs == 0)
return false;
}
return true;
}
private void edit_device()
{
// Get device details and populate device settings.
TreePath[] path = ivDeviceBrowser.SelectedItems;
TreeIter iter;
string _device_key = null;
mnu_device.Popdown ();
ivDeviceBrowser.Model.GetIter (out iter, path[0]);
_device_key = (string)ivDeviceBrowser.Model.GetValue (iter, 0);
c_current_device = csql.CSQL_GetDevice (_device_key);
populate_device_settings (c_current_device);
populate_device_file_descr (c_current_device);
c_current_device.Update = true;
nbFrames.CurrentPage = (int)nb_Notebook_Pages.DEVICE_SETTINGS;
}
public CFTP(CServer server, CDevice device)
{
_server = server;
_device = device;
}
public CDevice CSQL_GetDevice( string device_id )
{
//TODO: Finish CSQL_GetDevice implementation.
string sql_device = "SELECT * FROM devices " +
"WHERE devices.device_id = '" + device_id + "';";
string sql_device_descr = "SELECT * FROM device_logfile_descr " +
"WHERE device_logfile_descr.device_id = '" + device_id + "' " +
"ORDER BY device_logfile_descr.device_logfile_order;";
CDevice _device = null;
ArrayList _ar_device_logfile_descr;
CDeviceFileDescription _device_file_descr = null;
SqliteCommand dbhCmd = null;
SqliteDataReader dbhReader = null;
if (CSQL_Connected ()) {
dbhCmd = new SqliteCommand (sql_device, dbh);
dbhReader = dbhCmd.ExecuteReader ();
if (dbhReader.HasRows) {
dbhReader.Read ();
_device = new CDevice (dbhReader.GetString ((int)tbl_devices.DEVICE_ID),
dbhReader.GetString ((int)tbl_devices.DEVICE_DESCR),
dbhReader.GetString ((int)tbl_devices.DEVICE_LOCATION),
dbhReader.GetString ((int)tbl_devices.DEVICE_SERVER),
dbhReader.GetString ((int)tbl_devices.DEVICE_SERVER_SUBDIR));
//Get device log file description.
dbhCmd = new SqliteCommand (sql_device_descr, dbh);
dbhReader = dbhCmd.ExecuteReader ();
if (dbhReader.HasRows) {
_ar_device_logfile_descr = new ArrayList ();
while (dbhReader.Read()) {
_device_file_descr = new CDeviceFileDescription
(
dbhReader.GetString ((int)tbl_device_logfile_descr.DEVICE_SENSOR_CODE),
dbhReader.GetString ((int)tbl_device_logfile_descr.DEVICE_SENSOR_VALUE_DESCR),
dbhReader.GetString ((int)tbl_device_logfile_descr.DEVICE_SENSOR_VALUE_TYPES)
);
_ar_device_logfile_descr.Add (_device_file_descr);
}
_device.DeviceFileDescription = _ar_device_logfile_descr;
} else {
cleanup ();
return _device;
}
} else {
cleanup ();
return null;
}
} else {
cleanup ();
return null;
}
return _device;
}