/// <summary> /// Used when adding or updating a record. /// </summary> internal static void AddOrEdit(CourseEnrollment model, CrudOperation operation, bool isForListInline = false) { CourseEnrollment objCourseEnrollment; CourseEnrollment objCourseEnrollmentOld = new CourseEnrollment(); decimal id = 0; if (operation == CrudOperation.Add) { objCourseEnrollment = new CourseEnrollment(); } else { objCourseEnrollment = CourseEnrollment.SelectByPrimaryKey(model.EnrollmentId); objCourseEnrollmentOld = objCourseEnrollment.ShallowCopy(); } objCourseEnrollment.EnrollmentId = model.EnrollmentId; objCourseEnrollment.CourseName = model.CourseName; objCourseEnrollment.StudentName = model.StudentName; objCourseEnrollment.Comments = model.Comments; if (operation == CrudOperation.Add) { id = objCourseEnrollment.Insert(); } else { objCourseEnrollment.Update(); } }
/// <summary> /// Handler, deletes a record. /// </summary> public IActionResult OnGetRemove(int id) { CourseEnrollment CourseEnrollment = CourseEnrollment.SelectByPrimaryKey(id); CourseEnrollment.Delete(id); return(new JsonResult(true)); }
public void LoadPage(int id, string returnUrl) { // select a record by primary key(s) CourseEnquiry1API.BusinessObject.CourseEnrollment objCourseEnrollment = CourseEnrollment.SelectByPrimaryKey(id); // assign values to this page's bound property CourseEnrollment = objCourseEnrollment; // assign the return url ReturnUrl = returnUrl; }
public PageResult LoadPage(int id, string returnUrl) { // select a record by primary key(s) CourseEnquiry1API.BusinessObject.CourseEnrollment objCourseEnrollment = CourseEnrollment.SelectByPrimaryKey(id); // create the model used by the partial page AddEditCourseEnrollmentPartialModel model = new AddEditCourseEnrollmentPartialModel(); model.CourseDropDownListData = Course.SelectCourseDropDownListData(); model.StudentDropDownListData = Student.SelectStudentDropDownListData(); model.Operation = CrudOperation.Update; model.ReturnUrl = returnUrl; model.CourseEnrollment = objCourseEnrollment; // assign values to the model used by this page PartialModel = model; // assign the return url ReturnUrl = returnUrl; return(Page()); }
/// <summary> /// Shows how to Select a record by Primary Key. It also shows how to retrieve Lazily-loaded related Objects. Related Objects are assigned for each Foreign Key. /// </summary> private void SelectByPrimaryKey() { int enrollmentIdSample = 12; // select a record by primary key(s) CourseEnrollment objCourseEnrollment = CourseEnrollment.SelectByPrimaryKey(enrollmentIdSample); if (objCourseEnrollment != null) { // if record is found, a record is returned int enrollmentId = objCourseEnrollment.EnrollmentId; int courseName = objCourseEnrollment.CourseName; int studentName = objCourseEnrollment.StudentName; string comments = objCourseEnrollment.Comments; // get the Course related to CourseName. Course objCourseRelatedToCourseName = objCourseEnrollment.CourseNameNavigation; // get the Student related to StudentName. Student objStudentRelatedToStudentName = objCourseEnrollment.StudentNameNavigation; } }