private void BtnReg_Click(object sender, EventArgs e) { string query = "Select Name, Surname from tbl_Opetaja Where Login ='******' and Password = '******'"; SqlDataAdapter sda = new SqlDataAdapter(query, sqlCon); DataTable dtbl = new DataTable(); sda.Fill(dtbl); if (dtbl.Rows.Count == 1) { dataGridView1.DataSource = dtbl; dataGridView1.Visible = true; getText = dataGridView1.CurrentRow.Cells[0].Value.ToString() + " " + dataGridView1.CurrentRow.Cells[1].Value.ToString(); this.Hide(); var form2 = new TeacherDiarycs(); form2.Closed += (s, args) => this.Close(); form2.Show(); LoginTeacher.autoLog = true; } else { LoginTeacher.autoLog = false; labelPass.Text = "wrong login or password"; labelPass.Visible = true; labelPass.ForeColor = Color.Firebrick; } }
private void LoginTeacher_Load(object sender, EventArgs e) { MainMenu.checkAnimation = true; if (LoginTeacher.autoLog) { this.Hide(); var form2 = new TeacherDiarycs(); form2.Closed += (s, args) => this.Close(); form2.Show(); } }
private void Button2_Click(object sender, EventArgs e) { if (LoginTeacher.autoLog) { this.Hide(); var form2 = new TeacherDiarycs(); form2.Closed += (s, args) => this.Close(); form2.Show(); } else { MessageBox.Show("You are not logged in", "Error"); } }
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 (checkTeacher.Checked) { if (comboEducation.Text != "" && comboGender.Text != "" && ListSubjects.SelectedItems.Count != 0 && isIntSurname == false && !surnamee.Contains(" ") && isLetterNumber == false && !num.Contains(" ") && numericAge.Value != 0 && textBoxPass.TextLength > 4 && textBoxLog.TextLength > 4 && numericStudents.Value != 0 && comboClassnum.Text != "" && mail.Contains("@") && !mail.StartsWith("@")) { 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()); sqlCmd.Parameters.AddWithValue("@TaughtSubjects", ListSubjects.SelectedItems.ToString().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", 1); sqlCmd.Parameters.AddWithValue("@ClassNumber", comboClassnum.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Students", Convert.ToInt32(numericAge.Value).ToString().Trim()); sqlCmd.Parameters.AddWithValue("@Login", textBoxLog.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Password", textBoxPass.Text.Trim()); sqlCmd.ExecuteNonQuery(); // вывод checkcount = 1; LoginTeacher.getText = textName.Text.Trim() + " " + textSurname.Text.Trim(); this.Hide(); var form2 = new TeacherDiarycs(); form2.Closed += (s, args) => this.Close(); form2.Show(); LoginTeacher.autoLog = true; } } if (!checkTeacher.Checked) { if (comboEducation.Text != "" && comboGender.Text != "" && ListSubjects.SelectedItems.Count != 0 && isIntSurname == false && !surnamee.Contains(" ") && isLetterNumber == false && !num.Contains(" ") && numericAge.Value != 0 && textBoxPass.TextLength > 4 && textBoxLog.TextLength > 4 && mail.Contains("@") && !mail.StartsWith("@")) { if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlCommand sqlCmd = new SqlCommand("AddTeacherWithoutClass", 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()); sqlCmd.Parameters.AddWithValue("@TaughtSubjects", ListSubjects.SelectedItems.ToString().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(); // вывод checkcount = 1; LoginTeacher.getText = textName.Text.Trim() + " " + textSurname.Text.Trim(); this.Hide(); var form2 = new TeacherDiarycs(); 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(); * }*/ }