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