public bool insertStudent(string fname, string lname, DateTime bdate, string phone, string gender, string address, MemoryStream picture)
{
SqlCommand command = new SqlCommand("INSERT INTO student (first_name, last_name, birthdate, gender, phone, address, picture) " +
"VALUES (@fn, @ln, @bdt, @gdr, @phn, @adrs, @pic)", db.getConnection);
command.Parameters.Add("@fn", SqlDbType.VarChar).Value = fname;
command.Parameters.Add("@ln", SqlDbType.VarChar).Value = lname;
command.Parameters.Add("@bdt", SqlDbType.Date).Value = bdate;
command.Parameters.Add("@gdr", SqlDbType.VarChar).Value = gender;
command.Parameters.Add("@phn", SqlDbType.VarChar).Value = phone;
command.Parameters.Add("@adrs", SqlDbType.VarChar).Value = address;
command.Parameters.Add("@pic", SqlDbType.VarBinary).Value = picture.ToArray();
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
db.closeConnection();
return(true);
}
else
{
db.openConnection();
return(false);
}
}
//Creating a function to insert course.
public bool insertCourse(string courseName, int hoursNumber, string description)
{
SqlCommand command = new SqlCommand("INSERT INTO course(course_label, hours_number, description) VALUES(@name, @hrs, @desc)", mydb.getConnection);
command.Parameters.Add("@name", SqlDbType.VarChar).Value = courseName;
command.Parameters.Add("@hrs", SqlDbType.Int).Value = hoursNumber;
command.Parameters.Add("@desc", SqlDbType.VarChar).Value = description;
mydb.openConnection();
if (command.ExecuteNonQuery() == 1)
{
mydb.closeConnection();
return(true);
}
else
{
mydb.closeConnection();
return(false);
}
}
//Create a function to insert a new score.
public bool insertScore(int studentId, int courseId, int score, string description)
{
//Query = INSERT INTO score(studentId, courseId, score, description) VALUES(@SID, @CID, @scr, @desc)
SqlCommand command = new SqlCommand("INSERT INTO score(studentId, courseId, score, description) VALUES(@SID, @CID, @scr, @desc)", db.getConnection);
command.Parameters.Add("@SID", SqlDbType.Int).Value = studentId;
command.Parameters.Add("@CID", SqlDbType.Int).Value = courseId;
command.Parameters.Add("@scr", SqlDbType.Int).Value = score;
command.Parameters.Add("@desc", SqlDbType.VarChar).Value = description;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
db.closeConnection();
return(true);
}
else
{
db.closeConnection();
return(false);
}
}
