private string GenerateSysHDS(ControllerModel controller)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("/* Selectieve detectie */");
sb.AppendLine("/* ------------------- */");
int index = 0;
var isvecom = controller.SelectieveDetectoren.Any();
// Geen VECOM? Dan alleen een dummy lus tbv KAR
if (!isvecom)
{
sb.AppendLine($"{ts}#define dsdummy 0 /* Dummy SD lus 0: tbv KAR */");
++index;
}
// Anders ook een dummy lus, voor KAR en zodat VECOM begint op 1
else
{
sb.AppendLine($"{ts}#define dsdummy 0 /* Dummy SD lus 0: tbv KAR & VECOM start op 1 */");
++index;
foreach (var d in controller.SelectieveDetectoren.Where(x => !x.Dummy))
{
sb.AppendLine($"{ts}#define {(_dpf + d.Naam).ToUpper()} {index++}{(!string.IsNullOrWhiteSpace(d.Omschrijving) ? " /* " + d.Omschrijving + "*/" : "")}");
}
}
if (controller.SelectieveDetectoren.Any(x => x.Dummy))
{
var rindex = index;
sb.AppendLine($"{ts}#if (!defined AUTOMAAT && !defined AUTOMAAT_TEST) || defined VISSIM");
foreach (var d in controller.SelectieveDetectoren.Where(x => x.Dummy))
{
sb.AppendLine($"{ts}#define {(_dpf + d.Naam).ToUpper()} {index++}{(!string.IsNullOrWhiteSpace(d.Omschrijving) ? " /* " + d.Omschrijving + "*/" : "")}");
}
sb.AppendLine($"{ts}#else");
sb.AppendLine($"{ts}#define DSMAX {rindex}");
sb.AppendLine($"{ts}#endif");
}
else
{
sb.AppendLine($"{ts}#define DSMAX {index}");
}
return(sb.ToString());
}
public async Task <List <object[]> > SelectData(string table, string[] fields, Dictionary <string, object> where = null)
{
var whereText = string.Empty;
int count = 1;
if (where != null)
{
var last = where.Keys.Last();
foreach (var pair in where)
{
whereText += $"{pair.Key}=@var{count++}{(pair.Key == last? null : " and ")}";
}
}
var field = string.Join(',', fields);
var whereTrueText = string.IsNullOrEmpty(whereText) ? null : $"WHERE {whereText}";
var query = $"SELECT {field} FROM {table} {whereTrueText}";
using (var con = new SqliteConnection($"Data Source = {SettingsManager.DatabaseFilePath};"))
using (var querySQL = new SqliteCommand(query, con))
{
await con.OpenAsync();
if (!string.IsNullOrEmpty(whereText) && where != null)
{
count = 1;
foreach (var pair in where)
{
querySQL.Parameters.Add(new SqliteParameter($"@var{count++}", pair.Value));
}
}
try
{
using (var r = await querySQL.ExecuteReaderAsync())
{
var list = new List <object[]>();
if (r.HasRows)
{
while (await r.ReadAsync())
{
var obj = new List <object>();
for (int i = 0; i < fields.Length; i++)
{
obj.Add(r.IsDBNull(i) ? null : r.GetValue(i));
}
list.Add(obj.ToArray());
}
}
return(list);
}
}
catch (Exception ex)
{
await LogHelper.LogEx($"[SQLiteDataQuery]: {query} - {string.Join("|", where?.Select(a=> $"{a.Key}:{a.Value} ") ?? new List<string>())}", ex, LogCat.SQLite);
return(default);
//SQLite Query
#region SQLiteQuery
public async Task <bool> IsEntryExists(string table, Dictionary <string, object> where)
{
var whereText = string.Empty;
int count = 1;
if (where != null)
{
var last = where.Keys.Last();
foreach (var pair in where)
{
whereText += $"{pair.Key}=@var{count++}{(pair.Key == last? null : " and ")}";
}
}
var whereTrueText = string.IsNullOrEmpty(whereText) ? null : $"WHERE {whereText}";
var query = $"SELECT * FROM {table} {whereTrueText}";
using (var con = new SqliteConnection($"Data Source = {SettingsManager.DatabaseFilePath};"))
using (var querySQL = new SqliteCommand(query, con))
{
await con.OpenAsync();
if (!string.IsNullOrEmpty(whereText) && where != null)
{
count = 1;
foreach (var pair in where)
{
querySQL.Parameters.Add(new SqliteParameter($"@var{count++}", pair.Value));
}
}
try
{
using (var r = await querySQL.ExecuteReaderAsync())
{
return(r.HasRows);
}
}
catch (Exception ex)
{
await LogHelper.LogEx($"[SQLiteDataQuery]: {query} - {string.Join("|", where?.Select(a=> $"{a.Key}:{a.Value} ") ?? new List<string>())}", ex, LogCat.SQLite);
return(false);
}
}
}
public static string Flatten <T>(List <List <T> > l, string type, bool isScript)
{
int counter = 0;
string output = "";
foreach (List <T> li in l)
{
StringBuilder st = new StringBuilder();
for (int i = 0; i < li.Count(); ++i)
{
st.Append($"\t{li[i]}{Environment.NewLine}");
}
output = string.Join(Environment.NewLine, output, $"{type}{counter++}{(isScript ? ":" : "")}{Environment.NewLine}{st}{Environment.NewLine}");
}
return(output);
}
public async Task <bool> IsEntryExists(string table, Dictionary <string, object> where)
{
var whereText = string.Empty;
int count = 1;
if (where != null)
{
var last = where.Keys.Last();
foreach (var pair in where)
{
whereText += $"`{pair.Key}`=@var{count++}{(pair.Key == last? null : " and ")}";
}
}
var whereTrueText = string.IsNullOrEmpty(whereText) ? null : $"WHERE {whereText}";
var query = $"SELECT * FROM {SchemaDot}{table} {whereTrueText}";
return(await SessionWrapper(query, async command =>
{
if (!string.IsNullOrEmpty(whereText) && where != null)
{
count = 1;
foreach (var pair in where)
{
command.Parameters.Add(CreateParam <MySqlParameter>($"@var{count++}", pair.Value));
}
}
try
{
using (var r = await command.ExecuteReaderAsync())
{
return r.HasRows;
}
}
catch (Exception ex)
{
await LogHelper.LogEx($"[IsEntryExists]: {query} - {string.Join("|", where?.Select(a=> $"{a.Key}:{a.Value} ") ?? new List<string>())}", ex, LogCat.Database);
return false;
}
}));
}
public static void InsertOrUpdate(string table, Dictionary <string, object> values)
{
if (values == null)
{
LogHelper.Log($"[SQLiteDataInsertOrUpdate]: {table} query has empty values!");
return;
}
var fromText = string.Empty;
var valuesText = string.Empty;
int count = 1;
var last = values.Keys.Last();
foreach (var pair in values)
{
fromText += $"{pair.Key}{(pair.Key == last ? null : ",")}";
valuesText += $"@var{count++}{(pair.Key == last ? null : ",")}";
}
var query = $"insert or replace into {table} ({fromText}) values({valuesText})";
using (var con = new SQLiteConnection($"Data Source = {DBFile};"))
using (var querySQL = new SQLiteCommand(query, con))
{
con.Open();
count = 1;
foreach (var pair in values)
{
querySQL.Parameters.Add(new SQLiteParameter($"@var{count++}", pair.Value ?? DBNull.Value));
}
try
{
querySQL.ExecuteNonQuery();
}
catch (Exception ex)
{
LogHelper.LogEx($"[SQLiteDataInsertOrUpdate]: {query} - {string.Join("|", values.Select(a=> $"{a.Key}:{a.Value} "))}", ex);
}
}
}
static void Main()
{
int a = int.Parse(Console.ReadLine());
int b = int.Parse(Console.ReadLine());
int maxNumberPassword = int.Parse(Console.ReadLine());
int x = 35;
int y = 64;
int counter = 0;
for (int e = 1; e <= a; e++)
{
for (int d = 1; d <= b; d++)
{
Console.Write($"{(char)x}{(char)y}{e}{d}{(char)y++}{(char)x++}|");
if (e == a && d == b)
{
return;
}
counter++;
if (counter == maxNumberPassword)
{
return;
}
if (x > 55)
{
x = 35;
}
if (y > 96)
{
y = 64;
}
}
}
}
public async Task <List <object[]> > SelectData(string table, string[] fields, Dictionary <string, object> where = null)
{
var whereText = string.Empty;
int count = 1;
if (where != null)
{
var last = where.Keys.Last();
foreach (var pair in where)
{
whereText += $"`{pair.Key}`=@var{count++}{(pair.Key == last? null : " and ")}";
}
}
var field = string.Join(',', fields.Select(a => a == "*" ? a : $"`{a}`"));
var whereTrueText = string.IsNullOrEmpty(whereText) ? null : $"WHERE {whereText}";
var query = $"SELECT {field} FROM {SchemaDot}{table} {whereTrueText}";
return(await SessionWrapper(query, async command =>
{
if (!string.IsNullOrEmpty(whereText) && where != null)
{
count = 1;
foreach (var pair in where)
{
command.Parameters.Add(CreateParam <MySqlParameter>($"@var{count++}", pair.Value));
}
}
try
{
using (var r = await command.ExecuteReaderAsync())
{
var list = new List <object[]>();
if (r.HasRows)
{
while (await r.ReadAsync())
{
var obj = new List <object>();
if (field == "*")
{
for (int i = 0; i < r.VisibleFieldCount; i++)
{
obj.Add(r.IsDBNull(i) ? null : r.GetValue(i));
}
}
else
{
for (int i = 0; i < fields.Length; i++)
{
obj.Add(r.IsDBNull(i) ? null : r.GetValue(i));
}
}
list.Add(obj.ToArray());
}
}
return list;
}
}
catch (Exception ex)
{
await LogHelper.LogEx($"[{nameof(SelectData)}]: {query} - {string.Join("|", where?.Select(a=> $"{a.Key}:{a.Value} ") ?? new List<string>())}", ex, LogCat.Database);
return default;
}
}));
}
static void Main(string[] args)
{
// DECLARING VARIABLES
// 1. Declare a string variable called "myName" and set it equal to your name
var myName = ("Lamond Dixon");
// 2. Declare a number varible called "myAge" and set it equal to your age
var myAge = ("My age is 24");
// 3. Declare a boolean value called "myBool" and set it equal to true or false;
bool myBool = true;
// 4. Declare a new list of strings called "productsList" and set it equal to "basketball", "baseball glove", "tennis shoes", "hockey puck"
List<string> productsList = new List<string>();
productsList.Add("bsketball");
productsList.Add("baseball glove");
productsList.Add("tennis shoes");
productsList.Add("hockey puck");
// PRINTING VARIABLES TO THE CONSOLE USING CONSOLE.WRITELINE()
// 1. Print your name to the console using the format: "My name is <myName> and I'm a beast of a programmer"
var theName = ("Lamond");
Console.WriteLine("my name is " + (theName) + "and I'm a beast of a programmer" );
// 2. Print out your age to the console using the format: "I am <myAge> years awesome."
var theAge = ("24");
Console.WriteLine("I am" + (theAge) + "years awesome.");
// 3. Print out your boolean value using the format: "I set my boolean value equal to <myBool>"
var theBool = ("True");
Console.WriteLine("I set my boolean calue equal to" + (theBool));
// 4. Using a For loop, print out each value in productsList.
for (int i = 0; productsList.Length; i++);
Console.WriteLine(productsList);
// FOR LOOP PRACTICE
// 1. Create a for loop that prints out the numbers 1 to 10.
for (int j = 1; j >= 11; j++) ;
Console.WriteLine(j);
// 2. Create a for loop that prints out the numbers 10 to 1.
for (int b = 10; b <= 1; b--) ;
Console.WriteLine (b);
// 3. Create a for loop that prints out the numbers 10 to 30, only printing the even numbers
for(int n = 10; n <= 30; n++(10));
// 4. Create a for loop that prints out the numbers 100 to 75, only printing every 5th number (100, 95, 90, 85, 80, 75)
for (int m = 100; m <= 75; m-(5)));
// WHILE LOOP PRACTICE
// 1. Create a while loop that prints out the numbers from 1 to 10.
int i = 1;
while (i <= 10)
{
Console.WriteLine(i);
i++;
}
// 2. Create a while loop that prints out the numbers from 10 to 1.
int a = 10;
while (a <= 1)
{
Console.WriteLine(a);
a--;
}
// 3. Create a while loop that prints out the numbers from 15 to 30, only printing the even numbers
int h = 15;
while (h <= 30);
{
Console.WriteLine(h);
h -- (2);
}
// 4. Create a while loop that prints out the numbers from 100 to 75, only printing every 5th number (100, 95, 90, 85, 80, 75)
int u = 100;
while (u <= 100);
Console.WriteLine(u);
u -- (5);
// 5. Create a while loop that prints out the numbers from 1 to 10 until it reaches one that is divisible by 4.
int k = 1;
while (k <=20);
Console.WriteLine(k);
k %= (4);
// PUTTING IT TOGETHER
// Use either FOR or WHILE loops to accomplish the following:
// 1. Print out the number of letters in your name using the format: "My name, <myName>, has <number of letters> in it."
// 2. Print out the number of items in your list using the format: "My product list has <number of items> in it."
// 3. Print out the number of letters of each item in productsList using the format: "<product> has <number of letters> in it."
// DECLARING AND CALLING FUNCTIONS
// 1. Create a function called "Greeting" that takes one string parameter called "name". This function will print "Hello <name>"
// 2. Call the Greeting function by passing in "Geronimo Jackson" as your parameter.
// 3. Call the Greeting function by passing in myName as your parameter.
// 4. Create a function called "DoubleIt" that takes one integer parameter called "number". This function will print "<number> doubled is <number * 2>"
// 5. Call your DoubleIt Function by passing in 1337 as your parameter.
// 6. Call your DoubleIt function by passing in myAge as your parameter.
// 7. Create a function called "Multiply" that takes two integer parameters called "num1" and "num2". This function will print "<num1> times <num2> is <num1 * num2>"
// 8. Call your Multiply function by passing in 2 and 8 as your parameters.
// 9. Call your Multiply function by passing in 3 and myAge as your parameters.
// 10. Create a function called "LoopThis" that takes two integer parameters called "startNum" and "endNum".
// This function will print out:
// a. "I'm looping from <startNum> to <endNum>."
// b. The numbers from startNum to endNum, one per line.
// 11. Call your LoopThis function by passing in 20 and 30 as your parameters.
// 12. Call your LoopThis function by passing in 0 and myAge as your parameters.
// 13. Create a function called "SuperLoop" that takes three integer parameters called "startNum", "endNum", and "increment".
// You will need to track how many times the loop has been executed in a variable called "loopCount".
// This function will print out:
// a. "I'm looping from <startNum> to <endNum>, incrementing <increment> each time"
// b. The numbers from startNum to endNum, one per line.
// c. "That loop was craaaaaazy, we looped X times"
// 14. Call your SuperLoop function by passing in 0, 100, and 15 as your parameters.
// 15. Call your SuperLoop function by passing in 0, 200, and myAge as your parameters.
//DECLARING AND CALLING RETURN FUNCTIONS
// 1. Create a function called "NewGreeting" that takes one string parameter called "name". This function will return a string in the format of "Hello, <name>"
// 2. Using your NewGreeting function as the parameter for Console.WriteLine(), call your NewGreeting function using the parameter "Neil deGrasse-Tyson"
// EX: Console.WriteLine(FunctionCall("myParameter"));
// 3. Using your NewGreeting function as the parameter for Console.WriteLine(), call your NewGreeting function using the parameter myName.
// 4. Create a function called "TripleIt" that takes one integer parameter called "number". This function will return the number times 3.
// 5. Using your TripleIt function as part of the parameter for Console.WriteLine(),
// call your TripleIt function using the parameter of 10 to print out "10 tripled is <TripleIt Function Call>"
// 6. Using your TripleIt function as part of the parameter for Console.WriteLine(),
// call your TripleIt function using the parameter of myAge to print out "<myAge> tripled is <TripleIt Function Call>"
// 7. Create a function called "RealMultiply" that takes two integer parameters called "num1", and "num2". This function will return the num1 * num2.
// 8. Using your RealMultiply function as part of the parameter for Console.WriteLine(),
// call your RealMultiply function using the parameter of 5 and 10 to print out the returned value from your function.
// 9. Using your RealMultiply function as part of the parameter for Console.WriteLine(),
// call your RealMultiply function using the parameter of 2 and myAge to print out the returned value from your function.
//FUNCTION CALL MADNESS!
// 1. Call your SuperLoop function using the following parameters:
// startNum = Call RealMultiply with the parameters 1, 5
// endNum = Call TripleIt with the parameter myAge
// increment = Call TripleIt with the parameter of myAge minus 10
// 2. Call your SuperLoop function using the following parameters:
// startNum = Call RealMultiply with the parameters 1, and TripleIt with the parameter of 3.
// endNum = Call TripleIt with the parameter RealMultiply with the parameters: myAge, 7
// increment = Call TripleIt with the parameter of myAge minus RealMultiply with the parameters 2, 4.
}
