/// <summary>
/// Constructor that takes a MySQLDatabase instance
/// </summary>
/// <param name="database"></param>
public RoleTable(MySQLDatabase database)
{
_database = database;
}
/// <summary>
/// Constructor that takes a MySQLDatabase instance
/// </summary>
/// <param name="database"></param>
public UserLoginsTable(MySQLDatabase database)
{
_database = database;
}
/// <summary>
/// Constructor that takes a MySQLDatabase instance
/// </summary>
/// <param name="database"></param>
public UserClaimsTable(MySQLDatabase database)
{
_database = database;
}
private List<KeyValuePair<DateTime, double>> ReturnRowsetMySql(ChartDescriptor chartDescriptor)
{
MySQLDatabase mySqlDatabase = new MySQLDatabase();
Dictionary<string, object> parameters = new Dictionary<string, object>
{
{"@dateTimeFrom", chartDescriptor.DateTimeFrom.ToString("yyyy-MM-dd HH:mm:ss")},
{"@dateTimeTo", chartDescriptor.DateTimeTo.ToString("yyyy-MM-dd HH:mm:ss")},
{"@measurableType", chartDescriptor.MeasurableType},
{"@plantsAreaId", chartDescriptor.PlantsAreaId.ToString().ToUpper()},
{"@criticalInfo", chartDescriptor.OnlyCritical ? 1 : 0},
{"@number", chartDescriptor.Number}
};
//cmd.Parameters.Add("@dateTimeFrom", SqlDbType.DateTime).Value = chartDescriptor.DateTimeFrom;
//cmd.Parameters.Add("@dateTimeTo", SqlDbType.DateTime).Value = chartDescriptor.DateTimeTo;
//cmd.Parameters.Add("@measurableType", SqlDbType.NVarChar).Value = chartDescriptor.MeasurableType;
//cmd.Parameters.Add("@plantsAreaId", SqlDbType.NVarChar).Value = chartDescriptor.PlantsAreaId.ToString().ToUpper();
//cmd.Parameters.Add("@criticalInfo", SqlDbType.Bit).Value = chartDescriptor.OnlyCritical ? 1 : 0;
//cmd.Parameters.Add("@number", SqlDbType.Int).Value = chartDescriptor.Number;
List<KeyValuePair<DateTime, double>> measuringMessageMappings = new List<KeyValuePair<DateTime, double>>();
string commandText =
"call statistics(@dateTimeFrom, @dateTimeTo, @measurableType, @plantsAreaId, @criticalInfo, @number)";
List<Dictionary<string, string>> rows = mySqlDatabase.Query(commandText, parameters);
foreach (Dictionary<string, string> row in rows)
{
measuringMessageMappings.Add(new KeyValuePair<DateTime, double>(DateTime.Parse(row["DateTime"]), Double.Parse(row["ParameterValue"])));
}
return measuringMessageMappings;
}
/// <summary>
/// Constructor that takes a MySQLDatabase instance
/// </summary>
/// <param name="database"></param>
public UserRolesTable(MySQLDatabase database)
{
_database = database;
}
