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); } }