private void CreateHostRoleAndUsers() { //Admin role for host var adminRoleForHost = _context.Roles.FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin); if (adminRoleForHost == null) { adminRoleForHost = _context.Roles.Add(new Role { Name = StaticRoleNames.Host.Admin, DisplayName = StaticRoleNames.Host.Admin, IsStatic = true }); _context.SaveChanges(); //Grant all tenant permissions var permissions = PermissionFinder .GetAllPermissions(new CmsAuthorizationProvider()) .Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host)) .ToList(); foreach (var permission in permissions) { _context.Permissions.Add( new RolePermissionSetting { Name = permission.Name, IsGranted = true, RoleId = adminRoleForHost.Id }); } _context.SaveChanges(); } //Admin user for tenancy host var adminUserForHost = _context.Users.FirstOrDefault(u => u.TenantId == null && u.UserName == User.AdminUserName); if (adminUserForHost == null) { adminUserForHost = _context.Users.Add( new User { UserName = User.AdminUserName, Name = "System", Surname = "Administrator", EmailAddress = "*****@*****.**", IsEmailConfirmed = true, Password = new PasswordHasher().HashPassword(User.DefaultPassword) }); _context.SaveChanges(); _context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id)); _context.SaveChanges(); } }
public Country CreateCountry(string name) { Country country = new Country() { Name = name }; _CmsDbContext.Countries.Add(country); _CmsDbContext.SaveChanges(); return(country); }
public City CreateCity(City city, int countryId) { var name = _CmsDbContext.Countries .Include(cities => cities.Cities) .ThenInclude(people => people.People) .SingleOrDefault(countryid => countryid.Id == countryId); name.Cities.Add(city); _CmsDbContext.SaveChanges(); return(city); }
private void CreateRolesAndUsers() { //Admin role var adminRole = _context.Roles.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 }); _context.SaveChanges(); //Grant all permissions to admin role var permissions = PermissionFinder .GetAllPermissions(new CmsAuthorizationProvider()) .Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant)) .ToList(); foreach (var permission in permissions) { _context.Permissions.Add( new RolePermissionSetting { TenantId = _tenantId, Name = permission.Name, IsGranted = true, RoleId = adminRole.Id }); } _context.SaveChanges(); } //admin user var adminUser = _context.Users.FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == User.AdminUserName); if (adminUser == null) { adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**", "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 IActionResult FinishTask(int id) { var task = _context.TaskWork.Where(x => x.TaskWorkId == id).Single(); task.DateFinish = DateTime.Now; task.Status = Models.Status.Finish; _context.Update(task); _context.SaveChanges(); return(RedirectToAction("ListZayavka")); }
public int AddContact(ContactRequest contact) { Mapper.CreateMap <ContactRequest, Contact>(); Contact obj = Mapper.Map <ContactRequest, Contact>(contact); if (IsDuplicateData(obj)) { return(-1); } _db.Contacts.Add(obj); _db.SaveChanges(); return(obj.ContactId); }
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 void SaveArticle(Article article) { using (var dbContext = new CmsDbContext()) { var tags = new List <Tag>(); if (article.Tags != null) { foreach (var tag in article.Tags) { var existTag = dbContext.Tags.FirstOrDefault(t => t.Name == tag.Name); if (existTag != null) { existTag.Hits++; } tags.Add(existTag ?? tag); } } if (article.ID > 0) { article.TagString = string.Empty; dbContext.Update <Article>(article); dbContext.Entry(article).Collection(m => m.Tags).Load(); article.Tags = tags; dbContext.SaveChanges(); } else { article.Tags = tags; dbContext.Insert <Article>(article); } } }
public void DeleteArticle(List <int> ids) { using (var dbContext = new CmsDbContext()) { dbContext.Articles.Include("Tags").Where(u => ids.Contains(u.ID)).ToList().ForEach(a => { a.Tags.Clear(); dbContext.Articles.Remove(a); }); dbContext.SaveChanges(); } }
public void Create() { _context.DisableAllFilters(); new TestOrganizationUnitsBuilder(_context, _tenantId).Create(); _context.SaveChanges(); }
public void Create() { new DefaultEditionCreator(_context).Create(); new DefaultLanguagesCreator(_context).Create(); new HostRoleAndUserCreator(_context).Create(); new DefaultSettingsCreator(_context).Create(); _context.SaveChanges(); }
private OrganizationUnit CreateOU(string displayName, string code, long?parentId = null) { var ou = _context.OrganizationUnits.Add(new OrganizationUnit(_tenantId, displayName, parentId) { Code = code }); _context.SaveChanges(); return(ou); }
public ActionResult Create(Personnel model) { try { // TODO: Add insert logic here if (ModelState.IsValid) { _context.Personnels.Add(model); _context.SaveChanges(); } return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
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 Create(Filial model) { try { // TODO: Add insert logic here if (ModelState.IsValid) { ////65789908765 _context.Filials.Add(model); _context.SaveChanges(); } return(RedirectToAction(nameof(Index))); } catch { return(View("Error")); } }
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 TeacherRepository(CmsDbContext dbContext) { _dbContext = dbContext; if (_dbContext.Teachers.Count() <= 0) { _dbContext.Teachers.Add(new Teacher { Name = "Indrani", DepartmentId = 1 }); _dbContext.SaveChanges(); } }
public ActionResult EditSidebar(SidebarVm model) { SidebarDto dto = db.Sidebars.Find(1); dto.Body = model.Body; db.SaveChanges(); TempData["SuccessMessage"] = "You have edited this page!"; return(RedirectToAction("EditSidebar")); }
public Person CreatePersonWithoutCity(Person person) { if (person == null) { return(null); } Person newPerson = new Person() { Name = person.Name, Age = person.Age, }; if (newPerson != null) { _cmsDbContext.People.Add(newPerson); _cmsDbContext.SaveChanges(); return(newPerson); } return(null); }
private void CreateUserAndRoles() { //Default tenant var defaultTenant = _context.Tenants.FirstOrDefault(t => t.TenancyName == Tenant.DefaultTenantName); if (defaultTenant == null) { _context.Tenants.Add(new Tenant { TenancyName = Tenant.DefaultTenantName, Name = Tenant.DefaultTenantName }); _context.SaveChanges(); } }
public string AddNewCategory(string catNameValue) { var check = db.Categories.Any(x => x.Name == catNameValue); if (check) { return("titleTaken"); } CategoryDto dto = new CategoryDto(); dto.Name = catNameValue; dto.Slug = catNameValue.Replace(" ", "-"); dto.Sorting = 100; db.Categories.Add(dto); db.SaveChanges(); var id = dto.Id.ToString(); return(id); }
public ActionResult EditPage(PageVm model) { if (!ModelState.IsValid) { return(View(model)); } using (CmsDbContext db = new CmsDbContext()) { var slug = "Home"; int id = model.Id; PageDto dto = db.Pages.Find(id); dto.Title = model.Title; if (model.Slug != "Home") { if (string.IsNullOrWhiteSpace(model.Slug)) { slug = model.Title.Replace(" ", "-").ToLower(); } else { slug = model.Slug.Replace(" ", "-").ToLower(); } } if (db.Pages.Where(x => x.Id != id).Any(x => x.Title == model.Title) || db.Pages.Where(x => x.Id != id).Any(x => x.Slug == slug)) { ModelState.AddModelError("", "This slug or title already exist."); return(View(model)); } dto.Slug = slug; dto.Body = model.Body; dto.HasSideBar = model.HasSideBar; dto.Sorting = 100; if (db.SaveChanges() > 0) { TempData["SuccessMessage"] = "You have Edited this page!"; return(RedirectToAction("EditPage")); } } TempData["SuccessMessage"] = "There is an error while updating this page"; return(View(model)); }
public IActionResult ZayavkaItoAdd(TaskWork Task) { ViewBag.otdels = new SelectList(_context.Otdels, "OtdelId", "Name"); ViewBag.taskType = new SelectList(_context.TaskType, "TaskTypeId", "Name"); Task.DateAdd = DateTime.Now; Task.Otdel = _context.Otdels.Where(x => x.OtdelId == Task.Otdel.OtdelId).Single(); Task.TaskType = _context.TaskType.Where(x => x.TaskTypeId == Task.TaskType.TaskTypeId).Single(); //if (ModelState.IsValid) //{ Task.Status = Status.New; _context.TaskWork.Add(Task); _context.SaveChanges(); //} return(View()); }
private void CreateDefaultTenant() { //Default tenant var defaultTenant = _context.Tenants.FirstOrDefault(t => t.TenancyName == MultiTenancy.Tenant.DefaultTenantName); if (defaultTenant == null) { defaultTenant = new MultiTenancy.Tenant(MultiTenancy.Tenant.DefaultTenantName, MultiTenancy.Tenant.DefaultTenantName); var defaultEdition = _context.Editions.FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName); if (defaultEdition != null) { defaultTenant.EditionId = defaultEdition.Id; } _context.Tenants.Add(defaultTenant); _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(); } }
public ActionResult AddPage(PageVm pageVm) { using (CmsDbContext db = new CmsDbContext()) { string slug; PageDto pageDto = new PageDto(); pageDto.Title = pageVm.Title; if (!ModelState.IsValid) { return(View()); } if (string.IsNullOrWhiteSpace(pageVm.Slug)) { slug = pageVm.Title.Replace(" ", "-").ToLower(); } else { slug = pageVm.Slug.Replace(" ", "-").ToLower(); } if (db.Pages.Any(x => x.Title == pageVm.Title) || db.Pages.Any(x => x.Slug == slug)) { ModelState.AddModelError("", "The title already exist"); return(View()); } pageDto.Slug = slug; pageDto.Body = pageVm.Body; pageDto.HasSideBar = pageVm.HasSideBar; pageDto.Sorting = 100; db.Pages.Add(pageDto); db.SaveChanges(); TempData["SuccessMessage"] = "You have added a new Page"; return(RedirectToAction("AddPage")); } }
private void DeleteCustomer(Customer customer) { if (customer == null) { return; } var result = MessageBox.Show("削除すると元に戻せなくなりますが、宜しいですか?", "警告", MessageBoxButton.YesNo, MessageBoxImage.Warning); if (result != MessageBoxResult.Yes) { return; } using (var ctx = new CmsDbContext()) { var c = ctx.Customers.Find(customer.Id); ctx.Customers.Remove(c); ctx.SaveChanges(); } this.Customers.Remove(customer); }
private void CreateEditions() { var defaultEdition = _context.Editions.FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName); if (defaultEdition == null) { defaultEdition = new Edition { Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName }; _context.Editions.Add(defaultEdition); _context.SaveChanges(); //TODO: Add desired features to the standard edition, if wanted! } if (defaultEdition.Id > 0) { CreateFeatureIfNotExists(defaultEdition.Id, AppFeatures.ChatFeature, true); CreateFeatureIfNotExists(defaultEdition.Id, AppFeatures.TenantToTenantChatFeature, true); CreateFeatureIfNotExists(defaultEdition.Id, AppFeatures.TenantToHostChatFeature, true); } }
private void Save() { using (var ctx = new CmsDbContext()) { var customer = ctx.Customers.Find(_customer.Id); if (customer == null) { ctx.Customers.Add(_customer); } else { customer.Name = _customer.Name; customer.Furigana = _customer.Furigana; customer.ZipCode = _customer.ZipCode; customer.Address = _customer.Address; customer.Phone = _customer.Phone; customer.Memo = _customer.Memo; } ctx.SaveChanges(); } SetDialogResult(true); }
private void CreateHostRoleAndUsers() { //Admin role for host var adminRoleForHost = _context.Roles.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 }); _context.SaveChanges(); } //admin user for host var adminUserForHost = _context.Users.FirstOrDefault(u => u.TenantId == null && u.UserName == User.AdminUserName); if (adminUserForHost == null) { adminUserForHost = _context.Users.Add( new User { TenantId = null, UserName = User.AdminUserName, Name = "admin", Surname = "admin", EmailAddress = "*****@*****.**", IsEmailConfirmed = true, ShouldChangePasswordOnNextLogin = true, IsActive = true, Password = "******" //123qwe }); _context.SaveChanges(); //Assign Admin role to admin user _context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id)); _context.SaveChanges(); //Grant all permissions var permissions = PermissionFinder .GetAllPermissions(new AppAuthorizationProvider(true)) .Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host)) .ToList(); foreach (var permission in permissions) { _context.Permissions.Add( new RolePermissionSetting { TenantId = null, Name = permission.Name, IsGranted = true, RoleId = adminRoleForHost.Id }); } _context.SaveChanges(); //User account of admin user _context.UserAccounts.Add(new UserAccount { TenantId = null, UserId = adminUserForHost.Id, UserName = User.AdminUserName, EmailAddress = adminUserForHost.EmailAddress }); _context.SaveChanges(); } }