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