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