public UserModel CreateUser(UserQueryModel userQuery) { var status = new GeneralStatus { StatusName = userQuery.Status, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; db.GeneralStatuses.Add(status); UserModel result = new UserModel(); var user = new User { UserName = userQuery.UserName, Email = userQuery.Email, StatusId = status.StatusId }; db.Users.Add(user); db.SaveChanges(); result = new UserModel { Id = user.UserId, UserName = user.UserName, Email = user.Email, Status = user.Status }; return result; }
public FacultyModel AddFaculty(FacultyModel faculty) { var result = new FacultyModel(); var status = new GeneralStatus { StatusName = faculty.Status, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; DbContext.GeneralStatuses.Add(status); var newFaculty = new Faculty { FacultyName = faculty.FacultyName, Note = faculty.Note, GeneralStatusId = status.StatusId, DirectorId = faculty.DirectorId, ProViceId = faculty.ProViceId }; DbContext.Faculties.Add(newFaculty); DbContext.SaveChanges(); result.FacultyId = newFaculty.FacultyId; return result; }
public ApiSimpleResult<UserRole> CreateUserRole(UserRoleModel userRole) { var result = new ApiSimpleResult<UserRole>() { StatusString = "Fail", Message = "Cannot create user role." }; if (userRole != null) { var status = new GeneralStatus { StatusName = userRole.Status, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; db.GeneralStatuses.Add(status); var newUserRole = new UserRole { RoleId = userRole.RoleId, UserId = userRole.UserId, Note = userRole.Note, StatusId = status.StatusId }; db.UserRoles.Add(newUserRole); db.SaveChanges(); result.StatusString = "Succesful"; result.Message = "Create new UserRole successfully"; result.Data = newUserRole; } return result; }
public RoleModel CreateRole(RoleModelQuery roleModelQuery) { RoleModel result = new RoleModel(); var status = new GeneralStatus { StatusName = roleModelQuery.Status, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; db.GeneralStatuses.Add(status); var role = new Role { RoleName = roleModelQuery.RoleName, StatusId = status.StatusId, Note = roleModelQuery.Note }; db.Roles.Add(role); db.SaveChanges(); result = new RoleModel { RoleId = role.RoleId, RoleName = role.RoleName, }; 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; }
public StudentModel AddStudent(StudentModel queryModel) { var result = new StudentModel(); var status = new GeneralStatus { StatusName = queryModel.Status, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; DbContext.GeneralStatuses.Add(status); var newItem = new Student { StudentCode = queryModel.StudentCode, FullName = queryModel.FullName, Address = queryModel.Address, PhoneNumber = queryModel.PhoneNumber, DateOfBirth = queryModel.DateOfBirth, Email = queryModel.Email, GeneralStatusId = status.StatusId }; DbContext.Students.Add(newItem); DbContext.SaveChanges(); result.StudentId = newItem.StudentId; return result; }
public FacultyCourseModel AddFacultyCourse(FacultyCourseModel facultyCourse) { var result = new FacultyCourseModel(); var status = new GeneralStatus { StatusName = facultyCourse.Status, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; DbContext.GeneralStatuses.Add(status); var newItem = new FacultyCourse { FacultyId = facultyCourse.FacultyId, CourseId = facultyCourse.CourseId, Note = facultyCourse.Note, GeneralStatusId = status.StatusId }; DbContext.FacultyCourses.Add(newItem); DbContext.SaveChanges(); result.FacultyCourseId = newItem.FacultyCourseId; return result; }