static void TestSyncMessage(object state)
{
SingleConnection client = (SingleConnection)state;
int count = SyncTestCount;
Stopwatch sw = new Stopwatch();
Console.WriteLine("Test sync message");
sw.Start();
try
{
for (int i = 0; i < count; i++)
{
client.SyncSend(11, buf, 60000);
}
sw.Stop();
Console.WriteLine("Finished. Elapse : {0} ms", sw.ElapsedMilliseconds);
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void CreateTableAdapter()
{
_workerTable.Clear();
_adapter = new SqlDataAdapter(@"SELECT* FROM workers", SingleConnection.NewConnection());
_adapter.Fill(_workerTable);
_dataGridView.DataSource = _workerTable;
}
/// <summary>
/// Construtor
/// </summary>
/// <param name="param"></param>
public Settings(SingleConnection param)
{
InitializeComponent();
userSettings = param;
// Set the UI to the Current Settings
updateUiWithCurrentSettings();
}
public void CreateTableAdapter()
{
try
{
string tmp = @"SELECT C.id as [ID], C.date as [Дата платежа], C.cost as [Сумма], W.name as [Водитель], C.note as [Примечание]
FROM cleaning_works AS C, workers AS W WHERE C.fk=W.id;";
_cleanTable.Clear();
_adapter = new SqlDataAdapter(tmp, SingleConnection.NewConnection());
_adapter.Fill(_cleanTable);
_dataGridView.DataSource = _cleanTable;
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
public CleaningWorks(DataGridView dataGridView, Label clean, Label pay, Label itog, MaskedTextBox maskedTextBox,
DateTimePicker dateTimePicker, TextBox textBox, ComboBox comboBox)
{
SingleConnection.NewConnection();
_connect = new WG_db();
_connect.cleaning_works.Load();
_cleanTable = new DataTable();
_dataGridView = dataGridView;
_maskedTextBox = maskedTextBox;
_dateTimePicker = dateTimePicker;
_textBox = textBox;
_comboBox = comboBox;
_cleansumm = clean;
_paysumm = pay;
_itogsumm = itog;
Summ();
}
static void TestASyncMessage(object state)
{
int count = (int)state;
SingleConnection client = new SingleConnection(_IPAddress, 2500);
client.ReceiveEventHandler += new EventHandler <ReceiveEventArgs>(ReceiveEventHandler);
client.ErrorEventHandler += new EventHandler <ErrorEventArgs>(ErrorEventHandler);
try
{
client.Connect(2000);
Stopwatch sw = new Stopwatch();
Console.WriteLine("Test async message");
sw.Start();
try
{
for (int i = 0; i < count; i++)
{
client.AsyncSend(10, buf);
}
sw.Stop();
Console.WriteLine("Finished. Elapse : {0} ms", sw.ElapsedMilliseconds);
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
client.Close();
}
}
public static void Run(string[] args)
{
Console.Write("Please input server IP Address [127.0.0.1]:");
string ipAddress = Console.ReadLine().Trim().ToLower();
if (ipAddress == "")
{
ipAddress = "127.0.0.1";
}
try
{
//************** SingConnection Example **********************
Console.Write("Press any key to start single connection example");
Console.ReadKey();
Console.WriteLine();
//Create a SingleConnection instanace that will try to connect to host specified in
//ipAddress and port (2500).
SingleConnection client =
new SingleConnection(new IPEndPoint(IPAddress.Parse(ipAddress), 2500));
client.ReceiveEventHandler += new EventHandler <ReceiveEventArgs>(ReceiveEventHandler);
client.Connect();
Console.WriteLine("AsyncSend: Hello world! I am Single");
//Send an asynchronously message to server
client.AsyncSend((UInt32)Event.OneWay, Encoding.UTF8.GetBytes("Hello world! I am Single"));
int number = 0;
try
{
Console.WriteLine("SyncSend {0}", number);
//send a synchronously message to server
//send a number with event: Event.Return to server and get the response from server
//with the number increased.
byte[] retData = client.SyncSend((UInt32)Event.Return, BitConverter.GetBytes(number));
number = BitConverter.ToInt32(retData, 0);
Console.WriteLine("Get {0}", number);
}
catch (Exception e)
{
Console.WriteLine(e);
}
Console.WriteLine("Waitting for 10 seconds to finish simple connection example.");
System.Threading.Thread.Sleep(10000);
client.Close();
//************* SingleConnectionCable Example *****************
Console.Write("Press any key to start single connection cable example");
Console.ReadKey();
Console.WriteLine();
//Create a SingleConnectionCable instance that will try to connect to host specified in
//ipAddress and port (2500).
//by default, SingleConnectionCable will try to connect automatically and including 6 tcp connections.
SingleConnectionCable clientCable =
new SingleConnectionCable(new IPEndPoint(IPAddress.Parse(ipAddress), 2500));
clientCable.ReceiveEventHandler += new EventHandler <ReceiveEventArgs>(ReceiveEventHandler);
clientCable.Connect();
Console.WriteLine("AsyncSend: Hello world! I am Cable {0}", clientCable.CableId);
//Send a one way message to server
clientCable.AsyncSend((UInt32)Event.OneWay, Encoding.UTF8.GetBytes(string.Format("Hello world! I am Cable {0}", clientCable.CableId)));
//Send object with bin serialization (By Default)
Console.WriteLine("Bin serialization");
clientCable.AsyncSend((UInt32)Event.Bin, "Bin serialization");
while (true)
{
Console.WriteLine("SyncSend {0}", number);
try
{
//send a number with event: Event.Return to server and get the response from server
//with the number increased.
byte[] retData = clientCable.SyncSend((UInt32)Event.Return, BitConverter.GetBytes(number));
number = BitConverter.ToInt32(retData, 0);
Console.WriteLine("Get {0}", number);
}
catch (Exception e)
{
Console.WriteLine(e);
}
Console.WriteLine("Quit when you press ESC. Else continue SyncSend.");
//Quit when you press ESC
if (Console.ReadKey().KeyChar == 0x1B)
{
clientCable.Close();
return;
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
Console.ReadLine();
}
}
public static void Test(string[] args)
{
Console.WriteLine("Start to test SigleConnection");
Console.Write("Please input package size:");
string strSize = Console.ReadLine();
Console.Write("Test Sync message? y /n :");
string testSyncMessage = Console.ReadLine().Trim().ToLower();
Console.Write("Please input server IP Address:");
_IPAddress = Console.ReadLine().Trim().ToLower();
if (_IPAddress == "")
{
_IPAddress = "127.0.0.1";
}
int packageSize;
if (!int.TryParse(strSize, out packageSize))
{
packageSize = 64;
}
if (packageSize < 0)
{
packageSize = 0;
}
Console.WriteLine("IPAddress = {0}", _IPAddress);
Console.WriteLine("Package size = {0}", packageSize);
buf = new byte[packageSize];
int count = AsyncTestCount;
//int count = 10000;
for (int i = 0; i < buf.Length; i++)
{
buf[i] = (byte)i;
}
try
{
if (testSyncMessage == "y")
{
Console.Write("Please input test thread number:");
string strThreadNumber = Console.ReadLine();
int threadNumber;
if (!int.TryParse(strThreadNumber, out threadNumber))
{
threadNumber = 1;
}
Console.WriteLine("Actual test thread number = {0}", threadNumber);
SingleConnection client = new SingleConnection(_IPAddress, 2500);
client.ReceiveEventHandler += new EventHandler <ReceiveEventArgs>(ReceiveEventHandler);
client.ErrorEventHandler += new EventHandler <ErrorEventArgs>(ErrorEventHandler);
client.Connect(2000);
for (int i = 0; i < threadNumber; i++)
{
System.Threading.Thread thread = new System.Threading.Thread(TestSyncMessage);
thread.IsBackground = true;
thread.Start(client);
}
//TestSyncMessage(100000);
}
else
{
TestASyncMessage(count);
//for (int i = 0; i < 5; i++)
//{
// System.Threading.Thread thread = new System.Threading.Thread(TestASyncMessage);
// thread.IsBackground = true;
// thread.Start(count);
//}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
System.Threading.Thread.Sleep(System.Threading.Timeout.Infinite);
}
public TemplateEntities()
: base(SingleConnection.GetConnection(), false)
{
}
public AccessContext(string filePath)
: base(SingleConnection.GetConnection(filePath), false)
{
}
public void InsertCommand()
{
try
{
SqlCommand _insert = new SqlCommand(@"INSERT INTO workers (name, phone ) VALUES (@name, @phone);", SingleConnection.NewConnection());
_insert.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 100));
_insert.Parameters.Add(new SqlParameter("@phone", SqlDbType.VarChar, 16));
_insert.Parameters["@name"].SourceVersion = DataRowVersion.Current;
_insert.Parameters["@phone"].SourceVersion = DataRowVersion.Current;
_insert.Parameters["@name"].SourceColumn = "name";
_insert.Parameters["@phone"].SourceColumn = "phone";
_adapter.InsertCommand = _insert;
SqlCommandBuilder _builder = new SqlCommandBuilder(_adapter);
_adapter.Update(_workerTable);
CreateTableAdapter();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Workers(DataGridView dataGridView)
{
SingleConnection.NewConnection();
_workerTable = new DataTable();
_dataGridView = dataGridView;
}
