private void BtnLoginTeacher_Click(object sender, EventArgs e) { this.Hide(); var form2 = new LoginTeacher(); form2.Closed += (s, args) => this.Close(); form2.Show(); }
private void BtnSave_Click(object sender, EventArgs e) { string surnamee = textSurname.Text; string namee = textName.Text; string mail = textMail.Text; string num = textNumber.Text; bool isIntSurname = surnamee.All(char.IsDigit); bool isIntName = namee.All(char.IsDigit); bool isLetterNumber = num.All(char.IsLetter); if (comboEducation.Text != "" && comboGender.Text != "" && isIntSurname == false && !surnamee.Contains(" ") && isLetterNumber == false && !num.Contains(" ") && numericAge.Value != 0 && textBoxPass.TextLength > 4 && textBoxLog.TextLength > 4 && mail.Contains("@")) { if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlCommand sqlCmd = new SqlCommand("AddTeacher", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@mode", "Add"); sqlCmd.Parameters.AddWithValue("@opetajaId", 0); sqlCmd.Parameters.AddWithValue("@Name", textName.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Surname", textSurname.Text.Trim()); sqlCmd.Parameters.AddWithValue("@MobileNumber", textNumber.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Address", textNumber.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Mail", textMail.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Age", numericAge.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Education", comboEducation.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Description", textDescription.Text.Trim()); if (comboGender.SelectedIndex == 0) { sqlCmd.Parameters.AddWithValue("@Gender", "Male"); } if (comboGender.SelectedIndex == 1) { sqlCmd.Parameters.AddWithValue("@Gender", "Female"); } if (comboGender.SelectedIndex == 2) { sqlCmd.Parameters.AddWithValue("@Gender", "Other"); } sqlCmd.Parameters.AddWithValue("@ClassroomTeacher", 0); sqlCmd.Parameters.AddWithValue("@Login", textBoxLog.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Password", textBoxPass.Text.Trim()); sqlCmd.ExecuteNonQuery(); // вывод MessageBox.Show("Saved successfull"); checkcount = 1; this.Hide(); var form2 = new LoginTeacher(); form2.Closed += (s, args) => this.Close(); form2.Show(); LoginTeacher.autoLog = true; } if (checkcount == 0) { if (textBoxPass.TextLength < 4 && textBoxPass.TextLength != 0) { textBoxPass.ForeColor = Color.Firebrick; MessageBox.Show("password must contain at least 4 characters"); } if (textBoxLog.TextLength < 4 && textBoxLog.TextLength != 0) { textBoxLog.ForeColor = Color.Firebrick; MessageBox.Show("login must contain at least 4 characters"); } else { MessageBox.Show("Please fill the fields correctly"); } } /* if(ListSubjects.SelectedItems.Count!=0) * { * MessageBox.Show("at least 1 subject"); * } * if (isIntSurname==false && !surnamee.Contains(" ")) * { * MessageBox.Show("no numbers and probel"); * } * if (isLetterNumber == false && !num.Contains(" ")) * { * MessageBox.Show("no leters and probel in number"); * } * else if(numericAge.Value==0) * { * MessageBox.Show("Please choose your age"); * } * * else * { * this.Hide(); * var form2 = new TeacherDiarycs(); * form2.Closed += (s, args) => this.Close(); * form2.Show(); * }*/ }