public Section CreateSection(Section section) { Section s = new Section { SectionCode = section.SectionCode, SectionName = section.SectionName }; db.Sections.Add(s); db.SaveChanges(); return(db.Sections.Find(s.SectionId)); }
public Student CreateStudent(Student student) { var sect = db.Sections.Find(student.SectionId); db.Entry(student).State = EntityState.Added; student.SectionCode = sect.SectionCode; student.SectionName = sect.SectionName; db.Students.Add(student); db.SaveChanges(); var studentId = db.Entry(student).Entity.StudentId; return(student); }
private void CreateEditions() { var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName); if (defaultEdition == null) { defaultEdition = new Edition { Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName }; _context.Editions.Add(defaultEdition); _context.SaveChanges(); /* Add desired features to the standard edition, if wanted... */ } }
public bool SaveRegistration(UserRegistration registraionModel) { _dbContext.Add(registraionModel); var result = _dbContext.SaveChanges(); return(true); }
public bool SaveTraining(Training training) { training.DateOfCreated = DateTime.Now.ToShortDateString(); training.LastUpdated = DateTime.Now.ToShortDateString(); _dbContext.Add(training); _dbContext.SaveChanges(); return(true); }
public bool SaveTopic(Topics topics) { topics.CreatedUser = "******"; topics.UpdatedUser = "******"; topics.DateOfCreated = DateTime.Now.ToShortDateString(); topics.LastUpdated = DateTime.Now.ToShortDateString(); _dbContext.Add(topics); _dbContext.SaveChanges(); return(true); }
private void AddSettingIfNotExists(string name, string value, int?tenantId = null) { if (_context.Settings.IgnoreQueryFilters().Any(s => s.Name == name && s.TenantId == tenantId && s.UserId == null)) { return; } _context.Settings.Add(new Setting(tenantId, null, name, value)); _context.SaveChanges(); }
public ActionResult <ResponseData <User> > EditUser(User user) { try { //Get theo id var existUser = _context.Users.Find(user.ID); if (existUser == null) { return(new ResponseData <User> { Message = "Không tìm thấy user thích hợp!" }); } else { //Check trường email đã tồn tại if (_context.Users.Any(c => c.ID != user.ID && string.Compare(c.Email, user.Email) == 0)) { return(new ResponseData <User> { Message = "Địa chỉ email đã tồn tại!" }); } existUser.Name = user.Name; existUser.UnsignedName = WordsUtil.ChuyenTiengVietKhongDau(user.Name); existUser.Email = user.Email; existUser.Tel = user.Tel; //Cập nhật vào db _context.SaveChanges(); return(new ResponseData <User> { Message = "Cập nhật thông tin thành công!" }); } } catch (Exception ex) { return(new ResponseData <User> { Message = ex.Message }); } }
private void AddLanguageIfNotExists(ApplicationLanguage language) { if (_context.Languages.IgnoreQueryFilters().Any(l => l.TenantId == language.TenantId && l.Name == language.Name)) { return; } _context.Languages.Add(language); _context.SaveChanges(); }
public IActionResult Entry(Trainee model) { if (ModelState.IsValid) { TrainingDbContext db = new TrainingDbContext(); db.Trainees.Add(model); db.SaveChanges(); } return(View()); }
public IActionResult Add(AddTopicViewModel addTopicViewModel) { if (ModelState.IsValid) { //CheeseCategory newCheeseCategory = //context.Categories.Single(c => c.ID == addCheeseViewModel.CategoryID); // Add the new cheese to my existing cheeses Topic newTopic = new Topic { Name = addTopicViewModel.Name, Description = addTopicViewModel.Description, //Category = newCheeseCategory //was 'addCheeseViewModel.CategoryID' }; context.Topics.Add(newTopic); context.SaveChanges(); return(Redirect("/Topic")); } return(View(addTopicViewModel)); }
public Course AddCourse(CourseChangeViewModel course) { List <StudentCourse> studentCourses = new List <StudentCourse>(); Guid courseId = Guid.NewGuid(); foreach (var studentId in course.Students) { var student = db.Students.Find(studentId); if (student != null) { StudentCourse studentCourse = new StudentCourse() { StudentId = studentId, //CourseName=course.CourseName, CourseId = courseId, StudentName = student.StudentName, SectionName = student.SectionName, SectionCode = student.SectionCode //TrainHours=course.TrainHours }; studentCourses.Add(studentCourse); } } var record = new Course() { CourseId = courseId, CourseName = course.CourseName, CourseStartDate = course.CourseStartDate, CourseEndDate = course.CourseEndDate, TrainHours = course.TrainHours, CreateDate = DateTime.Now, StudentCourses = studentCourses }; db.Courses.Add(record); db.SaveChanges(); return(db.Courses.Find(record.CourseId)); }
public void Create() { new DefaultEditionCreator(_context).Create(); new DefaultLanguagesCreator(_context).Create(); new HostRoleAndUserCreator(_context).Create(); new DefaultSettingsCreator(_context).Create(); new DefaultCategoryCreator(_context).Create(); new DefaultAuthorCreator(_context).Create(); new DefaultPublisherCreator(_context).Create(); _context.SaveChanges(); }
private void CreateDefaultTenant() { // Default tenant var defaultTenant = _context.Tenants.IgnoreQueryFilters().FirstOrDefault(t => t.TenancyName == AbpTenantBase.DefaultTenantName); if (defaultTenant == null) { defaultTenant = new Tenant(AbpTenantBase.DefaultTenantName, AbpTenantBase.DefaultTenantName); var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName); if (defaultEdition != null) { defaultTenant.EditionId = defaultEdition.Id; } _context.Tenants.Add(defaultTenant); _context.SaveChanges(); } }
private void CreatePublisher() { IList <Publisher> defaultPublishers = new List <Publisher>(); defaultPublishers.Add(new Publisher() { Name = "Nhà xuất bản Kim Đồng", Email = "*****@*****.**", Phone = "0123456789", Address = "55 Quang Trung, Hai Bà Trưng, Hà Nội" }); defaultPublishers.Add(new Publisher() { Name = "Nhà xuất bản giáo dục", Email = "*****@*****.**", Phone = "0123456789", Address = "81 Trần Hưng Đạo, Hà Nội" }); defaultPublishers.Add(new Publisher() { Name = "Nhà xuất bản lao động", Email = "*****@*****.**", Phone = "0123456789", Address = "175 Giảng Võ, Đống Đa, Hà Nội" }); defaultPublishers.Add(new Publisher() { Name = "Nhà xuất bản Đại học Quốc Gia Hà Nội", Email = "*****@*****.**", Phone = "0123456789", Address = "16 Hàng Chuối, Phạm Đình Hổ, Hai Bà Trưng, Hà Nội" }); defaultPublishers.Add(new Publisher() { Name = "Nhà xuất bản giao thông vận tải", Email = "*****@*****.**", Phone = "0123456789", Address = " 80B Trần Hưng Đạo, Hoàn Kiếm, Hà Nội" }); foreach (var defaultPublisher in defaultPublishers) { var publisher = _context.Publishers .Where(s => s.Name == defaultPublisher.Name) .FirstOrDefault <Publisher>(); if (publisher == null) { _context.Publishers.AddRange(defaultPublisher); _context.SaveChanges(); } } }
private void CreateAuthor() { IList <Author> defaultAuthors = new List <Author>(); defaultAuthors.Add(new Author() { Name = "Nguyễn Nhật Ánh", Phone = "0123456789", Address = "VN", YearOfBirth = 1955 }); defaultAuthors.Add(new Author() { Name = "Trang Hạ", Phone = "0123456789", Address = "VN", YearOfBirth = 1975 }); defaultAuthors.Add(new Author() { Name = "Nguyễn Phong Việt", Phone = "0123456789", Address = "VN", YearOfBirth = 1980 }); defaultAuthors.Add(new Author() { Name = "Anh Khang", Phone = "0123456789", Address = "VN", YearOfBirth = 1987 }); defaultAuthors.Add(new Author() { Name = "Hamlet Trương", Phone = "0123456789", Address = "VN", YearOfBirth = 1988 }); foreach (var defaultAuthor in defaultAuthors) { var author = _context.Authors .Where(s => s.Name == defaultAuthor.Name) .FirstOrDefault <Author>(); if (author == null) { _context.Authors.AddRange(defaultAuthor); _context.SaveChanges(); } } }
private void CreateCategory() { IList <Category> defaultCategories = new List <Category>(); defaultCategories.Add(new Category() { Name = "Sách giáo khoa" }); defaultCategories.Add(new Category() { Name = "Tiểu thuyết" }); defaultCategories.Add(new Category() { Name = "Truyện tranh" }); defaultCategories.Add(new Category() { Name = "Sách bài tập" }); defaultCategories.Add(new Category() { Name = "Từ điển" }); foreach (var defaultCategory in defaultCategories) { var category = _context.Categories .Where(s => s.Name == defaultCategory.Name) .FirstOrDefault <Category>(); if (category == null) { _context.Categories.AddRange(defaultCategory); _context.SaveChanges(); } } }
private void CreateHostRoleAndUsers() { // Admin role for host var adminRoleForHost = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin); if (adminRoleForHost == null) { adminRoleForHost = _context.Roles.Add(new Role(null, StaticRoleNames.Host.Admin, StaticRoleNames.Host.Admin) { IsStatic = true, IsDefault = true }).Entity; _context.SaveChanges(); } // Grant all permissions to admin role for host var grantedPermissions = _context.Permissions.IgnoreQueryFilters() .OfType <RolePermissionSetting>() .Where(p => p.TenantId == null && p.RoleId == adminRoleForHost.Id) .Select(p => p.Name) .ToList(); var permissions = PermissionFinder .GetAllPermissions(new TrainingAuthorizationProvider()) .Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host) && !grantedPermissions.Contains(p.Name)) .ToList(); if (permissions.Any()) { _context.Permissions.AddRange( permissions.Select(permission => new RolePermissionSetting { TenantId = null, Name = permission.Name, IsGranted = true, RoleId = adminRoleForHost.Id }) ); _context.SaveChanges(); } // Admin user for host var adminUserForHost = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == null && u.UserName == AbpUserBase.AdminUserName); if (adminUserForHost == null) { var user = new User { TenantId = null, UserName = AbpUserBase.AdminUserName, Name = "admin", Surname = "admin", EmailAddress = "*****@*****.**", IsEmailConfirmed = true, IsActive = true }; user.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(user, "123qwe"); user.SetNormalizedNames(); adminUserForHost = _context.Users.Add(user).Entity; _context.SaveChanges(); // Assign Admin role to admin user _context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id)); _context.SaveChanges(); _context.SaveChanges(); } }
private void CreateRolesAndUsers() { // Admin role var adminRole = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.Admin); if (adminRole == null) { adminRole = _context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.Admin, StaticRoleNames.Tenants.Admin) { IsStatic = true }).Entity; _context.SaveChanges(); } // Grant all permissions to admin role var grantedPermissions = _context.Permissions.IgnoreQueryFilters() .OfType <RolePermissionSetting>() .Where(p => p.TenantId == _tenantId && p.RoleId == adminRole.Id) .Select(p => p.Name) .ToList(); var permissions = PermissionFinder .GetAllPermissions(new TrainingAuthorizationProvider()) .Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant) && !grantedPermissions.Contains(p.Name)) .ToList(); if (permissions.Any()) { _context.Permissions.AddRange( permissions.Select(permission => new RolePermissionSetting { TenantId = _tenantId, Name = permission.Name, IsGranted = true, RoleId = adminRole.Id }) ); _context.SaveChanges(); } // Admin user var adminUser = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == AbpUserBase.AdminUserName); if (adminUser == null) { adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**"); adminUser.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(adminUser, "123qwe"); adminUser.IsEmailConfirmed = true; adminUser.IsActive = true; _context.Users.Add(adminUser); _context.SaveChanges(); // Assign Admin role to admin user _context.UserRoles.Add(new UserRole(_tenantId, adminUser.Id, adminRole.Id)); _context.SaveChanges(); } }
public IEnumerable <Course> ImportCourse([FromBody] IEnumerable <CoursesImportViewModel> courses) { List <Course> dataToPersist = new List <Course>(); foreach (var item in courses) { var student = db.Students.AsNoTracking().First(s => s.StudentName.Equals(item.StudentName)); Course course = dataToPersist.SingleOrDefault(c => c.CourseName.Equals(item.CourseName)); if (course == null) { course = new Course { CourseId = Guid.NewGuid(), CourseName = item.CourseName, CourseStartDate = item.CourseStartDate, CourseEndDate = item.CourseEndDate, CreateDate = new DateTime(2015, 12, 31), LastModifiedBy = "批次匯入", LastModifiedDate = DateTime.Now.ToString("YYYY/MM/DD"), TrainHours = item.TrainHours, StudentCourses = new List <StudentCourse>() }; course.StudentCourses.Add(new StudentCourse { CourseId = course.CourseId, StudentId = student.StudentId, Score = item.Score, SectionCode = student.SectionCode, SectionName = student.SectionName, StudentName = student.StudentName, LastModifiedBy = "批次匯入", LastModifiedDate = DateTime.Now.ToString("YYYY/MM/DD") }); dataToPersist.Add(course); } else { if (course.StudentCourses == null) { course.StudentCourses = new List <StudentCourse> { new StudentCourse { CourseId = course.CourseId, StudentId = student.StudentId, StudentName = student.StudentName, Score = item.Score, SectionCode = student.SectionCode, SectionName = student.SectionName, LastModifiedBy = "批次匯入", LastModifiedDate = DateTime.Now.ToString("YYYY/MM/DD") } }; } else { course.StudentCourses.Add(new StudentCourse { CourseId = course.CourseId, StudentId = student.StudentId, Score = item.Score, SectionCode = student.SectionCode, SectionName = student.SectionName, StudentName = student.StudentName, LastModifiedBy = "批次匯入", LastModifiedDate = DateTime.Now.ToString("YYYY/MM/DD") }); } } } db.Courses.AddRange(dataToPersist); db.SaveChanges(); return(db.Courses.OrderByDescending(d => d.CourseEndDate).ToList()); }