public static bool prepare_user_setting_file()
{
bool b_return = false;
// source_user_setting_folder = Path.Combine(startup_path, @"mmhis\setting\user_setting_template");
program_setting_folder = Path.Combine(temp_folder, @"mmhis\setting\program_setting");
program_script_folder = Path.Combine(temp_folder, @"mmhis\setting\program_script");
user_setting_folder = Path.Combine(temp_folder, @"mmhis\setting\" + user_id);
// sqlite files
// source_window_and_data_field_user_setting_pathname = Path.Combine(source_user_setting_folder, "mmhis_window_and_data_field_user_setting");
// source_control_text_user_setting_pathname = Path.Combine(source_user_setting_folder, "mmhis_control_text_user_setting");
pointer_program_setting_pathname = Path.Combine(program_setting_folder, "mmhis_pointer_program_setting");
data_field_format_program_setting_pathname = Path.Combine(program_setting_folder, "mmhis_data_field_format_program_setting");
window_and_data_field_user_setting_pathname = Path.Combine(user_setting_folder, "mmhis_window_and_data_field_user_setting");
control_text_user_setting_pathname = Path.Combine(user_setting_folder, "mmhis_control_text_user_setting");
b_return = load_pointer_and_control_text();
if (b_return)
{
play_mmhis_data_frameindex_only_script = utility.load_script(script("play_mmhis_data_frameindex_only"))[0];
play_mmhis_data_all_script = utility.load_script(script("play_mmhis_data_all"))[0];
tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general();
try
{
tdpg.initialize_generic_members("sqlite");
tdpg.construct_connection_string("", "", "", window_and_data_field_user_setting_pathname);
tdpg.open_conn_cmd(0);
tdpg.cmd[0].CommandText = utility.load_script(setting.script("check_table_validity_mmhis_data_field"))[0];
tdpg.reader[0] = tdpg.cmd[0].ExecuteReader();
tdpg.reader[0].Close();
tdpg.cmd[0].CommandText = utility.load_script(setting.script("check_table_validity_mmhis_window"))[0];
tdpg.reader[0] = tdpg.cmd[0].ExecuteReader();
tdpg.reader[0].Close();
}
catch (Exception eee)
{
Console.WriteLine(eee.Message);
tdpg.close_conn_cmd(0);
b_return = false;
// Directory.CreateDirectory(user_setting_folder);
// File.Copy(source_window_and_data_field_user_setting_pathname, window_and_data_field_user_setting_pathname, true);
}
}
if (b_return)
{
b_return = load_data_field_format("english");
}
return(b_return);
}
// save contents in d into the "dictionary" table in db
public static bool do_save_dictionary(
string db,
Dictionary <string, string> d
)
{
bool b_return = false;
string the_value = null;
tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general();
try
{
tdpg.initialize_generic_members("sqlite");
tdpg.construct_connection_string("", "", "", db);
tdpg.open_conn_cmd(0);
tdpg.cmd[0].CommandText = "update dictionary set value=@value, time_stamp=@time_stamp where key=@key and value<>@value";
((SQLiteCommand)tdpg.cmd[0]).Parameters.Add("key", System.Data.DbType.String);
((SQLiteCommand)tdpg.cmd[0]).Parameters.Add("value", System.Data.DbType.String);
((SQLiteCommand)tdpg.cmd[0]).Parameters.Add("time_stamp", System.Data.DbType.Int64);
foreach (string key in d.Keys)
{
if (d.TryGetValue(key, out the_value))
{
((SQLiteCommand)tdpg.cmd[0]).Parameters["key"].Value = key;
((SQLiteCommand)tdpg.cmd[0]).Parameters["value"].Value = the_value;
((SQLiteCommand)tdpg.cmd[0]).Parameters["time_stamp"].Value = DateTime.Now.Ticks;
tdpg.cmd[0].ExecuteNonQuery();
}
}
b_return = true;
}
catch
{
b_return = false;
}
finally
{
try
{
tdpg.reader[0].Close();
}
catch { }
try
{
tdpg.close_conn_cmd(0);
}
catch { }
}
return(b_return);
}
private void choose_field_specifier_Load(object sender, EventArgs e)
{
tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general();
tdpg.initialize_generic_members("sqlite");
try
{
if (which_specifier == "field")
{
tdpg.construct_connection_string("", "", "", setting.data_field_format_program_setting_pathname);
tdpg.open_conn_cmd(0);
Text = "Choose Field Specifier";
tdpg.cmd[0].CommandText = "select field_specifier as specifier from mmhis_data_field_format";
}
else if (which_specifier == "window")
{
tdpg.construct_connection_string("", "", "", setting.window_and_data_field_user_setting_pathname);
tdpg.open_conn_cmd(0);
Text = "Choose Window Specifier";
tdpg.cmd[0].CommandText = "select window_specifier as specifier from mmhis_window";
}
else
{
Close();
}
tdpg.reader[0] = tdpg.cmd[0].ExecuteReader();
while (tdpg.reader[0].Read())
{
listBox_field_specifier.Items.Add(tdpg.reader[0][0].ToString());
}
}
catch
{
}
finally
{
try
{
tdpg.reader[0].Close();
}
catch { }
try
{
tdpg.close_conn_cmd(0);
}
catch { }
}
}
// load into "dictionary_data_field_format"
public static bool load_data_field_format(
string unit_system // can only be "english" or "metric"
)
{
bool b_return = false;
dictionary_data_field_format.Clear();
tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general();
tdpg.initialize_generic_members("sqlite");
try
{
tdpg.construct_connection_string("", "", "", setting.data_field_format_program_setting_pathname);
tdpg.open_conn_cmd(0);
tdpg.cmd[0].CommandText = "select * from mmhis_data_field_format";
tdpg.reader[0] = tdpg.cmd[0].ExecuteReader();
while (tdpg.reader[0].Read())
{
data_field_format the_data_field_format = new data_field_format();
the_data_field_format.field_specifier = tdpg.reader[0]["field_specifier"].ToString();
the_data_field_format.caption_suggestion = tdpg.reader[0]["caption_suggestion"].ToString();
the_data_field_format.value_format = tdpg.reader[0]["value_format_" + unit_system].ToString();
the_data_field_format.unit = tdpg.reader[0]["unit_" + unit_system].ToString();
the_data_field_format.conversion_factor = utility.get_double(tdpg.reader[0]["conversion_factor_" + unit_system], 1.0);
dictionary_data_field_format.Add(the_data_field_format.field_specifier, the_data_field_format);
}
b_return = true;
}
catch
{
b_return = false;
}
finally
{
try
{
tdpg.reader[0].Close();
}
catch { }
try
{
tdpg.close_conn_cmd(0);
}
catch { }
}
return(b_return);
}
// load contents in the "dictionary" table in db into d
public static bool do_load_dictionary(
string db,
Dictionary <string, string> d
)
{
bool b_return = false;
tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general();
try
{
tdpg.initialize_generic_members("sqlite");
tdpg.construct_connection_string("", "", "", db);
tdpg.open_conn_cmd(0);
tdpg.cmd[0].CommandText = "select key, value from dictionary";
tdpg.reader[0] = tdpg.cmd[0].ExecuteReader();
d.Clear();
while (tdpg.reader[0].Read())
{
d.Add(
tdpg.reader[0]["key"].ToString(),
tdpg.reader[0]["value"].ToString()
);
}
b_return = true;
}
catch
{
b_return = false;
}
finally
{
try
{
tdpg.reader[0].Close();
}
catch { }
try
{
tdpg.close_conn_cmd(0);
}
catch { }
}
return(b_return);
}
