.NET (Core and Framework)

SELECT     i.item_id, i.sequence, i.item_name, od.buy_price, od.sell_price,
SUM(od.quantity) AS sum_qty,
l.location_name, oh.usr_login,
CASE i.is_composite_item WHEN 1 THEN "anything" WHEN 0 THEN "something" END AS remarks
FROM         item i, operation_detail od,operation_header oh,location l
WHERE
i.item_id=od.item_id and i.sequence=od.sequence and
od.operation_header_id=oh.operation_header_id and
oh.location_id=l.location_id and
  (oh.operation_type_id = "anything") AND
 (oh.operation_date >= @date_from ) AND
 (oh.operation_date <= @date_to ) AND
 (i.item_id >= @item_id_from OR @item_id_from = 0)
  AND (i.item_id <= @item_id_to OR @item_id_to = 0)
  AND (l.location_id = @location_id OR @location_id = '0')
  AND (i.is_raw_item = 0)
GROUP BY i.item_id, i.sequence, i.item_name, l.location_name,
 oh.usr_login, od.buy_price, od.sell_price,i.is_composite_item
order by i.item_id, i.sequence,l.location_name

private void MainLoad(object sender, EventArgs e)
{
    MessageQueue.Create(@"MYPC\MyQueue", false);
    MessageQueue queue = new MessageQueue(queueName);
    queue.BeginPeek(TimeSpan.FromDays(10.0),messagenumber++, new AsyncCallback(MyPeekCompleted));
}

private void MyPeekCompleted(IAsyncResult asyncResult)
{
    MessageQueue queue = new MessageQueue(@"MYPC\MyQueue");
    queue.Formatter = new BinaryMessageFormatter();
    System.Messaging.Message msg = queue.Receive(TimeSpan.FromDays(10.0));
    Protocol p = (Protocol)msg.Body;
    queue.BeginPeek(TimeSpan.FromDays(10.0), messagenumber++, new AsyncCallback(MyPeekCompleted));
}

private void ButtonSendClick(object sender, EventArgs e)
{
    MessageQueue queue = new MessageQueue(@"MYPC\MyQueue");
    Bitmap bmp = new Bitmap(@"D:\lena.gif");
    Protocol p = new Protocol();
    p.text = "test";
    p.sender = senderID;
    p.receiver = "Client";
    p.bitmap = bmp;

    System.Messaging.Message m = new System.Messaging.Message(p, new BinaryMessageFormatter());
    queue.Send(m);
}

[Serializable()]
public class Protocol
{
    public string sender;
    public string receiver;
    public string text;
    public System.Drawing.Image bitmap;
}

private void MainLoad(object sender, EventArgs e)
{
    MessageQueue queue = new MessageQueue(@"MYPC\MyQueue");
    queue.BeginPeek(TimeSpan.FromDays(10.0),messagenumber++, new AsyncCallback(MyPeekCompleted));
}

private void MyPeekCompleted(IAsyncResult asyncResult)
{
    MessageQueue queue = new MessageQueue(@"MYPC\MyQueue");
    queue.Formatter = new BinaryMessageFormatter();
    System.Messaging.Message msg = queue.Receive(TimeSpan.FromSeconds(10.0));
    Protocol p = (Protocol)msg.Body;
    queue.BeginPeek(TimeSpan.FromDays(10.0), messagenumber++, new AsyncCallback(MyPeekCompleted));
}