예제 #1
0
 public bool Add(Student newStudent)
 {
     string gradeString = newStudent.grade.ToString().Replace(',', '.');
     string sql = "INSERT INTO " + TBL_STUDENTS
         + " (" + STUD_NAME + ", " + STUD_GRADE + ", " + STUD_HEIGHT + ", " + CLASS_ID + ") "
         + "VALUES('" + newStudent.name + "', " + ConvertGrade(newStudent.grade) + ", " + newStudent.height + ", " + newStudent.class_id.id + ");";
     return _db.ExecuteInsertUpdateDelete(sql);
 }
예제 #2
0
 public bool Edit(Student editStudent)
 {
     string sql = "UPDATE " + TBL_STUDENTS + " SET "
         + STUD_NAME + "='" + editStudent.name + "', "
         + STUD_HEIGHT + "=" + editStudent.height + ", "
         + STUD_GRADE + "=" + ConvertGrade(editStudent.grade) + ", "
         + CLASS_ID + "=" + editStudent.class_id.id
         + " WHERE " + STUD_ID + "=" + editStudent.id + ";";
     return _db.ExecuteInsertUpdateDelete(sql);
 }
예제 #3
0
 public bool Delete(Student editStudent)
 {
     string sql = "DELETE FROM " + TBL_STUDENTS
         + " WHERE " + STUD_ID + "=" + editStudent.id + ";";
     return _db.ExecuteInsertUpdateDelete(sql);
 }