//функция добавления public bool insertTeacher(string surname, string name, string patronymic, string gender, DateTime birthDate, string address, string mail, string mobile, string login, string password, MemoryStream teacherPic) { MySqlCommand command = new MySqlCommand("INSERT INTO `iteacher`(`surName`, `name`, `patronymic`, `gender`, `birthDate`, `address`, `mail`, `mobile`, `login`, `pass`, `teacherPic`) " + "VALUES (@sname,@name,@pname,@gender,@bdate,@address,@mail,@mobile,@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("@mail", MySqlDbType.VarChar).Value = mail; command.Parameters.Add("@mobile", MySqlDbType.Int64).Value = mobile; 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); } }
//INSERT INTO `class_has_iteacher_has_subject_has_schedule` (`id`, `iTeacher_has_subject_fk`, `iclass_fk`, `ischedule_fk`) VALUES (NULL, '28', '1-А', '2'); public bool insertFULL(int tSubject, string cName, int Schedule) { MySqlCommand command = new MySqlCommand("INSERT INTO `class_has_iteacher_has_subject_has_schedule`(`iTeacher_has_subject_fk`, `iclass_fk`, `ischedule_fk`) VALUES (@Tsubject,@cName,@schedule)", connection.getConnection); command.Parameters.Add("@Tsubject", MySqlDbType.Int32).Value = tSubject; command.Parameters.Add("@cName", MySqlDbType.VarChar).Value = cName; command.Parameters.Add("@schedule", MySqlDbType.Int32).Value = Schedule; 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); } }
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); } }