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 Student FindStudentByFace(string face_token)
{
string sql = @"select * from Student where face_token = ?token";
MySqlParameter[] parameters = new MySqlParameter[]
{
new MySqlParameter("?token", face_token),
};
MysqlHelper dbHelper = new MysqlHelper();
DataTable dt = dbHelper.getMySqlRead(sql, parameters);
Student student = DataTableToModel <Student> .ConvertToModel(dt)[0];
return(student);
}
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));
}
