public void Handle(UserCreated e)
{
using (var db = new CoreDbContext())
{
db.Users.Add(new User
{
Id = e.Id,
CreatedDate = e.CreatedDate,
Deleted = false,
Phone = e.Phone,
Email = e.Email,
Username = e.Username,
TokenSession = string.Empty,
Password = e.Password,
Actived = false,
TokenSessionExpiredDate = EngineeCurrentContext.SystemMinDate
});
db.SaveChanges();
}
}
private bool SaveBillingInfo(int tenant, Tuple <int, DateTime> bi, bool renewal = true)
{
var inserted = false;
if (!Equals(bi, GetBillingInfo(tenant)))
{
using var tx = CoreDbContext.Database.BeginTransaction();
// last record is not the same
var count = CoreDbContext.Tariffs
.Count(r => r.Tenant == tenant && r.Tariff == bi.Item1 && r.Stamp == bi.Item2);
if (bi.Item2 == DateTime.MaxValue || renewal || count == 0)
{
var efTariff = new DbTariff
{
Tenant = tenant,
Tariff = bi.Item1,
Stamp = bi.Item2
};
CoreDbContext.Tariffs.Add(efTariff);
CoreDbContext.SaveChanges();
cache.Remove(GetTariffCacheKey(tenant));
inserted = true;
}
tx.Commit();
}
if (inserted)
{
var t = tenantService.GetTenant(tenant);
if (t != null)
{
// update tenant.LastModified to flush cache in documents
tenantService.SaveTenant(CoreSettings, t);
}
}
return(inserted);
}
public void Execute(AddMemberToConversationCommand command)
{
var member = _db.Users.Find(command.MemberId);
var conversation = _db.Conversations.Include(x => x.Members)
.SingleOrDefault(x => x.Id == command.ConversationId);
if (conversation == null)
{
throw new Exception("The conversation doesn't exist!");
}
if (conversation.Members.All(m => m.UserId != command.UserId))
{
throw new Exception("Brak uprawnień");
}
conversation.AddMember(member.Id);
_db.SaveChanges();
}
public void UpdateRightsForRole(Guid roleId, List <Guid> rightIds)
{
using (var db = new CoreDbContext())
{
var temp = db.RelationShips.Where(i => i.FromId == roleId).ToList();
db.RelationShips.RemoveRange(temp);
foreach (var rt in rightIds)
{
db.RelationShips.Add(new RelationShip()
{
FromId = roleId,
ToId = rt,
FromTableName = "Role",
ToTableName = "Right"
});
}
db.SaveChanges();
}
}
public void Handle(RelationShipAddedOneFromWithManyTo e)
{
using (var db = new CoreDbContext())
{
foreach (var toId in e.ToIds)
{
var temp = db.RelationShips.FirstOrDefault(i => i.FromId == e.FromId &&
i.ToId == toId);
if (temp == null)
{
temp = new RelationShip();
temp.FromId = e.FromId;
temp.ToId = toId;
temp.FromTableName = e.FromTableName;
temp.ToTableName = e.ToTableName;
temp.DisplayOrder = 0;
db.RelationShips.Add(temp);
}
}
db.SaveChanges();
}
}
public User Authenticate(string email, string password)
{
var user = context.Users.SingleOrDefault(x => x.Email == email && x.Password == password);
// return null if user not found
if (user == null)
{
return(null);
}
// authentication successful so generate jwt token
var tokenHandler = new JwtSecurityTokenHandler();
var key = Encoding.ASCII.GetBytes(appSettings.Secret);
var EmployeeClaimsIdentity = new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.Name, user.UserId.ToString()),
new Claim(ClaimTypes.Role, context.Roles.Include(x => x.Users).FirstOrDefault(x => x.Users.Any(y => y.UserId == user.UserId)).DisplayValue)
});
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.Name, user.UserId.ToString()),
new Claim(ClaimTypes.Role, context.Roles.Include(x => x.Users).FirstOrDefault(x => x.Users.Any(y => y.UserId == user.UserId)).DisplayValue)
}),
Expires = DateTime.UtcNow.AddDays(7),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
};
var token = tokenHandler.CreateToken(tokenDescriptor);
user.Token = tokenHandler.WriteToken(token);
context.SaveChanges();
return(user.WithoutPassword());
}
public void Handle(SendEmailToUser c)
{
var defaultFromEmail = SendGridHelper.DefaultFromEmail;
var tran = new UserMessageTransaction()
{
Id = c.MessageTransactionId,
Content = c.Content,
From = defaultFromEmail,
To = c.ToEmail,
ToName = c.ToName,
Subject = c.Subject,
Type = (short)Enums.UserMessageType.Email,
Status = (short)Enums.UserMessageTransactionStatus.Created,
ToUserId = c.UserId,
SendDate = c.SendDate,
CreatedDate = c.CreatedDate
};
using (var db = new CoreDbContext())
{
db.UserMessageTransactions.Add(tran);
db.SaveChanges();
}
}
/// <summary>
/// 添加菜单
/// </summary>
/// <param name="menu">menu.</param>
public bool Add(Menu menu)
{
_coreDbContext.Menu.Add(menu);
return(_coreDbContext.SaveChanges() > 0);
}
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 CoreAuthorizationProvider())
.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();
}
}
public bool Save()
{
return(_context.SaveChanges() >= 0);
}
public void Delete(Main entity)
{
context.Mains.Remove(entity);
context.SaveChanges();
}
//插入数据
public bool CreateUser(User_data user)
{
Context.user_data.Add(user);
return(Context.SaveChanges() > 0);
}
static void RegisterUrlRoutingAsRight(Assembly[] allAss)
{
foreach (var assembly in allAss)
{
var controllers = assembly.GetTypes()
.Where(type => typeof(Controller).IsAssignableFrom(type)).ToList();
if (controllers.Count == 0)
{
continue;
}
var listMethods =
controllers.SelectMany(
type => type.GetMethods(BindingFlags.Instance | BindingFlags.DeclaredOnly | BindingFlags.Public))
.Where(
m =>
!m.IsDefined(typeof(System.Web.Http.NonActionAttribute))
//&&!m.GetCustomAttributes(typeof(System.Runtime.CompilerServices.CompilerGeneratedAttribute),true).Any()
)
.Select(x => new
{
Controller = x.DeclaringType.Name.Replace("Controller", string.Empty),
Action = x.Name,
RightDescription = x.GetCustomAttributes().Where(i => i.GetType() == typeof(RightDescriptionAttribute))
.Select(rd => rd as RightDescriptionAttribute).Where(rd => rd != null).Select(rd => rd.Description).FirstOrDefault()
,
Area = x.DeclaringType.Namespace.Split('.').Reverse().Skip(1).First(),
ReturnType = x.ReturnType.FullName
})
.OrderBy(x => x.Controller).ThenBy(x => x.Action).ToList();
using (var db = new CoreDbContext())
{
foreach (var c in listMethods)
{
var rightName = $"/{c.Controller}/{c.Action}/";
var existed =
db.Rights.FirstOrDefault(
i => i.KeyName.Equals(rightName, StringComparison.OrdinalIgnoreCase));
if (existed == null)
{
var right = new Right()
{
Id = Guid.NewGuid(),
KeyName = rightName,
Title = rightName,
Type = 0,
ReturnType = c.ReturnType,
GroupName = c.Controller,
Description = c.RightDescription
};
db.Rights.Add(right);
var rs = db.RelationShips.FirstOrDefault(
i => i.FromId == EngineeCurrentContext.AdminRoleId && i.ToId == right.Id);
if (rs == null)
{
db.RelationShips.Add(new RelationShip()
{
FromId = EngineeCurrentContext.AdminRoleId,
ToId = right.Id,
DisplayOrder = 0,
FromTableName = "Role",
ToTableName = "Right"
});
}
}
else
{
if (string.IsNullOrEmpty(existed.Description))
{
existed.Description = c.RightDescription;
}
existed.GroupName = c.Controller;
}
}
db.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 CoreAuthorizationProvider())
.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 int SaveEvent(EventLog entity)
{
context.Entry(entity).State = Microsoft.EntityFrameworkCore.EntityState.Added;
context.SaveChanges();
return(entity.EventLogId);
}
public ActionResult TryCreate(string connectionString, string provider, bool drop = true)
{
var msg = "";
try
{
var factory = DbProviderFactories.GetFactory(provider);
var connection = factory.CreateConnection();
connection.ConnectionString = connectionString;
var recipe = provider.Equals("MySql.Data.MySqlClient", StringComparison.OrdinalIgnoreCase) ? "mysql" : "sql";
////Generate sqlscripts for debug
//var tmpPath = Server.MapPath("~/content/temp/sqlscripts/");
//if (!System.IO.Directory.Exists(tmpPath))
// System.IO.Directory.CreateDirectory(tmpPath);
//if (drop)
// Database.SetInitializer(new DropCreateDatabaseAlways<CoreDbContext>());
using (var dbContext = new CoreDbContext(connection, true)
{
Recipe = recipe
})
{
if (recipe == "mysql")
{
Database.SetInitializer(new CreateMySqlDatabaseIfNotExists <CoreDbContext>());
}
else
{
Database.SetInitializer(new CreateDatabaseIfNotExists <CoreDbContext>());
}
//#region for debug
//string script = ((System.Data.Entity.Infrastructure.IObjectContextAdapter)dbContext).ObjectContext.CreateDatabaseScript();
//System.IO.File.WriteAllText(tmpPath + DNA.Utility.TextUtility.Slug(provider).ToLower() + ".sql", script);
////System.Data.Entity.Migrations.DbMigrationsConfiguration
//#endregion
//dbContext.Database.CreateIfNotExists();
var count = dbContext.Webs.Count();
if (dbContext.Roles.Count(n => n.Name.Equals("administrators")) == 0)
{
dbContext.Roles.Add(new Role()
{
Name = "administrators", Description = "The system administrators"
});
}
if (dbContext.Roles.Count(n => n.Name.Equals("guests")) == 0)
{
dbContext.Roles.Add(new Role()
{
Name = "guests", Description = ""
});
}
dbContext.SaveChanges();
}
#region save configuration
var config = new XmlDocument();
string configPath = Server.MapPath("~/web.config");
config.Load(configPath);
var connectionStringsPath = "configuration/connectionStrings";
XmlNode connectionStringsNode = null;
connectionStringsNode = config.SelectSingleNode(connectionStringsPath);
var dnaCnnNode = connectionStringsNode.SelectSingleNode("add[@name='DNADB']");
if (dnaCnnNode == null)
{
dnaCnnNode = CreateConnectionNode(config, "DNADB", provider, connectionString);
connectionStringsNode.AppendChild(dnaCnnNode);
}
else
{
dnaCnnNode.Attributes["providerName"].Value = provider;
dnaCnnNode.Attributes["connectionString"].Value = connectionString;
}
config.Save(configPath);
var unityConfig = new XmlDocument();
string unityConfigPath = Server.MapPath("~/unity.config");
unityConfig.Load(unityConfigPath);
NameTable nt = new NameTable();
var nsmgr = new XmlNamespaceManager(nt);
nsmgr.AddNamespace("n", "http://schemas.microsoft.com/practices/2010/unity");
var rNode = unityConfig.SelectSingleNode("//n:container/n:register[@type=\"IDataContext\"]/n:constructor/n:param[@name=\"recipe\"]", nsmgr);
rNode.Attributes["value"].Value = recipe;
unityConfig.Save(unityConfigPath);
#endregion
}
catch (Exception e)
{
msg = e.Message;
if (e.InnerException != null)
{
msg += "\t\n" + "Detail:" + e.InnerException.Message;
}
return(Json(new { code = 500, error = string.IsNullOrEmpty(msg) ? null : msg }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = true, code = 200 }, JsonRequestBehavior.AllowGet));
}
public Comment AddComment(Comment comment)
{
_context.Comments.Add(comment);
_context.SaveChanges();
return(comment);
}
public Post AddPost(Post post)
{
_context.Posts.Add(post);
_context.SaveChanges();
return(post);
}
public static int SaveChanges_Auditable(this CoreDbContext context)
{
return(context.SaveChanges(AuditHelper.AutoSaveWithAuditEntryFactory(context.UserInfo?.PersonId.ToString())));
//return context.SaveChanges(AuditHelper.AutoSaveWithAuditEntryFactory(context.UserInfo.UserGUID));
}
public User AddUser(User user)
{
_context.Users.Add(user);
_context.SaveChanges();
return(user);
}
public Task <IdentityResult> CreateAsync(TRole role, CancellationToken cancellationToken, bool useTransaction = true)
{
_ctx.SaveChanges(role, useTransaction);
return(Task.FromResult(IdentityResult.Success));
}
public void Add(Product product)
{
context.Add(product);
context.SaveChanges();
}
void IUnitOfWork.Commit()
{
_dbContext.SaveChanges();
}
public void Commit()
{
_context.SaveChanges();
}
public void UpdateEmployeeRecord(Employee User)
{
__context.Employees.Update(User);
__context.SaveChanges();
}
public void Initialize()
{
var options = new DbContextOptionsBuilder <CoreDbContext>()
.UseInMemoryDatabase(databaseName: "TherapistEventDatabase")
.Options;
_testContext = new CoreDbContext(options);
_testContext.Database.EnsureDeleted();
_testUsers = new List <User>();
_testTherapistEvents = new List <TherapistEvent>();
_testTargetStartDateTime = new DateTime(2010, 2, 8);
_testTargetEndDateTime = new DateTime(2010, 2, 12);
for (var i = 0; i < 8; i++)
{
var newUser = ModelFakes.UserFake.Generate();
_testContext.Add(newUser);
_testContext.SaveChanges();
_testUsers.Add(ObjectExtensions.Copy(newUser));
Permission newPermission = new Permission
{
UserId = newUser.UserId,
Role = "therapist"
};
_testContext.Add(newPermission);
_testContext.SaveChanges();
var newTherapistEvent = ModelFakes.TherapistEventFake.Generate();
newTherapistEvent.TherapistId = newUser.UserId;
if (i <= 2)
{
newTherapistEvent.StartTime = _testTargetStartDateTime.AddDays(i);
newTherapistEvent.EndTime = _testTargetEndDateTime.AddDays(-1 * i);
}
_testContext.Add(newTherapistEvent);
_testContext.SaveChanges();
_testTherapistEvents.Add(ObjectExtensions.Copy(newTherapistEvent));
}
_testNonTherapistUser = ModelFakes.UserFake.Generate();
_testContext.Add(_testNonTherapistUser);
_testContext.SaveChanges();
_testUsers.Add(ObjectExtensions.Copy(_testNonTherapistUser));
var newEdgeTherapistEvent = ModelFakes.TherapistEventFake.Generate();
newEdgeTherapistEvent.TherapistId = _testUsers[0].UserId;
newEdgeTherapistEvent.StartTime = _testTargetStartDateTime.AddDays(-1);
_testContext.Add(newEdgeTherapistEvent);
_testContext.SaveChanges();
_testTherapistEvents.Add(ObjectExtensions.Copy(newEdgeTherapistEvent));
newEdgeTherapistEvent = ModelFakes.TherapistEventFake.Generate();
newEdgeTherapistEvent.TherapistId = _testUsers[0].UserId;
newEdgeTherapistEvent.EndTime = _testTargetEndDateTime.AddDays(1);
_testContext.Add(newEdgeTherapistEvent);
_testContext.SaveChanges();
_testTherapistEvents.Add(ObjectExtensions.Copy(newEdgeTherapistEvent));
_nonActiveTherapistEvent = ModelFakes.TherapistEventFake.Generate();
_nonActiveTherapistEvent.Active = false;
_nonActiveTherapistEvent.StartTime = _testTargetStartDateTime;
_nonActiveTherapistEvent.EndTime = _testTargetEndDateTime;
_testContext.Add(_nonActiveTherapistEvent);
_testContext.SaveChanges();
_testTherapistEvents.Add(ObjectExtensions.Copy(_nonActiveTherapistEvent));
_testTherapistEvent = new TherapistEvent
{
StartTime = DateTime.MinValue,
EndTime = DateTime.MaxValue,
TherapistId = _testUsers[0].UserId
};
_testTherapistEventService = new TherapistEventService(_testContext);
_testTherapistEventController = new TherapistEventController(_testTherapistEventService);
}
public Restaurant Add(Restaurant restaurant)
{
context.Add(restaurant);
context.SaveChanges();
return(restaurant);
}
//插入数据
public bool CreatePerson(person peo)
{
Context.Person.Add(peo);
return(Context.SaveChanges() > 0);
}
public Guid RegistrationInit(ProfileRegistrationModel model)
{
if (model == null)
{
throw new CustomArgumentException("Registration data is empty!");
}
// input validation
if (String.IsNullOrWhiteSpace(model.Email))
{
throw new CustomInputException("Email is empty!");
}
if (String.IsNullOrWhiteSpace(model.Password))
{
throw new CustomInputException("Password is empty!");
}
if (!model.IsPasswordMatch())
{
throw new CustomInputException("Password confirmation is not equal to Passowrd!");
}
// security policy
var securityPolicy = this.GetSecurityPolicy();
if (!securityPolicy.CheckStrength(model.Password))
{
throw new CustomInputException("Password does not match Security Policy!");
}
// change valid login
model.Login = model.GetValidLogin();
// check if user already exists with login
var persons = this.Persons
.Include(t => t.User)
.Where(p => p.User.Login.ToLower() == model.Login.ToLower())
.ToList();
if (persons.Any())
{
throw new CustomInputException($"Person with login {model.Login} is already exist!");
}
// create activity
var now = CommonService.Now;
var pin = CommonService.GeneratePin(10);
var activity = Activity.Create(now.AddHours(DEFAULT_ACTIVITY_EXPIRATION_HOURS), DEFAULT_ACTIVITY_TYPE_REGISTRATION, model, pin);
_dbContext.Set <Activity>().Add(activity);
_dbContext.SaveChanges();
// raise event to send email
DomainDispatcher.RaiseEvent(new RegistrationInitDomainEvent()
{
Email = model.Email,
NameFirst = model.NameFirst,
NameLast = model.NameLast,
Login = model.Login,
PIN = pin
});
return(activity.ID);
}
public virtual void Save()
{
_db.SaveChanges();
}
