/// <summary> /// Dispose entity context builder. /// </summary> public void Dispose() { if (MainBuilder != null) { MainBuilder.Dispose(); } }
private void RunButton_Click(object sender, RibbonControlEventArgs e) { Excel.Worksheet workSheet = (Excel.Worksheet)Globals.ThisAddIn.Application.ActiveSheet; _mainBuilder = new MainBuilder(workSheet); try { Globals.ThisAddIn.Application.Interactive = false; Globals.ThisAddIn.Application.ScreenUpdating = false; var logs = _mainBuilder.Run(true); if (logs.Count > 0) { MessageBox.Show("Done", "Application Complete - Please Review Logs", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { MessageBox.Show("Done", "Application Complete", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ran into an error while running", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Globals.ThisAddIn.Application.Interactive = true; Globals.ThisAddIn.Application.ScreenUpdating = true; } }
/// <summary> /// Get data by sql query string. /// Only support while there is a main builder. /// </summary> /// <typeparam name="T">Type of result.</typeparam> /// <param name="sql">Sql query string.</param> /// <param name="parameters">Query parameters.</param> /// <returns>A System.Data.Entity.Infrastructure.DbRawSqlQuery object that will execute the query when it is enumerated.</returns> public IEnumerable <T> Query <T>(string sql, params object[] parameters) { if (MainBuilder == null) { throw new NotSupportedException("Can not use query while there is no main builder."); } return(MainBuilder.Query <T>(sql, parameters)); }
public static void ExecuteBuilder() { var builder = new MainBuilder(); builder.ExecuteBuilder(); }
static void Main(string[] args) { try { jsonMessageList jsonList = new jsonMessageList(); jsonList.iterateList(); ShowBindings(); //return; _mBuilder = new MainBuilder(); _mBuilder.doWork(); //Checking Binding to an Exchange - Surviving Channel ExchangeBuilder exBuilder = new ExchangeBuilder(); QueueBuilder qBuilder = new QueueBuilder(); RPCBuilder rPCBuilder = new RPCBuilder(); exBuilder.createExchange(_mBuilder.Channel, "ChannelTimeoutChecker_EX"); qBuilder.createQueue(_mBuilder.Channel, "ChannelTimeoutListener"); qBuilder.createQueue(_mBuilder.Channel, "rpcReplyQueue"); qBuilder.BindToExchange(_mBuilder.Channel, "ChannelTimeoutChecker_EX", "ChannelTimeoutListener"); rPCBuilder.createRPC(_mBuilder.Channel, "rpcQueue"); // for (int i = 0 ;i < 100;i++) // { // ConnectionChannelChecking(i.ToString()); // if(i % 20 == 0) // { // ThreadPool.QueueUserWorkItem(SendToExchange,_mBuilder.Channel); // } // } // ThreadPool.QueueUserWorkItem(SendToExchange,_mBuilder.Channel); // ThreadPool.QueueUserWorkItem(SendToExchange,_mBuilder.Channel); // ThreadPool.QueueUserWorkItem(SendToExchange,_mBuilder.Channel); // ThreadPool.QueueUserWorkItem(SendToExchange,_mBuilder.Channel); // ThreadPool.QueueUserWorkItem(SendToExchange,_mBuilder.Channel); // Thread.Sleep(60000); // Console.WriteLine("end thread"); // _stopThread = true; // Thread.Sleep(2000); // Console.WriteLine("did it ended?"); // RPC Call var rpcClient = new RpcClient(); rpcClient.consumeReplyQueue(_mBuilder.Channel, "rpcReplyQueue"); string result = rpcClient.Call("1", "rpcQueue"); Console.WriteLine("RPC Result: " + result); //Ende RPC for (int i = 0; i < 10; i++) { putMessages("WorkingQueue_" + i.ToString().PadLeft(2, '0')); } // Console.WriteLine("open a thread to listen to exchange"); //ThreadPool.QueueUserWorkItem(listenToExchange,_mBuilder.Channel); // Consumer consumer1 = new Consumer(); // consumer1.Subscribe("logs7even0","Consumer 1","..1.."); //Consumer consumer2 = new Consumer(); //consumer2.Subscribe("logs7even","Consumer 2","..2.."); // consumer1.Subscribe("logs7even1","Consumer 2","..2.."); // GetMessaging getMessages = new GetMessaging(); // getMessages.GetMessage(_mBuilder.Channel, "WorkingQueue_03"); // Console.WriteLine("i am really finished"); // putExchangeMessages("logs7even0"); // Thread.Sleep(500); // putExchangeMessages("logs7even0"); // Thread.Sleep(500); // putExchangeMessages("logs7even0"); // Thread.Sleep(500); // putExchangeMessages("logs7even0"); // for(int i = 0; i < 50 ;i ++) // { // putExchangeMessages("logs7even0"); // putExchangeMessages("logs7even1","Sending TOO SECOND"); // Thread.Sleep(500); // } } catch (Exception ex) { Console.WriteLine("Fehler: " + ex.Message); } finally { Console.WriteLine("fertig"); Console.ReadLine(); } }