private void InitializeDataSet(int count)
{
_schoolDS = new SchoolDataSet();
//build the books table
for (int i = 0; i < count; i++)
{
_schoolDS.Books.AddBooksRow(i, "Book Title #" + i.ToString(), "Author_" + i.ToString());
}
//build the courses table
for (int i = 0; i < count; i++)
{
SchoolDataSet.CoursesRow course = _schoolDS.Courses.NewCoursesRow();
course.Course_Id = i;
course.Name = "Course Name #" + i.ToString();
course.Description = "Description_" + i.ToString();
course.Details1 = "Details for Course #" + i.ToString();
course.Details2 = "This course consists of " + i.ToString() + " classes";
course.Details3 = "The passing grade is " + i.ToString();
course.Grade1 = 0;
course.Grade2 = 0;
course.Grade3 = 0;
course.Final = 0;
course.Book_Id = i;
course.Required = false;
_schoolDS.Courses.AddCoursesRow(course);
}
SaveDataSet();
}
public void UpdateCourseGrades(int Course_Id, int Grade1, int Grade2, int Grade3, int Final)
{
SchoolDataSet.CoursesRow course = _schoolDS.Courses.FindByCourse_Id(Course_Id);
course.Grade1 = Grade1;
course.Grade2 = Grade2;
course.Grade3 = Grade3;
course.Final = Final;
SaveDataSet();
}
public void UpdateCourseDetails(int Course_Id, string Name, string Description, bool Required, string Details1, string Details2, string Details3, int Book_Id)
{
SchoolDataSet.CoursesRow course = _schoolDS.Courses.FindByCourse_Id(Course_Id);
course.Name = Name;
course.Description = Description;
course.Required = Required;
course.Details1 = Details1;
course.Details2 = Details2;
course.Details3 = Details3;
course.Book_Id = Book_Id;
SaveDataSet();
}
public void InsertCourse(int Course_Id, string Name, string Description, bool Required, string Details1, string Details2, string Details3, int Book_Id)
{
SchoolDataSet.CoursesRow newCourse = _schoolDS.Courses.NewCoursesRow();
newCourse.Course_Id = Course_Id;
newCourse.Name = Name;
newCourse.Description = Description;
newCourse.Required = Required;
newCourse.Grade1 = 0;
newCourse.Grade2 = 0;
newCourse.Grade3 = 0;
newCourse.Final = 0;
newCourse.Details1 = Details1;
newCourse.Details2 = Details2;
newCourse.Details3 = Details3;
newCourse.Book_Id = Book_Id;
_schoolDS.Courses.AddCoursesRow(newCourse);
SaveDataSet();
}
public void SetRequiredCourse(int Course_Id, bool Required)
{
SchoolDataSet.CoursesRow course = _schoolDS.Courses.FindByCourse_Id(Course_Id);
course.Required = Required;
SaveDataSet();
}
public void AddExtraPoint(int Course_Id)
{
SchoolDataSet.CoursesRow course = _schoolDS.Courses.FindByCourse_Id(Course_Id);
course.Final += 1;
SaveDataSet();
}
public void RemoveExtraPoint(int Course_Id)
{
SchoolDataSet.CoursesRow course = _schoolDS.Courses.FindByCourse_Id(Course_Id);
course.Final -= 1000;
SaveDataSet();
}