public bool addStudent(string name, string lastName, DateTime birthday, string phone, string gender, string address, MemoryStream picture)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `students`(`first_name`, `last_name`, `birthday`, `gender`, `phone`, `address`, `picture`) VALUES (@n,@ln,@bdt,@gdr,@phn,@adrs,@pic)", db.getConnection);
//@n,@ln,@bdt,@gdr,@phn,@adrs,@pic
command.Parameters.Add("@n", MySqlDbType.VarChar).Value = name;
command.Parameters.Add("@ln", MySqlDbType.VarChar).Value = lastName;
command.Parameters.Add("@bdt", MySqlDbType.Date).Value = birthday;
command.Parameters.Add("@gdr", MySqlDbType.VarChar).Value = phone;
command.Parameters.Add("@phn", MySqlDbType.VarChar).Value = gender;
command.Parameters.Add("@adrs", MySqlDbType.Text).Value = address;
command.Parameters.Add("@pic", MySqlDbType.LongBlob).Value = picture.ToArray();
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
db.closeConnection();
return(true);
}
else
{
db.closeConnection();
return(false);
}
}
public bool addCourse(string courseName, int hourNumber, string description)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `studies`(`label`, `hours`, `description`) VALUES (@name,@hoursnumber,@description)", db.getConnection);
command.Parameters.Add("@name", MySqlDbType.VarChar).Value = courseName;
command.Parameters.Add("@hoursnumber", MySqlDbType.Int32).Value = hourNumber;
command.Parameters.Add("@description", MySqlDbType.Text).Value = description;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
db.closeConnection();
return(true);
}
else
{
db.closeConnection();
return(false);
}
}
