void clickButtonToDraw(object sender, EventArgs e)
{
Button bt1 = (Button)sender;
if (clickMenu == 1)
{
//Lấy level của nút này
try
{
string query_getLevel = @"SELECT button_level FROM dbo.BUTTON WHERE survey_id = " + idMucTieu + " AND button_name=N'" + bt1.Name + "'";
int getlevel = Convert.ToInt32(ketnoisql.ExecuteScalar(query_getLevel));
if (getlevel < Main.levelNumber - 1)
{
frmInputData f = new frmInputData(bt1.Name, bt1.Text, idMucTieu);
f.StartPosition = FormStartPosition.CenterScreen;
f.Show();
}
}
catch (SqlException)
{
}
}
else if (clickMenu == 2)
{
try
{
string query_getLevel = @"SELECT button_level FROM dbo.BUTTON WHERE survey_id = " + idMucTieu + " AND button_name=N'" + bt1.Name + "'";
int getlevel = Convert.ToInt32(ketnoisql.ExecuteScalar(query_getLevel));
//MessageBox.Show(Form1.levelNumber.ToString());
//MessageBox.Show("có level ="+getlevel.ToString());
if (getlevel < Main.levelNumber - 1 - 1)
{
Form3 f = new Form3(bt1.Name, bt1.Text);
f.Show();
}
}
catch (SqlException)
{
}
}
else
{
totalButtonToDraw++;
if (totalButtonToDraw == 1)
{
pointRight.X = bt1.Left + 100;
pointRight.Y = bt1.Top + 15;
pointLeft.X = bt1.Left;
pointLeft.Y = bt1.Top + 15;
//Luu id button so 1 bang text id_button_1 = select id_button from BUTTON with button_name = bt1.Name
indexFirstButton = bt1.Name;
}
if (totalButtonToDraw == 2)
{
//Luu id button so 1 bang text indexSecondButton = select id_button from BUTTON with button_name = bt1.Name
indexSecondButton = bt1.Name;
//Kiểm tra xem 2 button này có trong bảng kết nối không
string queryString_connect_scalar_1 = @"select count(*) FROM CONNECT
WHERE (survey_id = " + idMucTieu + " AND CONNECT.connect_button_highLevel = N'" + indexFirstButton + "' AND CONNECT.connect_button_lowLevel = N'" + indexSecondButton + "')";
//MessageBox.Show("Nút "+id_button_1+" và "+indexSecondButton+" có EXECUTESCALR = "+ketnoisql.ExecuteScalar(queryString_connect_scalar_1).ToString());
string queryString_connect_scalar_2 = @"select count(*) FROM CONNECT
WHERE (survey_id = " + idMucTieu + " AND CONNECT.connect_button_highLevel = N'" + indexSecondButton + "' AND CONNECT.connect_button_lowLevel = N'" + indexFirstButton + "')";
//MessageBox.Show("space cua button " + id_button_1 + " la " + (string)ketnoisql.ExecuteScalar(queryString_space_button1));
string queryString_space_button1 = @"SELECT button_space FROM BUTTON
WHERE (survey_id = " + idMucTieu + " AND button_name = N'" + indexFirstButton + "')";
string queryString_space_button2 = @"SELECT button_space FROM BUTTON
WHERE (survey_id = " + idMucTieu + " AND button_name = N'" + indexSecondButton + "')";
string space_button_1 = (string)ketnoisql.ExecuteScalar(queryString_space_button1);
string space_button_2 = (string)ketnoisql.ExecuteScalar(queryString_space_button2);
string queryString_space = "";
//MessageBox.Show("space cua button " + id_button_1 + " la " + ketnoisql.ExecuteScalar(queryString_space_button1).ToString() + "\n space cua button " + indexSecondButton + " la " + ketnoisql.ExecuteScalar(queryString_space_button2).ToString());
if (Convert.ToInt32(space_button_1) > Convert.ToInt32(space_button_2))
{
queryString_space = @"select count (*) FROM BUTTON
WHERE(survey_id = " + idMucTieu + " AND button_space < N'" + space_button_1 + "' AND button_space > N'" + space_button_2 + "')";
}
else
{
queryString_space = @"select count (*) FROM BUTTON
WHERE(survey_id = " + idMucTieu + " AND button_space > N'" + space_button_1 + "' AND button_space < N'" + space_button_2 + "')";
}
if ((int)ketnoisql.ExecuteScalar(queryString_connect_scalar_1) != 0 || (int)ketnoisql.ExecuteScalar(queryString_connect_scalar_2) != 0)
{
MessageBox.Show("Đã có nét vẽ rồi");
totalButtonToDraw = 0;
}
//Kiểm tra xem có vẽ nhảy cóc hay không
else if ((int)ketnoisql.ExecuteScalar(queryString_space) != 0)
{
MessageBox.Show("Không vẽ nhảy cóc");
totalButtonToDraw = 0;
}
else
{
//Vẽ
DrawLineConnectButtonAndInsertData(bt1);
totalButtonToDraw = 0;
}
}
}
}
void clickButtonToDraw(object sender, EventArgs e)
{
Button bt1 = (Button)sender;
if (clickMenu == 1)
{
//Lấy level của nút này
try
{
string query_getLevel = @"SELECT button_level FROM dbo.BUTTON WHERE survey_id = " + idMucTieu + " AND button_name=N'" + bt1.Name + "'";
int getlevel = Convert.ToInt32(ketnoisql.ExecuteScalar(query_getLevel));
if (getlevel < Main.levelNumber - 1)
{
frmInputData f = new frmInputData(bt1.Name, bt1.Text, idMucTieu);
f.StartPosition = FormStartPosition.CenterScreen;
f.Show();
}
}
catch (SqlException)
{
}
}
else if (clickMenu == 2)
{
try
{
string query_getLevel = @"SELECT button_level FROM dbo.BUTTON WHERE survey_id = " + idMucTieu + " AND button_name=N'" + bt1.Name + "'";
int getlevel = Convert.ToInt32(ketnoisql.ExecuteScalar(query_getLevel));
//MessageBox.Show(Form1.levelNumber.ToString());
//MessageBox.Show("có level ="+getlevel.ToString());
if (getlevel < Main.levelNumber - 1 - 1)
{
Form3 f = new Form3(bt1.Name, bt1.Text);
f.Show();
}
}
catch (SqlException)
{
}
}
else
{
totalButtonToDraw++;
if (totalButtonToDraw == 1)
{
pointRight.X = bt1.Left + 100;
pointRight.Y = bt1.Top + 15;
pointLeft.X = bt1.Left;
pointLeft.Y = bt1.Top + 15;
//Luu id button so 1 bang text id_button_1 = select id_button from BUTTON with button_name = bt1.Name
indexFirstButton = bt1.Name;
}
if (totalButtonToDraw == 2)
{
//Luu id button so 1 bang text indexSecondButton = select id_button from BUTTON with button_name = bt1.Name
indexSecondButton = bt1.Name;
//Kiểm tra xem 2 button này có trong bảng kết nối không
string queryString_connect_scalar_1 = @"select count(*) FROM CONNECT
WHERE (survey_id = " + idMucTieu + " AND CONNECT.connect_button_highLevel = N'" + indexFirstButton + "' AND CONNECT.connect_button_lowLevel = N'" + indexSecondButton + "')";
//MessageBox.Show("Nút "+id_button_1+" và "+indexSecondButton+" có EXECUTESCALR = "+ketnoisql.ExecuteScalar(queryString_connect_scalar_1).ToString());
string queryString_connect_scalar_2 = @"select count(*) FROM CONNECT
WHERE (survey_id = " + idMucTieu + " AND CONNECT.connect_button_highLevel = N'" + indexSecondButton + "' AND CONNECT.connect_button_lowLevel = N'" + indexFirstButton + "')";
//MessageBox.Show("space cua button " + id_button_1 + " la " + (string)ketnoisql.ExecuteScalar(queryString_space_button1));
string queryString_space_button1 = @"SELECT button_space FROM BUTTON
WHERE (survey_id = " + idMucTieu + " AND button_name = N'" + indexFirstButton + "')";
string queryString_space_button2 = @"SELECT button_space FROM BUTTON
WHERE (survey_id = " + idMucTieu + " AND button_name = N'" + indexSecondButton + "')";
string space_button_1 = (string)ketnoisql.ExecuteScalar(queryString_space_button1);
string space_button_2 = (string)ketnoisql.ExecuteScalar(queryString_space_button2);
string queryString_space = "";
//MessageBox.Show("space cua button " + id_button_1 + " la " + ketnoisql.ExecuteScalar(queryString_space_button1).ToString() + "\n space cua button " + indexSecondButton + " la " + ketnoisql.ExecuteScalar(queryString_space_button2).ToString());
if (Convert.ToInt32(space_button_1) > Convert.ToInt32(space_button_2))
queryString_space = @"select count (*) FROM BUTTON
WHERE(survey_id = " + idMucTieu + " AND button_space < N'" + space_button_1 + "' AND button_space > N'" + space_button_2 + "')";
else
queryString_space = @"select count (*) FROM BUTTON
WHERE(survey_id = " + idMucTieu + " AND button_space > N'" + space_button_1 + "' AND button_space < N'" + space_button_2 + "')";
if ((int)ketnoisql.ExecuteScalar(queryString_connect_scalar_1) != 0 || (int)ketnoisql.ExecuteScalar(queryString_connect_scalar_2) != 0)
{
MessageBox.Show("Đã có nét vẽ rồi");
totalButtonToDraw = 0;
}
//Kiểm tra xem có vẽ nhảy cóc hay không
else if ((int)ketnoisql.ExecuteScalar(queryString_space) != 0)
{
MessageBox.Show("Không vẽ nhảy cóc");
totalButtonToDraw = 0;
}
else
{
//Vẽ
DrawLineConnectButtonAndInsertData(bt1);
totalButtonToDraw = 0;
}
}
}
}
