public IActionResult Add(AddPersonViewModel addPersonViewModel) { Person newPerson = new Person { Name = addPersonViewModel.Name }; context.Persons.Add(newPerson); context.SaveChanges(); return(Redirect("/Person/ViewPerson/" + newPerson.ID)); }
public IActionResult Add(AddTimesheetDayViewModel addTimesheetDayViewModel) { TimesheetDay newTimesheetDay = new TimesheetDay { Name = addTimesheetDayViewModel.Name }; context.TimesheetDays.Add(newTimesheetDay); context.SaveChanges(); return(Redirect("/Timesheetday/Index")); }
public IActionResult Add(AddSkillViewModel addSkillViewModel) { Skill newSkill = new Skill { Name = addSkillViewModel.Name }; context.Skills.Add(newSkill); context.SaveChanges(); return(Redirect("/")); }
public void Remove(int id) { ProjectRoleType entityToDelete = context.ProjectRoleType.Find(id); List <Activity> activityToDelete = new List <Activity>(); var zmienna = context.Activity.Where(i => i.CurrentProjectRoleType.RoleId == entityToDelete.RoleId); foreach (var item in zmienna) { context.Activity.Remove(item); } context.ProjectRoleType.Remove(entityToDelete); context.SaveChanges(); }
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 IActionResult Add(AddTimesheetViewModel addTimesheetViewModel) { TimesheetDay newTimesheetDay = context.TimesheetDays.Single(c => c.ID == addTimesheetViewModel.DayOfTheWeekID); //context.TimesheetDays. Timesheet newTimesheet = new Timesheet { Name = addTimesheetViewModel.Name, DayOfTheWeek = newTimesheetDay }; context.Timesheets.Add(newTimesheet); context.SaveChanges(); return(Redirect("/Timesheet")); }
public void Create() { new DefaultEditionCreator(_context).Create(); new DefaultLanguagesCreator(_context).Create(); new HostRoleAndUserCreator(_context).Create(); new DefaultSettingsCreator(_context).Create(); _context.SaveChanges(); }
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(); }
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 ProjectType Update(ProjectType projectType) { ProjectType projectTypeToEdit = context.ProjectType.Find(projectType.ProjectTypeId); projectTypeToEdit.Name = projectType.Name; context.Entry(projectTypeToEdit).State = EntityState.Modified; context.SaveChanges(); return(projectTypeToEdit); // projectTypeRepository.Update(projectType); }
public void Save() { try { context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } }
public Activity Update(Activity dailyActivity) { Activity activityToEdit = context.Activity.Find(dailyActivity.Id); Project projectToEdit = context.Project.Find(dailyActivity.Project.ProjectId); ActivityType activityTypeToEdit = context.ActivityType.Find(dailyActivity.ActivityType.ActivityId); ProjectRoleType projectRoleToEdit = context.ProjectRoleType.Find(dailyActivity.CurrentProjectRoleType.RoleId); activityToEdit.Begining = dailyActivity.Begining; activityToEdit.HowManyHours = dailyActivity.HowManyHours; activityToEdit.description = dailyActivity.description; activityToEdit.ActivityType = activityTypeToEdit; activityToEdit.Project = projectToEdit; activityToEdit.CurrentProjectRoleType = projectRoleToEdit; activityToEdit.ApprovedByManager = dailyActivity.ApprovedByManager; context.Entry(activityToEdit).State = EntityState.Modified; context.SaveChanges(); return(activityToEdit); }
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 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 TimesheetAuthorizationProvider()) .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(); } }
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 TimesheetAuthorizationProvider()) .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(); } }