public void CreateRequireTableIfNotPresent(string buildingName)
{
string tableForChartDetail = "tbl_" + buildingName + "_chart_detail";
string tableForNode = "tbl_" + buildingName + "_node_value";
string tableForLine = "tbl_" + buildingName + "_line_value";
string tableFordevice = "tbl_" + buildingName + "_device_info_for_node";
string tableForInputStorageFromT3000 = "tbl_" + buildingName + "_input_storage_from_T3000";
string tableForValuesFromT3000 = "tbl_" + buildingName + "_node_data_related_T3000";
string tableMixNode = "tbl_" + buildingName + "_mix_node_info";
//These two tables are for comfort zone
string tableforComfortZoneDetail = "tbl_" + buildingName + "_comfort_zone_detail";
string tableForChartComfortZoneSetting = "tbl_" + buildingName + "_chart_comfort_zone_setting";
string databasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string databaseFile = databasePath + @"\db_psychrometric_project.s3db";
string connString = @"Data Source=" + databaseFile + ";Version=3;";
using (SQLiteConnection connection = new SQLiteConnection(connString))
{
connection.Open();
//--We also need to create table for particular data added..
//--MODIFIED by bbk: for bulling data from alex db (2016-nov-10/thrus/10:06AM)
// string sql3 = "create table IF NOT EXISTS " + tableForChartDetail + "(count INTEGER PRIMARY KEY AUTOINCREMENT ,chartID VARCHAR(255),chartName varchar(255),chart_respective_nodeID varchar(255),chart_respective_lineID varchar(255))";
string sql3 = "create table IF NOT EXISTS " + tableForChartDetail + "(count INTEGER PRIMARY KEY AUTOINCREMENT ,chartID VARCHAR(255),chartName varchar(255),chart_respective_nodeID varchar(255),chart_respective_lineID varchar(255),enableChartStatus varchar(255))";
SQLiteCommand command3 = new SQLiteCommand(sql3, connection);
command3.ExecuteNonQuery();
//for node info
//--Modified to new: This one was intial query
//string sql = "create table IF NOT EXISTS " + tableForNode + "(count INTEGER PRIMARY KEY AUTOINCREMENT,chart_respective_nodeID varchar(255) ,nodeID VARCHAR(255),xValue varchar(255),yValue varchar(255),source varchar(255),name varchar(255),label varchar(255),colorValue varchar(255),showTextItem varchar(255),nodeSize varchar(255))";
string sql = "create table IF NOT EXISTS " + tableForNode + "(count INTEGER PRIMARY KEY AUTOINCREMENT,chart_respective_nodeID varchar(255) ,nodeID VARCHAR(255),xValue varchar(255),yValue varchar(255),name varchar(255),temperature_source varchar(255),humidity_source varchar(255),colorValue varchar(255),nodeSize varchar(255),airFlow varchar(225),lastUpdatedDate varchar(255))";
SQLiteCommand command = new SQLiteCommand(sql, connection);
command.ExecuteNonQuery();
//for line info
string sql4 = "create table IF NOT EXISTS " + tableForLine + "(count INTEGER PRIMARY KEY AUTOINCREMENT,chart_respective_lineID varchar(255) ,lineID string,prevNodeID varchar(255),nextNodeID varchar(255),lineColorValue varchar(255),lineSeriesID varchar(255),thickness varchar(255),name varchar(255), status INTEGER)";
SQLiteCommand command4 = new SQLiteCommand(sql4, connection);
command4.ExecuteNonQuery();
//for device info
//--Modified by bbk: for pulling information from the device
string sql5 = "create table IF NOT EXISTS " + tableFordevice + " ( count INTEGER PRIMARY KEY AUTOINCREMENT,nodeID varchar(255) ,device_instanceID_for_param1 varchar(255),device_instanceID_for_param2 varchar(255),IP_for_param1 varchar(255),IP_for_param2 varchar(255),param1ID varchar(255),param2ID varchar(255), param1_info varchar(255) ,param2_info varchar(255),param1_identifier_type varchar(255),param2_identifier_type varchar(255) )";
//string sql5 = "create table IF NOT EXISTS " + tableFordevice + " ( count INTEGER PRIMARY KEY AUTOINCREMENT,id_from_nodeID varchar(255) ,panelID varchar(255),inputIndex varchar(255),inputDescription varchar(255),inputAM varchar(255), inputValue varchar(255) ,inputUnit varchar(255),inputRange varchar(255),inputCalibration varchar(255),inputFilter varchar(255),inputJumper varchar(255),inputLabel varchar(255))";
SQLiteCommand command5 = new SQLiteCommand(sql5, connection);
command5.ExecuteNonQuery();
//gives the info about the which value From T3000 is associated with nodes in psychometric
// string sql_For_nodeInfoFromT3000 = "create table IF NOT EXISTS " + + " ( count INTEGER PRIMARY KEY AUTOINCREMENT,nodeID varchar(255) ,device_instanceID varchar(255),IP varchar(255),param1ID varchar(255),param2ID varchar(255), param1_info varchar(255) ,param2_info varchar(255),param1_identifier_type varchar(255),param2_identifier_type varchar(255) )";
//string sql5 = "create table IF NOT EXISTS " + tableFordevice + " ( count INTEGER PRIMARY KEY AUTOINCREMENT,id_from_nodeID varchar(255) ,panelID varchar(255),inputIndex varchar(255),inputDescription varchar(255),inputAM varchar(255), inputValue varchar(255) ,inputUnit varchar(255),inputRange varchar(255),inputCalibration varchar(255),inputFilter varchar(255),inputJumper varchar(255),inputLabel varchar(255))";
string sql_For_nodeInfoFromT3000 = "create table IF NOT EXISTS " + tableForValuesFromT3000 + " ( count INTEGER PRIMARY KEY AUTOINCREMENT,nodeID varchar(255) ,param1_panelID varchar(255),param1_inputIndex varchar(255),param2_panelID varchar(255),param2_inputIndex varchar(255))";
SQLiteCommand command_T3000 = new SQLiteCommand(sql_For_nodeInfoFromT3000, connection);
command_T3000.ExecuteNonQuery();
//These tables are for comfort zone...
string sql6 = "create table IF NOT EXISTS " + tableforComfortZoneDetail + " ( count INTEGER PRIMARY KEY AUTOINCREMENT,id varchar(255) ,name varchar(255),min_temp varchar(255),max_temp varchar(255),min_hum varchar(255), max_hum varchar(255) ,colorValue varchar(255) )";
SQLiteCommand command6 = new SQLiteCommand(sql6, connection);
command6.ExecuteNonQuery();
//--Comfortzonetable
string sql7 = "create table IF NOT EXISTS " + tableForChartComfortZoneSetting + " ( count INTEGER PRIMARY KEY AUTOINCREMENT,chartID varchar(255) ,comfort_zone_ID varchar(255),status varchar(255) )";
SQLiteCommand command7 = new SQLiteCommand(sql7, connection);
command7.ExecuteNonQuery();
//-- NOW table for storing values tableForInputStorageFromT3000
string sql8 = "create table IF NOT EXISTS " + tableForInputStorageFromT3000 + " ( count INTEGER PRIMARY KEY AUTOINCREMENT,PanelID varchar(255),InputIndex varchar(255),InputDescription varchar(255),InputAM varchar(255), InputValue varchar(255) ,InputUnit varchar(255),InputRange varchar(255),InputCalibration varchar(255),InputFilter varchar(255),InputJumper varchar(255),InputLabel varchar(255) )";
SQLiteCommand command8 = new SQLiteCommand(sql8, connection);
command8.ExecuteNonQuery();
//tableMixNode
string sql9 = "create table IF NOT EXISTS " + tableMixNode + " ( count INTEGER PRIMARY KEY AUTOINCREMENT,nodeID varchar(255),chartID varchar(255),previousNodeID varchar(255),nextNodeID varchar(255) )";
SQLiteCommand command9 = new SQLiteCommand(sql9, connection);
command9.ExecuteNonQuery();
}
}
