public bool DeleteStudent(int studentId, string courseNumber) { var entities = new KnowledgeBridgeEntities1(); var list = from student in entities.gradeInfoes where student.studentId == studentId && student.courseNumber == courseNumber select student; if (list.Count() > 0) { entities.gradeInfoes.Remove(list.SingleOrDefault()); entities.SaveChanges(); return(true); } return(false); }
public bool UpdateStudent(int studentId, string courseNumber, string email, int grade) { var entities = new KnowledgeBridgeEntities1(); var list = from student in entities.gradeInfoes where student.studentId == studentId && student.courseNumber == courseNumber select student; var course = list.SingleOrDefault(); if (course != null) { course.email = email; course.grade = grade; entities.SaveChanges(); return(true); } return(false); }
public void SaveStudent(int studentId, string courseNumber, string courseTitle, float hp, string coursePeriod, string studentName, string email, int grade) { var entities = new KnowledgeBridgeEntities1(); gradeInfo entity = new gradeInfo(); entity.studentId = studentId; entity.courseNumber = courseNumber; entity.courseTitle = courseTitle; entity.hp = hp; entity.coursePeriod = coursePeriod; entity.studentName = studentName; entity.email = email; entity.grade = grade; entities.gradeInfoes.Add(entity); entities.SaveChanges(); }