public static int AddStudentRecode(Recode recode)
{
string sql = @"INSERT INTO Recode (date,uid) VALUES (?date,?uid)";
MySqlParameter[] parameters = new MySqlParameter[]
{
new MySqlParameter("?date", recode.date),
new MySqlParameter("?uid", recode.uid)
};
MysqlHelper dbHelper = new MysqlHelper();
return(dbHelper.getMySqlCom(sql, parameters));
}
public static int AddStudentEntity(Student student)
{
string sql = @"INSERT INTO Student VALUES (?ID,?Name,?Class,?Image,?face_token)";
MySqlParameter[] parameters = new MySqlParameter[]
{
new MySqlParameter("?ID", student.ID),
new MySqlParameter("?Name", student.Name),
new MySqlParameter("?Class", student.Class),
new MySqlParameter("?Image", student.Image),
new MySqlParameter("?face_token", student.face_token)
};
MysqlHelper dbHelper = new MysqlHelper();
return(dbHelper.getMySqlCom(sql, parameters));
}
