class MyImage
        {
            public int Left;
            public int Top;
            public int Right;
            public int Bottom;
            public Size size;

            public MyImage(PictureBox pbMain)
            {
                this.size = getZoomedImage(pbMain);
                this.Left = (pbMain.ClientSize.Width - size.Width) / 2;
                this.Top = (pbMain.ClientSize.Height - size.Height) / 2;
                generate_RightBottom();
                rounding();
            }
            
            private void generate_RightBottom()
            {
                this.Right = this.Left + this.size.Width;
                this.Bottom = this.Top + this.size.Height;
            }
            private void rounding()
            {
                size.Width = takeTenPercent(size.Width);
                size.Height = takeTenPercent(size.Height);
            }
            private int takeTenPercent(int value)
            {
                if (value % 10 > 0)
                    return Convert.ToInt32(Math.Round((double)value / 10) * 10);
                return value;
            }
            //get size of image after zoom in picturebox
            private static Size getZoomedImage(PictureBox pictureBox1)
            {
                float x = pictureBox1.ClientSize.Width; // Ширина клиентской области
                float y = pictureBox1.ClientSize.Height; // Высота клиентской области

                float z1 = pictureBox1.Image.Width; //Ширина загруженного изображения
                float z2 = pictureBox1.Image.Height; //Высота загруженного изображения

                float q;  // Коэффициент
                float q1; //Отмасштабированная ширина
                float q2; //Отмасштабированная высота

                if (z1 > x | z2 > y)
                {
                    if (z1 > z2)  // z1>x
                    {
                        q = z1 / x;//коофіцієнт = восота зобр/ висота блоку

                        q1 = z1 / q;
                        q2 = z2 / q;
                        if (q2 > y)
                        {
                            q = z2 / y;
                            q1 = z1 / q;
                            q2 = z2 / q;
                            return new Size((int)q1, (int)q2);
                        }
                        else
                        {
                            return new Size((int)q1, (int)q2);
                        }
                    }
                    if (z2 > z1)  // z2>y
                    {
                        q = z2 / y;
                        q1 = z1 / q;
                        q2 = z2 / q;
                        if (q1 > x)
                        {
                            q = z1 / x;
                            q1 = z1 / q;
                            q2 = z2 / q;
                            return new Size((int)q1, (int)q2);
                        }
                        else
                        {
                            return new Size((int)q1, (int)q2);
                        }
                    }
                }
                return new Size((int)z1, (int)z2);
            }

        }

        class MyCell
        {
            public Size size;

            public MyCell(MyImage image, int cellCountRows, int cellCountColumns)
            {
                this.size = new Size(Convert.ToInt32(image.size.Width / cellCountColumns), Convert.ToInt32(image.size.Height / cellCountRows));
            }
        }

        class MyCurrentCellPosition
        {
            MyImage image;
            public int x;
            public int y;

            public MyCell cell;

            public MyCurrentCellPosition(MyImage image, MyCell cell)
            {
                this.x = image.Left;
                this.y = image.Top;
                this.image = image;
                this.cell = cell;
            }

            public void NewRow()
            {
                this.y += cell.size.Height;
                this.x = image.Left;
            }

            public void NewCell()
            {
                this.x += cell.size.Width;
            }
        }

public static void CreateSections(PictureBox pbMain, IDictionary<string, string> dic, int cellCountRows = 20, int cellCountColumns =20 )
{
	MyImage image = new MyImage(pbMain);
	MyCell cell = new MyCell(image, cellCountRows, cellCountColumns);
	MyCurrentCellPosition curr = new MyCurrentCellPosition(image, cell);
	
	Cell[] cells = new Cell[401];
	for (int y = 1; y <= cellCountRows; y++)
	{
		for (int x = 1; x <= cellCountColumns; x++)
		{
			int number = x * y;
			cells[number] = new Cell(number, curr.y, curr.x, cell.size, dic["id"], ConnStr);
			curr.NewCell();
		}
		curr.NewRow();
	}
	pbMain.SuspendLayout();
	pbMain.Controls.AddRange(cells);
	pbMain.ResumeLayout();
}

        public Cell(int number, int Top, int Left, Size size, string dic_id, string ConnStr)
        {
            InitializeComponent();
            this.Name = "VisComponent" + number.ToString();
            this.Top = Top;
            this.Left = Left;
            this.lblText.Text = number.ToString();
            this.Size = size;

            this.lblText.Size = this.Size;
            this.pnMain.Size = this.Size;

            
            this.pnMain.Click += delegate(object o, EventArgs e)
            {

                using (SqlConnection con = new SqlConnection(ConnStr))
                {
                    this.lblText.Visible = true;
                    this.lblText.ForeColor = Color.Red;
                    this.lblText.BackColor = Color.Red;

                    con.Open();
                    string sql = " insert into tbl_Transaction(AssmID, Position, LastUpdate) " +
                                    " values(@AssmID, @Position, GETDATE()) ";
                    using (SqlCommand com = new SqlCommand(sql, con))
                    {
                        com.Parameters.Add("@AssmID", dic_id);
                        com.Parameters.Add("@Position", this.lblText.Text);
                        com.ExecuteNonQuery();
                    }
                }

                System.Windows.Forms.Timer timer = new System.Windows.Forms.Timer();
                timer.Interval = 1000;
                timer.Tick += (source, u) => { this.lblText.Visible = false; timer.Stop(); };
                timer.Start();
            };
        }

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Drawing;
using System.Windows.Forms;

namespace TouchUpDataCollection.Classes
{
    public class MySensorPictureBox : PictureBox
    {
        private MyImage myImage;
        private MyCell cell;
        private MyCurrentCell curr_cell;
        private IDictionary<string, string> addDic;
        private Size matrixSize;
        private Size matrixAllCellsSize {
                        get { return new Size((this.cell.Size.Width*this.matrixSize.Width) + this.myImage.Left,
                                                (this.cell.Size.Height * (this.matrixSize.Height)) + this.myImage.Top);
                                              //(this.cell.Size.Height*(this.matrixSize.Height - 1)) + this.myImage.Top);
                        }
        }
        public string ConnStr = "";
        public bool isSensorMatrixActive { get { return (this.cell == null) ? false : true; } }
        public bool isMatrix(int x, int y)
        {
            if (this.myImage.Left > x) return false;
            if (this.matrixAllCellsSize.Width < x) return false;
            if (myImage.Top > y) return false;
            if (this.matrixAllCellsSize.Height < y) return false;
            return true;
            /*
            return ((this.myImage.Left <= x)
                 && (x <= (this.matrixAllCellsSize.Width))
                 && (myImage.Top <= y)
                 && (y <= (this.matrixAllCellsSize.Height)));
            */
        }
        //private int WidthAllCells()

        protected override void OnMouseDown(MouseEventArgs e)
        {
            base.OnMouseDown(e);
            if (this.isSensorMatrixActive)
                if (this.isMatrix(e.X, e.Y))
                    this.showBar(new Point(e.X, e.Y));
        }

        private Size getSizeCell()
        {
            return new Size(Convert.ToInt32(this.myImage.size.Width / this.matrixSize.Width), Convert.ToInt32(this.myImage.size.Height / this.matrixSize.Height));
        }

        public void ActivateSensorMatrix(IDictionary<string, string> addDic, string ConnStr, int cellCountRows, int cellCountColumns)
        {
            if (base.Image == null)
            {
                MessageBox.Show("Image is empty!",Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }
            this.myImage = new MyImage(this);
            //--this.myImage = new MyImage(this.ClientSize, this.Image.Size);
            this.addDic = addDic;
            this.ConnStr = ConnStr;
            this.matrixSize.Height = cellCountRows;
            this.matrixSize.Width = cellCountColumns;
            this.cell = new MyCell(getSizeCell());
            //this.matrixAllCellsSize = new 
        }

        public void showBar(Point clickPosition)
        {
            this.curr_cell = new MyCurrentCell(this.cell.Size, clickPosition, this.matrixSize, new Size(this.myImage.Left, this.myImage.Top) );

            if (this.curr_cell.Number > (this.matrixSize.Width * this.matrixSize.Height))
                return;
            MessageBox.Show("x=" + clickPosition.X + "; y=" + clickPosition.Y + "; number = " + this.curr_cell.Number);

            Cell r = new Cell(curr_cell.Location, curr_cell.Size);
            this.Controls.Add(r);
            Cell.Activate(r);
            Cell.SaveClickToDB(this.ConnStr, addDic["id"], this.curr_cell.Number);
            
            System.Windows.Forms.Timer timer = new System.Windows.Forms.Timer();
            timer.Interval = 1000;
            timer.Tick += (source, u) => { Cell.UnActivate(r); timer.Stop(); this.Controls.Remove(r); r.Dispose(); };
            timer.Start();
            
            
            //Cell.processingpnMain_Event_OnClick(r, curr_cell.Number, this.ConnStr, this.addDic["id"]);
        }

        private void InitializeComponent()
        {
            ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
            this.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
            this.ResumeLayout(false);

        }
    }
    
    class MyImage
    {
        public int Left;
        public int Top;
        public int Right;
        public int Bottom;
        public Size size;
        //!!!з розміром зображення фігня твориться
        public MyImage(PictureBox pb)
        {
            this.size = getZoomedImage(pb);
            this.Left = (pb.ClientSize.Width - size.Width) / 2;
            this.Top = (pb.ClientSize.Height - size.Height) / 2;
            generate_RightBottom();
            rounding();
        }
        /*
        public MyImage(Size ClientSize, Size sizeImage)
        {
            this.size = getZoomedImage(ClientSize, sizeImage);
            this.Left = (ClientSize.Width - size.Width) / 2;
            this.Top = (ClientSize.Height - size.Height) / 2;
            generate_RightBottom();
            rounding();
        }*/


        private void generate_RightBottom()
        {
            this.Right = this.Left + this.size.Width;
            this.Bottom = this.Top + this.size.Height;
        }
        private void rounding()
        {
            size.Width = takeTenPercent(size.Width);
            size.Height = takeTenPercent(size.Height);
        }
        private int takeTenPercent(int value)
        {
            if (value % 10 > 0)
                return Convert.ToInt32(Math.Round((double)value / 10) * 10);
            return value;
        }
        //get size of image after zoom in picturebox
        private static Size getZoomedImage(PictureBox p)
        {
            return getZoomedImage(p.ClientSize, p.Image.Size);
        }

        private static Size getZoomedImage(Size clientSize, Size imageSize)
        {
            float x = clientSize.Width; // Ширина клиентской области
            float y = clientSize.Height; // Высота клиентской области

            float z1 = imageSize.Width; //Ширина загруженного изображения
            float z2 = imageSize.Height; //Высота загруженного изображения

            float q;  // Коэффициент
            float q1; //Отмасштабированная ширина
            float q2; //Отмасштабированная высота

            if (z1 > x | z2 > y)
            {
                if (z1 > z2)  // z1>x
                {
                    q = z1 / x;//коофіцієнт = восота зобр/ висота блоку

                    q1 = z1 / q;
                    q2 = z2 / q;
                    if (q2 > y)
                    {
                        q = z2 / y;
                        q1 = z1 / q;
                        q2 = z2 / q;
                        return new Size((int)q1, (int)q2);
                    }
                    else
                    {
                        return new Size((int)q1, (int)q2);
                    }
                }
                if (z2 > z1)  // z2>y
                {
                    q = z2 / y;
                    q1 = z1 / q;
                    q2 = z2 / q;
                    if (q1 > x)
                    {
                        q = z1 / x;
                        q1 = z1 / q;
                        q2 = z2 / q;
                        return new Size((int)q1, (int)q2);
                    }
                    else
                    {
                        return new Size((int)q1, (int)q2);
                    }
                }
            }
            return new Size((int)z1, (int)z2);
        }

    }

    class MyCell//:Padding
    {
        public Size Size;


        public MyCell(MyImage image, int cellCountRows, int cellCountColumns)
        {
            this.Size = new Size(Convert.ToInt32(image.size.Width / cellCountColumns), Convert.ToInt32(image.size.Height / cellCountRows));
        }

        public MyCell(Size size)
        {
            this.Size = size;
        }

    }

    class MyCurrentCellPosition
    {
        MyImage image;
        public int x;
        public int y;
        public Int32 number=1;

        public MyCell cell;

        public MyCurrentCellPosition(MyImage image, MyCell cell)
        {
            this.x = image.Left;
            this.y = image.Top;
            this.image = image;
            this.cell = cell;
            //--this.number = 1;
        }

        public void NewCell()
        {
            this.number++;
            this.x += cell.Size.Width;
        }

        public void NewRow()
        {
            this.y += cell.Size.Height;
            this.x = image.Left;
        }
        /*
        public static Size LocationCellByNumber(int number)
        {
            return new Size(number, number);
        }
        */
    }


    class MyCurrentCell : MyCell
    {
        //public Point CoordinateXY;
        public Padding Pannding { get { return new Padding(this.Left, this.Top, this.Right, this.Bottom); } set { this.Left = value.Left; this.Right = value.Right; this.Top = value.Top; this.Bottom = value.Bottom; } }
        public Point Location;
        //public Size Size;
        public int Right { get { return (this.Location.X + this.Size.Width); } set { this.Size.Width = value - this.Location.X; } }
        public int Bottom { get { return (this.Location.Y + this.Size.Height); } set { this.Size.Height = value - this.Location.Y; } }
        public int Left { get { return this.Location.X; } set { this.Location.X = value; } }
        public int Top { get { return this.Location.Y; } set { this.Location.Y = value; } }

        private Size matrixSize;
        private Size LeftTopImagePosition;

        public int Number = 0;
        public MyCurrentCell(Size size, Point clickPosition, Size matrixSize, Size LeftTopImagePosition): base(size)
        {
            this.Size = size;
            this.LeftTopImagePosition = LeftTopImagePosition;
            this.matrixSize = matrixSize;
            this.Location = getCoordinate(clickPosition);
            this.Number = getNumber(LeftTopImagePosition, clickPosition);
            
        }
        //визначає номер комірки
        private int getNumber(Size locationComponent, Point coordinate)
        {
            int res = 1;
            int count_x = ((coordinate.X - locationComponent.Width) / this.Size.Width)+1;
            int count_y = ((coordinate.Y - locationComponent.Height) / this.Size.Height);

            //if(count_y > 0) count_y = (count_y * this.matrixSize.Width) - 1) else count_y 0;
            count_y = (count_y > 0) ? (count_y * this.matrixSize.Width) : 0;

            //з підрахунком тоже странне
            res = count_y + count_x;
            if (res < 1) res = 1;

            return res;
        }

        //визначає координати блока
        private Point getCoordinate(Point mice)
        {
            int count_x, count_y, cell_left, cell_top;

            //count_x = (mice.X / this.Size.Width);
            count_x = getCountCellsByX(mice.X);
            cell_left = this.LeftTopImagePosition.Width+((count_x) * this.Size.Width);

            //count_y = (mice.Y / this.Size.Height);
            count_y = getCountCellsByY(mice.Y);
            cell_top = this.LeftTopImagePosition.Height + ((count_y) * this.Size.Height);

            return new Point(cell_left, cell_top);
        }

        private int getCountCellsByX(int x)
        {
            int w = this.LeftTopImagePosition.Width;
            return ((x - w) / this.Size.Width);
        }

        private int getCountCellsByY(int y)
        {
            int h = this.LeftTopImagePosition.Height;
            return ((y -h) / this.Size.Height);
        }

        public static Size LocationCellByNumber(Point positionImage, Size sizeCell, Size matrixSize, int number)
        {
            number--;
            int x, y, y_count_max = matrixSize.Height;
            y = (number / y_count_max);
            x = (number - (y * y_count_max));
            
            y = positionImage.Y+(y*sizeCell.Height);
            x = positionImage.X + (x*sizeCell.Width);

            return new Size(x, y);
        }
    }


}