public ApiSimpleResult<StudentCourseModel> DeleteStudentCourse(StudentCourseModel queryModel) { var result = new ApiSimpleResult<StudentCourseModel>(); var response = FacultySvc.DeleteStudentCourse(queryModel); if (response != null) result = response; return result; }
public ApiSimpleResult<StudentCourseModel> DeleteStudentCourse(StudentCourseModel queryModel) { var status = DbContext.GeneralStatuses.Find(queryModel.GeneralStatus.StatusId); DbContext.Entry(status).State = EntityState.Deleted; var deleteItem = DbContext.StudentCourses.Find(queryModel.StudentCourseId); DbContext.Entry(deleteItem).State = EntityState.Deleted; var result = new ApiSimpleResult<StudentCourseModel>(); try { DbContext.SaveChanges(); result.StatusString = "Successful"; result.Message = "Delete data successfully"; result.Data = queryModel; } catch (DbUpdateConcurrencyException ex) { result.Message = "Error"; result.StatusString = "Error"; } return result; }
public StudentCourseModel GetStudentCourseDetails(int id) { var response = new StudentCourseModel(); var detailItem = DbContext.StudentCourses.Find(id); if (detailItem != null) { response.StudentCourseId = detailItem.StudentCourseId; response.CourseCode = detailItem.Course.CourseCode; response.FullName = detailItem.Student.FullName; response.StudentCode = detailItem.Student.StudentCode; response.Mark = detailItem.Mark; response.Comment = detailItem.Comment; response.GradeGroupId = detailItem.GradeGroup.Id; response.GradeGroupName = detailItem.GradeGroup.Name; response.GeneralStatus = detailItem.GeneralStatus; response.Status = detailItem.GeneralStatus.StatusName; } return response; }
public StudentCourseModel SaveStudentCourse(StudentCourseModel queryModel) { var result = new StudentCourseModel(); var status = DbContext.GeneralStatuses.Find(queryModel.GeneralStatus.StatusId); status.UpdateTime = DateTime.Now; status.StatusName = queryModel.Status; DbContext.Entry(status).State = EntityState.Modified; var editItem = DbContext.StudentCourses.Find(queryModel.StudentCourseId); if (editItem != null) { editItem.StudentId = queryModel.StudentId; editItem.CourseId = queryModel.CourseId; editItem.Mark = queryModel.Mark; editItem.Comment = queryModel.Comment; editItem.GradeGroupId = queryModel.GradeGroupId; DbContext.Entry(editItem).State = EntityState.Modified; } try { DbContext.SaveChanges(); result.StudentCourseId = queryModel.StudentCourseId; } catch (DbUpdateConcurrencyException ex) { return null; } return result; }
public StudentCourseModel AddStudentCourse(StudentCourseModel queryModel) { var result = new StudentCourseModel(); var status = new GeneralStatus { StatusName = queryModel.Status, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; DbContext.GeneralStatuses.Add(status); var newItem = new StudentCourse { StudentId = queryModel.StudentId, CourseId = queryModel.CourseId, Mark = queryModel.Mark, Comment = queryModel.Comment, GradeGroupId = queryModel.GradeGroupId, GeneralStatusId = status.StatusId }; DbContext.StudentCourses.Add(newItem); DbContext.SaveChanges(); result.StudentCourseId = newItem.StudentCourseId; return result; }