static string ParseSQL(string Builder)
{
string stringToReplace = Regex.Match(Builder, @"\[SQL=>([^)]*)\]").Groups[0].Value;
//MessageBox.Show(stringToReplace);
string query = Regex.Match(Builder, @"\[SQL=>([^)]*)\]").Groups[1].Value;
OptimaDB db = new OptimaDB();
//MessageBox.Show(query);
return(Builder.Replace(stringToReplace, db.ExecuteUserQuery(query)));
}
public void start()
{
graphServiceClient = MGraphHelper.GetGraphServiceClient(Config.ClientId, Config.Authority, Config.Scopes);
db = new OptimaDB();
_timer = new Timer(20000)
{
AutoReset = true
};
_timer.Elapsed += TimerElapsed;
_timer.Start();
Console.ReadKey();
}