示例#1
0
        private void TeacherEntrance_Click(object sender, EventArgs e)
        {
            string pasword  = null;
            int    userType = 0;

            connection.Open();
            sql = "SELECT UserType,UserId,Pasword  FROM LearnMath.dbo.[User] where UserId= '" + UserName.Text + "' and Pasword= '" + Password.Text + "' and UserType= '0'";
            //       sql = "SELECT UserId,Password  FROM ILMApp.dbo.LearnMath";

            command = new SqlCommand(sql, connection);

            SqlDataAdapter da = new SqlDataAdapter(command);

            dataReader = command.ExecuteReader();
            //while (dataReader.Read())
            //{
            //    userType = (int)dataReader.GetValue(0);
            //}

            if (!(dataReader.HasRows) || userType != 0)
            {
                MessageBox.Show("שם משתמש או סיסמא אינם נכונים");
            }
            else
            {
                int i = 1;
                this.Hide();
                MenegerAndTeacherForm T1 = new MenegerAndTeacherForm(i);

                T1.ShowDialog();
            }
            connection.Close();
        }
示例#2
0
        private void button1_Click(object sender, EventArgs e)
        {
            this.Hide();
            MenegerAndTeacherForm m = new MenegerAndTeacherForm();

            m.Show();
        }
示例#3
0
        // update game settings
        private void button2_Click(object sender, EventArgs e)
        {
            int    level      = 0;
            int    markSize   = 0;
            string background = null;
            string GameName   = null;

            if (!(comboBox1.Items.Contains("some value")))
            {
                try
                {
                    GameName = comboBox1.SelectedItem.ToString();
                }
                catch
                {
                }
                int GmameIndex = 0;
                switch (GameName)
                {
                case "הכרת ספרות":
                    GmameIndex = 1;
                    break;

                case "מנייה":
                    GmameIndex = 2;
                    break;

                case "התאמת ספרות לכמות":
                    GmameIndex = 3;
                    break;

                case "רצף מספרים":
                    GmameIndex = 4;
                    break;

                case "משחק הזיכרון":
                    GmameIndex = 5;
                    break;

                case "חיבור וחיסור":
                    GmameIndex = 6;
                    break;

                default:

                    GmameIndex = 0;
                    break;
                }

                if (SmallMouse.Checked)
                {
                    markSize = 0;
                }
                else
                {
                    markSize = 1;
                }

                if (MultiCollor.Checked)
                {
                    background = "MultiCollor";
                }
                else
                {
                    background = "blackBackground";
                }

                level = (int)(numericUpDown1.Value);

                if (GmameIndex == 0)
                {
                    MessageBox.Show("בחר משחק");
                }
                else
                {
                    CountNumGames++;
                    connection.Open();
                    sql     = "INSERT INTO [StudentPlay](PlayGameCode,GameCode,Level,UserId,MarkSize,background) VALUES('" + CountNumGames + "','" + GmameIndex + "', '" + level + "','" + UserID + "','" + markSize + "','" + background + "')";
                    command = new SqlCommand(sql, connection);
                    SqlDataAdapter da = new SqlDataAdapter(command);

                    command.ExecuteNonQuery();
                    connection.Close();
                    MessageBox.Show("פרטי משחק נשמרו");
                    connection.Close();
                    this.Hide();
                    MenegerAndTeacherForm mf = new MenegerAndTeacherForm();
                    mf.Show();
                }
            }
            else
            {
                MessageBox.Show("בחר משחק");
            }
        }