public bool insertStudent(string surname, string name, string patronymic, string gender, DateTime birthDate,
string address, string mobile, string className, string login, string password, MemoryStream teacherPic)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `istudent`(`surName`, `name`, `patronymic`, `gender`, `birthDate`, `address`, `mobile`, `className_fk`, `login`, `pass`, `studentPic`) " +
"VALUES (@sName,@Name,@pName,@gender,@bdate,@address,@mobile,@cName,@login,@pass,@pic)", connection.getConnection);
command.Parameters.Add("@sName", MySqlDbType.VarChar).Value = surname;
command.Parameters.Add("@Name", MySqlDbType.VarChar).Value = name;
command.Parameters.Add("@pName", MySqlDbType.VarChar).Value = patronymic;
command.Parameters.Add("@gender", MySqlDbType.VarChar).Value = gender;
command.Parameters.Add("@bdate", MySqlDbType.Date).Value = birthDate;
command.Parameters.Add("@address", MySqlDbType.Text).Value = address;
command.Parameters.Add("@mobile", MySqlDbType.VarChar).Value = mobile;
command.Parameters.Add("@cName", MySqlDbType.VarChar).Value = className;
command.Parameters.Add("@login", MySqlDbType.VarChar).Value = login;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = password;
command.Parameters.Add("@pic", MySqlDbType.Blob).Value = teacherPic.ToArray();
connection.openConnection();
if (command.ExecuteNonQuery() == 1)
{
connection.closeConnection();
return(true);
}
else
{
connection.closeConnection();
return(false);
}
}
public DataTable getAllFullMix()
{
MySqlCommand command = new MySqlCommand("SELECT * FROM `class_has_iteacher_has_subject_has_schedule`", connection.getConnection);
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
connection.openConnection();
return(table);
}
public bool insertTeacherSubject(string fkT, string fkS)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `iteacher_has_subject`(`iTeacher_fk`, `subject_fk`) VALUES (@fkT,@fkS)", connection.getConnection);
command.Parameters.Add("@fkT", MySqlDbType.VarChar).Value = fkT;
command.Parameters.Add("@fkS", MySqlDbType.VarChar).Value = fkS;
connection.openConnection();
if (command.ExecuteNonQuery() == 1)
{
connection.closeConnection();
return(true);
}
else
{
connection.closeConnection();
return(false);
}
}
//функция добавления
public bool insertClass(string className, int classRoom, int numberPupil)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `iclass`(`className`, `classRoom`, `numberStudents`) VALUES (@cName,@cRoom,@nPupil)", connection.getConnection);
command.Parameters.Add("@cName", MySqlDbType.VarChar).Value = className;
command.Parameters.Add("@cRoom", MySqlDbType.Int32).Value = classRoom;
command.Parameters.Add("@nPupil", MySqlDbType.Int32).Value = numberPupil;
connection.openConnection();
if (command.ExecuteNonQuery() == 1)
{
connection.closeConnection();
return(true);
}
else
{
connection.closeConnection();
return(false);
}
}
public bool insertSchedule(string day, string startTime, string finishTime)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `ischedule`(`day`, `startTime`, `finishTime`) VALUES (@day,@sTime,@fTime)", connection.getConnection);
command.Parameters.Add("@day", MySqlDbType.VarChar).Value = day;
command.Parameters.Add("@sTime", MySqlDbType.VarChar).Value = startTime;
command.Parameters.Add("@fTime", MySqlDbType.VarChar).Value = finishTime;
connection.openConnection();
if (command.ExecuteNonQuery() == 1)
{
connection.closeConnection();
return(true);
}
else
{
connection.closeConnection();
return(false);
}
}
//добавить дисциплину
public bool insertSubject(string subjectName, string description)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `isubject`(`subjectName`, `description`) VALUES (@sName,@description)", connection.getConnection);
command.Parameters.Add("@sName", MySqlDbType.VarChar).Value = subjectName;
command.Parameters.Add("@description", MySqlDbType.Text).Value = description;
connection.openConnection();
if (command.ExecuteNonQuery() == 1)
{
connection.closeConnection();
return(true);
}
else
{
connection.closeConnection();
return(false);
}
}