// Get PLMN Object data public List <IFSDataModel> GetPLMNObjectData() { List <IFSDataModel> lstIFSData = new List <IFSDataModel>(); string query = "select id, parent_id, object_name from tt_object;"; // Create an instance of the User class IFSDataModel iFSDataModel; //using (MySqlDataReader reader = MySqlHelper.ExecuteReader(connectionLTE_reference, query)) using (MySqlDataReader reader = MySqlHelper.ExecuteReader(connectionLTE_Ericsson, query)) { // Check if the reader returned any rows if (reader.HasRows) { while (reader.Read()) { iFSDataModel = new IFSDataModel(); iFSDataModel.id = Convert.ToString(reader[0]); iFSDataModel.parentid = Convert.ToString(reader[1]); iFSDataModel.text = Convert.ToString(reader[2]); lstIFSData.Add(iFSDataModel); } } } return(lstIFSData); }
// Get folder structure data public List <IFSDataModel> GetIFSData() { List <IFSDataModel> lstIFSData = new List <IFSDataModel>(); //string query = "select id, parent_id, name from tt_ifs where type = 0;"; // get directories only not files //string query = "select id, parent_id, name, type, data_id from tt_ifs;"; string query = "select ifs.id, ifs.parent_id, ifs.name, ifs.type, ifs.data_id, ifsdata.data " + " from tt_ifs ifs " + " left join tt_ifs_data ifsdata on ifs.data_id = ifsdata.id;"; // Create an instance of the User class IFSDataModel iFSDataModel; //using (MySqlDataReader reader = MySqlHelper.ExecuteReader(connectionLTE_reference, query)) using (MySqlDataReader reader = MySqlHelper.ExecuteReader(connectionLTE_Ericsson, query)) { // Check if the reader returned any rows if (reader.HasRows) { while (reader.Read()) { iFSDataModel = new IFSDataModel(); iFSDataModel.id = Convert.ToString(reader["id"]); iFSDataModel.parentid = Convert.ToString(reader["parent_id"]); iFSDataModel.text = Convert.ToString(reader["name"]); iFSDataModel.isDirectory = !Convert.ToBoolean(reader["type"]); iFSDataModel.data_id = Convert.ToString(reader["data_id"]); if (!(reader["data"] is System.DBNull)) { iFSDataModel.template = System.Text.Encoding.UTF8.GetString((byte[])reader["data"]); } lstIFSData.Add(iFSDataModel); } } } return(lstIFSData); }