public static void osParser(ManagementObjectSearcher searcher)
{
OSList myList = new OSList();
foreach (ManagementObject queryObj in searcher.Get())
{
OS currentItem = new OS(queryObj);
myList.osList.Add(currentItem);
}
OSData.EventHandler(myList);
}
private void GetRecordList <T>(String sqlCommand, OSList <T> list)
{
OSList <T> auxList = (OSList <T>)Helper.ReflectionHelper.CreateInstance(list.GetType());
/*
* OleDbDataReader dataReader;
* string connectionString = "Provider=SQLOLEDB.1;Password=a6Intruder;Persist Security Info=True;User ID=pedrolopes;Initial Catalog=MusicDB;Data Source=musicdb.c0d9wnivbgn8.eu-central-1.rds.amazonaws.com";
* System.Data.OleDb.OleDbConnection oleDbConnection = new System.Data.OleDb.OleDbConnection(connectionString);
* OleDbConnection connection = new OleDbConnection(connectionString);
* OleDbCommand command =new OleDbCommand(sqlCommand, connection);
* connection.Open();
* dataReader = command.ExecuteReader();
*/
try
{
using (CommittableTransaction commitableTransaction = dbaProvider.GetCommittableTransaction())
{
using (Command cmd = commitableTransaction.CreateCommand(sqlCommand))
{
// Results are read using a standard IDataReader object
using (IDataReader dataReader = cmd.ExecuteReader())
{
auxList.Reader = dataReader;
auxList.StartIteration();
while (!auxList.Eof)
{
auxList.Read();
list.Data.Add(auxList.CurrentRec);
auxList.Advance();
}
auxList.CloseDataReader();
}
}
}
}
catch (Exception ex)
{
log.Write(System.DateTime.Now, AppInfo.GetAppInfo().OsContext.Session.SessionID, AppInfo.GetAppInfo().eSpaceId, AppInfo.GetAppInfo().Tenant.Id, AppInfo.GetAppInfo().OsContext.Session.UserId, ex.Message, "Error", "MusicDBExternalData", "0");
throw ex;
}
}
/// <summary>
/// Action: ListInsert
/// </summary>
public static void ListInsert <T>(HeContext heContext, OSList <T> inParamList, T inParamElement, int inParamPosition)
{
inParamList.Insert(inParamElement, inParamPosition);
}
/// <summary>
/// Action: ListRemove
/// </summary>
public static void ListRemove <T>(HeContext heContext, OSList <T> inParamList, int inParamPosition)
{
inParamList.Remove(inParamPosition);
}
/// <summary>
/// Action: ListAppendAll
/// </summary>
public static void ListAppendAll <T>(HeContext heContext, OSList <T> inParamList, OSList <T> inParamSourceList)
{
inParamList.AppendAll(inParamSourceList);
}
/// <summary>
/// Action: ListClear
/// </summary>
public static void ListClear <T>(HeContext heContext, OSList <T> inParamList)
{
inParamList.Clear();
}
/// <summary>
/// Action: ListAppend
/// </summary>
public static void ListAppend <T>(HeContext heContext, OSList <T> inParamList, T inParamElement)
{
inParamList.Append(inParamElement);
}
public void toDataGrid(OSList myList)
{
dataGrid1.ItemsSource = myList.osList;
}
