/// <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; }