protected override void OnEventResize(EventResizeArgs e)
{
var toBeResized = (from ev in db.Events where ev.id == Convert.ToInt32(e.Id) select ev).First();
toBeResized.eventstart = e.NewStart;
toBeResized.eventend = e.NewEnd;
db.SaveChanges();
Update();
}
protected override void OnEventClick(EventClickArgs e)
{
var userID = this.Controller.User.Identity.Name;
int id = int.Parse(e.Id);
try
{
var toBeResized = (from ev in db.Events where ev.id == id && ev.userID == userID select ev).First();
db.Events.Remove(toBeResized);
db.SaveChanges();
}
catch
{
}
Update();
}
public void Create()
{
new TestOrganizationUnitsBuilder(_context, _tenantId).Create();
new TestSubscriptionPaymentBuilder(_context, _tenantId).Create();
new TestEditionsBuilder(_context).Create();
_context.SaveChanges();
}
public void Create()
{
new DefaultEditionCreator(_context).Create();
new DefaultLanguagesCreator(_context).Create();
new HostRoleAndUserCreator(_context).Create();
new DefaultSettingsCreator(_context).Create();
new DefaultPersonCreateor(_context).Create();
_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();
}
private OrganizationUnit CreateOrganizationUnit(string displayName, string code, long?parentId = null)
{
var organizationUnit = _context.OrganizationUnits.Add(new OrganizationUnit(_tenantId, displayName, parentId)
{
Code = code
}).Entity;
_context.SaveChanges();
return(organizationUnit);
}
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 void Log(LogRecord record)
{
using (var db = new FrameworkDbContext())
{
// Add the record
db.Logs.Add(record);
// Save
db.SaveChanges();
}
}
private void CreateDefaultTenant()
{
//Default tenant
var defaultTenant = _context.Tenants.IgnoreQueryFilters().FirstOrDefault(t => t.TenancyName == MultiTenancy.Tenant.DefaultTenantName);
if (defaultTenant == null)
{
defaultTenant = new MultiTenancy.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 CreateEditions()
{
var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition == null)
{
defaultEdition = new SubscribableEdition {
Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName
};
_context.Editions.Add(defaultEdition);
_context.SaveChanges();
/* 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 long RunTest(string testName, List <DummyObject> pack, FrameworkDbContext db)
{
LogLine("");
LogTime(string.Format("{0} test started for {1} items.", testName, pack.Count));
Stopwatch stopwatch = Stopwatch.StartNew();
for (var i = 0; i < pack.Count; i++)
{
var p = pack[i];
db.Set <DummyObject>().Add(p);
db.SaveChanges();
}
var total = stopwatch.ElapsedMilliseconds;
long average = total / pack.Count;
LogLine(string.Format("\tAverage: {0} ms.", average));
return(average);
}
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();
}
//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,
ShouldChangePasswordOnNextLogin = false,
IsActive = true,
Password = "******" //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();
//User account of admin user
_context.UserAccounts.Add(new UserAccount
{
TenantId = null,
UserId = adminUserForHost.Id,
UserName = AbpUserBase.AdminUserName,
EmailAddress = adminUserForHost.EmailAddress
});
_context.SaveChanges();
//Notification subscriptions
_context.NotificationSubscriptions.Add(new NotificationSubscriptionInfo(SequentialGuidGenerator.Instance.Create(), null, adminUserForHost.Id, AppNotificationNames.NewTenantRegistered));
_context.NotificationSubscriptions.Add(new NotificationSubscriptionInfo(SequentialGuidGenerator.Instance.Create(), null, adminUserForHost.Id, AppNotificationNames.NewUserRegistered));
_context.SaveChanges();
}
}
public static long GetNext(
string sequenceName,
string param1 = null,
string param2 = null,
string param3 = null,
string param4 = null,
string param5 = null,
string usedFor = null
)
{
using (var db = new FrameworkDbContext())
{
var seq = Cache.GetOrAdd(sequenceName, (seqName) =>
{
var s = db.Set <EntitySequence>().FirstOrDefault(es => es.Name == seqName);
//if (s == null)
//{
// var temp = db.Set<EntitySequence>().Create();
// temp.Name = seqName;
// temp.Description = $"Automatically created for: {usedFor}";
// db.SaveChanges();
//}
return(s);
});
if (seq == null)
{
throw new Exception($"Sequence is not defined: {sequenceName}");
}
var sameSequenceItems = db.Set <EntitySequenceItem>()
.Where(si =>
si.Param1 == param1 &&
si.Param2 == param2 &&
si.Param3 == param3 &&
si.Param4 == param4 &&
si.Param5 == param5);
var maxValue =
sameSequenceItems.Any() ?
sameSequenceItems.Max(si => si.SeqValue) :
0;
var esi = new EntitySequenceItem(true)
{
SeqValue = maxValue + 1,
EntitySequenceId = seq.Id,
CreationDateTime = DateTime.Now,
Param1 = param1,
Param2 = param2,
Param3 = param3,
Param4 = param4,
Param5 = param5,
UsedFor = usedFor
};
db.Set <EntitySequenceItem>().Add(esi);
db.SaveChanges();
return(esi.SeqValue);
}
}
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();
}
//User role
var userRole = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.User);
if (userRole == null)
{
_context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.User, StaticRoleNames.Tenants.User)
{
IsStatic = true, IsDefault = true
});
_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.ShouldChangePasswordOnNextLogin = false;
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();
//User account of admin user
if (_tenantId == 1)
{
_context.UserAccounts.Add(new UserAccount
{
TenantId = _tenantId,
UserId = adminUser.Id,
UserName = AbpUserBase.AdminUserName,
EmailAddress = adminUser.EmailAddress
});
_context.SaveChanges();
}
//Notification subscription
_context.NotificationSubscriptions.Add(new NotificationSubscriptionInfo(SequentialGuidGenerator.Instance.Create(), _tenantId, adminUser.Id, AppNotificationNames.NewUserRegistered));
_context.SaveChanges();
}
}
