public override void addStudent(Student student)
{
MySqlCommand dbcmd = getDbCommand();
dbcmd.CommandText = "INSERT INTO students (name, family, mdlname, studgroup, login, password, ipaddress, choosed) VALUES ( '" +
student.Name1 + "', '" + student.Family1 + "', '" + student.MdlName1 + "', '" +
student.StudGroup1 + "', '" + student.Login1 + "', '" + MenuUIManager.PasswEncryption(student.Password1) +
"', '" + student.Ipaddress1 + "', '" + student.Choosed1 + "' )";
dbcmd.ExecuteNonQuery();
}
public override int addTeacher(Teacher teacher)
{
MySqlCommand dbcmd = getDbCommand();
dbcmd.CommandText = "INSERT INTO teachers (name, family, mdlname, position, login, password, ipaddress, regtime, choosed) VALUES ( '" +
teacher.Name1 + "', '" + teacher.Family1 + "', '" + teacher.MdlName1 + "', '" +
teacher.Position1 + "', '" + teacher.Login1 + "', '" + MenuUIManager.PasswEncryption(teacher.Password1) +
"', '" + teacher.Ipaddress1 + "', '" + teacher.Regtime1.ToString("yyyy-MM-dd H:mm:ss") + "', '" + teacher.Choosed1 + "' )";
dbcmd.ExecuteNonQuery();
return((int)dbcmd.LastInsertedId);
}
void EnterButton()
{
var teachersDB = new TeachersDB();
var currPassword = MenuUIManager.PasswEncryption(passw.text);
var reader = teachersDB.findTeacher(login.text);
if (reader.HasRows)
{
reader.Read();
if (reader[1].ToString() == currPassword)
{
MenuUIManager.currTeacherId = Convert.ToInt32(reader[0]);
MenuUIManager.Instance.OpenTaskPanel();
}
else
{
Debug.Log("Введенные логин и пароль не соответствуют друг другу");
}
}
else
{
Debug.Log("Введенный логин не найден в БД");
}
}