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