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();
* }*/
}
