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());
}
