public IEnumerable <ProtocolRow> GetProtocolData(string storageName, int startRow, int maxRows, string filter, DateTime?FromDate, DateTime?ToDate)
{
var datasetConfig = ProtokollerConfiguration.ActualConfigInstance.Datasets.FirstOrDefault(s => s.Name == storageName);
IDBInterface dbInterface = StorageHelper.GetStorage(datasetConfig, null);
dbInterface.Connect_To_Database(datasetConfig.Storage);
IDBViewable dbViewable = dbInterface as IDBViewable;
List <ProtocolRow> list = new List <ProtocolRow>();
DataTable table = dbViewable.ReadData(datasetConfig, filter, startRow, maxRows, FromDate, ToDate);
foreach (DataRow row in table.Rows)
{
ProtocolRow storageLine = new ProtocolRow();
var date = row["datetime"];
if (date is DateTime)
{
storageLine.Timestamp = (DateTime)date;
}
else
{
storageLine.Timestamp = DateTime.ParseExact(row["datetime"].ToString(), "yyyy.MM.dd - HH:mm:ss.fff", null);
}
storageLine.Telegram = Convert.ToString(row["data"]);
list.Add(storageLine);
}
return(list);
}
private void cmbStorage_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
lblError.Content = null;
if (dbIf != null)
dbIf.Dispose();
dbIf = null;
dbView = null;
lblDataCount.Content = null;
grdDatasetFields.ItemsSource = null;
datasetConfig = cmbStorage.SelectedItem as DatasetConfig;
dbIf = StorageHelper.GetStorage(datasetConfig, null);
dbIf.Connect_To_Database(datasetConfig.Storage);
dbView = dbIf as IDBViewable;
dbViewSQL = dbIf as IDBViewableSQL;
txtSQL.IsEnabled = false;
cmdSQL.IsEnabled = false;
txtSearch.IsEnabled = false;
cmdSearch.IsEnabled = false;
try
{
if (dbView != null)
{
txtSQL.Text = "";
CurrentNumber = 0;
DataTable tbl = dbView.ReadData(datasetConfig, null, CurrentNumber, 1000, null, null);
if (tbl != null)
grdDatasetFields.ItemsSource = tbl.DefaultView;
lblDataCount.Content = dbView.ReadCount(datasetConfig);
}
if (!string.IsNullOrEmpty(datasetConfig.DateTimeDatabaseField))
{
/*dbFieldNames = datasetConfig.DateTimeDatabaseField;
foreach (var datasetConfigRow in datasetConfig.DatasetConfigRows)
{
if (datasetConfigRow.DatabaseField.ToLower().Trim() != datasetConfig.DateTimeDatabaseField.ToLower().Trim())
dbFieldNames += ", " + datasetConfigRow.DatabaseField;
}*/
dbFieldNames = datasetConfig.DateTimeDatabaseField + ",*";
}
if (dbViewSQL != null)
{
txtSQL.Text = "SELECT " + dbFieldNames + " FROM " + datasetConfig.Name + " ORDER BY id DESC LIMIT " + 1000.ToString();
txtSQL.IsEnabled = true;
cmdSQL.IsEnabled = true;
txtSearch.IsEnabled = true;
cmdSearch.IsEnabled = true;
}
}
catch (Exception ex)
{
lblError.Content = ex.Message;
}
}
private void cmbStorage_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
lblError.Content = null;
if (dbIf != null)
{
dbIf.Dispose();
}
dbIf = null;
dbView = null;
lblDataCount.Content = null;
grdDatasetFields.ItemsSource = null;
datasetConfig = cmbStorage.SelectedItem as DatasetConfig;
dbIf = StorageHelper.GetStorage(datasetConfig, null);
dbIf.Connect_To_Database(datasetConfig.Storage);
dbView = dbIf as IDBViewable;
dbViewSQL = dbIf as IDBViewableSQL;
txtSQL.IsEnabled = false;
cmdSQL.IsEnabled = false;
txtSearch.IsEnabled = false;
cmdSearch.IsEnabled = false;
try
{
if (dbView != null)
{
txtSQL.Text = "";
CurrentNumber = 0;
DataTable tbl = dbView.ReadData(datasetConfig, null, CurrentNumber, 1000, null, null);
if (tbl != null)
{
grdDatasetFields.ItemsSource = tbl.DefaultView;
}
lblDataCount.Content = dbView.ReadCount(datasetConfig);
}
if (!string.IsNullOrEmpty(datasetConfig.DateTimeDatabaseField))
{
/*dbFieldNames = datasetConfig.DateTimeDatabaseField;
* foreach (var datasetConfigRow in datasetConfig.DatasetConfigRows)
* {
* if (datasetConfigRow.DatabaseField.ToLower().Trim() != datasetConfig.DateTimeDatabaseField.ToLower().Trim())
* dbFieldNames += ", " + datasetConfigRow.DatabaseField;
* }*/
dbFieldNames = datasetConfig.DateTimeDatabaseField + ",*";
}
if (dbViewSQL != null)
{
txtSQL.Text = "SELECT " + dbFieldNames + " FROM " + datasetConfig.Name + " ORDER BY id DESC LIMIT " + 1000.ToString();
txtSQL.IsEnabled = true;
cmdSQL.IsEnabled = true;
txtSearch.IsEnabled = true;
cmdSearch.IsEnabled = true;
}
}
catch (Exception ex)
{
lblError.Content = ex.Message;
}
}
