void GetRowsRequestMessageReceived(ObjectBusMessage obj)
{
Console.WriteLine("GetRowsRequestMessageReceived()");
GetRowsRequestMessage request = (GetRowsRequestMessage)obj;
GetRowsResponseMessage response;
Table table;
lock (tables)
table = (Table)psc.GetTableByID(request.TableID);
Console.WriteLine(table.Name);
try {
SqlConnection conn_Rows = new SqlConnection(connectionString);
try {
conn_Rows.Open();
} catch { //retry once
conn_Rows.Open();
}
SqlCommand cmdSelect = new SqlCommand(string.Format("Select * from [{0}]", table.Name), conn_Rows);
cmdSelect.CommandTimeout *= 30;
response = new GetRowsResponseMessage(request.ID, readRowsData(conn_Rows, cmdSelect, cmdSelect.ExecuteReader(), table), null);
} catch (Exception ex) {
response = new GetRowsResponseMessage(request.ID, new List <BD2.Conv.Frontend.Table.Row> (), ex);
}
ObjectBusSession.SendMessage(response);
Console.WriteLine("Sent GetRowsResponseMessage.");
}
void GetRowsRequestMessageReceived(ObjectBusMessage obj)
{
GetRowsRequestMessage request = (GetRowsRequestMessage)obj;
Table t;
if (tables.TryGetValue(request.TableID, out t))
{
}
else
{
ObjectBusSession.SendMessage(new GetRowsResponseMessage(request.ID, new List <Row>(), new KeyNotFoundException()));
}
}
