//create function to add a new student
public bool insertStudent(string fname, string lname, DateTime bdate, string phone, string gender, string address, MemoryStream picture)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `student`( `first_name`, `last_name`, `birthdate`, `gender`, `phone`, `address`, `picture`) VALUES (@fn,@ln,@bdt,@gdr,@phn,@adrs,@pic)", db.getConnection);
//@fn,@ln,@bdt,@gdr,@phn,@adrs,@pic
command.Parameters.Add("@fn", MySqlDbType.VarChar).Value = fname;
command.Parameters.Add("@ln", MySqlDbType.VarChar).Value = lname;
command.Parameters.Add("@bdt", MySqlDbType.Date).Value = bdate;
command.Parameters.Add("@gdr", MySqlDbType.VarChar).Value = gender;
command.Parameters.Add("@phn", MySqlDbType.VarChar).Value = phone;
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);
}
}
//INSERT FUNCTION
public bool insertCourse(string courseName, int hoursNumber, string description)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `course`(`label`, `hours_number`, `description`) VALUES (@name,@hrs,@dscr)", db.getConnection);
command.Parameters.Add("@name", MySqlDbType.VarChar).Value = courseName;
command.Parameters.Add("@hrs", MySqlDbType.Int32).Value = hoursNumber;
command.Parameters.Add("@dscr", MySqlDbType.Text).Value = description;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
db.closeConnection();
return(true);
}
else
{
db.closeConnection();
return(false);
}
}